{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Risk Register","Risk Stats","RiskMatrix","Definition Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"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":"Risk Register","index":0,"n_rows":18,"n_cols":23,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["#"," Risk Category","Identified Risk","Date Identified","Likelihood (Initial)","Consequence (Initial)","Score","Control/Mitigant","Likelihood (New)","Consequence (New)","New Score","Owner","Last Review","Initial Risk Light","Final Risk Light","Traffic Light","Scheduled","Initial Risk Score","Final Risk Score","Risk Score","Risk Level","Present","Priority"]
[1,"Strategic","ISO 9001","2016-11-01",3,5,{"$f":"IF(R2<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R2-1,TableRisk[TO],1),0)+1,0),\"\")","v":"High"},"Desin and certify all branches by 30/6/17.  Managed through quality objectives",5,2,{"$f":"IF(S2<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S2-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Moderate"},"Ray McMurrich","2016-12-01",{"$f":"IF(V2,IF(R2>='Definition Tables'!$I$26,\"RED\",IF(R2>='Definition Tables'!$I$25,\"AMBER\",IF(R2>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":"RED"},{"$f":"IF(V2,IF(S2=\"\",\"\",IF(S2>='Definition Tables'!$I$26,\"RED\",IF(S2>='Definition Tables'!$I$25,\"AMBER\",IF(S2>='Definition Tables'!$I$24,\"GREEN\",IF(S2>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":"AMBER"},{"$f":"IF(V2,IF(T2>='Definition Tables'!$I$26,\"RED\",IF(T2>='Definition Tables'!$I$25,\"AMBER\",IF(T2>='Definition Tables'!$I$24,\"GREEN\",IF(T2>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":"AMBER"},{"$f":"IF(M2<>\"\",EOMONTH(M2,ReviewFreq),\"\")","v":"2017-06-30"},{"$f":"IF(AND(F2<>\"\",E2<>\"\"),F2*E2,\"\")","v":15},{"$f":"IF(AND(J2<>\"\",I2<>\"\"),J2*I2,\"\")","v":10},{"$f":"IF(S2=\"\",R2,S2)","v":10},{"$f":"IF(K2=\"\",G2,K2)","v":"Moderate"},{"$f":"AND(B2<>\"\",T2<>\"\")","v":true}]
[2,"Compliance","Compliance to relevant Statutory and Regulatory requirements for chairs","2016-11-01",2,1,{"$f":"IF(R3<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R3-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Low"},"No regulations or codes concerning chairs",1,1,{"$f":"IF(S3<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S3-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Low"},"Ray McMurrich","2016-12-01",{"$f":"IF(V3,IF(R3>='Definition Tables'!$I$26,\"RED\",IF(R3>='Definition Tables'!$I$25,\"AMBER\",IF(R3>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":"GREEN"},{"$f":"IF(V3,IF(S3=\"\",\"\",IF(S3>='Definition Tables'!$I$26,\"RED\",IF(S3>='Definition Tables'!$I$25,\"AMBER\",IF(S3>='Definition Tables'!$I$24,\"GREEN\",IF(S3>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":"GREEN"},{"$f":"IF(V3,IF(T3>='Definition Tables'!$I$26,\"RED\",IF(T3>='Definition Tables'!$I$25,\"AMBER\",IF(T3>='Definition Tables'!$I$24,\"GREEN\",IF(T3>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":"GREEN"},{"$f":"IF(M3<>\"\",EOMONTH(M3,6),\"\")","v":"2017-06-30"},{"$f":"IF(AND(F3<>\"\",E3<>\"\"),F3*E3,\"\")","v":2},{"$f":"IF(AND(J3<>\"\",I3<>\"\"),J3*I3,\"\")","v":1},{"$f":"IF(S3=\"\",R3,S3)","v":1},{"$f":"IF(K3=\"\",G3,K3)","v":"Low"},true]
[3,"Operational","Interested parties","2016-11-01",5,2,{"$f":"IF(R4<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R4-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Moderate"},"Ensure interested parties register is reviewed at each management review and impement objectives and operational as needed.",5,1,{"$f":"IF(S4<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S4-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Low"},"Ray McMurrich","2016-12-01",{"$f":"IF(V4,IF(R4>='Definition Tables'!$I$26,\"RED\",IF(R4>='Definition Tables'!$I$25,\"AMBER\",IF(R4>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":"AMBER"},{"$f":"IF(V4,IF(S4=\"\",\"\",IF(S4>='Definition Tables'!$I$26,\"RED\",IF(S4>='Definition Tables'!$I$25,\"AMBER\",IF(S4>='Definition Tables'!$I$24,\"GREEN\",IF(S4>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":"GREEN"},{"$f":"IF(V4,IF(T4>='Definition Tables'!$I$26,\"RED\",IF(T4>='Definition Tables'!$I$25,\"AMBER\",IF(T4>='Definition Tables'!$I$24,\"GREEN\",IF(T4>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":"GREEN"},"2017-06-30",10,5,5,"Low",true]
[4,"Compliance","Compliance to relevant Statutory and Regulatory requirements for WHS","2016-10-01",5,4,{"$f":"IF(R5<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R5-1,TableRisk[TO],1),0)+1,0),\"\")","v":"High"},"WHS program",3,3,{"$f":"IF(S5<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S5-1,TableRisk[TO],1),0)+1,0),\"\")","v":"Moderate"},"Ray McMurrich","2016-12-01",{"$f":"IF(V5,IF(R5>='Definition Tables'!$I$26,\"RED\",IF(R5>='Definition Tables'!$I$25,\"AMBER\",IF(R5>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":"RED"},{"$f":"IF(V5,IF(S5=\"\",\"\",IF(S5>='Definition Tables'!$I$26,\"RED\",IF(S5>='Definition Tables'!$I$25,\"AMBER\",IF(S5>='Definition Tables'!$I$24,\"GREEN\",IF(S5>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":"AMBER"},{"$f":"IF(V5,IF(T5>='Definition Tables'!$I$26,\"RED\",IF(T5>='Definition Tables'!$I$25,\"AMBER\",IF(T5>='Definition Tables'!$I$24,\"GREEN\",IF(T5>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":"AMBER"},"2017-06-30",20,9,9,"Moderate",true]
[null,null,null,null,null,null,{"$f":"IF(R6<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R6-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S6<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S6-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V6,IF(R6>='Definition Tables'!$I$26,\"RED\",IF(R6>='Definition Tables'!$I$25,\"AMBER\",IF(R6>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V6,IF(S6=\"\",\"\",IF(S6>='Definition Tables'!$I$26,\"RED\",IF(S6>='Definition Tables'!$I$25,\"AMBER\",IF(S6>='Definition Tables'!$I$24,\"GREEN\",IF(S6>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V6,IF(T6>='Definition Tables'!$I$26,\"RED\",IF(T6>='Definition Tables'!$I$25,\"AMBER\",IF(T6>='Definition Tables'!$I$24,\"GREEN\",IF(T6>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R7<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R7-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S7<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S7-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V7,IF(R7>='Definition Tables'!$I$26,\"RED\",IF(R7>='Definition Tables'!$I$25,\"AMBER\",IF(R7>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V7,IF(S7=\"\",\"\",IF(S7>='Definition Tables'!$I$26,\"RED\",IF(S7>='Definition Tables'!$I$25,\"AMBER\",IF(S7>='Definition Tables'!$I$24,\"GREEN\",IF(S7>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V7,IF(T7>='Definition Tables'!$I$26,\"RED\",IF(T7>='Definition Tables'!$I$25,\"AMBER\",IF(T7>='Definition Tables'!$I$24,\"GREEN\",IF(T7>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R8<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R8-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S8<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S8-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V8,IF(R8>='Definition Tables'!$I$26,\"RED\",IF(R8>='Definition Tables'!$I$25,\"AMBER\",IF(R8>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V8,IF(S8=\"\",\"\",IF(S8>='Definition Tables'!$I$26,\"RED\",IF(S8>='Definition Tables'!$I$25,\"AMBER\",IF(S8>='Definition Tables'!$I$24,\"GREEN\",IF(S8>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V8,IF(T8>='Definition Tables'!$I$26,\"RED\",IF(T8>='Definition Tables'!$I$25,\"AMBER\",IF(T8>='Definition Tables'!$I$24,\"GREEN\",IF(T8>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R9<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R9-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S9<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S9-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V9,IF(R9>='Definition Tables'!$I$26,\"RED\",IF(R9>='Definition Tables'!$I$25,\"AMBER\",IF(R9>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V9,IF(S9=\"\",\"\",IF(S9>='Definition Tables'!$I$26,\"RED\",IF(S9>='Definition Tables'!$I$25,\"AMBER\",IF(S9>='Definition Tables'!$I$24,\"GREEN\",IF(S9>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V9,IF(T9>='Definition Tables'!$I$26,\"RED\",IF(T9>='Definition Tables'!$I$25,\"AMBER\",IF(T9>='Definition Tables'!$I$24,\"GREEN\",IF(T9>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R10<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R10-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S10<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S10-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V10,IF(R10>='Definition Tables'!$I$26,\"RED\",IF(R10>='Definition Tables'!$I$25,\"AMBER\",IF(R10>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V10,IF(S10=\"\",\"\",IF(S10>='Definition Tables'!$I$26,\"RED\",IF(S10>='Definition Tables'!$I$25,\"AMBER\",IF(S10>='Definition Tables'!$I$24,\"GREEN\",IF(S10>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V10,IF(T10>='Definition Tables'!$I$26,\"RED\",IF(T10>='Definition Tables'!$I$25,\"AMBER\",IF(T10>='Definition Tables'!$I$24,\"GREEN\",IF(T10>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},{"$f":"IF(M10<>\"\",EOMONTH(M10,6),\"\")","v":""},{"$f":"IF(AND(F10<>\"\",E10<>\"\"),F10*E10,\"\")","v":""},{"$f":"IF(AND(J10<>\"\",I10<>\"\"),J10*I10,\"\")","v":""},{"$f":"IF(S10=\"\",R10,S10)","v":""},{"$f":"IF(K10=\"\",G10,K10)","v":""},{"$f":"AND(B10<>\"\",T10<>\"\")","v":false}]
[null,null,null,null,null,null,{"$f":"IF(R11<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R11-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S11<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S11-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V11,IF(R11>='Definition Tables'!$I$26,\"RED\",IF(R11>='Definition Tables'!$I$25,\"AMBER\",IF(R11>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V11,IF(S11=\"\",\"\",IF(S11>='Definition Tables'!$I$26,\"RED\",IF(S11>='Definition Tables'!$I$25,\"AMBER\",IF(S11>='Definition Tables'!$I$24,\"GREEN\",IF(S11>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V11,IF(T11>='Definition Tables'!$I$26,\"RED\",IF(T11>='Definition Tables'!$I$25,\"AMBER\",IF(T11>='Definition Tables'!$I$24,\"GREEN\",IF(T11>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R12<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R12-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S12<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S12-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V12,IF(R12>='Definition Tables'!$I$26,\"RED\",IF(R12>='Definition Tables'!$I$25,\"AMBER\",IF(R12>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V12,IF(S12=\"\",\"\",IF(S12>='Definition Tables'!$I$26,\"RED\",IF(S12>='Definition Tables'!$I$25,\"AMBER\",IF(S12>='Definition Tables'!$I$24,\"GREEN\",IF(S12>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V12,IF(T12>='Definition Tables'!$I$26,\"RED\",IF(T12>='Definition Tables'!$I$25,\"AMBER\",IF(T12>='Definition Tables'!$I$24,\"GREEN\",IF(T12>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R13<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R13-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S13<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S13-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V13,IF(R13>='Definition Tables'!$I$26,\"RED\",IF(R13>='Definition Tables'!$I$25,\"AMBER\",IF(R13>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V13,IF(S13=\"\",\"\",IF(S13>='Definition Tables'!$I$26,\"RED\",IF(S13>='Definition Tables'!$I$25,\"AMBER\",IF(S13>='Definition Tables'!$I$24,\"GREEN\",IF(S13>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V13,IF(T13>='Definition Tables'!$I$26,\"RED\",IF(T13>='Definition Tables'!$I$25,\"AMBER\",IF(T13>='Definition Tables'!$I$24,\"GREEN\",IF(T13>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R14<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R14-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S14<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S14-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V14,IF(R14>='Definition Tables'!$I$26,\"RED\",IF(R14>='Definition Tables'!$I$25,\"AMBER\",IF(R14>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V14,IF(S14=\"\",\"\",IF(S14>='Definition Tables'!$I$26,\"RED\",IF(S14>='Definition Tables'!$I$25,\"AMBER\",IF(S14>='Definition Tables'!$I$24,\"GREEN\",IF(S14>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V14,IF(T14>='Definition Tables'!$I$26,\"RED\",IF(T14>='Definition Tables'!$I$25,\"AMBER\",IF(T14>='Definition Tables'!$I$24,\"GREEN\",IF(T14>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R15<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R15-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S15<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S15-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V15,IF(R15>='Definition Tables'!$I$26,\"RED\",IF(R15>='Definition Tables'!$I$25,\"AMBER\",IF(R15>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V15,IF(S15=\"\",\"\",IF(S15>='Definition Tables'!$I$26,\"RED\",IF(S15>='Definition Tables'!$I$25,\"AMBER\",IF(S15>='Definition Tables'!$I$24,\"GREEN\",IF(S15>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V15,IF(T15>='Definition Tables'!$I$26,\"RED\",IF(T15>='Definition Tables'!$I$25,\"AMBER\",IF(T15>='Definition Tables'!$I$24,\"GREEN\",IF(T15>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R16<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R16-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S16<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S16-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V16,IF(R16>='Definition Tables'!$I$26,\"RED\",IF(R16>='Definition Tables'!$I$25,\"AMBER\",IF(R16>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V16,IF(S16=\"\",\"\",IF(S16>='Definition Tables'!$I$26,\"RED\",IF(S16>='Definition Tables'!$I$25,\"AMBER\",IF(S16>='Definition Tables'!$I$24,\"GREEN\",IF(S16>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V16,IF(T16>='Definition Tables'!$I$26,\"RED\",IF(T16>='Definition Tables'!$I$25,\"AMBER\",IF(T16>='Definition Tables'!$I$24,\"GREEN\",IF(T16>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
[null,null,null,null,null,null,{"$f":"IF(R17<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R17-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,{"$f":"IF(S17<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(S17-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,{"$f":"IF(V17,IF(R17>='Definition Tables'!$I$26,\"RED\",IF(R17>='Definition Tables'!$I$25,\"AMBER\",IF(R17>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V17,IF(S17=\"\",\"\",IF(S17>='Definition Tables'!$I$26,\"RED\",IF(S17>='Definition Tables'!$I$25,\"AMBER\",IF(S17>='Definition Tables'!$I$24,\"GREEN\",IF(S17>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V17,IF(T17>='Definition Tables'!$I$26,\"RED\",IF(T17>='Definition Tables'!$I$25,\"AMBER\",IF(T17>='Definition Tables'!$I$24,\"GREEN\",IF(T17>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"","","","","",false]
["End",null,null,null,null,null,{"$f":"IF(R18<>\"\",OFFSET(TableRisk[[#Headers],[DESCRIPTION]],IFERROR(MATCH(R18-1,TableRisk[TO],1),0)+1,0),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(V18,IF(R18>='Definition Tables'!$I$26,\"RED\",IF(R18>='Definition Tables'!$I$25,\"AMBER\",IF(R18>='Definition Tables'!$I$24,\"GREEN\",\"\"))),\"\")","v":""},{"$f":"IF(V18,IF(S18=\"\",\"\",IF(S18>='Definition Tables'!$I$26,\"RED\",IF(S18>='Definition Tables'!$I$25,\"AMBER\",IF(S18>='Definition Tables'!$I$24,\"GREEN\",IF(S18>='Definition Tables'!$I$23,\"NONE\",\"\"))))),\"\")","v":""},{"$f":"IF(V18,IF(T18>='Definition Tables'!$I$26,\"RED\",IF(T18>='Definition Tables'!$I$25,\"AMBER\",IF(T18>='Definition Tables'!$I$24,\"GREEN\",IF(T18>='Definition Tables'!$I$23,\"NONE\",\"\")))),\"\")","v":""},"",null,"",null,"",false]

{"sheet":"Risk Stats","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[10,1,10,4]]}
[{"$f":"MID(CELL(\"filename\",$B$1),FIND(\"]\",CELL(\"filename\",$B$1))+1,99)","v":"Risk Stats"}]
[]
["Traffic Lights"]
[{"$f":"\"At \"&TEXT(TODAY(),\"d-mmm-yyyy\")","v":"At 7-Dec-2016"}]
["Green",{"$f":"COUNTIF(RiskLightFinal,$A5)","v":2}]
["Amber",{"$f":"COUNTIF(RiskLightFinal,$A6)","v":2}]
["Red",{"$f":"COUNTIF(RiskLightFinal,$A7)","v":0}]
["Total",{"$f":"SUM(B5:B7)","v":4}]
[]
[]
[null,"Final Risk Assessment"]
["Initial Risk","Red","Amber","Green","None","Total"]
["Red",{"$f":"COUNTIFS(RiskLightInit,$A13,RiskLightFinal,B$12)","v":0},2,0,0,{"$f":"SUM(B13:E13)","v":2}]
["Amber",0,0,1,0,{"$f":"SUM(B14:E14)","v":1}]
["Green",0,0,1,0,1]
["Total",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13:C15)","v":2},2,0,4]

{"sheet":"RiskMatrix","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,3,1,7],[3,1,7,1]]}
[null,null,null,2,3,4,5,6]
[null,null,null,"Risk Likelihood"]
[null,null,null,{"$f":"OFFSET(TableProb[[#Headers],[Likelihood]],D$1,2)","v":"1 - Very Low"},{"$f":"OFFSET(TableProb[[#Headers],[Likelihood]],E$1,2)","v":"2 - Low"},{"$f":"OFFSET(TableProb[[#Headers],[Likelihood]],F$1,2)","v":"3 - Moderate"},{"$f":"OFFSET(TableProb[[#Headers],[Likelihood]],G$1,2)","v":"4 - High"},{"$f":"OFFSET(TableProb[[#Headers],[Likelihood]],H$1,2)","v":"5 - Very High"}]
[5,"Risk Consequences",{"$f":"OFFSET(TableConseq[[#Headers],[Consequence]],$A4,2)","v":"5 - Very High"},{"$f":"LEFT($C4,2)*LEFT(D$3,2)","v":5},{"$f":"LEFT($C4,2)*LEFT(E$3,2)","v":10},{"$f":"LEFT($C4,2)*LEFT(F$3,2)","v":15},{"$f":"LEFT($C4,2)*LEFT(G$3,2)","v":20},{"$f":"LEFT($C4,2)*LEFT(H$3,2)","v":25}]
[4,null,{"$f":"OFFSET(TableConseq[[#Headers],[Consequence]],$A5,2)","v":"4 - High"},{"$f":"LEFT($C5,2)*LEFT(D$3,2)","v":4},8,12,16,20]
[3,null,{"$f":"OFFSET(TableConseq[[#Headers],[Consequence]],$A6,2)","v":"3 - Moderate"},3,6,9,12,15]
[2,null,{"$f":"OFFSET(TableConseq[[#Headers],[Consequence]],$A7,2)","v":"2 - Low"},2,4,6,8,10]
[1,null,{"$f":"OFFSET(TableConseq[[#Headers],[Consequence]],$A8,2)","v":"1 - Very Low"},1,2,3,4,5]
[]
[]
[]
[null,null,null,{"$f":"OFFSET(TableRisk[[#Headers],[Risk-Desc]],D$1,0)","v":"1 to 5"},{"$f":"OFFSET(TableRisk[[#Headers],[Risk-Desc]],E$1,0)","v":"6 to 11"},{"$f":"OFFSET(TableRisk[[#Headers],[Risk-Desc]],F$1,0)","v":"12 to 25"}]
[null,null,"Assessment & Action",{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],D$1,0)","v":"Low (None)"},{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],E$1,0)","v":"Moderate (Possibly)"},{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],F$1,0)","v":"High (Definitely)"}]

{"sheet":"Definition Tables","index":3,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["RIO Categories \n(add to as required)",null,"RISK Categories\n(add to as required)",null,null,"Risk Likelihod",null,null,null,null,"Risk Review Frequency (Default)",6]
["SOURCE",null,"Business Risk Category","Decription",null,"Likelihood","Rating","Like-Desc"]
["Document Management",null,"Strategic","Decisions Concerning Your Business’ Objectives",null,"None",0,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"0 - None"}]
["External Audit",null,"Compliance","The Need To Comply With Laws, Regulations, Standards And Codes Of Practice",null,"Very Low",1,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"1 - Very Low"}]
["Internal Audit",null,"Financial","Financial Transactions, Systems And Structure Of Your Business",null,"Low",2,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"2 - Low"}]
["Management Review",null,"Operational","Your Operational And Administrative Procedures",null,"Moderate",3,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"3 - Moderate"}]
["Observations",null,"Environmental","External Events That The Business Has Little Control Over Such Unfavourable Weather Or Economic Co",null,"High",4,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"4 - High"}]
["Preventive Action",null,"Reputational","The Character Or Goodwill Of The Business",null,"Very High",5,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"5 - Very High"}]
["Risk"]
["Improvement"]
["Opportunity"]
[null,null,null,null,null,"Risk Consequence"]
[null,null,null,null,null,"Consequence","Rating","Cons-Desc"]
[null,null,null,null,null,"Very Low",1,{"$f":"TableConseq[[#This Row],[Rating]]&\" - \"&TableConseq[[#This Row],[Consequence]]","v":"1 - Very Low"}]
[null,null,null,null,null,"Low",2,{"$f":"TableConseq[[#This Row],[Rating]]&\" - \"&TableConseq[[#This Row],[Consequence]]","v":"2 - Low"}]
[null,null,null,null,null,"Moderate",3,{"$f":"TableConseq[[#This Row],[Rating]]&\" - \"&TableConseq[[#This Row],[Consequence]]","v":"3 - Moderate"}]
[null,null,null,null,null,"High",4,{"$f":"TableConseq[[#This Row],[Rating]]&\" - \"&TableConseq[[#This Row],[Consequence]]","v":"4 - High"}]
[null,null,null,null,null,"Very High",5,{"$f":"TableConseq[[#This Row],[Rating]]&\" - \"&TableConseq[[#This Row],[Consequence]]","v":"5 - Very High"}]
[]
[]
[null,null,null,null,null,"Risk Score"]
[null,null,null,null,null,"DESCRIPTION","Escalation","Risk-Desc","FROM","TO","RIO Level"]
[null,null,null,null,null,"None","None",{"$f":"CONCATENATE(TableRisk[[#This Row],[FROM]],\" to \",TableRisk[[#This Row],[TO]])","v":"0 to 0"},0,0,{"$f":"TableRisk[[#This Row],[DESCRIPTION]]&\" (\"&TableRisk[[#This Row],[Escalation]]&\")\"","v":"None (None)"}]
[null,null,null,null,null,"Low","None",{"$f":"CONCATENATE(TableRisk[[#This Row],[FROM]],\" to \",TableRisk[[#This Row],[TO]])","v":"1 to 5"},1,5,{"$f":"TableRisk[[#This Row],[DESCRIPTION]]&\" (\"&TableRisk[[#This Row],[Escalation]]&\")\"","v":"Low (None)"}]
[null,null,null,null,null,"Moderate","Possibly",{"$f":"CONCATENATE(TableRisk[[#This Row],[FROM]],\" to \",TableRisk[[#This Row],[TO]])","v":"6 to 11"},{"$f":"OFFSET(TableRisk[[#This Row],[FROM]],-1,1)+1","v":6},11,{"$f":"TableRisk[[#This Row],[DESCRIPTION]]&\" (\"&TableRisk[[#This Row],[Escalation]]&\")\"","v":"Moderate (Possibly)"}]
[null,null,null,null,null,"High","Definitely",{"$f":"CONCATENATE(TableRisk[[#This Row],[FROM]],\" to \",TableRisk[[#This Row],[TO]])","v":"12 to 25"},{"$f":"OFFSET(TableRisk[[#This Row],[FROM]],-1,1)+1","v":12},{"$f":"MAX(TableProb[Rating])*MAX(TableConseq[Rating])","v":25},{"$f":"TableRisk[[#This Row],[DESCRIPTION]]&\" (\"&TableRisk[[#This Row],[Escalation]]&\")\"","v":"High (Definitely)"}]