Go Down

Topic: Sorting by light (Read 2270 times) previous topic - next topic

Nagaro

Mar 27, 2018, 07:33 pm Last Edit: Mar 28, 2018, 08:07 pm by Nagaro
Hi,

I'm new in this forum, also using an arduino, but i can see the potential of it. And i'm getting really excited :-)

I would like to build a tool for my work, to improve our productivity.
Basically, we need to put some items back to stock, and to do so we need to sort them.
On each item is a barcode (to identify it), and each item has a specific location where it needs to go.

Currently, we do it « manually » : we scan an item with excel, it shows us the box number where it belongs, we find the box and we put it inside.

I would like to have the see the box where it belongs directly, without having to look for it all the time.
My idea is to scan each item, and a light will switch on over the corresponding box where to put it.
I would like to build it with excel/vba, as all data of items and boxes are in there, and then use an arduino to get the info from excel and switch on the correct light.
I will need about 40-50 lights, to switch on one by one (never more than 1 at a time).

Do you know how i could do this ?
I could see a lot of idea on the different forums, but didn't manage to find the right one.

Thank you very much for your help,

Frédéric

TolpuddleSartre

Quote
I will need about 40-50 lights, to switch on one by one (never more than 1 at a time).

Do you know how i could do this ?
Charlieplexing

(I don't know what the title of this topic means)

PaulRB

Charlieplexing, I agree, is one idea. 8 Arduino pins can light one of 56 LEDs. Cat5 cable, which contains 8 cores, could be used to wire the leds.

Another option would be ws2812b or similar "neopixels". More expensive, but less work for you and only 3 core wire needed.

A standard Nano 3 should be adequate.

Grumpy_Mike

(I don't know what the title of this topic means)
My guess is it should say "Sorting by light" if the OP's native language was English.

dougp

Sounds like a pick-to-light application.  Only this would be 'put' to light.
Everything we call real is made of things that cannot be regarded as real.  If quantum mechanics hasn't profoundly shocked you, you haven't understood it yet. - Niels Bohr

No private consultations undertaken!

Nagaro

Hi,

You're right, « sorting » sounds better than « sortation ». I'm french, so English is not my best :-)

I've checked on internet, and found a few videos about both concepts.
I'll check how i can adapt it for my purpose.

But i've seen that i need to use a specific program to use the led's, when i would need to control them via excel and vba.
Will that be possible ? And if yes, would you have some tipps ?

Thank you again for your support,

Grumpy_Mike

#6
Mar 28, 2018, 11:11 pm Last Edit: Mar 28, 2018, 11:11 pm by Grumpy_Mike
Quote
You're right, « sorting » sounds better than « sortation ». I'm french, so English is not my best :-)
well your English is better than my French  ;)

I would agree with Paul in reply #2, use a WS2812b strip, you can get individual ones on small PCBs. Then all you need is to pass that number to the Arduino and have it light up just that LED number.

PaulRB

#7
Mar 28, 2018, 11:29 pm Last Edit: Mar 28, 2018, 11:43 pm by PaulRB
For a vba script running in an excel sheet to communicate with the Arduino, the script must be able to send or print characters to a serial port. It must also be able to identify which serial port the Arduino is connected to. This could perhaps be done by the user entering or selecting the port in a drop-down menu or simply by entering its name in a cell on the spreadsheet. There is no guarantee that the Arduino will always appear as the same com port each time it is plugged in.

Grumpy_Mike

Have you seen this project?
finding books with laser beam
I know the light isn't what you want but the looking up position part is half your project.

Nagaro

Hi,

Yes, the idea of the laser to look for books is the same than the led's to light to put items in box.
Unfortunately, i didn't find any code in there, on how to transfer the data from the computer to the Arduino.
I'll need to look more, to find some help on it.

I'll continue to post on this forum to update you on my researches

Grumpy_Mike

So why did you not put a comment on the blog post asking where the code could be found?

Nagaro

#11
Mar 30, 2018, 04:32 pm Last Edit: Mar 30, 2018, 06:25 pm by Nagaro
I didn't think about it. Ahah :-)
But now i put a comment to ask for the code. Let's see what they will answer.

Thanks again for the tipp.

jremington

#12
Mar 31, 2018, 05:21 pm Last Edit: Mar 31, 2018, 05:22 pm by jremington
If there are only 40-50 items, this is something an Arduino could do by itself (no need for a PC running Excel).

You can buy Arduino-compatible bar code readers, and have one or more bar codes light up one LED.

Nagaro

Hi,
That's really good to know.
It would actually be a list of about 7000 barcodes, to light up those 40-50 led's (several barcodes can light the same light).
Would that be something that the arduino could manage without excel ?
Because then, i would transfer the data once a day for example, to upload the list in the arduino. It would be a easy table, with 3 columns : one for the barcode, one for the light to switch on.

I started to received the pieces to build the arduino with the lights

Grumpy_Mike

Quote
Would that be something that the arduino could manage without excel ?
Only if you add some place to store the data like an SD card.

Go Up