{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Risk Score Calculator","Trauma Index Reference","Workbook"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":9,"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":"Instructions","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,1,27,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[0,1,0,3],[17,2,17,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[13,2,13,5],[12,1,12,5],[6,1,6,5],[1,1,1,5]]}
[null,"Risk Score Calculator\nVersion 2.21"]
[null,"About this Calculator"]
[null,"This tool outlines a method for evaluating the degree of risk posed by hazards alongside a specific stretch of road."]
[null,"This Calculator is based on the process outlined in Austroads Guide to Road Design Part 6, which assesses the safety of a roadside based on its geometry, traffic characteristics, and the presence of potential hazards."]
[null,"The information from the Austroads Guide to Road Design Part 6 Appendix B has been utilised to create this Risk Score Calculator."]
[]
[null,"Disclaimer:"]
[null,"1.","Although the utmost care has been taken in creating this Calculator, the Department of Transport and Main Roads cannot be held responsible for any decisions or actions made based on the information, data, statement or advice provided, whether directly or indirectly. We believe that the Calculator is error-free at the time of its release."]
[null,"2.","To ensure that the most up-to-date advice is utilised, it is essential to obtain the latest version of this Calculator prior to undertaking a risk assessment."]
[null,"3.","The Calculator incorporates additional operating speeds (40 km/h, 50 km/h, 60 km/h, 80 km/h, and 100 km/h) that have been estimated through interpolation or extrapolation, in addition to those outlined in Austroads Guide to Road Design   Part 6."]
[null,"4.","In the case of any suggestions or corrections, please get in touch with the Standards Research and Training Team."]
[]
[null,"Instructions"]
[null,"1.","Select the tab 'Risk Score Calculator' to access the Calculator."]
[null,"2.","The Colour Denotation on the top right side is provided for guidance in filling out the information in the Calculator. Please note that certain cells may change the display colours to indicate input status during the assessment. "]
[null,"3.","Input Project Details at the top of the Calculator, set the required Network Roadside Risk Intervention Threshold (NRRIT)."]
[null,"4.","Complete all items from A to S which relate to General and Particular road characteristics, Background and Isolated hazard characteristics. You can find the 'Data Input Guidelines' table on the right-hand side, following the same order as the Calculator, to assist you with instructions on inputting information."]
[null,"5.","If more than one isolated hazard are to be assessed, click 'Add Isolated Hazard' and complete the necessary information for each one."]
[null,"6.","Items from T to Z are calculated in accordance with the AGRD Part 6 Appendix B and relate to the Exposure, which indicates the number of vehicles that may leave the traffic lanes and move onto the shoulder."]
[null,"7.","Items from AA to AF are calculated in accordance with the AGRD Part 6 Appendix B and relate to the Likelihood, which depends on the roadside cross section and the speed of vehicles on the road. It measures the probability of a collision with a hazard beyond the lateral distance from the road to the hazard."]
[null,"8.","Items from AH to AM are calculated in accordance with the AGRD Part 6 Appendix B and relate to Severity (Trauma Index). These items use similar concepts to other approaches to assess the likely severity of impacts with a hazard."]
[null,"9.","The Combined Risk Score (Item AS) will be automatically calculated, along with the individual Risk Score for Background hazards, Isolated hazards and Rollover events. All the Risk Scores are calculated as the product of the Exposure, Likelihood, and Severity (Trauma Index)."]
[null,"10.","If necessary, click the 'Add Treatment' button to add the treatment."]
[null,"11.","The 'Clear Input' button is provided to clear all the input and calculation to begin a new assessment. "]
[null,"12.","Please ensure the Background/Isolated hazard you are evaluating is listed in the 'Trauma Index Reference' tab. If the object is not listed in the table, select the closest object to continue with the assessment.  "]
[null,"13.","The Print Area is set up for users who want to have a print copy of the risk calculation sheet."]
[]
[null,"Amendment Register"]
[]
[null,"Revision","Reference","Revision description","Authorised by","Date issued"]
[null,1,"AGRD Part 6","Initial release of the new risk score calculator","Santosh Tripathi","November 2020"]
[null,2,"AGRD Part 6","Multiple hazards added to the risk score calculator","Santosh Tripathi","April 2023"]
[null,2.1,"AGRD Part 6","Administrative changes","Santosh Tripathi","May 2023"]
[null,2.2000000000000002,"AGRD Part 6","1. Simplification of the risk score calculator for                                 user-friendliness\n2. Multiple hazards modification factors","Santosh Tripathi","May 2024"]
[null,2.21,"AGRD Part 6","Trauma Index correction","Steven Tu","September 2024"]

{"sheet":"Risk Score Calculator","index":1,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[27,5,27,9],[28,5,28,9],[29,5,29,9],[30,5,30,9],[38,5,38,9],[39,5,39,9],[40,5,40,9],[41,5,41,9],[42,5,42,9],[13,2,13,4],[24,13,24,15],[19,13,19,15],[20,13,20,15],[21,13,21,15],[22,13,22,15],[23,13,23,15],[14,13,14,15],[11,13,11,15],[36,2,36,4],[37,2,37,4],[0,12,0,15],[1,1,1,5],[19,2,19,4],[8,3,8,4],[11,0,18,0],[15,13,15,15],[16,13,16,15],[17,13,17,15],[18,13,18,15],[10,13,10,15],[5,3,5,4],[6,3,6,4],[7,3,7,4],[12,13,12,15],[13,13,13,15],[7,0,7,2],[6,0,6,2],[5,0,5,2],[8,0,8,2],[10,2,10,4],[11,2,11,4],[12,2,12,4],[34,2,34,4],[35,2,35,4],[57,0,62,0],[38,0,45,0],[19,0,24,0],[28,1,29,1],[32,1,33,1],[16,2,16,4],[14,2,14,4],[15,2,15,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[26,2,26,4],[17,2,17,4],[18,2,18,4],[54,0,56,0],[31,0,37,0],[27,0,30,0],[46,0,53,0],[38,2,38,4],[54,2,54,4],[54,5,54,9],[56,5,56,9],[45,2,45,4],[62,2,62,4],[59,2,59,4],[57,2,57,4],[61,2,61,4],[55,2,55,4],[56,2,56,4],[46,2,46,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[58,2,58,4],[60,2,60,4],[52,2,52,4],[53,2,53,4],[61,5,61,9],[62,5,62,9],[57,5,57,9],[59,5,59,9],[44,2,44,4],[42,2,42,4],[43,2,43,4],[43,5,43,9],[44,5,44,9],[45,5,45,9],[46,5,46,9],[47,5,47,9],[53,5,53,9],[28,2,29,4],[32,2,33,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[31,2,31,4],[27,2,27,4],[30,2,30,4],[62,13,62,14],[57,13,57,14],[58,13,58,14],[59,13,59,14],[60,13,60,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[61,13,61,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[35,13,35,14],[36,13,36,14],[37,13,37,14],[55,13,55,14],[56,13,56,14],[43,13,43,14],[44,13,44,14],[45,13,45,14],[46,13,46,14],[47,13,47,14],[26,13,26,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[48,13,48,14],[49,13,49,14],[50,13,50,14],[51,13,51,14],[39,13,39,14],[38,13,38,14],[2,13,2,14],[3,13,3,14],[1,12,1,15],[5,12,8,15],[32,12,33,12],[28,12,29,12],[52,13,52,14],[53,13,53,14],[54,13,54,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow coloured cells: user input required - either manual input, or selection from drop-down lists"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gray coloured cells: no user input required - either no data entry, or auto-calculated values"]
[]
[null,null,null,"Project:",null,null,null,null,null,null,null,null,"Data Input Guidelines"]
[null,null,null,"Road Name:"]
[null,null,null,"Road ID:"]
[null,null,null,"Network Roadside Risk Intervention Threshold:",null,0.6," "]
[]
["Group","Item","Measure",null,null,"Input",null,null,null,null,null,null,"Item","Instructions"]
["General Road Characteristics","A","Terrain",null,null,null,null,null,null,null,null,null,"A","Select from the drop-down list: Flat, Rolling, Mountainous"]
[null,"B","Environment",null,null,null,null,null,null,null,null,null,"B","Select from the drop-down list: Urban, Rural"]
[null,"C","Operating speed (km/h)",null,null,null,null,null,null,null,null,null,"C","Select from the drop-down list: 40, 50, 60, 70, 80, 90, 100, 110"]
[null,"D","Carriageway type ",null,null,null,null,null,null,null,null,null,"D","Select from the drop-down list: Divided, Undivided"]
[null,"E","Number of the traffic lanes in the direction of travel",null,null,null,null,null,null,null,null,null,"E","Select from the drop-down list: 1, 2, 3, 4, 5 "]
[null,"F","Lane width",null,null,null,null,null,null,null,null,null,"F","Select the closest value from the drop-down list: 2.7 m and narrower, 3.0 m, 3.3 m, 3.5 m and wider"]
[null,"G","Design AADT (veh/day)                                                                                                                                 ",null,null,null,null,null,null,null,null,null,"G","Use Carriageway Volume for undivided, and Bi-directional Volume for divided carriageway"]
[null,"H","Length of road section (m)",null,null,null,null,null,null,null,null,null,"H","Default is 1000 m "]
["Particular Road Characteristics","I","Chainage where the roadside is assessed",null,null,null,null,null,null,null,null,null,"I","Chainage where the roadside is assessed"]
[null,"J","Side of travelled way",null,null,null,null,null,null,null,null,null,"J","Select from the drop-down list: Left (Verge), Right (Median)"]
[null,"K","Grade",null,null,null,null,null,null,null,null,null,"K","Upgrade should be entered as a positive value"]
[null,"L","Curve radius (m) ",null,null,null,null,null,null,null,null,null,"L","Use 2000 m for straight roads"]
[null,"M","Curve direction",null,null,null,null,null,null,null,null,null,"M","Select from the drop-down list: Left, Right, Straight"]
[null,"TA","Lateral width of the flat area (≤1:6) beside the traffic lane (m)",null,null,null,null,null,null,null,null,null,"TA","The lateral width is measured from the edge of the traffic lane to the background hazards if they are located within the flat area (≤1:6). Otherwise, it is measured from the edge of the traffic lane to the flat area where the batter slope is no more than 1:6. See Appendix B.5."]
[]
["Group","Item","Measure",null,null,"Hazard 1","Hazard 2","Hazard 3","Hazard 4","Hazard 5","Treatment",null,"Item","Instructions",null,"AGRD Part 6"]
["Background Hazard Characteristics","N","Description (Leave blank if none) ",null,null,null,null,null,null,null,null,null,"N","If the object is listed in the Trauma Index Reference table, select it from the drop-down list.\nOtherwise, enter its description in the text input field.",null,"Table B.4 - B.9"]
[null,"AH","Trauma Index for background hazards at the operating speed of 110 km/h",null,null,{"$f":"_xlfn.XLOOKUP($F$28,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},null,null,null,null,{"$f":"_xlfn.XLOOKUP($K$28,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},null,"AH","If a trauma index value automatically displays here, please do not input the Cell below. ",null,"Table B.4 - B.9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If the object is not listed in the Trauma Index Reference table, \nselect the closest trauma index value from the drop-down list in the text input area. ",null,"Table B.4 - B.9"]
[null,"O","Lateral distance to background hazards from the edge of the traffic lane (m) ",null,null,null,null,null,null,null,null,null,"O","Lateral distance to the background hazards from the edge of the traffic lane.",null,"Figure B.10"]
["Isolated Hazard Characteristics","P","Description (Leave blank if none) ",null,null,null,null,null,null,null,null,null,"P","If the object is listed in the Trauma Index Reference table, select it from the drop-down list.\nOtherwise, enter its description in the text input field.",null,"Table B.4 - B.9"]
[null,"AK","Trauma Index for isolated hazards at the operating speed of 110 km/h",null,null,{"$f":"_xlfn.XLOOKUP(F32,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},{"$f":"_xlfn.XLOOKUP(G32,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},{"$f":"_xlfn.XLOOKUP(H32,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},{"$f":"_xlfn.XLOOKUP(I32,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},{"$f":"_xlfn.XLOOKUP(J32,Workbook!$O$2:$O$106,Workbook!$P$2:$P$106,\"\",0,1)","v":""},{"$f":"_xlfn.XLOOKUP(K32,Workbook!V2,Workbook!W2,\"\",0,1)","v":""},null,"AK","If a trauma index value automatically displays here, please do not input the Cell below. ",null,"Table B.4 - B.9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If the object is not listed in the Trauma Index Reference table, \nselect the closest trauma index value from the drop-down list in the text input area. ",null,"Table B.4 - B.9"]
[null,"TB","Do the isolated hazards shield the background hazard?",null,null,null,null,null,null,null,null,null,"TB","Do the isolated hazards shield the background hazard?",null,"Appendix B"]
[null,"Q","Length of the isolated hazards (m) ",null,null,null,null,null,null,null,null,null,"Q","The sum of this length (Item Q) and 18 meters should be no more than the length of road section (Item H).",null,"Appendix B.3"]
[null,"R","Average distance between the isolated hazards (m)",null,null,null,null,null,null,null,null,null,"R","This length (Item R) should be less than or equal to the length of road section (Item H).",null,"Appendix B"]
[null,"S","Lateral distance to isolated hazards from the edge of the traffic lane (m)                                                                                                                                                                         ",null,null,null,null,null,null,null,null,null,"S","Lateral distance to the isolated hazards from the edge of the traffic lane    ",null,"Figure B.10"]
["Exposure","T","Base exposure (encr/km/yr)",null,null,{"$f":"IF(Workbook!F10<8,\"\",Workbook!BF1)","v":""},null,null,null,null,{"$f":"IF(Workbook!F10<8,\"\",Workbook!BF1)","v":""},null,"T","Base exposure (encr/km/yr)",null,"Figure B.1 - B.2"]
[null,"U","Number of lanes factor",null,null,{"$f":"IF(F39=\"\",\"\",IF($F$13=\"Rural\",IF($F$15=\"Divided\",IF($F$16>2,0.91,1),IF($F$16>1,0.76,1)),IF($F$15=\"Divided\",IF($F$16>2,0.91,1),IF(F14<=90,1,IF($F$16>2,0.91,1)))))","v":""},null,null,null,null,{"$f":"IF(K39=\"\",\"\",IF($F$13=\"Rural\",IF($F$15=\"Divided\",IF($F$16>2,0.91,1),IF($F$16>1,0.76,1)),IF($F$15=\"Divided\",IF($F$16>2,0.91,1),IF(F14<=90,1,IF($F$16>2,0.91,1)))))","v":""},null,"U","Number of lanes factor",null,"Table B.1 - B.2"]
[null,"V","Lane width factor",null,null,{"$f":"IF(F39=\"\",\"\",IF($F$15=\"Undivided\",IF($F$13=\"Rural\",IF($F$17=\"2.7 m and narrower\",1.5,IF($F$17=\"3.0 m\",1.3,IF($F$17=\"3.3 m\",1.05,1))),IF(F14<=90,IF($F$17=\"2.7 m and narrower\",2.13,IF($F$17=\"3.0 m\",1.85,IF($F$17=\"3.3 m\",1.49,1.42))),IF($F$17=\"2.7 m and narrower\",1.25,IF($F$17=\"3.0 m\",1.15,IF($F$17=\"3.3 m\",1.03,1))))),IF($F$17=\"2.7 m and narrower\",1.25,IF($F$17=\"3.0 m\",1.15,IF($F$17=\"3.3 m\",1.03,1)))))","v":""},null,null,null,null,{"$f":"IF(K39=\"\",\"\",IF($F$15=\"Undivided\",IF($F$13=\"Rural\",IF($F$17=\"2.7 m and narrower\",1.5,IF($F$17=\"3.0 m\",1.3,IF($F$17=\"3.3 m\",1.05,1))),IF(F14<=90,IF($F$17=\"2.7 m and narrower\",2.13,IF($F$17=\"3.0 m\",1.85,IF($F$17=\"3.3 m\",1.49,1.42))),IF($F$17=\"2.7 m and narrower\",1.25,IF($F$17=\"3.0 m\",1.15,IF($F$17=\"3.3 m\",1.03,1))))),IF($F$17=\"2.7 m and narrower\",1.25,IF($F$17=\"3.0 m\",1.15,IF($F$17=\"3.3 m\",1.03,1)))))","v":""},null,"V","Lane width factor",null,"Table B.1 - B.3"]
[null,"W","Terrain factor",null,null,{"$f":"IF(F39=\"\",\"\",IF($F$15=\"Undivided\",IF($F$13=\"Rural\",IF($F$12=\"Rolling\",2.58,IF($F$12=\"Mountainous\",2.27,1)),IF(F14<=90,IF($F$12=\"Rolling\",2.58,1),IF($F$12=\"Rolling\",1.66,IF($F$12=\"Mountainous\",1.51,1)))),IF($F$12=\"Rolling\",1.66,IF($F$12=\"Mountainous\",1.51,1))))","v":""},null,null,null,null,{"$f":"IF(K39=\"\",\"\",IF($F$15=\"Undivided\",IF($F$13=\"Rural\",IF($F$12=\"Rolling\",2.58,IF($F$12=\"Mountainous\",2.27,1)),IF(F14<=90,IF($F$12=\"Rolling\",2.58,1),IF($F$12=\"Rolling\",1.66,IF($F$12=\"Mountainous\",1.51,1)))),IF($F$12=\"Rolling\",1.66,IF($F$12=\"Mountainous\",1.51,1))))","v":""},null,"W","Terrain factor",null,"Table B.1 - B.3"]
[null,"X","Grade factor",null,null,{"$f":"IF(F39=\"\",\"\",IF(100*$F$22<-6,2,IF(100*$F$22>-2,1,0.5-100*$F$22/4)))","v":""},null,null,null,null,{"$f":"IF(K39=\"\",\"\",IF(100*$F$22<-6,2,IF(100*$F$22>-2,1,0.5-100*$F$22/4)))","v":""},null,"X","Grade factor",null,"Figure B.3"]
[null,null,"Objects inside curve? (Yes/No)",null,null,{"$f":"IF(Workbook!F10<8,\"\",IF($F$21=$F$24,\"Yes\",\"No\"))","v":""},null,null,null,null,{"$f":"IF(Workbook!F10<8,\"\",IF($F$21=$F$24,\"Yes\",\"No\"))","v":""},null,null,"Objects inside curve? Yes, No"]
[null,"Y","Curve correction factor",null,null,{"$f":"IF(OR($F$23=\"\",F39=\"\"),\"\",IF(F44=\"Yes\",IF($F$23>600,1,IF($F$23<300,2,3-$F$23/300)),IF($F$23>600,1,IF($F$23<300,4,7-$F$23/100))))","v":""},null,null,null,null,{"$f":"IF(OR($F$23=\"\",K39=\"\"),\"\",IF(K44=\"Yes\",IF($F$23>600,1,IF($F$23<300,2,3-$F$23/300)),IF($F$23>600,1,IF($F$23<300,4,7-$F$23/100))))","v":""},null,"Y","Curve correction factor",null,"Figure B.4"]
[null,"Z","Exposure (encr/km/yr)",null,null,{"$f":"IF(F39=\"\",\"\",PRODUCT(F39:F43,F45))","v":""},null,null,null,null,{"$f":"IF(K39=\"\",\"\",PRODUCT(K39:K43,K45))","v":""},null,"Z","Exposure (encr/km/yr)",null,"Product T to Y"]
["Likelihood",null,"Likeihood curve correction factor",null,null,{"$f":"IF(F39=\"\",\"\",INDEX(Workbook!$Z$3:$AG$18,MATCH(F23,Workbook!$Y$3:$Y$18,1),MATCH(F14,Workbook!$Z$2:$AG$2,0)))","v":""},null,null,null,null,{"$f":"IF(F39=\"\",\"\",INDEX(Workbook!$Z$3:$AG$18,MATCH(F23,Workbook!$Y$3:$Y$18,1),MATCH(F14,Workbook!$Z$2:$AG$2,0)))","v":""},null,null,"Likeihood curve correction factor"]
[null,"AA","Likelihood for background hazards",null,null,{"$f":"IF(F31=\"\",\"\",IF(F31<0,\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/F47*F31)/100))","v":""},null,null,null,null,{"$f":"IF(K31=\"\",\"\",IF(K31<0,\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/K47*K31)/100))","v":""},null,"AA","Likelihood of impact with background hazard without isolated hazards (taking into account the curve radius)",null,"Figure B.6 - B.8"]
[null,"AB","Likelihood modification factor",null,null,{"$f":"IF($F$31=\"\",\"\",IF(F51=0,1,IF(OR(F35=\"No\",F35=\"\"),1,MAX((1-(F36+18)/MIN(F37,$F$19)),0))))","v":""},{"$f":"IF($F$31=\"\",\"\",IF(G51=0,1,IF(OR(G35=\"No\",G35=\"\"),1,MAX(1-(G36+18)/MIN(G37,$F$19),0))))","v":""},{"$f":"IF($F$31=\"\",\"\",IF(H51=0,1,IF(OR(H35=\"No\",H35=\"\"),1,MAX(1-(H36+18)/MIN(H37,$F$19),0))))","v":""},{"$f":"IF($F$31=\"\",\"\",IF(I51=0,1,IF(OR(I35=\"No\",I35=\"\"),1,MAX(1-(I36+18)/MIN(I37,$F$19),0))))","v":""},{"$f":"IF($F$31=\"\",\"\",IF(J51=0,1,IF(OR(J35=\"No\",J35=\"\"),1,MAX(1-(J36+18)/MIN(J37,$F$19),0))))","v":""},{"$f":"IF($K$31=\"\",\"\",IF(K51=0,1,IF(OR(K35=\"No\",K35=\"\"),1,MAX(1-(K36+18)/MIN(K37,$F$19),0))))","v":""},null,"AB","Modification factor for likelihood if the isolated hazards shield the background hazards",null,"1-(Q+18)/MIN(R,H)"]
[null,"AC","Modified likelihood for background hazards",null,null,{"$f":"IF(OR($F$31=\"\",F49=\"\"),\"\",$F$48*F49)","v":""},{"$f":"IF(OR($F$31=\"\",G49=\"\"),\"\",$F$48*G49)","v":""},{"$f":"IF(OR($F$31=\"\",H49=\"\"),\"\",$F$48*H49)","v":""},{"$f":"IF(OR($F$31=\"\",I49=\"\"),\"\",$F$48*I49)","v":""},{"$f":"IF(OR($F$31=\"\",J49=\"\"),\"\",$F$48*J49)","v":""},{"$f":"IF(OR($K$31=\"\",K49=\"\"),\"\",K48*K49)","v":""},null,"AC","Likelihood accounting for shielding by isolated hazards",null,"AA*AB"]
[null,null,"Impact length of the isolated hazards",null,null,{"$f":"IF(F36=\"\",\"\",IF(F36=0,0,IF(F36<=MIN($F$19,F37)-18,18+F36,\"Input Error: Check Items Q, H, and R\")))","v":""},"","","","",{"$f":"IF(K36=\"\",\"\",IF(K36=0,0,IF(K36<=MIN($F$19,K37)-18,18+K36,\"Input Error: Check Items Q, H, and R\")))","v":""}]
[null,"AD","Likelihood of impacts with continuous isolated hazards",null,null,{"$f":"IF(F36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$F$47*F38)/100)","v":""},{"$f":"IF(G36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$F$47*G38)/100)","v":""},{"$f":"IF(H36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$F$47*H38)/100)","v":""},{"$f":"IF(I36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$F$47*I38)/100)","v":""},{"$f":"IF(J36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$F$47*J38)/100)","v":""},{"$f":"IF(K36=\"\",\"\",100*EXP(-0.1644409/_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1)/$K$47*K38)/100)","v":""},null,"AD","Likelihood of impact with continuous isolated hazards (taking into account the curve radius)",null,"Figure B.6-B.8"]
[null,"AE","Likelihood of impacts with isolated hazards",null,null,{"$f":"IF(F52=\"\",\"\",IF(F36=0,0,IF(F51=\"\",\"\",F52*F51/MIN(F37,$F$19))))","v":""},{"$f":"IF(G52=\"\",\"\",IF(G36=0,0,IF(G51=\"\",\"\",G52*G51/MIN(G37,$F$19))))","v":""},{"$f":"IF(H52=\"\",\"\",IF(H36=0,0,IF(H51=\"\",\"\",H52*H51/MIN(H37,$F$19))))","v":""},{"$f":"IF(I52=\"\",\"\",IF(I36=0,0,IF(I51=\"\",\"\",I52*I51/MIN(I37,$F$19))))","v":""},{"$f":"IF(J52=\"\",\"\",IF(J36=0,0,IF(J51=\"\",\"\",J52*J51/MIN(J37,$F$19))))","v":""},{"$f":"IF(K52=\"\",\"\",IF(K36=0,0,IF(K51=\"\",\"\",K52*K51/MIN(K37,F19))))","v":""},null,"AE","Likelihood of impacts with isolated hazards",null,"AD*(Q+18)/MIN(R,H)"]
[null,"AF","Likelihood of a rollover",null,null,{"$f":"IF($F$25=\"\",\"\",0.00592*$F$25*_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1))","v":""},null,null,null,null,{"$f":"IF($F$25=\"\",\"\",0.00592*$F$25*_xlfn.XLOOKUP($F$14,Workbook!$AZ$2:$AZ$10,Workbook!$BA$2:$BA$10,,0,1))","v":""},null,"AF","Likelihood of a rollover",null,"Equation B2"]
["Severity \n(Trauma Index)","AJ","Trauma Index for background hazards at the appropriate operating speed",null,null,{"$f":"IF(F31=\"\",\"\",IF(Workbook!C18=1,F29*_xlfn.XLOOKUP('Risk Score Calculator'!$F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!F30,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP('Risk Score Calculator'!$F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},null,null,null,null,{"$f":"IF(K31=\"\",\"\",IF(Workbook!M18=1,K29*_xlfn.XLOOKUP('Risk Score Calculator'!$F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!K30,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP('Risk Score Calculator'!$F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},null,"AJ","Trauma Index for background hazards at the appropriate operating speed",null,"Appendix B.4.5"]
[null,"AL","Trauma Index for isolated hazards at the appropriate operating speed",null,null,{"$f":"IF(F32=\"\",\"\",IF(Workbook!C22=1,F33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!F34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},{"$f":"IF(G32=\"\",\"\",IF(Workbook!E22=1,G33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!G34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},{"$f":"IF(H32=\"\",\"\",IF(Workbook!G22=1,H33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!H34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},{"$f":"IF(I32=\"\",\"\",IF(Workbook!I22=1,I33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!I34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},{"$f":"IF(J32=\"\",\"\",IF(Workbook!K22=1,J33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!J34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},{"$f":"IF(K32=\"\",\"\",IF(Workbook!M22=1,K33*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1),_xlfn.XLOOKUP('Risk Score Calculator'!K34,Workbook!$T$2:$T$106,Workbook!$S$2:$S$106,,0,1)*_xlfn.XLOOKUP($F$14,Workbook!$AW$2:$AW$9,Workbook!$AX$2:$AX$9,,0,1)))","v":""},null,"AL","Trauma Index for isolated hazards at the appropriate operating speed",null,"Appendix B.4.5"]
[null,"AM","Trauma Index for a rollover",null,null,{"$f":"IF(F54=\"\",\"\",0.63)","v":""},null,null,null,null,{"$f":"IF(K54=\"\",\"\",0.63)","v":""},null,"AM","Trauma Index for a rollover is 0.63",null,0.63]
["Risk Score","AP","Risk Score for background hazards                                                                                                                                                                                     ",null,null,{"$f":"Workbook!G35","v":""},null,null,null,null,{"$f":"K59","v":""},null,"AP","Calculate Risk Score (product of the exposure, likelihood and Trauma Index) for background hazards                ",null,"Z*AC*AJ"]
[null,null,"Risk Score for background hazards                                                                                                                                                                                     ",null,null,{"$f":"IF(F50=\"\",\"\",IF($F$28=\"\",0,$F$46*F50*$F$55))","v":""},{"$f":"IF(G50=\"\",\"\",IF($F$28=\"\",0,$F$46*G50*$F$55))","v":""},{"$f":"IF(H50=\"\",\"\",IF($F$28=\"\",0,$F$46*H50*$F$55))","v":""},{"$f":"IF(I50=\"\",\"\",IF($F$28=\"\",0,$F$46*I50*$F$55))","v":""},{"$f":"IF(J50=\"\",\"\",IF($F$28=\"\",0,$F$46*J50*$F$55))","v":""},{"$f":"IF(K50=\"\",\"\",IF($K$28=\"\",0,$K$46*K50*$K$55))","v":""}]
[null,"AQ","Risk Score for isolated hazards",null,null,{"$f":"IF(SUM(F61:J61)=0,\"\",SUM(F61:J61))","v":""},null,null,null,null,{"$f":"K61","v":""},null,"AQ","Calculate Risk Score (product of the exposure, likelihood and Trauma Index) for isolated hazards",null,"Z*AE*AL"]
[null,null,"Risk Score for isolated hazards",null,null,{"$f":"IF(F32=\"\",0,$F$46*F53*F56)","v":0},{"$f":"IF(G32=\"\",0,$F$46*G53*G56)","v":0},{"$f":"IF(H32=\"\",0,$F$46*H53*H56)","v":0},{"$f":"IF(I32=\"\",0,$F$46*I53*I56)","v":0},{"$f":"IF(J32=\"\",0,$F$46*J53*J56)","v":0},{"$f":"IF(K32=\"\",\"\",$K$46*K53*K56)","v":""}]
[null,"AR","Risk Score for rollover events",null,null,{"$f":"IF(F25=\"\",\"\",$F$46*$F$54*$F$57)","v":""},null,null,null,null,{"$f":"IF(F25=\"\",\"\",$K$46*$K$54*$K$57)","v":""},null,"AR","Calculate Risk Score (product of the exposure, likelihood and Trauma Index) for rollover events",null,"Z*AF*AM"]
[null,"AS","Combined Risk Score",null,null,{"$f":"IF(OR(F51=\"Input Error: Check Items Q, H, and R\",G51=\"Input Error: Check Items Q, H, and R\",H51=\"Input Error: Check Items Q, H, and R\",I51=\"Input Error: Check Items Q, H, and R\",J51=\"Input Error: Check Items Q, H, and R\"),\"Input Error: Check Items Q, H, and R\",SUM(F58,F60,F62))","v":0},null,null,null,null,{"$f":"IF(K51=\"Input Error: Check Items Q, H, and R\",\"Input Error: Check Items Q, H, and R\",SUM(K58,K60,K62))","v":0},null,"AS","Combined Risk Score",null,"AP+AQ+AR"]

{"sheet":"Trauma Index Reference","index":2,"n_rows":106,"n_cols":3,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[null,"Hazard","Trauma Index – 110 km/h"]
[null,"Bridge pier column",44]
[null,"Generic fixed object",6]
[null,"Generic rigid wall",0.77]
[null,"Road safety barrier",0.43]
[null,"Rock cutting",6]
[null,"Rocks protruding between 100 and 150mm above the ground surface",3]
[null,"Rocks protruding between 200 and 300mm above the ground surface",6]
[null,"Ruts in the ground surface between 200 and 300mm deep",3]
[null,"Ruts in the ground surface more than 300mm deep",6]
[null,"Signs breakaway",0.75]
[null,"Slip base or energy absorbing poles",1.9]
[null,"Small wooden sign",0.75]
[null,"Traffic signal pole",8.6]
[null,"Tree with a trunk of 75 to 100mm diameter",0.53]
[null,"Tree with a trunk of 150 to 250mm diameter",3.1]
[null,"Tree with a trunk of 250mm and larger in diameter",6.7]
[null,"Tree lined edge",6]
[null,"Utility pole",6.4]
[null,"Cut 1:6 to 1:3 (All heights) ",0.35]
[null,"Cut 1:2 (All heights) ",0.61]
[null,"Cut 1:1.5 (All heights) ",0.74]
[null,"Cut 1:1 (All heights) ",0.9]
[null,"Vertical Face (All heights)",0.8]
[null,"Fill 1:6 (All heights) ",0.63]
[null,"Fill 1:4 (0 to 2m) ",0.69]
[null,"Fill 1:4 (more than 2m) ",0.89]
[null,"Fill 1:3 (0 to 2m)",0.83]
[null,"Fill 1:3 (2 to 5m)",1.4]
[null,"Fill 1:3 (5 to 20m)",1.5]
[null,"Fill 1:3 (more than 20m)",2.1]
[null,"Fill 1:2 (0 to 2m)",1.3]
[null,"Fill 1:2 (2 to 5m)",3.5]
[null,"Fill 1:2 (5 to 10m)",4.5]
[null,"Fill 1:2 (10 to 20m)",6.7]
[null,"Fill 1:2 (more than 20m)",9.9]
[null,"Fill 1:1.5 (0 to 2m)",1.7]
[null,"Fill 1:1.5 (2 to 5m)",7]
[null,"Fill 1:1.5 (5 to 10m)",14]
[null,"Fill 1:1.5 (10 to 20m)",27]
[null,"Fill 1:1.5 (more than 20m)",39]
[null,"Drop 0.0m (Water 1m and lower deep)",1.2]
[null,"Drop 0.0m (Water 2m deep)",7.2]
[null,"Drop 0.0m (Water 4m deep)",17]
[null,"Drop 0.0m (Water 6m and higher deep)",35]
[null,"Drop 0.3m (Water 1m and lower deep)",2]
[null,"Drop 0.3m (Water 2m deep)",9.9]
[null,"Drop 0.3m (Water 4m deep)",22]
[null,"Drop 0.3m (Water 6m and higher deep)",38]
[null,"Drop 2.0m (Water 1m and lower deep)",5.2]
[null,"Drop 2.0m (Water 2m deep)",20]
[null,"Drop 2.0m (Water 4m deep)",30]
[null,"Drop 2.0m (Water 6m and higher deep)",40]
[null,"Drop 4.0m (Water 1m and lower deep)",12]
[null,"Drop 4.0m (Water 2m deep)",28]
[null,"Drop 4.0m (Water 4m deep)",35]
[null,"Drop 4.0m (Water 6m and higher deep)",43]
[null,"Drop 6.0m (Water 1m and lower deep)",19]
[null,"Drop 6.0m (Water 2m deep)",33]
[null,"Drop 6.0m (Water 4m deep)",39]
[null,"Drop 6.0m (Water 6m and higher deep)",45]
[null,"Drop 8.0m (Water 1m and lower deep)",28]
[null,"Drop 8.0m (Water 2m deep)",36]
[null,"Drop 8.0m (Water 4m deep)",42]
[null,"Drop 8.0m (Water 6m and higher deep)",46]
[null,"Drop 10.0m or higher (Water 1m and lower deep)",45]
[null,"Drop 10.0m or higher (Water 2m deep)",48]
[null,"Drop 10.0m or higher (Water 4m deep)",51]
[null,"Drop 10.0m or higher (Water 6m and higher deep)",52]
[null,"V Drain 1:6 Foreslope 1:6 Backslope",0.55000000000000004]
[null,"V Drain 1:6 Foreslope 1:4 Backslope",0.59]
[null,"V Drain 1:6 Foreslope 1:3 Backslope",0.61]
[null,"V Drain 1:6 Foreslope 1:2 Backslope",0.68]
[null,"V Drain 1:4 Foreslope 1:4 Backslope",0.68]
[null,"V Drain 1:4 Foreslope 1:3 Backslope",0.69]
[null,"V Drain 1:4 Foreslope 1:2 Backslope",0.8]
[null,"V Drain 1:3 Foreslope 1:4 Backslope",0.73]
[null,"V Drain 1:3 Foreslope 1:3 Backslope",0.81]
[null,"V Drain 1:3 Foreslope 1:2 Backslope",0.9]
[null,"V Drain 1:2 Foreslope 1:3 Backslope",0.9]
[null,"V Drain 1:2 Foreslope 1:2 Backslope",1]
[null,"Upslope 1:6 and flatter (All heights)",0.73]
[null,"Upslope 1:4 (All heights)",1.0900000000000001]
[null,"Upslope 1:3 (All heights) ",1.6]
[null,"Upslope 1:2 (All heights) ",3.3]
[null,"Upslope 1:1.5 (All heights) ",5]
[null,"Upslope 1:1 (All heights) ",6.5]
[null,"Downslope 1:6 and flatter (0 to 2m)",1]
[null,"Downslope 1:6 and flatter (2 to 5m)",1.9]
[null,"Downslope 1:6 and flatter (more than 5m)",2.7]
[null,"Downslope 1:4 and flatter (0 to 2m)",1.2]
[null,"Downslope 1:4 and flatter (2 to 5m)",3.7]
[null,"Downslope 1:4 and flatter (5 to 10m)",11]
[null,"Downslope 1:4 and flatter (more than 10m)",14]
[null,"Downslope 1:3 and flatter (0 to 2m)",1.2]
[null,"Downslope 1:3 and flatter (2 to 5m)",4.4000000000000004]
[null,"Downslope 1:3 and flatter (5 to 10m)",17]
[null,"Downslope 1:3 and flatter (more than 10m)",25]
[null,"Downslope 1:2 and flatter (0 to 2m)",1.2]
[null,"Downslope 1:2 and flatter (2 to 5m)",4.5]
[null,"Downslope 1:2 and flatter (5 to 10m)",21]
[null,"Downslope 1:2 and flatter (more than 10m)",38]
[null,"Downslope 1:1.5 and flatter (0 to 2m)",1.2]
[null,"Downslope 1:1.5 and flatter (2 to 5m)",4.5]
[null,"Downslope 1:1.5 and flatter (5 to 10m)",21]
[null,"Downslope 1:1.5 and flatter (more than 10m)",42]

{"sheet":"Workbook","index":3,"n_rows":106,"n_cols":60,"rows_kept":106,"cut":false,"hidden":true,"merged":[[0,25,0,32],[0,24,1,24]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hazard","Trauma Index – 110 km/h",null,"Hazard","Trauma Index – 110 km/h",null,null,"Treatment","Trauma Index – 110 km/h",null,"Radius (m)","Design speed \n(km/h)",null,null,null,null,null,null,null,null,"Terrain",null,"Environment",null,"Operating speed",null,"Carriageway Type",null,"Number of lanes  (direction of travel)",null,"Lane width",null,"Side of road",null,"Design speed (km/h)","Trauma Index Factor",null,"Design speed (km/h)","Speed correction factor",null,"Yes",null,"Base exposure",{"$f":"IF(BF3=\"Undivided\",_xlfn.XLOOKUP(BF2,BE5:BE7,BF5:BF7,,-1,1),_xlfn.XLOOKUP(BF2,BG5:BG7,BH5:BH7,,-1,1))","v":0}]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F12=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Bridge pier column",44,null,"Bridge pier column",44,{"$f":"CONCATENATE(S2,\", similar to Trauma Index of \",R2)","v":"44, similar to Trauma Index of Bridge pier column"},null,"Road safety barrier",0.43,null,null,40,50,60,70,80,90,100,110,null,"Flat",null,"Urban",null,120,null,"Divided",null,1,null,"2.7 m and narrower",null,"Left",null,40,0.16228399699474075,null,40,{"$f":"(AZ2/110)^2","v":0.13223140495867769},null,"No",null,"AADT",{"$f":"'Risk Score Calculator'!F18","v":0}]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F13=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Generic fixed object",6,null,"Generic fixed object",6,{"$f":"CONCATENATE(S3,\", similar to Trauma Index of \",R3)","v":"6, similar to Trauma Index of Generic fixed object"},null,null,null,null,1,1.2,1.3,1.5,1.5,1.5,1.5,1.5,1.5,null,"Rolling",null,"Rural",null,110,null,"Undivided",null,2,null,"3.0 m",null,"Right",null,50,0.16228399699474075,null,50,{"$f":"(AZ3/110)^2","v":0.20661157024793386},null,null,null,"Carriage Type",{"$f":"'Risk Score Calculator'!F15","v":0}]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F14=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Generic rigid wall",0.77,null,"Generic rigid wall",0.77,"0.77, similar to Trauma Index of Generic rigid wall",null,null,null,null,100,1.2,1.3,1.4,1.5,1.5,1.5,1.5,1.5,null,"Mountainous",null,null,null,100,null,null,null,3,null,"3.3 m",null,"Straight",null,60,{"$f":"(AW4/110)^3","v":0.16228399699474075},null,60,0.29752066115702475,null,null,null,"Undivided","B1","Divided","B2"]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F15=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Road safety barrier",0.43,null,"Road safety barrier",0.43,"0.43, similar to Trauma Index of Road safety barrier",null,null,null,null,150,1.2,1.2,1.3,1.4,1.5,1.5,1.5,1.5,null,null,null,null,null,90,null,null,null,4,null,"3.5 m and wider",null,null,null,70,{"$f":"(AW5/110)^3","v":0.25770097670924114},null,70,0.4049586776859504,null,null,null,0,{"$f":"0.00028616*BF2*EXP(0.4997-0.2092*BF2/1000)","v":0},0,{"$f":"0.00034055*BF2*EXP(-0.2104-0.08256*BF2/1000)","v":0}]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F16=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Rock cutting",6,null,"Rock cutting",6,"6, similar to Trauma Index of Rock cutting",null,null,null,null,200,1.1000000000000001,1.2,1.3,1.4,1.5,1.5,1.5,1.5,null,null,null,null,null,80,null,null,null,5,null,null,null,null,null,80,{"$f":"(AW6/110)^3","v":0.38467317806160783},null,80,0.52892561983471076,null,null,null,4780,0.82940000000000003,12110,1.2295]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F17=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Rocks protruding between 100 and 150mm above the ground surface",3,null,"Rocks protruding between 100 and 150mm above the ground surface",3,"3, similar to Trauma Index of Rocks protruding between 100 and 150mm above the ground surface",null,null,null,null,250,1.1000000000000001,1.2,1.3,1.4,1.4,1.5,1.5,1.5,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,90,0.54770848985725029,null,90,0.66942148760330589,null,null,null,11560,{"$f":"0.07177*BF2/1000","v":0},23230,{"$f":"0.05293*BF2/1000","v":0}]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F18=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Rocks protruding between 200 and 300mm above the ground surface",6,null,"Rocks protruding between 200 and 300mm above the ground surface",6,"6, similar to Trauma Index of Rocks protruding between 200 and 300mm above the ground surface",null,null,null,null,300,1.1000000000000001,1.2,1.2,1.3,1.4,1.5,1.5,1.5,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,100,0.75131480090157765,null,100,0.82644628099173545]
[null,null,null,null,null,{"$f":"IF('Risk Score Calculator'!F19=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,"Ruts in the ground surface between 200 and 300mm deep",3,null,"Ruts in the ground surface between 200 and 300mm deep",3,"3, similar to Trauma Index of Ruts in the ground surface between 200 and 300mm deep",null,null,null,null,350,1.1000000000000001,1.2,1.2,1.3,1.3,1.4,1.5,1.5,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,110,1,null,110,1]
[null,null,null,null,null,{"$f":"SUM(F2:F9)","v":0},null,null,null,null,null,null,null,null,"Ruts in the ground surface more than 300mm deep",6,null,"Ruts in the ground surface more than 300mm deep",6,"6, similar to Trauma Index of Ruts in the ground surface more than 300mm deep",null,null,null,null,400,1.1000000000000001,1.1000000000000001,1.2,1.3,1.3,1.4,1.4,1.5,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,120,1.298271975957926,null,120,1.190082644628099]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signs breakaway",0.75,null,"Signs breakaway",0.75,"0.75, similar to Trauma Index of Signs breakaway",null,null,null,null,450,1.1000000000000001,1.1000000000000001,1.2,1.2,1.3,1.3,1.4,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slip base or energy absorbing poles",1.9,null,"Slip base or energy absorbing poles",1.9,"1.9, similar to Trauma Index of Slip base or energy absorbing poles",null,null,null,null,500,1.1000000000000001,1.1000000000000001,1.2,1.2,1.2,1.3,1.4,1.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Small wooden sign",0.75,null,"Small wooden sign",0.75,"0.75, similar to Trauma Index of Small wooden sign",null,null,null,null,600,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.2,1.2,1.3,1.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traffic signal pole",8.6,null,"Traffic signal pole",8.6,"8.6, similar to Trauma Index of Traffic signal pole",null,null,null,null,700,1,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.2,1.2,1.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tree with a trunk of 75 to 100mm diameter",0.53,null,"Tree with a trunk of 75 to 100mm diameter",0.53,"0.53, similar to Trauma Index of Tree with a trunk of 75 to 100mm diameter",null,null,null,null,900,1,1,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.2,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tree with a trunk of 150 to 250mm diameter",3.1,null,"Tree with a trunk of 150 to 250mm diameter",3.1,"3.1, similar to Trauma Index of Tree with a trunk of 150 to 250mm diameter",null,null,null,null,1000,1,1,1,1,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tree with a trunk of 250mm and larger in diameter",6.7,null,"Tree with a trunk of 250mm and larger in diameter",6.7,"6.7, similar to Trauma Index of Tree with a trunk of 250mm and larger in diameter",null,null,null,null,1200,1,1,1,1,1,1,1,1.1000000000000001]
[null,"F23",{"$f":"COUNTIF(Workbook!O2:O106,'Risk Score Calculator'!F28)","v":0},null,null,null,null,null,null,null,null,"K23",{"$f":"COUNTIF(Workbook!O2:O106,'Risk Score Calculator'!K28)","v":0},null,"Tree lined edge",6,null,"Tree lined edge",6,"6, similar to Trauma Index of Tree lined edge",null,null,null,null,2000,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utility pole",6.4,null,"Utility pole",6.4,"6.4, similar to Trauma Index of Utility pole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cut 1:6 to 1:3 (All heights) ",0.35,null,"Cut 1:6 to 1:3 (All heights) ",0.35,"0.35, similar to Trauma Index of Cut 1:6 to 1:3 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cut 1:2 (All heights) ",0.61,null,"Cut 1:2 (All heights) ",0.61,"0.61, similar to Trauma Index of Cut 1:2 (All heights) "]
[null,"F27",{"$f":"COUNTIF(Workbook!O2:O106,'Risk Score Calculator'!F32)","v":0},"G27",{"$f":"COUNTIF(Workbook!O2:O106,'Risk Score Calculator'!G32)","v":0},"H27",{"$f":"COUNTIF(Workbook!$O$2:$O$106,'Risk Score Calculator'!H32)","v":0},"I27",{"$f":"COUNTIF(Workbook!$O$2:$O$106,'Risk Score Calculator'!I32)","v":0},"J27",{"$f":"COUNTIF(Workbook!$O$2:$O$106,'Risk Score Calculator'!J32)","v":0},"K27",{"$f":"COUNTIF(Workbook!V2:V2,'Risk Score Calculator'!K32)","v":0},null,"Cut 1:1.5 (All heights) ",0.74,null,"Cut 1:1.5 (All heights) ",0.74,"0.74, similar to Trauma Index of Cut 1:1.5 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cut 1:1 (All heights) ",0.9,null,"Cut 1:1 (All heights) ",0.9,"0.9, similar to Trauma Index of Cut 1:1 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vertical Face (All heights)",0.8,null,"Vertical Face (All heights)",0.8,"0.8, similar to Trauma Index of Vertical Face (All heights)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:6 (All heights) ",0.63,null,"Fill 1:6 (All heights) ",0.63,"0.63, similar to Trauma Index of Fill 1:6 (All heights) "]
[null,null,null,null,null,"AB",{"$f":"MAX(1-((IF('Risk Score Calculator'!F35=\"Yes\",IF(OR('Risk Score Calculator'!F37=\"\",'Risk Score Calculator'!F37>'Risk Score Calculator'!F19),('Risk Score Calculator'!F19/'Risk Score Calculator'!F19)*('Risk Score Calculator'!F36+18),('Risk Score Calculator'!F19/'Risk Score Calculator'!F37)*('Risk Score Calculator'!F36+18)),0)+(IF('Risk Score Calculator'!G35=\"Yes\",IF(OR('Risk Score Calculator'!G37=\"\",'Risk Score Calculator'!G37>'Risk Score Calculator'!F19),('Risk Score Calculator'!F19/'Risk Score Calculator'!F19)*('Risk Score Calculator'!G36+18),('Risk Score Calculator'!F19/'Risk Score Calculator'!G37)*('Risk Score Calculator'!G36+18)),0)+IF('Risk Score Calculator'!H35=\"Yes\",IF(OR('Risk Score Calculator'!H37=\"\",'Risk Score Calculator'!H37>'Risk Score Calculator'!F19),('Risk Score Calculator'!F19/'Risk Score Calculator'!F19)*('Risk Score Calculator'!H36+18),('Risk Score Calculator'!F19/'Risk Score Calculator'!H37)*('Risk Score Calculator'!H36+18)),0)+IF('Risk Score Calculator'!I35=\"Yes\",IF(OR('Risk Score Calculator'!I37=\"\",'Risk Score Calculator'!I37>'Risk Score Calculator'!F19),('Risk Score Calculator'!F19/'Risk Score Calculator'!F19)*('Risk Score Calculator'!I36+18),('Risk Score Calculator'!F19/'Risk Score Calculator'!I37)*('Risk Score Calculator'!I36+18)),0)+(IF('Risk Score Calculator'!J35=\"Yes\",IF(OR('Risk Score Calculator'!J37=\"\",'Risk Score Calculator'!J37>'Risk Score Calculator'!F19),('Risk Score Calculator'!F19/'Risk Score Calculator'!F19)*('Risk Score Calculator'!J36+18),('Risk Score Calculator'!F19/'Risk Score Calculator'!J37)*('Risk Score Calculator'!J36+18)),0)))))/'Risk Score Calculator'!F19,0)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Fill 1:4 (0 to 2m) ",0.69,null,"Fill 1:4 (0 to 2m) ",0.69,"0.69, similar to Trauma Index of Fill 1:4 (0 to 2m) "]
[null,null,null,null,null,"AC",{"$f":"'Risk Score Calculator'!F48*G26","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,"Fill 1:4 (more than 2m) ",0.89,null,"Fill 1:4 (more than 2m) ",0.89,"0.89, similar to Trauma Index of Fill 1:4 (more than 2m) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:3 (0 to 2m)",0.83,null,"Fill 1:3 (0 to 2m)",0.83,"0.83, similar to Trauma Index of Fill 1:3 (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:3 (2 to 5m)",1.4,null,"Fill 1:3 (2 to 5m)",1.4,"1.4, similar to Trauma Index of Fill 1:3 (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:3 (5 to 20m)",1.5,null,"Fill 1:3 (5 to 20m)",1.5,"1.5, similar to Trauma Index of Fill 1:3 (5 to 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:3 (more than 20m)",2.1,null,"Fill 1:3 (more than 20m)",2.1,"2.1, similar to Trauma Index of Fill 1:3 (more than 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:2 (0 to 2m)",1.3,null,"Fill 1:2 (0 to 2m)",1.3,"1.3, similar to Trauma Index of Fill 1:2 (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:2 (2 to 5m)",3.5,null,"Fill 1:2 (2 to 5m)",3.5,"3.5, similar to Trauma Index of Fill 1:2 (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:2 (5 to 10m)",4.5,null,"Fill 1:2 (5 to 10m)",4.5,"4.5, similar to Trauma Index of Fill 1:2 (5 to 10m)"]
[null,null,null,null,null,"AP",{"$f":"IF('Risk Score Calculator'!F28=\"\",\"\",IF(AND('Risk Score Calculator'!F32=\"\",'Risk Score Calculator'!G32=\"\",'Risk Score Calculator'!H32=\"\",'Risk Score Calculator'!I32=\"\",'Risk Score Calculator'!J32=\"\"),1*'Risk Score Calculator'!F48*'Risk Score Calculator'!F46*'Risk Score Calculator'!F55,'Risk Score Calculator'!F46*G27*'Risk Score Calculator'!F55))","v":""},null,null,null,null,null,null,null,"Fill 1:2 (10 to 20m)",6.7,null,"Fill 1:2 (10 to 20m)",6.7,"6.7, similar to Trauma Index of Fill 1:2 (10 to 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:2 (more than 20m)",9.9,null,"Fill 1:2 (more than 20m)",9.9,"9.9, similar to Trauma Index of Fill 1:2 (more than 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:1.5 (0 to 2m)",1.7,null,"Fill 1:1.5 (0 to 2m)",1.7,"1.7, similar to Trauma Index of Fill 1:1.5 (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:1.5 (2 to 5m)",7,null,"Fill 1:1.5 (2 to 5m)",7,"7, similar to Trauma Index of Fill 1:1.5 (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:1.5 (5 to 10m)",14,null,"Fill 1:1.5 (5 to 10m)",14,"14, similar to Trauma Index of Fill 1:1.5 (5 to 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:1.5 (10 to 20m)",27,null,"Fill 1:1.5 (10 to 20m)",27,"27, similar to Trauma Index of Fill 1:1.5 (10 to 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill 1:1.5 (more than 20m)",39,null,"Fill 1:1.5 (more than 20m)",39,"39, similar to Trauma Index of Fill 1:1.5 (more than 20m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.0m (Water 1m and lower deep)",1.2,null,"Drop 0.0m (Water 1m and lower deep)",1.2,"1.2, similar to Trauma Index of Drop 0.0m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.0m (Water 2m deep)",7.2,null,"Drop 0.0m (Water 2m deep)",7.2,"7.2, similar to Trauma Index of Drop 0.0m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.0m (Water 4m deep)",17,null,"Drop 0.0m (Water 4m deep)",17,"17, similar to Trauma Index of Drop 0.0m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.0m (Water 6m and higher deep)",35,null,"Drop 0.0m (Water 6m and higher deep)",35,"35, similar to Trauma Index of Drop 0.0m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.3m (Water 1m and lower deep)",2,null,"Drop 0.3m (Water 1m and lower deep)",2,"2, similar to Trauma Index of Drop 0.3m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.3m (Water 2m deep)",9.9,null,"Drop 0.3m (Water 2m deep)",9.9,"9.9, similar to Trauma Index of Drop 0.3m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.3m (Water 4m deep)",22,null,"Drop 0.3m (Water 4m deep)",22,"22, similar to Trauma Index of Drop 0.3m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 0.3m (Water 6m and higher deep)",38,null,"Drop 0.3m (Water 6m and higher deep)",38,"38, similar to Trauma Index of Drop 0.3m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 2.0m (Water 1m and lower deep)",5.2,null,"Drop 2.0m (Water 1m and lower deep)",5.2,"5.2, similar to Trauma Index of Drop 2.0m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 2.0m (Water 2m deep)",20,null,"Drop 2.0m (Water 2m deep)",20,"20, similar to Trauma Index of Drop 2.0m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 2.0m (Water 4m deep)",30,null,"Drop 2.0m (Water 4m deep)",30,"30, similar to Trauma Index of Drop 2.0m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 2.0m (Water 6m and higher deep)",40,null,"Drop 2.0m (Water 6m and higher deep)",40,"40, similar to Trauma Index of Drop 2.0m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 4.0m (Water 1m and lower deep)",12,null,"Drop 4.0m (Water 1m and lower deep)",12,"12, similar to Trauma Index of Drop 4.0m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 4.0m (Water 2m deep)",28,null,"Drop 4.0m (Water 2m deep)",28,"28, similar to Trauma Index of Drop 4.0m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 4.0m (Water 4m deep)",35,null,"Drop 4.0m (Water 4m deep)",35,"35, similar to Trauma Index of Drop 4.0m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 4.0m (Water 6m and higher deep)",43,null,"Drop 4.0m (Water 6m and higher deep)",43,"43, similar to Trauma Index of Drop 4.0m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 6.0m (Water 1m and lower deep)",19,null,"Drop 6.0m (Water 1m and lower deep)",19,"19, similar to Trauma Index of Drop 6.0m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 6.0m (Water 2m deep)",33,null,"Drop 6.0m (Water 2m deep)",33,"33, similar to Trauma Index of Drop 6.0m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 6.0m (Water 4m deep)",39,null,"Drop 6.0m (Water 4m deep)",39,"39, similar to Trauma Index of Drop 6.0m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 6.0m (Water 6m and higher deep)",45,null,"Drop 6.0m (Water 6m and higher deep)",45,"45, similar to Trauma Index of Drop 6.0m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 8.0m (Water 1m and lower deep)",28,null,"Drop 8.0m (Water 1m and lower deep)",28,"28, similar to Trauma Index of Drop 8.0m (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 8.0m (Water 2m deep)",36,null,"Drop 8.0m (Water 2m deep)",36,"36, similar to Trauma Index of Drop 8.0m (Water 2m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 8.0m (Water 4m deep)",42,null,"Drop 8.0m (Water 4m deep)",42,"42, similar to Trauma Index of Drop 8.0m (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 8.0m (Water 6m and higher deep)",46,null,"Drop 8.0m (Water 6m and higher deep)",46,"46, similar to Trauma Index of Drop 8.0m (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 10.0m or higher (Water 1m and lower deep)",45,null,"Drop 10.0m or higher (Water 1m and lower deep)",45,"45, similar to Trauma Index of Drop 10.0m or higher (Water 1m and lower deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 10.0m or higher (Water 2m deep)",48,null,"Drop 10.0m or higher (Water 2m deep)",48,{"$f":"CONCATENATE(S67,\", similar to Trauma Index of \",R67)","v":"48, similar to Trauma Index of Drop 10.0m or higher (Water 2m deep)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 10.0m or higher (Water 4m deep)",51,null,"Drop 10.0m or higher (Water 4m deep)",51,"51, similar to Trauma Index of Drop 10.0m or higher (Water 4m deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drop 10.0m or higher (Water 6m and higher deep)",52,null,"Drop 10.0m or higher (Water 6m and higher deep)",52,"52, similar to Trauma Index of Drop 10.0m or higher (Water 6m and higher deep)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:6 Foreslope 1:6 Backslope",0.55000000000000004,null,"V Drain 1:6 Foreslope 1:6 Backslope",0.55000000000000004,"0.55, similar to Trauma Index of V Drain 1:6 Foreslope 1:6 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:6 Foreslope 1:4 Backslope",0.59,null,"V Drain 1:6 Foreslope 1:4 Backslope",0.59,"0.59, similar to Trauma Index of V Drain 1:6 Foreslope 1:4 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:6 Foreslope 1:3 Backslope",0.61,null,"V Drain 1:6 Foreslope 1:3 Backslope",0.61,"0.61, similar to Trauma Index of V Drain 1:6 Foreslope 1:3 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:6 Foreslope 1:2 Backslope",0.68,null,"V Drain 1:6 Foreslope 1:2 Backslope",0.68,"0.68, similar to Trauma Index of V Drain 1:6 Foreslope 1:2 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:4 Foreslope 1:4 Backslope",0.68,null,"V Drain 1:4 Foreslope 1:4 Backslope",0.68,"0.68, similar to Trauma Index of V Drain 1:4 Foreslope 1:4 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:4 Foreslope 1:3 Backslope",0.69,null,"V Drain 1:4 Foreslope 1:3 Backslope",0.69,"0.69, similar to Trauma Index of V Drain 1:4 Foreslope 1:3 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:4 Foreslope 1:2 Backslope",0.8,null,"V Drain 1:4 Foreslope 1:2 Backslope",0.8,"0.8, similar to Trauma Index of V Drain 1:4 Foreslope 1:2 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:3 Foreslope 1:4 Backslope",0.73,null,"V Drain 1:3 Foreslope 1:4 Backslope",0.73,"0.73, similar to Trauma Index of V Drain 1:3 Foreslope 1:4 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:3 Foreslope 1:3 Backslope",0.81,null,"V Drain 1:3 Foreslope 1:3 Backslope",0.81,"0.81, similar to Trauma Index of V Drain 1:3 Foreslope 1:3 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:3 Foreslope 1:2 Backslope",0.9,null,"V Drain 1:3 Foreslope 1:2 Backslope",0.9,"0.9, similar to Trauma Index of V Drain 1:3 Foreslope 1:2 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:2 Foreslope 1:3 Backslope",0.9,null,"V Drain 1:2 Foreslope 1:3 Backslope",0.9,"0.9, similar to Trauma Index of V Drain 1:2 Foreslope 1:3 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V Drain 1:2 Foreslope 1:2 Backslope",1,null,"V Drain 1:2 Foreslope 1:2 Backslope",1,"1, similar to Trauma Index of V Drain 1:2 Foreslope 1:2 Backslope"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:6 and flatter (All heights)",0.73,null,"Upslope 1:6 and flatter (All heights)",0.73,"0.73, similar to Trauma Index of Upslope 1:6 and flatter (All heights)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:4 (All heights)",1.0900000000000001,null,"Upslope 1:4 (All heights)",1.0900000000000001,"1.09, similar to Trauma Index of Upslope 1:4 (All heights)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:3 (All heights) ",1.6,null,"Upslope 1:3 (All heights) ",1.6,"1.6, similar to Trauma Index of Upslope 1:3 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:2 (All heights) ",3.3,null,"Upslope 1:2 (All heights) ",3.3,"3.3, similar to Trauma Index of Upslope 1:2 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:1.5 (All heights) ",5,null,"Upslope 1:1.5 (All heights) ",5,"5, similar to Trauma Index of Upslope 1:1.5 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upslope 1:1 (All heights) ",6.5,null,"Upslope 1:1 (All heights) ",6.5,"6.5, similar to Trauma Index of Upslope 1:1 (All heights) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:6 and flatter (0 to 2m)",1,null,"Downslope 1:6 and flatter (0 to 2m)",1,"1, similar to Trauma Index of Downslope 1:6 and flatter (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:6 and flatter (2 to 5m)",1.9,null,"Downslope 1:6 and flatter (2 to 5m)",1.9,"1.9, similar to Trauma Index of Downslope 1:6 and flatter (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:6 and flatter (more than 5m)",2.7,null,"Downslope 1:6 and flatter (more than 5m)",2.7,"2.7, similar to Trauma Index of Downslope 1:6 and flatter (more than 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:4 and flatter (0 to 2m)",1.2,null,"Downslope 1:4 and flatter (0 to 2m)",1.2,"1.2, similar to Trauma Index of Downslope 1:4 and flatter (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:4 and flatter (2 to 5m)",3.7,null,"Downslope 1:4 and flatter (2 to 5m)",3.7,"3.7, similar to Trauma Index of Downslope 1:4 and flatter (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:4 and flatter (5 to 10m)",11,null,"Downslope 1:4 and flatter (5 to 10m)",11,"11, similar to Trauma Index of Downslope 1:4 and flatter (5 to 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:4 and flatter (more than 10m)",14,null,"Downslope 1:4 and flatter (more than 10m)",14,"14, similar to Trauma Index of Downslope 1:4 and flatter (more than 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:3 and flatter (0 to 2m)",1.2,null,"Downslope 1:3 and flatter (0 to 2m)",1.2,"1.2, similar to Trauma Index of Downslope 1:3 and flatter (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:3 and flatter (2 to 5m)",4.4000000000000004,null,"Downslope 1:3 and flatter (2 to 5m)",4.4000000000000004,"4.4, similar to Trauma Index of Downslope 1:3 and flatter (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:3 and flatter (5 to 10m)",17,null,"Downslope 1:3 and flatter (5 to 10m)",17,"17, similar to Trauma Index of Downslope 1:3 and flatter (5 to 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:3 and flatter (more than 10m)",25,null,"Downslope 1:3 and flatter (more than 10m)",25,"25, similar to Trauma Index of Downslope 1:3 and flatter (more than 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:2 and flatter (0 to 2m)",1.2,null,"Downslope 1:2 and flatter (0 to 2m)",1.2,"1.2, similar to Trauma Index of Downslope 1:2 and flatter (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:2 and flatter (2 to 5m)",4.5,null,"Downslope 1:2 and flatter (2 to 5m)",4.5,"4.5, similar to Trauma Index of Downslope 1:2 and flatter (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:2 and flatter (5 to 10m)",21,null,"Downslope 1:2 and flatter (5 to 10m)",21,"21, similar to Trauma Index of Downslope 1:2 and flatter (5 to 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:2 and flatter (more than 10m)",38,null,"Downslope 1:2 and flatter (more than 10m)",38,"38, similar to Trauma Index of Downslope 1:2 and flatter (more than 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:1.5 and flatter (0 to 2m)",1.2,null,"Downslope 1:1.5 and flatter (0 to 2m)",1.2,"1.2, similar to Trauma Index of Downslope 1:1.5 and flatter (0 to 2m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:1.5 and flatter (2 to 5m)",4.5,null,"Downslope 1:1.5 and flatter (2 to 5m)",4.5,"4.5, similar to Trauma Index of Downslope 1:1.5 and flatter (2 to 5m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:1.5 and flatter (5 to 10m)",21,null,"Downslope 1:1.5 and flatter (5 to 10m)",21,"21, similar to Trauma Index of Downslope 1:1.5 and flatter (5 to 10m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Downslope 1:1.5 and flatter (more than 10m)",42,null,"Downslope 1:1.5 and flatter (more than 10m)",42,"42, similar to Trauma Index of Downslope 1:1.5 and flatter (more than 10m)"]