|How do you earn yourself 500 PM's, 200 e-mails, 100 replies to a post, and an instant 5 to 6 bars in rep? If your name is Grant Imahara, make yourself known to the Chief Delphi community. - Andy Grady [more]|
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@example.com
Scouting Database 2015- 1.0.xlsmdownload file
Scouting Database 2015- 2.0.xlsmdownload file
Scout862 v2.0.apkdownload file
Scouting Database 2015- 3.0.xlsmdownload file
Scout862 3.0.apkdownload file
Scouting System Guide.pdfdownload file
Scouting Datsbase 2015- 4.0.xlsmdownload file
Scout862 v4.0.apkdownload file
Scouting Database 2015- 6.0.xlsmdownload file
Scout862 v6.0.apkdownload file
02-15-2015 09:16 AMDragonking
The scouting app is now available to download. Let me know if you have any problems installing it.
02-17-2015 02:56 PMDragonking
Below are some screenshots of the app.
02-25-2015 02:17 PMApril_robo
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.
02-25-2015 02:29 PMDragonking
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.
03-03-2015 01:58 PMDragonking
I will be releasing a set of updates for the scouting systems along with hopefully some more detailed instructions by week 3 competitions.
- bug fixes
- using user created folders to store data on tablets
- scouting teleop by stack instead of overall (this allows to see exactly what kinds of stacks a team created during that match)
- some minor changes and additions to the spreadsheet
I also may have time to make a step by step guide with pictures to help with using all the features of the scouting system.
03-08-2015 12:27 PMDragonking
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.
03-10-2015 06:04 PMDragonking
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.
03-17-2015 05:02 PMDragonking
Newest version is now released. It includes some bug fixes. Let me know if you find anymore bugs.
04-15-2015 09:36 PMDragonking
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.
04-15-2015 09:37 PMDragonking
Also let me know if there is anything you want me to change, fix, or edit.
04-16-2015 09:19 AMphilso
What version of Android is required to run your app? My phone is pretty ancient (Android 2.2.3).
04-16-2015 03:12 PMDragonking
The minimum I can currently set it to is 4.0. Also the app only works on 7in screens.
04-18-2015 01:37 PMDragonking
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.