Many barcode scanners can scan directly to excel (e.g. this one).
Use Pandas to read excel data. Use Matplotlib to create graphs.
Need more info about the check-in/check-out process. Is there some person with the laptop and scanner sitting there checking out devices? That is to say, maybe the user walks up, enters their information (or scans a badge, maybe?) and the person doing the checkout validates the information and scans the device and hands it to them and sends them on their way? That's one possible scenario. Is that the kind of thing you're envisioning?
What condition would alert you to the fact that a device was not checked in or out properly?
My recommendation will be dependent on the answers to the questions above.
These work pretty well for scanning and they're cheap. My first choice for a printer would be a Zebra GK410 (or GK420 if you need 4" wide labels).
Purchased in the US from this Amazon listing.
Excerpt from the user's manual and sticker.
For completeness I also swapped out the 433 MHz antenna for a 2.4 GHz antenna and watched the waterfall around 2.44 GHz, but no new traffic appeared during scans either with or without the dongle.
Additional I/Q file of the data burst when no dongle is connected. Same SDR, 20 MHz sample rate, "auto" bandwidth this time.
btw- this one? freaking amazing for what I paid
https://www.amazon.com/gp/product/B01GDJ2BH6
not my only, but the best value in a while- I use it all across my shop...
only aggravation is it only scans on a single horizon.
I'd do it a little differently... they all have UPC's?
https://www.amazon.com/gp/product/B01GDJ2BH6
36$ right now.. hell of a long range ~ massive...
it's a keyboard HID device (to a windows PC)
Open excel - click in a1- walk around, and scan the store- 1 scan per item in the store
if you have ten on the shelf, pick up the first one and scan it ten times
excel will show a line per scan (the scanner adds a carriage return)
there is your inventory-- now countif duplicates for total inventory
- want to really trip balls?
scan it to a google sheets on PC#1
open the SAME sheet on a different PC-- as the scanner scans- have them call out the name, shelf price, and if you want SKU.. someone at pc#2 can type into the first UPC line while the scanning continues -- soon as it's time to go to the next, person on pc2 goes left arrow, (into upcs list) ctrl+dwn arrow- then right arrow, then goes on to typing the data at the head of the UPC list again.
Oh I should learn something? How about you read your own link where it even says:
>Laser - This type of illumination method uses a single point red laser diode similar to a laser pointer. The point of light is expanded into a line by oscillating the laser into a stationary mirror, or projecting the point into an oscillating mirror. This illumination method is very popular because of the working distances typically achieved are superior to the point illumination or linear LED illumination methods. Typical working distances are from 1" to 18". By increasing the power of the laser and decreasing the angle of oscillation, ranges of over 20 feet can be obtained.
Or here, watch this video by EEVblog where he disassembles a commonly used omnidirectional Laser Barcode Scanner:
https://www.youtube.com/watch?v=PIn00-qW5WI
Or read this where it says:
>Laser - This is the most well known scanner type. It uses a red diode laser to read the reflectance of the black and white spaces in a barcode. Laser scanners are only able to read standard linear (1D) barcodes but are also the most cost effective option. Standard laser scanners can read from a few inches to a foot or two away depending on the size of the barcode. There are also extended range laser scanners, like the Zebra LS2208, which can read up to 35ft away when using large reflective labels.
Or check out this handheld barcode scanner which even has the laser symbol on the front
And here you got an explanation why lasers are different from focused light
So please, CCD or array based scanners are a rather new development and I even asked you if you are talking about Linear Imagers which you completely ignored and staretd to ramble how low powered lasers are just focused light. The classical barcode scanners used for decades use lasers which are different from focused light.