{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Basic Details","Dashboard","Summary","Risk Register","Risk Action Log","Closed Risks","Data Validation"],"not_rendered":{"charts":8,"images":6,"macros":1,"external_links":0,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Basic Details","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,0,5,1]]}
[]
[]
[]
[]
[]
["Risk Register"]
["Division:"]
[]
[]
["Risk Register Owner:"]
["Month:"]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Dashboard","index":1,"n_rows":62,"n_cols":30,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,15,4,21],[5,15,11,15],[11,16,11,21],[33,15,34,21],[35,15,41,15],[41,16,41,21]]}
[]
[]
[]
[null,"Open",{"$f":"COUNTIF(Summary!$J$3:$J$49884,Dashboard!B4)","v":0},null,{"$f":"COUNTA(Summary!C:C)-1+COUNTA('Closed Risks'!A:A)-1","v":0},null,null,null,null,null,"Not Due",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4919,Dashboard!K4)","v":0},null,null,null,"Number of Initial Risks in Each Category"]
[null,"Monitor",{"$f":"COUNTIF(Summary!$J$3:$J$49884,Dashboard!B5)","v":0},null,{"$f":"IF(C7<>E4,\"Error\",CONCATENATE(\"Risk Status - \",E4,\" Risks\"))","v":"Risk Status - 0 Risks"},null,null,null,null,null,"Overdue",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4919,Dashboard!K5)","v":0}]
[null,"Closed",{"$f":"COUNTIF(Summary!$J$3:$J$49884,Dashboard!B6)+COUNTIF('Closed Risks'!$P$2:$P$49983,Dashboard!B6)","v":0},null,null,null,null,null,null,null,"Complete",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4919,Dashboard!K6)","v":0},null,null,null,"Likelihood",5,{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,R$11,'Risk Register'!#REF!,$Q6))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,S$11,'Risk Register'!#REF!,$Q6))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,T$11,'Risk Register'!#REF!,$Q6))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,U$11,'Risk Register'!#REF!,$Q6))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,V$11,'Risk Register'!#REF!,$Q6))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"SUM(C4:C6)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(L4:L6)","v":0},null,null,null,null,4,{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,R$11,'Risk Register'!#REF!,$Q7))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,S$11,'Risk Register'!#REF!,$Q7))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,T$11,'Risk Register'!#REF!,$Q7))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,U$11,'Risk Register'!#REF!,$Q7))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,V$11,'Risk Register'!#REF!,$Q7))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,R$11,'Risk Register'!#REF!,$Q8))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,S$11,'Risk Register'!#REF!,$Q8))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,T$11,'Risk Register'!#REF!,$Q8))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,U$11,'Risk Register'!#REF!,$Q8))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,V$11,'Risk Register'!#REF!,$Q8))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,R$11,'Risk Register'!#REF!,$Q9))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,S$11,'Risk Register'!#REF!,$Q9))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,T$11,'Risk Register'!#REF!,$Q9))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,U$11,'Risk Register'!#REF!,$Q9))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,V$11,'Risk Register'!#REF!,$Q9))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,R$11,'Risk Register'!#REF!,$Q10))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,S$11,'Risk Register'!#REF!,$Q10))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,T$11,'Risk Register'!#REF!,$Q10))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,U$11,'Risk Register'!#REF!,$Q10))","v":{"$error":"#REF!"}},{"$f":"SUM(COUNTIFS('Risk Register'!#REF!,{\"Open\",\"Monitor\"},'Risk Register'!#REF!,V$11,'Risk Register'!#REF!,$Q10))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impact "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R6:V10)","v":{"$error":"#REF!"}},"Open Risks"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&I19,Summary!$H$3:$H$49884,\"<\"&J19)","v":0},0,6,"Low",{"$f":"COUNTIFS(Summary!$I$3:$I$49884,\">\"&M19,Summary!$I$3:$I$49884,\"<\"&N19)","v":0},0,6]
["Low",{"$f":"COUNTIFS('Risk Register'!$J$3:$J$4897,\">\"&C20,'Risk Register'!$J$3:$J$4897,\"<\"&D20)","v":0},0,6,null,null,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&I20,Summary!$H$3:$H$49884,\"<\"&J20)","v":0},5,13,"Medium",{"$f":"COUNTIFS(Summary!$I$3:$I$49884,\">\"&M20,Summary!$I$3:$I$49884,\"<\"&N20)","v":0},5,13]
["Medium",{"$f":"COUNTIFS('Risk Register'!$J$3:$J$4897,\">\"&C21,'Risk Register'!$J$3:$J$4897,\"<\"&D21)","v":0},5,13,null,null,"High - 25",{"$f":"COUNTIF(Summary!$H$3:$H$49884,I21)","v":0},25,26,"High - 25",{"$f":"COUNTIF(Summary!$I$3:$I$49884,I21)","v":0},25,26]
["High",{"$f":"COUNTIFS('Risk Register'!$J$3:$J$4897,\">\"&C22,'Risk Register'!$J$3:$J$4897,\"<\"&D22)","v":0},12,26,null,null,"High - 20",{"$f":"COUNTIF(Summary!$H$3:$H$49884,I22)","v":0},20,null,"High - 20",{"$f":"COUNTIF(Summary!$I$3:$I$49884,I22)","v":0},20]
[null,{"$f":"SUM(B20:B22)","v":0},null,null,null,null,"High - 16",{"$f":"COUNTIF(Summary!$H$3:$H$49884,I23)","v":0},16,null,"High - 16",{"$f":"COUNTIF(Summary!$I$3:$I$49884,I23)","v":0},16]
[null,null,null,null,null,null,"High - 15",{"$f":"COUNTIF(Summary!$H$3:$H$49884,I24)","v":0},15,null,"High - 15",{"$f":"COUNTIF(Summary!$I$3:$I$49884,I24)","v":0},15]
[null,{"$f":"CONCATENATE(\"Inherent Risk Rating - \",B23, \" Risks\")","v":"Inherent Risk Rating - 0 Risks"},null,null,null,null,null,{"$f":"SUM(H19:H24)","v":0},null,null,null,{"$f":"SUM(L19:L24)","v":0}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Residual Risk Rating - \",H25, \" Risks\")","v":"Residual Risk Rating - 0 Risks"},null,null,null,null,null,{"$f":"CONCATENATE(\"Target Risk Rating - \",L25, \" Risks\")","v":"Target Risk Rating - 0 Risks"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Current Risks in Each Category",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS('Risk Action Log'!$N$3:$N$4,\">\"&AC34,'Risk Action Log'!$N$3:$N$4,\"<\"&AD34)","v":0},0,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS('Risk Action Log'!$N$3:$N$4,\">\"&AC35,'Risk Action Log'!$N$3:$N$4,\"<\"&AD35)","v":0},5,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Likelihood",5,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,R$41,'Risk Action Log'!$M$4:$M$4,$Q36))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,S$41,'Risk Action Log'!$M$4:$M$4,$Q36))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,T$41,'Risk Action Log'!$M$4:$M$4,$Q36))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,U$41,'Risk Action Log'!$M$4:$M$4,$Q36))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,V$41,'Risk Action Log'!$M$4:$M$4,$Q36))","v":0},null,null,null,null,null,{"$f":"COUNTIFS('Risk Action Log'!$N$3:$N$4,\">\"&AC36,'Risk Action Log'!$N$3:$N$4,\"<\"&AD36)","v":0},12,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,R$41,'Risk Action Log'!$M$4:$M$4,$Q37))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,S$41,'Risk Action Log'!$M$4:$M$4,$Q37))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,T$41,'Risk Action Log'!$M$4:$M$4,$Q37))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,U$41,'Risk Action Log'!$M$4:$M$4,$Q37))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,V$41,'Risk Action Log'!$M$4:$M$4,$Q37))","v":0},null,null,null,null,"Low",{"$f":"SUM(AB34:AB36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,R$41,'Risk Action Log'!$M$4:$M$4,$Q38))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,S$41,'Risk Action Log'!$M$4:$M$4,$Q38))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,T$41,'Risk Action Log'!$M$4:$M$4,$Q38))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,U$41,'Risk Action Log'!$M$4:$M$4,$Q38))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,V$41,'Risk Action Log'!$M$4:$M$4,$Q38))","v":0},null,null,null,null,"Medium"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,R$41,'Risk Action Log'!$M$4:$M$4,$Q39))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,S$41,'Risk Action Log'!$M$4:$M$4,$Q39))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,T$41,'Risk Action Log'!$M$4:$M$4,$Q39))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,U$41,'Risk Action Log'!$M$4:$M$4,$Q39))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,V$41,'Risk Action Log'!$M$4:$M$4,$Q39))","v":0},null,null,null,null,"High",{"$f":"CONCATENATE(\"Target Risk Rating - \",AB37, \" Risks\")","v":"Target Risk Rating - 0 Risks"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,R$41,'Risk Action Log'!$M$4:$M$4,$Q40))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,S$41,'Risk Action Log'!$M$4:$M$4,$Q40))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,T$41,'Risk Action Log'!$M$4:$M$4,$Q40))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,U$41,'Risk Action Log'!$M$4:$M$4,$Q40))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$4:$E$4,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$4:$L$4,V$41,'Risk Action Log'!$M$4:$M$4,$Q40))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impact "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R36:V40)","v":0},"Open Risks"]
[null,null,null,{"$f":"'Data Validation'!F1","v":"Harm to a Person "},{"$f":"'Data Validation'!F2","v":"Service user experience"},{"$f":"'Data Validation'!F3","v":"Business/Service disruption/Security "},{"$f":"'Data Validation'!F4","v":"Loss of trust/confidence or morale (Public/Staff)"},{"$f":"'Data Validation'!F5","v":"Organisational objectives or outcomes"},{"$f":"'Data Validation'!F6","v":"Compliance (Legislative, Policy, Regulatory including data)"},{"$f":"'Data Validation'!F7","v":"Financial (including performance to budget, claims, etc.) "},{"$f":"'Data Validation'!F8","v":"Environmental/Infrastructure/Equipment"},{"$f":"'Data Validation'!F9","v":"Strategic Programme/Project (Objectives/timeframes) – HSE Executive Use Only"},{"$f":"IF('Data Validation'!F10=0,\"\",'Data Validation'!F10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Organisational objectives or outcomes","Compliance","Financial","Environmental/Infrastructure/Equipment"]
[0,6,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!D$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!E$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!F$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!G$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!H$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!I$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!J$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!K$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!L$44)","v":0},{"$f":"IF(M44=\"\",\"\",COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$N$3:$N$49884,Dashboard!M$44))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$M$3:$M$49884,Dashboard!Z$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$M$3:$M$49884,Dashboard!AA$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$M$3:$M$49884,Dashboard!AB$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$M$3:$M$49884,Dashboard!AC$44)","v":0}]
[5,13,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!D$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!E$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!F$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!G$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!H$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!I$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!J$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!K$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!L$44)","v":0},{"$f":"IF(M45=\"\",\"\",COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$N$3:$N$49884,Dashboard!M$44))","v":""}]
[12,26,"High",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!D$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!E$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!F$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!G$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!H$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!I$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!J$44)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!K$44)","v":0},{"$f":"IF(L46=\"\",\"\",COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!L$44))","v":0},{"$f":"IF(M46=\"\",\"\",COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$N$3:$N$49884,Dashboard!M$44))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A45,Summary!$H$3:$H$49884,\"<\"&$B45,Summary!$M$3:$M$49884,Dashboard!I$47)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A46,Summary!$H$3:$H$49884,\"<\"&$B46,Summary!$M$3:$M$49884,Dashboard!I$47)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$A47,Summary!$H$3:$H$49884,\"<\"&$B47,Summary!$M$3:$M$49884,Dashboard!I$47)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Number"]
[null,"Strategic",{"$f":"COUNTIF(Summary!$M$3:$M$49884,Dashboard!B59)","v":0},null,null,null,null,null,"Strategic","Operational"]
[null,"Operational",{"$f":"COUNTIF(Summary!$M$3:$M$49884,Dashboard!B60)","v":0},null,null,0,6,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F60,Summary!$H$3:$H$49884,\"<\"&$G60,Summary!$M$3:$M$49884,Dashboard!I$59)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F60,Summary!$H$3:$H$49884,\"<\"&$G60,Summary!$M$3:$M$49884,Dashboard!J$59)","v":0}]
[null,null,null,null,null,5,13,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F61,Summary!$H$3:$H$49884,\"<\"&$G61,Summary!$M$3:$M$49884,Dashboard!I$59)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F61,Summary!$H$3:$H$49884,\"<\"&$G61,Summary!$M$3:$M$49884,Dashboard!J$59)","v":0}]
[null,null,null,null,null,12,26,"High",{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F62,Summary!$H$3:$H$49884,\"<\"&$G62,Summary!$M$3:$M$49884,Dashboard!I$59)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49884,\">\"&$F62,Summary!$H$3:$H$49884,\"<\"&$G62,Summary!$M$3:$M$49884,Dashboard!J$59)","v":0}]

