Hi i want expert opinion and help regarding my project the details are as following.
- Source Excel File containing following information
a) Product b) Batch C) Quantity - Arduino read source file and store 3 parameters in memory
- Now process should start like this:
• Stock is placed one by one on conveyor (controlled by Arduino)
• Each item is placed on conveyor , system should check batch number and product description with QR code reader (stickers already placed on every product)
• At this point our core requirement is that system should check the stored information within its memory and compare this information with digital or analog signals receiving through QR code reader if the information matches with imported excel file then every thing is ok but if there is a mismatch system should stop and alert via buzzer or light as the case may be and restart only if correct item is placed on Conveyor and system allows to pass through the sensor.
• Finally System should be able to present the results on excel sheet with same format i.e.
a) Product b) Batch C) Quantity for total items passed through sensor (barcode scanner)
this project is based on concept for distribution ware house management where i want to check whether inventory or stock drawn by employees is same as per report generated by system. (source file)