Spreadsheet: 154786d1336565569-run-an-if-statement-of-a-dependent-drop-down-list-application-master_john_v2
Sheet: POC Tracking Sheet

Ticket /Case # | Date | Application Name | Sev | Incident Start Time | Incident End Time | Incidnet Duration in hours | Indicent Start Date | Indicent End Date | Duration in days | Description of Issue/Impact | Immediate Fix | Issue Category (Need a Name) | Issue Sub Category | Other | [NAME] if  applicable | RCA Requested | RCA Requested Date | Prbolem Record Complete Y or N | Owner of problem [NAME] | Last Contact Date | Long Term Corrective Action | Timeline for LTCA | Owner of LTCA | Related Change Request or Incident |  |  |  |  |  |  |  |  | Ticket/Case # | Date | Application Name | Sev | Incident Start Time | Incident End Time | Incidnet Duration in hours | Indicent Start Date | Indicent End Date | Duration in days | Description of Issue/Impact | Immediate Fix | Issue Category (Need a Name) | Issue Sub Category | Other | [NAME] if  applicable | RCA Requested | RCA Requested Date | Prbolem Record Complete Y or N | Owner of problem Record From IBM | Last Contact Date | Long Term Corrective Action | Timeline for LTCA | Owner of LTCA | Related Change Request or Incident
IN12345678 | 2012-01-01 00:00:00 | TPS | 2 | 01:03:00 | 14:00:00 |  | 2012-01-01 00:00:00 | 2012-01-15 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Scripts | Other |  | BSMED02S | N |  | N |  | 2054-07-24 00:00:00 | N | 2012-04-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Care Planner | 1 | 08:30:00 | 09:05:00 |  | 2012-01-01 00:00:00 | 2012-01-10 00:00:00 |  | Descrption | Descrption |  |  |  |  | Y |  | Y |  |  | Y |  |  |  |  | Servers | Rebooted | Space | Security login | Reconfigure | Other |  |  | Y
IN12345679 | 2012-01-02 00:00:00 | Outlook | 2 | 01:00:00 | 19:18:00 |  | 2012-01-02 00:00:00 | 2012-01-16 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Scripts | Other |  | BSMED02S | Y | 2012-04-10 00:00:00 | Y |  | 2020-08-10 00:00:00 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | MCPS | 2 |  |  |  |  |  |  |  |  |  |  |  |  | N |  | N |  |  | N |  |  |  |  | Scripts | Schedule | ETL Failure | File Access Issue | Other |  |  |  | N
IN12345680 | 2012-01-03 00:00:00 | MCPS | 2 | 01:00:00 | 11:57:00 |  | 2012-01-03 00:00:00 | 2012-01-17 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Scripts | Schedule |  | BSMED02S | N |  | N |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  | TPS | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Security | Fire Wall | Access Denied | Other
IN12345681 | 2012-01-04 00:00:00 | MCPS | 2 | 03:00:00 | 16:00:00 |  | 2012-01-04 00:00:00 | 2012-01-18 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | ETL | ETL Failure |  | BSMED02S | Y |  | N |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | NASCO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maintenance | [NAME] | Code Failure | Other
IN12345682 | 2012-01-05 00:00:00 | Care Planner | 2 | 01:00:00 | 14:45:00 |  | 2012-01-05 00:00:00 | 2012-01-19 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Maintenance | Other |  | BSMED02S | Y |  | N |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | RTMS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Applications | Configuration | User Error | Database | Networking | Connectivity | Other
IN12345683 | 2012-01-06 00:00:00 | MCPS | 2 | 13:12:00 | 20:45:00 |  | 2012-01-06 00:00:00 | 2012-01-20 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Security | File Access Issue |  | BSMED02S | Y |  | Y |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  | Outlook |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ETL | Schedule | Server | File Access | Other
IN12345684 | 2012-01-07 00:00:00 | TPS | 2 | 00:12:00 | 16:14:00 |  | 2012-01-07 00:00:00 | 2012-01-21 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters | Security | Other |  | BSMED02S | N |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | 5010
IN12345685 | 2012-01-08 00:00:00 | NASCO | 2 | 01:12:00 | 18:14:00 |  | 2012-01-08 00:00:00 | 2012-01-22 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blue Squard
IN12345686 | 2012-01-09 00:00:00 | 5010 | 1 | 02:12:00 | 15:14:00 |  | 2012-01-09 00:00:00 | 2012-01-23 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345687 | 2012-01-10 00:00:00 | Blue Squard | 1 | 03:12:00 | 16:14:00 |  | 2012-01-10 00:00:00 | 2012-01-24 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345688 | 2012-01-11 00:00:00 | 5010 | 1 | 04:12:00 | 17:14:00 |  | 2012-01-11 00:00:00 | 2012-01-25 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345689 | 2012-01-12 00:00:00 | NASCO | 2 | 05:12:00 | 22:14:00 |  | 2012-01-12 00:00:00 | 2012-01-26 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345690 | 2012-01-13 00:00:00 | RTMS | 1 | 06:12:00 | 22:14:00 |  | 2012-01-13 00:00:00 | 2012-01-27 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345691 | 2012-01-14 00:00:00 | MCPS | 3 | 07:12:00 | 23:14:00 |  | 2012-01-14 00:00:00 | 2012-01-28 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345692 | 2012-01-15 00:00:00 | Blue Squard | 1 | 08:12:00 | 1900-01-01 00:14:00 |  | 2012-01-15 00:00:00 | 2012-01-29 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345693 | 2012-01-16 00:00:00 | Blue Squard | 1 | 09:12:00 | 1900-01-01 01:14:00 |  | 2012-01-16 00:00:00 | 2012-01-30 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345694 | 2012-01-17 00:00:00 | NASCO | 1 | 10:12:00 | 1900-01-01 02:14:00 |  | 2012-01-17 00:00:00 | 2012-01-31 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345695 | 2012-01-18 00:00:00 | Blue Squard | 1 | 11:12:00 | 1900-01-01 03:14:00 |  | 2012-01-18 00:00:00 | 2012-02-01 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345696 | 2012-01-19 00:00:00 | Blue Squard | 1 | 12:12:00 | 1900-01-01 04:14:00 |  | 2012-01-19 00:00:00 | 2012-02-02 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345697 | 2012-01-20 00:00:00 | RTMS | 1 | 13:12:00 | 1900-01-01 05:14:00 |  | 2012-01-20 00:00:00 | 2012-02-03 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345698 | 2012-01-21 00:00:00 | NASCO | 2 | 14:12:00 | 1900-01-01 06:14:00 |  | 2012-01-21 00:00:00 | 2012-02-04 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345699 | 2012-01-22 00:00:00 | Outlook | 2 | 15:12:00 | 1900-01-01 07:14:00 |  | 2012-01-22 00:00:00 | 2012-02-05 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345700 | 2012-01-23 00:00:00 | Outlook | 2 | 16:12:00 | 1900-01-01 08:14:00 |  | 2012-01-23 00:00:00 | 2012-02-06 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S
IN12345701 | 2012-01-24 00:00:00 | Outlook | 1 | 17:12:00 | 1900-01-01 09:14:00 |  | 2012-01-24 00:00:00 | 2012-02-07 00:00:00 |  | Free Text 200 Charcters | Free Text 50 Charcters |  |  |  | BSMED02S