Quote:
Originally Posted by The Lucas
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...[snip]
|
Shouldn't there be a further method of determining the cutoff? For instance, 1640 is currently sitting at
28 (assuming worst case that the MO Chairman's winner is ranked under us). This means, I think, that
25 teams (minimum) need to move above us, putting us at 53. The least number of points this requires is
827, under the overall point remainder of 987. Have I done this correctly?
However, this leapfrogging (at its minimum) requires
10 teams to earn 40 or more points at Mount Olive and another 8 to earn 30 or more (2 in the 20s, and 5 in the 10s). There should be some mathematical limit to the points one team can acquire, and another limit to the number of teams who can earn, say, 40 points.
I'm working on figuring this out. (Thought I had it there for a while...) Is this what you're doing in columns Q-AB?