Ratq Science & Tech

Exploring the value of science & technology to make a positive difference. #TechAndLead

[ratqsciencentech]

Student Safety Survey

Please fill up this form 

Loading…

[ratqsciencentech]

The Benefits of Anonymous  Reporting :

To rightly implement a violence reporting tool , it is very much required  to add a feature  of anonymous reporting. As we are currently working on smart reporting tool  for school safety we tried to asses current reporting mechanism in schools.

We realized people are reluctant to report even the critical issues due to the fear of getting exposed and it’s related consequences.

For example in school safety system,teachers and staffs are reluctant to report safety related issues as they fear of losing job. Parents and Students have the same fear of getting rusticated from the school. 

Anonymous reporting is a great mechanism to mitigate that fear of getting exposed. 

However it will be inappropriate to charge someone on the basis of anonymous reporting.

Here is some guidelines to use  anonymous reporting constructively :

Concerned authorities can take a step forward  to verify an anonymous report depending on the following criteria:

The details of the report : If the report is very much detailed containing all the details  like the exact time,location etc the concerned authority should give attention.

Visual Report : If the report is a self explanatory  photo or video then it deserves attention.(AI has a big opportunity to verify a visual report)

Severity of Issue :  If the reported fact or incident is severe one then also authority should take prompt action to validate and verify.

Frequency of Issue : If  similar type of complains are coming for a same person or a section of work then definitely authority should validate and verify.

A very productive way to validate or verify an anonymous report is to conduct a survey on the related issue or area of impact.

Take a look on our initial demo on anonymous reporting for safe school.

[ratqsciencentech]

Learn Tumblr Tips & Tricks

Tumblr is place to connect to like minded people through your interest and passions.You can not not only set up your personal blog but can also set up business website using tumblr.

We have launched some tutorial videos on tumblr  tips & tricks through our YouTube channel.

Tips & Tricks are as follows:

Resolve  non-https error

Suppress the Tumblr Control Button from home page.

Backup your tumblr blog.

Resolve SCM music player problem in tumblr.

Below is the link of playlist

[ratqsciencentech]

Nervousness in MRP

Bill of Material- Low-level Code

We are going to make two parent parts product A and product L. So, they are level 0. Product A is made from product B and C whereas, product L is made of product D and F.

Now how does MRP calculate? It’s going to calculate the level 0 parent parts. It calculates the requirement of product A, then product L. Then it’s going to calculate product B, C, and F. why is D tucked down at the bottom? That’s because of something called low-level code. Low-level code is the lowest level where that part exists in that bill of material.

So that’s why even though it at level 1 of parent product L, it actually sits at level code 2. So, MRP is going to get together all the requirements at the higher levels and then it’s going to calculate the requirement of D.

 Nervousness

Any input change ripples through any involved BOM or product structure. This is something is called nervousness.

It’s defined as The characteristic of an MRP system when minor changes in higher level (e.g. level 0 or 1) records or the master production schedule cause significant timing or quantity changes in lower level (e.g. 5 or 6) schedules or orders.

It looks like this: I have a change in the material at the topmost level i.e. FPA, it ripples all the way down through the Bill of the material of FPA.  

Let’s say, for example, to produce 1 unit of FPA, I need 1 unit of ICA and SAA each. Now to produce 1 unit of ICA, I need 5 KGs of SAB and to produce 1 KG of SAB I need 20 KG of PPB. So effectively if the master production schedule of FPA is 100 Units, I need 10000 KGs of PPB. If there is a minor change - let’s say if I change the master production schedule of FPA from 100 to 110 units, I will fall short by 1000 KGs for material PPB.

Similarly, rescheduling the MPS, in general, leads to replanning activities on low-level items. Because of lot-sizing, even minor time-phasing changes on the MPS level may lead to major rescheduling actions on lower stages. In particular, changes in lot sizes on the MPS level may cause rescheduling of released orders at lower levels.

Now it also affects any shared component. Let’s say if SAB or SAG are shared component items, then it really does impact other product structures as well.              

[ratqsciencentech]

Holi Offers  on Udemy Courses: ₹ 640 only

We are glad to announce that you will get our #udemy courses on SAPS4HANA on a discounted price of Rs 640 only.

We have the following two live courses on udemy:

Learn SAP S/4HANA Migration Cockpit from Scratch

Use code HOLIDMC 

Discover Demand-Driven Replenishment (DDMRP) in SAP S/4 HANA 

Use code HOLIDDMRP

 Happy Holi !!! Color yourself with ERP inventions...

[ratqsciencentech]

Learn Demand Driven Material Requirements Planning (DDMRP)  for SAP from Udemy

Demand Driven Material Requirements Planning (DDMRP)  for SAP is a revolution to the supply chain planning and execution.

