This is for Judges that judge a state cheerleading competition. They will still us the “paper” based sheet to score the teams, but the problems arise with the tabulators!!!
INPUT SHEET FROM 5 JUDGES AND INFRACTION JUDGE: I would like to have where the tabulators get the 5 scores sheets from the 5 judges and the one safety infraction sheet. The tabulator will then take each sheet and input the scores from the 15 categories… The excel sheet will add up the total from the 15 categories and yield a total at the bottom. This will take place for all 5 judges. One column will need to be listed for deductions. This can be manually input on the separate spreadsheet (below).
MASTER SHEET: In addition, the total scores from the 5 judges will then, on a separate spreadsheet, be listed, high and low score dropped and then added up (see master score sheet). After they are added up, some formula (I hope) will be able to rank the teams. Obliviously, if there is only one team, they would be first. This sheet will need to be able to list up to 30 teams.
This may just have to be completed manually… TIE BREAKERS: if on the master sheet there is a tie… the high and low score will need to be added back in to break the tie ONLY between the two or more teams that were tied. The system CANNOT add back in the high and low and end up beating out the first place team (unless they were tied for 1st and 2nd)…
I can sent paper based examples!