Thread created automatically to discuss a document in CD-Media.
OPR-based Ranking of FRC Teams over 2008-2013
by: Basel A
A ranking of FRC Teams based on their Average Season OPRs over the past 10 years (each year equally weighted). Includes Average Season Z-score and Average Rank. Now includes Z-score Prediction based on a time-derated average.
I created this spreadsheet for use in a discussion of the top 10 FRC teams of all time, but it may prove interesting for everyone. Using raw data from Team 2834 and Caleb Sykes, I found the Average Event OPR for each team over each season. This data was used to rank teams by their average yearly rank and their average yearly z-score.
I’ve now added future Z-Score Prediction based on a time-derated average. This is the same system Jim Zondag uses in his CMP History Results. It’s a basic guess of how good a team will be in the next year. E.g. for 2015, it’s a time-derated average of 2008-2014 z-scores.
Remember that OPR isn’t perfect or close. Don’t take the results too seriously.
Includes filtering by location (state and/or country) or by district region. Incorrect locations or district are hopefully minimal to non-existent (PM me about any errors). Only the USA and Canada can be filtered by state/province. All other countries use “Other” as the state.
6_Years_of_Average_OPRs.xlsx (943 KB)
Time Derated Power Rating.xlsx (617 KB)
7_Years_of_Average_OPRs + ratings.xlsx (2.31 MB)
8_years wo calculation.xlsx (2.26 MB)
9_years_wo_calculation.xlsx (2.93 MB)
10_years_wo_calculation.xlsx (5.46 MB)
10_years_wo_calculation.xlsx (4.4 MB)