Spreadsheet: 114961d1310619490-offset-samepl_offset
Sheet: Calculations

 |  | Calculations - Overview
 |  | Calculations and consolidation for overview dashboard
 |  | Controls
 |  | Select report | 2 | KPI NAR
 |  | List | SWAT NAR
 |  |  | KPI NAR
 |  | Overview
 |  |  |  | NAR / week |  |  | [NAME] | Quota 1
 |  |  |  | Value | % to plan
 |  |  | Quota | 137800 |  |  | 1 | 137800
 |  |  | KPI NAR | 93006.44 | 0.6749378809869376 |  | 2 | 137800
 |  |  | SWAT NAR | 106773 | 0.7748403483309144 |  | 3 | 137800
 |  |  |  |  |  |  | 4 | 137800
 |  |  |  | P1 | P2 | P3 | P4 | P5
 |  |  | KPI | 466.3069696969697 | 510.4663636363636 | 539.1966666666667 | 608.7036363636364 | 693.7033333333333
 |  |  | SWAT | 615.5151515151515 | 584.969696969697 | 770.6666666666666 | 641.969696969697 | 622.4242424242424
 |  |  | CSA | 2.054545454545454 | 2.1 | 2.066666666666666 | 1.96969696969697 | 2.215151515151514
 |  |  |  |  |  | 2011
 |  |  |  |  | # SEs | SWAT NAR | KPI NAR
 |  | Position
 |  | Sales Executive | SE |  | 22 | 147.6623376623376 | 122.0447835497835
 |  | Senior Sales Executive | SSE |  | 11 | 166.8961038961039 | 158.5357142857143
 |  | All S.Es |  |  | 33 | 314.5584415584416 | 280.5804978354978
 |  | Hire Year |  |  |  |  |  | Selected
 |  | 2003 |  |  | 3 | 281.4920634920635 | 265.8561904761905 | 265.8561904761905
 |  | 2004 |  |  | 1 | 239.8571428571429 | 236.5695238095238 | 236.5695238095238
 |  | 2005 |  |  | 3 | 158.0476190476191 | 154.0744444444445 | 154.0744444444445
 |  | 2006 |  |  | 3 | 165.7301587301587 | 161.2161904761905 | 161.2161904761905
 |  | 2007 |  |  | 2 | 117.0476190476191 | 61.76190476190476 | 61.76190476190476
 |  | 2008 |  |  | 2 | 176.2142857142857 | 125.1428571428571 | 125.1428571428571
 |  | 2009 |  |  | 6 | 133.3888888888889 | 105.4259523809524 | 105.4259523809524
 |  | 2010 |  |  | 10 | 126.0714285714286 | 131.1902857142857 | 131.1902857142857
 |  | 2011 |  |  | 3 | 127.0634920634921 | 43.53333333333333 | 43.53333333333333
 |  | Branch
 |  | San Antonio |  |  | 2 | 392 | 360.092380952381
 |  | Albuquerque |  |  | 2 | 136.4047619047619 | 153.8954761904762
 |  | Concord |  |  | 4 | 196.4166666666667 | 148.6661904761905
 |  | North Los Angeles |  |  | 2 | 166.3333333333333 | 126.0952380952381
 |  | Los Angeles |  |  | 2 | 226.3095238095238 | 148.452380952381
 |  | Salt Lake City |  |  | 2 | 132.5952380952381 | 153.5357142857143
 |  | Houston |  |  | 3 | 152.2063492063492 | 168.1326984126984
 |  | Portland |  |  | 3 | 106.7777777777778 | 87
 |  | Sacramento |  |  | 4 | 101.1428571428571 | 63.64285714285715
 |  | San Francisco |  |  | 4 | 162.1428571428571 | 132.2321428571429
 |  | Fresno |  |  | 3 | 55.41269841269841 | 60.02587301587302
 |  | [NAME] |  |  | 1 | 99.14285714285714 | 107.1904761904762
 |  | Boise |  |  | 1 | 96 | 113.9047619047619
 |  | SE
 |  | [NAME] |  |  |  | 4504 | 5385.01 |  | 1 | 5385.010000001001 | 12133.660000027 | 27 | [NAME] |  | 12133.660000027
 |  | [NAME] |  |  |  | 1225 | 1078.6 |  | 2 | 1078.600000002 | 5813.500000025 | 25 | [NAME] |  | 5813.500000025
 |  | [NAME] |  |  |  | 2082 | 2251 |  | 3 | 2251.000000003 | 5385.010000001001 | 1 | [NAME] |  | 5385.010000001001
 |  | [NAME] |  |  |  | 2016 | 2392 |  | 4 | 2392.000000004 | 5242.400000012 | 12 | [NAME] |  | 5242.400000012
 |  | [NAME] |  |  |  | 5037 | 4967.96 |  | 5 | 4967.960000005 | 4967.960000005 | 5 | [NAME] |  | 4967.960000005
 |  | [NAME] |  |  |  | 4521 | 2194 |  | 6 | 2194.000000006 | 4724.500000032 | 32 | [NAME] |  | 4724.500000032
 |  | [NAME] |  |  |  | 2896 | 2248 |  | 7 | 2248.000000007 | 4210.000000017 | 17 | [NAME] |  | 4210.000000017
 |  | [NAME] |  |  |  | 1569 | 2128.67 |  | 8 | 2128.670000008 | 3430.000000029 | 29 | [NAME] |  | 3430.000000029
 |  | [NAME] |  |  |  | 1244 | 1341.96 |  | 9 | 1341.960000009 | 3276.280000013001 | 13 | [NAME] |  | 3276.280000013001
 |  | [NAME] |  |  |  | 1392 | 627 |  | 10 | 627.00000001 | 3131.000000015 | 15 | [NAME] |  | 3131.000000015
 |  | [NAME] |  |  |  | 678 | 311 |  | 11 | 311.000000011 | 3104.000000016 | 16 | Carmen Venegas |  | 3104.000000016
 |  | [NAME] |  |  |  | 4329 | 5242.4 |  | 12 | 5242.400000012 | 3078.00000003 | 30 | [NAME] |  | 3078.00000003
 |  | [NAME] |  |  |  | 2703 | 3276.280000000001 |  | 13 | 3276.280000013001 | 2990.220000028 | 28 | [NAME] |  | 2990.220000028
 |  | [NAME] |  |  |  | 2557 | 2073.68 |  | 14 | 2073.680000014 | 2775.000000019 | 19 | [NAME] |  | 2775.000000019
 |  | [NAME] |  |  |  | 5213 | 3131 |  | 15 | 3131.000000015 | 2392.000000004 | 4 | [NAME] |  | 2392.000000004
 |  | Carmen Venegas |  |  |  | 4292 | 3104 |  | 16 | 3104.000000016 | 2251.000000003 | 3 | [NAME] |  | 2251.000000003
 |  | [NAME] |  |  |  | 5442 | 4210 |  | 17 | 4210.000000017 | 2248.000000007 | 7 | [NAME] |  | 2248.000000007
 |  | [NAME] |  |  |  | 1544 | 1086 |  | 18 | 1086.000000018 | 2194.000000006 | 6 | [NAME] |  | 2194.000000006
 |  | [NAME] |  |  |  | 3222 | 2775 |  | 19 | 2775.000000019 | 2128.670000008 | 8 | [NAME] |  | 2128.670000008
 |  | [NAME] |  |  |  | 1520 | 1339 |  | 20 | 1339.00000002 | 2125.000000023 | 23 | [NAME] |  | 2125.000000023
 |  | [NAME] |  |  |  | 1985 | 1367 |  | 21 | 1367.000000021 | 2073.680000014 | 14 | [NAME] |  | 2073.680000014
 |  | [NAME] |  |  |  | 3000 | 1674 |  | 22 | 1674.000000022 | 1924.000000031 | 31 | [NAME] |  | 1924.000000031
 |  | [NAME] |  |  |  | 2188 | 2125 |  | 23 | 2125.000000023 | 1674.000000022 | 22 | [NAME] |  | 1674.000000022
 |  | [NAME] |  |  |  | 1916 | 920 |  | 24 | 920.000000024 | 1367.000000021 | 21 | [NAME] |  | 1367.000000021
 |  | [NAME] |  |  |  | 3119 | 5813.5 |  | 25 | 5813.500000025 | 1341.960000009 | 9 | [NAME] |  | 1341.960000009
 |  | [NAME] |  |  |  | 2450 | 635 |  | 26 | 635.000000026 | 1339.00000002 | 20 | [NAME] |  | 1339.00000002
 |  | [NAME] |  |  |  | 13511 | 12133.66 |  | 27 | 12133.660000027 | 1086.000000018 | 18 | [NAME] |  | 1086.000000018
 |  | [NAME] |  |  |  | 2953 | 2990.22 |  | 28 | 2990.220000028 | 1078.600000002 | 2 | [NAME] |  | 1078.600000002
 |  | [NAME] |  |  |  | 3143 | 3430 |  | 29 | 3430.000000029 | 1029.000000033 | 33 | [NAME] |  | 1029.000000033
 |  | [NAME] |  |  |  | 4045 | 3078 |  | 30 | 3078.00000003 | 920.000000024 | 24 | [NAME] |  | 920.000000024
 |  | [NAME] |  |  |  | 3159 | 1924 |  | 31 | 1924.000000031 | 635.000000026 | 26 | [NAME] |  | 635.000000026
 |  | [NAME] |  |  |  | 2988 | 4724.5 |  | 32 | 4724.500000032 | 627.00000001 | 10 | [NAME] |  | 627.00000001
 |  | [NAME] |  |  |  | 4330 | 1029 |  | 33 | 1029.000000033 | 311.000000011 | 11 | [NAME] |  | 311.000000011
 |  | [NAME] |  |  |  | 0 | 0 |  | 34 | 3.4e-08 | 3.4e-08 | 34 | [NAME] |  | 3.4e-08
 |  | #N/A |  |  |  | #N/A | #N/A |  | 35 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 36 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 37 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 38 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 39 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 40 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 41 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 42 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 43 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 44 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 45 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 46 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 47 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 48 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 49 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 50 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 51 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 52 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 53 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 54 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 55 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 56 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 57 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 58 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 59 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 60 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 61 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 62 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 63 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #N/A |  |  |  | #N/A | #N/A |  | 64 | #N/A |  | #N/A | #N/A |  | #N/A