Spreadsheet: 106275d1303439773-sum-if-to-compare-workload-by-person-supervisorperf
Sheet: Sheet1

am shift | ACD Calls | Calls Handled | [NAME] | % Aban Calls | % Ans in 20 | % Ans in 30 | % Ans in 40 | % Ans in 60 | AHT | Avg ACD Time | Avg ACW Time | [NAME] | Work load FTE | ACD FTE | ACW FTE | [NAME] | ASA | AM Supervisor |  | am shift | ACD Calls | Calls Handled | [NAME] | % Aban Calls | % Ans in 20 | % Ans in 30 | % Ans in 40 | % Ans in 60 | AHT | Avg ACD Time | Avg ACW Time | [NAME] | Work load FTE | ACD FTE | ACW FTE | [NAME] | ASA | pm Supervisor |  | pm shift | ACD Calls | Calls Handled | [NAME] | % Aban Calls | % Ans in 20 | % Ans in 30 | % Ans in 40 | % Ans in 60 | AHT | Avg ACD Time | Avg ACW Time | [NAME] | Work load FTE | ACD FTE | ACW FTE | [NAME] | ASA | Supervisor
2010-03-16 00:00:00 | 162 | 160 | 2 | 1 | 94 | 94 | 94 | 95 | 448 | 233 | 154 | 60 | 37 | 21 | 14 | 245 | 6 | [NAME] |  | 2010-03-16 00:00:00 | 162 | 160 | 2 | 1 | 94 | 94 | 94 | 95 | 448 | 233 | 154 | 60 | 37 | 21 | 14 | 245 | 6 | [NAME] |  | 2010-03-16 00:00:00 | 162 | 160 | 2 | 1 | 94 | 94 | 94 | 95 | 448 | 233 | 154 | 60 | 37 | 21 | 14 | 245 | 6 | [NAME]
2010-03-17 00:00:00 | 137 | 136 | 1 | 1 | 96 | 95 | 97 | 99 | 465 | 233 | 191 | 41 | 34 | 18 | 14 | 116 | 3 | [NAME] |  | 2010-03-17 00:00:00 | 137 | 136 | 1 | 1 | 96 | 95 | 97 | 99 | 465 | 233 | 191 | 41 | 34 | 18 | 14 | 116 | 3 | [NAME] |  | 2010-03-17 00:00:00 | 129 | 127 | 2 | 2 | 96 | 95 | 96 | 96 | 561 | 229 | 268 | 64 | 38 | 16 | 19 | 87 | 3 | [NAME]
2010-03-18 00:00:00 | 115 | 115 | 0 | 0 | 98 | 97 | 98 | 99 | 468 | 205 | 220 | 43 | 29 | 14 | 14 | 211 | 3 | [NAME] |  | 2010-03-18 00:00:00 | 115 | 115 | 0 | 0 | 98 | 97 | 98 | 99 | 468 | 205 | 220 | 43 | 29 | 14 | 14 | 211 | 3 | [NAME] |  | 2010-03-18 00:00:00 | 133 | 133 | 0 | 0 | 98 | 98 | 98 | 99 | 373 | 177 | 158 | 37 | 26 | 13 | 12 | 132 | 2 | [NAME]
2010-03-19 00:00:00 | 159 | 156 | 3 | 2 | 90 | 91 | 91 | 93 | 428 | 205 | 162 | 61 | 35 | 18 | 14 | 329 | 10 | [NAME] |  | 2010-03-19 00:00:00 | 159 | 156 | 3 | 2 | 90 | 91 | 91 | 93 | 428 | 205 | 162 | 61 | 35 | 18 | 14 | 329 | 10 | [NAME] |  | 2010-03-19 00:00:00 | 181 | 178 | 3 | 2 | 93 | 93 | 93 | 94 | 347 | 176 | 118 | 54 | 33 | 17 | 12 | 329 | 7 | [NAME]
2010-03-20 00:00:00 | 79 | 79 | 0 | 0 | 99 | 97 | 99 | 100 | 373 | 175 | 139 | 59 | 16 | 8 | 6 | 41 | 4 | [NAME] |  | 2010-03-20 00:00:00 | 79 | 79 | 0 | 0 | 99 | 97 | 99 | 100 | 373 | 175 | 139 | 59 | 16 | 8 | 6 | 41 | 4 | [NAME] |  | 2010-03-20 00:00:00 | 80 | 80 | 0 | 0 | 99 | 98 | 99 | 99 | 487 | 222 | 183 | 83 | 20 | 10 | 8 | 67 | 2 | [NAME]
2010-03-21 00:00:00 | 95 | 94 | 1 | 1 | 97 | 95 | 97 | 98 | 392 | 218 | 107 | 68 | 20 | 11 | 6 | 136 | 5 | [NAME] |  | 2010-03-21 00:00:00 | 95 | 94 | 1 | 1 | 97 | 95 | 97 | 98 | 392 | 218 | 107 | 68 | 20 | 11 | 6 | 136 | 5 | [NAME] |  | 2010-03-21 00:00:00 | 135 | 134 | 1 | 1 | 91 | 91 | 92 | 93 | 396 | 174 | 147 | 75 | 28 | 13 | 11 | 157 | 9 | [NAME]
2010-03-22 00:00:00 | 249 | 245 | 4 | 2 | 91 | 91 | 92 | 93 | 474 | 198 | 197 | 79 | 60 | 27 | 27 | 233 | 9 | [NAME] |  | 2010-03-22 00:00:00 | 249 | 245 | 4 | 2 | 91 | 91 | 92 | 93 | 474 | 198 | 197 | 79 | 60 | 27 | 27 | 233 | 9 | [NAME] |  | 2010-03-22 00:00:00 | 156 | 154 | 2 | 1 | 87 | 85 | 88 | 93 | 565 | 228 | 254 | 83 | 45 | 19 | 22 | 175 | 11 | [NAME]
2010-03-23 00:00:00 | 233 | 230 | 3 | 1 | 89 | 89 | 89 | 91 | 469 | 251 | 168 | 50 | 57 | 33 | 21 | 385 | 15 | [NAME] |  | 2010-03-23 00:00:00 | 233 | 230 | 3 | 1 | 89 | 89 | 89 | 91 | 469 | 251 | 168 | 50 | 57 | 33 | 21 | 385 | 15 | [NAME] |  | 2010-03-23 00:00:00 | 162 | 160 | 2 | 1 | 94 | 94 | 94 | 95 | 448 | 233 | 154 | 60 | 37 | 21 | 14 | 245 | 6 | [NAME]
2010-03-24 00:00:00 | 172 | 169 | 3 | 2 | 95 | 94 | 95 | 96 | 517 | 215 | 234 | 69 | 45 | 20 | 22 | 315 | 5 | [NAME] |  | 2010-03-24 00:00:00 | 172 | 169 | 3 | 2 | 95 | 94 | 95 | 96 | 517 | 215 | 234 | 69 | 45 | 20 | 22 | 315 | 5 | [NAME] |  | 2010-03-24 00:00:00 | 137 | 136 | 1 | 1 | 96 | 95 | 97 | 99 | 465 | 233 | 191 | 41 | 34 | 18 | 14 | 116 | 3 | [NAME]
2010-03-25 00:00:00 | 165 | 159 | 6 | 4 | 87 | 87 | 87 | 88 | 509 | 197 | 247 | 65 | 42 | 17 | 22 | 404 | 16 | [NAME] |  | 2010-03-25 00:00:00 | 165 | 159 | 6 | 4 | 87 | 87 | 87 | 88 | 509 | 197 | 247 | 65 | 42 | 17 | 22 | 404 | 16 | [NAME] |  | 2010-03-25 00:00:00 | 115 | 115 | 0 | 0 | 98 | 97 | 98 | 99 | 468 | 205 | 220 | 43 | 29 | 14 | 14 | 211 | 3 | [NAME]
2010-03-26 00:00:00 | 231 | 225 | 6 | 3 | 85 | 85 | 86 | 89 | 395 | 190 | 149 | 56 | 47 | 24 | 19 | 341 | 16 | [NAME] |  | 2010-03-26 00:00:00 | 231 | 225 | 6 | 3 | 85 | 85 | 86 | 89 | 395 | 190 | 149 | 56 | 47 | 24 | 19 | 341 | 16 | [NAME] |  | 2010-03-26 00:00:00 | 159 | 156 | 3 | 2 | 90 | 91 | 91 | 93 | 428 | 205 | 162 | 61 | 35 | 18 | 14 | 329 | 10 | jane
2010-03-27 00:00:00 | 123 | 123 | 0 | 0 | 100 | 100 | 100 | 100 | 429 | 200 | 166 | 62 | 28 | 14 | 11 | 0 | 0 | [NAME] |  | 2010-03-27 00:00:00 | 123 | 123 | 0 | 0 | 100 | 100 | 100 | 100 | 429 | 200 | 166 | 62 | 28 | 14 | 11 | 0 | 0 | [NAME] |  | 2010-03-27 00:00:00 | 79 | 79 | 0 | 0 | 99 | 97 | 99 | 100 | 373 | 175 | 139 | 59 | 16 | 8 | 6 | 41 | 4 | [NAME]
2010-03-28 00:00:00 | 77 | 77 | 0 | 0 | 100 | 100 | 100 | 100 | 493 | 242 | 200 | 50 | 20 | 11 | 9 | 6 | 0 | [NAME] |  | 2010-03-28 00:00:00 | 77 | 77 | 0 | 0 | 100 | 100 | 100 | 100 | 493 | 242 | 200 | 50 | 20 | 11 | 9 | 6 | 0 | [NAME] |  | 2010-03-28 00:00:00 | 95 | 94 | 1 | 1 | 97 | 95 | 97 | 98 | 392 | 218 | 107 | 68 | 20 | 11 | 6 | 136 | 5 | [NAME]
 | Data
AM Supervisor | Sum of ACD Calls | Sum of Calls Handled | Sum of Aban Calls | Sum of % Aban Calls | Sum of % Ans in 20 | Sum of % Ans in 30 | Sum of [NAME]
[NAME] | 683 | 668 | 15 | 9 | 365 | 363 | 1271
[NAME] | 336 | 333 | 3 | 2 | 290 | 286 | 422
[NAME] | 570 | 566 | 4 | 2 | 385 | 384 | 507
[NAME] | 408 | 401 | 7 | 4 | 181 | 182 | 562
Grand Total | 1997 | 1968 | 29 | 17 | 1221 | 1215 | 2762