84Views9Replies

Author Options:

How do i build a device to allow an input and it give a designated output (1015469=input and B2-1= output)? Answered

I work in a warehouse as a forklift operator.  I deal with looking at a number on a container, then have to look up the number by going through several pages to find the corresponding isle and row to place the container.  EX. ( Container has 1015469 on it.  I have to find that number on a sheet then it will tell me to go to B2.  Once I get to B2 I have to find that number on another sheet of paper that has the isles and rows so it can tell me if it goes in B2 section 1 for route 20 or in B2 section 2 for route 21.  I need to make a device with large enough memory to hold several thousand 7 digit numbers and have each number reference me to the correct destination such as B2-1 or B2-2.  I really need some help with this.  I have basic electronics experience and a small amount of visual basics experience.  I need this device asap to increase my productivity at work so I can step up my performance so as not to loose my job.  The device just needs a simple 10 digit keypad to enter the numbers then an enter button and a clear button to be able to enter the next number.  It would be even better if I could enter several numbers at once, maybe spaced by a comma, and get several output locations since sometimes I move several containers at once and each goes to a different location.  Then I could figure the most effecient route in the warehouse.  Any help with this would be highly appreciated.  Thank you in advance for any help or advice you can give.

Ps. It also needs to be easily updated as the numbers in the database will be frequently changed and updated.

Discussions

0
None
steveastrouk

7 years ago

Any modern smart phone would do this easily. The biggest problem is getting the lists into the device. And what happens when your company changes the stock around ?

0
None
J.Reynolds09steveastrouk

Answer 7 years ago

I don't own a smart phone, and I was hoping to build it where it could be mounted to my forklift and then updated with a flash drive. I can get the spreadsheet files they use to print the sheets and update my files then just move the information over to the device with a flash/thumb drive. I was wondering if an arduino could handle this for me

0
None
steveastroukJ.Reynolds09

Answer 7 years ago

By the time you've messed around, you'd be as well off buying a notepad PC that someone doesn't want anymore for a few bucks. The software would be dead easy. I can't believe your company are so dumb they haven't already automated it for you !

0
None
J.Reynolds09steveastrouk

Answer 7 years ago

what would i need for the software end of using the notepad PC and will the battery last for 8 hours of constant use? The temp service that placed me with the company said they used scanners but once again that was yet another lie the temp service has told. I thought it was dumb to but it is what it is and I need a better method for doing my job. I think it's pretty inefficient to do it the way they are but you all know how cheap large corporations can be!

0
None
J.Reynolds09J.Reynolds09

Answer 7 years ago

It also has to be small and able to mount to the forklift without obstruction of view or in the way of my controls. All the notebooks I see are laptop style and that just wont work. I need something handheld size like a chunky calculator size.
Come on guys, I know one of you has a great suggestion. I know the company sucks for not having this covered but I can't help that. I need a solution quickly that I can build in the next few days under $80 otherwise I'm next on the chopping block!

0
None
steveastroukJ.Reynolds09

Answer 7 years ago

You need a cheap tablet then. Check on Ebay, there should be something there in your budget, then you just need a free viewer for spreadsheet files.

0
None
astroboy907J.Reynolds09

Answer 7 years ago

maybe a cheap android tablet with an XML (I assume thats what you are using for spreadsheets) application the allows you to search spreadsheets for the right numbers? IDK what you are using or how many spreadsheets you have...

0
None
J.Reynolds09J.Reynolds09

Answer 7 years ago

could a palm pilot be programmed to handle this task and if so where would I get a program to do the coding
?