Spreadsheet: 130078d1322057929-top-data-based-on-rank-sample_showdata
Sheet: Calculation sheet

 |  | Calculations
 |  |  |  | 7 | 9 | 30 | 22 | 23
 |  |  | Houston - Austin - San Antonio - Albuquerque | Start date | Tenure | Rank | YTD NAR | YTD NAR / week |  |  |  | District |  | Sort order | Sorted Names
 |  | 1 | [NAME] | 2003-03-10 00:00:00 | 43 | 2 | 21298.56 | 495.3153488372092 |  |  | 9 | Dallas - Shreveport |  | 9 | -
 |  | 2 | [NAME] | 2005-01-17 00:00:00 | 43 | 25 | 9994.01 | 232.4188372093023 |  |  | 12 | Houston - Austin - San Antonio - Albuquerque |  | 12 | Atlanta - Charleston
 |  | 3 | [NAME] | 2006-03-04 00:00:00 | 43 | 31 | 8950.63 | 208.1541860465116 |  |  | 22 | Newark - White Plains |  | 22 | Birmingham - Memphis
 |  | 4 | [NAME] | 2006-01-16 00:00:00 | 43 | 42 | 7563 | 175.8837209302326 |  |  | 8 | Cleveland - Pittsburgh - Cincinnati |  | 8 | Boston
 |  | 5 | [NAME] | 2003-05-12 00:00:00 | 43 | 68 | 5352.47 | 124.4760465116279 |  |  | 31 | Vancouver - Kelowna |  | 31 | Buffalo - Utica
 |  | 6 | [NAME] | 2010-02-15 00:00:00 | 43 | 71 | 5031.71 | 117.016511627907 |  |  | 33 | Wichita - Oklahoma City |  | 33 | Calgary - Edmonton
 |  | 7 | [NAME] | 2005-11-21 00:00:00 | 43 | 83 | 3982.76 | 92.62232558139536 |  |  | 23 | Orlando - Tampa |  | 23 | Chicago - Milwaukee
 |  | 8 | [NAME] | 2010-03-18 00:00:00 | 43 | 100 | 2854.35 | 66.38023255813954 |  |  | 21 | New York - Long Island |  | 21 | Cleveland - Pittsburgh - Cincinnati
 |  | 9 |  |  |  |  |  |  |  |  | 24 | Ottawa - Winnipeg |  | 24 | Dallas - Shreveport
 |  | 10 |  |  |  |  |  |  |  |  | 6 | Calgary - Edmonton |  | 6 | Des Moines - Omaha - Sioux Falls
 |  | 11 |  |  |  |  |  |  |  |  | 20 | New Orleans - Jackson |  | 20 | Detroit - Grand Rapids
 |  | 12 |  |  |  |  |  |  |  |  | 32 | Washington - Philadelphia |  | 32 | Houston - Austin - San Antonio - Albuquerque
 |  | 13 |  |  |  |  |  |  |  |  | 16 | Miami - Fort Myers |  | 16 | Indianapolis - Louisville
 |  | 14 |  |  |  |  |  |  |  |  | 27 | Salt Lake City - Boise |  | 27 | London - Cambridge
 |  | 15 |  |  |  |  |  |  |  |  | 17 | Montreal - Quebec City |  | 17 | Los Angeles - North Los Angeles
 |  | 16 |  |  |  |  |  |  |  |  | 10 | Des Moines - Omaha - Sioux Falls |  | 10 | Miami - Fort Myers
 |  | 17 |  |  |  |  |  |  |  |  | 18 | Nashville - Knoxville |  | 18 | Montreal - Quebec City
 |  | 18 |  |  |  |  |  |  |  |  | 28 | San Francisco - Concord |  | 28 | Nashville - Knoxville
 |  | 19 |  |  |  |  |  |  |  |  | 2 | Atlanta - Charleston |  | 2 | -New Acquisition-
 |  | 20 |  |  |  |  |  |  |  |  | 25 | Portland |  | 25 | New Orleans - Jackson
 |  | 21 |  |  |  |  |  |  |  |  | 14 | London - Cambridge |  | 14 | New York - Long Island
 |  | 22 |  |  |  |  |  |  |  |  | 3 | Birmingham - Memphis |  | 3 | Newark - White Plains
 |  |  |  |  |  |  |  |  |  |  | 30 | Toronto |  | 30 | Orlando - Tampa
 |  |  |  |  |  |  |  |  |  |  | 13 | Indianapolis - Louisville |  | 13 | Ottawa - Winnipeg
 |  |  |  |  |  |  |  |  |  |  | 5 | Buffalo - Utica |  | 5 | Portland
 |  |  |  |  |  |  |  |  |  |  | 29 | Saskatoon |  | 29 | Sacramento - Fresno
 |  |  | [NAME] | 1 |  |  |  |  |  |  | 19 | -New Acquisition- |  | 19 | Salt Lake City - Boise
 |  |  | Houston - Austin - San Antonio - Albuquerque | 12 |  |  |  |  |  |  | 15 | Los Angeles - North Los Angeles |  | 15 | San Francisco - Concord
 |  |  |  | 8 |  |  |  |  |  |  | 4 | Boston |  | 4 | Saskatoon
 |  |  |  |  |  |  |  |  |  |  | 7 | Chicago - Milwaukee |  | 7 | Toronto
 |  |  |  |  |  |  |  |  |  |  | 26 | Sacramento - Fresno |  | 26 | Vancouver - Kelowna
 |  |  |  |  |  |  |  |  |  |  | 11 | Detroit - Grand Rapids |  | 11 | Washington - Philadelphia
 |  |  |  |  |  |  |  |  |  |  | 1 | - |  | 1 | Wichita - Oklahoma City
 |  |  |  |  | 31 | 32 | 33 | 34
 |  |  |  | Total NAR | Q1 | Q2 | Q3 | Q4
 |  |  | Actuals | 21298.56 | 2162.69 | 11576.38 | 6494.940000000001 | 1064.55
 |  |  | Invisible | 0 | 0 | 2162.69 | 13739.07 | 20234.01
 |  |  |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  |  | Total | 60026.76 | 83549.18000000001 | 105270.56 | 85629 | 82094.72 | 79780.63000000002 | 81112.70000000001 | 70880.31 | 64673.41 | 88633.21000000002
 |  |  | Average | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | [NAME] | 671.75 | 560.08 | 930.86 | 1344.97 | 8626 | 1605.41 | 2244.32 | 1055.46 | 3195.16 | 1064.55
 |  |  | Tenure Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Sorting and Charts
 |  |  |  |  | No. | Value | Sort: Large | Position | Category |  | Chart total |  |  | Average/rep
 |  |  | Atlanta - Charleston |  | 1 | 15166 | 68189.89 | 8 | Dallas - Shreveport |  | 68189.89 | #N/A |  | 5 | 13637.978
 |  |  | Birmingham - Memphis |  | 2 | 23453.8 | 65027.49 | 11 | Houston - Austin - San Antonio - Albuquerque |  | 65027.49 | 65027.49 |  | 8 | 8128.43625
 |  |  | Boston |  | 3 | 6796 | 49552.66 | 5 | Calgary - Edmonton |  | 49552.66 | #N/A |  | 5 | 9910.532000000001
 |  |  | Buffalo - Utica |  | 4 | 20517 | 43011.96 | 27 | San Francisco - Concord |  | 43011.96 | #N/A |  | 7 | 6144.565714285714
 |  |  | Calgary - Edmonton |  | 5 | 49552.66 | 36000 | 21 | Newark - White Plains |  | 36000 | #N/A |  | 3 | 12000
 |  |  | Chicago - Milwaukee |  | 6 | 8873 | 34622.04 | 7 | Cleveland - Pittsburgh - Cincinnati |  | 34622.04 | #N/A |  | 3 | 11540.68
 |  |  | Cleveland - Pittsburgh - Cincinnati |  | 7 | 34622.04 | 32814 | 16 | Montreal - Quebec City |  | 32814 | #N/A |  | 5 | 6562.8
 |  |  | Dallas - Shreveport |  | 8 | 68189.89 | 31381.88 | 31 | Washington - Philadelphia |  | 31381.88 | #N/A |  | 4 | 7845.47
 |  |  | Des Moines - Omaha - Sioux Falls |  | 9 | 19363.01 | 31256.35 | 20 | New York - Long Island |  | 31256.35 | #N/A |  | 4 | 7814.0875
 |  |  | Detroit - Grand Rapids |  | 10 | 8006.23 | 30982.3 | 30 | Vancouver - Kelowna |  | 30982.3 | #N/A |  | 4 | 7745.575000000001
 |  |  | Houston - Austin - San Antonio - Albuquerque |  | 11 | 65027.49 | 30972 | 15 | Miami - Fort Myers |  | 30972 | #N/A |  | 4 | 7743
 |  |  | Indianapolis - Louisville |  | 12 | 24074.83 | 24074.83 | 12 | Indianapolis - Louisville |  | 24074.83 | #N/A |  | 4 | 6018.7075
 |  |  | London - Cambridge |  | 13 | 16357.59 | 23453.8 | 2 | Birmingham - Memphis |  | 23453.8 | #N/A |  | 3 | 7817.933333333333
 |  |  | Los Angeles - North Los Angeles |  | 14 | 16961 | 23325.8 | 19 | New Orleans - Jackson |  | 23325.8 | #N/A |  | 2 | 11662.9
 |  |  | Miami - Fort Myers |  | 15 | 30972 | 22193.17 | 23 | Ottawa - Winnipeg |  | 22193.17 | #N/A |  | 3 | 7397.723333333334
 |  |  | Montreal - Quebec City |  | 16 | 32814 | 22164.5 | 29 | Toronto |  | 22164.5 | #N/A |  | 4 | 5541.125
 |  |  | Nashville - Knoxville |  | 17 | 10218 | 21207.77 | 32 | Wichita - Oklahoma City |  | 21207.77 | #N/A |  | 3 | 7069.256666666667
 |  |  | -New Acquisition- |  | 18 | 13438.38 | 20517 | 4 | Buffalo - Utica |  | 20517 | #N/A |  | 3 | 6839
 |  |  | New Orleans - Jackson |  | 19 | 23325.8 | 19363.01 | 9 | Des Moines - Omaha - Sioux Falls |  | 19363.01 | #N/A |  | 3 | 6454.336666666667
 |  |  | New York - Long Island |  | 20 | 31256.35 | 17078.17 | 25 | Sacramento - Fresno |  | 17078.17 | #N/A |  | 5 | 3415.634
 |  |  | Newark - White Plains |  | 21 | 36000 | 17058 | 22 | Orlando - Tampa |  | 17058 | #N/A |  | 2 | 8529
 |  |  | Orlando - Tampa |  | 22 | 17058 | 16961 | 14 | Los Angeles - North Los Angeles |  | 16961 | #N/A |  | 3 | 5653.666666666667
 |  |  | Ottawa - Winnipeg |  | 23 | 22193.17 | 16357.59 | 13 | London - Cambridge |  | 16357.59 | #N/A |  | 2 | 8178.795
 |  |  | Portland |  | 24 | 14975 | 15889.41 | 26 | Salt Lake City - Boise |  | 15889.41 | #N/A |  | 2 | 7944.705
 |  |  | Sacramento - Fresno |  | 25 | 17078.17 | 15166 | 1 | Atlanta - Charleston |  | 15166 | #N/A |  | 2 | 7583
 |  |  | Salt Lake City - Boise |  | 26 | 15889.41 | 14975 | 24 | Portland |  | 14975 | #N/A |  | 3 | 4991.666666666667
 |  |  | San Francisco - Concord |  | 27 | 43011.96 | 13438.38 | 18 | -New Acquisition- |  | 13438.38 | #N/A |  | 2 | 6719.190000000001
 |  |  | Saskatoon |  | 28 | 7145.25 | 10218 | 17 | Nashville - Knoxville |  | 10218 | #N/A |  | 1 | 10218
 |  |  | Toronto |  | 29 | 22164.5 | 8873 | 6 | Chicago - Milwaukee |  | 8873 | #N/A |  | 2 | 4436.5
 |  |  | Vancouver - Kelowna |  | 30 | 30982.3 | 8006.23 | 10 | Detroit - Grand Rapids |  | 8006.23 | #N/A |  | 3 | 2668.743333333333
 |  |  | Washington - Philadelphia |  | 31 | 31381.88 | 7145.25 | 28 | Saskatoon |  | 7145.25 | #N/A |  | 1 | 7145.25
 |  |  | Wichita - Oklahoma City |  | 32 | 21207.77 | 6796 | 3 | Boston |  | 6796 | #N/A |  | 1 | 6796
 |  |  | [NAME] | NAR | Threshold X | Quota | [NAME]
 |  |  | P1 | 671.75 | 1 | 800 |  | 10
 |  |  | P2 | 560.08 | 2 | 800 |  | 11
 |  |  | P3 | 930.86 | 3 | 800 |  | 12
 |  |  | P4 | 1344.97 | 4 | 1000 |  | 13
 |  |  | P5 | 8626 | 5 | 800 |  | 14
 |  |  | P6 | 1605.41 | 6 | 800 |  | 15
 |  |  | P7 | 2244.32 | 7 | 1000 |  | 16
 |  |  | P8 | 1055.46 | 8 | 800 |  | 17
 |  |  | P9 | 3195.16 | 9 | 800 |  | 18
 |  |  | P10 | 1064.55 | 10 | 1000 | 8626 | 19