Spreadsheet: 91155d1290887759-calculate-quota-book3_test
Sheet: Master YTD NAR Quota

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Periods
 |  | Master [NAME] NAR Quota |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 1
 |  | 52 | YTD Weeks in Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 2
 |  | 7 | # of days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 3
 |  | 200 | Quota (2011) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 4
 |  | 2010-12-31 00:00:00 | Period 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-28 00:00:00 | 2010-05-02 00:00:00 | 2010-05-30 00:00:00 | 2010-06-27 00:00:00 | 2010-07-01 00:00:00 | 2010-08-29 00:00:00 | 2010-09-26 00:00:00 | 2010-10-31 00:00:00 | 2010-11-28 00:00:00 | 2010-12-31 00:00:00 |  | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-28 00:00:00 | 2010-05-02 00:00:00 | 2010-05-30 00:00:00 | 2010-06-27 00:00:00 | 2010-07-01 00:00:00 | 2010-08-29 00:00:00 | 2010-09-26 00:00:00 | 2010-10-31 00:00:00 | 2010-11-28 00:00:00 | 2010-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 5
 |  | 30.3333 | Months |  |  |  |  |  |  |  | Tenure (from hire date) in weeks |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual Quota |  |  |  |  |  |  |  |  |  |  |  |  | Period Quota (date of hire) |  |  |  |  |  |  |  |  |  |  |  |  | Period Quota (including ramp up) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 6
 |  | 4.3333 | # of weeks in Month |  |  |  |  |  |  |  | Period start date | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-03-29 00:00:00 | 2010-05-03 00:00:00 | 2010-05-31 00:00:00 | 2010-06-28 00:00:00 | 2010-08-02 00:00:00 | 2010-08-30 00:00:00 | 2010-09-27 00:00:00 | 2010-11-01 00:00:00 | 2010-11-29 00:00:00 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 7
 |  |  |  |  |  |  |  |  |  |  | Period end date | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-28 00:00:00 | 2010-05-02 00:00:00 | 2010-05-30 00:00:00 | 2010-06-27 00:00:00 | 2010-07-01 00:00:00 | 2010-08-29 00:00:00 | 2010-09-26 00:00:00 | 2010-10-31 00:00:00 | 2010-11-28 00:00:00 | 2010-12-31 00:00:00 |  | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 5 |  | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 5 |  | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 8
 |  | HR Employee # | Name | Start Date in position | District | Tenure (M) | Tenure (W) | YTD (W) | Adjusted YTD Quota (W) | Position End date | Status | P1 (W) | P2 (W) | P3 (W) | P4 (W) | P5 (W) | P6 (W) | P7 (W) | P8 (W) | P9 (W) | P10 (W) | P11 (W) | P12 (W) |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 |  |  | Annual Quota | YTD (Period 12) Total Quota | Adjusted YTD (Period 12) Total Quota |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 9
 |  | 00008747 | [NAME] | 2007-07-09 00:00:00 | - | 41.90114494631312 | 181.5702313958587 | 52 | 52 |  | Active | 133.8571428571429 | 137.8571428571429 | 141.8571428571429 | 146.8571428571429 | 150.8571428571429 | 154.8571428571429 | 155.4285714285714 | 163.8571428571429 | 167.8571428571429 | 172.8571428571429 | 176.8571428571429 | 181.5714285714286 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 10400 | 10400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 10
 |  | 13 | [NAME] | 2010-01-01 00:00:00 | - | 12.00001318682768 | 51.99965714248038 | 51.99965714248038 | 38.99965714248038 |  | Active | 4.285714285714286 | 8.285714285714286 | 12.28571428571429 | 17.28571428571428 | 21.28571428571428 | 25.28571428571428 | 25.85714285714286 | 34.28571428571428 | 38.28571428571428 | 43.28571428571428 | 47.28571428571428 | 52 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 75 | 150 | 175 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 10400 | 8400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 11
 |  | 24 | [NAME] | 2010-05-10 00:00:00 | - | 7.74726126072666 | 33.57120722110684 | 33.57120722110684 | 20.57120722110684 |  | Active | -14.14285714285714 | -10.14285714285714 | -6.142857142857143 | -1.142857142857143 | 2.857142857142857 | 6.857142857142857 | 7.428571428571429 | 15.85714285714286 | 19.85714285714286 | 24.85714285714286 | 28.85714285714286 | 33.57142857142857 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  | 75 | 150 | 150 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 7000 | 4775 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 12
 |  | 00010687 | [NAME] | 2010-09-14 00:00:00 | - | 3.560443473014805 | 15.42846970161506 | 15.42846970161506 | 2.428469701615057 |  | Active | -32.28571428571428 | -28.28571428571428 | -24.28571428571428 | -19.28571428571428 | -15.28571428571429 | -11.28571428571429 | -10.71428571428571 | -2.285714285714286 | 1.714285714285714 | 6.714285714285714 | 10.71428571428571 | 15.42857142857143 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  |  |  |  | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  |  |  |  | 75 | 150 | 175 | 1000 |  |  | 10400 | 3600 | 1400
 |  | 00009775 | [NAME] | 2008-12-08 00:00:00 | - | 24.82420310351989 | 107.5707193084828 | 52 | 52 | 2010-06-20 00:00:00 | Terminated | 59.85714285714285 | 63.85714285714285 | 67.85714285714286 | 72.85714285714286 | 76.85714285714286 | 79.71426687596046 | 0 | 0 | 0 | 0 | 0 | 0 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 |  |  |  |  |  |  |  |  | 10400 | 10400 | 5000
 |  | 00000732 | [NAME] | 2004-11-15 00:00:00 | - | 73.74733378827888 | 319.5693215047489 | 52 | 52 |  | Active | 271.8571428571428 | 275.8571428571428 | 279.8571428571428 | 284.8571428571428 | 288.8571428571428 | 292.8571428571428 | 293.4285714285714 | 301.8571428571428 | 305.8571428571428 | 310.8571428571428 | 314.8571428571428 | 319.5714285714286 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 10400 | 10400
 |  | 00000346 | [NAME] | 2005-10-10 00:00:00 | - | 62.90116802326156 | 272.5696313951993 | 52 | 52 |  | Active | 224.8571428571429 | 228.8571428571429 | 232.8571428571429 | 237.8571428571429 | 241.8571428571429 | 245.8571428571429 | 246.4285714285714 | 254.8571428571429 | 258.8571428571428 | 263.8571428571428 | 267.8571428571428 | 272.5714285714286 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 10400 | 10400
 |  | 00008482 | [NAME] | 2010-09-13 00:00:00 | - | 3.593410542209387 | 15.57132590255594 | 15.57132590255594 | 2.571325902555937 |  | Active | -32.14285714285715 | -28.14285714285714 | -24.14285714285714 | -19.14285714285714 | -15.14285714285714 | -11.14285714285714 | -10.57142857142857 | -2.142857142857143 | 1.857142857142857 | 6.857142857142857 | 10.85714285714286 | 15.57142857142857 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  |  |  |  | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  |  |  |  | 75 | 150 | 175 | 1000 |  |  | 10400 | 3600 | 1400
 |  | 00010495 | [NAME] | 2010-06-02 00:00:00 | - | 6.989018669251284 | 30.28551459946659 | 30.28551459946659 | 17.28551459946659 |  | Active | -17.42857142857143 | -13.42857142857143 | -9.428571428571429 | -4.428571428571429 | -0.4285714285714285 | 3.571428571428572 | 4.142857142857143 | 12.57142857142857 | 16.57142857142857 | 21.57142857142857 | 25.57142857142857 | 30.28571428571428 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  |  |  |  |  | 75 | 75 | 175 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 6200 | 3925
 |  | 00010319 | [NAME] | 2010-02-08 00:00:00 | - | 10.74726455743358 | 46.57112150672693 | 46.57112150672693 | 33.57112150672693 |  | Active | -1.142857142857143 | 2.857142857142857 | 6.857142857142857 | 11.85714285714286 | 15.85714285714286 | 19.85714285714286 | 20.42857142857143 | 28.85714285714286 | 32.85714285714285 | 37.85714285714285 | 41.85714285714285 | 46.57142857142857 |  | 800 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 75 | 150 | 175 | 800 | 800 | 1000 | 800 | 800 | 1000 | 800 | 1000 |  |  | 10400 | 9600 | 7400
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -
 |  |  |  |  | -