Spreadsheet: 115053d1310676820-countif-issue-no-duplicates-sample_sort
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.44000000002 | 0.6749378809869377 |  | 2 | 137800
 |  |  | SWAT NAR | 106773 | 0.7748403483309144 |  | 3 | 137800
 |  |  |  |  |  |  | 4 | 137800
 |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  |  | KPI | 466.3069696969697 | 510.4663636363636 | 539.1966666666666 | 608.7036363636364 | 693.7033333333333 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | SWAT | 615.5151515151515 | 584.969696969697 | 770.6666666666666 | 641.969696969697 | 622.4242424242424 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | CSA | 2.054545454545454 | 2.1 | 2.066666666666666 | 1.96969696969697 | 2.215151515151514 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  | 2011 |  |  | Sorting and Charts
 |  |  |  |  | # SEs | SWAT NAR | KPI NAR |  | No. | Value | Sort: Large | Position | Category | # SEs | Chart total | Chart averages
 |  | Position
 |  | Sales Executive | SE |  | 22 | 147.6623376623376 | 122.0447835497835 |  | 1 | 122.0447835507835 | 158.5357142877143 | 2 | Senior Sales Executive | 11 | 158.5357142877143
 |  | Senior Sales Executive | SSE |  | 11 | 166.8961038961039 | 158.5357142857142 |  | 2 | 158.5357142877143 | 122.0447835507835 | 1 | Sales Executive | 22 | 122.0447835507835
 |  | All S.Es |  |  | 33 | 314.5584415584416 | 280.5804978354978 |  | 1 | 280.5804978364978 |  |  | All S.Es | 33 | 280.5804978364978
 |  | Hire Year |  |  |  |  |  | Selected
 |  | 2003 |  |  | 3 | 281.4920634920635 | 265.8561904761904 | 265.8561904761904 | 1 | 265.8561904771904 | 265.8561904771904 | 1 | 2003 | 3 | 265.8561904771904
 |  | 2004 |  |  | 1 | 239.8571428571429 | 236.5695238095238 | 236.5695238095238 | 2 | 236.5695238115238 | 236.5695238115238 | 2 | 2004 | 1 | 236.5695238115238
 |  | 2005 |  |  | 3 | 158.0476190476191 | 154.0744444444445 | 154.0744444444445 | 3 | 154.0744444474444 | 161.2161904801904 | 4 | 2006 | 3 | 161.2161904801904
 |  | 2006 |  |  | 3 | 165.7301587301587 | 161.2161904761905 | 161.2161904761905 | 4 | 161.2161904801904 | 154.0744444474444 | 3 | 2005 | 3 | 154.0744444474444
 |  | 2007 |  |  | 2 | 117.0476190476191 | 61.76190476190476 | 61.76190476190476 | 5 | 61.76190476690476 | 131.1902857222857 | 8 | 2010 | 10 | 131.1902857222857
 |  | 2008 |  |  | 2 | 176.2142857142857 | 125.1428571428571 | 125.1428571428571 | 6 | 125.1428571488571 | 125.1428571488571 | 6 | 2008 | 2 | 125.1428571488571
 |  | 2009 |  |  | 6 | 133.3888888888889 | 105.4259523809524 | 105.4259523809524 | 7 | 105.4259523879524 | 105.4259523879524 | 7 | 2009 | 6 | 105.4259523879524
 |  | 2010 |  |  | 10 | 126.0714285714286 | 131.1902857142857 | 131.1902857142857 | 8 | 131.1902857222857 | 61.76190476690476 | 5 | 2007 | 2 | 61.76190476690476
 |  | 2011 |  |  | 3 | 127.0634920634921 | 43.53333333333333 | 43.53333333333333 | 9 | 43.53333334233333 | 43.53333334233333 | 9 | 2011 | 3 | 43.53333334233333
 |  | Branch |  | US West |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAMPLE TEST
 |  | San Antonio |  |  | 2 | 392 | 360.092380952381 |  | 1 | 360.092380953381 | 360.092380953381 | 1 | San Antonio | 2 | 360.092380953381 |  |  |  |  | Concord
 |  | Albuquerque |  |  | 2 | 136.4047619047619 | 153.8954761904762 |  | 2 | 153.8954761924762 | 168.1326984196984 | 7 | Houston | 3 | 168.1326984196984 |  |  |  |  | San Antonio
 |  | Concord |  |  | 4 | 196.4166666666667 | 148.6661904761905 |  | 3 | 148.6661904791905 | 153.8954761924762 | 2 | Albuquerque | 2 | 153.8954761924762 |  |  |  |  | Portland
 |  | North Los Angeles |  |  | 2 | 166.3333333333333 | 126.0952380952381 |  | 4 | 126.0952380992381 | 153.5357142917143 | 6 | Salt Lake City | 2 | 153.5357142917143 |  |  |  |  | Boise
 |  | Los Angeles |  |  | 2 | 226.3095238095238 | 148.452380952381 |  | 5 | 148.452380957381 | 148.6661904791905 | 3 | Concord | 4 | 148.6661904791905 |  |  |  |  | [NAME]
 |  | Salt Lake City |  |  | 2 | 132.5952380952381 | 153.5357142857143 |  | 6 | 153.5357142917143 | 148.452380957381 | 5 | Los Angeles | 2 | 148.452380957381 |  |  |  |  | Concord
 |  | Houston |  |  | 3 | 152.2063492063492 | 168.1326984126984 |  | 7 | 168.1326984196984 | 132.2321428671429 | 10 | San Francisco | 4 | 132.2321428671429 |  |  |  |  | Concord
 |  | Portland |  |  | 3 | 106.7777777777778 | 87 |  | 8 | 87.000000008 | 126.0952380992381 | 4 | North Los Angeles | 2 | 126.0952380992381 |  |  |  |  | Fresno
 |  | Sacramento |  |  | 4 | 101.1428571428571 | 63.64285714285715 |  | 9 | 63.64285715185714 | 113.9047619177619 | 13 | Boise | 1 | 113.9047619177619 |  |  |  |  | Sacramento
 |  | San Francisco |  |  | 4 | 162.1428571428571 | 132.2321428571429 |  | 10 | 132.2321428671429 | 107.1904762024762 | 12 | [NAME] | 1 | 107.1904762024762 |  |  |  |  | Houston
 |  | Fresno |  |  | 3 | 55.41269841269841 | 60.02587301587302 |  | 11 | 60.02587302687302 | 87.000000008 | 8 | Portland | 3 | 87.000000008 |  |  |  |  | San Francisco
 |  | [NAME] |  |  | 1 | 99.14285714285714 | 107.1904761904762 |  | 12 | 107.1904762024762 | 63.64285715185714 | 9 | Sacramento | 4 | 63.64285715185714 |  |  |  |  | Sacramento
 |  | Boise |  |  | 1 | 96 | 113.9047619047619 |  | 13 | 113.9047619177619 | 60.02587302687302 | 11 | Fresno | 3 | 60.02587302687302 |  |  |  |  | Portland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fresno
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portland
 |  | SE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North Los Angeles
 |  | [NAME] |  |  |  | 13511 | 12133.66 |  | 1 | 12133.660000001 | 12133.660000001 | 1 | [NAME] |  | 12133.660000001 |  |  |  |  | Albuquerque
 |  | [NAME] |  |  |  | 3119 | 5813.5 |  | 2 | 5813.500000002 | 5813.500000002 | 2 | [NAME] |  | 5813.500000002 |  |  |  |  | San Francisco
 |  | [NAME] |  |  |  | 4504 | 5385.01 |  | 3 | 5385.010000003001 | 5385.010000003001 | 3 | [NAME] |  | 5385.010000003001 |  |  |  |  | Sacramento
 |  | [NAME] |  |  |  | 4329 | 5242.4 |  | 4 | 5242.400000004 | 5242.400000004 | 4 | [NAME] |  | 5242.400000004 |  |  |  |  | Salt Lake City
 |  | [NAME] |  |  |  | 5037 | 4967.96 |  | 5 | 4967.960000005 | 4967.960000005 | 5 | [NAME] |  | 4967.960000005 |  |  |  |  | Sacramento
 |  | [NAME] |  |  |  | 2988 | 4724.5 |  | 6 | 4724.500000006 | 4724.500000006 | 6 | [NAME] |  | 4724.500000006 |  |  |  |  | Fresno
 |  | [NAME] |  |  |  | 5442 | 4210 |  | 7 | 4210.000000007 | 4210.000000007 | 7 | [NAME] |  | 4210.000000007
 |  | [NAME] |  |  |  | 3143 | 3430 |  | 8 | 3430.000000008 | 3430.000000008 | 8 | [NAME] |  | 3430.000000008
 |  | [NAME] |  |  |  | 2703 | 3276.280000000001 |  | 9 | 3276.280000009001 | 3276.280000009001 | 9 | [NAME] |  | 3276.280000009001
 |  | [NAME] |  |  |  | 5213 | 3131 |  | 10 | 3131.00000001 | 3131.00000001 | 10 | [NAME] |  | 3131.00000001
 |  | Carmen Venegas |  |  |  | 4292 | 3104 |  | 11 | 3104.000000011 | 3104.000000011 | 11 | Carmen Venegas |  | 3104.000000011
 |  | [NAME] |  |  |  | 4045 | 3078 |  | 12 | 3078.000000012 | 3078.000000012 | 12 | [NAME] |  | 3078.000000012
 |  | [NAME] |  |  |  | 2953 | 2990.22 |  | 13 | 2990.220000013 | 2990.220000013 | 13 | [NAME] |  | 2990.220000013
 |  | [NAME] |  |  |  | 3222 | 2775 |  | 14 | 2775.000000014 | 2775.000000014 | 14 | [NAME] |  | 2775.000000014
 |  | [NAME] |  |  |  | 2016 | 2392 |  | 15 | 2392.000000015 | 2392.000000015 | 15 | [NAME] |  | 2392.000000015
 |  | [NAME] |  |  |  | 2082 | 2251 |  | 16 | 2251.000000016 | 2251.000000016 | 16 | [NAME] |  | 2251.000000016
 |  | [NAME] |  |  |  | 2896 | 2248 |  | 17 | 2248.000000017 | 2248.000000017 | 17 | [NAME] |  | 2248.000000017
 |  | [NAME] |  |  |  | 4521 | 2194 |  | 18 | 2194.000000018 | 2194.000000018 | 18 | [NAME] |  | 2194.000000018
 |  | [NAME] |  |  |  | 1569 | 2128.67 |  | 19 | 2128.670000019 | 2128.670000019 | 19 | [NAME] |  | 2128.670000019
 |  | [NAME] |  |  |  | 2188 | 2125 |  | 20 | 2125.00000002 | 2125.00000002 | 20 | [NAME] |  | 2125.00000002
 |  | [NAME] |  |  |  | 2557 | 2073.68 |  | 21 | 2073.680000021 | 2073.680000021 | 21 | [NAME] |  | 2073.680000021
 |  | [NAME] |  |  |  | 3159 | 1924 |  | 22 | 1924.000000022 | 1924.000000022 | 22 | [NAME] |  | 1924.000000022
 |  | [NAME] |  |  |  | 3000 | 1674 |  | 23 | 1674.000000023 | 1674.000000023 | 23 | [NAME] |  | 1674.000000023
 |  | [NAME] |  |  |  | 1985 | 1367 |  | 24 | 1367.000000024 | 1367.000000024 | 24 | [NAME] |  | 1367.000000024
 |  | [NAME] |  |  |  | 1244 | 1341.96 |  | 25 | 1341.960000025 | 1341.960000025 | 25 | [NAME] |  | 1341.960000025
 |  | [NAME] |  |  |  | 1520 | 1339 |  | 26 | 1339.000000026 | 1339.000000026 | 26 | [NAME] |  | 1339.000000026
 |  | [NAME] |  |  |  | 1544 | 1086 |  | 27 | 1086.000000027 | 1086.000000027 | 27 | [NAME] |  | 1086.000000027
 |  | [NAME] |  |  |  | 1225 | 1078.6 |  | 28 | 1078.600000028 | 1078.600000028 | 28 | [NAME] |  | 1078.600000028
 |  | [NAME] |  |  |  | 4330 | 1029 |  | 29 | 1029.000000029 | 1029.000000029 | 29 | [NAME] |  | 1029.000000029
 |  | [NAME] |  |  |  | 1916 | 920 |  | 30 | 920.00000003 | 920.00000003 | 30 | [NAME] |  | 920.00000003
 |  | [NAME] |  |  |  | 2450 | 635 |  | 31 | 635.000000031 | 635.000000031 | 31 | [NAME] |  | 635.000000031
 |  | [NAME] |  |  |  | 1392 | 627 |  | 32 | 627.000000032 | 627.000000032 | 32 | [NAME] |  | 627.000000032
 |  | [NAME] |  |  |  | 678 | 311 |  | 33 | 311.000000033 | 311.000000033 | 33 | [NAME] |  | 311.000000033
 |  | #N/A |  |  |  | #N/A | #N/A |  | 34 | #N/A |  | #N/A | #N/A |  | #N/A
 |  | #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