Spreadsheet: 784829d1655970565-conditional-format-cell-colour-based-upon-another-cells-value-conditional_format_range
Sheet: Milestone RAG

ProjectName | Overall Project RAG | Phase Status | Project ID | Project Manager | Portfolio Manager | Phase | ParentTaskName | TaskName | Date Project Report last updatd | Date Project last Modified | MilestoneType | Taskbllastmonth | ReportingTaskBL0Finish | Today | Net Days Baseline at current gate | Net Days Baseline changed this month | TaskFinishDate | [NAME] | Complete
Orion Live | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 2 |  | 2022-03-29 12:00:00 |  |  |  | 2022-07-28 12:00:00 |  | No
Orion Live | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 4 |  | 2022-04-05 12:00:00 |  |  |  | 2022-08-04 12:00:00 |  | No
Orion Live | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 3 |  | 2022-03-29 12:00:00 |  |  |  | 2022-07-28 12:00:00 |  | No
ORION Development | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 2 |  | 2022-03-11 17:00:00 |  |  |  | 2022-08-03 17:00:00 |  | No
ORION Development | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 4 |  | 2022-03-25 17:00:00 |  |  |  | 2022-08-17 17:00:00 |  | No
ORION Development | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 3 |  | 2022-03-11 17:00:00 |  |  |  | 2022-08-03 17:00:00 |  | No
HR - ServiceNow | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 2 |  | 2022-04-20 08:00:00 |  |  |  | 2022-05-11 08:00:00 |  | No
HR - ServiceNow | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 3 |  | 2022-04-20 12:00:00 |  |  |  | 2022-05-11 08:00:00 |  | No
Electronic Safety Cases (eSc) | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 2 |  | 2022-03-25 17:00:00 |  |  |  | 2022-06-13 17:00:00 |  | No
Electronic Safety Cases (eSc) | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 4 |  | 2022-05-03 17:00:00 |  |  |  | 2022-06-27 12:00:00 |  | No
Condition Monitoring Prototype System | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 3 |  | 2022-03-02 17:00:00 |  |  |  | 2022-10-12 17:00:00 |  | No
Condition Monitoring | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 5 |  | 2022-05-03 17:00:00 |  |  |  | 2022-12-08 17:00:00 |  | No
[NAME] | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 6 |  | 2022-03-17 08:00:00 |  |  |  | 2022-06-09 17:00:00 |  | No
[NAME] | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 5 |  | 2022-02-28 17:00:00 |  |  |  | 2022-06-08 17:00:00 |  | No
IS Project Plan | Red | Go | 1 | George | [NAME] | Design | IS [NAME]Digitisation) | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 6 |  | 2022-07-06 17:00:00 |  | 29 |  | 2022-06-30 08:00:00 |  | No
Digital Radio Implementation | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Key Milestone |  | 2021-12-10 17:00:00 |  | 20 |  | 2022-06-08 17:00:00 |  | No
Digital Radio Implementation | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Key Milestone |  | 2021-11-24 17:00:00 |  |  |  | 2022-05-30 17:00:00 |  | No
Digital Radio Implementation | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Key Milestone |  | 2021-12-01 17:00:00 |  |  |  | 2022-06-06 17:00:00 |  | No
NRM | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 7 |  | 2022-06-16 17:00:00 |  |  |  | 2022-07-29 17:00:00 |  | No
NRM | Red | Go | 1 | George | [NAME] | Design | Milestones | Task1 | 2022-06-23 00:00:00 | 2022-06-23 00:00:00 | Tag 8 |  | 2022-07-11 17:00:00 |  |  |  | 2022-08-23 17:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Project Startup Gate complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Design Gate complete - SG3 |  |  | Tag 3 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Build Gate complete - SG4 |  |  | Tag 4 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Go No Go "Into Live Service" Gate complete - SG6 |  |  | Tag 6 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Transition Gate complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
Knowledge Assessment Tool V1 |  |  |  |  |  |  | Milestones | Project Complete - SG7 |  |  | Tag 7 |  |  |  |  |  | 2020-11-16 00:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG2: Definition complete |  |  | Tag 3 |  |  |  |  |  | 2021-02-15 00:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG1: [NAME] complete |  |  | Tag 2 |  |  |  |  |  | 2021-02-15 00:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG3: Design complete |  |  | Tag 4 |  |  |  |  |  | 2021-02-15 00:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG4: Delivery complete |  |  | Tag 5 |  |  |  |  |  | 2021-02-15 00:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG0.5: Qualify Demand complete |  |  | Tag 1 |  | 2021-05-18 17:00:00 |  |  |  | 2021-05-18 17:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG0: Assess Idea complete |  |  | Tag 0 |  | 2021-03-30 17:00:00 |  |  |  | 2021-03-30 17:00:00 |  | No
RedNet installation at Derby |  |  |  |  |  |  | Milestones | SG5: Transition (Handover & Closure) complete |  |  | Tag 6 |  |  |  |  |  | 2021-02-15 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | [NAME] |  |  | Tag 1 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | Project Startup Complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | Architecture Design Complete - SG1.5 |  |  | Tag 2 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | Design Complete - SG3 |  |  | Tag 3 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | Build Complete - SG4 |  |  | Tag 4 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
Nimbus Content Management System on RedNet |  |  |  |  |  |  | Milestones | Testing Complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2020-10-13 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Project Startup Gate complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Design Gate complete - SG3 |  |  | Tag 3 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Build Gate complete - SG4 |  |  | Tag 4 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Go No Go "Into Live Service" Gate complete - SG6 |  |  | Tag 6 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Transition Gate complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
V6X Fingerprinting Capability - IS support for [NAME] for Proposal, Evaluation, Vendor Selection and Implementation |  |  |  |  |  |  | Milestones | Project Complete - SG7 |  |  | Tag 7 |  |  |  |  |  | 2020-12-22 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Project Startup Gate complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Design Gate complete - SG3 |  |  | Tag 3 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Build Gate complete - SG4 |  |  | Tag 4 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Go No Go "Into Live Service" Gate complete - SG6 |  |  | Tag 6 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Transition Gate complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
OS Scientific Environment |  |  |  |  |  |  | Milestones | Project Complete - SG7 |  |  | Tag 7 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
[NAME] |  |  |  |  |  |  | Milestones | Go No Go/ Start of Warranty - SG4 |  |  | Tag 4 |  |  |  |  |  | 2021-07-30 15:00:00 |  | No
[NAME] |  |  |  |  |  |  | Milestones | Project Complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2021-09-29 09:37:54 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Project Startup Gate complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Design Gate complete - SG3 |  |  | Tag 3 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Build Gate complete - SG4 |  |  | Tag 4 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Go No Go "Into Live Service" Gate complete - SG6 |  |  | Tag 6 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Transition Gate complete - SG5 |  |  | Tag 5 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
Cross Network Licence Server |  |  |  |  |  |  | Milestones | Project Complete - SG7 |  |  | Tag 7 |  |  |  |  |  | 2021-01-18 00:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Definition Phase Complete Stage Gate 2 |  |  | Tag 3 |  |  |  |  |  | 2022-07-07 08:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | [NAME] Phase Complete - Stage Gate 1 |  |  | Tag 2 |  |  |  |  |  | 2022-06-20 17:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Design Phase Complete - Stage Gate 3 |  |  | Tag 4 |  |  |  |  |  | 2022-07-28 17:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Delivery Phase Complete - Stage Gate 4 |  |  | Tag 5 |  |  |  |  |  | 2022-11-03 17:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Transition (Handover & Closure) Phase Complete - Stage Gate 5 |  |  | Tag 8 |  |  |  |  |  | 2022-12-01 17:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Qualify Demand Board Complete |  |  | Tag 1 |  |  |  |  |  | 2022-05-30 08:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Idea Review Board Complete |  |  | Tag 0 |  |  |  |  |  | 2022-02-01 17:00:00 |  | Yes
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Go Live |  |  | Tag 6 |  |  |  |  |  | 2022-11-03 17:00:00 |  | No
CDE Tender and Selection |  |  |  |  |  |  | Milestones | Warranty Complete |  |  | Tag 7 |  |  |  |  |  | 2022-12-01 17:00:00 |  | No
IS Integrated Milestone_Plan |  |  |  |  |  |  | Ccure Upgrade | Build Complete - SG4 |  |  | Tag 0 |  | 2019-09-12 17:00:00 |  |  |  | 2019-10-10 08:00:00 |  | Yes
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Herme Project Complete - SG5 |  |  | Tag 6 |  |  |  |  |  | 2021-04-15 08:00:00 |  | No
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Herme Installation Completed |  |  | Tag 4 |  |  |  |  |  | 2021-03-26 08:00:00 |  | No
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | [NAME] |  |  | Tag 2 |  |  |  |  |  | 2020-11-26 08:00:00 |  | Yes
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Herme Purchase Orders Raised |  |  | Tag 1 |  |  |  |  |  | 2020-09-24 08:00:00 |  | Yes
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Project Startup Complete - SG0 |  |  | Tag 0 |  |  |  |  |  | 2020-09-10 08:00:00 |  | Yes
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Herme Go No Go |  |  | Tag 3 |  |  |  |  |  | 2021-02-03 08:00:00 |  | Yes
IS Integrated Milestone_Plan |  |  |  |  |  |  | HERMES | Herme Transition Complete - SG4 |  |  | Tag 5 |  |  |  |  |  | 2021-04-08 08:00:00 |  | No