I purchased that Lenovo on Amazon and just tried it today. It’s extremely slow, which makes sense because it’s only 4 GB of RAM. The big downside is that I can’t get the scanner to work on it. We’ll be using the scanner with ScoutingPASS excel file, but the Lenovo simply won’t recognize the input. The scanner works fine on everything else, but not this computer. I’ll likely return the computer.
Hello, our team has been having a hard time with the google sheets. We are trying to use excel using our phones as scanners and are at a loss. Is there more we can do to make google sheets work? Has there been any teams who had success using google sheets? We really love your app and want to use it this season. Thank you
Quick question this is my first time using something like this but I was wondering how data gets entered into the excel sheets. Currently I am hosting the website on my macbook so would I need to scan the qr codes on my macbook for it to get entered into the excel sheets? Great app by the way assuming we can get it to work.
Yes, within one of their excel templates is a QR scanner macro. You click the macro button, then you can either enter the QR data manually, or use a scanner connected to your computer to auto input the data string. This can all be viewed in the “How we scout” section of their GitHub page for ScoutingPASS.
In the GitHub repo in the Excel directory is a file called 2023 Excel Skeleton.xlsm.
That spreadsheet has a button that is tied to the QR code reading macro. The macro will open up an input pop up. Scan the QR code and the data will be copied into the input field. The macro will then take the input from the scanner, parse it and paste it into the “Match Scouting Data” sheet.
If you just want the macro code it is in the QRReader.bas VB file in the same directory.
Thank you so much! I think i’ve almost got it I’m just a bit confused on how the macro works as i’m inputing data but it says that it cannot create an object and run time error 429. I’m currently manually entering in data is that why its happening?