Week1 Final Scores OPR

[Ether]

Originally Posted by Ether

Here is a ZIP file containing the component OPR scores.

The columns are as follows:

Team Number, Final Score, Qual, Coop, Auto, RC, Tote, Litter, DQ

South Florida (FLFO) and Lake Superior (MNDU) are missing: I'm pondering the best way to handle the surrogate team data (in the Match Results) with the Rankings data (which doesn't have surrogate data).

Please let me know if you spot any errors.

Here's a ZIP of the same data, but in CSV format so it can be opened directly in Excel (if file association is set).

Note: Ed Law and I have been exchanging PM's the past few minutes. Our computations do not agree completely. We're discussing it.

[Spoam]

Originally Posted by Ether

Here's a ZIP of the same data, but in CSV format so it can be opened directly in Excel (if file association is set).

Note: Ed Law and I have been exchanging PM's the past few minutes. Our computations do not agree completely. We're discussing it.

This is interesting. Our computations agree with yours. How is Ed doing the calculations?

[Ether]

Originally Posted by Spoam

Our computations agree with yours. How is Ed doing the calculations?

http://www.chiefdelphi.com/forums/sh...97&postcount=5

Ed takes great pains to handle special cases like DQ's and surrogates, and does so in a manner that is as consistent as possible from year to year.

I don't have Ed's remarkable patience and attention span, so the calculations I did don't have special-case handling for DQ/surrogate and so they won't agree exactly with Ed's for events with DQ's and/or surrogates.

Ed's numbers are the de facto official OPR numbers for FRC, so always use them when they are available.