paper: Einstein History

[Hitchhiker 42]

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

Einstein History (http://www.chiefdelphi.com/media/papers/3270?) by Hitchhiker 42

[maxnz]

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

[marshall]

Thanks for this! Love the data.

[lynca]

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

[Hitchhiker 42]

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

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.

[Jake177]

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

Curie (http://www.thebluealliance.com/event/2001cur#awards): 115, 217, 75, 60, 85
Galileo (http://www.thebluealliance.com/event/2001gal#awards): 177, 122, 59, 340, 53

[Hitchhiker 42]

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

Curie (http://www.thebluealliance.com/event/2001cur#awards): 115, 217, 75, 60, 85
Galileo (http://www.thebluealliance.com/event/2001gal#awards): 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.

[mipo0707]

33 should have a win too with 233 and 2056

[Citrus Dad]

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.

[Jefferson]

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

[Hitchhiker 42]

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


I'm proud of my little state...

[Brian Maher]

New Jersey (51) ... Michigan is only a bit bigger than NJ but scores 170.

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).

[jgerstein]

Thanks for the data!

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

[Hitchhiker 42]

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.

[SteveGarward]

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

[Hitchhiker 42]

111 has won 3 championships, including 2003. Looks like the data from 2003 on TBA is... not quite right. :) 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?

[smitikshah]

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

[Jake177]

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?

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

[Hitchhiker 42]

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!

[Joe Ross]

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

[MARS_James]

33 should have a win too with 233 and 2056

..... from when?

[mipo0707]

..... from when?

No I mean like they all are long due to win worlds

[Lexlukener]

Another typo 4265 is from TN not MA

[smitikshah]

Another typo 4265 is from TN not MA

I don't know what you're talking about - that's what it says.

http://imgur.com/UFeJ667

[Hitchhiker 42]

Hey, so I just updated the spreadsheet a little, to make it more formula-based, so its easier to add next year's teams on Einstein (gonna have to think about how we're gonna stretch that 2 Einstein thing [just wondering, will they still be called Einstein?]) </end rant>.

Basically, you can just type in next year's teams in the left-most column, and press update teams button to update the lists.

[Paul Copioli]

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

I don't know if it's Andrew's summary or the data, but 217 should have 7 appearances: 2001, 2005, 2006, 2008, 2009, 2011, 2016.

[Hitchhiker 42]

I don't know if it's Andrew's summary or the data, but 217 should have 7 appearances: 2001, 2005, 2006, 2008, 2009, 2011, 2016.

Just the summary; the full data sheet lists them as having 7 appearances.

[mipo0707]

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

233 won't be able to win now but 33 3476 2056 4039 1986 195 125 all need to win some time soon

[Kpchem]

233 won't be able to win now...

Maybe I've just missed something, but why won't 233 be able to win now?

[asid61]

Maybe I've just missed something, but why won't 233 be able to win now?

This was their last year in FRC. :(

[logank013]

Is there any reason that this sheet only goes back to 2000? I got confused when it said 71 only had 3 worlds wins but one was in 97 so it wasn't counter on the sheet.

[wajirock]

Is there any reason that this sheet only goes back to 2000? I got confused when it said 71 only had 3 worlds wins but one was in 97 so it wasn't counter on the sheet.

It is probably because there was no Einstein before 2001. The Championship back then was one event simply called the National Championship.

[Hitchhiker 42]

As an update, I'm uploading another version that goes back all the way to 1992. Keep in mind that TBA only had W/F or Winner for most of these.