{"sheet":"Summary","index":2,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Unique ID","Risk Owner","Risk Co-ordinator","Risk Description","Date Entered","Inherent Risk","Date Reviewed","Residual Risk","Target Risk","Risk Status","Risk Rating Change"]

{"sheet":"Risk Register","index":3,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,2,15]]}
[{"$f":"GETFIRSTLETTERS('Basic Details'!B7)&GETFIRSTLETTERS('Basic Details'!B8)&GETFIRSTLETTERS('Basic Details'!B9)","v":""}]
[]
[]
["Unique ID","Risk Owner","Risk Co-ordinator","Risk Criteria","Primary Risk Category","Risk Description","Date Entered","Likelihood","Impact","Inherent Risk Rating","Existing Controls","Likelihood","Impact","Residual Risk Rating","Review Date","Risk Status"]

{"sheet":"Risk Action Log","index":4,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,2,13]]}
[{"$f":"IF('Basic Details'!B7=\"\",\"\",CONCATENATE(\"Risk Register - \",'Basic Details'!B7,\", \",IF('Basic Details'!B8=\"\",\"\",'Basic Details'!B8&\", \"),IF('Basic Details'!B9=\"\",\"\",'Basic Details'!B9&\", \"),'Basic Details'!B10))","v":""}]
[]
[]
["Unique ID","Risk Owner","Risk Co-ordinator","Risk Description","Risk Status","Actions Required","Action Owner","Action Due Date","Action Completion Date","Action Status","Action Update","Likelihood","Impact","Target Risk "]

