Spreadsheet: 91931d1291633187-counting-using-nested-if-and-index-section-master-business-development
Sheet: Calcs

 | Risk List |  | Risk Scores |  |  | Risk Rank |  |  |  | KPI REF | [NAME] |  |  |  |  | [NAME] | DT1
 | Operational |  | / | 0 |  | Very Low(VL) | VL |  |  | KPI1 | insert descriptions |  |  |  |  | Deliver continuous improvement in customer satisfaction | DT2
 | Financial |  | VL/VL | 1 |  | Low(L) | L |  |  | [NAME] | insert descriptions |  |  |  |  | Make services equitable, sustainable and accessible | DT3
 | Objectives |  | L/VL | 2 |  | Significant (S) | S |  |  | KPI3 | insert descriptions |  |  |  |  | Improve service quality | DT4
 | Reputation |  | VL/L | 3 |  | High(H) | H |  |  | KPI4 | insert descriptions |  |  |  |  | Improve perceptions of safety and security | DT5
 |  |  | S/VL | 4 |  | Very High(VH) | VH |  |  | KPI5 | insert descriptions |  |  |  |  | Plan for the long term development of Metro | MR1
 |  |  | L/L | 5 |  | - |  |  |  | KPI6 | insert descriptions |  |  |  |  | Use assets more effectively | MR2
 |  |  | H/VL | 6 |  |  |  |  |  | KPI7 | insert descriptions |  |  |  |  | Deliver the asset renewal plan | MR3
 |  |  | VH/VL | 7 |  | Risk Status |  |  |  | KPI8 | insert descriptions |  |  |  |  | Roll out smart ticketing | ST1
 | [NAME] |  | S/L | 8 |  | Live |  |  |  | KPI9 | insert descriptions |  |  |  |  | Implement ticketing and gating | ST2
 | - |  | H/L | 9 |  | Revised |  |  |  | KPI10 | insert descriptions |  |  |  |  | Improve ticketing options | ST3
 | Red | R | VL/S | 10 |  | Closed |  |  |  | KPI11 | insert descriptions |  |  |  |  | Become and employer of choice | EO1
 | Amber | A | L/S | 11 |  |  |  |  |  | KPI12 | insert descriptions |  |  |  |  | Deliver business efficiencies | EO2
 | Green | G | VL/H | 12 |  |  |  |  |  | KPI13 | insert descriptions |  |  |  |  | Make procurement smarter | EO3
 |  |  | VH/L | 13 |  | RAGY |  |  |  | KPI14 | insert descriptions |  |  |  |  | Become a more effective organisation | [NAME]
 |  |  | S/S | 14 |  | RAG1Q | QTR1 |  |  | KPI15 | insert descriptions |  |  |  |  | Focus on health and safety | EO5
 |  |  | H/S | 15 |  | RAG2Q | QTR2 |  |  | KPI16 | insert descriptions
 |  |  | L/H | 16 |  | RAG3Q | QTR3 |  |  | KPI17 | insert descriptions
 | Choice |  | VH/S | 17 |  | RAG4Q | QTR4 |  |  | KPI18 | insert descriptions
 | Yes |  | VL/VH | 18 |  |  |  |  |  | KPI19 | insert descriptions
 | No |  | S/H | 19 |  |  |  |  |  | KPI20 | insert descriptions
 |  |  | L/VH | 20 |  |  |  |  |  | KPI21 | insert descriptions
 |  |  | S/VH | 21 |  |  |  |  |  | KPI22 | insert descriptions
 |  |  | H/H | 22 |  |  |  |  |  | KPI23 | insert descriptions
 |  |  | VH/H | 23 |  |  |  |  |  | KPI24 | insert descriptions
 |  |  | H/VH | 24 |  |  |  |  |  | KPI25 | insert descriptions
 |  |  | VH/VH | 25 |  |  |  |  |  | KPI26 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI27 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI28 | insert descriptions
 | PI Type |  |  |  |  | Period |  |  |  | KPI29 | insert descriptions
 | O | Operational |  |  |  | Qtr1 |  |  |  | KPI30 | insert descriptions
 | CH | Corporate Health |  |  |  | Qtr2 |  |  |  | KPI31 | insert descriptions
 | CF | Customer Focused |  |  |  | Qtr3 |  |  |  | KPI32 | insert descriptions
 | FL | [NAME] Reported |  |  |  | Qtr4 |  |  |  | KPI33 | insert descriptions
 | - | Spare |  |  |  |  |  |  |  | KPI34 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI35 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI36 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI37 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI38 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI39 | insert descriptions
 |  |  |  |  |  |  |  |  |  | KPI40 | insert descriptions