Spreadsheet: 267008d1379908653-extract-specific-data-from-a-report-and-re-produce-cleaner-output-offset-for-svtf
Sheet: Tab 1 Data

Agent ID | Skill Group Name | Calls Handled In | Short Calls | Talk Time In | Avg Talk Time In | Avg Handle Time Total | Logged On Time (Per Agent) | Wrap Time Total | Avg Wrap Time Total | Hold Time Total | Avg Hold Time Total | Not Ready Time (Per Agent) | % Not Ready (Per Agent) | % Occupancy (Per Agent)
AC
9/20/2013
20322200 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 01:53 | 04:22:43 | 01:20 | 01:20 | 00:00 | 00:00 | 09:38 | 0.03666814789175987 | 0.0439002737402916
20322200 | GI_ON_DMK_EN_CSC_EXS_ALL | 14 | 0 | 01:04:12 | 04:35 | 08:01 | 04:22:43 | 45:08 | 03:01 | 09:53 | 00:40 | 09:38 | 0.03666814789175987 | 0.4746558368206024
20322200 | GI_ON_DMK_EN_CSC_NEW_ALL | 1 | 0 | 09:00 | 09:00 | 12:30 | 04:22:43 | 03:30 | 03:30 | 00:00 | 00:00 | 09:38 | 0.03666814789175987 | 0.08424792438745499
20322200 | GI_ON_EMP_EN_CSC_EXS_ALL | 4 | 0 | 11:08 | 02:47 | 05:30 | 04:22:43 | 10:50 | 02:42 | 00:00 | 00:00 | 09:38 | 0.03666814789175987 | 0.1202182322740555
20322200 | GI_ON_EMP_EN_CSC_NEW_ALL | 1 | 0 | 15:40 | 15:40 | 19:55 | 04:22:43 | 03:10 | 03:10 | 01:05 | 01:05 | 09:38 | 0.03666814789175987 | 0.1126054674386978
20322200 | GI_WP_000_EN_000_EMR_STJ | 0 | 0 | 00:00 | 00:00 | 00:00 | 04:22:43 | 00:00 | 00:00 | 00:00 | 00:00 | 09:38 | 0.03666814789175987 | 0.03666814789175987
Daily Total: |  | 20 | 0 | 01:40:00 | 05:00 | 08:01 | 04:22:43 | 01:03:58 | 02:54 | 10:58 | 00:30 | 57:48 | 0.03666814789175987 | 0.1453826427459717
Agent Total: |  | 20 | 0 | 01:40:00 | 05:00 | 08:01 | 04:22:43 | 01:03:58 | 02:54 | 10:58 | 00:30 | 57:48 | 0.03666814789175987 | 0.1453826427459717
[NAME]
9/20/2013
20322204 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 00:24 | 05:29:56 | 00:00 | 00:00 | 00:00 | 00:00 | 23:59 | 0.07269145548343658 | 0.07511618733406067
20322204 | GI_ON_DMK_EN_CSC_EXS_ALL | 6 | 0 | 01:10:58 | 11:50 | 19:02 | 05:29:56 | 25:52 | [NAME] | 17:22 | 02:54 | 23:59 | 0.07269145548343658 | 0.418923020362854
20322204 | GI_ON_DMK_EN_CSC_NEW_ALL | 5 | 0 | 01:06:08 | 13:14 | 20:42 | 05:29:56 | 22:19 | 04:28 | 15:03 | 03:01 | 23:59 | 0.07269145548343658 | 0.3863911926746368
20322204 | GI_ON_EMP_EN_CSC_EXS_ALL | 3 | 0 | 25:44 | 08:35 | 10:48 | 05:29:56 | 06:41 | 02:14 | 00:00 | 00:00 | 23:59 | 0.07269145548343658 | 0.1709941476583481
20322204 | GI_ON_EMP_EN_CSC_NEW_ALL | 0 | 0 | 00:00 | 00:00 | 00:00 | 05:29:56 | 00:00 | 00:00 | 00:00 | 00:00 | 23:59 | 0.07269145548343658 | 0.07269145548343658
Daily Total: |  | 14 | 0 | 02:42:50 | 11:38 | 15:41 | 05:29:56 | 54:52 | 03:26 | 32:25 | 02:02 | 01:59:55 | 0.07269145548343658 | 0.2248231917619705
Agent Total: |  | 14 | 0 | 02:42:50 | 11:38 | 15:41 | 05:29:56 | 54:52 | 03:26 | 32:25 | 02:02 | 01:59:55 | 0.07269145548343658 | 0.2248231917619705 |  |  | `
JG
9/20/2013
20322195 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 01:19 | [NAME] | 04:23 | 00:38 | 00:00 | 00:00 | 08:12 | 0.02291462942957878 | 0.04857715219259262
20322195 | GI_ON_DMK_EN_CSC_EXS_ALL | 9 | 0 | 01:50:54 | 12:19 | 16:08 | [NAME] | 34:15 | 03:48 | 00:00 | 00:00 | 08:12 | 0.02291462942957878 | 0.4285314977169037
20322195 | GI_ON_DMK_EN_CSC_NEW_ALL | 5 | 0 | 01:28:57 | 17:47 | 21:55 | [NAME] | 15:41 | 03:08 | 04:58 | 01:00 | 08:12 | 0.02291462942957878 | 0.328908771276474
20322195 | GI_ON_EMP_EN_CSC_EXS_ALL | 3 | 0 | 21:14 | 07:05 | 06:58 | [NAME] | 07:19 | 01:28 | 04:07 | 00:49 | 08:12 | 0.02291462942957878 | 0.1111266389489174
20322195 | GI_ON_EMP_EN_CSC_NEW_ALL | 0 | 0 | 00:00 | 00:00 | 00:00 | [NAME] | 00:00 | 00:00 | 00:00 | 00:00 | 08:12 | 0.02291462942957878 | 0.02291462942957878
20322195 | GI_WP_000_EN_000_EMR_STJ | 0 | 0 | 00:00 | 00:00 | 00:00 | [NAME] | 00:00 | 00:00 | 00:00 | 00:00 | 08:12 | 0.02291462942957878 | 0.02291462942957878
Daily Total: |  | 17 | 0 | 03:41:05 | 13:00 | 11:30 | [NAME] | 01:01:38 | 02:22 | 09:05 | 00:21 | 49:12 | 0.02291462942957878 | 0.1604955494403839
Agent Total: |  | 17 | 0 | 03:41:05 | 13:00 | 11:30 | [NAME] | 01:01:38 | 02:22 | 09:05 | 00:21 | 49:12 | 0.02291462942957878 | 0.1604955494403839
AL
9/20/2013
20322183 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 06:18 | 05:20:02 | 01:25 | 01:25 | 00:00 | 00:00 | 08:13 | 0.02567440830171108 | 0.04530778154730797
20322183 | GI_ON_DMK_EN_CSC_EXS_ALL | 20 | 0 | 02:03:18 | 06:10 | 09:07 | 05:20:02 | 57:46 | 02:53 | 01:10 | 00:04 | 08:13 | 0.02567440830171108 | 0.5947297215461731
20322183 | GI_ON_DMK_EN_CSC_NEW_ALL | 2 | 0 | 17:33 | 08:46 | 12:38 | 05:20:02 | 07:44 | 03:52 | 00:00 | 00:00 | 08:13 | 0.02567440830171108 | 0.1046765968203545
20322183 | GI_ON_EMP_EN_CSC_EXS_ALL | 4 | 0 | 28:12 | 07:03 | 12:52 | 05:20:02 | 19:34 | 04:54 | 03:43 | 00:56 | 08:13 | 0.02567440830171108 | 0.186490997672081
20322183 | GI_ON_EMP_EN_CSC_NEW_ALL | 2 | 0 | 05:35 | 02:48 | 06:54 | 05:20:02 | 07:18 | 03:39 | 00:54 | 00:27 | 08:13 | 0.02567440830171108 | 0.06593063473701477
20322183 | GI_WP_000_EN_000_EMR_STJ | 0 | 0 | 00:00 | 00:00 | 00:00 | 05:20:02 | 00:00 | 00:00 | 00:00 | 00:00 | 08:13 | 0.02567440830171108 | 0.02567440830171108
Daily Total: |  | 28 | 0 | 02:54:38 | 06:14 | 09:37 | 05:20:02 | 01:33:47 | 03:14 | 05:47 | 00:12 | 49:18 | 0.02567440830171108 | 0.1704683601856232
Agent Total: |  | 28 | 0 | 02:54:38 | 06:14 | 09:37 | 05:20:02 | 01:33:47 | 03:14 | 05:47 | 00:12 | 49:18 | 0.02567440830171108 | 0.1704683601856232
CL
9/20/2013
20322203 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 04:48 | 05:52:13 | 13:29 | 02:42 | 00:00 | 00:00 | 22:07 | 0.06279278546571732 | 0.130979984998703
20322203 | GI_ON_DMK_EN_CSC_EXS_ALL | 14 | 0 | 01:47:21 | 07:40 | 11:20 | 05:52:13 | 35:12 | 02:31 | 16:14 | 01:10 | 22:07 | 0.06279278546571732 | 0.4862537384033203
20322203 | GI_ON_DMK_EN_CSC_NEW_ALL | 4 | 0 | 40:37 | 10:09 | 13:03 | 05:52:13 | 11:36 | 02:54 | 00:00 | 00:00 | 22:07 | 0.06279278546571732 | 0.2110443413257599
20322203 | GI_ON_EMP_EN_CSC_EXS_ALL | 3 | 0 | 18:55 | 06:18 | 10:29 | 05:52:13 | 08:39 | 02:53 | 03:52 | 01:17 | 22:07 | 0.06279278546571732 | 0.1471158862113953
20322203 | GI_ON_EMP_EN_CSC_NEW_ALL | 0 | 0 | 00:00 | 00:00 | 00:00 | 05:52:13 | 00:00 | 00:00 | 00:00 | 00:00 | 22:07 | 0.06279278546571732 | 0.06279278546571732
Daily Total: |  | 21 | 0 | 02:46:53 | 07:57 | 10:15 | 05:52:13 | 01:08:56 | 02:39 | 20:06 | 00:46 | [NAME] | 0.06279278546571732 | 0.2076373398303986
Agent Total: |  | 21 | 0 | 02:46:53 | 07:57 | 10:15 | 05:52:13 | 01:08:56 | 02:39 | 20:06 | 00:46 | [NAME] | 0.06279278546571732 | 0.2076373398303986
MM
9/20/2013
20322192 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 02:10 | 05:30:03 | 04:10 | 01:02 | 00:00 | 00:00 | 07:08 | 0.02161288633942604 | 0.0504973977804184
20322192 | GI_ON_DMK_EN_CSC_EXS_ALL | 10 | 0 | 01:02:43 | 06:16 | 07:56 | 05:30:03 | 19:06 | 01:44 | 05:01 | 00:27 | 07:08 | 0.02161288633942604 | 0.2748573422431946
20322192 | GI_ON_DMK_EN_CSC_NEW_ALL | 3 | 0 | 38:49 | 12:56 | 19:34 | 05:30:03 | 03:50 | 01:17 | 16:03 | 05:21 | 07:08 | 0.02161288633942604 | 0.18391153216362
20322192 | GI_ON_EMP_EN_CSC_EXS_ALL | 3 | 0 | 50:11 | 16:44 | 20:24 | 05:30:03 | 08:54 | 02:58 | 02:06 | 00:42 | 07:08 | 0.02161288633942604 | 0.2070393413305283
20322192 | GI_ON_EMP_EN_CSC_NEW_ALL | 2 | 0 | 29:42 | 14:51 | 17:00 | 05:30:03 | 04:17 | 02:08 | 00:00 | 00:00 | 07:08 | 0.02161288633942604 | 0.1246275827288628
20322192 | GI_WP_000_EN_000_EMR_STJ | 0 | 0 | 00:00 | 00:00 | 00:00 | 05:30:03 | 00:00 | 00:00 | 00:00 | 00:00 | 07:08 | 0.02161288633942604 | 0.02161288633942604
Daily Total: |  | 18 | 0 | 03:01:25 | 10:05 | 10:52 | 05:30:03 | 40:17 | 01:45 | 23:10 | 01:00 | 42:48 | 0.02161288633942604 | 0.1437576860189438
Agent Total: |  | 18 | 0 | 03:01:25 | 10:05 | 10:52 | 05:30:03 | 40:17 | 01:45 | 23:10 | 01:00 | 42:48 | 0.02161288633942604 | 0.1437576860189438
LS
9/20/2013
20322199 | TD_CUCM1.Cisco_Voice.defau.05524 | 0 | 0 | 00:00 | 00:00 | 05:01 | 06:55:32 | 09:53 | 01:59 | 00:00 | 00:00 | 07:24 | 0.01780843921005726 | 0.07805230468511581
20322199 | GI_ON_DMK_EN_CSC_EXS_ALL | 17 | 0 | 02:44:02 | 09:39 | 12:41 | 06:55:32 | 59:27 | 03:08 | 15:10 | 00:48 | 07:24 | 0.01780843921005726 | 0.5784534215927124
20322199 | GI_ON_DMK_EN_CSC_NEW_ALL | 4 | 0 | 53:37 | 13:24 | 20:33 | 06:55:32 | 18:35 | 04:39 | 10:01 | 02:30 | 07:24 | 0.01780843921005726 | 0.2080057710409164
20322199 | GI_ON_EMP_EN_CSC_EXS_ALL | 1 | 0 | 25:51 | 25:51 | 31:50 | 06:55:32 | 05:59 | 05:59 | 00:00 | 00:00 | 07:24 | 0.01780843921005726 | 0.09445692598819733
20322199 | GI_ON_EMP_EN_CSC_NEW_ALL | 0 | 0 | 00:00 | 00:00 | 00:00 | 06:55:32 | 00:00 | 00:00 | 00:00 | 00:00 | 07:24 | 0.01780843921005726 | 0.01780843921005726
20322199 | GI_WP_000_EN_000_EMR_STJ | 0 | 0 | 00:00 | 00:00 | 00:00 | 06:55:32 | 00:00 | 00:00 | 00:00 | 00:00 | 07:24 | 0.01780843921005726 | 0.01780843921005726
Daily Total: |  | 22 | 0 | 04:03:30 | 11:04 | 13:07 | 06:55:32 | 01:33:54 | 03:14 | 25:11 | 00:52 | 44:24 | 0.01780843921005726 | 0.1657642126083374
Agent Total: |  | 22 | 0 | 04:03:30 | 11:04 | 13:07 | 06:55:32 | 01:33:54 | 03:14 | 25:11 | 00:52 | 44:24 | 0.01780843921005726 | 0.1657642126083374
Report Total: |  | 140 | 0 | 20:50:21 | 08:56 | 11:07 | [NAME] | 07:57:22 | 02:47 | 02:06:42 | 00:44 | 07:54:00 | 0.03503882884979248 | 0.172652468085289