Spreadsheet: 101440d1299565151-bonus-calculation-sample_bonus
Sheet: ISE Performance

 |  | # of weeks in year | 52
 |  | Period: | Period 2
 |  | Period ending date: | 2011-02-27 00:00:00
 |  | Number of YTD weeks: | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12
 |  |  |  |  |  |  |  |  | Period Purge Performance |  |  |  |  |  |  |  |  |  |  |  | YTD Purge Performance |  | Period [NAME] |  |  |  |  |  |  |  |  |  |  |  | YTD [NAME] (Period 2) |  |  | Number of Signed CSA's |  |  |  |  |  |  |  |  |  |  |  | YTD Signed CSA's |  |  |  |  |  |  |  |  |  |  | Error checkers
 |  | Name | Branch | District | Start Date in the position | 2011 YTD tenure (W's) (as of Period 2) | Annual [NAME] |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | YTD Total |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | YTD Total | % to Quota |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | YTD Total | Avg. per week |  | # of weeks | % Purge Revenue to [NAME] | [NAME]. CSA per week | On Pace? |  |  |  |  | YTD Purge Performance | YTD Signed CSA |  | % rev. to budget | [NAME]. CSA per week
 |  | [NAME] | Houston | Houston-San Antonio-Austin-Albuquerque | 2011-01-01 00:00:00 | 8.142857142857142 | 180000 |  | 12222 |  |  |  |  |  |  |  |  |  |  |  | 12222 |  | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 30000 | 0.4074 |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0.2456140350877193 |  | 8.142857142857142 | 0.4074 | 0.2456140350877193 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | Albuquerque | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 100000 |  | 14560 |  |  |  |  |  |  |  |  |  |  |  | 14560 |  | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 17000 | 34000 | 0.428235294117647 |  | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.125 |  | 8 | 0.428235294117647 | 0.125 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | [NAME] | Houston-San Antonio-Austin-Albuquerque | 2011-02-10 00:00:00 | 2.428571428571428 | 100000 |  |  | 4500 |  |  |  |  |  |  |  |  |  |  | 4500 |  |  | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 0.5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2.428571428571428 | 0.963529411764706 | 0 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | Albuquerque | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 100000 |  | 15654 |  |  |  |  |  |  |  |  |  |  |  | 15654 |  | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 30000 | 0.5218 |  | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.125 |  | 8 | 0.5218 | 0.125 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | Zach Praise | San Antonio | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 180000 |  | 11233 |  |  |  |  |  |  |  |  |  |  |  | 11233 |  | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 12000 | 24000 | 0.4680416666666667 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0.4680416666666667 | 0 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | Albuquerque | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 180000 |  | 5655 |  |  |  |  |  |  |  |  |  |  |  | 5655 |  | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 30000 | 0.1885 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0.1885 | 0 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | [NAME] | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 140000 |  | 15000 |  |  |  |  |  |  |  |  |  |  |  | 15000 |  | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 15000 | 30000 | 0.5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 | 0.5 | 0 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | San Antonio | Houston-San Antonio-Austin-Albuquerque | 2011-01-31 00:00:00 | 3.857142857142857 | 100000 |  | 3600 |  |  |  |  |  |  |  |  |  |  |  | 3600 |  | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 9000 | 18000 | 0.2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 3.857142857142857 | 0.4853333333333333 | 0 | O |  |  |  |  | OK | OK |  | OK | OK
 |  | [NAME] | San Antonio | Houston-San Antonio-Austin-Albuquerque | Before 2011 | 8 | 158000 |  | 19500 |  |  |  |  |  |  |  |  |  |  |  | 19500 |  | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 40000 | 0.4875 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0.125 |  | 8 | 0.4875 | 0.125 | O |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK
 |  |  | Select a branch |  | Select a date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK