Spreadsheet: 701025d1603468522-data-from-multiple-columns-into-one-table-by-date-query-dates-for-gates
Sheet: owssvr (1)

Title | Status of Project | Project Manager | Current Stage Gate | Health Check Type | Pipeline Transition Review | Start Up Review | Initiate Health Check | Define and Design Health Check | Build and Deliver Health Check | Closure Health Check | Item Type | Path
Project 1 | Closed | t8860 | Closure | Progress to next stage (Mandatory) |  | 2019-05-22 00:00:00 | 2019-06-27 00:00:00 | 2019-09-02 00:00:00 | 2020-02-25 00:00:00 | 2020-03-26 00:00:00
Project 2 | Controlled Closure | t8861 | Define & Design | Review (Mandatory) |  |  | 2019-09-05 00:00:00
Project 3 | Controlled Closure | t8862 | Build & Deliver |  |  |  | 2018-03-21 00:00:00 | 2018-03-21 00:00:00 | 2020-02-25 00:00:00
Project 4 | Controlled Closure | t8863 | Build & Deliver |  |  |  | 2018-03-28 00:00:00 | 2018-05-30 00:00:00 | 2019-02-27 00:00:00
Project 5 | Controlled Closure | [NAME] | Initiation | Progress to next stage (Mandatory) |  |  | 2020-02-27 00:00:00
Project 6 | Controlled Closure | t8865 | Initiation
Project 7 | Controlled Closure | t8866
Project 8 | Live | t8867 | Define & Design | 6 Monthly (Optional) |  |  | 2019-01-28 00:00:00 |  |  | 2020-09-15 00:00:00
Project 9 | Live | t8868 | Build & Deliver | Review (Mandatory) |  | 2019-04-16 00:00:00 | 2019-07-25 00:00:00 | 2019-10-08 00:00:00 | 2020-02-20 00:00:00
Project 10 | Live | t8869 | Initiation | 6 Monthly (Optional) |  | 2019-05-09 00:00:00 | 2020-06-22 00:00:00
Project 11 | Live | t8870 | Build & Deliver | Review (Mandatory) |  | 2019-05-09 00:00:00 | 2019-07-03 00:00:00 | 2019-09-11 00:00:00 | 2020-06-16 00:00:00
Project 12 | Live | [NAME] | Build & Deliver | 6 Monthly (Optional) |  |  | 2018-11-15 00:00:00 | 2020-03-09 00:00:00 | 2020-10-14 00:00:00
Project 13 | Live | t8872 | Build & Deliver | Progress to next stage (Mandatory) |  | 2019-03-14 00:00:00 | 2019-03-14 00:00:00 | 2019-08-14 00:00:00
Project 14 | Live | t8873 | Build & Deliver
Project 15 | Live | t8874 | Build & Deliver |  |  |  | 2018-11-19 00:00:00
Project 16 | Live | [NAME] | Build & Deliver | Review (Mandatory) |  |  | 2018-10-24 00:00:00 | 2019-08-21 00:00:00 | 2020-06-18 00:00:00
Project 17 | Live | t8876 | Build & Deliver | 6 Monthly (Optional) |  |  | 2018-06-18 00:00:00 |  | 2020-11-02 00:00:00
Project 18 | Live | t8877 | Build & Deliver | 6 Monthly (Optional) |  |  | 2018-07-23 00:00:00 | 2019-12-09 00:00:00 | 2020-07-15 00:00:00
Project 19 | Live | t8878 | Define & Design
Project 20 | Live | t8879 | Closure |  |  |  | 2017-10-09 00:00:00 | 2018-04-19 00:00:00 | 2018-08-16 00:00:00 | 2020-08-21 00:00:00
Project 21 | Live | t8880 | Define & Design | Progress to next stage (Mandatory) |  |  | 2019-01-10 00:00:00 | 2020-01-30 00:00:00
Project 22 | Live | t8881 | Closure |  |  | 2019-09-12 00:00:00 |  |  | 2020-06-25 00:00:00
Project 23 | Live | t8882 | Build & Deliver | Progress to next stage (Mandatory) |  |  | 2020-01-30 00:00:00 | 2020-02-19 00:00:00 | 2020-02-27 00:00:00
Project 24 | Live | t8883 | Initiation | Progress to next stage (Mandatory) | 2020-03-09 00:00:00 | 2020-08-03 00:00:00 | 2020-11-11 00:00:00
Project 25 | Live | t8884 | Initiation | Start up (Optional) | 2020-03-12 00:00:00 | 2020-03-12 00:00:00
Project 26 | Live | t8885 | Build & Deliver | Progress to next stage (Mandatory) | 2020-04-14 00:00:00 | 2020-05-15 00:00:00 | 2020-06-08 00:00:00 | 2020-06-08 00:00:00
Project 27 | Live | t8886 | Build & Deliver | Progress to next stage (Mandatory) |  |  |  | 2020-03-30 00:00:00 | 2020-10-12 00:00:00
Project 28 | Live | t8887 | Build & Deliver |  |  |  | 2020-09-11 00:00:00 | 2020-07-29 00:00:00
Project 29 | Live | t8888 | Build & Deliver | Review (Mandatory) |  | 2020-07-20 00:00:00 | 2020-07-20 00:00:00 | 2020-07-20 00:00:00 | 2020-08-19 00:00:00
Project 30 | Live | t8889 | Initiation |  |  | 2020-10-14 00:00:00
Project 31 | On Hold | t8890 | Initiation | Review (Mandatory)
Project 32 | On Hold | t8891 | Build & Deliver | 6 Monthly (Optional) |  |  |  | 2019-10-17 00:00:00 | 2020-10-19 00:00:00
Project 33 | On Hold | t8892 | Closure | Review (Mandatory)
Project 34 | Pending Review | t8893 | Initiation | Start up (Optional) | 2020-03-18 00:00:00
Project 35 | Pipeline | [NAME] | Pipeline Transition | Start up (Optional) | 2020-02-10 00:00:00 | 2020-10-15 00:00:00
Project 36 | Pipeline | t8895 | Pipeline Transition