I need help with sorting and categorizing barcodes (recycle project)

[iwirgens]

Hello!


For a school project, we are going to make a machine that will register bottles recycled, and give a prize to random recyclers. We have got a solution that can scan barcodes and paste them into excel in a vertical row. Every student also has a id-card with a barcode on. What we need help with, is to create a script that can do this:

1: When the ID-card is scanned, it needs to make a "category", or some other way to organize different pupils (so we can pick winner).

2: Then when bottles and cans are scanned, the codes need to be "connected" or organized under or together with the student id-code, and it would be nice to have a counter to see how many bottles each student has deposited. And maybe a "total bottles" counter as well?

3: Then it has to "reset" for a new student to be able to scan his/her card and deposit their bottles.

An example for the code on a bottle is "7038010043888", and an id card is: "5427771". Im guessing it should be possible to sort them based on length? I think all id-cards and bottles have the same length of 13 and 7 digits.

If anyone wants to either help make this, or completely create it would help us a lot.

Thank you so much, any help is appreciated.
Both we and the environment thanks you

 

[NdNoviceHlp]

Hi iwergens and Welcome to the Board. Seems like a worthwhile project. "a solution that can scan barcodes and paste them into excel in a vertical row" I'm assuming that a vertical row in XL speak is a column? Do U want to retain a record of all bottles recycles or just their total numbers. Are U able to scan the student barcode to XL? Do U want a userform for user interface ie. enter/select student; display barcodes of current entry, display total barcodes entered, a random student selection button, and maybe display all barcodes entered for the student? Maybe a bit more info. Dave

 

[iwirgens]

Yes i mean a column. The app I’m using is called “scan it to office” which scans the code and enters it into the selected cell, then the next will appear under it. An interface would be awesome.
This is supposed to be a machine standing in a hallway with like a raspberry pi and a barcode scanner, the app is just for prototyping before we can get a real scanner. It would be sweet if each student could see how many bottles they’ve deposited when they scan the card, and maybe a total bottle counter? Thanks for the reply

 

[NdNoviceHlp]

I've spent some time on this and am almost ready for the beta test. I will private message U. Dave