This video is amazing and well thought out. This information can help a lot of businesses. If you have never heard about “Kanban” you would never find this great video. Maybe add “barcodes for dummies” or “barcode 101” in the video title so people can find it better on RUclips. Keep up the great work.
Paul... Lukas is a keeper! I just got a scanner and I am like huh??? I learned a few things on my own. But I learned so much more thanks to him! Thanks Lukas!!!
2 second improvement - keep the scanner always on and in a fixed position next to the laptop on the forklift so that one does not have to constantly pick up the scanner. Easily shave off five seconds per scan.
Thank you for this gift, really informative video. I tried doing the tab and carriage return but it wasn't working... I finally figured out that my scanner does not have the ability to read ascii. I ordered a scanner with the ability to read ascii and it works just like you demonstrated in this video. Also, I figured out that you can create a single barcode that will scan in the part#, tab, scan in quantity, carriage return... So you only have to dink a Kanban card once, a downside is that the barcode will be longer. So for part# Elbow with a quantity of 25 you'd input this: (asterisk)Elbow$I25$M(asterisk) Thank you again Lukas and Paul.
This guy needs a raise!!!! Awesome job, you have no idea how much this has helped me and my project. So fantastic that you shared your knowledge with us! Good lookin' warehouse too btw!
You saved my day, thank you! My team has to fill out a Excel to get some KPI's that we can't get out of SAP. Now i designed a Form in Excel and a Makro to fill the Data it in a Table and reset the Form after this. With your Barcode Tipps i created a A3 Sheet with Barcodes where you can take the right data and hop in the next box. - Saving a lot of Time (75-85%) of my Team - Saving my Time (90%) (The Only thing i have to do now is open the Excle und hit the KPI Dashboard, no Checking of Data, no adjustments on the Pivot. Before this i had to proof all Data for wrong Entrys) - No Mistakes Possible (Created Rules in the Boxes, you cant put a Number in a Checkbox where you need do fill in witch kind of Drum it is) Have a great day :)
Lukas, Paul great video, we’ve used barcodes for a few years now, but the tips you’ve just shown for tabbing and entering automatically have just revolutionised our stock entry process (or at least it will do as soon as I get in to work this morning!)
Scanners are Honeywell 1900 GHD-2. The label printers we use for small labels are both Wasp WPL406 and Zebra 123100 - 202. We also use Zebra ZP 450 ctp for our pallet labels
Thanks Lukas. Correct me if I am wrong, but not every scanner is capable of reading QR codes (2D). The lower end (or older) scanners are usually only able to read 1D, which is what the 3of9 font is going to generate. You will likely need to buy a higher end scanner to also read 2D barcodes reliably.
Lennon Allen I recommend you playing with it on your own in learning by experimenting I think that you'll find the process of figuring these things out very rewarding
I second that request, been battling with the formatting of the excel sheet to get it to print on both sides of the page and to line up. (formating is easy, printing is easy getting the two sides to line up has got me stumped)
I tried following this exact video and have the same honeywell barcodes and the $I and $M commands do not work. I have a code 39 extended font, code 39 turned on, and full ascii on. Any idea what I could be doing wrong?
Our scanners are Honeywell 1900 GHD-2. The label printers we use for small labels are both Wasp WPL406 and Zebra 123100 - 202. We also use Zebra ZP 450 ctp for our pallet labels.
Simon Harte Well we don’t ban phones we just get our people to understand that the use of their phones for personal things during worktime is stealing from the company and from our customers. All of our people have their phones on them and they use them all the time for work! We are not a company of rules we are a company that operates based on a philosophy of serving the customer and respecting them.
Congrats guys!! I would love my business is so well organized and my workes so commited!!! Would be nice to see your excel spreadsheet inventory system. Thanks to your videos I've discovered KAIZEN and KANBAN. I've learn a lot with your videos. Keep posting!! Great job!! Greetings from Barcelona!!
QR-code.When a people seen the light in dark. They go to him!!! Do fighting for your the freedom!!!!!!!!!!!!!!!!! I believe that you will succeed too. Qr code tattoo- id you body's. We yourself to choise a way.
I have a dilemma using the special characters in the barcode, and I cannot find a solution. everything works as it should when using excel on my desktop. However im using OneDrive for my excel workbook. When I scan the barcodes with special characters it will not tab correctly from cell to cell. the first scan will tab correctly from cell A to Cell B. But the next scan will not drop down into Cell A in the second column, it drops straight down into Cell B.
Alexander Tolivaisa Because some people who subscribe to FastCap channel or not interested in Lean and I've got a few comments so I just stick to my channel with this.
QR-code.When a people seen the light in dark. They go to him!!! Do fighting for your the freedom!!!!!!!!!!!!!!!!! I believe that you will succeed too. Qr code tattoo- id you body's. We yourself to choise a way.
If the narrator does not have equity in the company or options he should leave and start his own company. Too talented to make a wage and not a profit.
Although a dry subject, he did a great job at explaining everything. Well done 👍
This is a amazing great video especially the part about the stars to trigger the bar code scanner. Great work as always. Give that man a fat raise😁
This video is amazing and well thought out. This information can help a lot of businesses. If you have never heard about “Kanban” you would never find this great video. Maybe add “barcodes for dummies” or “barcode 101” in the video title so people can find it better on RUclips. Keep up the great work.
Your generosity is boundless and the value from this video so significant. Amazing actionable insights. Thank you Paul and Lucas!
This was incredibly insightful. Great job Lukas!
Paul... Lukas is a keeper! I just got a scanner and I am like huh??? I learned a few things on my own. But I learned so much more thanks to him! Thanks Lukas!!!
Going to be playing with this and my phone scanner now to see what I can come up with.
2 second improvement - keep the scanner always on and in a fixed position next to the laptop on the forklift so that one does not have to constantly pick up the scanner. Easily shave off five seconds per scan.
That was incredibly informative. Thank you for taking the time to document this!
Amazing! Thanks for taking the time to record this all.
That is one of the best, most informative videos I have seen. Great video Lukas. Thank you!
Very informative! Great job!
Wow!!!! Amazing video! Answered every question I had for you guys. Rock on!
Mind blowing! i will try this right now! its going to be great 👍🏻 thanks !
Thank you for this gift, really informative video.
I tried doing the tab and carriage return but it wasn't working... I finally figured out that my scanner does not have the ability to read ascii. I ordered a scanner with the ability to read ascii and it works just like you demonstrated in this video.
Also, I figured out that you can create a single barcode that will scan in the part#, tab, scan in quantity, carriage return... So you only have to dink a Kanban card once, a downside is that the barcode will be longer.
So for part# Elbow with a quantity of 25 you'd input this:
(asterisk)Elbow$I25$M(asterisk)
Thank you again Lukas and Paul.
This guy needs a raise!!!! Awesome job, you have no idea how much this has helped me and my project. So fantastic that you shared your knowledge with us! Good lookin' warehouse too btw!
You saved my day, thank you!
My team has to fill out a Excel to get some KPI's that we can't get out of SAP.
Now i designed a Form in Excel and a Makro to fill the Data it in a Table and reset the Form after this.
With your Barcode Tipps i created a A3 Sheet with Barcodes where you can take the right data and hop in the next box.
- Saving a lot of Time (75-85%) of my Team
- Saving my Time (90%) (The Only thing i have to do now is open the Excle und hit the KPI Dashboard, no Checking of Data, no adjustments on the Pivot. Before this i had to proof all Data for wrong Entrys)
- No Mistakes Possible (Created Rules in the Boxes, you cant put a Number in a Checkbox where you need do fill in witch kind of Drum it is)
Have a great day :)
Thank you very much Lucas. Cheers
Thank you Lucas for sharing your work, and a Thank You to Paul for allowing him the resources to provide this video
Thank you for sharing Paul and Lukas!!!
Lucas Lorentz our pleasure
Paul & Lucas Really helpful!! Thanks for making / sharing this!!
Thanks Lucas, fantastic system.
You guys are awesome!! Thank you a ton!!!
Excellent video! Thank you
Lukas, Paul great video, we’ve used barcodes for a few years now, but the tips you’ve just shown for tabbing and entering automatically have just revolutionised our stock entry process (or at least it will do as soon as I get in to work this morning!)
Mark so happy that's why we did the video we want to help people.
Thank you so much Lukas.... this is awesome
That was so helpful that I applied immediately with good results! Amazing Job! Thanks
I love these videos. Just a thought, should the barcodes be on the right side of the cart since most people are right handed?
LUKAS!!!!!! What a well-made video! Thanks for the thorough explanation! Awesome man!
Great video - thank you!!
This was incredibly helpful ! Looking to up our barcode game and this was exactly what we needed to know ! Thanks !
Awesome video
Lukas, can you list the printers and scanner you use? thanks bro.
Scanners are Honeywell 1900 GHD-2. The label printers we use for small labels are both Wasp WPL406 and Zebra 123100 - 202. We also use Zebra ZP 450 ctp for our pallet labels
Thanks Lukas.
Correct me if I am wrong, but not every scanner is capable of reading QR codes (2D). The lower end (or older) scanners are usually only able to read 1D, which is what the 3of9 font is going to generate. You will likely need to buy a higher end scanner to also read 2D barcodes reliably.
You are correct. Im sorry i was not fully aware of this and did not include this information in the video! Thank you for catching that detail!
So helpful, thank you!
at 23:23 Lukas gets a haircut :) Thanks for the great video!
I’d be interested in a video showing how ya’ll format those excel sheets to print the labels and kanbans. Thanks.
Lennon Allen I recommend you playing with it on your own in learning by experimenting I think that you'll find the process of figuring these things out very rewarding
I second that request, been battling with the formatting of the excel sheet to get it to print on both sides of the page and to line up. (formating is easy, printing is easy getting the two sides to line up has got me stumped)
At the 22 minute mark, what was the actual formula you put in to create the "tab, tab, enter, tab" barcode?
“*”&”$I”&”$I”&$M””&”*”
“*$I$I$M*”
Both are correct
I tried following this exact video and have the same honeywell barcodes and the $I and $M commands do not work. I have a code 39 extended font, code 39 turned on, and full ascii on. Any idea what I could be doing wrong?
Any recommendations for scanners? Yours looks great since it does barcodes and QR codes
Our scanners are Honeywell 1900 GHD-2. The label printers we use for small labels are both Wasp WPL406 and Zebra 123100 - 202. We also use Zebra ZP 450 ctp for our pallet labels.
Hi Paul if you ban phones how do the employees scan the QR code you have all round the facility do you have a work iPhone or something
Simon Harte Well we don’t ban phones we just get our people to understand that the use of their phones for personal things during worktime is stealing from the company and from our customers. All of our people have their phones on them and they use them all the time for work! We are not a company of rules we are a company that operates based on a philosophy of serving the customer and respecting them.
Yes Paul I realize that but if you did ban phones could you prob a work p hone for only taking videos of improvements
Prob was provide sorry
@@simonharte7530 I'm not sure what you are asking. I explained how we do it at FastCap. Yes, an employer could provide a phone if they wanted to.
do you know if you can make Excel use QR codes to possible open a file and or populate and save a shared spreadsheet?
I think if you do a google search, you'll find some solutions.
Congrats guys!! I would love my business is so well organized and my workes so commited!!! Would be nice to see your excel spreadsheet inventory system. Thanks to your videos I've discovered KAIZEN and KANBAN. I've learn a lot with your videos. Keep posting!! Great job!! Greetings from Barcelona!!
QR-code.When a people seen the light in dark. They go to him!!! Do fighting for your the freedom!!!!!!!!!!!!!!!!!
I believe that you will succeed too. Qr code tattoo- id you body's. We yourself to choise a way.
I have a dilemma using the special characters in the barcode, and I cannot find a solution. everything works as it should when using excel on my desktop. However im using OneDrive for my excel workbook. When I scan the barcodes with special characters it will not tab correctly from cell to cell. the first scan will tab correctly from cell A to Cell B. But the next scan will not drop down into Cell A in the second column, it drops straight down into Cell B.
Allan Godon I will check with Lucas
Why are posting this on your personal channel instead of the FastCap channel?
Alexander Tolivaisa Because some people who subscribe to FastCap channel or not interested in Lean and I've got a few comments so I just stick to my channel with this.
This is actually Paul's entrepreneur, business owner, author, speaker, Lean maniac, & podcast channel :)
🔥🤯😮💨👌🏾💎
QR-code.When a people seen the light in dark. They go to him!!! Do fighting for your the freedom!!!!!!!!!!!!!!!!!
I believe that you will succeed too. Qr code tattoo- id you body's. We yourself to choise a way.
If the narrator does not have equity in the company or options he should leave and start his own company. Too talented to make a wage and not a profit.