Spreadsheet: 123195d1317397012-drop-down-selection-that-copies-cells-employee-ranking
Sheet: NM Input WK1

[NAME] | Job Title | Employee | Dept | Hours | Trans Cnt | UPT | ASP | RPT | NMPT | POS Rev | POS Rev/Hr | Cntbl Erode Pct | R&E Pct | POS or Notional Margin | POS or Notional Margin /Hr | POS or Notional Margin % | [NAME] | [NAME] | [NAME] | Connections [NAME] | GSBTP Rev Mix | Services [NAME]
Store 479 | SALES ASSOC, GAMING | [NAME] | Computing Experience |  | 1 | 1 | 14.99 | 14.99 | 6.8954 | 14.99 |  | 0 | 0 | 6.8954 |  | 0.46 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SPEC, INVENTORY | [NAME] | Computing Experience |  | 1 | 11 | 94.5390909090909 | 1039.93 | 205.9214 | 1039.93 |  | 0 | 0 | 205.9214 |  | 0.1980146740646 | 0.673102997317127 | 0.0961507024511265 | 0.0384448953294933 | 0 | 0 | 0.192301404902253
Store 479 | COUNTER OPERATIONS | [NAME] | Computing Experience |  | 34 | 1 | 110.171194029851 | 217.102058823529 | 51.4791235294118 | 7381.47 |  | 0.0149021807309384 | -0.135801934341051 | 1750.2902 |  | 0.237119462654458 | 0.457895243088436 | 0.0896691309454621 | 0.197774968942501 | 0 | 0.0149008259872356 | 0.239759831036365
Store 479 | SUPV, GAMING II | [NAME] | Computing Experience |  | 1 | 1 | 39.99 | 39.99 | 13.5966 | 39.99 |  | 0 | 0 | 13.5966 |  | 0.34 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 3 | 1 | 141.59 | 235.983333333333 | 18.0251666666667 | 707.95 |  | 0 | 0 | 54.0755 |  | 0.0763832191538951 | 0.847475104174024 | 0.124288438449043 | 0 | 0 | 0.0282364573769334 | 0
Store 479 | SPEC, SOLUTIONS | [NAME] | Computing Experience |  | 1 | 4 | 182.49 | 729.96 | 192.43 | 729.96 |  | 0.0821962847279303 | 0 | 192.43 |  | 0.26361718450326 | 0.739752863170585 | 0.109567647542331 | 0 | 0 | 0.150679489287084 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 87.54 | 97 | 2 | 192.488699551569 | 442.525567010309 | 54.2297731958763 | 42924.98 | 490.347 | 0.0038436826295551 | -0.109048008272522 | 5260.288 | 60.0901073794837 | 0.12254607922939 | 0.844947627232441 | 0.0694474406278116 | 0.0188671025589296 | 0 | 0.0505092838715359 | 0.0162285457092816
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 63.18 | 37 | 1 | 360.049206349206 | 613.056756756757 | 64.2108621621622 | 22683.1 | 359.0234 | 0.00232860587838523 | -0.0847310998390429 | 2375.8019 | 37.6037021209243 | 0.104738854036706 | 0.881465055481835 | 0.0372475543466281 | 0.013223060340077 | 0 | 0.0464522045046753 | 0.0216121253267851
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 1 | 1 | 16.99 | 16.99 | 12.29 | 16.99 |  | 0 | 0 | 12.29 |  | 0.723366686286051 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 65.03 | 39 | 2 | 198.849156626506 | 423.191794871795 | 50.261441025641 | 16504.48 | 253.7979 | 0.00611894467441567 | -0.0928828218306372 | 1960.1962 | 30.1429524834692 | 0.118767522515099 | 0.834303776913904 | 0.0990531055810301 | 0.0205974377865888 | 0 | 0.0351401558849476 | 0.0109055238335288
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 15.62 | 4 | 6 | 73.4583333333333 | 440.75 | 121.304925 | 1763 | 112.8681 | 0 | 0 | 485.2197 | 31.0640012804097 | 0.275223879750425 | 0.52862733976177 | 0.150947249007374 | 0.136108905275099 | 0 | 0.0708848553601815 | 0.113431650595576
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 53.42 | 51 | 3 | 186.590245398773 | 596.357058823529 | 96.7732764705882 | 30414.21 | 569.3413 | 0.00292593494948578 | -0.0464016128349556 | 4935.4371 | 92.389312991389 | 0.162274052161802 | 0.775379995074671 | 0.0644573704199451 | 0.0305718938614549 | 0 | 0.0925005120961551 | 0.0370902285477742
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 2 | 1 | 194.99 | 194.99 | 4.7075 | 389.98 |  | 0 | 0 | 9.415 |  | 0.0241422637058311 | 0.97438330170778 | 0.0256166982922201 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 2 | 1 | 229.99 | 229.99 | 5.495 | 459.98 |  | 0 | 0 | 10.99 |  | 0.0238923431453541 | 0.826101134831949 | 0.173898865168051 | 0 | 0 | 0 | 0
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 68.45 | 60 | 2 | 174.063544303797 | 458.367333333333 | 57.4651083333333 | 27502.04 | 401.7829 | 0.00203584897702134 | -0.117135828689545 | 3447.9065 | 50.3711687363039 | 0.125369118072696 | 0.800215911256038 | 0.0720113853372332 | 0.0487167497392921 | 0 | 0.0444501571519785 | 0.0346057965154585
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 10.79 | 26 | 3 | 196.7175 | 605.284615384616 | 81.8132923076923 | 15737.4 | 1458.5171 | 0.00654491847446211 | -0.0542928018229805 | 2127.1456 | 197.14046339203 | 0.135164995488454 | 0.795796637309848 | 0.0593376288332253 | 0.0559107603543152 | 0 | 0.0552791439500807 | 0.0336758295525309
Store 479 | CIA | [NAME] | Computing Experience |  | 26 | 1 | 75.9220408163265 | 143.083846153846 | 45.7340615384615 | 3720.18 |  | 0.00537339591095055 | -0.166837247739708 | 1189.0856 |  | 0.319631200640829 | 0.317183577138741 | 0.210976350606691 | 0.0671876092017053 | 0 | 0.0555483874436183 | 0.349104075609245
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 80.66 | 73 | 2 | 172.037741935484 | 511.399863013699 | 61.5228616438356 | 37332.19 | 462.834 | 0.0123397529049327 | -0.101739750797331 | 4491.1689 | 55.6802491941483 | 0.120302851239105 | 0.811322078881523 | 0.0581532988019187 | 0.0471368007073788 | 0 | 0.0577190890756744 | 0.0256687325335053
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 75.6 | 60 | 3 | 191.642961165049 | 657.974166666667 | 92.743915 | 39478.45 | 522.2017 | 0.0102321646366562 | -0.0646309032684236 | 5564.6349 | 73.6062817460317 | 0.140953732985971 | 0.763367102811787 | 0.097328795836716 | 0.0464757354962011 | 0 | 0.0557595346321854 | 0.0370688312231103
Store 479 | CIA | [NAME] | Computing Experience |  | 15 | 1 | 70.6237037037037 | 127.122666666667 | 53.83046 | 1906.84 |  | 0 | -0.0314857047078722 | 807.4569 |  | 0.423452885402026 | 0 | 0.286814835014999 | 0.183528770111808 | 0 | 0 | 0.529656394873193
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 58.56 | 35 | 3 | 149.853188405797 | 590.849714285714 | 101.504068571429 | 20679.74 | 353.1376 | 0.00135349864166571 | -0.091067560725186 | 3552.6424 | 60.6667076502732 | 0.171793378446731 | 0.703380700144199 | 0.0713036043973473 | 0.0367441757004682 | 0 | 0.130251154028049 | 0.0583203657299366
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 88.53 | 51 | 4 | 220.587345132743 | 977.504705882353 | 161.752039215686 | 49852.74 | 563.1169 | 0.00210640378041408 | -0.0325052602815653 | 8249.354 | 93.1814526149328 | 0.165474435306866 | 0.728396673883923 | 0.107134532625489 | 0.057362343574295 | 0 | 0.0730343006221925 | 0.034072149294101
Store 479 | WIRELESS SALES CONSULTANT 1 | [NAME] | Computing Experience |  | 1 | -1 | 109.99 | -109.99 | -89.54 | -109.99 |  | 0 | 0 | -89.54 |  | 0.814074006727884 | 0 | 0 | 0 | 0 | 1 | 0
Store 479 | WIRELESS SALES CONSULTANT 1 | Long Nguyen | Computing Experience |  | 2 | 4 | 192.49125 | 769.965 | 134.9535 | 1539.93 |  | 0 | 0 | 269.907 |  | 0.17527225263486 | 0.798724617352737 | 0.0876468410901794 | 0 | 0 | 0.103894332859286 | 0.00973420869779795
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 6 | 0 | -3.51 | -1.17 | 1.70266666666667 | -7.02 |  | 0.712250712250713 | -1.07166190281748 | 10.216 |  | -1.45527065527065 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SUPV, PCHO | [NAME] | Computing Experience | 43.77 | 12 | 6 | 128.005 | 832.0325 | 169.270041666667 | 9984.39 | 228.1103 | 0.0230359591322054 | 0 | 2031.2405 | 46.4071395933288 | 0.203441622372524 | 0.593914099909959 | 0.0510667151423372 | 0.149218930750902 | 0 | 0.0649503875549733 | 0.140849866641828
Store 479 | SUPV, PORTABLE ELECTRONICS II | [NAME] | Computing Experience |  | 1 | 2 | 44.99 | 89.98 | 31.9854 | 89.98 |  | 0 | 0 | 31.9854 |  | 0.355472327183819 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | CIA | [NAME] | Computing Experience |  | 7 | 2 | 90.8764705882353 | 220.7 | 81.3717571428571 | 1544.9 |  | 0 | 0 | 569.6023 |  | 0.368698491811768 | 0 | 0.268599909379248 | 0.349504822318597 | 0 | 0 | 0.381895268302155
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 2 | 3 | 45.89 | 137.67 | 63.3282 | 275.34 |  | 0 | 0 | 126.6564 |  | 0.46 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PORTABLE ELECTRONICS | [NAME] | Computing Experience |  | 1 | 2 | 30.49 | 60.98 | 13.01 | 60.98 |  | 0 | 0 | 13.01 |  | 0.213348638897999 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 4 | 2 | 83.74125 | 167.4825 | 31.729375 | 669.93 |  | 0 | 0 | 126.9175 |  | 0.189448897646023 | 0.522427716328572 | 0.343259743555297 | 0.0298389383965489 | 0 | 0.104473601719583 | 0
Store 479 | CIA | [NAME] | Computing Experience |  | 13 | 1 | 58.0984615384615 | 58.0984615384615 | 26.6177769230769 | 755.28 |  | 0.0299226776824489 | -0.135102947575751 | 346.0311 |  | 0.458149428026692 | 0 | 0.367850333651096 | 0.0264670056138121 | 0 | 0 | 0.605682660735092
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 1 | -1 | 49.99 | -49.99 | -28.74 | -49.99 |  | 0 | 0 | -28.74 |  | 0.574914982996599 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 101.67 | 92 | 3 | 183.501165644172 | 650.232391304348 | 87.7888391304348 | 59821.38 | 588.3877 | 0.00493636221698664 | -0.0815340085586405 | 8076.5732 | 79.4390990459329 | 0.135011482516786 | 0.765316179600003 | 0.08052455493337 | 0.0536187898039129 | 0 | 0.0598409799305867 | 0.0406994957321279
Store 479 | SALES ASSOC, GAMING | [NAME] | Computing Experience |  | 6 | 2 | 32.3733333333333 | 64.7466666666667 | 11.5004666666667 | 388.48 |  | 0 | 0 | 69.0028 |  | 0.177622528830313 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 5 | 0 | 50.79 | 40.632 | 8.22508 | 203.16 |  | 0 | 0 | 41.1254 |  | 0.202428627682615 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO-APPLE | [NAME] | Computing Experience | 89.79 | 83 | 2 | 224.420211864407 | 638.110481927711 | 78.6663469879518 | 52963.17 | 589.856 | 0.0117249401801289 | -0.0504493870153499 | 6529.3068 | 72.7175275643167 | 0.123280135988839 | 0.822030290105369 | 0.0699795725973351 | 0.0337927280410142 | 0 | 0.0476918205613448 | 0.0265055886949365
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 5 | 1 | 87.1342857142857 | 121.988 | 31.23136 | 609.94 |  | 0 | -0.0799330246028993 | 156.1568 |  | 0.256019936387186 | 0.557415483490179 | 0.229481588352953 | 0.0983539364527658 | 0 | 0.114748991704102 | 0
Store 479 | SUPV, HT-APPLIANCE | [NAME] | Computing Experience |  | 5 | 1 | 120.132857142857 | 168.186 | 29.18824 | 840.93 |  | 0 | 0 | 145.9412 |  | 0.173547382065095 | 0.594567918851747 | 0.387606578431023 | 0 | 0 | 0.0178255027172297 | 0