Spreadsheet: 142275d1329761656-determining-top-score-of-multiple-columns-sample-1
Sheet: DrumMajors

Category |  | [NAME] |  |  |  |  | [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
 |  | Step-Off | Beating of Time | Salute | Leadership | TOTAL POINTS Judge 1 | Step-Off | Beating of Time | Salute | Leadership | TOTAL POINTS Judge 2
Ms
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 1 | 33 | 22 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 2 | 33 | 22 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 3 | 54 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 4 | 44 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 5 | 66 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 6 | 77 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Ms | School 7 | 88 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Mil | School 8 | 43 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Mil | School 9 | 34 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Mil | 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 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Mil | 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 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
Mil | School 12 | 56 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0 | 65
[NAME] | 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 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | School 14 | 43 | 33 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 2 | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 12 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | 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 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | School 16 | 33 | 33 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | School 17 | 45 | 66 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | 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 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  | 0
[NAME] | 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 | 0 | 0 | 0 |  |  | 0
[NAME] | 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 |  | 0 | 0 | 0 | 0 |  |  | 0
 | MIDDLE SCHOOL MACE/MILITARY OVERALL  Drum Major Scores |  |  |  | SWEEPSTAKES WINNER |  |  |  |  |  |  | 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