Spreadsheet: 63073d1264026384-excel-2007-macro-that-selects-certain-rows-copy-of-performance-report-2-
Sheet: Pivot Data

Name | (All) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Output | Output Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
 | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Values | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | Grand Total |  |  |  |  |  |  | [NAME]
[NAME] | 0:00:00 | 111 days, 11:00:00 | 122 days, 6:18:00 | 120 days, 5:06:00 | 114 days, 22:12:00 | 121 days, 22:12:00 | 151 days, 15:06:00 | 143 days, 22:18:00 | 147 days, 2:54:00 | 153 days, 2:06:00 | 137 days, 14:06:00 | 143 days, 1:24:00 | 1467 days, 4:42:00 |  |  |  |  |  |  | [NAME] Parkinson
Logon Duration | 131 days, 21:59:48 | 123 days, 12:42:11 | 139 days, 7:31:25 | 134 days, 14:51:50 | 124 days, 13:12:16 | 142 days, 21:14:54 | 157 days, 16:01:45 | 165 days, 10:43:02 | 168 days, 6:06:41 | 177 days, 17:26:39 | 165 days, 5:58:58 | 157 days, 5:06:28 | 1788 days, 8:55:57 |  |  |  |  |  |  | [NAME]
# ACD Inc | 6747 | 6377 | 7114 | 3189 | 2705 | 3791 | 3596 | 3348 | 4442 | 3637 | 3201 | 3207 | 51354 |  |  |  |  |  |  | [NAME]
# PBX Inc Calls | 835 | 769 | 1347 | 3170 | 3048 | 3552 | 3599 | 3812 | 4103 | 3775 | 3193 | 3320 | 34523 |  |  |  |  |  |  | [NAME]
# PBX Out | 12970 | 13354 | 14332 | 14419 | 15010 | 15251 | 14545 | 16127 | 16202 | 16123 | 17067 | 16473 | 181873 |  |  |  |  |  |  | [NAME]
Avg ACD Inc | 1:20:53 | 1:22:04 | 1:18:24 | 1:20:25 | 1:21:47 | 1:22:24 | 1:38:55 | 1:48:13 | 1:42:31 | 1:46:47 | 1:49:36 | 1:49:02 | 18:41:01 |  |  |  |  |  |  | [NAME]
ACD Total Talk Duration | 19 days, 17:55:22 | 19 days, 6:38:26 | 20 days, 19:37:50 | 9 days, 14:13:35 | 8 days, 14:39:41 | 11 days, 21:37:18 | 11 days, 14:55:43 | 11 days, 6:59:32 | 13 days, 8:40:57 | 11 days, 0:43:14 | 9 days, 17:41:10 | 10 days, 2:18:17 | 157 days, 2:01:05 |  |  |  |  |  |  | [NAME]
Time on Work | 13 days, 16:49:30 | 10 days, 14:39:12 | 12 days, 16:54:27 | 12 days, 6:31:53 | 10 days, 7:06:52 | 34 days, 0:07:51 | 56 days, 16:40:00 | 61 days, 15:47:26 | 68 days, 11:58:17 | 66 days, 20:34:02 | 66 days, 3:47:18 | 60 days, 1:26:07 | 473 days, 12:22:55 |  |  |  |  |  |  | [NAME]
Time on Break | 26 days, 23:24:36 | 30 days, 18:42:19 | 29 days, 14:15:17 | 32 days, 10:35:25 | 29 days, 8:53:59 | 28 days, 2:52:43 | 31 days, 12:52:45 | 30 days, 18:14:04 | 29 days, 4:33:45 | 32 days, 1:11:07 | 33 days, 17:35:21 | 31 days, 4:09:51 | 365 days, 17:21:12 |  |  |  |  |  |  | [NAME]
Avg PBX Inc Call Duration | 1:57:02 | 1:54:08 | 1:19:49 | 1:21:10 | 1:22:04 | 1:20:59 | 1:47:28 | 1:48:07 | 1:53:11 | 1:57:45 | 1:56:08 | 2:05:54 | 20:43:45 |  |  |  |  |  |  | [NAME]
PBX Inc Call Total Duration | 3 days, 16:17:39 | 3 days, 6:02:17 | 4 days, 5:09:50 | 9 days, 14:37:11 | 9 days, 6:08:53 | 10 days, 18:26:54 | 11 days, 13:48:31 | 12 days, 5:23:48 | 13 days, 9:58:18 | 12 days, 16:45:28 | 10 days, 14:01:51 | 11 days, 19:56:39 | 113 days, 2:37:19 |  |  |  |  |  |  | [NAME]
PBX Avg Duration | 0:44:22 | 0:46:14 | 0:42:46 | 0:42:12 | 0:42:19 | 0:42:45 | 0:54:34 | 0:54:48 | 0:59:43 | 0:54:57 | 1:00:22 | 1:01:13 | 10:06:15 |  |  |  |  |  |  | [NAME]
PBX Total Duration | 20 days, 17:12:19 | 22 days, 3:21:05 | 22 days, 22:05:52 | 22 days, 15:32:51 | 23 days, 2:41:37 | 23 days, 18:16:43 | 23 days, 19:26:24 | 26 days, 0:00:32 | 26 days, 23:57:19 | 25 days, 12:51:05 | 28 days, 17:10:42 | 27 days, 20:10:48 | 294 days, 4:47:17 |  |  |  |  |  |  | [NAME]
Total Talk Time | 44 days, 3:25:20 | 44 days, 16:01:48 | 47 days, 22:53:32 | 41 days, 20:23:37 | 40 days, 23:30:11 | 46 days, 10:20:55 | 47 days, 0:10:38 | 49 days, 12:23:52 | 53 days, 18:36:34 | 49 days, 6:19:47 | 49 days, 0:53:43 | 49 days, 18:25:44 | 564 days, 9:25:41 |  |  |  |  |  |  | [NAME]
Total # Incoming Calls | 7582 | 7146 | 8461 | 6359 | 5753 | 7343 | 7195 | 7160 | 8545 | 7412 | 6394 | 6527 | 85877 |  |  |  |  |  |  | [NAME]
% of clocked time on Phone | #[NAME]! | 0.4007588785046729 | 0.392220366773071 | 0.3481312991269319 | 0.3565742352097583 | 0.3808176512579833 | 0.3100154494853734 | 0.344034327585264 | 0.3655185489377906 | 0.321801181846499 | 0.3564081274878948 | 0.3478851543335728 | 0.3846745082187833 |  |  |  |  |  |  | [NAME]
% of Talk time on Outbound Calls | 0.4693173952259092 | 0.4956497382432292 | 0.477975058963915 | 0.541169810308431 | 0.5639978523480834 | 0.5117596104350948 | 0.5065161649642319 | 0.5250841936575669 | 0.5020537239727829 | 0.5183421996167172 | 0.5855901934067107 | 0.5594137970168914 | 0.5212672516952778 |  |  |  |  |  |  | [NAME]
Total Inbound Talk Time | 23 days, 10:13:01 | 22 days, 12:40:43 | 25 days, 0:47:40 | 19 days, 4:50:46 | 17 days, 20:48:34 | 22 days, 16:04:12 | 23 days, 4:44:14 | 23 days, 12:23:20 | 26 days, 18:39:15 | 23 days, 17:28:42 | 20 days, 7:43:01 | 21 days, 22:14:56 | 270 days, 4:38:24 |  |  |  |  |  |  | Ronny Rowland
Option Button Trigger | 1
Company Total (copy from all above) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Values | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | Grand Total |  |  |  |  |  |  | [NAME]
[NAME] | 0:00:00 | 111 days, 11:00:00 | 122 days, 6:18:00 | 120 days, 5:06:00 | 114 days, 22:12:00 | 121 days, 22:12:00 | 151 days, 15:06:00 | 143 days, 22:18:00 | 147 days, 2:54:00 | 153 days, 2:06:00 | 137 days, 14:06:00 | 143 days, 1:24:00 | 1467 days, 4:42:00 |  |  |  |  |  |  | [NAME]
Logon Duration | 131 days, 21:59:48 | 123 days, 12:42:11 | 139 days, 7:31:25 | 134 days, 14:51:50 | 124 days, 13:12:16 | 142 days, 21:14:54 | 157 days, 16:01:45 | 165 days, 10:43:02 | 168 days, 6:06:41 | 177 days, 17:26:39 | 165 days, 5:58:58 | 157 days, 5:06:28 | 1788 days, 8:55:57
# ACD Inc | 6747 | 6377 | 7114 | 3189 | 2705 | 3791 | 3596 | 3348 | 4442 | 3637 | 3201 | 3207 | 51354
# PBX Inc Calls | 835 | 769 | 1347 | 3170 | 3048 | 3552 | 3599 | 3812 | 4103 | 3775 | 3193 | 3320 | 34523
# PBX Out | 12970 | 13354 | 14332 | 14419 | 15010 | 15251 | 14545 | 16127 | 16202 | 16123 | 17067 | 16473 | 181873
Avg ACD Inc | 1:20:53 | 1:22:04 | 1:18:24 | 1:20:25 | 1:21:47 | 1:22:24 | 1:38:55 | 1:48:13 | 1:42:31 | 1:46:47 | 1:49:36 | 1:49:02 | 18:41:01
ACD Total Talk Duration | 19 days, 17:55:22 | 19 days, 6:38:26 | 20 days, 19:37:50 | 9 days, 14:13:35 | 8 days, 14:39:41 | 11 days, 21:37:18 | 11 days, 14:55:43 | 11 days, 6:59:32 | 13 days, 8:40:57 | 11 days, 0:43:14 | 9 days, 17:41:10 | 10 days, 2:18:17 | 157 days, 2:01:05
Time on Work | 13 days, 16:49:30 | 10 days, 14:39:12 | 12 days, 16:54:27 | 12 days, 6:31:53 | 10 days, 7:06:52 | 34 days, 0:07:51 | 56 days, 16:40:00 | 61 days, 15:47:26 | 68 days, 11:58:17 | 66 days, 20:34:02 | 66 days, 3:47:18 | 60 days, 1:26:07 | 473 days, 12:22:55
Time on Break | 26 days, 23:24:36 | 30 days, 18:42:19 | 29 days, 14:15:17 | 32 days, 10:35:25 | 29 days, 8:53:59 | 28 days, 2:52:43 | 31 days, 12:52:45 | 30 days, 18:14:04 | 29 days, 4:33:45 | 32 days, 1:11:07 | 33 days, 17:35:21 | 31 days, 4:09:51 | 365 days, 17:21:12
Avg PBX Inc Call Duration | 1:57:02 | 1:54:08 | 1:19:49 | 1:21:10 | 1:22:04 | 1:20:59 | 1:47:28 | 1:48:07 | 1:53:11 | 1:57:45 | 1:56:08 | 2:05:54 | 20:43:45
PBX Inc Call Total Duration | 3 days, 16:17:39 | 3 days, 6:02:17 | 4 days, 5:09:50 | 9 days, 14:37:11 | 9 days, 6:08:53 | 10 days, 18:26:54 | 11 days, 13:48:31 | 12 days, 5:23:48 | 13 days, 9:58:18 | 12 days, 16:45:28 | 10 days, 14:01:51 | 11 days, 19:56:39 | 113 days, 2:37:19
PBX Avg Duration | 0:44:22 | 0:46:14 | 0:42:46 | 0:42:12 | 0:42:19 | 0:42:45 | 0:54:34 | 0:54:48 | 0:59:43 | 0:54:57 | 1:00:22 | 1:01:13 | 10:06:15
PBX Total Duration | 20 days, 17:12:19 | 22 days, 3:21:05 | 22 days, 22:05:52 | 22 days, 15:32:51 | 23 days, 2:41:37 | 23 days, 18:16:43 | 23 days, 19:26:24 | 26 days, 0:00:32 | 26 days, 23:57:19 | 25 days, 12:51:05 | 28 days, 17:10:42 | 27 days, 20:10:48 | 294 days, 4:47:17
Total Talk Time | 44 days, 3:25:20 | 44 days, 16:01:48 | 47 days, 22:53:32 | 41 days, 20:23:37 | 40 days, 23:30:11 | 46 days, 10:20:55 | 47 days, 0:10:38 | 49 days, 12:23:52 | 53 days, 18:36:34 | 49 days, 6:19:47 | 49 days, 0:53:43 | 49 days, 18:25:44 | 564 days, 9:25:41
Total # Incoming Calls | 7582 | 7146 | 8461 | 6359 | 5753 | 7343 | 7195 | 7160 | 8545 | 7412 | 6394 | 6527 | 85877
% of clocked time on Phone | #[NAME]! | 0.4007588785046729 | 0.392220366773071 | 0.3481312991269319 | 0.3565742352097583 | 0.3808176512579833 | 0.3100154494853734 | 0.344034327585264 | 0.3655185489377906 | 0.321801181846499 | 0.3564081274878948 | 0.3478851543335728 | 0.3846745082187833
% of Talk time on Outbound Calls | 0.4693173952259092 | 0.4956497382432292 | 0.477975058963915 | 0.541169810308431 | 0.5639978523480834 | 0.5117596104350948 | 0.5065161649642319 | 0.5250841936575669 | 0.5020537239727829 | 0.5183421996167172 | 0.5855901934067107 | 0.5594137970168914 | 0.5212672516952778
Total Inbound Talk Time | 23 days, 10:13:01 | 22 days, 12:40:43 | 25 days, 0:47:40 | 19 days, 4:50:46 | 17 days, 20:48:34 | 22 days, 16:04:12 | 23 days, 4:44:14 | 23 days, 12:23:20 | 26 days, 18:39:15 | 23 days, 17:28:42 | 20 days, 7:43:01 | 21 days, 22:14:56 | 270 days, 4:38:24
Chart Data
Month | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00