paper: 2006 Excel Scouting database

[Greg Needel]

Originally Posted by 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.

you are 100% correct my database doesn't take this into account and after thinking about adding the functionality i decided it is not necessary. The only thing that it will cause is a slight shift in real time ranking which is not a big deal. IMO those real time ranks that align with the FIRST rankings are good but since you are going to be behind with data entry anyway having someone checking the real rankings board is probably not a bad idea anyway. This being said if there are a ton of people who think this bug needs to be fixed i will have no problems fixing it.