Spreadsheet: 330457d1404754467-new-here-need-help-with-data-extraction-in-excel-ad_report
Sheet: Sheet1

 | Adherence
 |  | Date Range: 5/1/14 - 5/31/14
 |  | Agent: 607 [NAME], [NAME]
 |  | Total for 607 Jackson, [NAME]
 |  | Scheduled Activities |  |  | Scheduled Time |  | Actual Time |  | Min. in Adherence |  | Min. out Adherence |  | Percent in Adherence | +/- Min. in Conformance |  |  | Percent in Conformance |  |  | Percent of Total Schedule | Percent of Total Actual
 |  | Assist Others |  |  | 00:00:00 |  | 03:59:00 |  | 0 |  | 0 |  | 0 | 239 |  |  | 0 |  |  | 0 | 0.0202
 |  | Break |  |  | 00:00:00 |  | 03:34:00 |  | 0 |  | 0 |  | 0 | 214 |  |  | 0 |  |  | 0 | 0.0181
 |  | Default Aux |  |  | 00:00:00 |  | 00:04:00 |  | 0 |  | 0 |  | 0 | 4 |  |  | 0 |  |  | 0 | 0.0003
 |  | Job Assignments |  |  | 1 day, 15:33:00 |  | 1 day, 20:29:00 |  | 2360 |  | 13 |  | 0.9945 | 296 |  |  | 1.1247 |  |  | 0.2008 | 0.2251
 |  | Login |  |  | 4 days, 21:17:00 |  | 4 days, 13:44:00 |  | 6473 |  | 564 |  | 0.9199 | -453 |  |  | 0.9356 |  |  | 0.5954 | 0.5553
 |  | Logout |  |  | 1 day, 10:32:00 |  | 1 day, 9:53:00 |  | 1997 |  | 111 |  | 0.9638 | -39 |  |  | 0.9812 |  |  | 0.1753 | 0.1715
 |  | Meeting |  |  | 01:23:00 |  | 01:39:00 |  | 83 |  | 0 |  | 1 | 16 |  |  | 1.1928 |  |  | 0.007 | 0.0084
 |  | Outbound / Assist |  |  | 04:00:00 |  | 00:00:00 |  | 0 |  | 240 |  | 0 | -240 |  |  | 0 |  |  | 0.0203 | 0
 |  | Training |  |  | 00:15:00 |  | 00:14:00 |  | 14 |  | 1 |  | 0.9333 | -1 |  |  | 0.9333 |  |  | 0.0013 | 0.0012
 |  | Total |  |  | 8 days, 5:00:00 |  | 8 days, 5:36:00 |  | 10927 |  | 929 |  | 0.9245 | 36
 |  | Agent: 553 [NAME], [NAME]
 |  | Total for 553 [NAME], [NAME]
 |  | Scheduled Activities |  |  | Scheduled Time |  | Actual Time |  | Min. in Adherence |  | Min. out Adherence |  | Percent in Adherence | +/- Min. in Conformance |  |  | Percent in Conformance |  |  | Percent of Total Schedule | Percent of Total Actual
 |  | Assist Others |  |  | 01:27:00 |  | 04:12:00 |  | 0 |  | 87 |  | 0 | 165 |  |  | 2.8966 |  |  | 0.0081 | 0.0235
 |  | Break |  |  | 00:00:00 |  | 09:48:00 |  | 0 |  | 0 |  | 0 | 588 |  |  | 0 |  |  | 0 | 0.0549
 |  | Computer Problems |  |  | 00:00:00 |  | 00:09:00 |  | 0 |  | 0 |  | 0 | 9 |  |  | 0 |  |  | 0 | 0.0008
 |  | Default Aux |  |  | 00:00:00 |  | 02:15:00 |  | 0 |  | 0 |  | 0 | 135 |  |  | 0 |  |  | 0 | 0.0126
 |  | Job Assignments |  |  | 00:00:00 |  | 00:11:00 |  | 0 |  | 0 |  | 0 | 11 |  |  | 0 |  |  | 0 | 0.001
 |  | Login |  |  | 5 days, 7:36:00 |  | 4 days, 12:08:00 |  | 6341 |  | 1315 |  | 0.8282 | -1168 |  |  | 0.8474 |  |  | 0.7167 | 0.6055
 |  | Logout |  |  | 1 day, 18:15:00 |  | 1 day, 21:39:00 |  | 2100 |  | 467 |  | 0.8284 | 204 |  |  | 1.0805 |  |  | 0.2373 | 0.2556
 |  | Meeting |  |  | 02:00:00 |  | 01:47:00 |  | 106 |  | 14 |  | 0.8833 | -13 |  |  | 0.8917 |  |  | 0.0112 | 0.01
 |  | Outbound / Assist |  |  | 04:30:00 |  | 00:00:00 |  | 0 |  | 270 |  | 0 | -270 |  |  | 0 |  |  | 0.0253 | 0
 |  | Training |  |  | 00:15:00 |  | 06:26:00 |  | 0 |  | 15 |  | 0 | 371 |  |  | 25.7333 |  |  | 0.0014 | 0.036
 |  | Total |  |  | 7 days, 10:03:00 |  | 7 days, 10:35:00 |  | 8547 |  | 2168 |  | 0.8001 | 32
 |  | Agent: [NAME], April
 |  | Total for 258 Jackson, April
 |  | Scheduled Activities |  |  | Scheduled Time |  | Actual Time |  | Min. in Adherence |  | Min. out Adherence |  | Percent in Adherence | +/- Min. in Conformance |  |  | Percent in Conformance |  |  | Percent of Total Schedule | Percent of Total Actual
 |  | Assist Others |  |  | 00:00:00 |  | 07:25:00 |  | 0 |  | 0 |  | 0 | 445 |  |  | 0 |  |  | 0 | 0.0391
 |  | Break |  |  | 00:00:00 |  | 06:13:00 |  | 0 |  | 0 |  | 0 | 373 |  |  | 0 |  |  | 0 | 0.0328
 |  | Computer Problems |  |  | 00:00:00 |  | 00:20:00 |  | 0 |  | 0 |  | 0 | 20 |  |  | 0 |  |  | 0 | 0.0018
 |  | Default Aux |  |  | 00:00:00 |  | 00:50:00 |  | 0 |  | 0 |  | 0 | 50 |  |  | 0 |  |  | 0 | 0.0044
 |  | Job Assignments |  |  | 00:00:00 |  | 10:33:00 |  | 0 |  | 0 |  | 0 | 633 |  |  | 0 |  |  | 0 | 0.0556
 |  | Login |  |  | 4 days, 11:30:00 |  | 3 days, 16:48:00 |  | 5026 |  | 1424 |  | 0.7792 | -1122 |  |  | 0.8261 |  |  | 0.5703 | 0.4683
 |  | Logout |  |  | 2 days, 23:15:00 |  | 3 days, 1:40:00 |  | 4011 |  | 331 |  | 0.9383 | 145 |  |  | 1.0339 |  |  | 0.378 | 0.3885
 |  | Meeting |  |  | 02:00:00 |  | 00:00:00 |  | 0 |  | 120 |  | 0 | -120 |  |  | 0 |  |  | 0.0106 | 0
 |  | Outbound / Assist |  |  | 07:30:00 |  | 00:00:00 |  | 0 |  | 450 |  | 0 | -450 |  |  | 0 |  |  | 0.0398 | 0
 |  | Training |  |  | 00:15:00 |  | 01:48:00 |  | 14 |  | 1 |  | 0.9333 | 93 |  |  | 7.2 |  |  | 0.0013 | 0.0095
 |  | Total |  |  | 7 days, 20:30:00 |  | 7 days, 21:37:00 |  | 9051 |  | 2326 |  | 0.8003 | 67