Spreadsheet: 98057d1297141093-excel-2007-sumif-criteria-sumifpvt
Sheet: Input Sheet

Input Sheet |  | Start Date |  |  |  |  |  |  |  |  |  |  | # Units Achieved vs [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # Productive Hours
 |  | 2011-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 3600 | 3600 | 3600 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Team Name | Day | Date | Base Rostered Hours | Rostered Hours (Annual Leave adjusted) | Unplanned Leave | Unavailable Hours | Annual Leave | Overtime hours | Management Representative | Actual Work Hours | Comments |  | Handle Time | Outbound Campaign | Account Maintenance | Emails | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Task | Total Tasks | Productive Hours | Productive % |  |  |  |  |  | Total Productive Hours
Adrian Jimenez |  |  | 7 |  |  |  |  |  |  |  | Emails |  | 100 | 0 | 2100 | 52
[NAME] |  |  | 0
[NAME] |  |  | 7 |  |  | 4 |  |  |  |  | Buddying |  | 11824 | 0 | 3669 | 28
[NAME] |  |  | 0
[NAME] |  |  | 0
Wahed Shareef |  |  | 0
[NAME] |  |  | 0
[NAME] |  |  | 7 |  | 7 |  |  |  | No |  | SL
Ankit Dalal |  |  | 0
Agent10 |  |  | 0
Agent11 |  |  | 0
Agent12 |  |  | 0
Agent13 |  |  | 0
Agent14 |  |  | 0
Agent15 |  |  | 0
Agent16 |  |  | 0
Agent17 |  |  | 0
Agent18 |  |  | 0
Agent19 |  |  | 0
Agent20 |  |  | 0
Agent21 |  |  | 0
Agent22 |  |  | 0
Agent23 |  |  | 0
Agent24 |  |  | 0
 |  |  | 6 |  |  |  |  |  |  |  | Emails |  | 60 | 0 | 2100 | 121
 |  |  | 0
 |  |  | 7 |  |  | 4 |  |  |  |  | Buddying |  | 25489 | 0 | 310 | 22
 |  |  | 0
 |  |  | 3.5 |  |  | 2 |  |  |  |  | Buddying |  | 294 | 0 | 3600 | 52
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 491 | 0 | 0 | 100
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 21650 | 0 | 122 | 17
 |  |  | 0
 |  |  | 7 |  |  |  |  | 0.5 |  |  |  |  | 2235 | 3066 | 6904 | 67
 |  |  | 0
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 21016 | 0 | 733 | 12
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 5.5 |  |  |  |  |  |  |  |  |  | 145 | 0 | 0 | 98
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 22663 | 0 | 518 | 24
 |  |  | 0
 |  |  | 7 |  |  | 3 |  |  |  |  |  |  | 4563 | 4205 | 3244 | 37
 |  |  | 0
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 23309 | 0 | 17 | 4
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 4 |  |  |  |  |  |  |  |  |  | 9834 | 44 | 0 | 3
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 5 |  |  |  |  |  |  |  |  |  | 1278 | 0 | 0 | 118
 |  |  | 0
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 19718 | 78 | 208 | 35
 |  |  | 3.5 |  |  |  |  |  |  |  |  |  | 596 | 0 | 0 | 49
 |  |  | 7 |  |  |  |  | 2 |  |  |  |  | 2163 | 6424 | 776 | 114
 |  |  | 0
 |  |  | 2.5 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 41
 |  |  | 7 |  |  |  |  |  |  |  |  |  | 22646 | 0 | 57 | 8
 |  |  | 4 |  |  |  |  |  |  |  |  |  | 178 | 0 | 0 | 55
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0