|
|
|
 Totally agree on the fact that legal strategies are... legal. - Kevin Sevcik [more] |
 |
|
|||||||
|
||||||||
By: Hitchhiker 42
New: 06-06-2016 08:27 PM
Updated: 08-22-2016 12:19 PM
Total downloads: 238 times
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.
Attached Files
-
state strength.xlsm
state strength.xlsm
download file
uploaded: 08-19-2016 04:32 PM
filetype: lsm
filesize: 53.73kb
downloads: 146
-
Einstein/National History 1992-2016
state strength.xlsm
download file
uploaded: 08-22-2016 12:19 PM
filetype: lsm
filesize: 52.29kb
downloads: 90
Discussion
view entire thread
06-09-2016 12:28 PM
lynca
Re: paper: Einstein History
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 |
06-09-2016 01:38 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by maxnz
Found a typo: 2052 is from MN, not MA.
|
EDIT: I just took a look and I think it's fine. It says MN for them.
06-09-2016 02:54 PM
Jake177
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
06-09-2016 03:41 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by Jake177
|
06-09-2016 05:38 PM
Citrus Dad
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.
06-09-2016 06:35 PM
Jefferson
Re: paper: Einstein History
|
Originally Posted by 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.
|
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
06-09-2016 09:03 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by Jefferson
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
|
06-09-2016 10:48 PM
Brian Maher
Re: paper: Einstein History
|
Originally Posted by Citrus Dad
New Jersey (51) ... Michigan is only a bit bigger than NJ but scores 170.
|
06-10-2016 12:40 PM
jgerstein
Re: paper: Einstein History
Thanks for the data!
Just a quick note, 694 is from New York, not Ohio.
06-10-2016 01:27 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by jgerstein
Thanks for the data!
Just a quick note, 694 is from New York, not Ohio. |
06-10-2016 02:20 PM
SteveGarward
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.
06-10-2016 02:36 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by 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. |
06-10-2016 03:26 PM
smitikshah
Re: paper: Einstein History
Awesome work Mark! It's fun to pass the time looking at this data and analyzing for my own conclusions!
06-10-2016 03:46 PM
Jake177
Re: paper: Einstein History
|
Originally Posted by Hitchhiker 42
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?
|
http://www.thebluealliance.com/event/2003cmp#awards
2003 is also missing the SF teams: 236, 341, 175, 378, 292, 302
06-10-2016 04:05 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by Jake177
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 |
06-10-2016 04:20 PM
Joe Ross
Re: paper: Einstein History
You may be interested in comparing your data against this: https://www.chiefdelphi.com/media/papers/3263
06-10-2016 06:24 PM
MARS_James
Re: paper: Einstein History
|
Originally Posted by mipo0707
33 should have a win too with 233 and 2056
|
06-10-2016 06:37 PM
mipo0707
Re: paper: Einstein History
|
Originally Posted by MARS_James
..... from when?
|
06-29-2016 02:00 PM
smitikshah
Re: paper: Einstein History
|
Originally Posted by Lexlukener
Another typo 4265 is from TN not MA
|
http://imgur.com/UFeJ667
08-19-2016 04:32 PM
Hitchhiker 42
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.
08-21-2016 04:01 PM
Paul Copioli
Re: paper: Einstein History
|
Originally Posted by lynca
Great information. Sorting by appearances on Einstein.
233 and 2056 are due for a Win! |
08-21-2016 04:05 PM
Hitchhiker 42
Re: paper: Einstein History
|
Originally Posted by Paul Copioli
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.
|
08-21-2016 08:44 PM
mipo0707
Re: paper: Einstein History
|
Originally Posted by lynca
Great information. Sorting by appearances on Einstein.
233 and 2056 are due for a Win! |
08-22-2016 12:58 AM
Kpchem
Re: paper: Einstein History
|
Originally Posted by mipo0707
233 won't be able to win now...
|
08-22-2016 02:46 AM
asid61
Re: paper: Einstein History
|
Originally Posted by Kpchem
Maybe I've just missed something, but why won't 233 be able to win now?
|
08-22-2016 10:23 AM
logank013
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.
08-22-2016 11:18 AM
wajirock
Re: paper: Einstein History
|
Originally Posted by 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.
|
08-22-2016 12:17 PM
Hitchhiker 42
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.
view entire thread
Tags
loading ...