OPR calculation

[jvriezen]

Is there a tool/spreadsheet on CD that helps compute OPR based on match results? I'd like to do so for the MN FTC Qualifying regionals. I believe I saw a white paper on the topic before, but I'm having trouble finding it now -- I tried searching.

The difference for FTC is that qualifying matches are 2v2.


Thanks.

[Ether]

Is there a tool/spreadsheet on CD that helps compute OPR based on match results? I'd like to do so for the MN FTC Qualifying regionals. I believe I saw a white paper on the topic before, but I'm having trouble finding it now -- I tried searching.

Do you just want to do the computation, or do you want to learn the underlying mathematics?

[jvriezen]

Do you just want to do the computation, or do you want to learn the underlying mathematics?




Both, if available.

I'd like to explain the math to the kids (at a high level at least) which I think I can do from what I recall reading about it months ago. (Assume each team always contributes same points toward each match total, then come up with these per team values that best approximate actual match scores.)

Then I'd like to calculate it using an 'easy to use' tool. I don't think the kids could start from the underlying math explanation and do it themselves, and they don't really have the time to invest in that excercise (though I may be surprised about that)

I have 73 teams, up to 32 matches at each of 5 tournaments-- so ~160 matches of data total.

[Ether]

I have 73 teams, up to 32 matches at each of 5 tournaments-- so ~160 matches of data total.

What is the format of the data?

Attached is a simple-to-use tool which accepts data in the following format:

RED1 RED2 RED3 BLUE1 BLUE2 BLUE3 RED_SCORE BLUE_SCORE

... and calculates all sorts of stats, including OPR, and outputs the results to a CSV file which can be opened directly in Excel.

Tell me what format your data is in and maybe I can make a few simple changes so it can process the whole batch for you.

[Ether]

Both, if available

OPR math:

OPR explained using St Joe event data as example:
http://www.chiefdelphi.com/forums/showpost.php?p=1253180&postcount=11

"formula" for OPR:
http://www.chiefdelphi.com/forums/showpost.php?p=1119150&postcount=36

Ed Law's OPR paper
http://www.chiefdelphi.com/media/papers/2174

Jay Lundy's OPR & DPR
http://www.chiefdelphi.com/forums/showpost.php?p=733759&postcount=160

... I'm sure there are others

[jvriezen]

What is the format of the data?

Attached is a simple-to-use tool which accepts data in the following format:

RED1 RED2 RED3 BLUE1 BLUE2 BLUE3 RED_SCORE BLUE_SCORE

... and calculates all sorts of stats, including OPR, and outputs the results to a CSV file which can be opened directly in Excel.

Tell me what format your data is in and maybe I can make a few simple changes so it can process the whole batch for you.




Although I asked for better machine readable data, I was told this is the best it gets:

http://www.hightechkids.org/sites/default/files/FTC/2013/ColumbiaHgts/1-25-14%20ColumbiaHgts%20Match%20Results.pdf

There are four other similar pages for the other tournaments.

I did enter one tournament into Excel with columns:
Tourney#, Match #, Color, Score, Team#
(total of four rows per match)

This format can be easily adjusted, of course.

I also just realized I can copy/paste into a text file and get this:

Q-1 117-161 B
7972 8034
7661 2887
Q-2 11-82 B
6707 7000
4140 8005

That's:

Q-Match# RedScore-BlueScore WinningColor(R/B)
Red1 Red2
Blue1 Blue2

It gets a little messed up at page breaks in the PDF but that's trivial to fix.