paper: FIRST Championship History Results

[JamesBrown]

Originally Posted by Adam Freeman

Jim,

Thank you! I alway love looking into this data and trying to determine which team is #1. Congratulations to Wildstang for taking over the title....for this year.

One error I noticed was, in the data for Archimedes you have 2106 instead of 2016.

Also, I am not exactly sure how the weighted data is calculated but we seem to be taking a significant dive in value compared to other past year champions, even though we had similar performances. I guess when you pull ahead by so much, the expectations are that much higher.

Interestingly enough 217 is showing a decline, even though they did better this year than last year. Yet, 469 shows an improvement even though they declined compared to last year.

Interesting, thanks.

I think that 67 ran into the problem of not having room to improve, appearances in the Einstein finals in a row is tough to top, 217 benefits from having a down year last year (if you can call division finalist a down year).

If I wanted to calculate 78's ranking including when they were part of 121 can I just add their 11 year derated points? I assume I can because there is no overlap in the years they made eliminations (121 made it 220-the split, 78 made it the two years since the split), including results before the split 78 jumps up to 13/14 with 33 and 330.

[martin417]

Originally Posted by thefro526

Thanks for posting such an interesting database.

I noticed a few mistakes though, it seems that the database has us (816) listed as the 11th pick in the Curie 09 draft, when we were the 6th Alliance Captain. Also I believe the draft position of 1771 is wrong as well. Probably won't change anything, but it caught my eye.

Yes, in 2009, 1771 was the #1 pick draft selection on Curie

[Jim Zondag]

Thanks for the updates. I reposted this file with a couple of updates to the 2009 tab. In 2009, we had someone record all the alliance pairings, but I couldn't ever find the notebook they were written in when we got back from Atlanta. I thought I had all the corrections when I posted this last year, but perhaps not.

This is one of my biggest beefs with FIRST's data: the draft order is very important but is not presented anywhere in the official data. Bizarre.

Adam, the weighted average is really just a guess. Obviously history matters in overall team quality assessments, but stuff that happened 10 years ago is clearly much less relevant than what happened this year. The weighted average uses a 2/3 (66.7%) derating for each year. Thus if you got 50 points this year, it would still be worth 33 point next year, 22 points the year after that, etc. More details on the "Notes" tab. It will help boost your score way up if you do good things consecutively (like say, winning the Championship twice in a row ). Kind of like bowling.

Why 66.7%? It seems about right based on my judgement, 50% seems too low, but this is a hard thing to prove mathematically.

In 67's case, you had 161 points acculated last year, the highest ever, which are now worth 107 (-54) this year, plus 25 more this year = 132.
217, while outperforming last year, still lost a little ground due to continued derating of their 2008 & 2009 peak data.
The best score possible if you use this system is 198, but you would need to be world champion for 10 years straight to achieve this.

If anyone wants to play around with this, just change the value in cell Z1 on tab "11 year history results" and resort the results. Higher makes the totals linger longer, small makes them decay faster. Fun with math.

Regardless, there is no doubt that the small group of teams at the top are the very best in the world. Congrats to you all!

[Jim Zondag]

Attached is the updated Championship History Results Spreadsheet.
I have included all of the results of CMP Elimination rounds for 2012, it now includes 12 years of data.

Team #67 moves back into first place on both the Total Points Accumulated, and the Annually Derated Total. Team HOT is awesome as always.

439 teams have played in the CMP elimination rounds since 2001 out of 1184 total possible openings in this 12 year period.

The strongest indication that a team will play in next year's CMP Elimination rounds is whether they played in this years Elimination rounds. If only the FRC enrollment system allowed a better way to get everyone to the event, this would be even more true. It is tragic that 3 of our all time top 20 could not even get in to the 2012 CMP.

Enjoy.

[Zebra_Fact_Man]

Thank you Jim! This data is spectacular. It is almost impossible to find any data regarding years before 2003.

Sooo much detail!

[Peter Matteson]

Jim,
Once again I'm glad to see an update to this and shocked with how fast you were able to get this posted.

Also I did notice a typo. 2012 is listed as 2011 so if you need to update it for something else you can fix that too.

Pete

The typo/copy-paste error is on the 12 year history table.

[Gary Dillard]

Thanks Jim - this historical data is hard to come by and I missed this before. I found something interesting here (at least to me) - the last time 180 was on Einstein (2002) they beat a pretty good alliance in the semi-finals.....
233, 25, 118

[Grim Tuesday]

Originally Posted by Gary Dillard

Thanks Jim - this historical data is hard to come by and I missed this before. I found something interesting here (at least to me) - the last time 180 was on Einstein (2002) they beat a pretty good alliance in the semi-finals.....
233, 25, 118

Funny how history repeats its self.

[nuggetsyl]

Originally Posted by Grim Tuesday

Funny how history repeats its self.

It was so hot that day and those matches we got hammered. We redesigned our robots drivetrain and evil machine 1.0 came out in 03

[Gary Dillard]

Originally Posted by nuggetsyl

It was so hot that day and those matches we got hammered. We redesigned our robots drivetrain and evil machine 1.0 came out in 03

Ah yes, the pre-CIM days when the teams from the north would come down and fry their FP's and Bosch's that had been running in the cold all winter.

[nuggetsyl]

16 needs to be fixed for 2012

[Jim Zondag]

Updated FRC Championship History Results Spreadsheet.
Complete results of Elimination Round Performance from 2001-2013
Notable points:
- Team 67 Remains in the #1 position as "best team ever" on both the Derated Points Scale and the Total Point Scale
- 987 moves into #2 position, passing 254, 233, and 1114.
- Overall grouping of the top 20 is much tighter this year, indicating that the level of compeition in CMP Elims was more closely balanced than in the past.
- interestingly, a total 469 teams have competed in CMP Elims in 13 years

[Marc S.]

This is an awesome ranking system, thank you so much for doing this!

[qzrrbz]

Is there enough information about IRI to be able to add that to this sheet, too?

[SIIENGINEER]

Jim...Thanks for putting this together. I only have a ??? it shows that 16 was a QF last year 2012. Should that not show them as WC?

Again...Thank you very much for taking the time to gather and present these #'s for us.