This thread came up a couple months ago and has some relevant info to your questions I think.
The following was a post I made in the thread above describing our scouting system from 2016:
Quote:
Originally Posted by cad321
Here on 2386 we had just recently moved to electronic scouting for the 2016 season. For the years before that, scouting was normally an afterthough and carried out by only a few students and mentors. Our system this year was comprised of a custom app writen by one of our senior students an an excel spreadsheet used to analyze the data.
We would input the data collected for each robot onto one of 6 android enabled devices in the stands. Such things included how many shots on each goal vs how many successful shots on goal, completed scales, what defences were crossed and (x) amount of times etc. From here we would transfer the data from 5 of the devices onto the 6th (the one we deemed the master device) via bluetooth. After this we would export a .CSV file (a file readable by excel) from the master device with all of the raw data collected.
This is where things got a little labour intensive and where we plan to improve next year. After we had the raw data that was collected during the day, I had to manually sift through the data and move all of the data pertaining to each team into their associated worksheet on our that primary spreadsheet. This can be improved upon by writing macros in excel to do this for us. From here we could assign different weights to each "catagory" as we deemed fit. These catagories were things such as number of high goals, number of low goals, number of crossings and number of successful scales.
Finally on our master list of all the teams, a score was calaculated based on the raw data collected during the day, and the weights assigned by our scouting team to help form our picklist. As this was our first year implementing the system, we still spent time manually checking our findings in the spreadsheet, however as time goes on we hope that we can rely more and more on this system to save us time while creating our pick list.
|
Hopefully some of this info is helpful to you.