Spreadsheet: 131296d1322846168-removing-tied-entries-sample
Sheet: DrumMajors

Category |  |  |  |  |  |  | [NAME] |  |  |  |  | AVERAGE SCORE                 (if 2 Judges) | PENALTIES | FINAL SCORE | OPEN PLACEMENT MS/HS | Middle School DM Awards | HS Military DM Awards | HS Mace DM Awards | Tie-Breaker is "Beating of Time" (Average of Column D and I - see helper column AA)
 |  | Step-Off | Beating of Time | Salute | Leadership | TOTAL POINTS Judge 1 | Step-Off | Beating of Time | Salute | Leadership | TOTAL POINTS Judge 2
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 1 | 33 | 22 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 2 | 33 | 22 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 3 | 54 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 4 | 44 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 66 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 77 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 88 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 43 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 9 | 34 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 10 | 77 | 77 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 11 | 44 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 12 | 56 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 65
 | School 13 | 43 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 14 | 43 | 33 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 2 | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 12 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 15 | 34 | 56 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 16 | 33 | 33 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 17 | 45 | 66 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 18 | 33 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 19 | 78 | 45 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | School 20 | 88 | 77 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
 | MIDDLE SCHOOL MACE/MILITARY OVERALL  Drum Major Scores |  |  |  | IF BLANK or #[NAME] there is a tie in the tie-breaker Column D "Beating Of Time" |  |  |  |  |  |  | HIGH SCHOOL MILITARY Drum Major [NAME] |  |  |  |  |  |  | HIGH SCHOOL MACE Drum Major [NAME] |  |  |  | OPEN DRUM MAJOR COMPETITION
 | 1st Place |  |  |  |  |  |  |  |  |  |  | 1st Place |  |  |  |  |  |  | 1st Place |  |  |  | 1st Place
 | 2nd Place |  |  |  |  |  |  |  |  |  |  | 2nd Place |  |  |  |  |  |  | 2nd Place |  |  |  | 2nd Place
 | 3rd Place |  |  |  |  |  |  |  |  |  |  | 3rd Place |  |  |  |  |  |  | 3rd Place |  |  |  | 3rd Place
 | 4th Place |  |  |  |  |  |  |  |  |  |  | 4th Place |  |  |  |  |  |  | 4th Place |  |  |  | 4th Place
 | 5th Place |  |  |  |  |  |  |  |  |  |  | 5th Place |  |  |  |  |  |  | 5th Place |  |  |  | 5th Place
 | 6th Place |  |  |  |  |  |  |  |  |  |  | 6th Place |  |  |  |  |  |  | 6th Place |  |  |  | 6th Place
 | 7th Place |  |  |  |  |  |  |  |  |  |  | 7th Place |  |  |  |  |  |  | 7th Place |  |  |  | 7th Place
 | 8th Place |  |  |  |  |  |  |  |  |  |  | 8th Place |  |  |  |  |  |  | 8th Place |  |  |  | 8th Place
 | 9th Place |  |  |  |  |  |  |  |  |  |  | 9th Place |  |  |  |  |  |  | 9th Place |  |  |  | 9th Place
 | 10th Place |  |  |  |  |  |  |  |  |  |  | 10th Place |  |  |  |  |  |  | 10th Place |  |  |  | 10th Place
 | 11th Place |  |  |  |  |  |  |  |  |  |  | 11th Place |  |  |  |  |  |  | 11th Place |  |  |  | 11th Place
 | 12th Place |  |  |  |  |  |  |  |  |  |  | 12th Place |  |  |  |  |  |  | 12th Place |  |  |  | 12th Place
 | 13th Place |  |  |  |  |  |  |  |  |  |  | 13th Place |  |  |  |  |  |  | 13th Place |  |  |  | 13th Place
 | 14th Place |  |  |  |  |  |  |  |  |  |  | 14th Place |  |  |  |  |  |  | 14th Place |  |  |  | 14th Place
 | 15th Place |  |  |  |  |  |  |  |  |  |  | 15th Place |  |  |  |  |  |  | 15th Place |  |  |  | 15th Place
 |  |  |  |  |  |  |  |  |  |  |  | 16th Place |  |  |  |  |  |  | 16th Place
 |  |  |  |  |  |  |  |  |  |  |  | 17th Place |  |  |  |  |  |  | 17th Place
 |  |  |  |  |  |  |  |  |  |  |  | 18th Place |  |  |  |  |  |  | 18th Place
 |  |  |  |  |  |  |  |  |  |  |  | 19th Place |  |  |  |  |  |  | 19th Place
 |  |  |  |  |  |  |  |  |  |  |  | 20th Place |  |  |  |  |  |  | 20th Place
 |  |  |  |  |  |  |  |  |  |  |  | 21st Place |  |  |  |  |  |  | 21st Place
 |  |  |  |  |  |  |  |  |  |  |  | 22nd Place |  |  |  |  |  |  | 22nd Place
 |  |  |  |  |  |  |  |  |  |  |  | 23rd Place |  |  |  |  |  |  | 23rd Place
 |  |  |  |  |  |  |  |  |  |  |  | 24th Place |  |  |  |  |  |  | 24th Place
 |  |  |  |  |  |  |  |  |  |  |  | 25th Place |  |  |  |  |  |  | 25th Place