Thread created automatically to discuss a document in CD-Media.
2015 Scouting System Team 862 by: Dragonking
Electronic scouting system including excel spreadsheet and android app.
–This is our 2015 scouting system. It includes an excel spreadsheet that can be used with either electronic or paper scouting input. There is also an android app we created to work with the spreadsheet. Make sure to read the guide below as well as the instructions tab in the spreadsheet. Data transfer to and from the android app works through excel files using USB or bluetooth. Some of the features of the spreadsheet include customizable scouted values (the app is not), customizable ranking values, lots of statistical calculations, match prediction, ranking projection, match prep sheet, mostly automated electronic data transfer/easy manual input.
–If you have any questions, message me through Chief Delphi or email me at [email protected]
thank you guys for creating the excel document. The only question I have is what do I need to input into each column is it a yes/no or a number? Also still slightly unsure where to input data.
You input 1,0. You input data in Input tab. After inputting a match schedule and team list, click calculate worksheet (f9), and then you sort and filter by match, team, or alliance station, and then type in the data you scout.
Version 2 is now posted and the biggest difference other than a bunch of fixed bugs is that you can now choose specific files to save scouted data from the app.
Version 3 will hopefully be release in the next few days. The biggest difference with version 3 is that now teleop is scouted by stack instead of overall stats. During our week 1 event I found it way more helpful to see exactly what kinds of stacks a robot makes than just seeing how many total totes it scored. I also plan on creating a step by step guide for all the functions of the scouting system with pictures to be released with version 3.
The version 3.0 spreadsheet and app is now released along with a step by step guide for setting up and running the scouting system at an event. Version 2.0 is still functional if you prefer it or don’t have time to switch. The guide applies to both versions.
Any comments, suggestions, found bugs are always welcome.
If I find any bugs at our week 3 event, I will try to fix it and upload the fixed version immediately if there is internet at the event.
I will be posting new versions of the app and database in the next couple days. There are a few new features and I fixed all the bugs I found (Warning: I may have created different bugs in the process). The android app version should be completely fool proof and crash proof.
Newest versions are now posted. The new app is now crash proof and a little more efficient. The new spreadsheet has some fixed bugs and I also added another value that can be scouted: speed of canburglar. This is scouted separately from the tablets and is not necessary for the rest of the formulas to work correctly.