DDMRP is considered as the greatest innovation in the supply chain which to reshape the manufacturing industry in the next twenty years.

The digitalization of the industry will generate considerable improvements in productivity and speed to market for both new and existing product offerings. However, will this revolution in industrial integration really deliver to its full potential and convert these productivity gains into real top and bottom-line returns?

For every business, the vital elements necessary to ensure that the supply chain is focused on delivering·         

the right products·        

 to the right places·         

at the right time.

This vital element is the use of the Demand Driven Operating Model and the related planning methodology Demand Driven MRP (DDMRP). This is currently the only approach that allows to effectively synchronize supply and demand across complex and volatile supply networks.

 We see a shift from the traditional Forecast-MPS-MRP drove world to a Demand-Driven-Pull world as a necessary condition to capitalize on the productivity improvements that will be generated by the digitalization of the industry.

So, it’s imperative that we learn and understand this key concept because when DDMRP is combined with the automation and productivity improvements promised by Industry 4.0 concepts, then a truly transformational change in top and bottom-line business performance is within reach.

So we have launched a course on Udemy :

Discover Demand-Driven Replenishment (DDMRP) in SAP S/4 HANA

In this course you will learn :

Classical Material Requirement Planning and it’s legacy.

Why  DDMRP was conceived. 

How it overcomes the conventional MRP shortfalls.

How to implement it.

This is the only DDMRP course available on Udemy. So request you to subscribe to our new course to stay ahead in the industry.

Please have a look at the course overview.

[ratqsciencentech]

Blockchain in Relief Fund : Where trust matters most

In the case of natural calamities, instant funding is required to get recovered from the mass casualties.

For notified natural calamities, the State Government of India is required to submit a detailed memorandum indicating the sector-wise details of damage and requirement of funds for relief operations of immediate nature. 

Trust and transparency are the most required parameters in case of the relief fund. Donors must have the power to decide on which sector they want to donate for.

A Blockchain based relief fund network can enable instant and efficient funding system.  Donors across the world can pay through their blockchain wallet and money will be transferred instantly.

Through Blockchain, relief organizations can display both the required fund for each sector and accumulated fund to date. 

It will not only make the relief fund more transparent and trustworthy but also empower donors to take the decision about their payment.

Each donor can check how much fund is accumulated for each sector and pay accordingly.

All organizations can take part in a single network to work together to accumulate the fund and disburse it.

All transaction records can be stored in a distributed and decentralized network to make it more immutable.

Different parties can apply privacy so that data related to their transactions won't be exposed to everyone. 

The commonly agreed rules can be implemented by a smart contract to ensure the execution of the rules. 

A simple demo on blockchain based donation on relief fund :

Source and Reference: 

http://www.arthapedia.in/index.php?title=Disaster_funding_arrangements_in_India

https://www.digitalistmag.com/improving-lives/2017/11/23/blockchain-for-disaster-relief-creating-trust-where-it-matters-most-05527536

 Read Full Paper

[ratqsciencentech]

QR Business Card :#NoMorePrintedCards

When you are carrying business cards then you can afford to carry a smartphone or an iPhone too. Yes, most of us can easily afford. So why do you still need those printed business cards? 

There is an easy way to generate the QR code for business card details. You can just carry this image of the QR code in your phone. Anyone having a smartphone or iPhone can easily scan it and save all the details to there contacts.  Eventually, all the details will be saved to related clouds. Make sure the required settings for cloud backups are on.

In that way, we can save a lot of papers, protect the environment. Be smart enough to use your smartphone effectively.

You can easily generate a QR code for your business card.  Here is a demo on how you can generate the QR code and how to scan it to save the details in your contacts.

Some free sites to generate your QR codes are:

https://www.qr-code-generator.com/

https://barcode.tec-it.com/en/QRCode

[ratqsciencentech]

Blockchain for School Safety: #SafeSchool

A safe learning environment is the basic need of every child. If a child feels unsafe in school, he or she may lose the eagerness to learn new things or may stop showing up.

All the stakeholders of the school should jointly create an environment of safety and in school.

We are very glad to announce that we are starting an open source project SafeSchool.

This is a research and experimental development based project on how a blockchain based app can be used for school safety.

The idea is to develop an app through which all the stakeholders(parents, staff, teacher, student etc) can report any issue or incident related to safety.

That’s how we can safeguard our next generation in schools and encourage them to learn and explore fearlessly.

A  block-chain based tamperproof digital instant reporting system with the feature of anonymously reporting of any issues can be a great step to make schools safer. 

Anyone interested can join our project.

We especially need android and blockchain developers.

So contact us if you are interested to get involved in our project.

We have just started with conceptualization. Regular updates will be shared,

SafeSchool Wiki 

[ratqsciencentech]

