[Btower]

A couple of things which I'm not sure are important for you purposes, but I felt I should say them anyway:

1. There is no provision for a DQ, which results in zero Qualifying and Ranking Points.
2. I'm not sure you are calculating ranking points accurately.

the rules this year:

First is Qualifing Points (QP's) you seem to have this correct.
Win - 2pt
Loss/DQ - 0pt
Tie - 1pt

In the event of a tie in QP's they use ranking points (RP's) which are awarded as follows:

Win - The lesser of Unpenalized Alliance Scores from either Alliance
Loss - Penalized score of losing alliance
Tie - Penalized score of own alliance.
DQ - zero

I just finished a backup scoring sheet in excel, what a pain to get all these difference in place.