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.
Good news! After a long debugging session tonight we finally found the problem. The Google Script code is not correct. In order to fix this issues change the following line:
return header === 'Date' ? new Date() : e.parameter[header].join(",")
return header === 'Date' ? new Date() : e.parameter[header]
(remove the .join(“,”) at the end.)
You’ll need to redeploy the code.
Please let us know if that solves your issues.
Thanks for the assistance just once more question so i’ve opened up the file on vscode and I need to download a debuger as well to run it is there any other way to run it?
Actually I think a better question is how do you open the qr code macro
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?
Try running your version of the scouting web app on the same computer as your Excel sheet.
Scout a match on the App and go to the QR code page. There’s a “Copy Data” button. It will copy the input to your clipboard.
Then go to Excel, start the macro, and paste the data (from the clipboard) into the input field. It should process without a problem.
Remember, if you modify your configuration, you’ll need to modify the macro so that the fields match up between the two.
I ran the scouting application thta I am currently hosting on GitHub pages and I am pasting it into the excel macro but it gives me the same error.
We had some issues running the macros on OSX devices (assuming 429 is the cannot create activeX object error), which means my best guess is that VBA doesn’t really like certain OSX devices.
We ended up just forcing our scouts to only run the spreadsheet on a Windows computer.
Oh so its better to run this application on windows computer? Right now I am using a macbook to run the application
The excel spreadsheet portion yes. The web application can run on any device with a web browser.
Good luck to all our ScoutingPASS teams going into Week 1!
We’ve had a few instances of the TBA integration not working because the event code was entered with capital letters. Event codes need to be all lowercase. A bug fix will be issued shortly.
A big thank you to PWNAGE for sharing your scouting program with everyone!! It inspired Fondy Fire to share our data analysis spreadsheet. We’ll be scouting with ScoutingPASS this year, so we formatted our spreadsheet to work with the ScoutingPASS data output.
Here’s the link to the post that contains info about the spreadsheet and how to download it.
Thanks to everyone who helped me set up the app! It worked to great success and made scouting feel so much more easier and faster than when doing it on paper!
another question, can you change the text that shows up on excel? for example, the match level column displays “qm” for quals, or the driver effectiveness just does one letter. Is there a way that you can change the config on github to display (for example) “quals” or “finals” or “very effective” when you input QR codes?
We use abbreviations whenever possible to keep the QR code size reasonable and easily read by the scanner.
You can use Excel to expand those fields if you’d like. Create a new column in the Match Scouting Data table, like “matchLevelStr” and enter in this formula:
=IF([@matchLevel]=“qm”, “quals”, IF([@matchLevel]=“f”, “finals”, IF([@matchLevel]=“de”, “double elimination”, “other”)))
You can do the same with any of the other fields. We usually turn driver skill into a number, “driverSkillMetric”
=IF([@driverSkill]=“n”, 0, IF([@driverSkill]=“a”, 5, IF([@driverSkill]=“v”, 10,“”)))
I hope that helps.
Very cool, thank you!
If you’re using the Fondy Fire Scouting Analysis Spreadsheet with PWNAGE ScoutingPASS app, please note that I updated the spreadsheets to incorporate the new column PWNAGE added to the Pit Scouting section (Number of Batteries.)
Original files are here:
This is version 3 of the Fondy Fire Scouting Analysis Spreadsheet. It was updated today (3/19/2023) to match the revisions made by PWNAGE on github this weekend.