{"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":7,"images":3,"macros":1,"external_links":0,"defined_names":16,"comments":0,"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":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,0,5,1]]}
[]
[]
[]
[]
[]
["Risk Register"]
["Division:"]
[]
[]
["Risk Register Owner:"]
["Month:"]

{"sheet":"Dashboard","index":1,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,15,4,21],[5,15,11,15],[11,16,11,21],[17,15,18,21],[19,15,25,15],[25,16,25,21]]}
[]
[]
[]
[null,"Open",{"$f":"COUNTIF(Summary!$I$3:$I$49996,Dashboard!B4)","v":0},null,{"$f":"COUNTA(Summary!C:C)-1+COUNTA('Closed Risks'!A:A)-1","v":0},null,null,null,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&K4,Summary!$H$3:$H$49996,\"<\"&L4)","v":0},0,6,null,null,null,"Number of Initial Risks in Each Category"]
[null,"Monitor",{"$f":"COUNTIF(Summary!$I$3:$I$49996,Dashboard!B5)","v":0},null,{"$f":"IF(C7<>E4,\"Error\",CONCATENATE(\"Risk Status - \",E4,\" Risks\"))","v":"Risk Status - 0 Risks"},null,null,null,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&K5,Summary!$H$3:$H$49996,\"<\"&L5)","v":0},5,13]
[null,"Closed",{"$f":"COUNTIF(Summary!$I$3:$I$49996,Dashboard!B6)+COUNTIF('Closed Risks'!$M$2:$M$50000,Dashboard!B6)","v":0},null,null,null,null,null,"High - 25",{"$f":"COUNTIF(Summary!$H$3:$H$49996,K6)","v":0},25,26,null,null,null,"Impact",5,{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,R$11,'Risk Register'!$J$5:$J$4933,$Q6))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,S$11,'Risk Register'!$J$5:$J$4933,$Q6))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,T$11,'Risk Register'!$J$5:$J$4933,$Q6))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,U$11,'Risk Register'!$J$5:$J$4933,$Q6))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,V$11,'Risk Register'!$J$5:$J$4933,$Q6))","v":0}]
[null,null,{"$f":"SUM(C4:C6)","v":0},null,null,null,null,null,"High - 20",{"$f":"COUNTIF(Summary!$H$3:$H$49996,K7)","v":0},20,null,null,null,null,null,4,{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,R$11,'Risk Register'!$J$5:$J$4933,$Q7))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,S$11,'Risk Register'!$J$5:$J$4933,$Q7))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,T$11,'Risk Register'!$J$5:$J$4933,$Q7))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,U$11,'Risk Register'!$J$5:$J$4933,$Q7))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,V$11,'Risk Register'!$J$5:$J$4933,$Q7))","v":0}]
[null,null,null,null,null,null,null,null,"High - 16",{"$f":"COUNTIF(Summary!$H$3:$H$49996,K8)","v":0},16,null,null,null,null,null,3,{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,R$11,'Risk Register'!$J$5:$J$4933,$Q8))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,S$11,'Risk Register'!$J$5:$J$4933,$Q8))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,T$11,'Risk Register'!$J$5:$J$4933,$Q8))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,U$11,'Risk Register'!$J$5:$J$4933,$Q8))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,V$11,'Risk Register'!$J$5:$J$4933,$Q8))","v":0}]
[null,null,null,null,null,null,null,null,"High - 15",{"$f":"COUNTIF(Summary!$H$3:$H$49996,K9)","v":0},15,null,null,null,null,null,2,{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,R$11,'Risk Register'!$J$5:$J$4933,$Q9))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,S$11,'Risk Register'!$J$5:$J$4933,$Q9))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,T$11,'Risk Register'!$J$5:$J$4933,$Q9))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,U$11,'Risk Register'!$J$5:$J$4933,$Q9))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,V$11,'Risk Register'!$J$5:$J$4933,$Q9))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J9)","v":0},null,null,null,null,null,null,1,{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,R$11,'Risk Register'!$J$5:$J$4933,$Q10))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,S$11,'Risk Register'!$J$5:$J$4933,$Q10))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,T$11,'Risk Register'!$J$5:$J$4933,$Q10))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,U$11,'Risk Register'!$J$5:$J$4933,$Q10))","v":0},{"$f":"SUM(COUNTIFS('Risk Register'!$M$5:$M$4933,{\"Open\",\"Monitor\"},'Risk Register'!$I$5:$I$4933,V$11,'Risk Register'!$J$5:$J$4933,$Q10))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Current Risk Rating - \",J10, \" Risks\")","v":"Current Risk Rating - 0 Risks"},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,"Likelihood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R6:V10)","v":0},"Open Risks"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS('Risk Register'!$K$3:$K$49893,\">\"&K18,'Risk Register'!$K$3:$K$49893,\"<\"&L18)","v":0},0,6,null,null,null,"Number of Current Risks in Each Category"]
[null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS('Risk Register'!$K$3:$K$49893,\">\"&K19,'Risk Register'!$K$3:$K$49893,\"<\"&L19)","v":0},5,13]
[null,"Not due",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4939,Dashboard!B20)","v":0},null,null,null,null,null,null,{"$f":"COUNTIFS('Risk Register'!$K$3:$K$49893,\">\"&K20,'Risk Register'!$K$3:$K$49893,\"<\"&L20)","v":0},12,26,null,null,null,"Impact",5,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,R$25,'Risk Action Log'!$M$5:$M$4939,$Q20))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,S$25,'Risk Action Log'!$M$5:$M$4939,$Q20))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,T$25,'Risk Action Log'!$M$5:$M$4939,$Q20))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,U$25,'Risk Action Log'!$M$5:$M$4939,$Q20))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,V$25,'Risk Action Log'!$M$5:$M$4939,$Q20))","v":0}]
[null,"Overdue",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4939,Dashboard!B21)","v":0},null,null,null,null,null,"Low",{"$f":"SUM(J18:J20)","v":0},null,null,null,null,null,null,4,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,R$25,'Risk Action Log'!$M$5:$M$4939,$Q21))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,S$25,'Risk Action Log'!$M$5:$M$4939,$Q21))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,T$25,'Risk Action Log'!$M$5:$M$4939,$Q21))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,U$25,'Risk Action Log'!$M$5:$M$4939,$Q21))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,V$25,'Risk Action Log'!$M$5:$M$4939,$Q21))","v":0}]
[null,"Complete",{"$f":"COUNTIF('Risk Action Log'!$J$4:$J$4939,Dashboard!B22)","v":0},null,null,null,null,null,"Medium",null,null,null,null,null,null,null,3,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,R$25,'Risk Action Log'!$M$5:$M$4939,$Q22))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,S$25,'Risk Action Log'!$M$5:$M$4939,$Q22))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,T$25,'Risk Action Log'!$M$5:$M$4939,$Q22))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,U$25,'Risk Action Log'!$M$5:$M$4939,$Q22))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,V$25,'Risk Action Log'!$M$5:$M$4939,$Q22))","v":0}]
[null,null,{"$f":"SUM(C20:C22)","v":0},null,null,null,null,null,"High",{"$f":"CONCATENATE(\"Initial Risk Rating - \",J21, \" Risks\")","v":"Initial Risk Rating - 0 Risks"},null,null,null,null,null,null,2,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,R$25,'Risk Action Log'!$M$5:$M$4939,$Q23))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,S$25,'Risk Action Log'!$M$5:$M$4939,$Q23))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,T$25,'Risk Action Log'!$M$5:$M$4939,$Q23))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,U$25,'Risk Action Log'!$M$5:$M$4939,$Q23))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,V$25,'Risk Action Log'!$M$5:$M$4939,$Q23))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,R$25,'Risk Action Log'!$M$5:$M$4939,$Q24))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,S$25,'Risk Action Log'!$M$5:$M$4939,$Q24))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,T$25,'Risk Action Log'!$M$5:$M$4939,$Q24))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,U$25,'Risk Action Log'!$M$5:$M$4939,$Q24))","v":0},{"$f":"SUM(COUNTIFS('Risk Action Log'!$E$5:$E$4939,{\"Open\",\"Monitor\"},'Risk Action Log'!$L$5:$L$4939,V$25,'Risk Action Log'!$M$5:$M$4939,$Q24))","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,"Likelihood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R20:V24)","v":0},"Open Risks"]
[null,null,null,"Harm to a person","Service user experience","Compliance with Standards","Objectives and projects","Business continuity","Adverse publicity/ Reputational","Financial Loss","Environment"]
[0,6,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!D$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!E$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!F$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!G$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!H$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!I$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!J$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!K$28)","v":0}]
[5,13,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!D$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!E$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!F$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!G$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!H$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!I$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!J$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!K$28)","v":0}]
[12,26,"High",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!D$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!E$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!F$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!G$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!H$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!I$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!J$28)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!K$28)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A29,Summary!$H$3:$H$49996,\"<\"&$B29,Summary!$L$3:$L$49996,Dashboard!I$31)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A30,Summary!$H$3:$H$49996,\"<\"&$B30,Summary!$L$3:$L$49996,Dashboard!I$31)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$A31,Summary!$H$3:$H$49996,\"<\"&$B31,Summary!$L$3:$L$49996,Dashboard!I$31)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Number"]
[null,"Strategic",{"$f":"COUNTIF(Summary!$K$3:$K$49996,Dashboard!B43)","v":0},null,null,null,null,null,null,null,null,null,"Strategic","Operational"]
[null,"Operational",{"$f":"COUNTIF(Summary!$K$3:$K$49996,Dashboard!B44)","v":0},null,null,null,null,null,null,0,6,"Low",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J44,Summary!$H$3:$H$49996,\"<\"&$K44,Summary!$K$3:$K$49996,Dashboard!M$43)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J44,Summary!$H$3:$H$49996,\"<\"&$K44,Summary!$K$3:$K$49996,Dashboard!N$43)","v":0}]
[null,null,null,null,null,null,null,null,null,5,13,"Medium",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J45,Summary!$H$3:$H$49996,\"<\"&$K45,Summary!$K$3:$K$49996,Dashboard!M$43)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J45,Summary!$H$3:$H$49996,\"<\"&$K45,Summary!$K$3:$K$49996,Dashboard!N$43)","v":0}]
[null,null,null,null,null,null,null,null,null,12,26,"High",{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J46,Summary!$H$3:$H$49996,\"<\"&$K46,Summary!$K$3:$K$49996,Dashboard!M$43)","v":0},{"$f":"COUNTIFS(Summary!$H$3:$H$49996,\">\"&$J46,Summary!$H$3:$H$49996,\"<\"&$K46,Summary!$K$3:$K$49996,Dashboard!N$43)","v":0}]

{"sheet":"Summary","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Unique ID","Risk Owner","Risk Co-ordinator","Risk Description","Date Entered","Initial Risk","Date Reviewed","Current 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,12]]}
[{"$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":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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","Existing Controls","Likelihood","Impact","Initial Risk","Review Date","Risk Status"]

{"sheet":"Risk Action Log","index":4,"n_rows":4,"n_cols":17,"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","Current Risk",null,null,{"$f":"TODAY()","v":"2018-03-08"}]

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

{"sheet":"Data Validation","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Owner 1","Co-ordinator 1",1,"Monitor",null,"Harm to a Person","Action Owner 1","Strategic"]
["Owner 2","Co-ordinator 2",2,"Open",null,"Service user experience","Action Owner 2","Operational"]
[null,null,3,"Closed",null,"Compliance with standards"]
[null,null,4,null,null,"Objectives and projects"]
[null,null,5,null,null,"Business continuity"]
[null,null,null,null,null,"Adverse Publicity/ Reputational"]
[null,null,null,null,null,"Financial Loss"]
[null,null,null,null,null,"Environment"]