[logank013]

This year, our data is very simple. Simple data is the best data. We have 6 scouters and one per team. Our teleop data is as simple as this. How many high goals? How many low goals? What 4 defenses are on the field and how many times was each defense crossed from the neutral zone to the courtyard? Capture? Scale?

We have a macro that is super useful and was written in about an hour all while teaching me how to do it in the future. This macro works like this. We are able to type in what defenses are on the field and how many times each was crossed. The macro lets the 4 defenses that aren't on the field to be left blank. This causes the sheet to sort the data so that the averages are not messed up. We also have a macro that sets up 60 sheets in a matter of second. We have 2 sheets per team. We type in the team list and it sets up both sheets and organized them for each team.

We ran into some problems at this event between Chrome OS and Windows which caused us to do paper scouting. After entering all the data, everything worked as planned. We have lots of great tools like defense predictors. It uses our data and tells us which defense is the best to put out each match. We built this database in about 5 meetings (spread out). Our scouting programmer and I have already talked about how to fix our issues. By our next competition, our goal is to have live data that automatically pulls into the database with the push of a button. Our laptop issue should have a quick fix that will allow us to go paperless (the best type). All I'll have to do to set up the database is enter in the team list and schedule.

Databases don't need to be lots of work and don't need to be expensive. Most of our tools that were used the most at this last competition were developed on our 11 hour bus ride to the competition. They are simple to make but are still powerful when looking for teams as a captain. If you are interested in how we use excel to create our database and have questions about how we use it, feel free to PM me. Thanks.