Quote:
Originally Posted by Patrick Flynn
I've added new columns to the spread sheet using each teams MAX OPR as displayed in Ed Law's sheet*.
Then summed the score for each alliance and displayed who would win based strictly on OPR.
Any recommendations for how to total the points that each team would receive and tally these other than by hand?
*Thanks for the data Ed!
|
Unfortunately, the OPRs listed on the
this spreadsheet at the moment aren't quite right. In fact, according to Mathematica,
Union[N[Round[10 ToExpression[#]]/10] & /@
StringSplit["(*OPRs from spreadsheet with spaces added before -'s*)"]]
Every single team in Galileo has one of the following OPRs, and that's after 27 and 45 changed all of their OPRs to what I assume is the correct value.
{-15.3, -2.2, 20.1, 23.5, 33.3, 37.6, 56., 83.9}
I don't know enough of data management in Excel to conjure correct values at the moment, but I'm sure there are people that can help.
- Harrison