Spreadsheet: 38690d1236838812-average-based-on-multiple-conditions-average-of-workdays-between-two-dates-based-on-book1
Sheet: Sheet1

Data Extracted from AHD Between 1/10/2008  12:00:00AM  - 28/02/2009  12:00:00AM
Incident Id | Severity | Priority | Status | Date & Time Raised | Date & Time Restored | Date & Time Closed | Created By Group | Restoration Group | Closed Group | User Comment
3725407 | Prod Severity 4 | 4 | Closed | 2007-09-17 11:18:43 |  | 13/11/2008   9:58:10AM | GSDS eCommerce Support | GSDS eCommerce Support | GSDS eCommerce Support | No longer outstanding and NIC cqard has been operational for 100 days. We have received no issues about this since this alert. Will close job. |  |  |  |  |  |  |  |  |  | #N/A |  |  | #N/A
4135470 | Prod Severity 4 | 1 | Closed | 2008-04-28 03:01:39 |  | 24/02/2009   8:56:26AM | Middleware Production Services - WAS | Middleware Production Services - WAS | Middleware Production Services - WAS | N/A |  |  |  |  |  |  |  |  |  | #N/A
4196589 | Development Severity 5 | 5 | Acknowledge | 2008-05-26 15:01:34 |  |  | GSDS Project Delivery Lab Projects | N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A
4354962 | Prod Severity 4 | 5 | Closed | 2008-08-08 20:24:00 | 13/10/2008   5:12:10PM | 13/10/2008   8:39:02PM | Technology Service Desk - Bangalore | GSDS Development Support | Technology Service Desk - Bangalore | Issue has been resolved. |  |  |  |  |  |  |  |  |  | #N/A
4379258 | Development Severity 3 | 5 | Closed | 2008-08-19 17:16:21 | 2/12/2008  11:28:36AM | 2/12/2008  10:28:58AM | GSDS Development Support | GSDS Development Support | GSDS Development Support | N/A |  |  |  |  |  |  |  |  |  | -136
4387470 | Development Severity 5 | 5 | Closed | 2008-08-22 20:24:30 | 21/10/2008   1:21:09PM | 21/10/2008   5:53:01PM | Technology Service Desk - Bangalore | GSDS Development Support | Technology Service Desk - Bangalore | Issue is resolved. |  |  |  |  |  |  |  |  |  | #N/A
4447301 | Prod Severity 4 | 4 | Closed | 2008-09-16 17:58:05 | 15/10/2008   2:45:46PM | 15/10/2008   3:01:30PM | Technology Service Desk - Bangalore | Technology Service Desk - Bangalore | Technology Service Desk - Bangalore | From: M S, Muralidhar  Sent: Wednesday, 15 October 2008 9:17 AM To: Technology Service Desk - Bangalore Subject: RE: PCRS Issues/ SAS Issues on [NAME] box 4447301   No [NAME], This problem got resolved after the Server Shutdown Issues/Access Issues.  But t |  |  |  |  |  |  |  |  |  | #N/A
4455738 | Prod Severity 4 | 5 | Closed | 2008-09-19 17:32:47 | 6/10/2008  10:42:12AM | 13/10/2008   1:59:33PM | Technology Service Desk - Bangalore | GSDS Development Support | Technology Service Desk - Bangalore | Issue resolved. |  |  |  |  |  |  |  |  |  | #N/A
4465257 | Development Severity 4 | 1 | Closed | 2008-09-24 16:40:49 | 29/10/2008   2:20:36PM | 31/10/2008   8:23:43AM | [NAME] Service Desk | GSDS Development Support | [NAME] Service Desk | N/A |  |  |  |  |  |  |  |  |  | #N/A
4466968 | Development Severity 4 | 5 | Closed | 2008-09-25 12:25:16 | 20/10/2008   3:48:30PM | 1/12/2008  10:25:54AM | Payments Test Environment Support | GSDS Development Support | Payments Test Environment Support | N/A |  |  |  |  |  |  |  |  |  | -184
4468816 | Prod Severity 4 | 5 | Service Restored | 2008-09-26 10:10:20 | 1/10/2008   4:07:24PM |  | Payments Test Environment Support | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4469806 | Development Severity 3 | 5 | Service Restored | 2008-09-26 16:03:02 | 7/10/2008  10:36:04AM |  | Trust & Authentication Systems | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4476298 | Development Severity 4 | 4 | Closed | 2008-09-30 14:38:24 | 21/11/2008   3:16:17PM | 21/11/2008   2:30:46PM | EA - Environment Management | EA - Environment Management | EA - Environment Management | N/A |  |  |  |  |  |  |  |  |  | #N/A
4476658 | Development Severity 4 | 4 | Closed | 2008-09-30 17:40:49 | 7/10/2008  10:35:37AM | 16/10/2008   5:42:07PM | ORION Support | GSDS Development Support | ORION Support | N/A |  |  |  |  |  |  |  |  |  | #N/A
4477934 | Development Severity 5 | 5 | Closed | 2008-10-01 08:41:10 | 2/10/2008  11:34:28AM | 23/10/2008  11:19:18AM | GIW Development | GSDS Development Support | GIW Development | N/A |  |  |  |  |  |  |  |  |  | #N/A
4478451 | Development Severity 4 | 5 | Closed | 2008-10-01 10:54:31 | 7/10/2008   9:49:01AM | 8/10/2008  10:47:10AM | Payments Windows Support | GSDS Development Support | Voucher Processing Applications Support | N/A |  |  |  |  |  |  |  |  |  | -38
4479006 | Development Severity 3 | 5 | Closed | 2008-10-01 13:36:06 | 1/10/2008   3:14:15PM | 2/10/2008   2:45:25PM | EIS Infrastructure - Development | GSDS Development Support | EIS Infrastructure - Development | pwd restored |  |  |  |  |  |  |  |  |  | -168
4479534 | Prod Severity 3 | 1 | Closed | 2008-10-01 17:40:53 |  | 9/10/2008   9:47:58AM | Institutional Technology Custody Sup (ANZIT) | Institutional Technology Custody Sup (ANZIT) | Institutional Technology Custody Sup (ANZIT) | N/A |  |  |  |  |  |  |  |  |  | -16
4482078 | Development Severity 2 | 5 | Service Restored | 2008-10-02 17:48:44 | 3/10/2008  10:37:50AM |  | Payments Test Environment Support | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4483207 | Prod Severity 5 | 5 | Closed | 2008-10-03 10:16:31 | 3/10/2008   3:59:46PM | 3/11/2008  12:13:07PM | Institutional Tech-Cash Technology | GSDS Development Support | 0 | Institutional Tech-Cash Technology | [NAME] has had more than enough opportinuty to action this record if required |  |  |  |  |  |  |  |  | -149
4483382 | Prod Severity 4 | 5 | Closed | 2008-10-03 11:10:33 |  | 10/10/2008   4:23:45PM | Technology Service Desk - Bangalore | Technology Service Desk - Bangalore | Technology Service Desk - Bangalore | Issue has been solved with the help of development support team. |  |  |  |  |  |  |  |  |  | 6
4484356 | Development Severity 3 | 1 | Closed | 2008-10-03 17:00:28 | 6/10/2008  10:07:11AM | 6/10/2008   9:44:17AM | Markets Shared Services Support | GSDS Development Support | Markets Shared Services Support | N/A |  |  |  |  |  |  |  |  |  | -84
4487695 | Development Severity 3 | 3 | Closed | 2008-10-06 09:17:11 | 6/10/2008  10:46:54AM | 13/10/2008  10:12:08AM | [NAME] Service Desk | GSDS Development Support | [NAME] Service Desk | N/A |  |  |  |  |  |  |  |  |  | #N/A
4487851 | Prod Severity 3 | 3 | Closed | 2008-10-06 10:07:56 | 6/10/2008   3:16:25PM | 13/10/2008   2:18:45PM | Mortgages PSS WFDP | GSDS Development Support | ITOS Service Desk | [NAME] has advised that this has been actioned.  [NAME].  [NAME]. |  |  |  |  |  |  |  |  |  | #N/A
4488162 | Development Severity 3 | 5 | Closed | 2008-10-06 11:46:28 | 6/10/2008   3:18:09PM | 7/10/2008  10:33:42AM | Technology Team - Mortgages | GSDS Development Support | Technology Team - Mortgages | N/A |  |  |  |  |  |  |  |  |  | -63
4488504 | Development Severity 3 | 5 | Closed | 2008-10-06 13:49:27 | 20/10/2008   2:55:12PM | 11/12/2008  11:07:08AM | EIS Infrastructure - Development | GSDS Development Support | EIS Infrastructure - Development | working as expected |  |  |  |  |  |  |  |  |  | 28
4488554 | Development Severity 3 | 5 | Service Restored | 2008-10-06 14:04:58 | 7/10/2008   9:14:02AM |  | ANZIT Internal Projects | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4489145 | Development Severity 3 | 5 | Service Restored | 2008-10-06 19:56:54 | 7/10/2008   9:33:02AM |  | MAPS Production Support | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4489208 | Development Severity 3 | 2 | Closed | 2008-10-06 21:15:55 | 8/10/2008  10:40:15AM | 8/10/2008  10:07:15AM | GSDS Development Support | GSDS Development Support | GSDS Development Support | N/A |  |  |  |  |  |  |  |  |  | -41
4489239 | Prod Severity 5 | 4 | Closed | 2008-10-06 21:56:33 |  | 7/10/2008   4:12:27PM | [NAME] | [NAME] | [NAME] | No Virus Found! [NAME]! |  |  |  |  |  |  |  |  |  | -63
4490351 | Development Severity 4 | 5 | Closed | 2008-10-07 09:10:43 | 7/10/2008  12:33:18PM | 10/10/2008  10:16:45AM | EIS Infrastructure - Development | GSDS Development Support | EIS Infrastructure - Development | The server is up and running now. |  |  |  |  |  |  |  |  |  | 4
4490840 | Development Severity 2 | 5 | Closed | 2008-10-07 11:15:07 | 10/10/2008   9:40:07PM | 1/12/2008  10:25:39AM | Payments Test Environment Support | GSDS Development Support | Payments Test Environment Support | N/A |  |  |  |  |  |  |  |  |  | -192
4491612 | Development Severity 3 | 2 | Closed | 2008-10-07 14:57:31 | 7/10/2008   7:31:19PM | 13/10/2008   3:50:14PM | Database Services SQL | GSDS Development Support | Database Services SQL | N/A |  |  |  |  |  |  |  |  |  | #N/A
4491725 | Development Severity 3 | 3 | Closed | 2008-10-07 15:59:05 | 7/10/2008   7:09:10PM | 14/10/2008   2:56:37PM | C&IT eCommerce Systems | GSDS Development Support | C&IT eCommerce Systems | N/A |  |  |  |  |  |  |  |  |  | #N/A
4491924 | Development Severity 5 | 5 | Service Restored | 2008-10-07 18:00:42 | 8/10/2008   2:25:52PM |  | GSDS Project Delivery | GSDS Development Support |  |  |  |  |  |  |  |  |  |  |  | #N/A
4494878 | Prod Severity 5 | 4 | Closed | 2008-10-08 18:17:01 | 9/10/2008  11:19:07AM | 13/02/2009   6:59:50PM | ORION Development | GSDS Development Support | ORION Development | AHD has been compleated as per request. |  |  |  |  |  |  |  |  |  | #N/A
4495022 | Prod Severity 4 | 5 | Closed | 2008-10-08 19:50:52 |  | 21/10/2008   7:37:51PM | Technology Service Desk - Bangalore | Technology Service Desk - Bangalore | GSDS OTSS India Support | done |  |  |  |  |  |  |  |  |  | #N/A
4495072 | Development Severity 3 | 3 | Open | 2008-10-08 20:39:32 |  |  | Branch Technologies Development | N/A |  |  |  |  |  |  |  |  |  |  |  | #N/A