4536 2017 scouting database, what would you like to see?

Competition Scouting
1

As the build season is coming to a close, I am going to spend the next few weeks creating the 4536 2017 scouting database. The available data we have to work with can be found here. Using this data, here are the metrics I am currently planning to track, let me know if you would like this database to cover any other metrics:

Calculated contributions (component OPRs):
Auto:
autoMobilityPoints
autoFuelLow
autoFuelHigh
autoFuelPoints
rotor1Auto
rotor2Auto
autoRotorPoints
autoPoints

Teleop:
teleopFuelLow
teleopFuelHigh
teleopFuelPoints
rotor1Engaged
rotor2Engaged
rotor3Engaged
rotor4Engaged
teleopRotorPoints
teleopPoints

Endgame:
touchpadNear
touchpadMiddle
touchpadFar
teleopTakeoffPoints

Misc:
kPaRankingPointAchieved
rotorRankingPointAchieved
foulCount
foulsDrawn
techFoulCount
techFoulsDrawn
foulPoints
foulPointsDrawn
totalPoints
win
winning margin

Useful linear combinations of above metrics:
autoRotorBonus = autoRotorPoints/3
rotorPoints = autoRotorPoints + teleopRotorPoints
rotorsEngaged = rotor1Engaged+rotor2Engaged+rotor3Engaged+rotor4Engaged
subtracted kPa = teleopFuelPoints+autoFuelPoints
playoffTotalPoints = totalPoints+100rotor4Engaged+20kPaRankingPointAchieved

Miscellaneous derived metrics (see this thread for more info on gear contributions):
autoScoredGears
totalScoredGears
teleopScoredGears
estimatedAutoGears
estimatedTotalGears
estimatedTeleopGears
estimatedAutoGears2 (I have some other ideas for how to estimate scored gears that may go here)
estimatedTotalGears2
estimatedTeleopGears2
Winning Margin Elo (see this thread)

Other additions to the 4536 scouting database when compared with last year’s database will hopefully include:
A team lookup sheet
Adding team nicknames everywhere
Every team’s home championship will appear in the world results sheet and in team lookup
Adding a week number anywhere an event name appears
Seed metrics for all future events to make pre-scouting much easier

Let me know if you would like to see anything else in the 2017 database, and I will consider adding it.

2

I would like to see some option on teleop for climbing for a team that didn’t climb. Also i would like to see a metric for number of gears dropped during a given match. Knowing which teams have the ability to possess a gear, and knowing which teams have the ability to keep possession will be a vitally important data point in separating the wheat from the chaff when it come to “gear specialist” robots.

3

I’m not quite sure that you understand what this database is. Here is the 2016 database for reference. Your first suggestion for climbing seems like it would be covered in the teleopTakeoffPoints category. Your second suggestion for gears dropped is not something I will be able to track using the data provided by the frc events API.

4

Will this database be available for use by other teams? Wasn’t aware of this in previous years, and it would save a ton of time after build season since I was planning on creating a Google sheet for my team.

5

Absolutely it will be publicly available. I have a link to the 2016 database in my previous post if you want to see what it looked like last year.