{"sheet":"Closed Risks","index":5,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Unique ID","Risk Owner","Risk Co-ordinator","Risk Type","Risk Criteria","Risk Description","Date Entered","Likelihood","Impact","Inherent Risk Rating","Existing Controls","Likelihood","Impact","Residual Risk Rating","Review Date","Risk Status","Actions Required","Action Owner","Action Due Date","Action Completion Date","Action Status","Action Update","Likelihood","Impact","Target Risk"]

{"sheet":"Data Validation","index":6,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Owner 1","Co-ordinator 1",2,"Monitor",null,"Harm to a Person ","Action Owner 1","Strategic"]
["Owner 2","Co-ordinator 2",3,"Open",null,"Service user experience","Action Owner 2","Operational"]
[null,null,4,"Closed",null,"Business/Service disruption/Security "]
[null,null,5,null,null,"Loss of trust/confidence or morale (Public/Staff)"]
[null,null,null,null,null,"Organisational objectives or outcomes"]
[null,null,null,null,null,"Compliance (Legislative, Policy, Regulatory including data)"]
[null,null,null,null,null,"Financial (including performance to budget, claims, etc.) "]
[null,null,null,null,null,"Environmental/Infrastructure/Equipment"]
[null,null,null,null,null,"Strategic Programme/Project (Objectives/timeframes) – HSE Executive Use Only"]