Go to Post I happen to know that there is a back-order status from Exide. Seems for some reason people are ordering this product - Mike Martus [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
Reload this Page Scouting Database from Team 2834
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



Scouting Database from Team 2834

By: timuraydin
New: 08-03-2016 07:45
Updated: 08-05-2016 08:20
Total downloads: 1800 times


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
http://www.chiefdelphi.com/media/papers/2174.

EPR calculations (http://www.chiefdelphi.com/forums/sh...d.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

Attached Files

  • lsm Team 2834 2016 Scouting_Database v1 week 1

    Team_2834_2016_Scouting_Database_v1_w1.xlsm

    downloaddownload file

    uploaded: 08-03-2016 07:45
    filetype: lsm
    filesize: 14.69MB
    downloads: 268


  • lsm Team 2834 2016 Scouting_Database v1 week 2

    Team_2834_2016_Scouting_Database_v1_w2.xlsm

    downloaddownload file

    uploaded: 14-03-2016 22:30
    filetype: lsm
    filesize: 16.39MB
    downloads: 238


  • lsm Team 2834 2016 Scouting_Database v1 week 3

    Team_2834_2016_Scouting_Database_v1_w3.xlsm

    downloaddownload file

    uploaded: 21-03-2016 12:30
    filetype: lsm
    filesize: 17.18MB
    downloads: 190


  • lsm Team 2834 2016 Scouting_Database v1 week 4

    Team_2834_2016_Scouting_Database_v1_w4.xlsm

    downloaddownload file

    uploaded: 29-03-2016 00:03
    filetype: lsm
    filesize: 18.05MB
    downloads: 220


  • lsm Team 2834 2016 Scouting_Database v1 week 5

    Team_2834_2016_Scouting_Database_v1_w5.xlsm

    downloaddownload file

    uploaded: 05-04-2016 09:21
    filetype: lsm
    filesize: 19.01MB
    downloads: 239


  • lsm Team 2834 2016 Scouting_Database v1 week 6

    Team_2834_2016_Scouting_Database_v1_w6.xlsm

    downloaddownload file

    uploaded: 11-04-2016 14:10
    filetype: lsm
    filesize: 19.67MB
    downloads: 51


  • lsm Team 2834 2016 Scouting_Database v1 week 6 (corrected MIHowell subOPRs)

    Team_2834_2016_Scouting_Database_v1_w6.xlsm

    downloaddownload file

    uploaded: 11-04-2016 16:52
    filetype: lsm
    filesize: 19.69MB
    downloads: 131


  • lsm Team 2834 2016 Scouting_Database v1 week 7

    Team_2834_2016_Scouting_Database_v1_w7.xlsm

    downloaddownload file

    uploaded: 18-04-2016 12:22
    filetype: lsm
    filesize: 20.01MB
    downloads: 181


  • lsm Team 2834 2016 Scouting_Database v1 week 8 (Included Championship Divisions)

    Team_2834_2016_Scouting_Database_v1_w8.xlsm

    downloaddownload file

    uploaded: 24-04-2016 07:23
    filetype: lsm
    filesize: 20.27MB
    downloads: 134


  • lsm Team 2834 2016 Scouting_Database v1 Final

    Team_2834_2016_Scouting_Database_v1_CMP.xlsm

    downloaddownload file

    uploaded: 08-05-2016 08:20
    filetype: lsm
    filesize: 20.84MB
    downloads: 146



Recent Downloaders

Discussion

view entire thread

Reply

17-03-2016 19:31

Citrus Dad


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



17-03-2016 22:33

Ether


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Citrus Dad View Post
What is "EPR"?
Equidistant Power Rating




18-03-2016 00:19

Ed Law


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Citrus Dad View Post
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.



18-03-2016 12:46

Caleb Sykes


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Citrus Dad View Post
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 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.



18-03-2016 17:40

timuraydin


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



20-03-2016 13:26

AliciaTBay


Unread Re: paper: Scouting Database from Team 2834

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



20-03-2016 22:40

Citrus Dad


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Caleb Sykes View Post
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.
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.



21-03-2016 10:08

allen.mays


Unread 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!



21-03-2016 19:31

Caleb Sykes


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Citrus Dad View Post
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 what you had in mind? It is just ("normal" OPR) + 20*(breach contribution) + 25*(capture contribution).



05-04-2016 11:21

Louisiana Jones


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



05-04-2016 12:19

timuraydin


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Louisiana Jones View Post
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.



05-04-2016 12:26

Louisiana Jones


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by timuraydin View Post
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.



05-04-2016 12:29

bennettj800


Unread 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



11-04-2016 10:33

Banderoonies


Unread Re: paper: Scouting Database from Team 2834

When will week 6 be available?



11-04-2016 12:13

timuraydin


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Banderoonies View Post
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.



11-04-2016 15:28

Banderoonies


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



03-05-2016 11:38

Nathan Streeter


Unread Re: paper: Scouting Database from Team 2834

Is a post-CMP update coming? :-)



05-05-2016 10:29

timuraydin


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by Nathan Streeter View Post
Is a post-CMP update coming? :-)
I am planning to post it this weekend.



05-05-2016 11:11

Nathan Streeter


Unread Re: paper: Scouting Database from Team 2834

Quote:
Originally Posted by timuraydin View Post
I am planning to post it this weekend.
Sounds good; thank you!



view entire thread

Reply

Tags

loading ...



All times are GMT -5. The time now is 13:48.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.

Contact Us - Chief Delphi - Rules - Archive - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi