Spreadsheet: 825261d1681217966-help-with-formula-to-return-top-5-from-raid-log-filter-function-20230411_dynamic-raid_v2
Sheet: Master RAID Log

ID | Risk/Issue Description | Date Raised | RAID Log - Directorate | RAID Log - Programme | Current Likelihood | Current Impact | Current Proximity | Current Score | Risk Score Movement | Current RAG | Risk Status | CRR Status | Last Review Date | Next Review Date | Update To | Helper - Risk / Issue | Helper - Directorate | Helper - Programmes | Helper - Current RAG Rating
10852 | Issue for Directorate A, Programme A2 | 2021-03-10 00:00:00 | RL - Directorate A | LR - Programme A2 | 5 - Very Likely | 5 - Very High | 0-3 Months | 25 | '-5 | Red | Approved | Open for Updates | 2023-03-17 00:00:00 | 2023-01-17 00:00:00 |  | Issue
10954 | Issue for Directorate A, Programme A2 | 2021-03-10 00:00:00 | RL - Directorate A | LR - Programme A2 | 5 - Very Likely | 4 - High | 0-3 Months | 20 | No Movement | Red | Approved | Open for Updates | 2023-03-20 00:00:00 | 2023-01-17 00:00:00 |  | Issue
11412 | Issue for Directorate D, Programme D9 | 2019-04-01 00:00:00 | RL - Directorate D | LR - Programme D9 | 5 - Very Likely | 4 - High | 0-3 Months | 20 | '+ 10 | Red | Submitted (awaiting approval) | Open for Updates | 2023-02-10 00:00:00 | 2023-02-09 00:00:00 |  | Issue
10741 | Risk for Directorate B, Programme B1 | 2021-01-14 00:00:00 | RL - Directorate B | LR - Programme B1 | 4 - Likely | 4 - High | 6-9 Months | 16 | No Movement | Amber | Approved | Open for Updates | 2023-02-27 00:00:00 | 2022-12-31 00:00:00
10851 | Risk for Directorate C, Programme C1 | 2020-09-02 00:00:00 | RL - Directorate C | LR - Programme C1 | 4 - Likely | 4 - High | 0-3 Months | 16 | '-4 | Amber | Approved | Open for Updates | 2023-03-16 00:00:00 | 2023-03-14 00:00:00
10956 | Issue for Directorate C, Programme C8 | 2021-02-10 00:00:00 | RL - Directorate C | LR - Programme C8 | 5 - Very Likely | 3 - Moderate | 0-3 Months | 15 | '-4 | Amber | Approved | Open for Updates | 2023-03-15 00:00:00 | 2023-04-10 00:00:00 |  | Issue
10959 | Risk for Directorate E, Programme E2 | 2021-03-10 00:00:00 | RL - Directorate E | LR - Programme E2 | 4 - Likely | 4 - High | 0-3 Months | 16 | No Movement | Amber | Approved | Open for Updates | 2023-03-15 00:00:00 | 2023-04-10 00:00:00
10939 | Risk for Directorate A, Programme A7 | 2019-09-30 00:00:00 | RL - Directorate A | LR - Programme A7 | 4 - Likely | 3 - Moderate | 0-3 Months | 12 | No Movement | Amber | Approved | Open for Updates | 2022-12-15 00:00:00 | 2023-01-13 00:00:00
10843 | Risk for Directorate B, Programme B2 | 2020-09-02 00:00:00 | RL - Directorate B | LR - Programme B2 | 3 - Possible | 3 - Moderate | 6-9 Months | 9 | No Movement | Yellow | Submitted (awaiting approval) | Open for Updates | 2023-03-14 00:00:00 | 2023-03-30 00:00:00
11408 | Risk for Directorate F, Programme F4 | 2020-04-01 00:00:00 | RL - Directorate F | LR - Programme F4 | 2 - Unlikely | 2 - Low | 12 Months + | 4 | '-4 | Green | Submitted (awaiting approval) | Open for Updates | 2023-02-10 00:00:00 | 2023-03-31 00:00:00
11682 | Risk for Directorate G, Programme G1 | 2020-06-09 00:00:00 | RL - Directorate G | LR - Programme G1 | 1 - Rare | 1 - Very Low | 9-12 Months | 1 | No Movement | Green | Submitted for Closure | Open for Updates | 2023-03-20 00:00:00 | 2023-05-31 00:00:00