Spreadsheet: 109428d1306281988-excel-2007-countifs-help-report
Sheet: AllOpen

Incident ID*+ | Assignee+ | Summary* | Status* | Submit Date | SLM_MeasurementStatus_SLA | Priority* | First Name*+ | Last Name*+ | [NAME] | Operational Categorization Tier 3
test 1 | test 1 | test 1 | In Progress | 2011-05-23 09:47:11 | Warning | test 1 | test 1 | test 1 | test 1 | PORT | 2011-05-23 15:09:50
test 2 | test 2 | test 2 | In Progress | 2011-05-22 19:43:57 | Warning | test 2 | test 2 | test 2 | test 2 | Web Sites | 2011-05-22 20:01:15
test 3 | test 3 | test 3 | Pending | 2011-05-24 15:56:37 | Pending | test 3 | test 3 | test 3 | test 3 |  |  | 2011-05-24 15:56:37
test 4 | test 4 | test 4 | Pending | 2011-05-23 18:13:27 | Pending | test 4 | test 4 | test 4 | test 4 | Cisco settings | 2011-05-23 18:13:27 | 2011-05-24 15:45:40
test 5 | test 5 | test 5 | Pending | 2011-05-20 15:49:52 | Pending | test 5 | test 5 | test 5 | test 5 | softphone | 2011-05-20 15:49:52 | 2011-05-24 15:34:39
test 6 | test 6 | test 6 | Pending | 2011-05-23 18:28:32 | Pending | test 6 | test 6 | test 6 | test 6 | Wireless connectivity | 2011-05-23 18:28:32 | 2011-05-24 08:56:16
test 7 | test 7 | test 7 | Pending | 2011-05-20 16:27:47 | Pending | test 7 | test 7 | test 7 | test 7 | laptop | 2011-05-20 16:27:47 | 2011-05-20 16:33:18
test 8 | test 8 | test 8 | Pending | 2011-05-19 14:43:23 | Pending | test 8 | test 8 | test 8 | test 8 |  | 2011-05-19 14:43:23 | 2011-05-19 16:25:44
test 9 | test 9 | test 9 | Pending | 2011-05-18 14:57:11 | Pending | test 9 | test 9 | test 9 | test 9 | User Account | 2011-05-23 09:39:57 | 2011-05-23 11:47:28
test 10 | test 10 | test 10 | Pending | 2011-05-16 06:01:04 | Pending | test 10 | test 10 | test 10 | test 10 | [NAME] and [NAME] | 2011-05-20 11:19:55 | 2011-05-20 12:22:15
test 11 | test 11 | test 11 | Pending | 2011-05-11 17:21:50 | Pending | test 11 | test 11 | test 11 | test 11 | equipment | 2011-05-16 14:35:01 | 2011-05-16 14:35:20
test 12 | test 12 | test 12 | Pending | 2011-05-11 10:44:04 | Pending | test 12 | test 12 | test 12 | test 12 | Hardware Break/Fix Support | 2011-05-11 10:44:04 | 2011-05-11 14:01:06
test 1 | test 1 | test 1 | Pending | 2011-05-18 08:23:38 | Pending | test 1 | test 1 | test 1 | test 1 | laptop | 2011-05-18 09:42:04 | 2011-05-18 09:42:16
test 2 | test 2 | test 2 | Pending | 2011-05-17 10:31:13 | Pending | test 2 | test 2 | test 2 | test 2 | laptop | 2011-05-20 13:54:20 | 2011-05-20 13:54:34
test 3 | test 3 | test 3 | Pending | 2011-05-13 09:49:32 | Pending | test 3 | test 3 | test 3 | test 3 | Office applications | 2011-05-13 09:49:32 | 2011-05-17 09:03:13
test 4 | test 4 | test 4 | Pending | 2011-05-23 10:17:16 | Pending | test 4 | test 4 | test 4 | test 4 | printer | 2011-05-23 10:17:16 | 2011-05-24 11:10:51
test 5 | test 5 | test 5 | Pending | 2011-05-23 14:34:54 | Pending | test 5 | test 5 | test 5 | test 5 | New Employee Preparation | 2011-05-23 14:34:54 | 2011-05-23 14:38:29
test 6 | test 6 | test 6 | Pending | 2011-05-18 13:17:08 | Pending | test 6 | test 6 | test 6 | test 6 | laptop | 2011-05-19 13:19:46 | 2011-05-20 11:17:29
test 7 | test 7 | test 7 | Pending | 2011-05-17 09:57:31 | Pending | test 7 | test 7 | test 7 | test 7 | mailbox | 2011-05-23 13:32:07 | 2011-05-24 10:10:31
test 8 | test 8 | test 8 | Pending | 2011-05-02 13:24:34 | Pending | test 8 | test 8 | test 8 | test 8 | Video Conferencing | 2011-05-02 13:24:34 | 2011-05-03 11:01:11
test 9 | test 9 | test 9 | Pending | 2011-05-17 13:43:21 | Pending | test 9 | test 9 | test 9 | test 9 | laptop | 2011-05-17 13:43:21 | 2011-05-18 11:15:25
test 10 | test 10 | test 10 | Pending | 2011-05-12 15:54:22 | Pending | test 10 | test 10 | test 10 | test 10 | VPN Client | 2011-05-18 06:00:04 | 2011-05-18 10:48:00
test 11 | test 11 | test 11 | Pending | 2011-05-09 16:16:26 | Pending | test 11 | test 11 | test 11 | test 11 | mailbox | 2011-05-09 16:16:26 | 2011-05-11 15:01:49
test 12 | test 12 | test 12 | Pending | 2011-05-05 15:51:20 | Pending | test 12 | test 12 | test 12 | test 12 |  | 2011-05-18 12:17:21 | 2011-05-18 17:11:43
test 1 | test 1 | test 1 | Pending | 2011-04-27 10:26:46 | Pending | test 1 | test 1 | test 1 | test 1 | New Employee Preparation | 2011-05-23 14:23:53 | 2011-05-23 17:06:37
test 2 | test 2 | test 2 | Pending | 2011-05-23 11:48:43 | Pending | test 2 | test 2 | test 2 | test 2 | Leaving Employee Procedure | 2011-05-23 11:48:43 | 2011-05-23 13:16:56
test 3 | test 3 | test 3 | Pending | 2011-05-09 15:10:25 | Pending | test 3 | test 3 | test 3 | test 3 | Leaving Employee Procedure | 2011-05-09 15:10:25 | 2011-05-09 15:29:15
test 4 | test 4 | test 4 | Pending | 2011-05-06 10:04:24 | Pending | test 4 | test 4 | test 4 | test 4 | Leaving Employee Procedure | 2011-05-06 10:04:24 | 2011-05-09 10:07:33
test 5 | test 5 | test 5 | Pending | 2011-05-05 11:57:34 | Pending | test 5 | test 5 | test 5 | test 5 | Leaving Employee Procedure | 2011-05-05 11:57:34 | 2011-05-06 12:32:35
test 6 | test 6 | test 6 | Pending | 2011-05-03 16:49:28 | Pending | test 6 | test 6 | test 6 | test 6 | Leaving Employee Procedure | 2011-05-03 17:24:49 | 2011-05-06 12:33:08
test 7 | test 7 | test 7 | Pending | 2011-04-29 17:49:30 | Pending | test 7 | test 7 | test 7 | test 7 |  | 2011-04-29 17:49:30 | 2011-05-02 09:36:11
test 8 | test 8 | test 8 | Pending | 2011-04-28 12:05:16 | Pending | test 8 | test 8 | test 8 | test 8 | Leaving Employee Procedure | 2011-04-28 12:05:16 | 2011-04-28 17:41:07
test 9 | test 9 | test 9 | Pending | 2011-04-28 09:44:59 | Pending | test 9 | test 9 | test 9 | test 9 | Leaving Employee Procedure | 2011-04-28 09:44:59 | 2011-04-28 16:45:15
test 10 | test 10 | test 10 | Pending | 2011-04-26 13:46:43 | Pending | test 10 | test 10 | test 10 | test 10 | Leaving Employee Procedure | 2011-04-26 13:46:43 | 2011-04-26 17:12:21
test 11 | test 11 | test 11 | Pending | 2011-04-08 15:34:58 | Pending | test 11 | test 11 | test 11 | test 11 | Leaving Employee Procedure | 2011-04-08 15:34:58 | 2011-04-08 18:46:53
test 12 | test 12 | test 12 | Pending | 2011-05-23 16:57:08 | Pending | test 12 | test 12 | test 12 | test 12 |  | 2011-05-24 12:57:14 | 2011-05-24 13:19:17
test 1 | test 1 | test 1 | Pending | 2011-05-12 16:44:34 | Pending | test 1 | test 1 | test 1 | test 1 |  |  | 2011-05-16 12:05:08
test 2 | test 2 | test 2 | Pending | 2011-05-01 06:31:50 | Pending | test 2 | test 2 | test 2 | test 2 | mailbox | 2011-05-17 08:44:50 | 2011-05-17 11:38:18
test 3 | test 3 | test 3 | Pending | 2011-05-23 11:39:58 | Pending | test 3 | test 3 | test 3 | test 3 | laptop | 2011-05-23 11:39:58 | 2011-05-23 15:46:18
test 4 | test 4 | test 4 | Pending | 2011-05-19 17:45:17 | Pending | test 4 | test 4 | test 4 | test 4 | Leaving Employee Procedure | 2011-05-19 17:45:17 | 2011-05-20 10:39:22
test 5 | test 5 | test 5 | Pending | 2011-05-19 17:43:09 | Pending | test 5 | test 5 | test 5 | test 5 | Leaving Employee Procedure | 2011-05-19 17:43:09 | 2011-05-20 10:40:38
test 6 | test 6 | test 6 | Pending | 2011-05-17 15:41:54 | Pending | test 6 | test 6 | test 6 | test 6 |  | 2011-05-18 16:42:40 | 2011-05-23 14:01:58
test 7 | test 7 | test 7 | Pending | 2011-05-05 10:50:43 | Pending | test 7 | test 7 | test 7 | test 7 | [NAME] and [NAME] | 2011-05-05 10:50:43 | 2011-05-10 12:03:36
test 8 | test 8 | test 8 | Pending | 2011-05-04 15:09:49 | Pending | test 8 | test 8 | test 8 | test 8 | New Employee Preparation | 2011-05-05 12:53:05 | 2011-05-05 15:06:03
test 9 | test 9 | test 9 | Pending | 2011-05-18 08:25:42 | Pending | test 9 | test 9 | test 9 | test 9 | monitor | 2011-05-18 08:25:42 | 2011-05-19 15:46:49
test 10 | test 10 | test 10 | Pending | 2011-05-10 16:21:59 | Pending | test 10 | test 10 | test 10 | test 10 | File store. Backup and File Recovery | 2011-05-10 16:21:59 | 2011-05-10 17:19:13
test 11 | test 11 | test 11 | Pending | 2011-04-29 12:53:56 | Pending | test 11 | test 11 | test 11 | test 11 | New Employee Preparation | 2011-05-05 13:36:21 | 2011-05-05 15:11:30
test 12 | test 12 | test 12 | Assigned | 2011-05-18 15:45:39 | Missed Goal | test 12 | test 12 | test 12 | test 12 | softphone | 2011-05-22 01:25:48 | 2011-05-19 14:38:07
test 1 | test 1 | test 1 | Assigned | 2011-05-18 13:46:18 | Missed Goal | test 1 | test 1 | test 1 | test 1 | softphone | 2011-05-22 01:28:11 | 2011-05-19 14:35:57
test 2 | test 2 | test 2 | Pending | 2011-05-20 16:46:59 | Missed Goal | test 2 | test 2 | test 2 | test 2 | laptop's accessories | 2011-05-20 16:46:59 | 2011-05-23 11:54:19
test 3 | test 3 | test 3 | In Progress | 2011-05-20 13:39:27 | Missed Goal | test 3 | test 3 | test 3 | test 3 | laptop's accessories | 2011-05-20 13:39:27
test 4 | test 4 | test 4 | In Progress | 2011-05-20 11:22:57 | Missed Goal | test 4 | test 4 | test 4 | test 4 | printer | 2011-05-20 11:22:57
test 5 | test 5 | test 5 | In Progress | 2011-05-19 22:32:08 | Missed Goal | test 5 | test 5 | test 5 | test 5 | LAN Administration | 2011-05-19 22:32:08
test 6 | test 6 | test 6 | Pending | 2011-05-19 17:58:39 | Missed Goal | test 6 | test 6 | test 6 | test 6 | laptop's accessories | 2011-05-19 17:58:39 | 2011-05-20 09:39:25
test 7 | test 7 | test 7 | Pending | 2011-04-19 11:28:54 | Missed Goal | test 7 | test 7 | test 7 | test 7 |  | 2011-04-19 11:28:54 | 2011-04-19 12:29:48
test 8 | test 8 | test 8 | Pending | 2011-05-11 08:25:48 | Missed Goal | test 8 | test 8 | test 8 | test 8 | upgrade laptop | 2011-05-18 13:26:46 | 2011-05-18 14:05:05
test 9 | test 9 | test 9 | In Progress | 2011-04-20 10:08:00 | Missed Goal | test 9 | test 9 | test 9 | test 9 | Leaving Employee Procedure | 2011-04-20 10:08:00
test 10 | test 10 | test 10 | In Progress | 2011-05-22 17:22:02 | Missed Goal | test 10 | test 10 | test 10 | test 10 | mailbox | 2011-05-22 23:03:42
test 11 | test 11 | test 11 | In Progress | 2011-05-20 11:58:12 | Missed Goal | test 11 | test 11 | test 11 | test 11 | New Employee Preparation | 2011-05-23 12:32:40 | 2011-05-23 10:13:47
test 12 | test 12 | test 12 | In Progress | 2011-04-26 07:54:35 | Missed Goal | test 12 | test 12 | test 12 | test 12 | antivirus/firewall | 2011-04-26 07:54:35
test 1 | test 1 | test 1 | In Progress | 2011-05-24 11:03:29 | In Process | test 1 | test 1 | test 1 | test 1
test 2 | test 2 | test 2 | Pending | 2011-04-28 15:27:42 | In Process | test 2 | test 2 | test 2 | test 2 |  |  | 2011-05-05 15:50:05
test 3 | test 3 | test 3 | In Progress | 2011-05-24 13:14:23 | In Process | test 3 | test 3 | test 3 | test 3 | Wireless | 2011-05-24 13:14:23
test 4 | test 4 | test 4 | In Progress | 2011-05-24 09:42:40 | In Process | test 4 | test 4 | test 4 | test 4 | Blue screen | 2011-05-24 09:42:40
test 5 | test 5 | test 5 | In Progress | 2011-05-20 12:26:12 | In Process | test 5 | test 5 | test 5 | test 5 |  | 2011-05-20 12:26:12
test 6 | test 6 | test 6 | Pending | 2011-05-16 15:52:53 | In Process | test 6 | test 6 | test 6 | test 6 | laptop's accessories | 2011-05-24 15:28:14 | 2011-05-24 15:50:38
test 7 | test 7 | test 7 | In Progress | 2011-05-23 17:43:21 | In Process | test 7 | test 7 | test 7 | test 7 | LAN Administration | 2011-05-23 17:43:21
test 8 | test 8 | test 8 | In Progress | 2011-05-24 11:15:15 | In Process | test 8 | test 8 | test 8 | test 8 | mailbox | 2011-05-24 11:15:15
test 9 | test 9 | test 9 | In Progress | 2011-05-17 10:40:04 | In Process | test 9 | test 9 | test 9 | test 9 | User Account | 2011-05-18 15:21:28 | 2011-05-17 11:00:07
test 10 | test 10 | test 10 | Assigned | 2011-05-20 16:05:33 | In Process | test 10 | test 10 | test 10 | test 10 | Distribution Lists | 2011-05-24 12:39:56 | 2011-05-23 11:10:22
test 11 | test 11 | test 11 | Pending | 2011-05-05 11:50:00 | In Process | test 11 | test 11 | test 11 | test 11 | Leaving Employee Procedure | 2011-05-05 11:50:00 | 2011-05-06 12:32:51
test 12 | test 12 | test 12 | In Progress | 2011-05-24 12:53:20 | In Process | test 12 | test 12 | test 12 | test 12 | New Employee Preparation | 2011-05-24 12:53:20
test 1 | test 1 | test 1 | In Progress | 2011-05-24 09:53:16 | In Process | test 1 | test 1 | test 1 | test 1 |  | 2011-05-24 09:53:16
test 2 | test 2 | test 2 | In Progress | 2011-05-23 12:02:34 | In Process | test 2 | test 2 | test 2 | test 2 | Leaving Employee Procedure | 2011-05-23 12:02:34
test 3 | test 3 | test 3 | Pending | 2011-05-18 13:31:18 | Detached | test 3 | test 3 | test 3 | test 3 | Fault/Failure | 2011-05-18 13:31:18 | 2011-05-20 16:42:32
test 4 | test 4 | test 4 | Pending | 2011-05-16 22:07:28 | Detached | test 4 | test 4 | test 4 | test 4 | Fault/Failure | 2011-05-19 12:16:12 | 2011-05-19 13:08:13
test 5 | test 5 | test 5 | Assigned | 2011-05-23 09:24:05 |  | test 5 | test 5 | test 5 | test 5 | Survey | 2011-05-23 09:24:05
test 6 | test 6 | test 6 | Assigned | 2011-05-17 03:44:25 |  | test 6 | test 6 | test 6 | test 6 | Survey | 2011-05-17 03:44:25
test 7 | test 7 | test 7 | Assigned | 2011-05-02 09:30:24 |  | test 7 | test 7 | test 7 | test 7 | Survey | 2011-05-02 09:30:24
test 8 | test 8 | test 8 | In Progress | 2011-04-26 12:41:29 |  | test 8 | test 8 | test 8 | test 8 | Survey | 2011-04-26 12:41:29
test 9 | test 9 | test 9 | In Progress | 2011-04-17 09:25:08 |  | test 9 | test 9 | test 9 | test 9 | Survey | 2011-04-17 09:25:08
test 10 | test 10 | test 10 | In Progress | 2011-04-11 09:39:52 |  | test 10 | test 10 | test 10 | test 10 | Survey | 2011-04-11 09:39:52