As an exercise, I made up a google sheet that compares the existing NorCal advancement criteria with the criteria in my proposal. You can see it using
this link.
The Input/ Existing Method worksheet essentially shows the advanced teams from
the official NorCal FTC Advancement page. Highlighted teams advance. Teams in red text are the host teams. Teams that qualify multiple times at a tournament are highlighted in bright yellow.
At the time of this post, 18 teams (including 11 hosts) have qualified as indicated by a team having a Star on the official page and by highlighting in my google sheet. 2 Winning Alliance captains at 16-team tournaments are not among those 18 teams (though the advancement in the third 16-team San Jose #1 tournament went all the way down to Inspire #3!).
The Output/ Proposed Method worksheet shows the proposed method.
At the time of this post, the proposed method is trying to allocate the same 18 advancement spots. At the 28 team Saratoga tournament, teams down to Inspire #3 would advance (as in the existing method). The differences are that all Winning Alliance captains would advance, the Inspire #2s at the three 16-team tournaments would be in a tie for the final spot, and there would be no advancement below Inspire #2 at the three 16-team tournaments.
I'll try to keep this google sheet updated as more NorCal results come in throughout the season.
If I were king of NorCal FTC, I think I'd guarantee that all hosts, Inspire winners, and Winning Alliance captains advance the day of the tournament and also Inspire #2s for the 28 team tournaments [that would total 45 slots = 45 teams if there were absolutely no overlaps] and then use the proposed Weighted Ranking system to fill any remaining Wildcard spots at the end of the season.