paper: Scouting Database from Team 2834
 

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

Scouting Database from Team 2834 by timuraydin

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

Equidistant Power Rating

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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!

Re: paper: Scouting Database from Team 2834
 

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

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

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

Re: paper: Scouting Database from Team 2834
 

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

https://drive.google.com/open?id=0B4...FpFTC04d2doYjg

there it is if you want it

Re: paper: Scouting Database from Team 2834
 

When will week 6 be available?

Re: paper: Scouting Database from Team 2834
 

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

Re: paper: Scouting Database from Team 2834
 

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.

Re: paper: Scouting Database from Team 2834
 

Is a post-CMP update coming? :-)

Re: paper: Scouting Database from Team 2834
 

I am planning to post it this weekend.

Re: paper: Scouting Database from Team 2834
 

Sounds good; thank you!