|
|
|
 It doesn't matter if you write a thousand lines of code for a robot, if you didn't teach and/or inspire the HS students as you did it then you are not a mentor. - JamesBrown [more] |
 |
|
|||||||
|
||||||||
A ranking of FRC Teams based on their Average Season OPRs over the past 7 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's Yearly Scouting Databases, 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.
If we are to trust OPR, then 1114 and 2056 are by far the best teams of the past 7 years. If you're looking for a rough top 10, it goes something like this: 1114, 2056, 67, 987, 254, 469, 1717, 118, 148, and 1986.
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). Incorrect Locations 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.
Attached Files
-
OPR Team Rankings 2008-2013
6_Years_of_Average_OPRs.xlsx
download file
uploaded: 29-04-2013 12:47
filetype: lsx
filesize: 942.81kb
downloads: 873
-
Time Derated Z-Score Prediction
Time Derated Power Rating.xlsx
download file
uploaded: 02-03-2014 03:05
filetype: lsx
filesize: 616.66kb
downloads: 161
-
OPR Team Rankings 2008-2014 with 2015 Z-Score Prediction
7_Years_of_Average_OPRs + ratings.xlsx
download file
uploaded: 01-05-2014 20:44
filetype: lsx
filesize: 2.31MB
downloads: 396
-
OPR Team Rankings 2008-2015 with 2016 Z-Score Prediction
8_years wo calculation.xlsx
download file
uploaded: 20-09-2015 15:54
filetype: lsx
filesize: 2.26MB
downloads: 382
Discussion
view entire thread
29-04-2013 12:50
Basel A
Re: paper: OPR-based Ranking of FRC Teams over 2008-2013
I created this spreadsheet for use in a discussion of the top 10 FRC teams of all time, but there seemed to be significant interest, so I updated it for 2013. Using raw data from Team 2834's Yearly Scouting Databases, 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.
If we are to trust OPR, then 1114 and 2056 are by far the best teams of the past 6 years. If you're looking for a rough top 10, it goes something like this: 1114, 2056, 987, 67, 254, 469, 111, 1717, 25, & 33.
Remember that OPR isn't perfect or close. Don't take the results too seriously.
Includes filtering by location (state and/or country). Incorrect Locations should be minimal to non-existent, but please let me know about errors. Only the USA and Canada can be filtered by state/province. All other countries use "Other" as the state.
29-04-2013 12:55
Joe Ross
Re: paper: OPR-based Ranking of FRC Teams over 2008-2013
By default, the filtering is only showing Michigan. If you can't find your team, set the filters to all.
29-04-2013 12:56
Akash Rastogi
Re: paper: OPR-based Ranking of FRC Teams over 2008-2013
Cool resource to look at, Basel. The ranking by state is also fun to look at.
29-04-2013 12:58
Adam Freeman
Re: paper: OPR-based Ranking of FRC Teams over 2008-2013
Basel,
Pretty impressive spreadsheet. It's a very interesting way of trying to objectively determine the top teams. I'm not sure OPR was extremely representative in all years 2008-2013, but much better than nothing that's for sure.
Without really looking at every team and their position, it would be really hard to argue with a teams position +/- a small (5?, 10?) # of spots.
Very cool, thanks!
01-05-2014 20:55
Basel A
2014 Update
Updated this to include the 2014 data. Also added Z-Score Prediction based on a time-derated average (the same system Jim uses in his CMP history chart).
Top 10 got shaken up a bit, probably because the 2014 OPRs are simply awful, almost as bad as 2009. Which is fine, because this is just for fun.
P.S. Why would you download the old ones? Don't download the old ones..
view entire thread
Tags
loading ...