View Single Post
  #4   Spotlight this post!  
Unread 25-10-2016, 14:14
CVR's Avatar
CVR CVR is offline
4039 Mentor
AKA: Matt G
FRC #4039 (Makeshift)
Team Role: Mentor
 
Join Date: Apr 2015
Rookie Year: 2009
Location: Ontario
Posts: 18
CVR is a splendid one to beholdCVR is a splendid one to beholdCVR is a splendid one to beholdCVR is a splendid one to beholdCVR is a splendid one to beholdCVR is a splendid one to beholdCVR is a splendid one to behold
Re: Google Sheets OPR Calculator

Rachel,

the IMPORTHTML function in google docs might be very useful to you. I've used it during many competitions to pull data from TBA and analyze it in Google Sheets.

If you put
Code:
=IMPORTHTML("https://www.thebluealliance.com/event/2016onwa","table",1)
in your google sheet, it'll pull the match results data from TBA and put it directly into the sheet. The format is a bit strange, but that can be dealt with easily enough.

I can't seem to find any of my spreadsheets, but there is a way you can have it auto-update the function. It will then load any new data from TBA, which is great for crunching numbers during competitions. Want to know what an alliance member's opr is in an upcoming match, even if this is their first event and they've only played 5 matches? Easy. (although the number may not be accurate... opr caveats and all that)

It also has the advantage of allowing you to change events (and even years) very easily since TBA uses a consistent url scheme.
Reply With Quote