Spreadsheet: 115001d1310649129-sort-button-not-working-sample_sort
Sheet: Royal Rankings Data

 |  |  |  |  |  |  |  | Sorted by: SWAT
 |  |  | 3 | 30 |  | 43 |  | 56 |  | 69 |  | 82 |  | 95
 |  | SE | Branch | P5 YTD KPI NAR / week | Rank | P5 YTD SWAT NAR / week | Rank | P5 YTD 1st Appointment Avg. | Rank | P5 YTD Total Appt., [NAME]. | Rank | P5 YTD CSA's signed / week | Rank | P5 YTD Total [NAME]'s Closed | Rank | TOTAL | P5 YTD Rank
 |  | [NAME] | Albuquerque | 256.4290476190477 | 3 | 214.4761904761905 | 6 | 9.7 | 1 | 10.24 | 10 | 4.56 | 1 | 0 | 13 | 34 | 2
 |  | [NAME] | Albuquerque | 51.36190476190476 | 28 | 58.33333333333334 | 32 | 6.44 | 14 | 7.7 | 27 | 1.74 | 20 | 0 | 13 | 134 | 30
 |  | [NAME] | [NAME] | 107.1904761904762 | 16 | 99.14285714285714 | 23 | 4.720000000000001 | 29 | 8.959999999999999 | 19 | 2.1 | 13 | 0 | 13 | 113 | 21
 |  | [NAME] | Boise | 113.9047619047619 | 15 | 96 | 24 | 5.7 | 21 | 6.720000000000001 | 31 | 2 | 15 | 0 | 13 | 119 | 24
 |  | [NAME] | Concord | 236.5695238095238 | 5 | 239.8571428571429 | 4 | 6.28 | 18 | 10.14 | 11 | 3.28 | 4 | 1 | 3 | 45 | 3
 |  | [NAME] | Concord | 104.4761904761905 | 18 | 215.2857142857143 | 5 | 7.359999999999999 | 7 | 9.540000000000001 | 16 | 2.34 | 9 | 3 | 1 | 56 | 5
 |  | [NAME] | Concord | 107.0476190476191 | 17 | 137.9047619047619 | 18 | 7.8 | 5 | 7.88 | 24 | 3.02 | 6 | 0 | 13 | 83 | 12
 |  | [NAME] | Fresno | 101.3652380952381 | 19 | 74.71428571428571 | 27 | 6.44 | 15 | 10.72 | 6 | 1.64 | 22 | 0 | 13 | 102 | 18
 |  | [NAME] | Fresno | 63.90285714285714 | 25 | 59.23809523809524 | 31 | 5.58 | 23 | 11.46 | 2 | 1.1 | 30 | 0 | 13 | 124 | 27
 |  | [NAME] | Sacramento | 29.85714285714286 | 32 | 66.28571428571429 | 30 | 5.36 | 27 | 9.26 | 18 | 1.36 | 29 | 0 | 13 | 149 | 32
 |  | [NAME] | Fresno | 14.80952380952381 | 33 | 32.28571428571428 | 33 | 7.88 | 4 | 7.98 | 22 | 1.04 | 31 | 0 | 13 | 136 | 31
 |  | [NAME] | Houston | 249.6380952380952 | 4 | 206.1428571428571 | 8 | 6.92 | 11 | 8.02 | 21 | 2.22 | 12 | 1 | 3 | 59 | 7
 |  | [NAME] | Houston | 156.0133333333334 | 9 | 128.7142857142857 | 19 | 5.42 | 25 | 11.44 | 3 | 1.76 | 19 | 1 | 3 | 78 | 11
 |  | [NAME] | Houston | 98.74666666666668 | 21 | 121.7619047619048 | 20 | 5.26 | 28 | 7.38 | 30 | 1.98 | 16 | 0 | 13 | 128 | 28
 |  | [NAME] | Los Angeles | 149.0952380952381 | 10 | 248.2380952380952 | 3 | 4.14 | 31 | 11.24 | 4 | 3.4 | 3 | 0 | 13 | 64 | 9
 |  | Carmen Venegas | Los Angeles | 147.8095238095238 | 11 | 204.3809523809524 | 9 | 4.14 | 31 | 5.94 | 32 | 2.44 | 8 | 1 | 3 | 94 | 16
 |  | [NAME] | North Los Angeles | 200.4761904761905 | 7 | 259.1428571428572 | 2 | 5.5 | 24 | 10.3 | 8 | 2.9 | 7 | 1 | 3 | 51 | 4
 |  | [NAME] | North Los Angeles | 51.71428571428572 | 27 | 73.52380952380952 | 28 | 7.08 | 9 | 7.859999999999999 | 26 | 1.44 | 26 | 0 | 13 | 129 | 29
 |  | [NAME] | Portland | 132.1428571428571 | 14 | 153.4285714285714 | 11 | 7 | 10 | 10.78 | 5 | 1.8 | 18 | 1 | 3 | 61 | 8
 |  | [NAME] | Portland | 63.76190476190476 | 26 | 72.38095238095238 | 29 | 6.74 | 13 | 9.440000000000001 | 17 | 1.54 | 25 | 0 | 13 | 123 | 26
 |  | [NAME] | Portland | 65.0952380952381 | 24 | 94.52380952380952 | 25 | 7.38 | 6 | 9.559999999999999 | 15 | 1.66 | 21 | 0 | 13 | 104 | 19
 |  | [NAME] | Sacramento | 79.71428571428571 | 23 | 142.8571428571429 | 15 | 6.82 | 12 | 10.26 | 9 | 2.1 | 13 | 0 | 13 | 85 | 14
 |  | [NAME] | Sacramento | 101.1904761904762 | 20 | 104.1904761904762 | 22 | 5.42 | 25 | 7.44 | 29 | 1.58 | 23 | 1 | 3 | 122 | 25
 |  | [NAME] | Sacramento | 43.80952380952381 | 30 | 91.23809523809524 | 26 | 3.36 | 33 | 5.200000000000001 | 33 | 1.4 | 28 | 0 | 13 | 163 | 33
 |  | [NAME] | Salt Lake City | 276.8333333333333 | 2 | 148.5238095238095 | 14 | 6.44 | 15 | 9.940000000000001 | 13 | 2.32 | 10 | 0 | 13 | 67 | 10
 |  | [NAME] | Salt Lake City | 30.23809523809524 | 31 | 116.6666666666667 | 21 | 7.340000000000001 | 8 | 12.24 | 1 | 2.24 | 11 | 0 | 13 | 85 | 15
 |  | [NAME] | San Antonio | 577.7933333333333 | 1 | 643.3809523809524 | 1 | 9.680000000000001 | 2 | 9.680000000000001 | 14 | 3.82 | 2 | 1 | 3 | 23 | 1
 |  | [NAME] | San Antonio | 142.3914285714286 | 13 | 140.6190476190476 | 17 | 9.66 | 3 | 10.44 | 7 | 3.259999999999999 | 5 | 0 | 13 | 58 | 6
 |  | [NAME] | San Francisco | 163.3333333333333 | 8 | 149.6666666666667 | 13 | 5.98 | 20 | 8.44 | 20 | 1.56 | 24 | 0 | 13 | 98 | 17
 |  | [NAME] | Concord | 146.5714285714286 | 12 | 192.6190476190476 | 10 | 6.12 | 19 | 10.08 | 12 | 1.42 | 27 | 1 | 3 | 83 | 13
 |  | [NAME] | San Francisco | 91.61904761904762 | 22 | 150.4285714285714 | 12 | 6.32 | 17 | 7.9 | 23 | 1.88 | 17 | 0 | 13 | 104 | 20
 |  | [NAME] | San Francisco | 224.9761904761905 | 6 | 142.2857142857143 | 16 | 4.58 | 30 | 7.659999999999999 | 28 | 1 | 32 | 2 | 2 | 114 | 22
 |  | [NAME] | San Francisco | 49 | 29 | 206.1904761904762 | 7 | 5.600000000000001 | 22 | 7.88 | 24 | 0.78 | 33 | 1 | 3 | 118 | 23