paper: Scouting Database from Team 2834

[timuraydin]

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

Scouting Database from Team 2834 (http://www.chiefdelphi.com/media/papers/3242?) by timuraydin

[Citrus Dad]

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.

[Ether]

What is "EPR"?

Equidistant Power Rating

[Ed Law]

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.
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.

[Caleb Sykes]

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.

Richard, I have just uploaded a scouting database (http://www.chiefdelphi.com/forums/showthread.php?threadid=145892) 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.

[timuraydin]

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.

[AliciaTBay]

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

[Citrus Dad]

Richard, I have just uploaded a scouting database (http://www.chiefdelphi.com/forums/showthread.php?threadid=145892) 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.

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.

[allen.mays]

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!

[Caleb Sykes]

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.

Is my eOPR2 (http://www.chiefdelphi.com/forums/showthread.php?threadid=145892) what you had in mind? It is just ("normal" OPR) + 20*(breach contribution) + 25*(capture contribution).

[Louisiana Jones]

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.

[timuraydin]

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.

[Louisiana Jones]

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.

[bennettj800]

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

[Banderoonies]

When will week 6 be available?

[timuraydin]

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.

[Banderoonies]

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.

[Nathan Streeter]

Is a post-CMP update coming? :-)

[timuraydin]

Is a post-CMP update coming? :-)

I am planning to post it this weekend.

[Nathan Streeter]

I am planning to post it this weekend.

Sounds good; thank you!