{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Risks","Scoring Matrix","Data Validation","Macros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Risks","index":0,"n_rows":201,"n_cols":33,"rows_kept":201,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,25,0,31],[1,29,1,31],[1,14,1,16],[0,10,0,16],[0,17,0,21],[0,22,0,24],[0,7,0,9]]}
[null,"Risk Detail",null,null,null,null,null,"Risk Evaluation ",null,null,"Combined Risk Analysis",null,null,null,null,null,null,"Risk Mitigation Detail",null,null,null,null,"Revised Risk Evaluation",null,null,"Combined Risk Analysis Revised"]
[null,null,null,null,null,null,null,null,null,null,"Reputational Severity",null,"Cost Severity",null,null,null,null,null,null,null,null,null,null,null,null,"Reputational Severity","Cost","Cost Severity","Reputational","Button"]
["Risk ID No","Asset Group","Cause of risk","Risk Description","Effect of Risk","Risk Owner","Current Status","Likelihood ","Reputational Severity","Cost Severity","Importance Indicator","Cost Risk Ranking","Importance Indicator","Reputational Risk Ranking","Likelihood ","Combined Indicator","Combined Ranking","Mitigation Action 1","Action Owner","Action Date","No. of Days Overdue","Comments","Likelihood ","Reputational Severity","Cost Severity","Importance Indicator","Risk Ranking","Importance Indicator","Risk Ranking","Likelihood ","Combined Indicator","Combined Ranking","Last Review Date"]
[14,"Bridges & Structures","Insufficient Competency","Lack of qualified / skilled professional (internal) staff ","impact on quality of service","Richard Atkins","Open",5,3,3,{"$f":"(H4*I4)","v":15},{"$f":"IF(K4<1,\"Nil\",IF(K4<5,\"Low\",IF(K4>=12,\"High\",\"Medium\")))","v":"High"},{"$f":"(H4*J4)","v":15},{"$f":"IF(M4<1,\"Nil\",IF(M4<5,\"Low\",IF(M4>=12,\"High\",\"Medium\")))","v":"High"},{"$f":"H4","v":5},{"$f":"MAX(K4,M4)","v":15},{"$f":"IF(P4=0,\"Nil\",IF(P4<5,\"Low\",IF(P4>=12,\"High\",\"Medium\")))","v":"High"},"Training requirments and succession management","Paul Mathieson","2018-03-01",null,null,2,1,1,{"$f":"(W4*X4)","v":2},{"$f":"IF(Z4<1,\"Nil\",IF(Z4<5,\"Low\",IF(Z4>=12,\"High\",\"Medium\")))","v":"Low"},{"$f":"(W4*Y4)","v":2},{"$f":"IF(AB4<1,\"Nil\",IF(AB4<5,\"Low\",IF(AB4>=12,\"High\",\"Medium\")))","v":"Low"},{"$f":"W4","v":2},{"$f":"MAX(Z4,AB4)","v":2},{"$f":"IF(AE4=0,\"Nil\",IF(AE4<5,\"Low\",IF(AE4>=12,\"High\",\"Medium\")))","v":"Low"}]
[1,"Bridges & Structures","Structural Failure","Embankment & cutting; collapses ","risk of injury & route closure","Richard Atkins","Open",3,3,5,9,"Medium",15,"High",3,15,"High","set up a monitoring regime","Richard Atkins","2016-06-01",null,null,2,3,5,6,"Medium",10,"Medium",2,10,"Medium"]
[4,"Bridges & Structures","Adverse/Extreme Weather","Fallen trees","disruption to highway network","Richard Atkins","Open",3,5,5,15,"High",15,"High",3,15,"High","Review location of vegetation","Richard Atkins","2017-03-31",null,null,2,5,5,10,"Medium",10,"Medium",2,10,"Medium"]
[7,"Bridges & Structures","Financial","Contractual insolvancy","leading to system being taken down","Richard Atkins","Open",3,5,4,15,"High",12,"High",3,15,"High","Due diligence at tender stage","Richard Atkins","2016-06-01",null,null,1,5,4,5,"Medium",4,"Low",1,5,"Medium"]
[13,"Bridges & Structures","Financial","Not implementing TAMP","reduction in funding","Richard Atkins","Open",3,5,3,15,"High",9,"Medium",3,15,"High","Implement TAMP and lifecycle management","Richard Atkins","2016-12-01",null,null,2,5,3,10,"Medium",6,"Medium",2,10,"Medium"]
[12,"Bridges & Structures","Adverse/Extreme Weather - Flooding","Localised flooding ","leading to travel disruption ","Richard Atkins","Open",4,3,3,12,"High",12,"High",4,12,"High","Consider works on the resilience network","Richard Atkins","2020-03-31",null,null,2,3,3,6,"Medium",6,"Medium",2,6,"Medium"]
[15,"Bridges & Structures","Condition Deterioration","Reduced load carrying capacity ","leading to reduced availability of highway network","Richard Atkins","Open",3,4,3,12,"High",9,"Medium",3,12,"High","Implement TAMP and lifecycle management","Richard Atkins","2017-03-01",null,null,2,4,3,8,"Medium",6,"Medium",2,8,"Medium"]
[2,"Bridges & Structures","Adverse/Extreme Weather - Flooding","Flooding, scour, undermining, adverse weather and natural events leading to ","structural damage","Richard Atkins","Open",2,4,5,8,"Medium",10,"Medium",2,10,"Medium","set up a monitoring regime","Richard Atkins","2016-06-01",null,null,1,4,5,4,"Low",5,"Medium",1,5,"Medium"]
[8,"Bridges & Structures","Accident Damage","Bridge strikes","structural damage, road closures","Richard Atkins","Open",3,3,3,9,"Medium",9,"Medium",3,9,"Medium","Ensure bridge heights and widths are clearly displayed","Richard Atkins","2017-03-31",null,null,2,3,3,6,"Medium",6,"Medium",2,6,"Medium"]
[5,"Bridges & Structures","Adverse/Extreme Weather","Coastal flooding ","travel disruption and possible evacuation","Richard Atkins","Open",2,4,4,8,"Medium",8,"Medium",2,8,"Medium","Develop SUDS projects and associated coastal defences","Richard Atkins","2020-03-31",null,null,1,4,4,4,"Low",4,"Low",1,4,"Low"]
[6,"Bridges & Structures","Unauthorised/Inappropriate Use","Unauthorised abnormal loads ","causing structural damage","Richard Atkins","Open",2,3,4,6,"Medium",8,"Medium",2,8,"Medium","Ensure process for abmormal loads is followed","Richard Atkins","2016-03-31",null,null,1,3,4,3,"Low",4,"Low",1,4,"Low"]
[9,"Bridges & Structures","Condition Deterioration","Loose or displaced elements, falling objects ","leading to personal injury","Richard Atkins","Open",2,4,3,8,"Medium",6,"Medium",2,8,"Medium","Carry out regular inspections","Richard Atkins","2020-03-31",null,null,1,3,3,3,"Low",3,"Low",1,3,"Low"]
[10,"Bridges & Structures","Structural Failure","Collapsing sign/signal gantries, tee-posts, high mast lighting","leading to injury","Richard Atkins","Open",2,3,3,6,"Medium",6,"Medium",2,6,"Medium","Carry out regular inspections","Richard Atkins","2020-03-31",null,null,1,3,3,3,"Low",3,"Low",1,3,"Low"]
[3,"Bridges & Structures","Structural Failure","Structural failure ","leads to serious injury and or major disruption","Richard Atkins","Open",1,5,5,5,"Medium",5,"Medium",1,5,"Medium","set up a monitoring regime","Richard Atkins","2016-06-01",null,null,1,4,5,4,"Low",5,"Medium",1,5,"Medium"]
[11,"Bridges & Structures","Structural Failure","Sub standard parapets  of rail and road traffic; road over rail incursions ","Serious risk to Health & Safety","Richard Atkins","Open",1,5,3,5,"Medium",3,"Low",1,5,"Medium","Carry out regular inspections","Richard Atkins","2020-03-31",null,null,1,5,3,5,"Medium",3,"Low",1,5,"Medium"]
[38,"Bridges & Structures","Adverse/Extreme Weather","Fallen trees ","structural damage & personal injury","Richard Atkins","Open",null,null,null,0,"Nil",0,"Nil",0,0,"Nil","Inspect trees near structures for integrety",null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[49,"Bridges & Structures","Accident Damage","Fuel Spillage","Endangering environment, contaminated watercourses, road closures & traffic disruption","Richard Atkins","Open",null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[45,"Carriageway & Footway","Condition Deterioration","Condition Deterioration","leading to increased claims, personal injury, ","Zulfiqar Ali","Open",3,5,5,15,"High",15,"High",3,15,"High","Forward programmes of works identifies and prioritises works required. Continuaing collaboration with contractors to identify new and improved innovative materials","Zulfiqar Ali",null,null,null,2,5,5,10,"Medium",10,"Medium",2,10,"Medium"]
[44,"Carriageway & Footway","Unauthorised/Inappropriate Use","structural damage","leading to traffic delays and pedestrian movement safety","Zulfiqar Ali","Open",3,4,3,12,"High",9,"Medium",3,12,"High","Increased opportunity to identify unauthorised use via introduction of the \"report it\" functionality and response.","Zulfiqar Ali",null,null,null,2,4,2,8,"Medium",4,"Low",2,8,"Medium"]
[43,"Carriageway & Footway","Lack of Resource","Insufficient staff to carry out statutory & day to day duties","works not initiated ","Zulfiqar Ali","Open",2,5,2,10,"Medium",4,"Low",2,10,"Medium","Increase in dedicated and qualified FTE","Zulfiqar Ali",null,null,null,1,4,2,4,"Low",2,"Low",1,4,"Low"]
[48,"Carriageway & Footway","Insufficient Competency","Lack of skilled professional staff ","leading to poor data & asset management, poor inspections, inappropriate permitting, loss of income (fines), inappropriate spend ","Paul Mathieson","Open",2,5,4,10,"Medium",8,"Medium",2,10,"Medium","Ongoing training organised.","Zulfiqar Ali",null,null,null,1,4,3,4,"Low",3,"Low",1,4,"Low"]
[36,"Carriageway & Footway","Adverse/Extreme Weather - Flooding","Flooding ","leading to traffic delays and pedestrian movement safety ","Paul Mathieson","Open",3,3,3,9,"Medium",9,"Medium",3,9,"Medium","Ensure gulleys are regularly cleaned (especially the resillience network). Develop capital schemes to improve the network, including SUDS","Zulfiqar Ali",null,null,null,2,3,2,6,"Medium",4,"Low",2,6,"Medium"]
[51,"Carriageway & Footway","Adverse/Extreme Weather","fallen trees","personal injury, traffic delays, structural damage, road closures","Zulfiqar Ali","Open",3,1,3,3,"Low",9,"Medium",3,9,"Medium","Training and early identification of, and works to, dead, diseased and dangerous trees.","Zulfiqar Ali",null,null,null,2,1,3,2,"Low",6,"Medium",2,6,"Medium"]
[54,"Carriageway & Footway","Condition Deterioration","Do minimum resurfacing programme could lead to an increased level of insurance claims","Cost esculation due to increased third party claims","Zulfiqar Ali","Open",3,3,2,9,"Medium",6,"Medium",3,9,"Medium","Consider increased capital funding targeted in high risk areas identified within the forward programme of works and capital schemes.","Zulfiqar Ali","2017-03-31",null,null,2,2,2,4,"Low",4,"Low",2,4,"Low"]
[52,"Carriageway & Footway","Accident Damage","RTC ","damage to street furniture","Zulfiqar Ali","Open",4,1,2,4,"Low",8,"Medium",4,8,"Medium","Decluttering where appropriate and recharging of costs where identified","Zulfiqar Ali",null,null,null,2,1,2,2,"Low",4,"Low",2,4,"Low"]
[53,"Carriageway & Footway","Condition Deterioration","Gulley condition differs depending upon time of year, e.g. autumn leaf fall blocking gulleys.","Gulleys that are signed as clear become blocked causing localised flooding","Zulfiqar Ali","Open",4,2,2,8,"Medium",8,"Medium",4,8,"Medium","Ensure key gulleys are cleared at known times of the year. Ongoing review of inspection regime.","Zulfiqar Ali",null,null,null,3,2,2,6,"Medium",6,"Medium",3,6,"Medium"]
[35,"Carriageway & Footway","Major Incident","network adversly affected","leading to traffic delays and pedestrian movement safety ","Zulfiqar Ali","Open",2,1,4,2,"Low",8,"Medium",2,8,"Medium","Develop emergency response procedure. Crossovers, etc. on resilience network.","Zulfiqar Ali",null,null,null,2,1,3,2,"Low",6,"Medium",2,6,"Medium"]
[34,"Carriageway & Footway","Financial","Contractual insolvancy","delay to planned & reactive works","Paul Mathieson","Open",1,4,5,4,"Low",5,"Medium",1,5,"Medium","Carry out financial checks on all contractors prior to award of contract","Mark Atkins",null,null,null,1,3,5,3,"Low",5,"Medium",1,5,"Medium"]
[37,"Carriageway & Footway","Insufficient Competency","Lack of skilled construction staff ","leading to poor maintenance/new works & increase in cost & time?","Paul Mathieson","Open",1,5,1,5,"Medium",1,"Low",1,5,"Medium","Ensure quality assessment is robust","Paul Mathieson",null,null,null,1,3,1,3,"Low",1,"Low",1,3,"Low"]
[46,"Carriageway & Footway","Accident Damage","Fuel Spillage","structural damage, road closures","Zulfiqar Ali","Open",2,1,2,2,"Low",4,"Low",2,4,"Low","Ensure contractors have appropriate materials","Zulfiqar Ali",null,null,null,1,1,2,1,"Low",2,"Low",1,2,"Low"]
[23,"Signals & Lights","Financial","Contractual insolvancy ","leading to system being taken down","Richard Backhouse","Open",3,5,4,15,"High",12,"High",3,15,"High",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[24,"Signals & Lights","Equipment Failure","Street furniture becoming live ","endangering the public","Richard Backhouse","Open",3,5,1,15,"High",3,"Low",3,15,"High",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[25,"Signals & Lights","Equipment Failure","Equipment failure on lighting column leading to exposed cables etc","leading to personal injury","Richard Backhouse","Open",4,3,2,{"$f":"(H36*I36)","v":12},{"$f":"IF(K36<1,\"Nil\",IF(K36<5,\"Low\",IF(K36>=12,\"High\",\"Medium\")))","v":"High"},{"$f":"(H36*J36)","v":8},{"$f":"IF(M36<1,\"Nil\",IF(M36<5,\"Low\",IF(M36>=12,\"High\",\"Medium\")))","v":"Medium"},{"$f":"H36","v":4},{"$f":"MAX(K36,M36)","v":12},{"$f":"IF(P36=0,\"Nil\",IF(P36<5,\"Low\",IF(P36>=12,\"High\",\"Medium\")))","v":"High"},null,null,null,null,null,null,null,null,{"$f":"(W36*X36)","v":0},{"$f":"IF(Z36<1,\"Nil\",IF(Z36<5,\"Low\",IF(Z36>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W36*Y36)","v":0},{"$f":"IF(AB36<1,\"Nil\",IF(AB36<5,\"Low\",IF(AB36>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W36","v":0},{"$f":"MAX(Z36,AB36)","v":0},{"$f":"IF(AE36=0,\"Nil\",IF(AE36<5,\"Low\",IF(AE36>=12,\"High\",\"Medium\")))","v":"Nil"}]
[26,"Signals & Lights","Accident Damage","Accident damage to signalling equipment ","leading to traffic delays and pedestrian movement safety","Richard Backhouse","Open",5,2,1,10,"Medium",5,"Medium",5,10,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[27,"Signals & Lights","Power Failure","Power failure to individual sites","leading to traffic confusion and pedestrian movement safety","Richard Backhouse","Open",5,1,1,5,"Medium",5,"Medium",5,5,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[28,"Signals & Lights","Vandelism","Inpairing the efficiency of the equipment ","endangering users","Richard Backhouse","Open",5,1,1,5,"Medium",5,"Medium",5,5,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[29,"Signals & Lights","System Failure","CMS system failure ","leading to wide spread blackout","Richard Backhouse","Open",1,5,1,5,"Medium",1,"Low",1,5,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[30,"Signals & Lights","Structural Failure","Structural failure ","leading to traffic confusion and pedestrian movement safety","Richard Backhouse","Open",1,5,1,5,"Medium",1,"Low",1,5,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[31,"Signals & Lights","Adverse/Extreme Weather","Non availability of skilled staff attending issues","leading to traffic delays and pedestrian movement safety","Richard Backhouse","Open",2,2,1,4,"Low",2,"Low",2,4,"Low",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[32,"Signals & Lights","Power Failure","Traffic control system defaults signals to standard timings ","leading to traffic delays","Richard Backhouse","Open",2,1,1,2,"Low",2,"Low",2,2,"Low",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[33,"Signals & Lights","Adverse/Extreme Weather - Flooding","Traffic signal failure","leading to traffic confusion and pedestrian movement safety","Richard Backhouse","Open",1,2,1,2,"Low",1,"Low",1,2,"Low",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[16,"Strategic","Adverse/Extreme Weather","Storms causing fallen trees","disruption to highway network & personal injury","Peter Geraghty","Open",3,5,5,15,"High",15,"High",3,15,"High","Ensure trees are regulary maintained by experienced personnel","Paul Jenkinson","2020-03-01",null,null,2,4,5,8,"Medium",10,"Medium",2,10,"Medium"]
[17,"Strategic","Financial","Not implementing TAMP","reduction in funding","Peter Geraghty","Open",3,5,3,15,"High",9,"Medium",3,15,"High","Create governance and work streams. Implement TAMP as quickly as possible","Peter Geraghty","2017-03-01",null,null,2,3,3,6,"Medium",6,"Medium",2,6,"Medium"]
[18,"Strategic","Insufficient Competency","Lack of skilled professional staff ","leading to poor maintenance/new works design options","Peter Geraghty","Open",3,5,2,15,"High",6,"Medium",3,15,"High","Compile skills matrix and commence training","neil hoskins","2017-03-01",null,null,1,4,2,4,"Low",2,"Low",1,4,"Low"]
[19,"Strategic","Adverse/Extreme Weather","Causing localised flooding ","leading to travel disruption ","Peter Geraghty","Open",4,3,3,12,"High",12,"High",4,12,"High","Ensure gulleys are regularly cleaned (especially the resillience network). Develop capital schemes to improve the network, including SUDS","neil hoskins","2017-03-01",null,null,3,3,3,9,"Medium",9,"Medium",3,9,"Medium"]
[20,"Strategic","Lack of Resource","Insufficient staff to collect condition survey data ","leading to incorrect interventions","Peter Geraghty","Open",4,3,2,12,"High",8,"Medium",4,12,"High","Develop a variety of delivery options","neil hoskins","2017-03-01",null,null,3,3,2,9,"Medium",6,"Medium",3,9,"Medium"]
[47,"Strategic","Financial","Lack of resource/ lack of skilled resource","Poor Safety Inspection Regimes","Peter Geraghty","Open",3,4,4,12,"High",12,"High",3,12,"High","Dedicated inspectors. Picking up category 2 defects - move more defects to planned","Peter Geraghty","2017-03-01",null,null,1,4,3,4,"Low",3,"Low",1,4,"Low"]
[21,"Strategic","Insufficient Competency","Lack of skilled construction staff ","leading to poor maintenance/new works design options","Peter Geraghty","Open",2,5,2,10,"Medium",4,"Low",2,10,"Medium","Discuss issue with contractor at joint conference - develop options","neil hoskins","2017-03-01",null,null,2,3,2,6,"Medium",4,"Low",2,6,"Medium"]
[41,"Strategic","Major Incident","Resilience network adversly affected","leading to travel disruption and possible evacuation","Peter Geraghty","Open",2,5,5,10,"Medium",10,"Medium",2,10,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[42,"Strategic","Financial","Contractual Insovency","Procurement etc","Peter Geraghty","Open",2,5,5,10,"Medium",10,"Medium",2,10,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[39,"Strategic","Adverse/Extreme Weather","Resilience network","leading to travel disruption","Peter Geraghty","Open",3,3,3,9,"Medium",9,"Medium",3,9,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[22,"Strategic","Extreme/Adverse Weather - Flooding","Coastal flooding ","leading to travel disruption and possible evacuation","Peter Geraghty","Open",2,4,4,8,"Medium",8,"Medium",2,8,"Medium","Work on developing a joint coastal/highway solution","Richard Atkins","2017-03-01",null,null,2,3,4,6,"Medium",8,"Medium",2,8,"Medium"]
[50,"Strategic","Major Incident","Incident causes major traffic disruption","Loss of income to Southend","Andrew Lewis","Open",2,3,3,6,"Medium",6,"Medium",2,6,"Medium",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[40,"Strategic","Industrial Action","Resilience network","Resilience network","Peter Geraghty","Open",1,3,2,3,"Low",2,"Low",1,3,"Low",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,"9.4.4 The safety inspection regime forms a key aspect of an authority’s strategy for managing liabilities and risks.",null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(H68*I68)","v":0},{"$f":"IF(K68<1,\"Nil\",IF(K68<5,\"Low\",IF(K68>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(H68*J68)","v":0},{"$f":"IF(M68<1,\"Nil\",IF(M68<5,\"Low\",IF(M68>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"H68","v":0},{"$f":"MAX(K68,M68)","v":0},{"$f":"IF(P68=0,\"Nil\",IF(P68<5,\"Low\",IF(P68>=12,\"High\",\"Medium\")))","v":"Nil"},null,null,null,null,null,null,null,null,{"$f":"(W68*X68)","v":0},{"$f":"IF(Z68<1,\"Nil\",IF(Z68<5,\"Low\",IF(Z68>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W68*Y68)","v":0},{"$f":"IF(AB68<1,\"Nil\",IF(AB68<5,\"Low\",IF(AB68>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W68","v":0},{"$f":"MAX(Z68,AB68)","v":0},{"$f":"IF(AE68=0,\"Nil\",IF(AE68<5,\"Low\",IF(AE68>=12,\"High\",\"Medium\")))","v":"Nil"}]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(H100*I100)","v":0},{"$f":"IF(K100<1,\"Nil\",IF(K100<5,\"Low\",IF(K100>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(H100*J100)","v":0},{"$f":"IF(M100<1,\"Nil\",IF(M100<5,\"Low\",IF(M100>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"H100","v":0},{"$f":"MAX(K100,M100)","v":0},{"$f":"IF(P100=0,\"Nil\",IF(P100<5,\"Low\",IF(P100>=12,\"High\",\"Medium\")))","v":"Nil"},null,null,null,null,null,null,null,null,{"$f":"(W100*X100)","v":0},{"$f":"IF(Z100<1,\"Nil\",IF(Z100<5,\"Low\",IF(Z100>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W100*Y100)","v":0},{"$f":"IF(AB100<1,\"Nil\",IF(AB100<5,\"Low\",IF(AB100>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W100","v":0},{"$f":"MAX(Z100,AB100)","v":0},{"$f":"IF(AE100=0,\"Nil\",IF(AE100<5,\"Low\",IF(AE100>=12,\"High\",\"Medium\")))","v":"Nil"}]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(H132*I132)","v":0},{"$f":"IF(K132<1,\"Nil\",IF(K132<5,\"Low\",IF(K132>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(H132*J132)","v":0},{"$f":"IF(M132<1,\"Nil\",IF(M132<5,\"Low\",IF(M132>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"H132","v":0},{"$f":"MAX(K132,M132)","v":0},{"$f":"IF(P132=0,\"Nil\",IF(P132<5,\"Low\",IF(P132>=12,\"High\",\"Medium\")))","v":"Nil"},null,null,null,null,null,null,null,null,{"$f":"(W132*X132)","v":0},{"$f":"IF(Z132<1,\"Nil\",IF(Z132<5,\"Low\",IF(Z132>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W132*Y132)","v":0},{"$f":"IF(AB132<1,\"Nil\",IF(AB132<5,\"Low\",IF(AB132>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W132","v":0},{"$f":"MAX(Z132,AB132)","v":0},{"$f":"IF(AE132=0,\"Nil\",IF(AE132<5,\"Low\",IF(AE132>=12,\"High\",\"Medium\")))","v":"Nil"}]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(H164*I164)","v":0},{"$f":"IF(K164<1,\"Nil\",IF(K164<5,\"Low\",IF(K164>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(H164*J164)","v":0},{"$f":"IF(M164<1,\"Nil\",IF(M164<5,\"Low\",IF(M164>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"H164","v":0},{"$f":"MAX(K164,M164)","v":0},{"$f":"IF(P164=0,\"Nil\",IF(P164<5,\"Low\",IF(P164>=12,\"High\",\"Medium\")))","v":"Nil"},null,null,null,null,null,null,null,null,{"$f":"(W164*X164)","v":0},{"$f":"IF(Z164<1,\"Nil\",IF(Z164<5,\"Low\",IF(Z164>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W164*Y164)","v":0},{"$f":"IF(AB164<1,\"Nil\",IF(AB164<5,\"Low\",IF(AB164>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W164","v":0},{"$f":"MAX(Z164,AB164)","v":0},{"$f":"IF(AE164=0,\"Nil\",IF(AE164<5,\"Low\",IF(AE164>=12,\"High\",\"Medium\")))","v":"Nil"}]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(H196*I196)","v":0},{"$f":"IF(K196<1,\"Nil\",IF(K196<5,\"Low\",IF(K196>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(H196*J196)","v":0},{"$f":"IF(M196<1,\"Nil\",IF(M196<5,\"Low\",IF(M196>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"H196","v":0},{"$f":"MAX(K196,M196)","v":0},{"$f":"IF(P196=0,\"Nil\",IF(P196<5,\"Low\",IF(P196>=12,\"High\",\"Medium\")))","v":"Nil"},null,null,null,null,null,null,null,null,{"$f":"(W196*X196)","v":0},{"$f":"IF(Z196<1,\"Nil\",IF(Z196<5,\"Low\",IF(Z196>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"(W196*Y196)","v":0},{"$f":"IF(AB196<1,\"Nil\",IF(AB196<5,\"Low\",IF(AB196>=12,\"High\",\"Medium\")))","v":"Nil"},{"$f":"W196","v":0},{"$f":"MAX(Z196,AB196)","v":0},{"$f":"IF(AE196=0,\"Nil\",IF(AE196<5,\"Low\",IF(AE196>=12,\"High\",\"Medium\")))","v":"Nil"}]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]
[null,null,null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil",null,null,null,null,null,null,null,null,0,"Nil",0,"Nil",0,0,"Nil"]

{"sheet":"Scoring Matrix","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[0,0,0,4]]}
["Scoring Matrix",null,null,null,null,null,"Risk management is dealt with in the UKRLG Highway Infrastructure Asset Management Guidance, Part C, and Section A.5 of the Well Managed Highway Infrastructure Code."]
["Score","Probability/Likelyhood",null,"Reputation","Cost"]
[5,"Almost Certain","71% to 99%","major reputational risk/National press coverage",">£500K"]
[4,"Probable","51% to 70%","Significant reputational risk/Regional press coverage","£250k - £500k"]
[3,"Possible","31% to 50%","Moderate reputational risk/Lengthy Local press coverage","£100k - £250k"]
[2,"Unlikely","11% to 30%","Some reputational risk/Local press coverage","£20k - £100k"]
[1,"Remote","1% to 10%","Minor reputational risk/Little or no local press coverage","< £20k"]

{"sheet":"Data Validation","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Asset Group","Risk Owner","Current Status","Cause of Risk"]
["Bridges & Structures","Andrew Lewis","Open","Accident"]
["Carriageway & Footway","David Gilkes","Closed","Accident Damage"]
["Signals & Lights","Neil Hoskins",null,"Accidents"]
["Strategic","Paul Mathieson",null,"Adverse/Extreme Weather"]
[null,"Peter Geraghty",null,"Adverse/Extreme Weather - Flooding"]
[null,"Richard Atkins",null,"Condition Deterioration"]
[null,"Richard Backhouse",null,"Equipment Failure"]
[null,"Zulfiqar Ali",null,"Financial"]
[null,"Paul Jenkinson",null,"Industrial Action"]
[null,"Mark Atkins",null,"Insufficient Competency"]
[null,null,null,"Lack of Resource"]
[null,null,null,"Major Incident"]
[null,null,null,"Power Failure"]
[null,null,null,"Structural Failure"]
[null,null,null,"Unauthorised/Inappropriate Use"]
[null,null,null,"Vandelism"]

{"sheet":"Macros","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Button:","Macro Name","Description"]
[1,"RiskIDSort","Sort by Rank ID - to revert spreadsheet to original order risks were added"]
[2,"AssetGroupSort","Sort by Asset Group then by Combined Ranking then by Combined Indicator Likelihood"]
[3,"CauseOfRisk","Sort by Cause of Risk then by Combined Ranking then by Combined Indicator then by Likelihood"]
[4,"RiskOwnerSort","Sort by Risk Owner then by Asset Group then by Combined Ranking then by Combined Indicator then by Likelihood "]
[5,"CurrentStatusSort","Sort by Current Status then by Combined Ranking then by Combined Indicator then by Likelihood then by Risk Owner then by Asset Group"]
[6,"CostRiskRankingSort","Sort by Cost Risk Ranking"]
[7,"ReputationalRiskRanking","Sort by Reputational Risk Ranking"]
["Combined 1","Combined1","Sort by Combined Ranking then by Combined Indicator then by Likelihood"]
[8,"ActionOwnerSort","Sort by Action Owner then by Combined Ranking then by Combined Indicator then by Likelihood then by Action Date then by Asset Group"]
[9,"ActionDateSort","Sort by Action Date then by Combined Ranking then by Combined Indicator then by Likelihood then by Action Owner then by Asset Group"]
["Combined 2","CombinedSort2","Sort by Combined Ranking then by Combined Indicator then by Likelihood"]