Spreadsheet: 799282d1665019458-help-with-formula-for-grabbing-statistics-based-on-person-name-np-national-report
Sheet: Sheet2

 | Overall Rank | Weighted Value | Gross Adds (MTD) | Gross Adds (Proj) | % GA to Goal | Rank 60% | GA/Door (EOM Proj) | [NAME] | $60+ Rate Plan Mix | Rank 10% | Protect [NAME] | Rank 10% | ACP Actvtn Attach Rate | [NAME] | Rank 10% | Churn ([NAME]) | Rank 10% | WTR
[NAME] | 151 | 146.8 | 814 | 814 | 0.9324169530355098 | 214 | 50.875 | 0.458416500332668 | 0.7521058965102286 | 12 | 0.5486238532110091 | 8 | 0.05120481927710843 | 0.846045197740113 | 106 | 0.01495481174011599 | 58 | 0.6923076923076923
[NAME] | 129 | 138.9 | 516 | 516 | 1.011764705882353 | 146 | 51.6 | 0.4865671641791044 | 0.5662188099808061 | 231 | 0.3151595744680851 | 251 | 0.2082324455205811 | 0.8895705521472392 | 21 | 0.009555271383915886 | 10 | 0.5248226950354611
[NAME] | 130 | 139.1 | 1138 | 1138 | 0.9483333333333334 | 194 | 81.28571428571429 | 0.4475728155339806 | 0.731665228645384 | 18 | 0.4246666666666667 | 68 | 0.04787234042553191 | 0.8505747126436781 | 98 | 0.01365351515953926 | 43 | 0.6473684210526316
ADESH MOHAMED | 59 | 104.8 | 1147 | 1147 | 1.015943312666076 | 122 | 76.46666666666667 | 0.3559797866367209 | 0.6618150684931506 | 77 | 0.4065217391304348 | 96 | 0.08830022075055188 | 0.8511480601741884 | 96 | 0.01293209700968959 | 47 | 0.6394557823129251
ADRIANA LOPEZ | 157 | 153 | 1168 | 1168 | 1.02726473175022 | 113 | 77.86666666666666 | 0.3055885850178359 | 0.5213389121338912 | 254 | 0.3594632768361582 | 170 | 0.1655011655011655 | 0.645041014168531 | 303 | 0.0188771694561209 | 125 | 0.574468085106383
AISHA UJKASEVIC | 51 | 101.7 | 1141 | 1141 | 1.266370699223085 | 18 | 87.76923076923077 | 0.1064996084573218 | 0.5129533678756477 | 257 | 0.417312661498708 | 84 | 0.2791005291005291 | 0.6779026217228464 | 299 | 0.02380266568907277 | 269 | 0.6310679611650485
[NAME] | 224 | 189.1 | 604 | 604 | 0.893491124260355 | 247 | 50.33333333333334 | 0.4793103448275862 | 0.5990180032733224 | 163 | 0.3675937122128174 | 149 | 0.2163865546218487 | 0.8936170212765957 | 16 | 0.01243424198947872 | 81 | 0.647398843930636
[NAME] | 12 | 69.9 | 781 | 781 | 1.170914542728636 | 34 | 60.07692307692308 | 0.4253127299484916 | 0.6338383838383839 | 110 | 0.4011976047904192 | 102 | 0.1757387247278382 | 0.8176638176638177 | 188 | 0.01745328581420911 | 95 | 0.5940594059405941
ALBERT VASQUEZ | 182 | 167.8 | 998 | 998 | 0.9568552253116012 | 188 | 76.76923076923077 | 0.3973429951690821 | 0.5619512195121952 | 216 | 0.423605497170574 | 72 | 0.3811821471652593 | 0.8145631067961165 | 190 | 0.0168509487711844 | 72 | 0.6645962732919254
[NAME] | 199 | 175.9 | 661 | 661 | 1.009160305343511 | 128 | 47.21428571428572 | 0.3680688336520077 | 0.5476190476190477 | 235 | 0.2550177095631641 | 279 | 0.2166344294003869 | 0.7928221859706363 | 234 | 0.0227170993733214 | 243 | 0.5492957746478873
ALEJANDRO FLORES [NAME] | 16 | 77 | 1631 | 1631 | 1.122505161734343 | 50 | 81.55 | 0.3734152900499424 | 0.66507747318236 | 75 | 0.3635547576301616 | 161 | 0.03117505995203837 | 0.8217503217503217 | 174 | 0.01481004507405023 | 60 | 0.5942857142857143
[NAME] | 109 | 126.5 | 1188 | 1188 | 1.028571428571428 | 112 | 74.25 | 0.3578378378378378 | 0.6120619396903015 | 145 | 0.3366867873910128 | 197 | 0.228952772073922 | 0.862934362934363 | 65 | 0.01693510969709021 | 186 | 0.5656565656565656