{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["QRA Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"QRA Template","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,6,10,8],[10,9,10,10],[10,2,10,5]]}
[]
[null,"File Name",null,null,null,null,null,{"$f":"IFERROR(MID(CELL(\"filename\",H2),FIND(\"[\",CELL(\"filename\",H2))+1,FIND(\"]\",CELL(\"filename\",H2))-FIND(\"[\",CELL(\"filename\",H2))-1),\"Please save the file to show here\")","v":"Quantified Risk Assessment Template.xlsm"}]
[null,"Sheet Name",null,null,null,null,null,{"$f":"IFERROR(MID(CELL(\"filename\",H2),FIND(\"]\",CELL(\"filename\",H2))+1,255),\"Please save the file to show here\")","v":"QRA Template"}]
[null,"Description and Purpose of Sheet",null,null,null,null,null,"user input"]
[]
[]
[null,"Quantified Risk Assessment (QRA)"]
[]
[null,"Refer to the Quantified Risk Assessment of the Greener Bus Tool user guide for further detail on conducting a QRA."]
[]
[null,null,"Step 1: Risk Identification",null,null,null,"Step 2: Assessing the Impacts of Risk",null,null,"Step 3: Estimating the Likelihood of Outcomes",null,"Step 4: Deriving the Costs","Mitigation"]
[null,null,"Risk No","Risk Description","Potential Impact","Risk owner","Minimum cost","Most likely cost","Maximum cost","Likelihood","Explanation of likelihood","Risk amount","Planned Mitigation"]
[null,null,"Assign the risk an identification number e.g. 1","Provide a brief description of the risk e.g.vehicle cost quotes expiring","Outline the impact the risk will have on project costs e.g potential cost increase if new quotes are sought","State the risk owner","Provide an estimate of the minimum additional cost to the project if the risk materialises.","Provide an estimate of the most likely additional cost to the project if the risk materialises.","Provide an estimate of the maxiumum additional cost to the project if the risk materialises.","Provide a probability of the risk occurring e.g. 60%","Provide reasoning for the estimated probability of the risk e.g. if risk is assumed to be low, how has this been determined?","This is determined by the probability of the most likely cost occurring and is automatically calculated in this spreasheet. Costs may also be derived using a probability distribution. If this is considered to be a proportionate apporach to derive costs please refer to TAG Unit A1.2 for further information.","Outline any measures that have been planned to mitigate the risk i.e. by either reducing the cost of the risk or the likelihood of the risk."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H14*J14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"H15*J15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Total risk/contigency amount",{"$f":"SUM($L$13:$L$19)","v":0}]
[]
[]
[]
[]
[]
[null,"END"]