Learn SAP S/4HANA Migration Cockpit from Scratch

S/4HANA Migration Cockpit is a web-based data migration tool to migrate Legacy Data into S/4HANA.

It provides downloadable predefined Excel Sheet-Templates so that you can “easily” extract legacy data into this format and upload in S/4HANA. Basic Mapping Functionalities are provided. You can customize it to meet your requirements.

To help you learn in details we have launched a course on Udemy:

Learn SAP S/4HANA Migration Cockpit from Scratch

Have a brief overview of this course:

In this course, you will learn:

SAP S/4 HANA Migration Cockpit with Step by step transactions and detailed configuration.

How to upload master and transactional data using S/4 HANA migration cockpit.

Explore the limitations of the standard migration objects and how to overcome them.

How to create a custom migration object, use of custom rules and error handling.

How to use recordings in migration objects.

Troubleshooting of real-time problems faced during implementation.

[ratqsciencentech]

Tutorials on Excel

An excel can be your customer database, your invoice template.

You can add a button in excel. You can generate image or PDF by clicking on the button. Many more things to do with excel.

Check our latest videos on excel in youtube:

[ratqsciencentech]

Excel Based Invoice-Automation

Are you a small business owner? Struggling to track orders and automate invoice generation for each ordered item? 

 An Excel-based invoice generation system can really make your job easy especially if your business belongs to the retail industry.

Using this excel based invoice generation system, you can do generate an invoice in pdf format for each ordered item by a customer. 

It has also the facility of tracking customer-order database. Searching for orders by a particular customer.

You can download it by clicking on the download icon below.

Check demo on Youtube:

[ratqsciencentech]

Excel Based 2-D Bar-code Generation

A Quick Response code, or QR code, is the next generation of barcodes.

Those little-jumbled squares were originally designed to track cars through the manufacturing process, but today, quick response codes can be found everywhere-on magazine advert, on a billboard, a web page or even on someone’s t-shirt.

The reason why they are more useful than a standard barcode is that they can store (and digitally present) much more data, including URL links, geo coordinates, and text. The other key feature of QR Codes is that instead of requiring a chunky hand-held scanner to scan them, many modern cell phones can scan them.

Another useful example of the 2D barcode is  Data Matrix barcode made up of black and white modules arranged in a compact square pattern. Datamatrix symbol can store an impressive 2,335 alphanumeric characters, which could include manufacturer ID, a unique serial number and lots more.

There are lots of benefits from 2D codes;

The most important of which is their ability to pack lots of data into a small space — for more than a linear 1D barcode. 

Whereas all the information in 1D codes can be found in one cut through the code, 2D codes contain many different lines of data.

 2D Barcodes can now be read by smartphone apps too. 

RST developed an excel based QR and Data Matrix Bar-code generator.

You can download the excel from below download link.

You can also copy the VBA macro if you want to customize it.

Please check the demo in Youtube

[ratqsciencentech]

Combine Multiple Workbooks into a Single One

When you are working in a team, it happens a lot of times that you need to merge workbooks of different team members into a single one.

You can always use this macro to do this job in a few minutes. The macro will also delete empty sheets.

Copy the VBA Code and create a macro. 

Create a ribbon to execute that macro.

Click on the ribbon and file selector dialog box will open.

You can select multiple excel files(.xls/.xlsx) to merge 

Click on download the excel template with macro and ribbon.

Check the demo below:

[ratqsciencentech]

Smart Recycling by Plastic Bank. Powered by IBM blockchain technology.

[ratqsciencentech]

Plastic Bank:Can be Revolutionary To Our Eco System?

Plastic is a real threat to the ocean environment, coastal regions, and sea life. The problem has greatly accelerated within the past few decades as the amount of plastic in the oceans continues to grow. But what if a piece of plastic was worth the right price? The result is the elimination of plastic litter, and the scavenged plastic can be exchanged for other goods.

 In developing countries, about 80 percent of plastic refuse comes from areas with high levels of poverty and no effective waste management systems. The founders of Plastic Bank are creating recycling systems in those areas. Stabilizing the reward for plastic at a fair price was often the tipping point, creating a dependable recycling activity that gives collectors a sense of pride.

 In addition, many people in developing countries lack bank accounts, and dealing in cash can be dangerous for them because of corruption and crime. But almost everyone—even in disadvantaged areas—has a mobile phone that supports digital transactions.

 Plastic Bank realized that to take this venture digital, it needs more expertise, so The Plastic Bank began working with IBM and IBM customer Cognition Foundry on a solution employing block-chain technology.

[ratqsciencentech]

Convert VBScript to EXE

You can easily convert VBScript to EXE file using VbsEdit tool. VbsEdit is one of the best VBScript editor, available free.

Check the Demo Below :