Paper: Scouting Database from Team 2834

Thread created automatically to discuss a document in CD-Media.

Scouting Database from Team 2834
by: timuraydin

This is a new scouting database with Offensive Power Rating (OPR), Calculated Contribution to Winning Margin (CCWM), and EPR calculations

This is the continuation of scouting database by Ed Law from
https://www.chiefdelphi.com/t/paper-new-scouting-database-from-team-2834/91560.

EPR calculations (http://www.chiefdelphi.com/forums/showthread.php?t=137328) are also included.

Event data is pre-updated using FRC Events API instead of FRC event website. Due to this change some of the previous features are not available (i.e. refresh data).

Timur Aydin
FRC Team 2834 Mentor

Team_2834_2016_Scouting_Database_v1_CMP.xlsm (20.8 MB)

1 Like

What is “EPR”? I note that unlike the other acronyms, this one isn’t defined.

Also, is there a separate measure of breach and capture ranking point contributions?

Note that these OPRs don’t include elimination rounds, so the OPRs may be less representative of what’s happening in the playoffs than in past years.

Equidistant Power Rating

EPR is half way between OPR and the “new and improved CCWM” which is WMPR. You can calculate WMPR from EPR and OPR.

We have not included elimination rounds to calculate OPR in the last 8 years.

Richard, I have just uploaded a scouting database which contains breach and capture ranking point contributions for all week 1 events. If you have any ideas for how to create a distinct elimination OPR (eOPR), I am all ears.

There is no separate measure of breach and capture ranking point contributions.

Elimination rounds are not included for calculations. If needed for an event, the workaround is, to copy elimination matches (row 400+) at the end of qualification matches (row 150+) and run CalcResults macro. This will update OPR/CCWM/EPR rankings for the event. subOPRs will not include play-offs.

Thank you so much for taking the time to update the data. MUCH appreciated!!

It should be fairly easy to calculate ranking point OPRs from quals data. It’s much like the OPRs for coop points last year. Just instead of 40 points, they are 1 point, and you get essentially “shares.” Previous data sets have had the game phases broken out. The reason to compute this is it is easy to convert by multiplying by either 20 or 25 points. In fact, it might be useful to run a parallel OPR with the converted ranking points.

My new Monday ritual: refreshing this thread to see if the new 2834 scouting database has been posted yet.

I really appreciate you managing all of this data. It is a great resource!

Is my eOPR2 what you had in mind? It is just (“normal” OPR) + 20*(breach contribution) + 25*(capture contribution).

In the past I believe their was a Max OPR column that could be used to help sort teams by their best performance. It looks like this would be a useful tool as some teams make big improvements from their first regional to their last regional. Is there anyway that this column will make its way into the spreadsheet before worlds.

Please check the comment on cell G3 in OPR Results sheet.

If you change the value of G3 to -1 and click “calc”, it will show the Max OPRs. Then click “sort” to sort teams based on Max OPRs.

Awesome! Thanks for putting all this together and keeping up with it.

i have a scouting database that uses paper for collecting the info…

https://drive.google.com/open?id=0B4buaELW8-5rdFpFTC04d2doYjg

there it is if you want it

When will week 6 be available?

Currently calculating World EPRs. Other calculations are done. I will post it as soon as it is done - sometime this afternoon.

Thank you very much for your generosity and hard work compiling and sharing this data. 195 has been using this database for years and really appreciate that you put it out there to share.

Is a post-CMP update coming? :slight_smile:

I am planning to post it this weekend.

Sounds good; thank you!