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

Date: | 2013-02-11 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 | 7962 | 02:36:00 | 00:05:00 | 81 | 79 | 33 | 01:08:00 | 1129 | 00:10:00 | 1900-01-14 08:59:30 | 11:55:06 | 07:53:46 | 16:35:51 | 2 days, 0:56:51 | 1900-01-03 16:28:39 | 1900-01-21 14:49:43
agent 8062005 | 168 | 01:54:00 | 00:02:00 | 79 | 77 | 0 |  | 36 | 00:03:00 | 05:19:01 | 0:08:29 | 0:08:14 | :15:18 | :35:44 | 01:36:11 | 08:02:57
agent [NAME] | 156 | 01:57:00 | 00:07:00 | 83 | 78 | 0 |  | 32 | 00:11:00 | 05:03:39 | 0:17:42 | 0:24:04 | :05:50 | :58:10 | 01:15:18 | 08:04:43
agent 8062033 | 149 | 01:55:00 | 00:02:00 | 79 | 77 | 0 |  | 29 | 00:15:00 | 04:45:41 | 0:06:57 | 0:07:23 | :42:11 | :54:43 | 01:33:30 | 08:10:25
agent 8062053 | 143 | 02:07:00 | 00:06:00 | 73 | 70 | 0 |  | 18 | 00:12:00 | 05:03:21 | 0:13:19 | 0:06:39 | :05:39 | :31:01 | 02:03:12 | 08:03:11
agent 8062077 | 142 | 02:00:00 | 00:00:00 | 79 | 79 | 0 |  | 24 | 00:05:00 | 04:44:31 | 0:00:00 | 0:07:16 | :05:34 | 01:50:59 | 01:17:54 | 08:06:14
agent 8062054 | 140 | 01:59:00 | 00:01:00 | 70 | 68 | 1 | 01:43:00 | 20 | 00:04:00 | 04:37:54 | 0:06:18 | 0:06:58 | :04:57 | 01:03:07 | 02:08:16 | 08:07:30
agent 8062133 | 139 | 02:31:00 | 00:08:00 | 87 | 83 | 0 |  | 13 | 00:16:00 | 05:48:42 | 0:21:51 | 0:06:57 | :15:21 | :39:09 | :56:57 | 08:08:57
agent 8062109 | 133 | 02:21:00 | 00:00:00 | 84 | 82 | 3 | 02:14:00 | 33 | 00:16:00 | 05:12:00 | 0:09:16 | 0:06:38 | :29:36 | 01:01:27 | 01:03:48 | 08:02:45
agent 8062043 | 130 | 02:46:00 | 00:00:00 | 87 | 87 | 0 |  | 18 | 00:24:00 | 06:00:26 | 0:00:00 | 0:06:13 | :24:15 | :33:55 | 01:01:18 | 08:06:07
agent 8062100 | 128 | 02:33:00 | 00:07:00 | 86 | 83 | 2 | 02:08:00 | 17 | 00:16:00 | 05:27:19 | 0:17:12 | 0:06:17 | :22:19 | :53:14 | :59:06 | 08:05:27
agent 8062020 | 127 | 02:44:00 | 00:00:00 | 86 | 86 | 0 |  | 19 | 00:25:00 | 05:46:28 | 0:00:00 | 0:06:29 | :23:32 | :40:35 | 01:03:45 | 08:00:49
agent [NAME] | 125 | 02:53:00 | 00:08:00 | 88 | 84 | 0 |  | 20 | 00:12:00 | 05:59:56 | 0:16:11 | 0:06:10 | :15:29 | :30:53 | :55:11 | 08:03:50
agent 8062114 | 117 | 02:16:00 | 00:06:00 | 86 | 82 | 1 | 02:24:00 | 8 | 00:10:00 | 04:25:27 | 0:12:31 | 0:05:48 | :03:40 | :29:49 | :48:25 | 06:05:40
agent [NAME] | 114 | 02:26:00 | 00:03:00 | 65 | 64 | 1 | 01:03:00 | 13 | 00:06:00 | 04:37:57 | 0:05:11 | 0:05:12 | :03:07 | :36:28 | 02:34:30 | 08:02:25
agent [NAME] | 113 | 02:27:00 | 00:03:00 | 83 | 80 | 2 | :55 | 12 | 00:09:00 | 04:37:43 | 0:10:18 | 0:05:42 | :26:12 | 01:00:01 | 01:07:57 | 07:27:53
agent 8062056 | 112 | 02:27:00 | 00:00:00 | 66 | 66 | 0 |  | 23 | 00:12:00 | 04:33:32 | 0:00:19 | 0:05:20 | :05:19 | :46:07 | 02:30:10 | 08:00:47
agent 8062031 | 111 | 03:19:00 | 00:16:00 | 90 | 84 | 0 |  | 10 | 00:06:00 | 06:09:01 | 0:29:07 | 0:05:24 | :03:30 | :34:04 | :44:52 | 08:05:58
agent 8062088 | 110 | 02:53:00 | 00:06:00 | 80 | 78 | 0 |  | 9 | 00:08:00 | 05:17:40 | 0:10:34 | 0:05:07 | :30:31 | :32:25 | 01:30:00 | 08:06:17
agent 8062082 | 109 | 02:49:00 | 00:00:00 | 85 | 85 | 0 |  | 10 | 00:09:00 | 05:06:29 | 0:00:05 | 0:05:15 | :06:49 | 01:16:16 | :54:23 | 07:29:17
agent 8062044 | 98 | 02:29:00 | 00:03:00 | 89 | 87 | 0 |  | 4 | 00:06:00 | 04:03:16 | 0:04:57 | 0:04:50 | :00:19 | :20:20 | :31:44 | 05:05:26
agent 8062134 | 96 | 03:35:00 | 00:03:00 | 87 | 86 | 0 |  | 14 | 00:06:00 | 05:43:53 | 0:05:13 | 0:04:33 | :08:41 | :54:06 | :54:30 | 07:50:56
agent 8062067 | 55 | 02:39:00 | 00:09:00 | 84 | 79 | 0 |  | 10 | 00:32:00 | 02:25:25 | 0:09:42 | 0:02:43 | :12:42 | :43:21 | :33:56 | 04:07:49