SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
I need to read in a txt file and then do some simple excel work with it. My problem is that the file isn't easy to import. Some rows have report info, some data, some headers, some blank spaces... And some have data associate with the row above but it's not obvious by what appears on that particular row.
In the sample below, I would need to find the text that says:
Day: 02/28/07
and then get the row after it starting with 3489:
3489 947 WALKAWAY 14:53:18 14:54:14 0:00:56 800 TSC - After Call Wrap up TSC
Then I would need to get the row after that which is similar but doesn't have the 4 digit number at the front:
WALKAWAY 15:02:45 15:03:29 0:00:44 800 TSC - After Call Wrap up
I'd then need to get the next 3 rows that are also associated with 3489 on 2/28. Then I'd need to get the 8 rows of data associated with 3498 the has a header splitting it up. I can email this file or call anybody that may think they could do this. I'm totally stumped.
Help help help. The real file is hundreds of pages long and I have many other reports like this. If someone could help me with this I could use the same trick on all the other repors.
Thanks,
Stacy
--------------
Report title : Agent Walkaway Report
Report type : Event Log - Agent Walkaway Report
Time frame : Day
Downtime : 00:00:24
Data selections
---------------
Days : 01/01/07 - 03/01/07
Agents : All
Scope : TSC
Generated at : Date: 03/02/07 Time: 9:22:07
Agent Walkaway Report Page 1
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
Day: 02/28/07
3489 947 WALKAWAY 14:53:18 14:54:14 0:00:56 800 TSC - After Call Wrap up TSC
WALKAWAY 15:02:45 15:03:29 0:00:44 800 TSC - After Call Wrap up
STAFFED 14:53:18 15:08:28 0:01:40
STAFFED 15:22:09 15:46:57 0:00:00
STAFFED 15:47:50 15:54:15 0:00:00
WORKDAY 14:53:18 15:54:15 0:01:40
3498 949 WALKAWAY 15:04:41 15:05:00 0:00:19 230 Not Defined TSC
STAFFED 15:04:41 16:45:41 0:00:19
WALKAWAY 17:07:24 17:08:16 0:00:52 230 Not Defined
WALKAWAY 17:14:45 17:15:24 0:00:39 230 Not Defined
Agent Walkaway Report Page 12
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WALKAWAY 17:54:36 17:56:01 0:01:25 230 Not Defined
WALKAWAY 18:21:20 18:22:23 0:01:03 230 Not Defined
STAFFED 17:04:42 18:33:55 0:03:59
WORKDAY 15:04:41 18:33:55 0:04:18
3500 1661 WALKAWAY 15:35:08 15:50:38 0:15:30 800 TSC - After Call Wrap up TSC
WALKAWAY 16:08:44 16:12:02 0:03:18 800 TSC - After Call Wrap up
WALKAWAY 16:26:48 16:30:50 0:04:02 230 Not Defined
STAFFED 15:02:26 16:30:50 0:22:50
WORKDAY 15:02:26 16:30:50 0:22:50
3501 1660 STAFFED 15:42:55 15:42:55 0:00:00 TSC
WALKAWAY 17:02:31 17:03:44 0:01:13 230 Not Defined
WALKAWAY 17:03:46 17:11:44 0:07:58 803 TSC - Assisting Other Managers
WALKAWAY 18:00:26 18:00:26 0:00:00 000 No Code Entered
STAFFED 15:57:38 18:00:26 0:09:11
WORKDAY 15:42:55 18:00:26 0:09:11
3502 957 STAFFED 15:37:41 15:37:41 0:00:00 TSC
STAFFED 15:51:31 17:00:56 0:00:00
WORKDAY 15:37:41 17:00:56 0:00:00
3510 945 STAFFED 15:13:32 15:22:06 0:00:00 TSC
STAFFED 15:23:37 15:24:54 0:00:00
WORKDAY 15:13:32 15:24:54 0:00:00
3517 1659 WALKAWAY 15:46:56 15:49:30 0:02:34 800 TSC - After Call Wrap up TSC
WALKAWAY 15:50:14 15:50:55 0:00:41 800 TSC - After Call Wrap up
WALKAWAY 15:59:07 16:04:32 0:05:25 800 TSC - After Call Wrap up
WALKAWAY 16:24:35 16:25:14 0:00:39 800 TSC - After Call Wrap up
WALKAWAY 17:32:47 17:35:31 0:02:44 800 TSC - After Call Wrap up
WALKAWAY 18:07:53 18:10:06 0:02:13 800 TSC - After Call Wrap up
WALKAWAY 18:23:21 18:25:01 0:01:40 800 TSC - After Call Wrap up
WALKAWAY 18:27:03 18:27:58 0:00:55 410 Not Defined
STAFFED 15:17:48 18:30:04 0:16:51
WORKDAY 15:17:48 18:30:04 0:16:51
3518 956 WALKAWAY 15:29:16 15:33:30 0:04:14 800 TSC - After Call Wrap up TSC
WALKAWAY 16:01:50 16:02:20 0:00:30 800 TSC - After Call Wrap up
STAFFED 15:29:16 16:02:20 0:04:44
WALKAWAY 16:27:26 16:30:18 0:02:52 800 TSC - After Call Wrap up
WALKAWAY 17:35:51 17:39:13 0:03:22 800 TSC - After Call Wrap up
WALKAWAY 18:47:18 18:47:19 0:00:01 800 TSC - After Call Wrap up
STAFFED 16:14:29 18:47:19 0:06:15
WORKDAY 15:29:16 18:47:19 0:10:59
3519 961 STAFFED 14:47:54 15:10:56 0:00:00 TSC
WALKAWAY 16:09:47 16:11:58 0:02:11 800 TSC - After Call Wrap up
STAFFED 15:29:57 16:11:58 0:02:11
Agent Walkaway Report Page 13
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 14:47:54 16:11:58 0:02:11
3526 950 STAFFED 15:14:58 16:39:41 0:00:00 TSC
WORKDAY 15:14:58 16:39:41 0:00:00
3530 963 WALKAWAY 15:27:47 15:27:58 0:00:11 410 Not Defined TSC
WALKAWAY 15:29:53 15:30:25 0:00:32 000 No Code Entered
STAFFED 15:00:02 15:30:25 0:00:43
WORKDAY 15:00:02 15:30:25 0:00:43
3534 970 STAFFED 08:08:32 09:29:22 0:00:00 TSC
STAFFED 11:38:51 11:50:58 0:00:00
WALKAWAY 11:59:08 12:12:51 0:13:43 801 TSC - Personal Emergency
STAFFED 11:58:52 12:13:41 0:13:43
STAFFED 12:15:20 12:52:17 0:00:00
STAFFED 14:11:01 17:01:33 0:00:00
WORKDAY 08:08:32 17:01:33 0:13:43
3535 966 STAFFED 06:09:16 09:06:43 0:00:00 TSC
STAFFED 09:29:14 11:31:24 0:00:00
STAFFED 11:43:38 12:13:52 0:00:00
STAFFED 12:37:57 14:43:25 0:00:00
STAFFED 15:01:11 15:32:41 0:00:00
WORKDAY 06:09:16 15:32:41 0:00:00
Day: 03/01/07
3488 948 STAFFED 08:53:41 08:54:22 0:00:00 TSC
WORKDAY 08:53:41 08:54:22 0:00:00
3489 947 WALKAWAY 09:55:23 09:58:40 0:03:17 801 TSC - Personal Emergency TSC
STAFFED 09:27:40 10:31:26 0:03:17
WALKAWAY 10:58:11 10:59:17 0:01:06 800 TSC - After Call Wrap up
WALKAWAY 11:00:12 13:24:45 2:24:33 803 TSC - Assisting Other Managers
STAFFED 10:46:41 13:24:45 2:25:39
STAFFED 14:26:22 15:31:34 0:00:00
WALKAWAY 17:41:32 17:44:04 0:02:32 800 TSC - After Call Wrap up
STAFFED 17:27:12 18:29:06 0:02:32
WORKDAY 09:27:40 18:29:06 2:31:28
3490 969 WALKAWAY 07:20:05 07:20:07 0:00:02 000 No Code Entered TSC
WALKAWAY 07:20:12 07:27:25 0:07:13 510 Not Defined
STAFFED 06:59:50 09:55:57 0:07:15
STAFFED 10:12:32 11:49:17 0:00:00
STAFFED 12:51:28 13:50:24 0:00:00
WORKDAY 06:59:50 13:50:24 0:07:15
3492 962 STAFFED 13:16:34 13:17:46 0:00:00 TSC
STAFFED 16:02:24 16:02:25 0:00:00
Agent Walkaway Report Page 14
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 13:16:34 16:02:25 0:00:00
3496 954 WALKAWAY 08:59:26 09:03:04 0:03:38 800 TSC - After Call Wrap up TSC
STAFFED 07:30:19 09:03:04 0:03:38
WALKAWAY 09:34:16 09:36:07 0:01:51 800 TSC - After Call Wrap up
WALKAWAY 09:38:20 09:39:07 0:00:47 800 TSC - After Call Wrap up
WALKAWAY 09:42:43 09:45:05 0:02:22 800 TSC - After Call Wrap up
WALKAWAY 09:46:42 09:50:25 0:03:43 800 TSC - After Call Wrap up
WALKAWAY 10:49:10 10:50:33 0:01:23 800 TSC - After Call Wrap up
STAFFED 09:24:57 10:56:07 0:10:06
WALKAWAY 13:12:10 13:14:00 0:01:50 800 TSC - After Call Wrap up
WALKAWAY 13:19:36 13:21:25 0:01:49 800 TSC - After Call Wrap up
WALKAWAY 13:26:25 13:27:17 0:00:52 800 TSC - After Call Wrap up
WALKAWAY 14:01:40 14:02:56 0:01:16 800 TSC - After Call Wrap up
WALKAWAY 14:17:53 14:18:14 0:00:21 800 TSC - After Call Wrap up
WALKAWAY 14:26:39 14:28:38 0:01:59 800 TSC - After Call Wrap up
STAFFED 13:10:13 14:31:46 0:08:07
WALKAWAY 14:53:20 14:56:47 0:03:27 800 TSC - After Call Wrap up
STAFFED 14:46:27 17:05:13 0:03:27
WORKDAY 07:30:19 17:05:13 0:25:18
3498 949 WALKAWAY 10:12:00 10:13:09 0:01:09 803 TSC - Assisting Other Managers TSC
STAFFED 09:29:09 11:26:33 0:01:09
WALKAWAY 11:50:48 11:51:14 0:00:26 803 TSC - Assisting Other Managers
STAFFED 11:43:47 13:07:16 0:00:26
WALKAWAY 14:27:03 14:29:19 0:02:16 803 TSC - Assisting Other Managers
WALKAWAY 14:40:51 14:43:22 0:02:31 803 TSC - Assisting Other Managers
WALKAWAY 15:13:40 15:15:04 0:01:24 803 TSC - Assisting Other Managers
WALKAWAY 15:20:03 15:20:59 0:00:56 803 TSC - Assisting Other Managers
WALKAWAY 15:39:50 15:40:38 0:00:48 803 TSC - Assisting Other Managers
WALKAWAY 15:52:10 15:54:44 0:02:34 510 Not Defined
STAFFED 14:21:01 15:54:44 0:10:29
WALKAWAY 17:05:07 17:05:19 0:00:12 803 TSC - Assisting Other Managers
WALKAWAY 18:06:01 18:07:36 0:01:35 803 TSC - Assisting Other Managers
WALKAWAY 18:12:28 18:13:33 0:01:05 803 TSC - Assisting Other Managers
STAFFED 16:18:32 18:28:11 0:02:52
WORKDAY 09:29:09 18:28:11 0:14:56
3500 1661 WALKAWAY 07:53:02 07:55:51 0:02:49 800 TSC - After Call Wrap up TSC
WALKAWAY 08:06:22 08:07:29 0:01:07 800 TSC - After Call Wrap up
WALKAWAY 08:11:03 08:13:04 0:02:01 800 TSC - After Call Wrap up
WALKAWAY 08:25:35 08:32:00 0:06:25 800 TSC - After Call Wrap up
WALKAWAY 08:59:17 09:00:20 0:01:03 800 TSC - After Call Wrap up
WALKAWAY 09:19:00 09:21:41 0:02:41 800 TSC - After Call Wrap up
WALKAWAY 09:35:10 09:38:50 0:03:40 800 TSC - After Call Wrap up
STAFFED 07:39:15 09:38:50 0:19:46
WALKAWAY 10:27:42 10:32:05 0:04:23 800 TSC - After Call Wrap up
WALKAWAY 10:32:06 10:37:42 0:05:36 803 TSC - Assisting Other Managers
WALKAWAY 11:31:27 11:40:25 0:08:58 800 TSC - After Call Wrap up
Agent Walkaway Report Page 15
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
STAFFED 10:00:07 12:01:28 0:18:57
WALKAWAY 13:53:05 14:17:23 0:24:18 808 TSC - Vendor Call (Pan / Cing)
WALKAWAY 14:39:57 14:43:57 0:04:00 800 TSC - After Call Wrap up
STAFFED 13:07:44 14:43:57 0:28:18
WALKAWAY 15:05:41 15:06:53 0:01:12 800 TSC - After Call Wrap up
WALKAWAY 15:14:06 15:14:33 0:00:27 800 TSC - After Call Wrap up
WALKAWAY 15:14:34 15:23:52 0:09:18 803 TSC - Assisting Other Managers
WALKAWAY 16:20:17 16:24:12 0:03:55 808 TSC - Vendor Call (Pan / Cing)
WALKAWAY 16:27:46 16:31:03 0:03:17 800 TSC - After Call Wrap up
STAFFED 14:58:04 16:31:03 0:18:09
WORKDAY 07:39:15 16:31:03 1:25:10
3501 1660 WALKAWAY 09:57:27 09:59:34 0:02:07 000 No Code Entered TSC
STAFFED 08:59:22 10:18:58 0:02:07
WALKAWAY 12:33:24 12:33:54 0:00:30 000 No Code Entered
WALKAWAY 12:41:14 12:41:45 0:00:31 803 TSC - Assisting Other Managers
STAFFED 10:33:29 13:53:45 0:01:01
STAFFED 14:53:34 15:54:12 0:00:00
WALKAWAY 16:57:16 16:59:58 0:02:42 803 TSC - Assisting Other Managers
WALKAWAY 17:05:37 17:05:40 0:00:03 000 No Code Entered
WALKAWAY 17:05:42 17:05:51 0:00:09 803 TSC - Assisting Other Managers
WALKAWAY 17:58:44 18:00:42 0:01:58 803 TSC - Assisting Other Managers
STAFFED 16:10:09 18:00:42 0:04:52
WORKDAY 08:59:22 18:00:42 0:08:00
3502 957 STAFFED 08:00:14 09:42:51 0:00:00 TSC
STAFFED 09:55:09 12:50:53 0:00:00
STAFFED 13:35:42 15:07:55 0:00:00
STAFFED 15:24:20 17:25:15 0:00:00
WORKDAY 08:00:14 17:25:15 0:00:00
3503 948 STAFFED 08:56:34 08:58:39 0:00:00 TSC
WORKDAY 08:56:34 08:58:39 0:00:00
3510 945 WALKAWAY 09:43:58 09:45:03 0:01:05 000 No Code Entered TSC
STAFFED 09:40:16 09:45:03 0:01:05
STAFFED 10:08:54 10:52:57 0:00:00
STAFFED 10:57:38 11:09:06 0:00:00
STAFFED 13:11:02 14:30:52 0:00:00
STAFFED 16:10:42 16:29:23 0:00:00
WORKDAY 09:40:16 16:29:23 0:01:05
3514 958 WALKAWAY 13:22:21 13:24:14 0:01:53 800 TSC - After Call Wrap up TSC
STAFFED 13:22:21 13:24:14 0:01:53
STAFFED 13:38:02 13:48:30 0:00:00
WALKAWAY 14:23:01 14:25:37 0:02:36 800 TSC - After Call Wrap up
WALKAWAY 14:30:49 14:31:30 0:00:41 800 TSC - After Call Wrap up
WALKAWAY 14:35:41 14:36:52 0:01:11 800 TSC - After Call Wrap up
WALKAWAY 14:58:12 14:58:27 0:00:15 800 TSC - After Call Wrap up
Agent Walkaway Report Page 16
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WALKAWAY 15:02:23 15:02:38 0:00:15 800 TSC - After Call Wrap up
WALKAWAY 15:10:02 15:10:30 0:00:28 800 TSC - After Call Wrap up
WALKAWAY 15:23:51 15:24:12 0:00:21 800 TSC - After Call Wrap up
STAFFED 14:10:37 15:39:33 0:05:47
WORKDAY 13:22:21 15:39:33 0:07:40
3517 1659 WALKAWAY 10:07:39 10:08:54 0:01:15 800 TSC - After Call Wrap up TSC
WALKAWAY 10:52:42 10:56:33 0:03:51 800 TSC - After Call Wrap up
STAFFED 09:35:48 11:11:38 0:05:06
WALKAWAY 11:24:29 11:26:16 0:01:47 800 TSC - After Call Wrap up
WALKAWAY 12:03:24 12:06:28 0:03:04 800 TSC - After Call Wrap up
WALKAWAY 12:22:14 12:24:12 0:01:58 800 TSC - After Call Wrap up
WALKAWAY 12:55:39 12:56:16 0:00:37 800 TSC - After Call Wrap up
WALKAWAY 13:32:00 13:32:41 0:00:41 800 TSC - After Call Wrap up
STAFFED 11:22:27 13:32:41 0:08:07
WALKAWAY 14:35:29 14:36:22 0:00:53 800 TSC - After Call Wrap up
WALKAWAY 14:40:49 14:41:44 0:00:55 800 TSC - After Call Wrap up
WALKAWAY 15:06:33 15:09:13 0:02:40 800 TSC - After Call Wrap up
WALKAWAY 15:37:04 15:41:18 0:04:14 800 TSC - After Call Wrap up
WALKAWAY 15:54:20 15:57:31 0:03:11 800 TSC - After Call Wrap up
WALKAWAY 16:09:10 16:09:11 0:00:01 880 Not Defined
WALKAWAY 16:41:35 16:41:44 0:00:09 800 TSC - After Call Wrap up
WALKAWAY 16:41:47 17:34:32 0:52:45 810 TSC - Customer Call Back
STAFFED 14:33:21 17:34:32 1:04:48
WALKAWAY 17:58:30 17:59:20 0:00:50 800 TSC - After Call Wrap up
WALKAWAY 18:03:56 18:26:30 0:22:34 800 TSC - After Call Wrap up
STAFFED 17:50:01 18:31:22 0:23:24
WORKDAY 09:35:48 18:31:22 1:41:25
3518 956 WALKAWAY 08:18:08 08:22:13 0:04:05 800 TSC - After Call Wrap up TSC
WALKAWAY 08:26:13 08:26:37 0:00:24 800 TSC - After Call Wrap up
WALKAWAY 08:40:11 08:44:59 0:04:48 800 TSC - After Call Wrap up
WALKAWAY 09:37:50 09:40:08 0:02:18 800 TSC - After Call Wrap up
STAFFED 07:57:44 10:03:56 0:11:35
WALKAWAY 11:16:00 11:17:11 0:01:11 800 TSC - After Call Wrap up
WALKAWAY 12:21:24 12:22:32 0:01:08 800 TSC - After Call Wrap up
STAFFED 10:20:47 12:22:32 0:02:19
WALKAWAY 13:30:00 13:32:32 0:02:32 800 TSC - After Call Wrap up
WALKAWAY 13:40:52 13:43:33 0:02:41 800 TSC - After Call Wrap up
WALKAWAY 15:35:17 15:36:14 0:00:57 800 TSC - After Call Wrap up
STAFFED 13:26:03 15:36:14 0:06:10
WALKAWAY 15:52:21 15:54:02 0:01:41 800 TSC - After Call Wrap up
WALKAWAY 16:16:47 16:18:04 0:01:17 800 TSC - After Call Wrap up
WALKAWAY 16:20:21 16:21:11 0:00:50 800 TSC - After Call Wrap up
WALKAWAY 16:26:59 16:28:28 0:01:29 800 TSC - After Call Wrap up
WALKAWAY 16:51:16 16:52:38 0:01:22 800 TSC - After Call Wrap up
WALKAWAY 17:45:33 17:45:33 0:00:00 800 TSC - After Call Wrap up
STAFFED 15:51:25 17:45:33 0:06:39
WORKDAY 07:57:44 17:45:33 0:26:43
Agent Walkaway Report Page 17
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
3519 961 WALKAWAY 08:09:52 08:16:37 0:06:45 410 Not Defined TSC
WALKAWAY 08:47:26 08:48:50 0:01:24 800 TSC - After Call Wrap up
WALKAWAY 08:48:53 08:48:54 0:00:01 410 Not Defined
WALKAWAY 08:55:39 09:06:51 0:11:12 800 TSC - After Call Wrap up
WALKAWAY 09:14:07 09:20:52 0:06:45 800 TSC - After Call Wrap up
STAFFED 08:00:46 10:33:34 0:26:07
WALKAWAY 11:12:02 11:18:19 0:06:17 800 TSC - After Call Wrap up
WALKAWAY 11:36:58 11:45:22 0:08:24 800 TSC - After Call Wrap up
WALKAWAY 11:51:11 11:57:04 0:05:53 800 TSC - After Call Wrap up
WALKAWAY 12:38:35 12:44:34 0:05:59 800 TSC - After Call Wrap up
WALKAWAY 12:56:40 12:58:45 0:02:05 800 TSC - After Call Wrap up
WALKAWAY 12:58:47 13:09:53 0:11:06 801 TSC - Personal Emergency
WALKAWAY 13:31:11 13:37:06 0:05:55 800 TSC - After Call Wrap up
STAFFED 10:55:16 13:46:01 0:45:39
WALKAWAY 14:57:44 14:58:31 0:00:47 800 TSC - After Call Wrap up
STAFFED 14:47:19 14:58:31 0:00:47
WALKAWAY 15:44:31 15:49:52 0:05:21 800 TSC - After Call Wrap up
STAFFED 15:21:46 15:49:52 0:05:21
WORKDAY 08:00:46 15:49:52 1:17:54
3520 952 WALKAWAY 13:34:38 13:39:06 0:04:28 800 TSC - After Call Wrap up TSC
STAFFED 13:34:38 13:44:30 0:04:28
STAFFED 14:01:35 15:35:32 0:00:00
WORKDAY 13:34:38 15:35:32 0:04:28
3526 950 WALKAWAY 08:53:04 08:58:12 0:05:08 800 TSC - After Call Wrap up TSC
STAFFED 07:29:31 10:30:40 0:05:08
STAFFED 10:59:16 12:16:00 0:00:00
WALKAWAY 13:51:38 14:01:50 0:10:12 800 TSC - After Call Wrap up
STAFFED 13:17:52 15:25:33 0:10:12
STAFFED 15:36:28 16:32:56 0:00:00
WORKDAY 07:29:31 16:32:56 0:15:20
3530 963 WALKAWAY 07:10:18 07:16:03 0:05:45 410 Not Defined TSC
WALKAWAY 08:07:29 08:09:23 0:01:54 800 TSC - After Call Wrap up
WALKAWAY 08:21:10 08:22:26 0:01:16 800 TSC - After Call Wrap up
STAFFED 06:20:01 08:34:29 0:08:55
WALKAWAY 10:00:13 10:03:02 0:02:49 410 Not Defined
STAFFED 08:47:56 10:31:34 0:02:49
WALKAWAY 12:29:19 12:33:41 0:04:22 800 TSC - After Call Wrap up
WALKAWAY 14:16:44 14:21:09 0:04:25 801 TSC - Personal Emergency
STAFFED 11:32:10 14:32:13 0:08:47
WALKAWAY 15:29:52 15:30:23 0:00:31 800 TSC - After Call Wrap up
STAFFED 14:44:16 15:30:23 0:00:31
WORKDAY 06:20:01 15:30:23 0:21:02
3534 970 STAFFED 07:53:35 12:28:41 0:00:00 TSC
STAFFED 13:20:05 16:59:59 0:00:00
Agent Walkaway Report Page 18
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 07:53:35 16:59:59 0:00:00
3535 966 STAFFED 06:13:31 09:05:52 0:00:00 TSC
WALKAWAY 09:56:51 10:06:48 0:09:57 800 TSC - After Call Wrap up
STAFFED 09:23:48 11:07:01 0:09:57
STAFFED 11:24:39 12:31:08 0:00:00
WORKDAY 06:13:31 12:31:08 0:09:57
In the sample below, I would need to find the text that says:
Day: 02/28/07
and then get the row after it starting with 3489:
3489 947 WALKAWAY 14:53:18 14:54:14 0:00:56 800 TSC - After Call Wrap up TSC
Then I would need to get the row after that which is similar but doesn't have the 4 digit number at the front:
WALKAWAY 15:02:45 15:03:29 0:00:44 800 TSC - After Call Wrap up
I'd then need to get the next 3 rows that are also associated with 3489 on 2/28. Then I'd need to get the 8 rows of data associated with 3498 the has a header splitting it up. I can email this file or call anybody that may think they could do this. I'm totally stumped.
Help help help. The real file is hundreds of pages long and I have many other reports like this. If someone could help me with this I could use the same trick on all the other repors.
Thanks,
Stacy
--------------
Report title : Agent Walkaway Report
Report type : Event Log - Agent Walkaway Report
Time frame : Day
Downtime : 00:00:24
Data selections
---------------
Days : 01/01/07 - 03/01/07
Agents : All
Scope : TSC
Generated at : Date: 03/02/07 Time: 9:22:07
Agent Walkaway Report Page 1
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
Day: 02/28/07
3489 947 WALKAWAY 14:53:18 14:54:14 0:00:56 800 TSC - After Call Wrap up TSC
WALKAWAY 15:02:45 15:03:29 0:00:44 800 TSC - After Call Wrap up
STAFFED 14:53:18 15:08:28 0:01:40
STAFFED 15:22:09 15:46:57 0:00:00
STAFFED 15:47:50 15:54:15 0:00:00
WORKDAY 14:53:18 15:54:15 0:01:40
3498 949 WALKAWAY 15:04:41 15:05:00 0:00:19 230 Not Defined TSC
STAFFED 15:04:41 16:45:41 0:00:19
WALKAWAY 17:07:24 17:08:16 0:00:52 230 Not Defined
WALKAWAY 17:14:45 17:15:24 0:00:39 230 Not Defined
Agent Walkaway Report Page 12
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WALKAWAY 17:54:36 17:56:01 0:01:25 230 Not Defined
WALKAWAY 18:21:20 18:22:23 0:01:03 230 Not Defined
STAFFED 17:04:42 18:33:55 0:03:59
WORKDAY 15:04:41 18:33:55 0:04:18
3500 1661 WALKAWAY 15:35:08 15:50:38 0:15:30 800 TSC - After Call Wrap up TSC
WALKAWAY 16:08:44 16:12:02 0:03:18 800 TSC - After Call Wrap up
WALKAWAY 16:26:48 16:30:50 0:04:02 230 Not Defined
STAFFED 15:02:26 16:30:50 0:22:50
WORKDAY 15:02:26 16:30:50 0:22:50
3501 1660 STAFFED 15:42:55 15:42:55 0:00:00 TSC
WALKAWAY 17:02:31 17:03:44 0:01:13 230 Not Defined
WALKAWAY 17:03:46 17:11:44 0:07:58 803 TSC - Assisting Other Managers
WALKAWAY 18:00:26 18:00:26 0:00:00 000 No Code Entered
STAFFED 15:57:38 18:00:26 0:09:11
WORKDAY 15:42:55 18:00:26 0:09:11
3502 957 STAFFED 15:37:41 15:37:41 0:00:00 TSC
STAFFED 15:51:31 17:00:56 0:00:00
WORKDAY 15:37:41 17:00:56 0:00:00
3510 945 STAFFED 15:13:32 15:22:06 0:00:00 TSC
STAFFED 15:23:37 15:24:54 0:00:00
WORKDAY 15:13:32 15:24:54 0:00:00
3517 1659 WALKAWAY 15:46:56 15:49:30 0:02:34 800 TSC - After Call Wrap up TSC
WALKAWAY 15:50:14 15:50:55 0:00:41 800 TSC - After Call Wrap up
WALKAWAY 15:59:07 16:04:32 0:05:25 800 TSC - After Call Wrap up
WALKAWAY 16:24:35 16:25:14 0:00:39 800 TSC - After Call Wrap up
WALKAWAY 17:32:47 17:35:31 0:02:44 800 TSC - After Call Wrap up
WALKAWAY 18:07:53 18:10:06 0:02:13 800 TSC - After Call Wrap up
WALKAWAY 18:23:21 18:25:01 0:01:40 800 TSC - After Call Wrap up
WALKAWAY 18:27:03 18:27:58 0:00:55 410 Not Defined
STAFFED 15:17:48 18:30:04 0:16:51
WORKDAY 15:17:48 18:30:04 0:16:51
3518 956 WALKAWAY 15:29:16 15:33:30 0:04:14 800 TSC - After Call Wrap up TSC
WALKAWAY 16:01:50 16:02:20 0:00:30 800 TSC - After Call Wrap up
STAFFED 15:29:16 16:02:20 0:04:44
WALKAWAY 16:27:26 16:30:18 0:02:52 800 TSC - After Call Wrap up
WALKAWAY 17:35:51 17:39:13 0:03:22 800 TSC - After Call Wrap up
WALKAWAY 18:47:18 18:47:19 0:00:01 800 TSC - After Call Wrap up
STAFFED 16:14:29 18:47:19 0:06:15
WORKDAY 15:29:16 18:47:19 0:10:59
3519 961 STAFFED 14:47:54 15:10:56 0:00:00 TSC
WALKAWAY 16:09:47 16:11:58 0:02:11 800 TSC - After Call Wrap up
STAFFED 15:29:57 16:11:58 0:02:11
Agent Walkaway Report Page 13
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 14:47:54 16:11:58 0:02:11
3526 950 STAFFED 15:14:58 16:39:41 0:00:00 TSC
WORKDAY 15:14:58 16:39:41 0:00:00
3530 963 WALKAWAY 15:27:47 15:27:58 0:00:11 410 Not Defined TSC
WALKAWAY 15:29:53 15:30:25 0:00:32 000 No Code Entered
STAFFED 15:00:02 15:30:25 0:00:43
WORKDAY 15:00:02 15:30:25 0:00:43
3534 970 STAFFED 08:08:32 09:29:22 0:00:00 TSC
STAFFED 11:38:51 11:50:58 0:00:00
WALKAWAY 11:59:08 12:12:51 0:13:43 801 TSC - Personal Emergency
STAFFED 11:58:52 12:13:41 0:13:43
STAFFED 12:15:20 12:52:17 0:00:00
STAFFED 14:11:01 17:01:33 0:00:00
WORKDAY 08:08:32 17:01:33 0:13:43
3535 966 STAFFED 06:09:16 09:06:43 0:00:00 TSC
STAFFED 09:29:14 11:31:24 0:00:00
STAFFED 11:43:38 12:13:52 0:00:00
STAFFED 12:37:57 14:43:25 0:00:00
STAFFED 15:01:11 15:32:41 0:00:00
WORKDAY 06:09:16 15:32:41 0:00:00
Day: 03/01/07
3488 948 STAFFED 08:53:41 08:54:22 0:00:00 TSC
WORKDAY 08:53:41 08:54:22 0:00:00
3489 947 WALKAWAY 09:55:23 09:58:40 0:03:17 801 TSC - Personal Emergency TSC
STAFFED 09:27:40 10:31:26 0:03:17
WALKAWAY 10:58:11 10:59:17 0:01:06 800 TSC - After Call Wrap up
WALKAWAY 11:00:12 13:24:45 2:24:33 803 TSC - Assisting Other Managers
STAFFED 10:46:41 13:24:45 2:25:39
STAFFED 14:26:22 15:31:34 0:00:00
WALKAWAY 17:41:32 17:44:04 0:02:32 800 TSC - After Call Wrap up
STAFFED 17:27:12 18:29:06 0:02:32
WORKDAY 09:27:40 18:29:06 2:31:28
3490 969 WALKAWAY 07:20:05 07:20:07 0:00:02 000 No Code Entered TSC
WALKAWAY 07:20:12 07:27:25 0:07:13 510 Not Defined
STAFFED 06:59:50 09:55:57 0:07:15
STAFFED 10:12:32 11:49:17 0:00:00
STAFFED 12:51:28 13:50:24 0:00:00
WORKDAY 06:59:50 13:50:24 0:07:15
3492 962 STAFFED 13:16:34 13:17:46 0:00:00 TSC
STAFFED 16:02:24 16:02:25 0:00:00
Agent Walkaway Report Page 14
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 13:16:34 16:02:25 0:00:00
3496 954 WALKAWAY 08:59:26 09:03:04 0:03:38 800 TSC - After Call Wrap up TSC
STAFFED 07:30:19 09:03:04 0:03:38
WALKAWAY 09:34:16 09:36:07 0:01:51 800 TSC - After Call Wrap up
WALKAWAY 09:38:20 09:39:07 0:00:47 800 TSC - After Call Wrap up
WALKAWAY 09:42:43 09:45:05 0:02:22 800 TSC - After Call Wrap up
WALKAWAY 09:46:42 09:50:25 0:03:43 800 TSC - After Call Wrap up
WALKAWAY 10:49:10 10:50:33 0:01:23 800 TSC - After Call Wrap up
STAFFED 09:24:57 10:56:07 0:10:06
WALKAWAY 13:12:10 13:14:00 0:01:50 800 TSC - After Call Wrap up
WALKAWAY 13:19:36 13:21:25 0:01:49 800 TSC - After Call Wrap up
WALKAWAY 13:26:25 13:27:17 0:00:52 800 TSC - After Call Wrap up
WALKAWAY 14:01:40 14:02:56 0:01:16 800 TSC - After Call Wrap up
WALKAWAY 14:17:53 14:18:14 0:00:21 800 TSC - After Call Wrap up
WALKAWAY 14:26:39 14:28:38 0:01:59 800 TSC - After Call Wrap up
STAFFED 13:10:13 14:31:46 0:08:07
WALKAWAY 14:53:20 14:56:47 0:03:27 800 TSC - After Call Wrap up
STAFFED 14:46:27 17:05:13 0:03:27
WORKDAY 07:30:19 17:05:13 0:25:18
3498 949 WALKAWAY 10:12:00 10:13:09 0:01:09 803 TSC - Assisting Other Managers TSC
STAFFED 09:29:09 11:26:33 0:01:09
WALKAWAY 11:50:48 11:51:14 0:00:26 803 TSC - Assisting Other Managers
STAFFED 11:43:47 13:07:16 0:00:26
WALKAWAY 14:27:03 14:29:19 0:02:16 803 TSC - Assisting Other Managers
WALKAWAY 14:40:51 14:43:22 0:02:31 803 TSC - Assisting Other Managers
WALKAWAY 15:13:40 15:15:04 0:01:24 803 TSC - Assisting Other Managers
WALKAWAY 15:20:03 15:20:59 0:00:56 803 TSC - Assisting Other Managers
WALKAWAY 15:39:50 15:40:38 0:00:48 803 TSC - Assisting Other Managers
WALKAWAY 15:52:10 15:54:44 0:02:34 510 Not Defined
STAFFED 14:21:01 15:54:44 0:10:29
WALKAWAY 17:05:07 17:05:19 0:00:12 803 TSC - Assisting Other Managers
WALKAWAY 18:06:01 18:07:36 0:01:35 803 TSC - Assisting Other Managers
WALKAWAY 18:12:28 18:13:33 0:01:05 803 TSC - Assisting Other Managers
STAFFED 16:18:32 18:28:11 0:02:52
WORKDAY 09:29:09 18:28:11 0:14:56
3500 1661 WALKAWAY 07:53:02 07:55:51 0:02:49 800 TSC - After Call Wrap up TSC
WALKAWAY 08:06:22 08:07:29 0:01:07 800 TSC - After Call Wrap up
WALKAWAY 08:11:03 08:13:04 0:02:01 800 TSC - After Call Wrap up
WALKAWAY 08:25:35 08:32:00 0:06:25 800 TSC - After Call Wrap up
WALKAWAY 08:59:17 09:00:20 0:01:03 800 TSC - After Call Wrap up
WALKAWAY 09:19:00 09:21:41 0:02:41 800 TSC - After Call Wrap up
WALKAWAY 09:35:10 09:38:50 0:03:40 800 TSC - After Call Wrap up
STAFFED 07:39:15 09:38:50 0:19:46
WALKAWAY 10:27:42 10:32:05 0:04:23 800 TSC - After Call Wrap up
WALKAWAY 10:32:06 10:37:42 0:05:36 803 TSC - Assisting Other Managers
WALKAWAY 11:31:27 11:40:25 0:08:58 800 TSC - After Call Wrap up
Agent Walkaway Report Page 15
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
STAFFED 10:00:07 12:01:28 0:18:57
WALKAWAY 13:53:05 14:17:23 0:24:18 808 TSC - Vendor Call (Pan / Cing)
WALKAWAY 14:39:57 14:43:57 0:04:00 800 TSC - After Call Wrap up
STAFFED 13:07:44 14:43:57 0:28:18
WALKAWAY 15:05:41 15:06:53 0:01:12 800 TSC - After Call Wrap up
WALKAWAY 15:14:06 15:14:33 0:00:27 800 TSC - After Call Wrap up
WALKAWAY 15:14:34 15:23:52 0:09:18 803 TSC - Assisting Other Managers
WALKAWAY 16:20:17 16:24:12 0:03:55 808 TSC - Vendor Call (Pan / Cing)
WALKAWAY 16:27:46 16:31:03 0:03:17 800 TSC - After Call Wrap up
STAFFED 14:58:04 16:31:03 0:18:09
WORKDAY 07:39:15 16:31:03 1:25:10
3501 1660 WALKAWAY 09:57:27 09:59:34 0:02:07 000 No Code Entered TSC
STAFFED 08:59:22 10:18:58 0:02:07
WALKAWAY 12:33:24 12:33:54 0:00:30 000 No Code Entered
WALKAWAY 12:41:14 12:41:45 0:00:31 803 TSC - Assisting Other Managers
STAFFED 10:33:29 13:53:45 0:01:01
STAFFED 14:53:34 15:54:12 0:00:00
WALKAWAY 16:57:16 16:59:58 0:02:42 803 TSC - Assisting Other Managers
WALKAWAY 17:05:37 17:05:40 0:00:03 000 No Code Entered
WALKAWAY 17:05:42 17:05:51 0:00:09 803 TSC - Assisting Other Managers
WALKAWAY 17:58:44 18:00:42 0:01:58 803 TSC - Assisting Other Managers
STAFFED 16:10:09 18:00:42 0:04:52
WORKDAY 08:59:22 18:00:42 0:08:00
3502 957 STAFFED 08:00:14 09:42:51 0:00:00 TSC
STAFFED 09:55:09 12:50:53 0:00:00
STAFFED 13:35:42 15:07:55 0:00:00
STAFFED 15:24:20 17:25:15 0:00:00
WORKDAY 08:00:14 17:25:15 0:00:00
3503 948 STAFFED 08:56:34 08:58:39 0:00:00 TSC
WORKDAY 08:56:34 08:58:39 0:00:00
3510 945 WALKAWAY 09:43:58 09:45:03 0:01:05 000 No Code Entered TSC
STAFFED 09:40:16 09:45:03 0:01:05
STAFFED 10:08:54 10:52:57 0:00:00
STAFFED 10:57:38 11:09:06 0:00:00
STAFFED 13:11:02 14:30:52 0:00:00
STAFFED 16:10:42 16:29:23 0:00:00
WORKDAY 09:40:16 16:29:23 0:01:05
3514 958 WALKAWAY 13:22:21 13:24:14 0:01:53 800 TSC - After Call Wrap up TSC
STAFFED 13:22:21 13:24:14 0:01:53
STAFFED 13:38:02 13:48:30 0:00:00
WALKAWAY 14:23:01 14:25:37 0:02:36 800 TSC - After Call Wrap up
WALKAWAY 14:30:49 14:31:30 0:00:41 800 TSC - After Call Wrap up
WALKAWAY 14:35:41 14:36:52 0:01:11 800 TSC - After Call Wrap up
WALKAWAY 14:58:12 14:58:27 0:00:15 800 TSC - After Call Wrap up
Agent Walkaway Report Page 16
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WALKAWAY 15:02:23 15:02:38 0:00:15 800 TSC - After Call Wrap up
WALKAWAY 15:10:02 15:10:30 0:00:28 800 TSC - After Call Wrap up
WALKAWAY 15:23:51 15:24:12 0:00:21 800 TSC - After Call Wrap up
STAFFED 14:10:37 15:39:33 0:05:47
WORKDAY 13:22:21 15:39:33 0:07:40
3517 1659 WALKAWAY 10:07:39 10:08:54 0:01:15 800 TSC - After Call Wrap up TSC
WALKAWAY 10:52:42 10:56:33 0:03:51 800 TSC - After Call Wrap up
STAFFED 09:35:48 11:11:38 0:05:06
WALKAWAY 11:24:29 11:26:16 0:01:47 800 TSC - After Call Wrap up
WALKAWAY 12:03:24 12:06:28 0:03:04 800 TSC - After Call Wrap up
WALKAWAY 12:22:14 12:24:12 0:01:58 800 TSC - After Call Wrap up
WALKAWAY 12:55:39 12:56:16 0:00:37 800 TSC - After Call Wrap up
WALKAWAY 13:32:00 13:32:41 0:00:41 800 TSC - After Call Wrap up
STAFFED 11:22:27 13:32:41 0:08:07
WALKAWAY 14:35:29 14:36:22 0:00:53 800 TSC - After Call Wrap up
WALKAWAY 14:40:49 14:41:44 0:00:55 800 TSC - After Call Wrap up
WALKAWAY 15:06:33 15:09:13 0:02:40 800 TSC - After Call Wrap up
WALKAWAY 15:37:04 15:41:18 0:04:14 800 TSC - After Call Wrap up
WALKAWAY 15:54:20 15:57:31 0:03:11 800 TSC - After Call Wrap up
WALKAWAY 16:09:10 16:09:11 0:00:01 880 Not Defined
WALKAWAY 16:41:35 16:41:44 0:00:09 800 TSC - After Call Wrap up
WALKAWAY 16:41:47 17:34:32 0:52:45 810 TSC - Customer Call Back
STAFFED 14:33:21 17:34:32 1:04:48
WALKAWAY 17:58:30 17:59:20 0:00:50 800 TSC - After Call Wrap up
WALKAWAY 18:03:56 18:26:30 0:22:34 800 TSC - After Call Wrap up
STAFFED 17:50:01 18:31:22 0:23:24
WORKDAY 09:35:48 18:31:22 1:41:25
3518 956 WALKAWAY 08:18:08 08:22:13 0:04:05 800 TSC - After Call Wrap up TSC
WALKAWAY 08:26:13 08:26:37 0:00:24 800 TSC - After Call Wrap up
WALKAWAY 08:40:11 08:44:59 0:04:48 800 TSC - After Call Wrap up
WALKAWAY 09:37:50 09:40:08 0:02:18 800 TSC - After Call Wrap up
STAFFED 07:57:44 10:03:56 0:11:35
WALKAWAY 11:16:00 11:17:11 0:01:11 800 TSC - After Call Wrap up
WALKAWAY 12:21:24 12:22:32 0:01:08 800 TSC - After Call Wrap up
STAFFED 10:20:47 12:22:32 0:02:19
WALKAWAY 13:30:00 13:32:32 0:02:32 800 TSC - After Call Wrap up
WALKAWAY 13:40:52 13:43:33 0:02:41 800 TSC - After Call Wrap up
WALKAWAY 15:35:17 15:36:14 0:00:57 800 TSC - After Call Wrap up
STAFFED 13:26:03 15:36:14 0:06:10
WALKAWAY 15:52:21 15:54:02 0:01:41 800 TSC - After Call Wrap up
WALKAWAY 16:16:47 16:18:04 0:01:17 800 TSC - After Call Wrap up
WALKAWAY 16:20:21 16:21:11 0:00:50 800 TSC - After Call Wrap up
WALKAWAY 16:26:59 16:28:28 0:01:29 800 TSC - After Call Wrap up
WALKAWAY 16:51:16 16:52:38 0:01:22 800 TSC - After Call Wrap up
WALKAWAY 17:45:33 17:45:33 0:00:00 800 TSC - After Call Wrap up
STAFFED 15:51:25 17:45:33 0:06:39
WORKDAY 07:57:44 17:45:33 0:26:43
Agent Walkaway Report Page 17
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
3519 961 WALKAWAY 08:09:52 08:16:37 0:06:45 410 Not Defined TSC
WALKAWAY 08:47:26 08:48:50 0:01:24 800 TSC - After Call Wrap up
WALKAWAY 08:48:53 08:48:54 0:00:01 410 Not Defined
WALKAWAY 08:55:39 09:06:51 0:11:12 800 TSC - After Call Wrap up
WALKAWAY 09:14:07 09:20:52 0:06:45 800 TSC - After Call Wrap up
STAFFED 08:00:46 10:33:34 0:26:07
WALKAWAY 11:12:02 11:18:19 0:06:17 800 TSC - After Call Wrap up
WALKAWAY 11:36:58 11:45:22 0:08:24 800 TSC - After Call Wrap up
WALKAWAY 11:51:11 11:57:04 0:05:53 800 TSC - After Call Wrap up
WALKAWAY 12:38:35 12:44:34 0:05:59 800 TSC - After Call Wrap up
WALKAWAY 12:56:40 12:58:45 0:02:05 800 TSC - After Call Wrap up
WALKAWAY 12:58:47 13:09:53 0:11:06 801 TSC - Personal Emergency
WALKAWAY 13:31:11 13:37:06 0:05:55 800 TSC - After Call Wrap up
STAFFED 10:55:16 13:46:01 0:45:39
WALKAWAY 14:57:44 14:58:31 0:00:47 800 TSC - After Call Wrap up
STAFFED 14:47:19 14:58:31 0:00:47
WALKAWAY 15:44:31 15:49:52 0:05:21 800 TSC - After Call Wrap up
STAFFED 15:21:46 15:49:52 0:05:21
WORKDAY 08:00:46 15:49:52 1:17:54
3520 952 WALKAWAY 13:34:38 13:39:06 0:04:28 800 TSC - After Call Wrap up TSC
STAFFED 13:34:38 13:44:30 0:04:28
STAFFED 14:01:35 15:35:32 0:00:00
WORKDAY 13:34:38 15:35:32 0:04:28
3526 950 WALKAWAY 08:53:04 08:58:12 0:05:08 800 TSC - After Call Wrap up TSC
STAFFED 07:29:31 10:30:40 0:05:08
STAFFED 10:59:16 12:16:00 0:00:00
WALKAWAY 13:51:38 14:01:50 0:10:12 800 TSC - After Call Wrap up
STAFFED 13:17:52 15:25:33 0:10:12
STAFFED 15:36:28 16:32:56 0:00:00
WORKDAY 07:29:31 16:32:56 0:15:20
3530 963 WALKAWAY 07:10:18 07:16:03 0:05:45 410 Not Defined TSC
WALKAWAY 08:07:29 08:09:23 0:01:54 800 TSC - After Call Wrap up
WALKAWAY 08:21:10 08:22:26 0:01:16 800 TSC - After Call Wrap up
STAFFED 06:20:01 08:34:29 0:08:55
WALKAWAY 10:00:13 10:03:02 0:02:49 410 Not Defined
STAFFED 08:47:56 10:31:34 0:02:49
WALKAWAY 12:29:19 12:33:41 0:04:22 800 TSC - After Call Wrap up
WALKAWAY 14:16:44 14:21:09 0:04:25 801 TSC - Personal Emergency
STAFFED 11:32:10 14:32:13 0:08:47
WALKAWAY 15:29:52 15:30:23 0:00:31 800 TSC - After Call Wrap up
STAFFED 14:44:16 15:30:23 0:00:31
WORKDAY 06:20:01 15:30:23 0:21:02
3534 970 STAFFED 07:53:35 12:28:41 0:00:00 TSC
STAFFED 13:20:05 16:59:59 0:00:00
Agent Walkaway Report Page 18
Daily Report
FLPH027, P2 Date: 03/02/07 Time: 09:22:07
Days: 01/01/07 - 03/01/07
AGENT POS ID PERIOD START END WALKAWAY WALKAWAY WALKAWAY COMMENT
TIME TIME TIME CODE REASON
HH:MM:SS
WORKDAY 07:53:35 16:59:59 0:00:00
3535 966 STAFFED 06:13:31 09:05:52 0:00:00 TSC
WALKAWAY 09:56:51 10:06:48 0:09:57 800 TSC - After Call Wrap up
STAFFED 09:23:48 11:07:01 0:09:57
STAFFED 11:24:39 12:31:08 0:00:00
WORKDAY 06:13:31 12:31:08 0:09:57
