{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["RIO Register","RIO Stats","RiskMatrix","Definition Tables","HELP!!!!"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":28,"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":"RIO Register","index":0,"n_rows":212,"n_cols":19,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
["No.","Source","Details","Raised","Originator","Reviews, Controls, Root cause, Actions","Risk Likelihood","Risk Consequence","Risk Assesment (Escalation)","Target","Who","Review of effectiveness","Completed","Approved","Changes","Traffic Light","Scheduled","Risk Score","Present"]
[1,"Example","IQA Purchasing Vehicles","2016-02-26","John Mason","Amend procedure and re-issue.",2,4,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R2,TableRisk[FROM],1),0),\"\")","v":"Moderate (Consider)"},"2016-05-01","John Mason",null,null,null,2,{"$f":"IF(OR(AND(D2<>\"\",M2=\"\",J2<TODAY()),AND(D2<>\"\",J2=\"\")),\"BLUE\",IF(O2+1>4,\"Red\",CHOOSE(O2+1,\"\",\"Green\",\"Amber\",\"Red\")))","v":"BLUE"},{"$f":"IF(J2=\"\",\"\",EOMONTH(J2,0))","v":"2016-05-31"},{"$f":"IF(AND(G2<>\"\",H2<>\"\"),G2*H2,\"\")","v":8},{"$f":"B2<>\"\"","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J34=\"\",\"\",EOMONTH(J34,0))","v":""},{"$f":"IF(AND(G34<>\"\",H34<>\"\"),G34*H34,\"\")","v":""},{"$f":"B34<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(D66<>\"\",M66=\"\",J66<TODAY()),AND(D66<>\"\",J66=\"\")),\"BLUE\",IF(O66+1>4,\"Red\",CHOOSE(O66+1,\"\",\"Green\",\"Amber\",\"Red\")))","v":""},{"$f":"IF(J66=\"\",\"\",EOMONTH(J66,0))","v":""},{"$f":"IF(AND(G66<>\"\",H66<>\"\"),G66*H66,\"\")","v":""},{"$f":"B66<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J98=\"\",\"\",EOMONTH(J98,0))","v":""},{"$f":"IF(AND(G98<>\"\",H98<>\"\"),G98*H98,\"\")","v":""},{"$f":"B98<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(D130<>\"\",M130=\"\",J130<TODAY()),AND(D130<>\"\",J130=\"\")),\"BLUE\",IF(O130+1>4,\"Red\",CHOOSE(O130+1,\"\",\"Green\",\"Amber\",\"Red\")))","v":""},{"$f":"IF(J130=\"\",\"\",EOMONTH(J130,0))","v":""},{"$f":"IF(AND(G130<>\"\",H130<>\"\"),G130*H130,\"\")","v":""},{"$f":"B130<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J162=\"\",\"\",EOMONTH(J162,0))","v":""},{"$f":"IF(AND(G162<>\"\",H162<>\"\"),G162*H162,\"\")","v":""},{"$f":"B162<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AND(D194<>\"\",M194=\"\",J194<TODAY()),AND(D194<>\"\",J194=\"\")),\"BLUE\",IF(O194+1>4,\"Red\",CHOOSE(O194+1,\"\",\"Green\",\"Amber\",\"Red\")))","v":""},"","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(J195=\"\",\"\",EOMONTH(J195,0))","v":""},{"$f":"IF(AND(G195<>\"\",H195<>\"\"),G195*H195,\"\")","v":""},{"$f":"B195<>\"\"","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R200,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R201,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R202,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R203,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R204,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R205,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R206,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R207,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R208,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R209,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R210,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(TableRisk[[#Headers],[RIO Level]],MATCH($R211,TableRisk[FROM],1),0),\"\")","v":""},null,null,null,null,null,null,"","","",false]
["End"]

