30-04-2015 21:35

Jim Zondag

Re: paper: 2015 FRC Championship History

Attached is my annual FRC Championship History Summary.
This release covers all 15 years of data 2001-2015.
The dynasties of the FRC continue, but it is also great to see the trends of some of our new rising stars. Amazing upward trends by 1023, 2826 and most of all 1678. Congrats to Citrus Circuits for becoming our new Number 1 team, finishing just one point ahead of the legendary Simbots. The Three-peat Einstein appearances really add up.

Great job to the 3 teams 33, 254 and 469 for making it to CMP Elims ALL 15 years in a row, a very rare distinction.

I have 2 years to figure out how to do this with two Championships
Enjoy.

30-04-2015 21:38

Jus_McG-3193

Re: paper: 2015 FRC Championship History

As a student who is nearly obsessed with past FRC results and the history of teams/events, I look forward spending hours just combing through this information with such enthusiasm. I really appreciate the time and effort I'm sure was put into this, thank you.

30-04-2015 23:03

Anteprefix

Re: paper: 2015 FRC Championship History

The color coordination on the graphs are a nice touch. Great attention to detail.

01-05-2015 02:57

Navid Shafa

Re: paper: 2015 FRC Championship History

I always love going over this every year. Noticed a few errors:

*1983: Semi Finalists in 2013, not Quarter Finalists.

*71: World Champions in 2001 not World Finalists, I believe...

01-05-2015 06:02

Govind Girish

Re: paper: 2015 FRC Championship History

This is so useful. Thank you s omuch.

01-05-2015 09:18

Jake177

Re: paper: 2015 FRC Championship History

Thanks for keeping track of all this Jim.

The 2001 column on the "15 Year_History_Results" tab has several errors, despite accurate data in the "2001" tab. It looks like the lack of quarterfinals that year might be messing up the formula that populates the summary table.

01-05-2015 11:57

Bennett548

Re: paper: 2015 FRC Championship History

Jim,
How did you decide on the 33.33% yearly depreciation of past performance?
I can see an argument either to increase or decrease the impact of historic performance, so I'm wondering how you settled on that number.

01-05-2015 13:17

Navid Shafa

Re: paper: 2015 FRC Championship History

33 seems like a good number

01-05-2015 13:18

Andrew Schreiber

Re: paper: 2015 FRC Championship History

I recall he explained it because it meant that things that happened more than a student cycle ago didn't count for much.

Edit: That's why I've stolen that number for a lot of things I do too.

01-05-2015 13:43

Adam Freeman

Re: paper: 2015 FRC Championship History

Yep, says that exact thing right in the notes tab of the spreadsheet:

"An annual derating factor was applied to all past data. This causes the data from past years to have a diminishing effect on the current team standings. A weighing factor of 66.66% was used. This means that the current season carries 1/3 of the weight of a team's entire calculated history over long periods. This factor was determined somewhat subjectively, and is largely based on the fact that a team's student population will turn over completely every 4 years. Thus we do not want events from over 4 years ago having a significant impact on the current cumulative rankings."

01-05-2015 14:04

Bennett548

Re: paper: 2015 FRC Championship History

I understand the reasoning behind the diminishing effect, I was just curious about the value chosen. With the current number ~80% of a team's ranking comes from the most recent 4 years.

I don't think there is a number everyone can agree upon. I would use a bigger weight that 66%, so that older years have more weight. It seems to me that mentors and sponsors are a big part of a teams success, and that they have a slower turnover rate.

01-05-2015 14:31

GeeTwo

Re: paper: 2015 FRC Championship History

Also, not all teams are four years. There are many 3 year high schools, and schools with FTC teams as well. As I recall from The New Cool, 1717 members only compete one year. Others, such as the Girls of Steel, have an 8th grade apprentice program and are essentially a five+ year program. Probably most teams which mentor a "farm system" of FLL/FTC would tend to have more than a four year decorrelation time. All that said, -33% per year sounds reasonable to me.

01-05-2015 15:43

IKE

Re: paper: 2015 FRC Championship History

Making it larger makes it significantly harder for "up and comers" to get their value to a reasonable level. Follow 1678 to see a good example (or 3476, or 1640. It takes several years of high performance to get there. another perspective, look at the "total history chart" tab, and you will get a feel what it looks like if you do not use any historical derate.

It is a neat exercise to do, and I would highly recommend playing around with it. I remember talking to Jim about this several years ago when he started publishing it. He played around with a few different values and 2/3 seemed to be "about right".

12-04-2016 07:56

Peter Matteson

Re: paper: 2015 FRC Championship History

I was just browsing and noticed an error or inconsistency in the data.
177 is shown on the 15 year tab as division finalist in 2001 not division winner, however on the 2001 tab the data is correct showing the Galileo win.

The point values also look correct in the 15 year data sheet.

Also as I was about to submit this I noticed 125, 365, 71 & 294 are listed as WF instead of World Champ for 2001, also with the correct point value for world champ. 111 is however correctly listed.