{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contributory Factors","Countermeasures","Recommendations_Printable","Sheet3","Recommendations","Transpose For Lists"],"not_rendered":{"charts":0,"images":128,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Contributory Factors","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Countermeasures","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Recommendations_Printable","index":2,"n_rows":124,"n_cols":4,"rows_kept":124,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Recommendations"]
[null,null,"Date of Asssessment:","dd/mm/yyyy"]
[null,null,"Assessed by:","Please enter name"]
[null,null,"Organisation:","Please enter organisation"]
[null,null,"Assessed Area:","Please enter area under assessment"]
[null,null,"RoR Crash Type:","All RoR"]
[]
["Priority","#","Contributory Factor","Recommended Countermeasures to be Considered"]
[1,1,"Data on (RoR) crashes aren't collected"]
[1,null,1,"Introduce RoR specific data fields to national incident data collection forms."]
[1,null,2,"Introduce legal requirement for collection of RoR incident data at national level."]
[1,null,3,"Incentivise collection of RoR incident data, by raising awareness to the benefits amongst traffic police."]
[1,null,4,"Create centralised database for RSA findings."]
[1,null,5,"Create centralised database for RSI findings."]
[1,null,6,"Create centralised data base for roadside related departures from standards."]
[1,2,"Data on (RoR) crashes aren't detailed enough"]
[1,null,1,"Establish in-depth on site incident data collection programme, such as RAIDS in the UK."]
[1,null,2,"Introduce site photographs as part of national incident data collection procedure. "]
[1,null,3,"Introduce sketch of the incident as part of national incident data collection form."]
[1,null,4,"Introduce detailed written description of the incident as part of national data collection form."]
[1,null,5,"Introduce data fields into national incident data collection form, which describe objects hit off carriageway."]
[1,null,6,"Regularly review and improve the national incident data collection form."]
[1,3,"Data pon (RoR) crashes aren't reviewed"]
[1,null,1,"Regularly (ex. annually) review incident statistics to identify RoR issues."]
[1,null,2,"Regularly (ex. annually) review RSI findings to identify roadside safety issues."]
[1,null,3,"Regularly (ex. annually) review RSA findings to identify roadside safety issues."]
[1,null,4,"Regularly (ex. annually) review departures from standards to identify common  issues."]
[1,null,5,"Regularly (ex. annually) review in-depth on site incident data to identify RoR issues."]
[1,4,"Roadside Design Standard is out of date"]
[1,null,1,"Regularly (ex. annually) review roadside design standards to ensure consistency with other relevant design standards."]
[1,null,2,"Regularly (ex. annually) review roadside design standards to ensure identified issues are covered."]
[1,5,"There is no solution available for some issues"]
[1,null,1,"Undertake research programmes to develop bespoke solutions."]
[1,null,2,"Review international best practice to identify potential solutions."]
[1,null,3,"Regularly raise identified issues at relevant national and European Standards Committees to support development of solutions. "]
[1,6,"Some road users are not considered in the design standard"]
[1,null,1,"Ensure all requirements within the roadside design standard take powered two wheelers into consideration"]
[1,null,2,"Ensure all requirements within the roadside design standard take cyclists into consideration"]
[1,null,3,"Ensure all requirements within the roadside design standard take pedestrians into consideration"]
[1,null,4,"Ensure all requirements within the roadside design standard take heavy vehicles  into consideration"]
[1,7,"Some site constraints are not considered in the design standard"]
[1,null,1,"Ensure soil and foundation conditions are considered within the roadside design manual"]
[1,null,2,"Introduce requirements to ensure VRS are installed on as-tested soil conditions."]
[1,null,3,"Introduce BIM Level 2 approach so more information about the roadside, including all infrastructure in the vicinity are available at the design stage."]
[1,null,4,"Ensure installations on roadside surfaces (such as kerbs) take effective barrier height into consideration."]
[1,8,"Some VRS product constraints are not considered in the design standard"]
[1,null,1,"Introduce requirements to ensure VRS tested length are taken into consideration"]
[1,null,2,"Introduce requirements to ensure availability of approved transitions are taken into consideration"]
[1,null,3,"Introduce requirements to ensure availability of approved terminals are taken into consideration"]
[1,null,4,"Introduce requirements to ensure durability of VRS are taken into consideration, in relation to local climate"]
[1,null,5,"Introduce requirement to ensure vehicle intrusion is taken into consideration"]
[1,9,"Combined (negative) effects of standards aren't considered"]
[1,10,"Design standard is not followed (user errors)"]
[1,null,1,"Provide sufficient applied examples in the design guide / manual"]
[1,null,2,"Introduce a mandatory training programme for designers"]
[1,null,3,"Introduce mandatory road safety audit process at design stages"]
[1,11,"Insufficient internal design checks / peer review / risk and value analysis"]
[1,12,"Departures from Standard due to Site constraints"]
[1,null,1,"Create centralised data base for roadside related departures from standards."]
[1,null,2,"Regularly (ex. annually) review departures from standards to identify common  issues."]
[1,null,3,"Adjust the design standard accordingly to take recurring, common departures into account"]
[1,13,"Departures from Standard due to Product Availability "]
[1,null,1,"Create centralised data base for roadside related departures from standards."]
[1,null,2,"Regularly (ex. annually) review departures from standards to identify common  issues."]
[1,null,3,"Work with industry to incentivise development of commonly needed products, such as transitions"]
[1,14,"Departures from Standard due to Budget Constraints"]
[1,null,1,"Create centralised data base for roadside related departures from standards."]
[1,null,2,"Regularly (ex. annually) review departures from standards to identify common  issues."]
[1,null,3,"Adjust the design standard accordingly to take recurring, common departures into account"]
[1,null,4,"Report recurring departures to upper management with justification / data for further budget allocation."]
[1,15,"Design is not subject to RSA"]
[1,null,1,"Introduce requirement for mandatory design stage road safety audit process"]
[1,null,2,"Introduce requirements to ensure a design cannot proceed to implementation without RSA"]
[1,16,"Problem is not identified during RSA"]
[1,null,1,"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account "]
[1,null,2,"Introduce training for road safety auditors in issues specific to road side safety design"]
[1,null,3,"Ensure road safety auditors are qualified to the necessary standards"]
[1,17,"Recommendations from RSA are discarded / ignored"]
[1,18,"Installation errors"]
[1,null,1,"Introduce a mandatory training and certification programme for roadside infrastructure installers"]
[1,null,2,"Ensure infrastructure installers are qualified to the necessary standards"]
[1,null,3,"Introduce a procedure to enable reporting of cases where installers arrive to a site which isn't as described in the design"]
[1,19,"VRS provided on site is not the same as tested (material/design)"]
[1,null,1,"Introduce procedure for sampling and testing of material delivered on site"]
[1,null,2,"Introduce factory production control requirement for non-harmonised VRS products"]
[1,20,"Inadequate contract specifications and incentives"]
[1,21,"Insufficient site supervision"]
[1,22,"Installation is not subject to RSA"]
[1,null,1,"Introduce requirement for mandatory implementation stage road safety audit process"]
[1,23,"Problem is not identified during RSA"]
[1,null,1,"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account "]
[1,null,2,"Introduce training for road safety auditors in issues specific to road side safety design"]
[1,null,3,"Ensure road safety auditors are qualified to the necessary standards"]
[1,24,"Recommendations from RSA are discarded / ignored"]
[1,25,"Durability issues (corrosion, loose bolts, etc.)"]
[1,null,1,"Carry out regular road safety inspections"]
[1,null,2,"Consider prioritising VRS with better durability"]
[1,null,3,"Establish asset management system to manage VRS maintenance"]
[1,26,"Road environment changes (vegetation, erosion, new asphalt layer, etc.)"]
[1,null,1,"Carry out regular road safety inspections"]
[1,27,"Previous impact damage"]
[1,null,1,"Carry out regular road safety inspections"]
[1,null,2,"Establish a system through which public can report damage and defects"]
[1,null,3,"Consider prioritising VRS which can withstand consecutive impacts without need for repair"]
[1,28,"Changes to road and traffic conditions (speed limit, ADT, HGV%, new lanes)"]
[1,null,1,"Ensure there is a mandatory reassessment of roadside design when the speed limit is increased"]
[1,null,2,"Ensure there is a mandatory reassessment of roadside design when lane layouts are changed"]
[1,null,3,"Create a database of traffic conditions at the time of roadside design and regularly review with current traffic conditions"]
[1,29,"Vehicle fleet changes (increased mass, SUVs, etc.)"]
[1,null,1,"Regularly review vehicle fleet composition and assess its effects on VRS"]
[1,null,2,"Incentivise VRS manufacturers to develop systems which are compatible with modern vehicle types such as SUVs"]
[1,null,3,"Update European VRS standards to ensure impact test vehicles are representative of modern fleet"]
[1,null,4,"Monitor performance of historic VRS for real world impacts by modern vehicles"]
[1,30,"Inadequate maintenance plan"]
[1,31,"RSI is not carried out"]
[1,null,1,"Introduce mandatory road safety inspections"]
[1,32,"Problem occurred after last RSI"]
[1,null,1,"Increase frequency of road safety inspections"]
[1,33,"Problem is not identified during RSI"]
[1,null,1,"Introduce guidelines for RSIs to take common issues relating to roadside safety into account "]
[1,null,2,"Introduce training for road safety inspectors in issues specific to road side safety"]
[1,null,3,"Ensure road safety inspectors are qualified to the necessary standards"]
[1,null,4,"Ensure multiple road safety inspectors are assigned for each inspection"]
[1,34,"Problem identified in RSI is not fixed"]

{"sheet":"Sheet3","index":3,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Button number","Button text","Risk (0 Empty, 1 Low, 2 Med, 3 High)","# of CM applied","Priority (4 = Very High, 3= High, 2 = Medium, 1 = Low)","Countermeasure 1","Countermeasure 2","Countermeasure 3","Countermeasure 4","Countermeasure 5","Countermeasure 6","CM1 Y/N?","CM2 Y/N?","CM3 Y/N?","CM4 Y/N?","CM5 Y/N?","CM6 Y/N?",null,null,null,null,"Date of Asssessment:","dd/mm/yyyy"]
[2,"Data on (RoR) crashes aren't collected",0,{"$f":"SUM(L2:Q2)","v":0},{"$f":"IF((C2=3)*AND(D2=0),1,(IF((C2=3)*AND(D2=1),2,(IF((C2=3)*AND(D2>1),3,(IF((C2=2)*AND(D2=0),2,(IF((C2=2)*AND(D2=1),3,(IF((C2=2)*AND(D2>1),3,4)))))))))))","v":4},"Introduce RoR specific data fields to national incident data collection forms.","Introduce legal requirement for collection of RoR incident data at national level.","Incentivise collection of RoR incident data, by raising awareness to the benefits amongst traffic police.","Create centralised database for RSA findings.","Create centralised database for RSI findings.","Create centralised data base for roadside related departures from standards.",0,0,0,0,0,0,null,null,null,null,"Assessed by:","Please enter name"]
[3,"Data on (RoR) crashes aren't detailed enough",0,0,{"$f":"IF((C3=3)*AND(D3=0),1,(IF((C3=3)*AND(D3=1),2,(IF((C3=3)*AND(D3>1),3,(IF((C3=2)*AND(D3=0),2,(IF((C3=2)*AND(D3=1),3,(IF((C3=2)*AND(D3>1),3,4)))))))))))","v":4},"Establish in-depth on site incident data collection programme, such as RAIDS in the UK.","Introduce site photographs as part of national incident data collection procedure. ","Introduce sketch of the incident as part of national incident data collection form.","Introduce detailed written description of the incident as part of national data collection form.","Introduce data fields into national incident data collection form, which describe objects hit off carriageway.","Regularly review and improve the national incident data collection form.",0,0,0,0,0,0,null,null,null,null,"Organisation:","Please enter organisation"]
[4,"Data on (RoR) crashes aren't reviewed",0,0,4,"Regularly (ex. annually) review incident statistics to identify RoR issues.","Regularly (ex. annually) review RSI findings to identify roadside safety issues.","Regularly (ex. annually) review RSA findings to identify roadside safety issues.","Regularly (ex. annually) review departures from standards to identify common  issues.","Regularly (ex. annually) review in-depth on site incident data to identify RoR issues.","Other",0,0,0,0,0,0,null,null,null,null,"Assessed Area:","Please enter area under assessment"]
[5,"Roadside Design Standard is out of date",0,0,4,"Regularly (ex. annually) review roadside design standards to ensure consistency with other relevant design standards.","Regularly (ex. annually) review roadside design standards to ensure identified issues are covered.","Other",null,null,null,0,0,0,0,0,0,null,null,null,null,"RoR Crash Type:","All RoR"]
[6,"There is no solution available for some issues",0,0,4,"Undertake research programmes to develop bespoke solutions.","Review international best practice to identify potential solutions.","Regularly raise identified issues at relevant national and European Standards Committees to support development of solutions. ","Other",null,null,0,0,0,0,0,0]
[7,"Some road users are not considered in the design standard",0,0,4,"Ensure all requirements within the roadside design standard take powered two wheelers into consideration","Ensure all requirements within the roadside design standard take cyclists into consideration","Ensure all requirements within the roadside design standard take pedestrians into consideration","Ensure all requirements within the roadside design standard take heavy vehicles  into consideration","Other",null,0,0,0,0,0,0]
[8,"Some site constraints are not considered in the design standard",0,0,4,"Ensure soil and foundation conditions are considered within the roadside design manual","Introduce requirements to ensure VRS are installed on as-tested soil conditions.","Introduce BIM Level 2 approach so more information about the roadside, including all infrastructure in the vicinity are available at the design stage.","Ensure installations on roadside surfaces (such as kerbs) take effective barrier height into consideration.","Other",null,0,0,0,0,0,0]
[9,"Some VRS product constraints are not considered in the design standard",0,0,4,"Introduce requirements to ensure VRS tested length are taken into consideration","Introduce requirements to ensure availability of approved transitions are taken into consideration","Introduce requirements to ensure availability of approved terminals are taken into consideration","Introduce requirements to ensure durability of VRS are taken into consideration, in relation to local climate","Introduce requirement to ensure vehicle intrusion is taken into consideration","Other",0,0,0,0,0,0]
[10,"Combined (negative) effects of standards aren't considered",0,0,4,"Other",null,null,null,null,null,0,0,0,0,0,0]
[11,"Design standard is not followed (user errors)",3,0,1,"Provide sufficient applied examples in the design guide / manual","Introduce a mandatory training programme for designers","Introduce mandatory road safety audit process at design stages","Other",null,null,0,0,0,0,0,0]
[12,"Insufficient internal design checks / peer review / risk and value analysis",0,{"$f":"SUM(L12:Q12)","v":0},{"$f":"IF((C12=3)*AND(D12=0),1,(IF((C12=3)*AND(D12=1),2,(IF((C12=3)*AND(D12>1),3,(IF((C12=2)*AND(D12=0),2,(IF((C12=2)*AND(D12=1),3,(IF((C12=2)*AND(D12>1),3,4)))))))))))","v":4},"Other",null,null,null,null,null,0,0,0,0,0,0]
[13,"Departures from Standard due to Site constraints",0,0,4,"Create centralised data base for roadside related departures from standards.","Regularly (ex. annually) review departures from standards to identify common  issues.","Adjust the design standard accordingly to take recurring, common departures into account","Other",null,null,0,0,0,0,0,0]
[14,"Departures from Standard due to Product Availability ",0,0,4,"Create centralised data base for roadside related departures from standards.","Regularly (ex. annually) review departures from standards to identify common  issues.","Work with industry to incentivise development of commonly needed products, such as transitions","Other",null,null,0,0,0,0,0,0]
[15,"Departures from Standard due to Budget Constraints",0,0,4,"Create centralised data base for roadside related departures from standards.","Regularly (ex. annually) review departures from standards to identify common  issues.","Adjust the design standard accordingly to take recurring, common departures into account","Report recurring departures to upper management with justification / data for further budget allocation.","Other",null,0,0,0,0,0,0]
[16,"Design is not subject to RSA",0,0,4,"Introduce requirement for mandatory design stage road safety audit process","Introduce requirements to ensure a design cannot proceed to implementation without RSA","Other",null,null,null,0,0,0,0,0,0]
[17,"Problem is not identified during RSA",0,0,4,"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account ","Introduce training for road safety auditors in issues specific to road side safety design","Ensure road safety auditors are qualified to the necessary standards","Other",null,null,0,0,0,0,0,0]
[18,"Recommendations from RSA are discarded / ignored",0,0,4,"Other",null,null,null,null,null,0,0,0,0,0,0]
[19,"Implementation errors",0,0,4,"Introduce a mandatory training and certification programme for roadside infrastructure installers","Ensure infrastructure installers are qualified to the necessary standards","Introduce a procedure to enable reporting of cases where installers arrive to a site which isn't as described in the design","Other",null,null,0,0,0,0,0,0]
[20,"Products provided on site are not the same as tested (material/design)",0,{"$f":"SUM(L20:Q20)","v":0},{"$f":"IF((C20=3)*AND(D20=0),1,(IF((C20=3)*AND(D20=1),2,(IF((C20=3)*AND(D20>1),3,(IF((C20=2)*AND(D20=0),2,(IF((C20=2)*AND(D20=1),3,(IF((C20=2)*AND(D20>1),3,4)))))))))))","v":4},"Introduce procedure for sampling and testing of material delivered on site","Introduce factory production control requirement for non-harmonised VRS products","Other",null,null,null,0,0,0,0,0,0]
[21,"Inadequate contract specifications and incentives",0,{"$f":"SUM(L21:Q21)","v":0},{"$f":"IF((C21=3)*AND(D21=0),1,(IF((C21=3)*AND(D21=1),2,(IF((C21=3)*AND(D21>1),3,(IF((C21=2)*AND(D21=0),2,(IF((C21=2)*AND(D21=1),3,(IF((C21=2)*AND(D21>1),3,4)))))))))))","v":4},"Other",null,null,null,null,null,0,0,0,0,0,0]
[22,"Insufficient site supervision",0,{"$f":"SUM(L22:Q22)","v":0},{"$f":"IF((C22=3)*AND(D22=0),1,(IF((C22=3)*AND(D22=1),2,(IF((C22=3)*AND(D22>1),3,(IF((C22=2)*AND(D22=0),2,(IF((C22=2)*AND(D22=1),3,(IF((C22=2)*AND(D22>1),3,4)))))))))))","v":4},"Other",null,null,null,null,null,0,0,0,0,0,0]
[23,"Implementation is not subject to RSA",0,0,4,"Introduce requirement for mandatory implementation stage road safety audit process","Other",null,null,null,null,0,0,0,0,0,0]
[24,"Problem is not identified during RSA",0,0,4,"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account ","Introduce training for road safety auditors in issues specific to road side safety design","Ensure road safety auditors are qualified to the necessary standards","Other",null,null,0,0,0,0,0,0]
[25,"Recommendations from RSA are discarded / ignored",0,{"$f":"SUM(L25:Q25)","v":0},{"$f":"IF((C25=3)*AND(D25=0),1,(IF((C25=3)*AND(D25=1),2,(IF((C25=3)*AND(D25>1),3,(IF((C25=2)*AND(D25=0),2,(IF((C25=2)*AND(D25=1),3,(IF((C25=2)*AND(D25>1),3,4)))))))))))","v":4},"Other",null,null,null,null,null,0,0,0,0,0,0]
[26,"Durability issues (corrosion, loose bolts, etc.)",0,0,4,"Carry out regular road safety inspections","Consider prioritising VRS with better durability","Establish asset management system to manage VRS maintenance","Other",null,null,0,0,0,0,0,0]
[27,"Road environment changes (vegetation, erosion, new asphalt layer, etc.)",0,0,4,"Carry out regular road safety inspections","Other",null,null,null,null,0,0,0,0,0,0]
[28,"Previous impact damage",0,0,4,"Carry out regular road safety inspections","Establish a system through which public can report damage and defects","Consider prioritising VRS which can withstand consecutive impacts without need for repair","Other",null,null,0,0,0,0,0,0]
[29,"Changes to road and traffic conditions (speed limit, ADT, HGV%, new lanes)",0,{"$f":"SUM(L29:Q29)","v":0},4,"Ensure there is a mandatory reassessment of roadside design when the speed limit is increased","Ensure there is a mandatory reassessment of roadside design when lane layouts are changed","Create a database of traffic conditions at the time of roadside design and regularly review with current traffic conditions","Other",null,null,0,0,0,0,0,0]
[30,"Vehicle fleet changes (increased mass, SUVs, etc.)",0,{"$f":"SUM(L30:Q30)","v":0},4,"Regularly review vehicle fleet composition and assess its effects on VRS","Incentivise VRS manufacturers to develop systems which are compatible with modern vehicle types such as SUVs","Update European VRS standards to ensure impact test vehicles are representative of modern fleet","Monitor performance of historic VRS for real world impacts by modern vehicles","Other",null,0,0,0,0,0,0]
[31,"Inadequate maintenance plan",0,{"$f":"SUM(L31:Q31)","v":0},{"$f":"IF((C31=3)*AND(D31=0),1,(IF((C31=3)*AND(D31=1),2,(IF((C31=3)*AND(D31>1),3,(IF((C31=2)*AND(D31=0),2,(IF((C31=2)*AND(D31=1),3,(IF((C31=2)*AND(D31>1),3,4)))))))))))","v":4},"Other",null,null,null,null,null,0,0,0,0,0,0]
[32,"RSI is not carried out",0,0,4,"Introduce mandatory road safety inspections","Other",null,null,null,null,0,0,0,0,0,0]
[33,"Problem occurred after last RSI",0,0,4,"Increase frequency of road safety inspections","Other",null,null,null,null,0,0,0,0,0,0]
[34,"Problem is not identified during RSI",0,0,4,"Introduce guidelines for RSIs to take common issues relating to roadside safety into account ","Introduce training for road safety inspectors in issues specific to road side safety","Ensure road safety inspectors are qualified to the necessary standards","Ensure multiple road safety inspectors are assigned for each inspection","Other",null,0,0,0,0,0,0]
[35,"Problem identified in RSI is not fixed",0,0,4,"Other",null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Recommendations","index":4,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,0,1,0],[0,6,0,11],[0,4,1,4],[0,5,1,5],[0,3,1,3],[0,2,1,2]]}
["Button no","Problem","Priority (0 Empty, 1 Low, 2 Med, 3 High)","# of Countermeasures applied","Priority (4 = Very High, 3= High, 2 = Medium, 1 = Low)","CM Use","Recommended alternative countermeasures"]
[null,null,null,null,null,null,1,2,3,4,5,6]
[2,"Data on (RoR) crashes aren't collected",{"$f":"Sheet3!C2","v":0},{"$f":"Sheet3!D2","v":0},{"$f":"IF((C3=3)*AND(D3=0),1,(IF((C3=3)*AND(D3=1),2,(IF((C3=3)*AND(D3>1),3,(IF((C3=2)*AND(D3=0),2,(IF((C3=2)*AND(D3=1),3,(IF((C3=2)*AND(D3>1),3,4)))))))))))","v":4},null,{"$f":"IF(Sheet3!L2=0,Sheet3!F2,\"\")","v":"Introduce RoR specific data fields to national incident data collection forms."},{"$f":"IF(Sheet3!M2=0,Sheet3!G2,\"\")","v":"Introduce legal requirement for collection of RoR incident data at national level."},{"$f":"IF(Sheet3!N2=0,Sheet3!H2,\"\")","v":"Incentivise collection of RoR incident data, by raising awareness to the benefits amongst traffic police."},{"$f":"IF(Sheet3!O2=0,Sheet3!I2,\"\")","v":"Create centralised database for RSA findings."},{"$f":"IF(Sheet3!P2=0,Sheet3!J2,\"\")","v":"Create centralised database for RSI findings."},{"$f":"IF(Sheet3!Q2=0,Sheet3!K2,\"\")","v":"Create centralised data base for roadside related departures from standards."}]
[3,"Data on (RoR) crashes aren't detailed enough",{"$f":"Sheet3!C3","v":0},{"$f":"Sheet3!D3","v":0},4,null,{"$f":"IF(Sheet3!L3=0,Sheet3!F3,\"\")","v":"Establish in-depth on site incident data collection programme, such as RAIDS in the UK."},{"$f":"IF(Sheet3!M3=0,Sheet3!G3,\"\")","v":"Introduce site photographs as part of national incident data collection procedure. "},{"$f":"IF(Sheet3!N3=0,Sheet3!H3,\"\")","v":"Introduce sketch of the incident as part of national incident data collection form."},{"$f":"IF(Sheet3!O3=0,Sheet3!I3,\"\")","v":"Introduce detailed written description of the incident as part of national data collection form."},{"$f":"IF(Sheet3!P3=0,Sheet3!J3,\"\")","v":"Introduce data fields into national incident data collection form, which describe objects hit off carriageway."},{"$f":"IF(Sheet3!Q3=0,Sheet3!K3,\"\")","v":"Regularly review and improve the national incident data collection form."}]
[4,"Data pon (RoR) crashes aren't reviewed",{"$f":"Sheet3!C4","v":0},{"$f":"Sheet3!D4","v":0},4,null,{"$f":"IF(Sheet3!L4=0,Sheet3!F4,\"\")","v":"Regularly (ex. annually) review incident statistics to identify RoR issues."},{"$f":"IF(Sheet3!M4=0,Sheet3!G4,\"\")","v":"Regularly (ex. annually) review RSI findings to identify roadside safety issues."},{"$f":"IF(Sheet3!N4=0,Sheet3!H4,\"\")","v":"Regularly (ex. annually) review RSA findings to identify roadside safety issues."},{"$f":"IF(Sheet3!O4=0,Sheet3!I4,\"\")","v":"Regularly (ex. annually) review departures from standards to identify common  issues."},{"$f":"IF(Sheet3!P4=0,Sheet3!J4,\"\")","v":"Regularly (ex. annually) review in-depth on site incident data to identify RoR issues."},{"$f":"IF(Sheet3!Q4=0,Sheet3!K4,\"\")","v":"Other"}]
[5,"Roadside Design Standard is out of date",{"$f":"Sheet3!C5","v":0},{"$f":"Sheet3!D5","v":0},4,null,{"$f":"IF(Sheet3!L5=0,Sheet3!F5,\"\")","v":"Regularly (ex. annually) review roadside design standards to ensure consistency with other relevant design standards."},{"$f":"IF(Sheet3!M5=0,Sheet3!G5,\"\")","v":"Regularly (ex. annually) review roadside design standards to ensure identified issues are covered."},{"$f":"IF(Sheet3!N5=0,Sheet3!H5,\"\")","v":"Other"},{"$f":"IF(Sheet3!O5=0,Sheet3!I5,\"\")","v":0},{"$f":"IF(Sheet3!P5=0,Sheet3!J5,\"\")","v":0},{"$f":"IF(Sheet3!Q5=0,Sheet3!K5,\"\")","v":0}]
[6,"There is no solution available for some issues",{"$f":"Sheet3!C6","v":0},{"$f":"Sheet3!D6","v":0},4,null,{"$f":"IF(Sheet3!L6=0,Sheet3!F6,\"\")","v":"Undertake research programmes to develop bespoke solutions."},{"$f":"IF(Sheet3!M6=0,Sheet3!G6,\"\")","v":"Review international best practice to identify potential solutions."},{"$f":"IF(Sheet3!N6=0,Sheet3!H6,\"\")","v":"Regularly raise identified issues at relevant national and European Standards Committees to support development of solutions. "},{"$f":"IF(Sheet3!O6=0,Sheet3!I6,\"\")","v":"Other"},{"$f":"IF(Sheet3!P6=0,Sheet3!J6,\"\")","v":0},{"$f":"IF(Sheet3!Q6=0,Sheet3!K6,\"\")","v":0}]
[7,"Some road users are not considered in the design standard",{"$f":"Sheet3!C7","v":0},{"$f":"Sheet3!D7","v":0},4,null,{"$f":"IF(Sheet3!L7=0,Sheet3!F7,\"\")","v":"Ensure all requirements within the roadside design standard take powered two wheelers into consideration"},{"$f":"IF(Sheet3!M7=0,Sheet3!G7,\"\")","v":"Ensure all requirements within the roadside design standard take cyclists into consideration"},{"$f":"IF(Sheet3!N7=0,Sheet3!H7,\"\")","v":"Ensure all requirements within the roadside design standard take pedestrians into consideration"},{"$f":"IF(Sheet3!O7=0,Sheet3!I7,\"\")","v":"Ensure all requirements within the roadside design standard take heavy vehicles  into consideration"},{"$f":"IF(Sheet3!P7=0,Sheet3!J7,\"\")","v":"Other"},{"$f":"IF(Sheet3!Q7=0,Sheet3!K7,\"\")","v":0}]
[8,"Some site constraints are not considered in the design standard",{"$f":"Sheet3!C8","v":0},{"$f":"Sheet3!D8","v":0},4,null,{"$f":"IF(Sheet3!L8=0,Sheet3!F8,\"\")","v":"Ensure soil and foundation conditions are considered within the roadside design manual"},{"$f":"IF(Sheet3!M8=0,Sheet3!G8,\"\")","v":"Introduce requirements to ensure VRS are installed on as-tested soil conditions."},{"$f":"IF(Sheet3!N8=0,Sheet3!H8,\"\")","v":"Introduce BIM Level 2 approach so more information about the roadside, including all infrastructure in the vicinity are available at the design stage."},{"$f":"IF(Sheet3!O8=0,Sheet3!I8,\"\")","v":"Ensure installations on roadside surfaces (such as kerbs) take effective barrier height into consideration."},{"$f":"IF(Sheet3!P8=0,Sheet3!J8,\"\")","v":"Other"},{"$f":"IF(Sheet3!Q8=0,Sheet3!K8,\"\")","v":0}]
[9,"Some VRS product constraints are not considered in the design standard",{"$f":"Sheet3!C9","v":0},{"$f":"Sheet3!D9","v":0},4,null,{"$f":"IF(Sheet3!L9=0,Sheet3!F9,\"\")","v":"Introduce requirements to ensure VRS tested length are taken into consideration"},{"$f":"IF(Sheet3!M9=0,Sheet3!G9,\"\")","v":"Introduce requirements to ensure availability of approved transitions are taken into consideration"},{"$f":"IF(Sheet3!N9=0,Sheet3!H9,\"\")","v":"Introduce requirements to ensure availability of approved terminals are taken into consideration"},{"$f":"IF(Sheet3!O9=0,Sheet3!I9,\"\")","v":"Introduce requirements to ensure durability of VRS are taken into consideration, in relation to local climate"},{"$f":"IF(Sheet3!P9=0,Sheet3!J9,\"\")","v":"Introduce requirement to ensure vehicle intrusion is taken into consideration"},{"$f":"IF(Sheet3!Q9=0,Sheet3!K9,\"\")","v":"Other"}]
[10,"Combined (negative) effects of standards aren't considered",{"$f":"Sheet3!C10","v":0},{"$f":"Sheet3!D10","v":0},4,null,{"$f":"IF(Sheet3!L10=0,Sheet3!F10,\"\")","v":"Other"},{"$f":"IF(Sheet3!M10=0,Sheet3!G10,\"\")","v":0},{"$f":"IF(Sheet3!N10=0,Sheet3!H10,\"\")","v":0},{"$f":"IF(Sheet3!O10=0,Sheet3!I10,\"\")","v":0},{"$f":"IF(Sheet3!P10=0,Sheet3!J10,\"\")","v":0},{"$f":"IF(Sheet3!Q10=0,Sheet3!K10,\"\")","v":0}]
[11,"Design standard is not followed (user errors)",{"$f":"Sheet3!C11","v":3},{"$f":"Sheet3!D11","v":0},1,null,{"$f":"IF(Sheet3!L11=0,Sheet3!F11,\"\")","v":"Provide sufficient applied examples in the design guide / manual"},{"$f":"IF(Sheet3!M11=0,Sheet3!G11,\"\")","v":"Introduce a mandatory training programme for designers"},{"$f":"IF(Sheet3!N11=0,Sheet3!H11,\"\")","v":"Introduce mandatory road safety audit process at design stages"},{"$f":"IF(Sheet3!O11=0,Sheet3!I11,\"\")","v":"Other"},{"$f":"IF(Sheet3!P11=0,Sheet3!J11,\"\")","v":0},{"$f":"IF(Sheet3!Q11=0,Sheet3!K11,\"\")","v":0}]
[12,"Insufficient internal design checks / peer review / risk and value analysis",{"$f":"Sheet3!C12","v":0},{"$f":"Sheet3!D12","v":0},4,null,{"$f":"IF(Sheet3!L12=0,Sheet3!F12,\"\")","v":"Other"},{"$f":"IF(Sheet3!M12=0,Sheet3!G12,\"\")","v":0},{"$f":"IF(Sheet3!N12=0,Sheet3!H12,\"\")","v":0},{"$f":"IF(Sheet3!O12=0,Sheet3!I12,\"\")","v":0},{"$f":"IF(Sheet3!P12=0,Sheet3!J12,\"\")","v":0},{"$f":"IF(Sheet3!Q12=0,Sheet3!K12,\"\")","v":0}]
[13,"Departures from Standard due to Site constraints",{"$f":"Sheet3!C13","v":0},{"$f":"Sheet3!D13","v":0},4,null,{"$f":"IF(Sheet3!L13=0,Sheet3!F13,\"\")","v":"Create centralised data base for roadside related departures from standards."},{"$f":"IF(Sheet3!M13=0,Sheet3!G13,\"\")","v":"Regularly (ex. annually) review departures from standards to identify common  issues."},{"$f":"IF(Sheet3!N13=0,Sheet3!H13,\"\")","v":"Adjust the design standard accordingly to take recurring, common departures into account"},{"$f":"IF(Sheet3!O13=0,Sheet3!I13,\"\")","v":"Other"},{"$f":"IF(Sheet3!P13=0,Sheet3!J13,\"\")","v":0},{"$f":"IF(Sheet3!Q13=0,Sheet3!K13,\"\")","v":0}]
[14,"Departures from Standard due to Product Availability ",{"$f":"Sheet3!C14","v":0},{"$f":"Sheet3!D14","v":0},4,null,{"$f":"IF(Sheet3!L14=0,Sheet3!F14,\"\")","v":"Create centralised data base for roadside related departures from standards."},{"$f":"IF(Sheet3!M14=0,Sheet3!G14,\"\")","v":"Regularly (ex. annually) review departures from standards to identify common  issues."},{"$f":"IF(Sheet3!N14=0,Sheet3!H14,\"\")","v":"Work with industry to incentivise development of commonly needed products, such as transitions"},{"$f":"IF(Sheet3!O14=0,Sheet3!I14,\"\")","v":"Other"},{"$f":"IF(Sheet3!P14=0,Sheet3!J14,\"\")","v":0},{"$f":"IF(Sheet3!Q14=0,Sheet3!K14,\"\")","v":0}]
[15,"Departures from Standard due to Budget Constraints",{"$f":"Sheet3!C15","v":0},{"$f":"Sheet3!D15","v":0},4,null,{"$f":"IF(Sheet3!L15=0,Sheet3!F15,\"\")","v":"Create centralised data base for roadside related departures from standards."},{"$f":"IF(Sheet3!M15=0,Sheet3!G15,\"\")","v":"Regularly (ex. annually) review departures from standards to identify common  issues."},{"$f":"IF(Sheet3!N15=0,Sheet3!H15,\"\")","v":"Adjust the design standard accordingly to take recurring, common departures into account"},{"$f":"IF(Sheet3!O15=0,Sheet3!I15,\"\")","v":"Report recurring departures to upper management with justification / data for further budget allocation."},{"$f":"IF(Sheet3!P15=0,Sheet3!J15,\"\")","v":"Other"},{"$f":"IF(Sheet3!Q15=0,Sheet3!K15,\"\")","v":0}]
[16,"Design is not subject to RSA",{"$f":"Sheet3!C16","v":0},{"$f":"Sheet3!D16","v":0},4,null,{"$f":"IF(Sheet3!L16=0,Sheet3!F16,\"\")","v":"Introduce requirement for mandatory design stage road safety audit process"},{"$f":"IF(Sheet3!M16=0,Sheet3!G16,\"\")","v":"Introduce requirements to ensure a design cannot proceed to implementation without RSA"},{"$f":"IF(Sheet3!N16=0,Sheet3!H16,\"\")","v":"Other"},{"$f":"IF(Sheet3!O16=0,Sheet3!I16,\"\")","v":0},{"$f":"IF(Sheet3!P16=0,Sheet3!J16,\"\")","v":0},{"$f":"IF(Sheet3!Q16=0,Sheet3!K16,\"\")","v":0}]
[17,"Problem is not identified during RSA",{"$f":"Sheet3!C17","v":0},{"$f":"Sheet3!D17","v":0},4,null,{"$f":"IF(Sheet3!L17=0,Sheet3!F17,\"\")","v":"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account "},{"$f":"IF(Sheet3!M17=0,Sheet3!G17,\"\")","v":"Introduce training for road safety auditors in issues specific to road side safety design"},{"$f":"IF(Sheet3!N17=0,Sheet3!H17,\"\")","v":"Ensure road safety auditors are qualified to the necessary standards"},{"$f":"IF(Sheet3!O17=0,Sheet3!I17,\"\")","v":"Other"},{"$f":"IF(Sheet3!P17=0,Sheet3!J17,\"\")","v":0},{"$f":"IF(Sheet3!Q17=0,Sheet3!K17,\"\")","v":0}]
[18,"Recommendations from RSA are discarded / ignored",{"$f":"Sheet3!C18","v":0},{"$f":"Sheet3!D18","v":0},4,null,{"$f":"IF(Sheet3!L18=0,Sheet3!F18,\"\")","v":"Other"},{"$f":"IF(Sheet3!M18=0,Sheet3!G18,\"\")","v":0},{"$f":"IF(Sheet3!N18=0,Sheet3!H18,\"\")","v":0},{"$f":"IF(Sheet3!O18=0,Sheet3!I18,\"\")","v":0},{"$f":"IF(Sheet3!P18=0,Sheet3!J18,\"\")","v":0},{"$f":"IF(Sheet3!Q18=0,Sheet3!K18,\"\")","v":0}]
[19,"Installation errors",{"$f":"Sheet3!C19","v":0},{"$f":"Sheet3!D19","v":0},4,null,{"$f":"IF(Sheet3!L19=0,Sheet3!F19,\"\")","v":"Introduce a mandatory training and certification programme for roadside infrastructure installers"},{"$f":"IF(Sheet3!M19=0,Sheet3!G19,\"\")","v":"Ensure infrastructure installers are qualified to the necessary standards"},{"$f":"IF(Sheet3!N19=0,Sheet3!H19,\"\")","v":"Introduce a procedure to enable reporting of cases where installers arrive to a site which isn't as described in the design"},{"$f":"IF(Sheet3!O19=0,Sheet3!I19,\"\")","v":"Other"},{"$f":"IF(Sheet3!P19=0,Sheet3!J19,\"\")","v":0},{"$f":"IF(Sheet3!Q19=0,Sheet3!K19,\"\")","v":0}]
[20,"VRS provided on site is not the same as tested (material/design)",{"$f":"Sheet3!C20","v":0},{"$f":"Sheet3!D20","v":0},4,null,{"$f":"IF(Sheet3!L20=0,Sheet3!F20,\"\")","v":"Introduce procedure for sampling and testing of material delivered on site"},{"$f":"IF(Sheet3!M20=0,Sheet3!G20,\"\")","v":"Introduce factory production control requirement for non-harmonised VRS products"},{"$f":"IF(Sheet3!N20=0,Sheet3!H20,\"\")","v":"Other"},{"$f":"IF(Sheet3!O20=0,Sheet3!I20,\"\")","v":0},{"$f":"IF(Sheet3!P20=0,Sheet3!J20,\"\")","v":0},{"$f":"IF(Sheet3!Q20=0,Sheet3!K20,\"\")","v":0}]
[21,"Inadequate contract specifications and incentives",{"$f":"Sheet3!C21","v":0},{"$f":"Sheet3!D21","v":0},4,null,{"$f":"IF(Sheet3!L21=0,Sheet3!F21,\"\")","v":"Other"},{"$f":"IF(Sheet3!M21=0,Sheet3!G21,\"\")","v":0},{"$f":"IF(Sheet3!N21=0,Sheet3!H21,\"\")","v":0},{"$f":"IF(Sheet3!O21=0,Sheet3!I21,\"\")","v":0},{"$f":"IF(Sheet3!P21=0,Sheet3!J21,\"\")","v":0},{"$f":"IF(Sheet3!Q21=0,Sheet3!K21,\"\")","v":0}]
[22,"Insufficient site supervision",{"$f":"Sheet3!C22","v":0},{"$f":"Sheet3!D22","v":0},4,null,{"$f":"IF(Sheet3!L22=0,Sheet3!F22,\"\")","v":"Other"},{"$f":"IF(Sheet3!M22=0,Sheet3!G22,\"\")","v":0},{"$f":"IF(Sheet3!N22=0,Sheet3!H22,\"\")","v":0},{"$f":"IF(Sheet3!O22=0,Sheet3!I22,\"\")","v":0},{"$f":"IF(Sheet3!P22=0,Sheet3!J22,\"\")","v":0},{"$f":"IF(Sheet3!Q22=0,Sheet3!K22,\"\")","v":0}]
[23,"Installation is not subject to RSA",{"$f":"Sheet3!C23","v":0},{"$f":"Sheet3!D23","v":0},4,null,{"$f":"IF(Sheet3!L23=0,Sheet3!F23,\"\")","v":"Introduce requirement for mandatory implementation stage road safety audit process"},{"$f":"IF(Sheet3!M23=0,Sheet3!G23,\"\")","v":"Other"},{"$f":"IF(Sheet3!N23=0,Sheet3!H23,\"\")","v":0},{"$f":"IF(Sheet3!O23=0,Sheet3!I23,\"\")","v":0},{"$f":"IF(Sheet3!P23=0,Sheet3!J23,\"\")","v":0},{"$f":"IF(Sheet3!Q23=0,Sheet3!K23,\"\")","v":0}]
[24,"Problem is not identified during RSA",{"$f":"Sheet3!C24","v":0},{"$f":"Sheet3!D24","v":0},4,null,{"$f":"IF(Sheet3!L24=0,Sheet3!F24,\"\")","v":"Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account "},{"$f":"IF(Sheet3!M24=0,Sheet3!G24,\"\")","v":"Introduce training for road safety auditors in issues specific to road side safety design"},{"$f":"IF(Sheet3!N24=0,Sheet3!H24,\"\")","v":"Ensure road safety auditors are qualified to the necessary standards"},{"$f":"IF(Sheet3!O24=0,Sheet3!I24,\"\")","v":"Other"},{"$f":"IF(Sheet3!P24=0,Sheet3!J24,\"\")","v":0},{"$f":"IF(Sheet3!Q24=0,Sheet3!K24,\"\")","v":0}]
[25,"Recommendations from RSA are discarded / ignored",{"$f":"Sheet3!C25","v":0},{"$f":"Sheet3!D25","v":0},4,null,{"$f":"IF(Sheet3!L25=0,Sheet3!F25,\"\")","v":"Other"},{"$f":"IF(Sheet3!M25=0,Sheet3!G25,\"\")","v":0},{"$f":"IF(Sheet3!N25=0,Sheet3!H25,\"\")","v":0},{"$f":"IF(Sheet3!O25=0,Sheet3!I25,\"\")","v":0},{"$f":"IF(Sheet3!P25=0,Sheet3!J25,\"\")","v":0},{"$f":"IF(Sheet3!Q25=0,Sheet3!K25,\"\")","v":0}]
[26,"Durability issues (corrosion, loose bolts, etc.)",{"$f":"Sheet3!C26","v":0},{"$f":"Sheet3!D26","v":0},4,null,{"$f":"IF(Sheet3!L26=0,Sheet3!F26,\"\")","v":"Carry out regular road safety inspections"},{"$f":"IF(Sheet3!M26=0,Sheet3!G26,\"\")","v":"Consider prioritising VRS with better durability"},{"$f":"IF(Sheet3!N26=0,Sheet3!H26,\"\")","v":"Establish asset management system to manage VRS maintenance"},{"$f":"IF(Sheet3!O26=0,Sheet3!I26,\"\")","v":"Other"},{"$f":"IF(Sheet3!P26=0,Sheet3!J26,\"\")","v":0},{"$f":"IF(Sheet3!Q26=0,Sheet3!K26,\"\")","v":0}]
[27,"Road environment changes (vegetation, erosion, new asphalt layer, etc.)",{"$f":"Sheet3!C27","v":0},{"$f":"Sheet3!D27","v":0},4,null,{"$f":"IF(Sheet3!L27=0,Sheet3!F27,\"\")","v":"Carry out regular road safety inspections"},{"$f":"IF(Sheet3!M27=0,Sheet3!G27,\"\")","v":"Other"},{"$f":"IF(Sheet3!N27=0,Sheet3!H27,\"\")","v":0},{"$f":"IF(Sheet3!O27=0,Sheet3!I27,\"\")","v":0},{"$f":"IF(Sheet3!P27=0,Sheet3!J27,\"\")","v":0},{"$f":"IF(Sheet3!Q27=0,Sheet3!K27,\"\")","v":0}]
[28,"Previous impact damage",{"$f":"Sheet3!C28","v":0},{"$f":"Sheet3!D28","v":0},4,null,{"$f":"IF(Sheet3!L28=0,Sheet3!F28,\"\")","v":"Carry out regular road safety inspections"},{"$f":"IF(Sheet3!M28=0,Sheet3!G28,\"\")","v":"Establish a system through which public can report damage and defects"},{"$f":"IF(Sheet3!N28=0,Sheet3!H28,\"\")","v":"Consider prioritising VRS which can withstand consecutive impacts without need for repair"},{"$f":"IF(Sheet3!O28=0,Sheet3!I28,\"\")","v":"Other"},{"$f":"IF(Sheet3!P28=0,Sheet3!J28,\"\")","v":0},{"$f":"IF(Sheet3!Q28=0,Sheet3!K28,\"\")","v":0}]
[29,"Changes to road and traffic conditions (speed limit, ADT, HGV%, new lanes)",{"$f":"Sheet3!C29","v":0},{"$f":"Sheet3!D29","v":0},4,null,{"$f":"IF(Sheet3!L29=0,Sheet3!F29,\"\")","v":"Ensure there is a mandatory reassessment of roadside design when the speed limit is increased"},{"$f":"IF(Sheet3!M29=0,Sheet3!G29,\"\")","v":"Ensure there is a mandatory reassessment of roadside design when lane layouts are changed"},{"$f":"IF(Sheet3!N29=0,Sheet3!H29,\"\")","v":"Create a database of traffic conditions at the time of roadside design and regularly review with current traffic conditions"},{"$f":"IF(Sheet3!O29=0,Sheet3!I29,\"\")","v":"Other"},{"$f":"IF(Sheet3!P29=0,Sheet3!J29,\"\")","v":0},{"$f":"IF(Sheet3!Q29=0,Sheet3!K29,\"\")","v":0}]
[30,"Vehicle fleet changes (increased mass, SUVs, etc.)",{"$f":"Sheet3!C30","v":0},{"$f":"Sheet3!D30","v":0},4,null,{"$f":"IF(Sheet3!L30=0,Sheet3!F30,\"\")","v":"Regularly review vehicle fleet composition and assess its effects on VRS"},{"$f":"IF(Sheet3!M30=0,Sheet3!G30,\"\")","v":"Incentivise VRS manufacturers to develop systems which are compatible with modern vehicle types such as SUVs"},{"$f":"IF(Sheet3!N30=0,Sheet3!H30,\"\")","v":"Update European VRS standards to ensure impact test vehicles are representative of modern fleet"},{"$f":"IF(Sheet3!O30=0,Sheet3!I30,\"\")","v":"Monitor performance of historic VRS for real world impacts by modern vehicles"},{"$f":"IF(Sheet3!P30=0,Sheet3!J30,\"\")","v":"Other"},{"$f":"IF(Sheet3!Q30=0,Sheet3!K30,\"\")","v":0}]
[31,"Inadequate maintenance plan",{"$f":"Sheet3!C31","v":0},{"$f":"Sheet3!D31","v":0},4,null,{"$f":"IF(Sheet3!L31=0,Sheet3!F31,\"\")","v":"Other"},{"$f":"IF(Sheet3!M31=0,Sheet3!G31,\"\")","v":0},{"$f":"IF(Sheet3!N31=0,Sheet3!H31,\"\")","v":0},{"$f":"IF(Sheet3!O31=0,Sheet3!I31,\"\")","v":0},{"$f":"IF(Sheet3!P31=0,Sheet3!J31,\"\")","v":0},{"$f":"IF(Sheet3!Q31=0,Sheet3!K31,\"\")","v":0}]
[32,"RSI is not carried out",{"$f":"Sheet3!C32","v":0},{"$f":"Sheet3!D32","v":0},4,null,{"$f":"IF(Sheet3!L32=0,Sheet3!F32,\"\")","v":"Introduce mandatory road safety inspections"},{"$f":"IF(Sheet3!M32=0,Sheet3!G32,\"\")","v":"Other"},{"$f":"IF(Sheet3!N32=0,Sheet3!H32,\"\")","v":0},{"$f":"IF(Sheet3!O32=0,Sheet3!I32,\"\")","v":0},{"$f":"IF(Sheet3!P32=0,Sheet3!J32,\"\")","v":0},{"$f":"IF(Sheet3!Q32=0,Sheet3!K32,\"\")","v":0}]
[33,"Problem occurred after last RSI",{"$f":"Sheet3!C33","v":0},{"$f":"Sheet3!D33","v":0},4,null,{"$f":"IF(Sheet3!L33=0,Sheet3!F33,\"\")","v":"Increase frequency of road safety inspections"},{"$f":"IF(Sheet3!M33=0,Sheet3!G33,\"\")","v":"Other"},{"$f":"IF(Sheet3!N33=0,Sheet3!H33,\"\")","v":0},{"$f":"IF(Sheet3!O33=0,Sheet3!I33,\"\")","v":0},{"$f":"IF(Sheet3!P33=0,Sheet3!J33,\"\")","v":0},{"$f":"IF(Sheet3!Q33=0,Sheet3!K33,\"\")","v":0}]
[34,"Problem is not identified during RSI",{"$f":"Sheet3!C34","v":0},{"$f":"Sheet3!D34","v":0},4,null,{"$f":"IF(Sheet3!L34=0,Sheet3!F34,\"\")","v":"Introduce guidelines for RSIs to take common issues relating to roadside safety into account "},{"$f":"IF(Sheet3!M34=0,Sheet3!G34,\"\")","v":"Introduce training for road safety inspectors in issues specific to road side safety"},{"$f":"IF(Sheet3!N34=0,Sheet3!H34,\"\")","v":"Ensure road safety inspectors are qualified to the necessary standards"},{"$f":"IF(Sheet3!O34=0,Sheet3!I34,\"\")","v":"Ensure multiple road safety inspectors are assigned for each inspection"},{"$f":"IF(Sheet3!P34=0,Sheet3!J34,\"\")","v":"Other"},{"$f":"IF(Sheet3!Q34=0,Sheet3!K34,\"\")","v":0}]
[35,"Problem identified in RSI is not fixed",{"$f":"Sheet3!C35","v":0},{"$f":"Sheet3!D35","v":0},4,null,{"$f":"IF(Sheet3!L35=0,Sheet3!F35,\"\")","v":"Other"},{"$f":"IF(Sheet3!M35=0,Sheet3!G35,\"\")","v":0},{"$f":"IF(Sheet3!N35=0,Sheet3!H35,\"\")","v":0},{"$f":"IF(Sheet3!O35=0,Sheet3!I35,\"\")","v":0},{"$f":"IF(Sheet3!P35=0,Sheet3!J35,\"\")","v":0},{"$f":"IF(Sheet3!Q35=0,Sheet3!K35,\"\")","v":0}]

{"sheet":"Transpose For Lists","index":5,"n_rows":8,"n_cols":39,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Button No",2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39]
["Contributory Factor",{"$f":"TRANSPOSE(Sheet3!B2:B35)","v":"Data on (RoR) crashes aren't collected"},"Data on (RoR) crashes aren't detailed enough","Data on (RoR) crashes aren't reviewed","Roadside Design Standard is out of date","There is no solution available for some issues","Some road users are not considered in the design standard","Some site constraints are not considered in the design standard","Some VRS product constraints are not considered in the design standard","Combined (negative) effects of standards aren't considered","Design standard is not followed (user errors)","Insufficient internal design checks / peer review / risk and value analysis","Departures from Standard due to Site constraints","Departures from Standard due to Product Availability ","Departures from Standard due to Budget Constraints","Design is not subject to RSA","Problem is not identified during RSA","Recommendations from RSA are discarded / ignored","Implementation errors","Products provided on site are not the same as tested (material/design)","Inadequate contract specifications and incentives","Insufficient site supervision","Implementation is not subject to RSA","Problem is not identified during RSA","Recommendations from RSA are discarded / ignored","Durability issues (corrosion, loose bolts, etc.)","Road environment changes (vegetation, erosion, new asphalt layer, etc.)","Previous impact damage","Changes to road and traffic conditions (speed limit, ADT, HGV%, new lanes)","Vehicle fleet changes (increased mass, SUVs, etc.)","Inadequate maintenance plan","RSI is not carried out","Problem occurred after last RSI","Problem is not identified during RSI","Problem identified in RSI is not fixed",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Counter Measure 1",{"$f":"TRANSPOSE(Sheet3!F2:K35)","v":"Introduce RoR specific data fields to national incident data collection forms."},"Establish in-depth on site incident data collection programme, such as RAIDS in the UK.","Regularly (ex. annually) review incident statistics to identify RoR issues.","Regularly (ex. annually) review roadside design standards to ensure consistency with other relevant design standards.","Undertake research programmes to develop bespoke solutions.","Ensure all requirements within the roadside design standard take powered two wheelers into consideration","Ensure soil and foundation conditions are considered within the roadside design manual","Introduce requirements to ensure VRS tested length are taken into consideration","Other","Provide sufficient applied examples in the design guide / manual","Other","Create centralised data base for roadside related departures from standards.","Create centralised data base for roadside related departures from standards.","Create centralised data base for roadside related departures from standards.","Introduce requirement for mandatory design stage road safety audit process","Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account ","Other","Introduce a mandatory training and certification programme for roadside infrastructure installers","Introduce procedure for sampling and testing of material delivered on site","Other","Other","Introduce requirement for mandatory implementation stage road safety audit process","Introduce guidelines for RSAs to take common issues relating to the latest roadside safety requirements into account ","Other","Carry out regular road safety inspections","Carry out regular road safety inspections","Carry out regular road safety inspections","Ensure there is a mandatory reassessment of roadside design when the speed limit is increased","Regularly review vehicle fleet composition and assess its effects on VRS","Other","Introduce mandatory road safety inspections","Increase frequency of road safety inspections","Introduce guidelines for RSIs to take common issues relating to roadside safety into account ","Other"]
["Counter Measure 2","Introduce legal requirement for collection of RoR incident data at national level.","Introduce site photographs as part of national incident data collection procedure. ","Regularly (ex. annually) review RSI findings to identify roadside safety issues.","Regularly (ex. annually) review roadside design standards to ensure identified issues are covered.","Review international best practice to identify potential solutions.","Ensure all requirements within the roadside design standard take cyclists into consideration","Introduce requirements to ensure VRS are installed on as-tested soil conditions.","Introduce requirements to ensure availability of approved transitions are taken into consideration",0,"Introduce a mandatory training programme for designers",0,"Regularly (ex. annually) review departures from standards to identify common  issues.","Regularly (ex. annually) review departures from standards to identify common  issues.","Regularly (ex. annually) review departures from standards to identify common  issues.","Introduce requirements to ensure a design cannot proceed to implementation without RSA","Introduce training for road safety auditors in issues specific to road side safety design",0,"Ensure infrastructure installers are qualified to the necessary standards","Introduce factory production control requirement for non-harmonised VRS products",0,0,"Other","Introduce training for road safety auditors in issues specific to road side safety design",0,"Consider prioritising VRS with better durability","Other","Establish a system through which public can report damage and defects","Ensure there is a mandatory reassessment of roadside design when lane layouts are changed","Incentivise VRS manufacturers to develop systems which are compatible with modern vehicle types such as SUVs",0,"Other","Other","Introduce training for road safety inspectors in issues specific to road side safety"]
["Counter Measure 3","Incentivise collection of RoR incident data, by raising awareness to the benefits amongst traffic police.","Introduce sketch of the incident as part of national incident data collection form.","Regularly (ex. annually) review RSA findings to identify roadside safety issues.","Other","Regularly raise identified issues at relevant national and European Standards Committees to support development of solutions. ","Ensure all requirements within the roadside design standard take pedestrians into consideration","Introduce BIM Level 2 approach so more information about the roadside, including all infrastructure in the vicinity are available at the design stage.","Introduce requirements to ensure availability of approved terminals are taken into consideration",0,"Introduce mandatory road safety audit process at design stages",0,"Adjust the design standard accordingly to take recurring, common departures into account","Work with industry to incentivise development of commonly needed products, such as transitions","Adjust the design standard accordingly to take recurring, common departures into account","Other","Ensure road safety auditors are qualified to the necessary standards",0,"Introduce a procedure to enable reporting of cases where installers arrive to a site which isn't as described in the design","Other",0,0,0,"Ensure road safety auditors are qualified to the necessary standards",0,"Establish asset management system to manage VRS maintenance",0,"Consider prioritising VRS which can withstand consecutive impacts without need for repair","Create a database of traffic conditions at the time of roadside design and regularly review with current traffic conditions","Update European VRS standards to ensure impact test vehicles are representative of modern fleet",0,0,0,"Ensure road safety inspectors are qualified to the necessary standards"]
["Counter Measure 4","Create centralised database for RSA findings.","Introduce detailed written description of the incident as part of national data collection form.","Regularly (ex. annually) review departures from standards to identify common  issues.",0,"Other","Ensure all requirements within the roadside design standard take heavy vehicles  into consideration","Ensure installations on roadside surfaces (such as kerbs) take effective barrier height into consideration.","Introduce requirements to ensure durability of VRS are taken into consideration, in relation to local climate",0,"Other",0,"Other","Other","Report recurring departures to upper management with justification / data for further budget allocation.",0,"Other",0,"Other",0,0,0,0,"Other",0,"Other",0,"Other","Other","Monitor performance of historic VRS for real world impacts by modern vehicles",0,0,0,"Ensure multiple road safety inspectors are assigned for each inspection"]
["Counter Measure 5","Create centralised database for RSI findings.","Introduce data fields into national incident data collection form, which describe objects hit off carriageway.","Regularly (ex. annually) review in-depth on site incident data to identify RoR issues.",0,0,"Other","Other","Introduce requirement to ensure vehicle intrusion is taken into consideration",0,0,0,0,0,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Other",0,0,0,"Other"]
["Counter Measure 6","Create centralised data base for roadside related departures from standards.","Regularly review and improve the national incident data collection form.","Other",0,0,0,0,"Other",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]