Spreadsheet: 718261d1613061433-list-of-values-based-on-a-specific-criteria-porfolio-1-
Sheet: Portfolio view

PROJECT TITLE/ NAME | PROJECT STATUS | [NAME] | START DATE | TARGET END DATE | ACTUAL END DATE
Project 1 | On Hold | Red | 2020-07-10 00:00:00 | TBC - after project scoping
Project 2 | In Progress | Red | 2020-07-14 00:00:00 | 2020-09-30 00:00:00 |  |  | In progress
Project 3 | Closed | Green | 2020-03-10 00:00:00 | 2020-10-01 00:00:00 | 2021-01-28 00:00:00 |  | On Hold
Project 4 | Closed | Green | 2020-06-23 00:00:00 | 2020-12-01 00:00:00 |  |  | Closed
Project 5 | Closed | Green | 2020-07-02 00:00:00 | 2020-09-21 00:00:00 |  |  | Pending
Project 6 | In Progress | Amber | 2020-06-01 00:00:00 | Phase 1 -  December 2020 / January 2021 Phase 2 - April 2021 - June 2021 Phase 3 - August / September 2021
Project 7 | Closed | Green |  | 2020-08-30 00:00:00
Project 8 | Closed | Green |  | 2020-08-24 00:00:00 | 2020-10-01 00:00:00
Project 9 | In Progress | Red | 2019-06-01 00:00:00 | 2020-10-15 00:00:00
Project 10 | In Progress | Green | 2020-02-01 00:00:00 | Phase 1 - September 2020 Phase 2 - November 2020 Phase 3 - June 2021 Phase 4 - June 2021 Phase 5 - 2022
Project 11 | In Progress | Red | 2020-06-01 00:00:00 | 2021-02-01 00:00:00
Project 12 | Closed |  |  | 2020-12-01 00:00:00
Project 13 | In Progress |  | 2020-12-01 00:00:00 | 2020-10-31 00:00:00
Project 14 | Closed |  | 2020-09-01 00:00:00 | 2020-12-01 00:00:00
Project 15 | In Progress | Amber | 2020-11-01 00:00:00 | 2020-12-10 00:00:00
Project 16 | In Progress |  | 01/112020 | 2021-03-01 00:00:00
Project 17 | Closed |  | 2020-07-01 00:00:00 | 2020-09-21 00:00:00
Project 18 | Closed | Amber | 2019-06-01 00:00:00 | 2020-12-01 00:00:00
Project 19 | Closed | Amber | 2020-10-01 00:00:00 | 2020-12-01 00:00:00
Project 20 |  | Amber | 2020-03-01 00:00:00 | 2021-02-01 00:00:00
Project 21
Project 22 | Pending |  | 2021-04-01 00:00:00 | 2022-04-01 00:00:00
Project 23 | Pending |  | 2020-06-01 00:00:00 | 2021-02-01 00:00:00
Project 24 | Pending |  | 2020-04-01 00:00:00 | 2022-01-01 00:00:00
Project 25 | Pending |  | tbc
Project 26 | Closed |  | 2020-07-01 00:00:00 | 2020-12-01 00:00:00
Project 27 | Closed |  | 2020-04-01 00:00:00 | 2022-04-01 00:00:00
Project 28 | In Progress | Amber | 2020-04-01 00:00:00 | 2021-04-01 00:00:00
Project 29 | Pending
Project 30 | In Progress
Project 31 | Closed |  | 2020-11-01 00:00:00 | 2021-01-01 00:00:00
Project 32 | In Progress |  | 2020-11-01 00:00:00 | 2021-01-01 00:00:00
Project 33 | On Hold |  | 2020-01-31 00:00:00 | TBC
Project 34 | In Progress |  | 2020-07-01 00:00:00 | 2021-05-01 00:00:00
Project 35 | Pending |  | 2021-01-01 00:00:00 | 2022-05-01 00:00:00
Project 36 | Pending |  | 2020-04-01 00:00:00 | 2021-01-01 00:00:00
Project 37 | Pending |  | 2020-04-01 00:00:00 | 2020-10-01 00:00:00
Project 38 |  |  | 2020-04-01 00:00:00 | 2021-03-01 00:00:00
Project 39 |  |  | 2020-02-01 00:00:00 | 2021-06-01 00:00:00
Project 40 | On Hold |  | 2020-02-01 00:00:00 | 2021-06-01 00:00:00
Project 41 | Pending |  | 2015-01-01 00:00:00 | TBC
Project 42 | On Hold |  | TBC | TBC
Project 43 | On Hold |  | TBC | TBC
Project 44 | In Progress |  | 2020-07-01 00:00:00 | TBC
Project 45 | On Hold |  | TBC | TBC
Project 46 | In Progress |  | 2020-09-01 00:00:00 | 2021-05-01 00:00:00
Project 47 | On Hold |  | 2020-07-01 00:00:00 | 2021-07-01 00:00:00
Project 48 | Closed |  | 2020-09-01 00:00:00 | 2021-01-15 00:00:00
Project 49
Project 50 | Closed |  |  |  | 2020-12-24 00:00:00
Project 51
Project 52 | Pending
Project 53 | In Progress |  | 2020-11-01 00:00:00 | 2021-03-01 00:00:00
Project 54
Project 55 | In Progress
Project 56 | In Progress |  | 2020-09-01 00:00:00 | 2022-04-01 00:00:00
Project 57 | On Hold
Project 58
Project 59 | On Hold
Project 60 | Closed
Project 61
Project 62 | In Progress |  |  | 2021-03-01 00:00:00
Project 63
Project 64
Project 65 | In Progress | Green | 2020-12-01 00:00:00 | 2021-05-01 00:00:00
Project 66 | Pending |  | TBD | TBD
Project 67 | Pending |  | TBD | TBD
Project 68 | In Progress | Amber | 2020-10-01 00:00:00 | 2021-04-01 00:00:00
Project 69 | In Progress | Amber | 2020-05-01 00:00:00 | 2021-05-01 00:00:00
Project 70 | In Progress | Green | 2020-10-01 00:00:00 | 2021-05-01 00:00:00
Project 71 | Pending |  | 2021-04-01 00:00:00
Project 72 | In Progress | Green | 2021-01-25 00:00:00 | 2021-05-01 00:00:00
Project 73 | In Progress | Green | 2020-11-01 00:00:00 | TBD
Project 74 | In Progress | Green | 2020-10-01 00:00:00 | 2021-03-01 00:00:00
Project 75 | In Progress | Green | 2021-01-04 00:00:00 | 2021-08-01 00:00:00
Project 76 | Pending |  | TBD | TBD
Project 77 | In Progress | Green | 2020-10-01 00:00:00 | 2021-04-01 00:00:00
Project 78 | In Progress | Amber | 2020-10-01 00:00:00 | TBD
Project 79 | Closed | Green | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-11-01 00:00:00
Project 80 | In Progress | Green | 2020-10-01 00:00:00 | 2021-04-01 00:00:00
Project 81 | Pending |  | 2020-10-01 00:00:00 | continuous improvement
Project 82 | In Progress | Amber | 2020-10-01 00:00:00 | 2021-04-01 00:00:00
Project 83 | In Progress | Green | 2020-10-01 00:00:00 | continuous improvement
Project 84 | In Progress | Green | 2020-11-01 00:00:00 | 2021-03-01 00:00:00
Project 85 | In Progress | Green | 2020-10-30 00:00:00 | 2021-03-01 00:00:00
Project 86 | In Progress | Amber | 2020-11-01 00:00:00 | 2021-04-01 00:00:00
Project 87 | In Progress | Amber | 2020-11-01 00:00:00 | 2021-04-01 00:00:00
Project 88 | On Hold |  | 2020-11-01 00:00:00 | 2021-04-01 00:00:00
Project 89 | In Progress | Green | 2020-12-01 00:00:00 | 2021-05-01 00:00:00
Project 90 | On Hold |  | 2020-12-01 00:00:00 | 2021-05-01 00:00:00
Project 91 | In Progress | Green | 2020-10-01 00:00:00 | 2021-03-01 00:00:00
Project 92 | In Progress | Green | 2021-01-18 00:00:00 | 2021-11-01 00:00:00
Project 93 | Pending
Project 94 | Pending
Project 95 | Pending |  | 2021-08-01 00:00:00 | 2021-10-01 00:00:00
Project 96 | In Progress | Green | 2020-10-01 00:00:00 | 2021-03-01 00:00:00
Project 97 | In Progress | Green
Project 98 | In Progress | Green
Project 99 | Pending
Project 100 | Pending
Project 101 | Pending
Project 102 | Pending
Project 103 | Pending
Project 104 | Pending
Project 105 | Pending
Project 106 | Pending
Project 107 | Pending
Project 108 | Pending |  |  | 2021/2022