paper: Einstein History

Thread created automatically to discuss a document in CD-Media.

Einstein History
by: Hitchhiker 42

This workbook summarizes Einstein history by each occurence, each team, each state (or province), and each country. Scores are generated based on appearances in quarterfinals, semifinals, finals, and winning.

The workbook pulls all Einstein appearances (data is drawn from TBA). Figures are listed from 2000-2016, and the highest level the team got to is also listed. Then, the data is sorted by appearances by team (winner, finals, semifinals, quarterfinals), by state/province, and by country. A score is generated based on the listed weights in the worksheet, which may be played with. This hopefully allows one to view how each team, state, and country has compared with each other over the past 16 years.

state strength.xlsm (53.7 KB)
state strength.xlsm (52.3 KB)
Einstein History.xlsm (56.1 KB)

Found a typo: 2052 is from MN, not MA.

Thanks for this! Love the data.

Great information. Sorting by appearances on Einstein.
233 and 2056 are due for a Win!

Team,#Times,wins,finals
217 6 2 1
177 6 2 1
67 6 3 1
25 6 2 2
1114 5 1 2
987 5 1 2
469 5 1 4
254 5 2 2
233 5 0 2
2056 4 0 1

1678 4 1 1
330 4 2 0
148 4 1 0
111 4 2 2
71 4 3 1
3476 3 0 0
968 3 0 1
144 3 0 1
118 3 1 0
33 3 0 2

Sorry about that. Will fix in a moment.

EDIT: I just took a look and I think it’s fine. It says MN for them.

Your 2001 data seems to be missing the semifinalist alliances (Curie and Galileo).

Curie: 115, 217, 75, 60, 85
Galileo: 177, 122, 59, 340, 53

Yes, you are right. TBA had only the data for the winners and finalists for 2001 and 2000. I will add the data right now. I would also appreciate it if someone could provide the 2000 semifinalists data.

33 should have a win too with 233 and 2056

Surprised to see that Ontario (54) and New Jersey (51) are so close. Ontario has a larger population, so its not at a disadvantage. Michigan is only a bit bigger than NJ but scores 170.

I did this because your comment made me curious. Thought others might be as well. Below is the people per point for each state. The real standouts are MI and CT


State	 Population/Score 
MI	 58,293 
CT	 71,934 
DE	 116,952 
NH	 132,681 
NV	 141,955 
NJ	 175,258 
IN	 188,482 
AR	 249,507 
CA	 253,611 
ON	 255,409 
MA	 281,059 
IL	 292,740 
NOR	 339,650 
OH	 362,318 
AZ	 517,806 
RI	 527,587 
NY	 598,371 
TX	 599,044 
FL	 621,666 
HI	 709,781 
SC	 805,414 
QBC	 826,360 
VA	 832,629 
NC	 903,997 
MN	 909,529 
PA	 913,372 
WI	 959,594 
CEN	 1,012,250 
MS	 1,492,463 
ID	 1,634,464 
TN	 1,637,338 
WV	 1,850,326 
OR	 1,985,120 
ALB	 2,098,250 
GA	 5,048,672 
MO	 6,063,589 
WA	 7,061,530 
NSW	 7,500,000

I’m proud of my little state…

In terms of general population, yes, Michigan is only a bit bigger than New Jersey. In terms of team count, Michigan boasts more than five times as many teams as NJ (411 vs 76).

Thanks for the data!

Just a quick note, 694 is from New York, not Ohio.

The worksheet has them down as from NY. I think you may have accidentally saw the row above them, 610 who are from ON.

111 has won 3 championships, including 2003. Looks like the data from 2003 on TBA is… not quite right. :slight_smile: The page on FIRST is not responding for me to check the source.

For 2003, both alliances are listed as finalists on TBA, and no winner. Should I switch that to both alliances as winners, or keep them this way?

Awesome work Mark! It’s fun to pass the time looking at this data and analyzing for my own conclusions!

If you look at the awards page, it shows the winning alliance (65, 469, 111) and the finalist alliance (25, 494, 343).
http://www.thebluealliance.com/event/2003cmp#awards

2003 is also missing the SF teams: 236, 341, 175, 378, 292, 302

Ok, thank you. I’m adding that to my data set right now. In general, if anyone has any data that’s missing from the spreadsheet, I’ll be happy to take it and fill it in!

You may be interested in comparing your data against this: https://www.chiefdelphi.com/media/papers/3263