Spreadsheet: 772265d1647136910-multiple-rank-tiebreakers-with-blanks-tiebreaker-countif
Sheet: PM Required

 |  |  |  | Beauty |  |  |  |  |  |  |  |  |  |  |  | OOC
 |  |  |  | Judge 1 |  |  |  | Judge 2 |  |  |  | Judge 3 |  |  |  | Judge 1 |  |  | Judge 2 |  |  | Judge 3
Contestant Number | [NAME] | Group | Division | First Impression | Facial Beauty | Stage Presence & Poise | Dress | First Impression | Facial Beauty | Stage Presence & Poise | Dress | First Impression | Facial Beauty | Stage Presence & Poise | Dress | Overall Appearance | Personality & Projection | Appeal of Themewear | Overall Appearance | Personality & Projection | Appeal of Themewear | Overall Appearance | Personality & Projection | Appeal of Themewear | Total Beauty | Beauty Tie Breaker 1 | Beauty Tie Breaker 2 | Total OOC | OOC [NAME] 1 | OOC [NAME] 2 | Total Score | Total [NAME] | Total [NAME] | Grand Rank | Division Rank | [NAME] | OOC Rank | DO Dress | DO Dress Rank | DO Facial Beauty | DO Personality | Age Group OOC | Age Group Beauty | Age Group Rank
26 | Z | Precious A | [NAME] | 9.7 | 9.8 | 9.5 | 9.8 | 9.5 | 9.5 | 9.8 | 9.9 | 9.8 | 9.5 | 9.7 | 9.8 | 9.9 | 10 | 9.5 | 9.8 | 9.6 | 10 | 9.6 | 9.9 | 9.8
27 | AA | Precious A | [NAME] | 10 | 9.9 | 9.7 | 9.8 | 9.7 | 9.9 | 9.5 | 9.9 | 9.8 | 10 | 9.7 | 10 | 9.8 | 10 | 9.8 | 10 | 9.9 | 9.7 | 9.8 | 9.6 | 9.8
28 | BB | Precious A | [NAME] | 9.5 | 9.8 | 10 | 9.8 | 9.7 | 9.5 | 9.6 | 9.8 | 9.8 | 9.9 | 9.8 | 9.5 | 9.9 | 9.8 | 9.9 | 9.8 | 9.9 | 10 | 9.8 | 9.9 | 9.8
29 | CC | Precious A | [NAME] | 9.5 | 9.9 | 9.5 | 9.8 | 9.9 | 9.5 | 9.5 | 9.5 | 9.7 | 9.5 | 10 | 9.7 | 10 | 9.7 | 9.7 | 9.7 | 10 | 9.6 | 9.7 | 9.8 | 9.9
30 | DD | Precious A | [NAME] | 10 | 9.7 | 10 | 10 | 9.6 | 9.8 | 10 | 10 | 9.9 | 9.9 | 9.6 | 9.6 | 9.5 | 9.7 | 9.6 | 9.5 | 9.6 | 9.5 | 9.6 | 10 | 9.8
31 | EE | Petite A | [NAME] | 9.5 | 9.6 | 9.8 | 9.6 | 9.5 | 9.7 | 9.9 | 9.6 | 10 | 10 | 10 | 9.8 | 9.9 | 9.8 | 9.5 | 9.5 | 9.5 | 9.8 | 9.6 | 9.6 | 9.9
32 | FF | Petite A | [NAME] | 9.6 | 9.5 | 9.6 | 10 | 9.8 | 10 | 9.6 | 9.5 | 9.9 | 9.6 | 9.7 | 9.8 | 9.9 | 10 | 9.8 | 9.6 | 9.7 | 10 | 9.5 | 9.5 | 9.9
33 | GG | Petite A | [NAME] | 9.5 | 9.9 | 9.8 | 9.7 | 10 | 9.8 | 10 | 9.9 | 9.9 | 9.9 | 9.6 | 9.9 | 10 | 10 | 9.7 | 9.8 | 9.9 | 9.9 | 9.5 | 9.7 | 9.5
34 | HH | Petite A | [NAME] | 10 | 9.6 | 9.8 | 9.6 | 9.8 | 9.7 | 10 | 9.6 | 9.7 | 9.9 | 9.8 | 10 | 9.6 | 9.9 | 9.8 | 9.7 | 9.6 | 9.7 | 9.6 | 10 | 9.5
35 | II | Petite A | [NAME] | 9.7 | 9.8 | 9.9 | 9.6 | 9.5 | 9.7 | 9.9 | 9.6 | 9.6 | 9.7 | 9.6 | 9.6 | 9.8 | 9.5 | 9.8 | 9.5 | 9.6 | 9.6 | 9.5 | 9.5 | 9.9
36 | JJ | Petite B | [NAME] | 9.7 | 9.7 | 9.7 | 9.8 | 9.6 | 9.7 | 9.8 | 10 | 9.5 | 10 | 9.6 | 9.6 | 9.5 | 9.8 | 9.7 | 9.8 | 9.7 | 9.6 | 9.5 | 9.8 | 9.9
37 | KK | Petite B | [NAME] | 9.6 | 9.6 | 9.5 | 9.5 | 9.5 | 9.7 | 9.9 | 9.7 | 9.8 | 9.5 | 9.9 | 10 | 9.9 | 9.5 | 9.5 | 9.5 | 10 | 9.6 | 9.7 | 9.6 | 10
38 | LL | Petite B | [NAME] | 9.9 | 9.8 | 9.5 | 9.7 | 10 | 9.8 | 10 | 10 | 9.5 | 9.9 | 10 | 10 | 9.8 | 9.7 | 10 | 9.6 | 9.9 | 9.8 | 9.5 | 9.8 | 9.5
39 | MM | Petite B | [NAME] | 9.7 | 9.6 | 9.6 | 9.7 | 9.8 | 10 | 9.9 | 9.9 | 9.9 | 10 | 10 | 9.9 | 10 | 9.9 | 9.9 | 9.7 | 9.8 | 9.9 | 9.9 | 9.5 | 9.5
40 | NN | Petite B | [NAME] | 9.8 | 9.9 | 9.6 | 10 | 9.5 | 9.5 | 9.7 | 9.9 | 10 | 9.5 | 9.6 | 9.5 | 9.7 | 9.8 | 9.9 | 9.8 | 9.8 | 9.7 | 10 | 9.6 | 9.6
41 | OO | Little A | [NAME] | 9.5 | 9.5 | 9.5 | 9.8 | 9.5 | 10 | 10 | 9.6 | 9.7 | 9.8 | 10 | 9.6 | 9.8 | 9.5 | 9.5 | 9.9 | 10 | 9.9 | 9.7 | 9.7 | 9.8
42 | PP | Little A | [NAME] | 9.5 | 9.9 | 10 | 9.7 | 9.7 | 9.5 | 9.7 | 9.6 | 9.6 | 10 | 9.8 | 9.5 | 9.8 | 9.7 | 9.8 | 9.5 | 9.8 | 9.8 | 9.8 | 10 | 9.8
43 | QQ | Little A | [NAME] | 9.8 | 9.5 | 9.9 | 10 | 10 | 9.7 | 9.8 | 9.9 | 10 | 9.5 | 10 | 9.5 | 9.9 | 9.6 | 9.5 | 9.6 | 10 | 9.7 | 9.9 | 9.7 | 9.8
44 | RR | Little A | [NAME] | 9.7 | 9.9 | 9.8 | 9.8 | 9.7 | 9.9 | 9.9 | 9.7 | 9.6 | 10 | 9.7 | 9.9 | 9.7 | 9.6 | 9.8 | 9.5 | 9.7 | 9.7 | 9.7 | 9.7 | 9.6
45 | SS | Little A | [NAME] | 9.8 | 10 | 9.8 | 10 | 9.6 | 9.7 | 9.5 | 9.9 | 10 | 10 | 9.9 | 9.5 | 10 | 10 | 9.7 | 9.5 | 9.7 | 9.7 | 9.8 | 9.9 | 9.9
46 | TT | Jr. Teen A | [NAME] | 9.9 | 9.8 | 9.7 | 10 | 10 | 9.7 | 9.7 | 9.8 | 9.8 | 9.7 | 9.7 | 9.8 | 9.5 | 9.9 | 10 | 9.5 | 9.7 | 9.8 | 9.5 | 10 | 10
47 | UU | Jr. Teen A | [NAME] | 9.8 | 9.7 | 10 | 9.5 | 9.9 | 9.5 | 9.5 | 9.6 | 10 | 10 | 9.8 | 9.8 | 9.5 | 9.5 | 9.5 | 10 | 9.8 | 9.7 | 10 | 9.6 | 9.7
48 | VV | Jr. Teen A | [NAME] | 9.9 | 9.9 | 9.5 | 9.9 | 9.5 | 9.8 | 9.5 | 9.9 | 9.8 | 9.7 | 9.9 | 10 | 9.7 | 9.7 | 9.8 | 9.5 | 9.6 | 9.8 | 9.5 | 9.6 | 9.8
49 | WW | Jr. Teen A | [NAME] | 9.9 | 9.6 | 9.9 | 9.8 | 9.6 | 9.9 | 9.7 | 9.9 | 9.7 | 9.7 | 9.9 | 9.5 | 9.5 | 9.7 | 9.5 | 9.8 | 9.5 | 9.5 | 9.5 | 9.5 | 9.8
50 | XX | Jr. Teen A | [NAME] | 9.9 | 10 | 9.9 | 9.6 | 9.8 | 9.9 | 9.9 | 9.5 | 9.8 | 9.8 | 9.5 | 9.7 | 9.9 | 9.8 | 9.8 | 9.7 | 9.5 | 9.6 | 9.9 | 10 | 9.6
51 | YY | Teen A | [NAME] | 9.9 | 9.9 | 9.9 | 10 | 9.5 | 10 | 10 | 9.5 | 9.9 | 9.6 | 10 | 9.9 | 9.7 | 9.5 | 9.7 | 9.7 | 9.5 | 9.9 | 9.7 | 9.8 | 9.6
52 | ZZ | Teen A | [NAME] | 10 | 9.6 | 9.7 | 9.5 | 9.6 | 9.5 | 9.5 | 10 | 9.5 | 9.8 | 9.5 | 9.9 | 9.5 | 9.9 | 9.9 | 9.7 | 10 | 9.7 | 9.7 | 10 | 9.7
53 | AAA | Teen A | [NAME] | 9.9 | 9.6 | 9.6 | 9.7 | 9.6 | 10 | 9.7 | 9.6 | 9.5 | 10 | 9.9 | 9.8 | 9.7 | 9.7 | 9.8 | 9.8 | 9.8 | 10 | 9.8 | 10 | 9.5
54 | BBB | Teen A | [NAME] | 9.5 | 9.9 | 9.5 | 10 | 9.9 | 9.9 | 10 | 9.9 | 9.8 | 9.7 | 9.6 | 9.9 | 9.7 | 9.6 | 9.9 | 10 | 9.7 | 9.9 | 9.6 | 10 | 10
55 | CCC | Teen A | [NAME] | 9.6 | 9.6 | 9.6 | 9.7 | 9.7 | 9.9 | 9.6 | 9.6 | 9.9 | 10 | 10 | 10 | 9.9 | 9.7 | 10 | 9.6 | 9.8 | 9.8 | 9.7 | 9.5 | 9.9
56 | DDD | Ms. [NAME] | [NAME] | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8
57 | EEE | Ms. [NAME] | [NAME] | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8
58 | FFF | Ms. [NAME] | [NAME] | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8
59 | GGG | Ms. [NAME] | [NAME] | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8
60 | HHH | Ms. [NAME] | [NAME] | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8