jcwelch111
New Member
- Joined
- May 20, 2013
- Messages
- 2
We have several punching machines in a manufacturing facitity that each have several punch units on them. I want to enable operators to scan the punch units and the unit be found in the spreadsheet, be prompted to enter a quantity, and have that data sent to the Excel spreadsheet to populate that cell. I have searched the web some and found the Motorola MT2000 series looks to be just what we need as far as capability and cost (not too much and not too little). The MT2000 has Microsoft .NET framework and MCL Client from what I've read, though I don't have any experience with these. I do have a little experience with writing programs in VBA. How hard would it be to setup this device (or any other you may suggest) to work for this application. I need it to:
b) the next unpopulated cell below will be ready for subsequent quantities to be entered
Below is a rough idea of the spreadsheet layout options.
<tbody>
</tbody>
<tbody>
</tbody>Any help is greatly appreciated. Thanks in advance!
- operator scans the barcode on the unit and the scanner sends that data to the spreadsheet where the corresponding unit ID is located, and the cell for the quantity alongside said ID is ready for population
- Scan gun prompts operator for quantity, which when entered is sent and populates quantity field in spreadsheet
- consecutive scans of the same unit will either
b) the next unpopulated cell below will be ready for subsequent quantities to be entered
Below is a rough idea of the spreadsheet layout options.
Tool ID # | Unit Type | # Punches |
123456 | PU-25 | xxxxxxxx |
<tbody>
</tbody>
Tool ID # | 123456 |
Unit Type | PU-25 |
# Punches | xxxxxx |
xxxxxx | |
xxxxxx | |
xxxxxx | |
xxxxxx | |
xxxxxx | |
<tbody>
</tbody>