Chief Delphi

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   Extra Discussion (http://www.chiefdelphi.com/forums/forumdisplay.php?f=68)
-   -   paper: Einstein History (http://www.chiefdelphi.com/forums/showthread.php?t=148849)

Hitchhiker 42 08-06-2016 18:33
paper: Einstein History
 
Thread created automatically to discuss a document in CD-Media.

Einstein History by Hitchhiker 42

maxnz 08-06-2016 18:34
Re: paper: Einstein History
 
Found a typo: 2052 is from MN, not MA.

marshall 08-06-2016 18:43
Re: paper: Einstein History
 
Thanks for this! Love the data.

lynca 09-06-2016 12:28
Re: paper: Einstein History
 
Great information. Sorting by appearances on Einstein.
233 and 2056 are due for a Win!

Quote:
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 09-06-2016 13:38
Re: paper: Einstein History
 
Quote:
Originally Posted by maxnz (Post 1592004)
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 09-06-2016 14:54
Re: paper: Einstein History
 
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

Hitchhiker 42 09-06-2016 15:41
Re: paper: Einstein History
 
Quote:
Originally Posted by Jake177 (Post 1592126)
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.

mipo0707 09-06-2016 16:42
Re: paper: Einstein History
 
33 should have a win too with 233 and 2056

Citrus Dad 09-06-2016 17:38
Re: paper: Einstein History
 
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 09-06-2016 18:35
Re: paper: Einstein History
 
Quote:
Originally Posted by Citrus Dad (Post 1592150)
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
Code:
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 09-06-2016 21:03
Re: paper: Einstein History
 
Quote:
Originally Posted by Jefferson (Post 1592155)
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 09-06-2016 22:48
Re: paper: Einstein History
 
Quote:
Originally Posted by Citrus Dad (Post 1592150)
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 10-06-2016 12:40
Re: paper: Einstein History
 
Thanks for the data!

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

Hitchhiker 42 10-06-2016 13:27
Re: paper: Einstein History
 
Quote:
Originally Posted by jgerstein (Post 1592256)
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 10-06-2016 14:20
Re: paper: Einstein History
 
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 10-06-2016 14:36
Re: paper: Einstein History
 
Quote:
Originally Posted by SteveGarward (Post 1592275)
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 10-06-2016 15:26
Re: paper: Einstein History
 
Awesome work Mark! It's fun to pass the time looking at this data and analyzing for my own conclusions!

Jake177 10-06-2016 15:46
Re: paper: Einstein History
 
Quote:
Originally Posted by Hitchhiker 42 (Post 1592279)
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 10-06-2016 16:05
Re: paper: Einstein History
 
Quote:
Originally Posted by Jake177 (Post 1592292)
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 10-06-2016 16:20
Re: paper: Einstein History
 
You may be interested in comparing your data against this: https://www.chiefdelphi.com/media/papers/3263

MARS_James 10-06-2016 18:24
Re: paper: Einstein History
 
Quote:
Originally Posted by mipo0707 (Post 1592148)
33 should have a win too with 233 and 2056
..... from when?

mipo0707 10-06-2016 18:37
Re: paper: Einstein History
 
Quote:
Originally Posted by MARS_James (Post 1592313)
..... from when?
No I mean like they all are long due to win worlds

Lexlukener 29-06-2016 13:01
Re: paper: Einstein History
 
Another typo 4265 is from TN not MA

smitikshah 29-06-2016 14:00
Re: paper: Einstein History
 
Quote:
Originally Posted by Lexlukener (Post 1594892)
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 19-08-2016 16:32
Re: paper: Einstein History
 
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 21-08-2016 16:01
Re: paper: Einstein History
 
Quote:
Originally Posted by lynca (Post 1592095)
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 21-08-2016 16:05
Re: paper: Einstein History
 
Quote:
Originally Posted by Paul Copioli (Post 1602142)
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 21-08-2016 20:44
Re: paper: Einstein History
 
Quote:
Originally Posted by lynca (Post 1592095)
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 22-08-2016 00:58
Re: paper: Einstein History
 
Quote:
Originally Posted by mipo0707 (Post 1602183)
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 22-08-2016 02:46
Re: paper: Einstein History
 
Quote:
Originally Posted by Kpchem (Post 1602194)
Maybe I've just missed something, but why won't 233 be able to win now?
This was their last year in FRC. :(

logank013 22-08-2016 10:23
Re: paper: Einstein History
 
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 22-08-2016 11:18
Re: paper: Einstein History
 
Quote:
Originally Posted by logank013 (Post 1602214)
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 22-08-2016 12:17
Re: paper: Einstein History
 
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.


All times are GMT -5. The time now is 07:12.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi