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

[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.9 | 14.99 |  | 0 | 0 | 6.9 |  | 0.46 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SPEC, INVENTORY | [NAME] | Computing Experience |  | 1 | 11 | 94.54 | 1039.93 | 205.92 | 1039.93 |  | 0 | 0 | 205.92 |  | 0.198 | 0.6731 | 0.0962 | 0.0384 | 0 | 0 | 0.1923
Store 479 | COUNTER OPERATIONS | [NAME] | Computing Experience |  | 34 | 1 | 110.17 | 217.1 | 51.48 | 7381.47 |  | 0.0149 | -0.1358 | 1750.29 |  | 0.2371 | 0.4579 | 0.0897 | 0.1978 | 0 | 0.0149 | 0.2398
Store 479 | SUPV, GAMING II | [NAME] | Computing Experience |  | 1 | 1 | 39.99 | 39.99 | 13.6 | 39.99 |  | 0 | 0 | 13.6 |  | 0.34 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 3 | 1 | 141.59 | 235.98 | 18.03 | 707.95 |  | 0 | 0 | 54.08 |  | 0.0764 | 0.8475 | 0.1243 | 0 | 0 | 0.0282 | 0
Store 479 | SPEC, SOLUTIONS | [NAME] | Computing Experience |  | 1 | 4 | 182.49 | 729.96 | 192.43 | 729.96 |  | 0.0822 | 0 | 192.43 |  | 0.2636 | 0.7398 | 0.1096 | 0 | 0 | 0.1507 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 88 | 97 | 2 | 192.49 | 442.53 | 54.23 | 42924.98 | 490.35 | 0.0038 | -0.109 | 5260.29 | 60.09 | 0.1225 | 0.8449 | 0.0694 | 0.0189 | 0 | 0.0505 | 0.0162
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 63 | 37 | 1 | 360.05 | 613.06 | 64.21 | 22683.1 | 359.02 | 0.0023 | -0.0847 | 2375.8 | 37.6 | 0.1047 | 0.8815 | 0.0372 | 0.0132 | 0 | 0.0465 | 0.0216
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 1 | 1 | 16.99 | 16.99 | 12.29 | 16.99 |  | 0 | 0 | 12.29 |  | 0.7234 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 65 | 39 | 2 | 198.85 | 423.19 | 50.26 | 16504.48 | 253.8 | 0.0061 | -0.0929 | 1960.2 | 30.14 | 0.1188 | 0.8343 | 0.0991 | 0.0206 | 0 | 0.0351 | 0.0109
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 16 | 4 | 6 | 73.46 | 440.75 | 121.3 | 1763 | 112.87 | 0 | 0 | 485.22 | 31.06 | 0.2752 | 0.5286 | 0.1509 | 0.1361 | 0 | 0.0709 | 0.1134
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 53 | 51 | 3 | 186.59 | 596.36 | 96.77 | 30414.21 | 569.34 | 0.0029 | -0.0464 | 4935.44 | 92.39 | 0.1623 | 0.7754 | 0.0645 | 0.0306 | 0 | 0.0925 | 0.0371
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 2 | 1 | 194.99 | 194.99 | 4.71 | 389.98 |  | 0 | 0 | 9.42 |  | 0.0241 | 0.9744 | 0.0256 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 2 | 1 | 229.99 | 229.99 | 5.5 | 459.98 |  | 0 | 0 | 10.99 |  | 0.0239 | 0.8261 | 0.1739 | 0 | 0 | 0 | 0
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 68 | 60 | 2 | 174.06 | 458.37 | 57.47 | 27502.04 | 401.78 | 0.002 | -0.1171 | 3447.91 | 50.37 | 0.1254 | 0.8002 | 0.072 | 0.0487 | 0 | 0.0445 | 0.0346
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 11 | 26 | 3 | 196.72 | 605.28 | 81.81 | 15737.4 | 1458.52 | 0.0065 | -0.0543 | 2127.15 | 197.14 | 0.1352 | 0.7958 | 0.0593 | 0.0559 | 0 | 0.0553 | 0.0337
Store 479 | CIA | [NAME] | Computing Experience |  | 26 | 1 | 75.92 | 143.08 | 45.73 | 3720.18 |  | 0.0054 | -0.1668 | 1189.09 |  | 0.3196 | 0.3172 | 0.211 | 0.0672 | 0 | 0.0555 | 0.3491
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 81 | 73 | 2 | 172.04 | 511.4 | 61.52 | 37332.19 | 462.83 | 0.0123 | -0.1017 | 4491.17 | 55.68 | 0.1203 | 0.8113 | 0.0582 | 0.0471 | 0 | 0.0577 | 0.0257
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 76 | 60 | 3 | 191.64 | 657.97 | 92.74 | 39478.45 | 522.2 | 0.0102 | -0.0646 | 5564.63 | 73.61 | 0.141 | 0.7634 | 0.0973 | 0.0465 | 0 | 0.0558 | 0.0371
Store 479 | CIA | [NAME] | Computing Experience |  | 15 | 1 | 70.62 | 127.12 | 53.83 | 1906.84 |  | 0 | -0.0315 | 807.46 |  | 0.4235 | 0 | 0.2868 | 0.1835 | 0 | 0 | 0.5297
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 59 | 35 | 3 | 149.85 | 590.85 | 101.5 | 20679.74 | 353.14 | 0.0014 | -0.0911 | 3552.64 | 60.67 | 0.1718 | 0.7034 | 0.0713 | 0.0367 | 0 | 0.1303 | 0.0583
Store 479 | SPEC, SALES COMPUTING & TABLET | [NAME] | Computing Experience | 89 | 51 | 4 | 220.59 | 977.5 | 161.75 | 49852.74 | 563.12 | 0.0021 | -0.0325 | 8249.35 | 93.18 | 0.1655 | 0.7284 | 0.1071 | 0.0574 | 0 | 0.073 | 0.0341
Store 479 | WIRELESS SALES CONSULTANT 1 | [NAME] | Computing Experience |  | 1 | -1 | 109.99 | -109.99 | -89.54 | -109.99 |  | 0 | 0 | -89.54 |  | 0.8141 | 0 | 0 | 0 | 0 | 1 | 0
Store 479 | WIRELESS SALES CONSULTANT 1 | Long Nguyen | Computing Experience |  | 2 | 4 | 192.49 | 769.97 | 134.95 | 1539.93 |  | 0 | 0 | 269.91 |  | 0.1753 | 0.7987 | 0.0876 | 0 | 0 | 0.1039 | 0.0097
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 6 | 0 | -3.51 | -1.17 | 1.7 | -7.02 |  | 0.7123 | -1.0717 | 10.22 |  | -1.4553 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SUPV, PCHO | [NAME] | Computing Experience | 44 | 12 | 6 | 128.01 | 832.03 | 169.27 | 9984.39 | 228.11 | 0.023 | 0 | 2031.24 | 46.41 | 0.2034 | 0.5939 | 0.0511 | 0.1492 | 0 | 0.065 | 0.1408
Store 479 | SUPV, PORTABLE ELECTRONICS II | [NAME] | Computing Experience |  | 1 | 2 | 44.99 | 89.98 | 31.99 | 89.98 |  | 0 | 0 | 31.99 |  | 0.3555 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | CIA | [NAME] | Computing Experience |  | 7 | 2 | 90.88 | 220.7 | 81.37 | 1544.9 |  | 0 | 0 | 569.6 |  | 0.3687 | 0 | 0.2686 | 0.3495 | 0 | 0 | 0.3819
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 2 | 3 | 45.89 | 137.67 | 63.33 | 275.34 |  | 0 | 0 | 126.66 |  | 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.2133 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 4 | 2 | 83.74 | 167.48 | 31.73 | 669.93 |  | 0 | 0 | 126.92 |  | 0.1894 | 0.5224 | 0.3433 | 0.0298 | 0 | 0.1045 | 0
Store 479 | CIA | [NAME] | Computing Experience |  | 13 | 1 | 58.1 | 58.1 | 26.62 | 755.28 |  | 0.0299 | -0.1351 | 346.03 |  | 0.4581 | 0 | 0.3679 | 0.0265 | 0 | 0 | 0.6057
Store 479 | SALES ASST, MULTI-CHANNEL | [NAME] | Computing Experience |  | 1 | -1 | 49.99 | -49.99 | -28.74 | -49.99 |  | 0 | 0 | -28.74 |  | 0.5749 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO | [NAME] | Computing Experience | 102 | 92 | 3 | 183.5 | 650.23 | 87.79 | 59821.38 | 588.39 | 0.0049 | -0.0815 | 8076.57 | 79.44 | 0.135 | 0.7653 | 0.0805 | 0.0536 | 0 | 0.0598 | 0.0407
Store 479 | SALES ASSOC, GAMING | [NAME] | Computing Experience |  | 6 | 2 | 32.37 | 64.75 | 11.5 | 388.48 |  | 0 | 0 | 69 |  | 0.1776 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 5 | 0 | 50.79 | 40.63 | 8.23 | 203.16 |  | 0 | 0 | 41.13 |  | 0.2024 | 0 | 1 | 0 | 0 | 0 | 0
Store 479 | SALES ASSOC, PCHO-APPLE | [NAME] | Computing Experience | 90 | 83 | 2 | 224.42 | 638.11 | 78.67 | 52963.17 | 589.86 | 0.0117 | -0.0504 | 6529.31 | 72.72 | 0.1233 | 0.822 | 0.07 | 0.0338 | 0 | 0.0477 | 0.0265
Store 479 | SALES ASSOC, HOME THEATER | [NAME] | Computing Experience |  | 5 | 1 | 87.13 | 121.99 | 31.23 | 609.94 |  | 0 | -0.0799 | 156.16 |  | 0.256 | 0.5574 | 0.2295 | 0.0984 | 0 | 0.1147 | 0
Store 479 | SUPV, HT-APPLIANCE | [NAME] | Computing Experience |  | 5 | 1 | 120.13 | 168.19 | 29.19 | 840.93 |  | 0 | 0 | 145.94 |  | 0.1735 | 0.5946 | 0.3876 | 0 | 0 | 0.0178 | 0