Spreadsheet: 136353d1326565178-if-and-or-logic-question-sample_bonus
Sheet: Performance

 |  | # of weeks in year | 52
 |  | Period: | Period 7
 |  | Period ending date: | 2012-08-05 00:00:00 |  |  |  | 1
 |  | Number of YTD weeks: | 31 |  |  |  |  |  | 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 1 | Period 2 | Period 3 | Period 4 | Period 5 | Period 6 | Period 7 | Period 8 | Period 9 | Period 10 | Period 11 | Period 12 |  |  |  | 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 OTS Performance |  |  |  |  |  |  |  |  |  |  |  | YTD OTS Performance (Period 7) |  | Period OTS Quota |  |  |  |  |  |  |  |  |  |  |  | YTD OTS Quota (Period 7) |  |  | Number of Signed CSA's |  |  |  |  |  |  |  |  |  |  |  | YTD Signed CSA's  (Period 7) |  |  |  |  |  |  |  |  |  |  | Error checkers
 |  | ISE Name | Branch | District | Start Date in the position | 2012 YTD tenure (W's) (as of Period 7) | Annual OTS Quota |  | 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 | YTD % to Quota |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | YTD Total | Avg. per week |  | # of weeks | % OTS Revenue to OTS Quota | [NAME]. CSA per week | On Pace? |  |  |  |  | YTD OTS Performance | YTD Signed CSA |  | % rev. to budget | [NAME]. CSA per week |  | Ramp-up
 |  | [NAME] | Select a branch |  | 2012-04-13 00:00:00 | 16.28571428571428 |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  | 10000 |  | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20000 | 0.5 |  | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 0.7982456140350878 |  | 16.28571428571428 | 0 | 0.7982456140350878 | O |  |  |  |  | OK | OK |  | OK | OK |  |  | 0 | 20.77082852527117
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  | OK | OK |  | OK | OK |  |  | 0
 |  |  |  |  |  |  |  |  | 5 | 9 | 13 | 18 | 22 | 26 | 31 | 35 | 39 | 44 | 48 | 52
 |  |  |  |  |  |  |  |  | 2012-02-05 00:00:00 | 2012-03-04 00:00:00 | 2012-04-01 00:00:00 | 2012-05-06 00:00:00 | 2012-06-03 00:00:00 | 2012-07-01 00:00:00 | 2012-08-05 00:00:00 | 2012-09-02 00:00:00 | 2012-09-30 00:00:00 | 2012-11-04 00:00:00 | 2012-12-02 00:00:00 | 2012-12-31 00:00:00
 |  |  |  |  |  |  |  |  | -10 | -6 | -2 | 3 | 7 | 11 | 16 | 20 | 24 | 29 | 33 | 37
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0