Spreadsheet: 135667d1326169605-break-ranking-ties-with-multiple-criteria-break-ranking-ties
Sheet: Ranking

 |  |  | Performance Ranking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My formula
 |  |  |  |  | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Weights | Total  weight |  | Tie Breaker |  |  |  |  |  |  |  |  |  |  |  |  | Ranking Summary without Weights
 |  | [NAME] |  |  | 0.15 | 0.15 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 |  | Weights | 0.5 | 0.5
 | Count | Name | (Met 2012 Plan Sales Target) | Final Rank | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Various Sales KPI's | Total Weighted Avg Score | Rank before Tie Breaker | Sales Volume Increase vs 2011 Act | Sales % Growth vs 2011 Act | Ranking on Sales Volume Increase Vs 2011 Act | Ranking on Sales % Growth vs 2011 Act | Final Rank after [NAME] |  |  |  |  |  |  |  | Sales Volume Increase vs 2012 Plan | Sales % Growth  vs 2012 Plan | Sales Volume Increase vs 2011 Act | Sales % Growth vs 2011 Act | Active Rep Count Increase vs 2012 Plan | Active Rep % Growth vs 2012 Plan | Active Rep Count Increase vs 2011 Act | Active Rep % Growth vs 2011 Act | Titled Sales Leader Count Increase (End 2012 vs Beg 2012) | Total Rank
 | 1 | CENIZAL, [NAME] | Qualified |  | 4.649999999999999 | 4.649999999999999 | 1.9 | 1.8 | 3.5 | 3.4 | 2.4 | 2.5 | 2
 | 2 | TAYAG, EILEEN | Qualified |  | 4.8 | 4.8 | 1.8 | 1.8 | 2 | 1.9 | 0.6000000000000001 | 0.6000000000000001 | 0.7000000000000001
 | 3 | MADRIDEO, LEONY | Qualified |  | 4.8 | 4.8 | 2 | 1.8 | 0.8 | 0.6000000000000001 | 0.5 | 0.4 | 3.8
 | 4 | CAYETANO, LITO | Disqualified
 | 5 | PEL, SONIA | Disqualified
 | 6 | BAYANI, SUZETTE | Qualified |  | 4.8 | 4.8 | 2.1 | 1.8 | 2.4 | 2.3 | 1.2 | 0.9 | 1.7
 | 7 | DEANG, ANNE | Qualified |  | 4.8 | 4.8 | 2.4 | 1.8 | 3.3 | 3.3 | 3.7 | 3.6 | 3.6
 | 8 | RODRIGUEZ, KAREN | Qualified |  | 4.8 | 4.8 | 2.2 | 1.8 | 0.9 | 0.8 | 0.2 | 0.3 | 2.2
 | 9 | ZM MALOLOS VACANT | Qualified |  | 4.8 | 4.8 | 2.5 | 1.8 | 1 | 0.9 | 0.3 | 0.2 | 3.7
 | 10 | CULLA, VIVIAN | Qualified |  | 4.8 | 4.8 | 2.3 | 1.8 | 0.5 | 0.4 | 1.1 | 1.2 | 1.4
 | 11 | RICHARD | Qualified |  | 1.5 | 2.4 | 1.4 | 1.5 | 0.6000000000000001 | 0.7000000000000001 | 0.1 | 0.1 | 0.8
 | 12 | HERRERA, DANA | Qualified |  | 1.8 | 1.65 | 1 | 1 | 0.7000000000000001 | 0.5 | 2 | 2.1 | 1.8
 | 13 | DEQUINA, JOSETTE | Disqualified
 | 14 | ESTACIO, [NAME] | Qualified |  | 4.5 | 4.5 | 2.8 | 2.8 | 0.4 | 0.3 | 1 | 1.4 | 2.5
 | 15 | CAJES, RIZZA | Disqualified
 | 16 | SANTOS, NIA | Disqualified
 | 17 | [NAME], DAISY | Disqualified
 | 18 | FLORES, MARISSA | Qualified |  | 1.05 | 1.5 | 0.3 | 0.2 | 2.8 | 2.7 | 2.9 | 2.9 | 0.2
 | 19 | GUINTO, JOY | Disqualified
 | 20 | URI, MEANN | Qualified |  | 3.45 | 3.6 | 3.8 | 3.8 | 0.2 | 0.2 | 0.4 | 0.5 | 1
 | 21 | PENA, ROSE | Disqualified
 | 22 | FESTEJO, CHRIS | Disqualified
 | 23 | PARMISANO, MIA (OIC) | Qualified |  | 2.25 | 2.25 | 1.3 | 1.3 | 2.1 | 2 | 1.4 | 1.3 | 1.6
 | 24 | RUSTRIA, LYZA | Disqualified
 | 25 | VIRTUDAZO, ANN | Qualified |  | 3.75 | 3.75 | 2.9 | 3 | 3.3 | 3.1 | 2.3 | 2.3 | 2.8
 | 26 | MONTEMAYOR, NITO | Qualified |  | 2.55 | 2.1 | 3.5 | 3.5 | 3.2 | 3 | 1.8 | 1.8 | 2.9
 | 27 | DE MESA, JAIDE | Disqualified
 | 28 | CARANAY, HASMIN (OIC) | Qualified |  | 0.3 | 0.3 | 0.5 | 0.7000000000000001 | 3.7 | 3.5 | 3.2 | 3.2 | 3
 | 29 | TOLENTINO, AILA | Disqualified
 | 30 | BERNAL, [NAME] | Disqualified
 | 31 | AGASER, NIKKAH | Qualified |  | 1.65 | 1.2 | 3.2 | 3.2 | 1.7 | 1.5 | 2.7 | 2.6 | 1.9
 | 32 | [NAME] | Qualified |  | 1.95 | 1.95 | 0.4 | 0.4 | 1.3 | 1.1 | 3.5 | 3.5 | 1.2
 | 33 | [NAME] ([NAME]) | Disqualified
 | 34 | Chew [NAME] ([NAME]) | Disqualified
 | 35 | [NAME] (Michelle) | Qualified |  | 3.3 | 3.3 | 2.7 | 2.7 | 2.7 | 2.6 | 3.4 | 3.3 | 0.6000000000000001
 | 36 | [NAME] | Qualified |  | 2.7 | 2.7 | 3.4 | 3.4 | 3.7 | 3.7 | 2.8 | 2.8 | 0.1
 | 37 | Izzaida [NAME] | Disqualified
 | 38 | [NAME] | Disqualified
 | 39 | Santhakumari (Shanti) | Disqualified
 | 40 | [NAME] | Qualified |  | 2.4 | 2.55 | 2.6 | 2.6 | 2.5 | 2.4 | 1.9 | 1.9 | 1.1
 | 41 | [NAME] | Qualified |  | 4.35 | 4.35 | 3.7 | 3.6 | 1.2 | 1.2 | 1.3 | 1.1 | 1.3
 | 42 | [NAME] | Disqualified
 | 43 | [NAME].[NAME] | Disqualified
 | 44 | [NAME] | Disqualified
 | 45 | [NAME] | Qualified |  | 0.15 | 0.15 | 1.1 | 1.1 | 3 | 3.2 | 3.6 | 3.7 | 0.5
 | 46 | [NAME] | Disqualified
 | 47 | [NAME] | Disqualified
 | 48 | [NAME] | Qualified |  | 4.05 | 4.05 | 3.6 | 3.7 | 2.9 | 2.9 | 2.6 | 2.7 | 2.1
 | 49 | Ros Badariah Mohamed | Disqualified
 | 50 | [NAME]. Rahim | Qualified |  | 3.9 | 3.9 | 0.9 | 0.9 | 1.9 | 1.8 | 2.5 | 2.4 | 0.9
 | 51 | [NAME] | Qualified |  | 0.6 | 0.6 | 1.5 | 1.4 | 1.8 | 1.7 | 1.5 | 1.5 | 2.3
 | 52 | [NAME] | Disqualified
 | 53 | [NAME] | Disqualified
 | 54 | Carolina Binti Caneza | Disqualified
 | 55 | [NAME] | Qualified |  | 0.75 | 0.8999999999999999 | 0.1 | 0.3 | 1.1 | 1 | 2.2 | 2.2 | 2.7
 | 56 | Cecilia Gau | Disqualified
 | 57 | [NAME] | Disqualified
 | 58 | [NAME] | Qualified |  | 2.85 | 2.85 | 3 | 2.9 | 3.9 | 3.8 | 3 | 3.1 | 3.5
 | 59 | Samsuria Binti Zainal | Disqualified
 | 60 | [NAME] | Qualified |  | 3.15 | 3.15 | 0.7000000000000001 | 0.6000000000000001 | 2.2 | 2.1 | 3.1 | 3 | 0.4
 | 61 | [NAME] | Disqualified
 | 62 | [NAME] | Disqualified
 | 63 | [NAME] | Qualified |  | 2.1 | 1.8 | 0.8 | 0.8 | 3.4 | 3.6 | 3.3 | 3.4 | 2.4
 | 64 | [NAME] | Disqualified
 | 65 | Vacant | Qualified |  | 3.6 | 3.45 | 3.1 | 3.1 | 2.3 | 2.2 | 2.1 | 2 | 3.4
 | 66 | Nor Wahida Shazrin bte [NAME] | Qualified |  | 1.2 | 1.35 | 0.6000000000000001 | 0.5 | 1.4 | 1.4 | 1.6 | 1.6 | 1.5
 | 67 | Norizan Mohamed | Disqualified
 | 68 | Nur Rahimah [NAME] | Disqualified
 | 69 | OIC BRENDA PAJARON | Disqualified
 | 70 | LIM, TANYA | Qualified |  | 0.45 | 0.45 | 0.2 | 0.1 | 0.3 | 0.1 | 0.8 | 0.8 | 0.3
 | 71 | COLOMA, ANNABELLE | Qualified |  | 3 | 3 | 1.6 | 1.6 | 2.9 | 2.8 | 1.7 | 1.7 | 2.6
 | 72 | OCAMPO, BONNA | Disqualified
 | 73 | ALIAS, LEAH | Qualified |  | 1.35 | 1.05 | 3.3 | 3.3 | 1.5 | 1.6 | 0.7000000000000001 | 1 | 3.2
 | 74 | [NAME] | Qualified |  | 4.2 | 4.2 | 1.2 | 1.2 | 1.6 | 1.3 | 0.9 | 0.7000000000000001 | 3.1
 | 75 | [NAME] | Qualified |  | 0.8999999999999999 | 0.75 | 1.7 | 1.7 | 2.6 | 2.5 | 3.8 | 3.8 | 3.3
 | Count