I have uploaded the Week 3 results. Please note that Peachtree Regional did not post the Standings. I calculated the standings based on match results. (You do that by using macro shortcut SHIFT-CRTL-R after you manually refresh the qualifying round data.) However if there are extra matches, it will still go into the standings because I would not know which match does not count. However it will not affect the OPR and CCWM data since all match data are used to calculate them.
I have also put in the links for Week 4 regionals and unless I made a mistake, they should all work. I need to write macros to create these links. It is very tedious to add the links manually and it is possible to make mistakes. Team 2834 will be going to Detroit District Competition. I will be busy this week since we have to work on the robot for 8 hours. I will not have time to change the database. However if someone finds an error in the spreadsheet, I will fix it as soon as I can.
I was looking at the results of the Cass Tech and I was amazed by the selection. It seems that the CCWM correlates extremely well with whiich teams were picked. Many teams that were ranked high were skipped. Except for one team, the teams that were skipped all had negative CCWM. It means either all Alliance Captains have access to this data (which I doubt that many teams actually use these data) or they can tell those teams were not that helpful to their partners in the qualifying round. Here are the numbers.
PHP Code:
Avg Score OPR OPR Rank Avg WM CCWM CCWM Rank Record Regional Rank Alliance Finish
28.6 50.9 1 16.1 50.3 1 (11-0-1) 1 of 40 Alliance Captain 1 Regional Winner
24.6 38.9 3 8.6 27.2 3 (10-2-0) 2 of 40 # 1 pick Regional Winner
23.4 33.0 4 7.3 17.0 4 (9-2-1) 3 of 40 Alliance Captain 2 Finalist
25.5 42.7 2 12.6 44.3 2 (8-3-1) 4 of 40 Alliance Captain 3 Semi Finalist
16.8 16.6 19 1.1 8.5 8 (7-3-2) 5 of 40 Alliance Captain 4 Semi Finalist
16.9 17.5 15 1.4 11.1 7 (8-4-0) 6 of 40 # 4 pick Semi Finalist
18.8 17.0 17 2.0 2.7 18 (7-4-1) 7 of 40 Alliance Captain 5 Quarter Finalist
18.4 18.9 13 2.1 6.2 12 (7-4-1) 8 of 40 Alliance Captain 6 Quarter Finalist
16.4 14.2 24 0.3 0.1 21 (7-4-1) 9 of 40 Alliance Captain 7 Quarter Finalist
21.3 29.1 6 2.2 4.7 15 (7-4-1) 10 of 40 # 6 pick Quarter Finalist
18.2 22.4 11 0.2 4.6 16 (7-4-1) 11 of 40 Alliance Captain 8 Quarter Finalist
21.2 25.9 8 4.1 8.2 9 (7-5-0) 12 of 40 # 7 or 10 pick Quarter Finalist
17.3 14.7 22 -1.4 -7.8 29 (7-5-0) 13 of 40
23.0 33.0 5 6.3 13.4 5 (7-5-0) 14 of 40 # 5 or 12 pick Quarter Finalist
16.6 15.0 21 -0.3 -2.1 23 (7-5-0) 15 of 40 # 13 pick Semi Finalist
17.3 11.0 31 -0.5 -11.5 30 (7-5-0) 16 of 40
15.6 14.4 23 0.4 5.5 13 (7-5-0) 17 of 40 # 8 or 9 pick Quarter Finalist
17.3 13.9 25 -0.5 -7.0 28 (6-5-1) 18 of 40
17.3 16.3 20 0.0 0.5 20 (5-5-2) 19 of 40 # 12 or 5 pick Quarter Finalist
15.9 6.4 35 -3.8 -19.2 37 (6-6-0) 20 of 40
17.4 18.2 14 0.1 4.4 17 (6-6-0) 21 of 40 # 10 or 7 pick Quarter Finalist
19.8 26.1 7 2.7 12.2 6 (6-6-0) 22 of 40 # 3 or 14 pick Semi Finalist
16.8 11.6 30 0.8 -4.3 25 (5-5-2) 23 of 40 # 9 or 8 pick Quarter Finalist
17.8 24.2 10 -0.1 8.1 10 (6-6-0) 24 of 40 # 11 pick Quarter Finalist
16.6 13.2 27 -1.8 -6.5 27 (6-6-0) 25 of 40
19.7 22.0 12 2.3 5.1 14 (5-7-0) 26 of 40 # 14 or 3 pick Semi Finalist
18.4 24.6 9 0.6 6.6 11 (5-7-0) 27 of 40 # 2 or 15 pick Finalist
16.3 17.1 16 -1.8 0.1 22 (5-7-0) 28 of 40 # 16 pick Regional Winner
13.9 2.4 39 -2.4 -11.6 31 (5-7-0) 29 of 40
16.4 13.4 26 -1.1 -3.0 24 (4-7-1) 30 of 40
Ed Law