FRC Blog - Official Event Results -- Follow Your Favorite Teams

[Eugene Fang]

Originally Posted by XaulZan11

Am I the only want that wants to see the breach and capture ranking points for each qualification match? In my mind, it is almost as important as the final score.

The Blue Alliance has them. Example: http://www.thebluealliance.com/match/2016scmb_qm85

*Insert snarky comment about The Blue Alliance being "the most COMPLETE source of results from FIRST Robotics Competition events"* Just kidding. <3 the data the FIRST API provides us.

[PayneTrain]

Originally Posted by Eugene Fang

The Blue Alliance has them. Example: http://www.thebluealliance.com/match/2016scmb_qm85

*Insert snarky comment about The Blue Alliance being "the most COMPLETE source of results from FIRST Robotics Competition events"* Just kidding. <3 the data the FIRST API provides us.

Eugene, have you guys looked at providing a .csv file of data from events?

[plnyyanks]

Originally Posted by PayneTrain

Eugene, have you guys looked at providing a .csv file of data from events?

What's the use case? It's something we could look into. And if it ends up not being a feature for TBA proper, I'd write up a Google Apps Script that auto-populates a Google Docs spreadsheet with match results.

EDIT: We also have data dumps of past events on GitHub: https://github.com/the-blue-alliance...-alliance-data

[PayneTrain]

Originally Posted by plnyyanks

What's the use case? It's something we could look into. And if it ends up not being a feature for TBA proper, I'd write up a Google Apps Script that auto-populates a Google Docs spreadsheet with match results.

Stupid people like me who want a consistent way to play with the data in excel but don't want to fiddle with the API might find some use for it

[plnyyanks]

Originally Posted by PayneTrain

Stupid people like me who want a consistent way to play with the data in excel but don't want to fiddle with the API might find some use for it

I opened an issue so we can look into automating the csv backups. That way, they can be updated daily or something during the competition season.

https://github.com/the-blue-alliance...ce/issues/1387

[Ben Martin]

Originally Posted by PayneTrain

Stupid people like me who want a consistent way to play with the data in excel but don't want to fiddle with the API might find some use for it

I would use this too, for the same reason (I was fiddling with turning the JSON match data into a CSV earlier today for general data analysis in Excel).

[plnyyanks]

Originally Posted by Ben Martin

I would use this too, for the same reason (I was fiddling with turning the JSON match data into a CSV earlier today for general data analysis in Excel).

Originally Posted by PayneTrain

Stupid people like me who want a consistent way to play with the data in excel but don't want to fiddle with the API might find some use for it

Here, I whipped this up. It should auto-update every 15 minutes: https://docs.google.com/spreadsheets...it?usp=sharing

Here's the script that backs it: https://script.google.com/d/1Hnwgk7f...it?usp=sharing

[Ben Martin]

Originally Posted by plnyyanks

Here, I whipped this up. It should auto-update every 15 minutes: https://docs.google.com/spreadsheets...it?usp=sharing

Here's the script that backs it: https://script.google.com/d/1Hnwgk7f...it?usp=sharing

Thanks!
I was actually thinking about using it for diving into the more granular data you guys have available now--like finding OPRs for scaling/shooting/low goaling/crossing each type of defense/fouls off the opponent's score/etc and comparing versus scouting data. That script will help a lot.

[Cory]

Thank god, FIRST's useless website in which you could only find an event by searching for events within 100 miles of a given zipcode finally has a single page listing of all events again.

[XaulZan11]

This site is great, but is there a way to get to it from the main site? Going homepage>Programs-FRC-Events>Regional&DistrictEvents goes to horrible page Cory describes below.

Originally Posted by Cory

Thank god, FIRST's useless website in which you could only find an event by searching for events within 100 miles of a given zipcode finally has a single page listing of all events again.