I've updated the Google Drive Spreadsheet earlier in the thread to include a calculation of district event points for the Sacramento event.
I picked Sacramento as it's mid-season, and all 3 members of the finalist alliance already had bids to CMP.
Two caveats:
- Google Sheets doesn't have an inverse error function, so I had to approximate it using a not-as-complicated formula as I'd like. As a result there are some minor errors in the values, but it doesn't appear to affect anything but the last placed team (got a 3 instead of a 4 -- I checked several other values with Wolfram Alpha).
- I did not add the "season-wide" district points for rookie and 2nd year teams. I believe the intent here is to evaluate the play on the field, and those points were not listed on the proposal, but I did add judged award points as listed on the proposal (excluded Chairman's RAS, EI).
- The DP tiebreaker is not factored in the sort on the spreadsheet
On a point basis... some interesting things:
- Winning alliance took positions 1, 2, and 5 in the DP ranking
- Finalist alliance took 3, 4, and 13th in the ranking. (3rd team was qual rank 26/60 with no awards)
- After all automatic and previously-awarded bids to CMP are factored in, 701 (sf 1st pick) would get the wildcard for the 2016 rules. Team 3250 (qf 1st pick) the additional under 2017 rules.
- The next teams, should other WCs had been generated would be 3669 (sf captain), 1056 (sf captain), 4094 (qf captain), and 4543 (qf 1st pick)
All in all I'm surprised the alliance captains didn't get more of a boost, and that award points played a significant result. Without them 701 and 3250 would not be anywhere close to in the running for a wildcard slot.
I'm interested to see what the rookie / 2nd year points boosts do. If someone wants to know, either post here, or PM me the team # ranges for rookies and 2nd year teams for 2016. I'm just too tired to go looking right now.
