Quote:
Originally Posted by Gaurav27
Please see the attached Excel spreadsheet for weeks 1 through 4 OPR. (Excluding Hawaii)
It has filters to rank by hybrid, bridge, teleop. and total. (Excluding Hawaii, even for the 'total')
It includes multiple entries for teams that have competed at more than one regional.
Feel free to change it up and add any functionalities. (i.e sort by regional, etc.)
Once again, thanks to Bongle for his work on OPR over the years to make it very easy to use and comprehend.
|
Interesting things show up in the spreadsheet you posted because teams have multiple entries. It's a bit easier to see consistency (although to be in the top 100 I limited it to, you're pretty consistent already if you made it there twice). These teams show up more than once (I know this isn't perfect because there are some awesome teams out there that haven't competed twice yet):
- 67 claims the top two spots.
- 341 claims THREE spots in the top 10 (4,6,9)
- 2056 claims two spots in the top 10 (3,7)
- #: Rankings
- 16: 38 and 42
- 48: 28 and 43
- 148: 73 and 75
- 340: 45 and 59
- 365: 11 and 82
- 399: 44 and 57
- 469: 19 and 39
- 488: 29 and 72
- 610: 30 and 93
- 967: 66 and 95
- 1114: 14 and 22
- 1208: 87 and 88
- 1218: 40 and 41
- 1477: 25 and 63
- 1507: 12 and 17
- 1629: 24 and 79
- 1714: 53 and 70
- 1983: 5 and 16
- 1986: 13 and 36
- 2169: 27 and 56
- 2474: 10 and 46
- 2826: 52 and 74
Together, these 25 teams account for 51 spots in the top 100.