{"sheet":"RIO Stats","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,11,23,12],[24,11,24,12],[13,11,13,12]]}
[null,"Next Mgt Review","2016-11-30",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"From",{"$f":"DATE(YEAR(C3)-1,MONTH(C3),DAY(C3)+1)","v":"2015-12-01"}]
[null,"To",{"$f":"C1","v":"2016-11-30"}]
[null,null,"TOTAL",{"$f":"IF(OFFSET(RIOCatSt,D$1,0)<>0,UPPER(OFFSET(RIOCatSt,D$1,0)),\"\")","v":"DOCUMENT MANAGEMENT"},"EXTERNAL AUDIT","INTERNAL AUDIT","MANAGEMENT REVIEW","OBSERVATIONS","PREVENTIVE ACTION","RISK","IMPROVEMENT","OPPORTUNITY","EXAMPLE","","","","",""]
[null,"Open",{"$f":"COUNTIFS(TheRaised,\"<\"&$C$2,TheCompleted,\">\"&$C$2,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&$C$2,TheCompleted,\"\",ThePresent,TRUE)","v":0},{"$f":"IF(D$4<>\"\",COUNTIFS(TheRaised,\"<\"&$C$2,TheCompleted,\">\"&$C$2,ThePresent,TRUE,TheSource,\"=\"&D$4)+COUNTIFS(TheRaised,\"<\"&$C$2,TheCompleted,\"\",ThePresent,TRUE,TheSource,\"=\"&D$4),\"\")","v":0},0,0,0,0,0,0,0,0,0,"","","","",""]
[null,"Raised",{"$f":"COUNTIFS(TheRaised,\">=\"&$C$2,TheRaised,\"<=\"&$C$3)","v":1},{"$f":"IF(D$4<>\"\",COUNTIFS(TheRaised,\">=\"&$C$2,TheRaised,\"<=\"&$C$3,TheSource,\"=\"&D$4),\"\")","v":0},0,0,0,0,0,0,0,0,1,"","","","",""]
[null,"Closed",{"$f":"COUNTIFS(TheCompleted,\">=\"&$C$2,TheCompleted,\"<=\"&$C$3)","v":0},{"$f":"IF(D$4<>\"\",COUNTIFS(TheCompleted,\">=\"&$C$2,TheCompleted,\"<=\"&$C$3,TheSource,\"=\"&D$4),\"\")","v":0},0,0,0,0,0,0,0,0,0,"","","","",""]
[null,"Open at end",{"$f":"COUNTIFS(TheRaised,\"<\"&$C$3,TheCompleted,\">\"&$C$3)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&$C$3,TheCompleted,\"\")","v":1},{"$f":"IF(D$4<>\"\",COUNTIFS(TheRaised,\"<\"&$C$3,TheCompleted,\">\"&$C$3,TheSource,\"=\"&D$4)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&$C$3,TheCompleted,\"\",TheSource,\"=\"&D$4),\"\")","v":0},0,0,0,0,0,0,0,0,1,"","","","",""]
[null,"Escalated to RR",{"$f":"IF(C$4<>\"\",COUNTIFS(TheRaised,\"<\"&$C$3,TheRaised,\">=\"&$C$2,ThePresent,TRUE,TheRisk,\">\"&rModerate),\"\")","v":0},{"$f":"IF(D$4<>\"\",COUNTIFS(TheRaised,\"<\"&$C$3,TheRaised,\">=\"&$C$2,ThePresent,TRUE,TheSource,\"=\"&D$4,TheRisk,\">\"&rModerate),\"\")","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(M$4<>\"\",COUNTIFS(TheRaised,\"<\"&$C$2,TheRaised,\">=\"&$C$1,ThePresent,TRUE,TheSource,\"=\"&M$4,TheRisk,\">\"&rModerate),\"\")","v":0},"","","","",""]
[]
[]
[null,"Last 5 Years"]
[null,"From",{"$f":"DATE(YEAR(TODAY())-4,1,1)","v":"2012-01-01"},{"$f":"EOMONTH(C13,11)+1","v":"2013-01-01"},{"$f":"EOMONTH(D13,11)+1","v":"2014-01-01"},{"$f":"EOMONTH(E13,11)+1","v":"2015-01-01"},{"$f":"EOMONTH(F13,11)+1","v":"2016-01-01"},null,{"$f":"EOMONTH(TODAY(),-1)+1","v":"2016-07-01"},{"$f":"EOMONTH(I13,0)","v":"2016-07-31"}]
[null,"To",{"$f":"EOMONTH(C13,11)","v":"2012-12-31"},{"$f":"EOMONTH(D13,11)","v":"2013-12-31"},{"$f":"EOMONTH(E13,11)","v":"2014-12-31"},{"$f":"EOMONTH(F13,11)","v":"2015-12-31"},{"$f":"EOMONTH(G13,11)","v":"2016-12-31"},null,null,null,null,{"$f":"TEXT(J13,\"mmmm yyyy\")","v":"July 2016"}]
[null,"Open",{"$f":"COUNTIFS(TheRaised,\"<\"&C$13,TheCompleted,\">\"&C$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&C$13,TheCompleted,\"\",ThePresent,TRUE)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&D$13,TheCompleted,\">\"&D$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&D$13,TheCompleted,\"\",ThePresent,TRUE)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&E$13,TheCompleted,\">\"&E$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&E$13,TheCompleted,\"\",ThePresent,TRUE)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&F$13,TheCompleted,\">\"&F$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&F$13,TheCompleted,\"\",ThePresent,TRUE)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&G$13,TheCompleted,\">\"&G$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&G$13,TheCompleted,\"\",ThePresent,TRUE)","v":0},null,null,null,null,"Open",{"$f":"COUNTIFS(TheRaised,\"<\"&I$13,TheCompleted,\">\"&I$13,ThePresent,TRUE)+COUNTIFS(TheRaised,\"<\"&I$13,TheCompleted,\"\",ThePresent,TRUE)","v":1}]
[null,"Raised",{"$f":"COUNTIFS(TheRaised,\">=\"&C$13,TheRaised,\"<=\"&C$14)","v":0},{"$f":"COUNTIFS(TheRaised,\">=\"&D$13,TheRaised,\"<=\"&D$14)","v":0},{"$f":"COUNTIFS(TheRaised,\">=\"&E$13,TheRaised,\"<=\"&E$14)","v":0},{"$f":"COUNTIFS(TheRaised,\">=\"&F$13,TheRaised,\"<=\"&F$14)","v":0},{"$f":"COUNTIFS(TheRaised,\">=\"&G$13,TheRaised,\"<=\"&G$14)","v":1},null,null,null,null,"Raised",{"$f":"COUNTIFS(TheRaised,\">=\"&I$13,TheRaised,\"<=\"&J$13)","v":0}]
[null,"Closed",{"$f":"COUNTIFS(TheCompleted,\">=\"&C$13,TheCompleted,\"<=\"&C$14)","v":0},{"$f":"COUNTIFS(TheCompleted,\">=\"&D$13,TheCompleted,\"<=\"&D$14)","v":0},{"$f":"COUNTIFS(TheCompleted,\">=\"&E$13,TheCompleted,\"<=\"&E$14)","v":0},{"$f":"COUNTIFS(TheCompleted,\">=\"&F$13,TheCompleted,\"<=\"&F$14)","v":0},{"$f":"COUNTIFS(TheCompleted,\">=\"&G$13,TheCompleted,\"<=\"&G$14)","v":0},null,null,null,null,"Closed",{"$f":"COUNTIFS(TheCompleted,\">=\"&I$13,TheCompleted,\"<=\"&J$13)","v":0}]
[null,"Open at end",{"$f":"COUNTIFS(TheRaised,\"<\"&C$14,TheCompleted,\">\"&C$14)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&C$14,TheCompleted,\"\")","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&D$14,TheCompleted,\">\"&D$14)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&D$14,TheCompleted,\"\")","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&E$14,TheCompleted,\">\"&E$14)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&E$14,TheCompleted,\"\")","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&F$14,TheCompleted,\">\"&F$14)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&F$14,TheCompleted,\"\")","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&G$14,TheCompleted,\">\"&G$14)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&G$14,TheCompleted,\"\")","v":1},null,null,null,null,"Open at end",{"$f":"COUNTIFS(TheRaised,\"<\"&J$13,TheCompleted,\">\"&J$13)+COUNTIFS(TheRaised,\"<>0\",TheRaised,\"<\"&J$13,TheCompleted,\"\")","v":1}]
[null,"Escalated to RR",{"$f":"COUNTIFS(TheRaised,\"<\"&C$14,TheRaised,\">=\"&C$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&D$14,TheRaised,\">=\"&D$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&E$14,TheRaised,\">=\"&E$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&F$14,TheRaised,\">=\"&F$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0},{"$f":"COUNTIFS(TheRaised,\"<\"&G$14,TheRaised,\">=\"&G$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0},null,null,null,null,"Escalated to RR",{"$f":"COUNTIFS(TheRaised,\"<\"&J$13,TheRaised,\">=\"&I$13,ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Traffic Lights"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"At \"&TEXT(TODAY(),\"d-mmm-yyyy\")","v":"At 20-Jul-2016"}]
[null,null,null,null,null,null,null,null,null,null,null,"Blue",{"$f":"COUNTIFS(TheCompleted,\"\",TheTrafficLight,L26)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"Green",{"$f":"COUNTIFS(TheCompleted,\"\",TheTrafficLight,L27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Amber",{"$f":"COUNTIFS(TheCompleted,\"\",TheTrafficLight,L28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Red",{"$f":"COUNTIFS(TheCompleted,\"\",TheTrafficLight,L29)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Escalated to RR",{"$f":"COUNTIFS(TheCompleted,\"=\"&\"\",ThePresent,TRUE,TheRisk,\">\"&rModerate)","v":0}]

{"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 & Escalation",{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],D$1,0)","v":"Low (None)"},{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],E$1,0)","v":"Moderate (Consider)"},{"$f":"OFFSET(TableRisk[[#Headers],[RIO Level]],F$1,0)","v":"High (Definitely)"}]

{"sheet":"Definition Tables","index":3,"n_rows":26,"n_cols":14,"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,"Worksheet Header (Enter values here if you want a specific header)"]
["SOURCE",null,"Business Risk Category","Decription",null,"Likelihood","Rating","Like-Desc",null,null,null,null,"Worksheet","Header Title"]
["Document Management",null,"Strategic","Decisions Concerning Your Business’ Objectives",null,"None",0,{"$f":"TableProb[[#This Row],[Rating]]&\" - \"&TableProb[[#This Row],[Likelihood]]","v":"0 - None"},null,null,null,null,{"$f":"TRIM(MID(CELL(\"filename\",'RIO Register'!$A$1),FIND(\"]\",CELL(\"filename\",'RIO Register'!$A$1))+1,99))","v":"RIO Register"},"Risks, Improvements, Opportunities Register"]
["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"},null,null,null,null,{"$f":"MID(CELL(\"filename\",'RIO Stats'!$A$1),FIND(\"]\",CELL(\"filename\",'RIO Stats'!$A$1))+1,99)","v":"RIO Stats"},{"$f":"\"ISO9001 Risks, Improvements, Opportunities \"&CHAR(10)&TEXT(TODAY(),\"mmmm yyyy\")","v":"ISO9001 Risks, Improvements, Opportunities \nJuly 2016"}]
["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"},null,null,null,null,{"$f":"MID(CELL(\"filename\",RiskMatrix!$A$1),FIND(\"]\",CELL(\"filename\",RiskMatrix!$A$1))+1,99)","v":"RiskMatrix"},"Risk Matrix"]
["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"]
["Example",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,"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","Consider",{"$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 (Consider)"}]
[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)"}]

{"sheet":"HELP!!!!","index":4,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["How to use this register - Some basic HELP"]
[]
["This register is used to record Risks, Improvements and Opportunities (RIOs), and produce some basic statistics."]
["It has a couple of macros in it so macros should be enabled in Excel"]
["When an entry is made in Source, the next number is automatically populated (it’s the first of the macros).  It's the number of the cell above plus one"]
["The values that can be entered in \"Source\" are restricted to the values in a table in column A of the worksheet \"Definition Tables\".  These can be added to, modified or deleted."]
["Details, Raised, Originator and Reviews/Controls/Root cause/Actions are straightforward"]
["In Risk Likelihood enter a number representing the likelihood of the risk occurring from 1 (very low) to 5 (very high)"]
["In Risk Consequence enter a number representing the consequemce of the risk occurs from 1 (very low) to 5 (very high)"]
["Risk Assesment (Escalation) is calculated based on the table \"Risk Score\" in worksheet Definition Tables"]
["Target, Who, Review of effectiveness, Completed and Approved are hopefully straighforward"]
[]
["Changes, Traffic Light, Scheduled, Risk Score, Present are all calculated columns"]
["Changes reflects the number of changes made to the target date and drives the colour of the \"Target Date\" cell (the number of changes can be adjusted manually if ncessary)"]
["Traffic Light - Blue if Target date is this month, Green if # changes = 1, Amber if # changes = 2, Red if # changes >2 "]
["Present - TRUE if there is an entry in \"source\" cell"]
[]
[]
["Printing"]
["Another macro runs whenever the workbook is saved and will adjust the footer of each page to display the date the Workbook was last saved. "]
["If you want to change the description in the header for a sheet, enter the required value in the table in Definition Tables M2:N10"]
[]
[]
["RIO Stats"]
["These are some basic summaries of the number of RIOs in the period.  The first table is intended for presentation at Management Reviews and by default are for the 12 months preceeding the next Management Review (which is entered in cell C1).  It shows the number of RIOs Open, Raised, Closed, Open at end and Escalated to Risk Register for the period by the \"source\" type (as defined in the table in column A of Definition Tables."]
["The second table shows the number of RIOs Open, Raised, Closed, Open at end and Escalated to Risk Register for the previous 5 calendar years"]
["And finally the number of RIOs Open, Raised, Closed, Open at end and Escalated to Risk Register as at today's date and the number of RIOs for each Traffic Light"]