Spreadsheet: 215267d1361319773-summing-vlookup-values-sample-average-vlookup
Sheet: Tuesday

Date: | 2013-02-12 00:00:00
Agent Group: | FL COE
Agent Name | ACD Calls | Avg ACD Time | Avg ACW Time | % Agent Occupancy w/ ACW | % Agent Occupancy w/o ACW | Extn In Calls | [NAME] In Time | Extn Out Calls | [NAME] Time | ACD Time | ACW Time | Agent [NAME] | Other Time | AUX Time | Avail Time | Staffed Time
Totals | 6947 | 02:28:00 | 00:04:00 | 75 | 73 | 27 | 00:29:00 | 935 | 00:11:00 | 11 days, 22:08:10 | 09:51:49 | 06:28:32 | 12:08:04 | 1 day, 18:38:25 | 4 days, 7:16:54 | 19 days, 4:31:54
agent 8062005 | 105 | 01:54:00 | 00:03:00 | 79 | 77 | 0 |  | 13 | 00:01:00 | 03:19:14 | :05:53 | :05:03 | :03:03 | :35:32 | :56:02 | 05:04:47
agent [NAME] | 108 | 02:56:00 | 00:09:00 | 82 | 78 | 1 | 00:13:00 | 20 | 00:09:00 | 05:15:54 | :20:21 | :05:24 | :17:40 | :42:24 | 01:17:19 | 07:59:02
agent 8062020 | 126 | 02:27:00 | 00:00:00 | 80 | 80 | 0 |  | 20 | 00:28:00 | 05:08:52 | :00:00 | :06:17 | :25:31 | :44:35 | 01:27:15 | 07:52:30
agent [NAME] | 74 | 02:13:00 | 00:01:00 | 81 | 79 | 1 | 20:220:00 AM | 12 | 00:12:00 | 02:44:16 | :05:07 | :03:36 | :04:12 | :22:26 | :40:40 | 04:00:17
agent 8062031 | 105 | 03:10:00 | 00:15:00 | 82 | 76 | 0 |  | 10 | 00:08:00 | 05:32:34 | :27:41 | :05:05 | :02:45 | :37:28 | 01:20:42 | 08:06:15
agent 8062036 | 131 | 02:16:00 | 00:01:00 | 74 | 73 | 1 | 00:37:00 | 10 | 00:16:00 | 04:56:26 | :06:22 | :06:11 | :03:25 | 01:00:01 | 01:49:03 | 08:01:28
agent 8062043 | 126 | 02:27:00 | 00:00:00 | 73 | 73 | 0 |  | 7 | 00:30:00 | 05:07:40 | :00:42 | :05:54 | :04:33 | :44:50 | 01:58:48 | 08:02:27
agent 8062044 | 83 | 02:46:00 | 00:05:00 | 82 | 80 | 0 |  | 9 | 00:10:00 | 03:49:10 | :06:25 | :04:09 | :00:45 | :14:58 | :52:15 | 05:07:42
agent 8062053 | 161 | 02:00:00 | 00:03:00 | 76 | 74 | 0 |  | 20 | 00:06:00 | 05:22:41 | :09:30 | :08:01 | :03:23 | :32:05 | 01:48:00 | 08:03:40
agent 8062054 | 123 | 01:46:00 | 00:00:00 | 74 | 73 | 0 |  | 18 | 00:06:00 | 03:38:05 | :01:58 | :06:10 | :04:00 | 02:56:22 | 01:21:57 | 08:08:32
agent 8062056 | 150 | 02:00:00 | 00:02:00 | 76 | 74 | 1 | 00:33:00 | 25 | 00:12:00 | 04:59:57 | :06:46 | :07:25 | :10:23 | :52:29 | 01:46:01 | 08:03:01
agent 8062067 | 57 | 02:41:00 | 00:17:00 | 80 | 72 | 0 |  | 10 | 00:08:00 | 02:33:14 | :17:56 | :02:50 | :05:31 | :25:42 | :45:54 | 04:11:07
agent 8062077 | 90 | 01:53:00 | 00:00:00 | 70 | 70 | 0 |  | 25 | 00:10:00 | 02:49:34 | :00:00 | :04:22 | :10:30 | :19:41 | 01:19:16 | 04:43:23
agent 8062082 | 139 | 02:16:00 | 00:00:00 | 73 | 73 | 0 |  | 13 | 00:12:00 | 05:14:14 | :03:21 | :06:50 | :06:31 | :37:34 | 02:01:07 | 08:09:37
agent 8062088 | 119 | 02:43:00 | 00:05:00 | 83 | 80 | 0 |  | 13 | 00:14:00 | 05:22:32 | :10:41 | :06:01 | :32:36 | :31:49 | 01:17:46 | 08:01:25
agent 8062100 | 115 | 02:45:00 | 00:07:00 | 80 | 76 | 0 |  | 16 | 00:08:00 | 05:15:24 | :16:09 | :05:43 | :15:00 | :49:57 | 01:31:02 | 08:13:15
agent 8062109 | 141 | 02:15:00 | 00:00:00 | 79 | 78 | 0 |  | 27 | 00:12:00 | 05:16:29 | :03:26 | :07:10 | :25:24 | :37:24 | 01:30:14 | 08:00:07
agent 8062114 | 109 | 02:11:00 | 00:00:00 | 79 | 79 | 0 |  | 24 | 00:10:00 | 03:58:41 | :00:04 | :05:33 | :13:21 | :32:49 | 01:08:26 | 05:58:54
agent [NAME] | 74 | 02:34:00 | 00:00:00 | 76 | 76 | 0 |  | 14 | 00:13:00 | 03:09:28 | :01:07 | :03:40 | :14:23 | :31:37 | 01:05:07 | 05:05:22
agent 8062133 | 128 | 02:34:00 | 00:11:00 | 84 | 78 | 0 |  | 11 | 00:11:00 | 05:28:09 | :24:44 | :06:29 | :14:25 | :29:54 | 01:13:08 | 07:56:49
agent 8062134 | 117 | 02:52:00 | 00:04:00 | 82 | 80 | 0 |  | 11 | 00:20:00 | 05:36:14 | :10:48 | :06:01 | :07:24 | :43:27 | 01:17:09 | 08:01:03