Skip to content

Instantly share code, notes, and snippets.

@phil-lopreiato

phil-lopreiato/Archimedes-teams.csv

Last active August 29, 2015 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phil-lopreiato/d69e9d6a23d548597147 to your computer and use it in GitHub Desktop.
Save phil-lopreiato/d69e9d6a23d548597147 to your computer and use it in GitHub Desktop.
Download ZIP
2015 CMP Teams
Raw
Archimedes-teams.csv
41 51 68 108 115 122 135 188 201 207 217 234 280 314 360 378 503 623 691 836 857 931 1023 1089 1310 1322 1538 1572 1640 1648 1700 1701 1706 1714 1785 2013 2220 2338 2342 2363 2383 2522 2605 2619 2655 2848 2907 2914 2974 3103 3238 3278 3284 3322 3357 3602 3996 4010 4201 4207 4213 4334 4364 4451 4977 5048 5162 5212 5403 5464 5505 5536 5571 5581 5667 5687 5692
Raw
Carson-teams.csv
16 20 60 67 85 93 173 203 225 236 246 254 375 399 418 467 558 973 999 1058 1241 1296 1306 1325 1458 1501 1510 1511 1519 1629 1710 1711 1730 1885 2075 2085 2283 2377 2471 2521 2534 2601 2905 3256 3339 3478 3481 3506 3547 3604 3728 3880 3946 4028 4215 4488 4499 4574 4587 4818 4953 4980 5053 5059 5122 5254 5338 5406 5416 5510 5549 5625 5655 5659 5696 5719
Raw
Carver-teams.csv
66 71 75 126 128 144 172 193 216 233 329 337 359 368 585 771 829 971 1024 1208 1369 1425 1592 1625 1717 1718 1768 1868 1884 1986 2130 2337 2491 2630 2648 2767 2834 2852 2876 3140 3324 3352 3419 3504 3507 3512 3536 3566 3653 3721 3802 3844 3881 4001 4039 4183 4253 4381 4384 4536 4721 4911 4915 4945 4967 5260 5291 5402 5431 5437 5442 5458 5465 5515 5546 5689
Raw
Curie-teams.csv
56 57 70 88 107 120 123 148 176 228 230 271 303 339 341 369 379 610 649 701 702 708 842 900 948 1086 1114 1156 1305 1318 1319 1506 1574 1622 1816 1923 2046 2457 2557 2594 2994 2996 3008 3193 3309 3452 3495 3663 3937 3959 3974 4048 4061 4073 4080 4143 4146 4355 4450 4468 4498 4593 4595 4613 4653 4909 5046 5407 5472 5572 5585 5586 5603 5654 5735 5737
Raw
Galileo-teams.csv
1 27 45 102 111 191 219 237 245 330 365 384 492 494 525 568 597 604 744 862 876 967 1002 1011 1189 1477 1540 1547 1595 1619 1649 1690 1726 1777 1902 2052 2056 2067 2168 2375 2451 2502 2626 2836 2990 3026 3142 3146 3175 3288 3337 3397 3410 3492 3562 3618 3668 3674 3770 3787 3944 4198 4373 4719 4920 4961 5114 5216 5421 5429 5460 5498 5541 5554 5584 5725
Raw
Hopper-teams.csv
11 33 78 103 125 166 223 263 343 469 548 573 781 811 987 1124 1218 1391 1533 1676 1723 1746 1796 1817 2016 2064 2169 2183 2228 2344 2500 2512 2530 2531 2590 2609 2614 2783 2826 2830 3042 3098 3255 3266 3501 3620 3683 3688 3735 3939 3950 4130 4265 4329 4362 4391 4405 4486 4550 4589 4731 4799 4918 4930 5015 5024 5118 5318 5413 5428 5454 5493 5509 5562 5576 5771
Raw
Newton-teams.csv
25 74 100 118 133 155 175 190 195 269 295 321 533 537 540 587 932 955 1094 1111 1466 1671 1678 1720 1741 1756 1918 1983 2039 2158 2339 2468 2607 2761 2877 3015 3039 3130 3137 3171 3310 3314 3464 3467 3539 3574 3641 3783 3785 3838 3940 4013 4118 4188 4322 4471 4501 4522 4541 4575 4678 4841 4842 4903 4954 5012 5027 5188 5418 5479 5489 5495 5511 5526 5529 5710
Raw
team-spliy.py
import csv
import xlrd
teams = {}
teams['Archimedes'] = []
teams['Carson'] = []
teams['Carver'] = []
teams['Curie'] = []
teams['Galileo'] = []
teams['Hopper'] = []
teams['Newton'] = []
teams['Tesla'] = []
workbook = xlrd.open_workbook('all-teams.xlsx')
for sheet_name in workbook.sheet_names():
sheet = workbook.sheet_by_name(sheet_name)
for row in range(4, sheet.nrows)[0::2]:
team_number = sheet.cell_value(row, 2)
division = sheet.cell_value(row, 3)
teams[division].append(team_number)
for division, teams in teams.iteritems():
print "{}: {} teams".format(division, len(teams))
with open(division + "-teams.csv", 'wb') as csvfile:
writer = csv.writer(csvfile, delimiter=',')
writer.writerow(teams)
Raw
Tesla-teams.csv
48 58 141 171 226 244 292 319 340 358 612 624 668 706 1025 1225 1255 1311 1323 1403 1502 1515 1523 1610 1647 1658 1806 1836 2054 2059 2062 2122 2137 2170 2191 2399 2415 2481 2486 2526 2587 2613 2635 2658 2875 2883 2930 2950 2959 2960 2992 3132 3184 3250 3360 3476 3656 3824 3847 3941 4003 4050 4256 4481 4571 5006 5072 5314 5415 5422 5528 5582 5627 5678 5712 5730
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment