Re: paper: FIRST Championship History Results
 

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.

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

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!

Re: paper: FIRST Championship History Results
 

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.

Re: paper: FIRST Championship History Results
 

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

Sooo much detail!

Re: paper: FIRST Championship History Results
 

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.

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

Funny how history repeats its self.

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

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.

Re: paper: FIRST Championship History Results
 

16 needs to be fixed for 2012

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

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

Re: paper: FIRST Championship History Results
 

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.