I pulled down a copy of the Gdoc and did some calculations to determine who has clinched qualification in the MAR championship. If these calculations (mine and the point totals from the Gdoc) are correct...
Congrats to 1168, 2607, 2729 and all other teams with
58 pts or more. You have mathematically clinched a berth in the MAR championship.
A little background on my method of calculation. First I calculated the points remaining in MAR: 42 (number of teams at Mt. Olive) * 2 (# of qual matches is twice # the teams) * 6 (possible pts per match) + 483 pts (e.g. awards, elim performance, alliance selection) = 987 possible pts left in MAR.
Next for each team high in the rankings, calculate the minimum number of pts needed for enough Mt. Olive teams to tie them in the rankings to possibly force that team out of MAR Championship on tie breakers. If this min pts is greater than 987, then that team has clinched a berth. For example, it would take 1047 pts for the next 29 active teams to tie the 3 teams tied at 58 pts (ranked 19-21). The 29 teams takes into account Chairman's winners current ranked below them (433 & 11) and assumes the Mt. Olive Chairman's winner is not one of those 29 teams or any teams currently ranked above them. I looks good for teams tied at 57 pts (especially active Team 222), since the min number is 971 which is just short of the 987 possible. All pts accumulated by already qualified teams reduces the cutoff point.
I attached my spreadsheet. The clinching teams are highlighted in green, and the one that are currently in (w/o Mt. Olive) are highlighted in orange. The array of numbers to the right of each team's total points are used for the pt calculations. Please tell me if I made any mistakes and feel free to extend the sheet however you want (live updates as Mt. Olive is happening, maybe
).
Quote:
Originally Posted by scottandme
41 teams (assuming no 896) finish the MAR qualifying season at Mount Olive this weekend.
|
I believe 896 is currently going to Mt. Olive since it is much closer to their school and they will have 6 more hours to work on their bot.