{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Blank Template","Risk Summary Table","Scoring Matrix","Risk_1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Blank Template","index":0,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,8,2,10],[2,17,2,19],[0,3,0,5],[0,1,0,2]]}
[null,"Strategic Risk Area:"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place / in progress / due to start)"," Completion Due Date","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"G4*H4","v":0},null,null,null,null,null,null,"n",{"$f":"IF(T4<4,\"GREEN\",IF(AND(T4>3,T4<7),\"YELLOW\",IF(AND(T4>7,T4<10),\"AMBER\",IF(AND(T4>9,T4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"P4*Q4","v":0},"Up"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,null,"n",{"$f":"IF(T5<4,\"GREEN\",IF(AND(T5>3,T5<7),\"YELLOW\",IF(AND(T5>7,T5<10),\"AMBER\",IF(AND(T5>9,T5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"P5*Q5","v":0},"Down"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,null,"n",{"$f":"IF(T6<4,\"GREEN\",IF(AND(T6>3,T6<7),\"YELLOW\",IF(AND(T6>7,T6<10),\"AMBER\",IF(AND(T6>9,T6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]

{"sheet":"Risk Summary Table","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,5],[1,1,2,1],[1,0,2,0]]}
[]
[null,"Risk Areas","Count of Risks"]
[null,null,"Green","Yellow","Amber","Red"]
[{"$f":"ROW()-4","v":0},null,{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<4\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">0\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B4,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":0}]
[{"$f":"ROW()-4","v":1},{"$f":"LEFT(Risk_1!D1,31)","v":""},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<4\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">0\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<7\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">3\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<10\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">6\"),0)","v":0},{"$f":"IFERROR(COUNTIFS(INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\"<17\",INDIRECT(\"'\"&LEFT($B5,31)&\"'!$S$4:$S$27\"),\">9\"),0)","v":0}]
[]
[]
[{"$f":"COUNTA(RiskTable[[#All],[Column1]])","v":1},"Total",{"$f":"SUM(C5:C5)","v":0},{"$f":"SUM(D5:D5)","v":0},{"$f":"SUM(E5:E5)","v":0},{"$f":"SUM(F5:F5)","v":0}]

{"sheet":"Scoring Matrix","index":2,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,8,1],[3,3,3,6]]}
[]
[]
[]
[null,null,null,"Impact"]
[null,null,null,"Low (1)","Moderate (2)","High (3)","Critical (4)",null,null,null,null,null,null,null,null,null,null,"Avoid"]
[null,"Likelihood","Highly Likely (4)",4,8,12,16,null,null,null,null,null,null,null,null,null,null,"Treat"]
[null,null,"Likely (3)",3,6,9,12,null,null,null,null,null,null,null,null,null,null,"Tolerate"]
[null,null,"Feasible (2)",2,4,6,8,null,null,null,null,null,null,null,null,null,null,"Transfer"]
[null,null,"Unlikely (1)",1,2,3,4]

{"sheet":"Risk_1","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,3,0,5],[2,8,2,10],[2,17,2,19]]}
[null,"Strategic Risk Area:"]
[]
[null,"No.","Risk  (what could happen)","Risk Owner","Risk Manager","Consequences (how would this affect the University)","Likelihood","Impact","Unmitigated Score\n(gross)",null,null,"Response","Mitigations (what is being/has been done to control the risk) ","Status (in place / in progress / due to start)"," Completion Due Date","Likelihood","Impact","Mitigated Score\n(net)",null,null,"Risk Movement"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K4<4,\"GREEN\",IF(AND(K4>3,K4<7),\"YELLOW\",IF(AND(K4>7,K4<10),\"AMBER\",IF(AND(K4>9,K4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"G4*H4","v":0},null,null,null,null,null,null,"n",{"$f":"IF(T4<4,\"GREEN\",IF(AND(T4>3,T4<7),\"YELLOW\",IF(AND(T4>7,T4<10),\"AMBER\",IF(AND(T4>9,T4<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"P4*Q4","v":0},"Up"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K5<4,\"GREEN\",IF(AND(K5>3,K5<7),\"YELLOW\",IF(AND(K5>7,K5<10),\"AMBER\",IF(AND(K5>9,K5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,null,"n",{"$f":"IF(T5<4,\"GREEN\",IF(AND(T5>3,T5<7),\"YELLOW\",IF(AND(T5>7,T5<10),\"AMBER\",IF(AND(T5>9,T5<17),\"RED\",\"ERROR\"))))","v":"GREEN"},{"$f":"P5*Q5","v":0},"Down"]
[null,null,null,null,null,null,null,null,"n",{"$f":"IF(K6<4,\"GREEN\",IF(AND(K6>3,K6<7),\"YELLOW\",IF(AND(K6>7,K6<10),\"AMBER\",IF(AND(K6>9,K6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,null,null,null,null,null,null,"n",{"$f":"IF(T6<4,\"GREEN\",IF(AND(T6>3,T6<7),\"YELLOW\",IF(AND(T6>7,T6<10),\"AMBER\",IF(AND(T6>9,T6<17),\"RED\",\"ERROR\"))))","v":"GREEN"},0,"No Change"]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]
[null,null,null,null,null,null,null,null,"n","GREEN",0,null,null,null,null,null,null,"n","GREEN",0]