We’ve already been using Airtable for scouting, which is more or less Google Forms/Sheets with a bit nicer UI. The Slackbot pretty much just had one command: @scoutingbot match x. It would grab the alliances for that match from TBA, grab data for the 6 teams out of Airtable, and try to calculate an estimated score for each alliance, along with some basic average stats for each team.
An example output:
------RED: 74.7063492063492---------
Team: 2957
Hatches: 0.75
Cargo: 3.25
Climb: 2.25
Team: 2702
Hatches: 2
Cargo: 2.25
Climb: 5.25
Team: 1885
Hatches: 4.25
Cargo: 4
Climb: 5.25
------BLUE: 67.5---------
Team: 7797
Hatches: 0
Cargo: 0
Climb: 2.25
Team: 4130
Hatches: 2.25
Cargo: 3.75
Climb: 6.75
Team: 4039
Hatches: 3.75
Cargo: 2.5
Climb: 12
Code can be found here: https://github.com/iliterobotics/FRC-Scouting-2019. It’s definitely not pretty; this was a last minute idea that was thrown together in a few days, but it was super useful as a concept and something we hope to expand on for this upcoming season.
