{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Project Information","Report","Rural Multilane Site Total","Multi-Year Summary","Multi-Year Analysis Report","Divided Segment Template","Undivided Segment Template","Intersection Template","Multi-Year Template","Segment Tables","Intersection Tables","Construction"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":37,"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":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,2,38,14],[39,2,39,14],[30,2,30,14],[31,2,31,14],[32,2,32,14],[35,2,35,14],[36,2,36,14],[26,2,26,14],[27,2,27,14],[28,2,28,14],[29,2,29,14],[37,2,37,14],[1,2,1,14],[4,2,4,14],[23,2,23,14],[24,2,24,14],[25,2,25,14],[19,2,19,14]]}
[]
[null,null,"HSM Part C Training Tool Instructions"]
[]
[null,null,"Overview"]
[null,null,"This series of spreadsheets has been developed to assist in the application of the predictive methods contained in the Highway Safety Manual (HSM), 1st Edition for analyzing: urban and suburban arterials, rural multilane roads, and rural two lane roads.  "]
[]
[null,null,"Data Color Guidelines"]
[]
[null,null,null,"    Required user input data"]
[]
[null,null,null,"    Required user input data restricted to dropdown values"]
[]
[null,null,null,"    Automatically updated information based on previous user input data"]
[]
[null,null,null,"    User work space (notes, comments, etc.)"]
[]
[null,null,"Upon Opening the File"]
[null,null,"1.    Ensure that macros are enabled in Excel.  (Refer to Microsoft Help for more information about enabling macros.)"]
[null,null,"2.    Read the terms of use and follow the directions on the prompts."]
[null,null,"3.    If analyzing a new project, follow the prompts to save as a new file."]
[null,null,"4.    Read all instructions before proceeding."]
[]
[null,null,"General Steps for Project Safety Performance Analysis"]
[null,null,"1.       Navigate to the “Project Information” tab."]
[null,null,"2.       Using the color guidelines above, populate the required information under General Information."]
[null,null,"3.       Push the “Update Element Table” button to set up the element table.  *Note: Elements cannot be added to the analysis once this button has been pushed."]
[null,null,"4.       Fill in the Route, Location Description, and Jurisdiction for each element.  For intersections, also select whether or not the intersection is signalized.  And where applicable, select divided or undivided for each segment."]
[null,null,"5.       Once all of the information has been entered, push the “Proceed to 1st Element” button."]
[null,null,"6.       On the current tab (either “Segment 1” or “Intersection 1”), enter all of the required information (refer to color guidelines)."]
[null,null,"7.       Ensure that all necessary information has been entered, then push the “Next Element” button."]
[null,null,"8.       Repeat steps 6 and 7 for all project elements."]
[null,null,"9.       On the tab for the final project element, push the \"Generate Report\" button to run the analysis and redirect to the “Report” page, giving a summary of the analysis results."]
[null,null,"10.   At this time, any of the input information on the element tabs can be altered if desired.  The results will update automatically."]
[]
[null,null,"General Steps for a Multi-Year Project Safety Performance Analysis"]
[null,null,"1.       Complete all steps for the Project Safety Performance Analysis first."]
[null,null,"2.       Navigate to the “Multi-Year Analysis Inputs” tab."]
[null,null,"3.       Enter the required information (Input Data*).  Refer to color guidelines as necessary. *Note: the Traffic Growth Rate is a linear growth rate per year (i.e. the volume increases by the same number of vehicles each year) and should be entered as a percent, not as a decimal."]
[null,null,"4.       Once all of the information is complete, push the “Run Multi-Year Analysis” button to perform the analysis."]
[null,null,"5.       The “Multi-Year Summary Report” tab provides a summary table of the multi-year analysis, with the expected average crash frequency, the potential for safety improvement, and a discussion of the results for the analysis period."]

{"sheet":"Project Information","index":1,"n_rows":29,"n_cols":38,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,8,15,8],[16,0,16,8],[18,0,18,8],[0,0,0,8],[14,1,15,1],[14,2,15,2],[14,5,15,5],[14,6,15,6],[14,7,15,7],[12,4,15,4],[12,5,12,7],[13,0,15,0],[13,1,13,2],[13,3,15,3],[13,6,13,7],[6,1,6,2],[10,1,10,2],[11,1,11,2],[12,0,12,3],[0,11,0,22],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
["PROJECT SAFETY PERFORMANCE ANALYSIS INPUT SHEET",null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["General Information"]
["Project Name","Practical Case Study",null,"Contact Email",null,"email"]
["Project Description","Three Signalized Intersections",null,"Contact Phone",null,1234567891]
["Reference Number","STARS Report A-1",null,"Date Performed",null,"2011-05-12"]
["Analyst","John Smith",null,"Analysis Year",null,2011]
["Agency/Company","ABC Company",null,"Multiple Year Analysis?"]
[]
[]
[]
["# of Segments in Analysis",1,null,"Predicted/expected crashes"]
["# of Intersections in Analysis",1]
[null,null,null,null,"ANALYSIS YEAR"]
["INDIVIDUAL PROJECT ELEMENTS","LOCATION INFORMATION",null,"JURISDICTION",null,"INTERSECTIONS ONLY","DETERMINING FOR PROJECT ELEMENT:",null,"SEGMENTS ONLY"]
[null,"Route","Location Description",null,null,"Signalized or Unsignalized?","Typical site safety performance (predicted average crash frequency)","Anticipated long-term safety performance (expected average crash frequency)","Divided or Undivided?"]
[]
["SEGMENTS"]
[]
["INTERSECTIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Year"]

{"sheet":"Report","index":2,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,13,0,23],[11,1,11,3],[11,4,11,6],[11,7,11,9],[0,0,0,9],[1,0,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,0,10,9],[12,0,14,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[13,3,14,3],[13,6,14,6],[13,9,14,9],[21,0,22,9],[23,0,24,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[24,4,24,5],[24,6,24,7],[24,8,24,9],[25,0,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,0,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[34,0,34,9],[35,0,35,9],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[32,0,32,9],[33,0,33,9]]}
["PROJECT SAFETY PERFORMANCE SUMMARY REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["General Information"]
["Project Name",{"$f":"'Project Information'!B3","v":"Practical Case Study"}]
["Project Description",{"$f":"'Project Information'!B4","v":"Three Signalized Intersections"}]
["Reference Number",{"$f":"'Project Information'!B5","v":"STARS Report A-1"}]
["Analyst",{"$f":"'Project Information'!B6","v":"John Smith"}]
["Agency/Company",{"$f":"'Project Information'!B7","v":"ABC Company"}]
["Contact Email",{"$f":"'Project Information'!F3","v":"email"}]
["Contact Phone",{"$f":"'Project Information'!F4","v":1234567891}]
["Date Completed",{"$f":"'Project Information'!F5","v":"2011-05-12"}]
["PROJECT SUMMARY"]
[null,"Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
["Project Element","(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
["INDIVIDUAL SEGMENTS"]
[]
["INDIVIDUAL INTERSECTIONS"]
[]
["COMBINED (sum of column)"]
[]
["PROJECT SUMMARY -- Site-Specific EB Method Summary Results for Rural Multilane Roads"]
[]
["Crash severity level",null,null,null,"N predicted(PROJECT)",null,"N expected (PROJECT)",null,"N potential for improvement (PROJECT)"]
[null,null,null,null,"Predicted average crash frequency - Average safety performance of projects consisting of similar elements (anticipated average crashes/yr)",null,"Expected average crash frequency - Actual long-term safety performance of the project (anticipated average crashes/yr)",null,"Potential for Safety Improvement (anticipated average crashes/yr)"]
["Fatal and injury (KABC)",null,null,null,{"$f":"+E20","v":0},null,{"$f":"+F20","v":0},null,{"$f":"+IF(G26>=E26,+G26-E26,\"N/A\")","v":0}]
["Property damage only (PDO)",null,null,null,{"$f":"+H20","v":0},null,{"$f":"+I20","v":0},null,{"$f":"+IF(G27>=E27,+G27-E27,\"N/A\")","v":0}]
["Total (KABCO)",null,null,null,{"$f":"+B20","v":0},null,{"$f":"+C20","v":0},null,{"$f":"+IF(G28>=E28,+G28-E28,\"N/A\")","v":0}]
[]
[]
["Discussion of Results"]
["Given the potential effects of project characteristics on safety performance, results indicate that:"]
[{"$f":"IFERROR(+CONCATENATE(\"1.  It is anticipated that the project will, on average, experience \",+ROUND(G28,1),\" crashes per year (\",ROUND(G26,1),\" fatal and injury crashes per year; and \",+ROUND(G27,1),\" property damage only crashes per year).\"),\"\")","v":"1.  It is anticipated that the project will, on average, experience 0 crashes per year (0 fatal and injury crashes per year; and 0 property damage only crashes per year)."}]
[{"$f":"IFERROR(+CONCATENATE(\"2. A similar project is anticipated, on average, to experience \",+(ROUND(E28,1)),\" crashes per year (\",+ROUND(E26,1),\" fatal and injury crashes per year; and \",+ROUND(E27,1),\" property damage only crashes per year).\"),\"\")","v":"2. A similar project is anticipated, on average, to experience 0 crashes per year (0 fatal and injury crashes per year; and 0 property damage only crashes per year)."}]
[{"$f":"IFERROR(+IF(I28=\"N/A\",\"\",+CONCATENATE(\"3.  It is anticipated the project has, on average, a potential for safety improvement of \",ROUND(I28,1),\" crashes per year (\",+ROUND(I26,1),\" fatal and injury crashes per year; and \",+ROUND(I27,1),\" property damage only crashes per year).\")),\"\")","v":"3.  It is anticipated the project has, on average, a potential for safety improvement of 0 crashes per year (0 fatal and injury crashes per year; and 0 property damage only crashes per year)."}]

{"sheet":"Rural Multilane Site Total","index":3,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":true,"merged":[[2,14,2,20],[5,10,7,10],[5,9,10,9],[21,2,21,4],[2,1,3,11],[4,1,4,2],[8,11,10,11],[8,10,10,10],[5,11,7,11],[8,4,10,4],[8,5,10,5],[5,6,7,8],[8,8,10,8],[8,7,10,7],[8,6,10,6],[5,1,10,2],[15,1,15,2],[5,3,7,5],[8,3,10,3],[27,5,27,7],[26,5,26,7],[25,5,25,7],[24,5,24,7],[22,2,22,4],[19,2,20,10],[27,2,28,4],[25,2,26,4],[23,2,24,4],[23,5,23,7],[22,5,22,7],[21,5,21,7],[28,8,28,10],[27,8,27,10],[21,8,21,10],[28,5,28,7],[26,8,26,10],[25,8,25,10],[24,8,24,10],[23,8,23,10],[22,8,22,10]]}
[]
[]
[null,"Worksheet 3A -- Predicted and Observed Crashes by Severity and Site Type Using the Site-Specific EB Method",null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
[]
[null,"(1)",null,"(2)","(3)","(4)","(5)","(5)","(5)","(6)","(7)","(8)"]
[null,"Site type",null,"Predicted average crash frequency (crashes/year)",null,null,"Observed crashes (crashes/year)",null,null,"Overdispersion Parameter, k","Weighted adjustment, w","Expected average crash frequency, Nexpected"]
[]
[]
[null,null,null,"N predicted \n(TOTAL)"," N predicted      \n(FI)"," N predicted    (PDO)","Nobserved \n(TOTAL)","Nobserved \n(FI)","Nobserved \n(PDO)",null,"Equation A-5 from Part C Appendix","Equation   A-4 from Part C Appendix"]
[]
[]
[null,"ROADWAY SEGMENTS"]
[]
[null,"INTERSECTIONS"]
[]
[null,"COMBINED (sum of column)"]
[]
[]
[]
[null,null,"Worksheet 3B -- Site-Specific EB Method Summary Results"]
[]
[null,null,"(1)",null,null,"(2)",null,null,"(3)"]
[null,null,"Crash severity level",null,null,"N predicted",null,null,"N expected"]
[null,null,"Total",null,null,"(2)COMB from Worksheet 3A",null,null,"(8)COMB from Worksheet 3A"]
[null,null,null,null,null,{"$f":"+D16","v":0},null,null,{"$f":"+L16","v":0}]
[null,null,"Fatal and injury (FI)",null,null,"(3)COMB from Worksheet 3A",null,null,"(3)TOTAL * (2)FI / (2) TOTAL"]
[null,null,null,null,null,{"$f":"+E16","v":0},null,null,{"$f":"+L16*E16/D16","v":{"$error":"#DIV/0!"}}]
[null,null,"Property damage only (PDO)",null,null,"(4)COMB from Worksheet 3A",null,null,"(3)TOTAL * (2)PDO / (2) TOTAL"]
[null,null,null,null,null,{"$f":"+F16","v":0},null,null,{"$f":"+L16*F16/D16","v":{"$error":"#DIV/0!"}}]

{"sheet":"Multi-Year Summary","index":4,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[10,0,11,0],[10,1,10,3],[10,4,10,6],[10,7,10,9],[3,0,3,3],[4,0,4,1],[4,2,4,3],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3]]}
["MULTIPLE-YEAR ANALYSIS SUMMARY FOR RURAL MULTILANE ROADS"]
[]
[]
["General Information"]
["Base Year"]
["Analysis Period (Years)"]
["Linear Traffic Growth Rate (annual %)"]
[]
[]
[{"$f":"CONCATENATE(C6,\"-Year Analysis Summary Report\")","v":"-Year Analysis Summary Report"}]
["Analysis Year","Predicted Average Crash Frequency \n(Npredicted)",null,null,"Expected Average Crash Frequency \n(Nexpected)",null,null,"Potential for Safety Improvement \n(crashes/yr)"]
[null,"KABC","PDO","Total (KABCO)","KABC","PDO","Total (KABCO)","KABC","PDO","Total (KABCO)"]

{"sheet":"Multi-Year Analysis Report","index":5,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[[33,0,33,8],[34,0,34,8],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[31,0,31,8],[32,0,32,8],[25,0,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,0,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[23,4,23,5],[23,6,23,7],[23,8,23,9],[24,4,24,5],[24,6,24,7],[24,8,24,9],[12,1,12,9],[13,0,13,9],[15,0,15,9],[16,0,17,0],[16,1,16,3],[16,4,16,6],[16,7,16,9],[0,12,0,22],[11,1,11,9],[0,0,0,9],[1,0,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9]]}
["MULTIPLE YEAR PROJECT SAFETY PERFORMANCE SUMMARY REPORT FOR RURAL MULTILANE ROADS",null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["General Information"]
["Project Name","Practical Case Study"]
["Project Description","Three Signalized Intersections"]
["Reference Number","STARS Report A-1"]
["Analyst","John Smith"]
["Agency/Company","ABC Company"]
["Contact Email","email"]
["Contact Phone",1234567891]
["Date Completed","2011-05-12"]
["Base Year"]
["Analysis Period (Years)"]
["Linear Traffic Growth Rate (annual %)"]
["PROJECT SUMMARY"]
[]
[{"$f":"CONCATENATE(B12,\"-Year Analysis Summary Report\")","v":"-Year Analysis Summary Report"}]
["Analysis Year","Predicted Average Crash Frequency \n(Npredicted)",null,null,"Expected Average Crash Frequency \n(Nexpected)",null,null,"Potential for Safety Improvement \n(crashes/yr)"]
[null,"KABC","PDO","Total (KABCO)","KABC","PDO","Total (KABCO)","KABC","PDO","Total (KABCO)"]
[{"$f":"B11","v":0}]
["Total"]
[]
[]
["PROJECT SUMMARY -- Site-Specific EB Method Summary Results for Rural Multilane Roads"]
[null,null,null,null,"N predicted(PROJECT)",null,"N expected (PROJECT)",null,"N potential for improvement (PROJECT)"]
["Crash severity level",null,null,null,{"$f":"+CONCATENATE(\"Predicted average crash frequency - Average safety performance of projects consisting of similar elements (anticipated total number of crashes over \",B12,\" years)\")","v":"Predicted average crash frequency - Average safety performance of projects consisting of similar elements (anticipated total number of crashes over  years)"},null,{"$f":"+CONCATENATE(\"Expected average crash frequency - Average long-term safety performance of the project (anticipated total number of crashes over \",B12,\" years)\")","v":"Expected average crash frequency - Average long-term safety performance of the project (anticipated total number of crashes over  years)"},null,{"$f":"+CONCATENATE(\"Potential safety performance - Average project performance compared to threshold set by typical other similar projects (anticipated total number of crashes over \",B12,\" years)\")","v":"Potential safety performance - Average project performance compared to threshold set by typical other similar projects (anticipated total number of crashes over  years)"}]
["Fatal and injury crashes (KABC)",null,null,null,{"$f":"+B20","v":0},null,{"$f":"+E20","v":0},null,{"$f":"+IF(G26>=E26,+G26-E26,\"N/A\")","v":0}]
["Property damage only crashes (PDO)",null,null,null,{"$f":"+C20","v":0},null,{"$f":"+F20","v":0},null,{"$f":"+IF(G27>=E27,+G27-E27,\"N/A\")","v":0}]
["Total crashes (KABCO)",null,null,null,{"$f":"+D20","v":0},null,{"$f":"+G20","v":0},null,{"$f":"+IF(G28>=E28,+G28-E28,\"N/A\")","v":0}]
[]
[]
["Discussion of Results"]
[{"$f":"+CONCATENATE(\"Given the potential effects of project characteristics on safety performance and assuming a \",100*B13, \" % growth in AADT over a \",B12, \" year analysis period with \",B11,\" as the base year, results indicate that:\")","v":"Given the potential effects of project characteristics on safety performance and assuming a 0 % growth in AADT over a  year analysis period with  as the base year, results indicate that:"}]
[{"$f":"IFERROR(+CONCATENATE(\"1.  The project is anticipated, on average, to experience \", +ROUND(G28,1),\" crashes  over a \",B12, \" year analysis period (\",+(ROUND(G26,1)),\" fatal and injury crashes; and \",+ROUND(G27,1),\" property damage only crashes).\"),\"\")","v":"1.  The project is anticipated, on average, to experience 0 crashes  over a  year analysis period (0 fatal and injury crashes; and 0 property damage only crashes)."}]
[{"$f":"IFERROR(+CONCATENATE(\"2. A similar project is anticipated, on average, to experience \", +(ROUND(E28,1)),\" crashes  over a \",B12, \" year analysis period (\", +ROUND(E26,1),\" fatal and injury crashes over \",B12,\" years; and \",+ROUND(E27,1),\" property damage only crashes over \",B12,\" years).\"),\"\")","v":"2. A similar project is anticipated, on average, to experience 0 crashes  over a  year analysis period (0 fatal and injury crashes over  years; and 0 property damage only crashes over  years)."}]
[{"$f":"IFERROR(+IF(I28=\"N/A\",\"\",+CONCATENATE(\"3.  It is anticipated the project will have an average potential for safety improvement of \",ROUND(I28,1),\" crashes  over a \",B12, \" year analysis period (\",+ROUND(I26,1),\" fatal and injury crashes over \",B12,\" years; and \",+ROUND(I27,1),\" property damage only crashes over \",B12,\" years).\")),\"\")","v":"3.  It is anticipated the project will have an average potential for safety improvement of 0 crashes  over a  year analysis period (0 fatal and injury crashes over  years; and 0 property damage only crashes over  years)."}]

{"sheet":"Divided Segment Template","index":6,"n_rows":89,"n_cols":37,"rows_kept":89,"cut":false,"hidden":true,"merged":[[88,2,88,11],[0,16,0,21],[8,11,8,13],[7,11,7,13],[9,7,9,10],[8,7,8,10],[7,7,7,10],[3,0,3,1],[4,0,4,1],[18,7,18,10],[17,7,17,10],[16,7,16,10],[15,7,15,10],[14,7,14,10],[13,7,13,10],[12,7,12,10],[9,0,9,6],[18,0,18,6],[16,0,16,6],[17,0,17,6],[13,0,13,6],[15,0,15,6],[14,0,14,6],[11,7,11,10],[10,11,10,13],[9,11,9,13],[11,24,11,25],[16,24,18,28],[5,24,6,28],[7,24,8,25],[7,26,7,28],[14,24,14,25],[10,24,10,25],[15,24,15,25],[12,24,12,25],[9,24,9,25],[13,24,13,25],[17,11,17,13],[16,11,16,13],[15,11,15,13],[14,11,14,13],[13,11,13,13],[11,11,11,13],[10,14,10,15],[12,11,12,13],[18,11,18,13],[71,11,71,13],[72,0,72,2],[72,3,72,7],[74,0,74,2],[58,12,58,13],[62,0,62,1],[62,3,62,4],[62,6,62,7],[62,9,62,10],[62,12,62,13],[63,0,63,1],[63,3,63,4],[63,6,63,7],[63,9,63,10],[61,12,61,13],[59,0,59,1],[59,3,59,4],[59,6,59,7],[59,9,59,10],[59,12,59,13],[65,0,65,13],[60,0,60,1],[60,3,60,4],[60,6,60,7],[76,0,76,13],[68,0,68,13],[69,0,69,2],[69,3,69,7],[74,11,74,13],[72,11,72,13],[73,0,73,2],[73,3,73,7],[73,8,73,10],[74,8,74,10],[69,8,69,10],[69,11,69,13],[70,0,71,2],[70,3,70,7],[70,8,71,10],[70,11,70,13],[71,3,71,7],[72,8,72,10],[74,3,74,7],[73,11,73,13],[75,0,75,2],[75,3,75,7],[75,8,75,10],[75,11,75,13],[60,9,60,10],[60,12,60,13],[61,0,61,1],[61,3,61,4],[61,6,61,7],[61,9,61,10],[63,12,63,13],[64,0,64,1],[64,3,64,4],[64,6,64,7],[64,9,64,10],[64,12,64,13],[58,0,58,1],[58,3,58,4],[58,6,58,7],[58,9,58,10],[52,9,54,10],[57,0,57,1],[57,3,57,4],[57,6,57,7],[55,3,56,4],[55,5,56,5],[57,12,57,13],[52,0,56,1],[52,2,54,2],[52,3,54,4],[52,5,54,5],[55,11,56,11],[52,11,54,11],[52,12,54,13],[55,2,56,2],[55,6,56,7],[55,8,56,8],[55,9,56,10],[52,6,54,7],[52,8,54,8],[57,9,57,10],[55,12,56,13],[46,0,46,13],[50,0,50,13],[51,0,51,1],[51,3,51,4],[51,6,51,7],[51,9,51,10],[51,12,51,13],[45,12,45,13],[44,9,45,10],[44,11,45,11],[44,12,44,13],[44,0,45,1],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,6],[41,0,41,1],[41,5,41,6],[41,7,41,8],[41,9,41,10],[44,7,45,8],[43,0,43,1],[43,5,43,6],[43,7,43,8],[43,9,43,10],[42,0,42,1],[42,5,42,6],[42,7,42,8],[42,9,42,10],[38,0,40,1],[38,2,38,4],[38,5,39,6],[38,7,39,8],[38,9,38,10],[38,11,40,11],[39,2,39,4],[39,9,40,10],[40,5,40,6],[40,7,40,8],[36,0,36,13],[37,0,37,1],[37,2,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[32,7,32,8],[32,9,32,11],[32,12,32,13],[28,5,29,6],[28,7,29,8],[28,9,29,11],[28,12,29,13],[32,0,32,1],[32,2,32,4],[32,5,32,6],[31,0,31,1],[31,2,31,4],[31,5,31,6],[1,0,1,13],[2,0,2,6],[2,7,2,13],[4,7,4,9],[4,10,4,13],[3,7,3,9],[7,0,7,6],[3,10,3,13],[6,7,6,9],[6,10,6,13],[5,7,5,9],[5,10,5,13],[5,0,5,1],[6,0,6,1],[6,2,6,6],[5,2,5,6],[4,2,4,6],[3,2,3,6],[40,12,40,13],[38,12,39,13],[37,12,37,13],[10,0,10,3],[10,7,10,10],[8,0,8,6],[19,0,19,10],[12,0,12,6],[11,0,11,6],[30,12,30,13],[27,12,27,13],[31,7,31,8],[31,9,31,11],[31,12,31,13],[30,0,30,1],[30,2,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,11],[27,7,27,8],[27,9,27,11],[27,0,27,1],[28,0,29,1],[28,2,29,4],[87,2,87,11],[20,14,24,14],[21,9,21,10],[20,9,20,10],[20,0,21,5],[80,2,81,11],[82,2,86,2],[82,3,82,5],[82,6,82,8],[82,9,82,11],[83,3,83,5],[83,6,83,8],[83,9,83,11],[84,5,85,5],[84,8,85,8],[84,11,85,11],[20,7,20,8],[21,7,21,8],[26,0,26,13],[43,12,43,13],[42,12,42,13],[41,12,41,13],[27,2,27,4],[27,5,27,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["Worksheet 1A (a) -- General Information and Input Data for Rural Multilane Roadway Segments"]
["General Information",null,null,null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with CMFs for Specific Segment AADT values:"]
["Analyst",null,{"$f":"'Project Information'!B6","v":"John Smith"},null,null,null,null,"Roadway",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,2,FALSE)","v":{"$error":"#N/A"}}]
["Agency or Company",null,{"$f":"'Project Information'!B7","v":"ABC Company"},null,null,null,null,"Roadway Section",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,3,FALSE)","v":{"$error":"#N/A"}}]
["Date Performed",null,{"$f":"'Project Information'!F5","v":"2011-05-12"},null,null,null,null,"Jurisdiction",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-16: CMF for Lane Width on Divided Roadway Segments (CMFRA)"]
["Segment for Analysis",null,null,null,null,null,null,"Analysis Year",null,null,{"$f":"'Project Information'!F6","v":2011}]
["Input Data",null,null,null,null,null,null,"Site Conditions",null,null,null,"Base Conditions",null,null,null,null,null,null,null,null,null,null,null,null,"Lane Width (ft)",null,"AADT (veh/day)"]
["Roadway type (divided / undivided)",null,null,null,null,null,null,"Divided",null,null,null,"Undivided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 400","400 to 2000","> 2000"]
["Length of segment, L (mi)",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,9,null,1.03,{"$f":"1.03+0.000138*('Divided Segment Template'!$H$11-400)","v":0.9748},1.25]
["AADT (veh/day)",null,null,null,"AADTMAX =",89300,"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(H11>F11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"},null,null,null,null,null,null,null,null,null,9.5,null,{"$f":"+(AA10+AA12)/2","v":1.02},{"$f":"+(AB10+AB12)/2","v":0.97489999999999999},{"$f":"+(AC10+AC12)/2","v":1.2}]
["Lane width (ft)",null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.01,{"$f":"1.01+0.0000875*('Divided Segment Template'!$H$11-400)","v":0.97499999999999998},1.1499999999999999]
["Shoulder width (ft) - right shoulder width for divided [if differ for directions of travel, use average width]",null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,10.5,null,{"$f":"+(AA12+AA14)/2","v":1.01},{"$f":"+(AB12+AB14)/2","v":0.99},{"$f":"+(AC12+AC14)/2","v":1.0899999999999999}]
["Shoulder type - right shoulder type for divided",null,null,null,null,null,null,null,null,null,null,"Paved",null,null,null,null,null,null,null,null,null,null,null,null,11,null,1.01,{"$f":"1.01+0.0000125*('Divided Segment Template'!$H$11-400)","v":1.0050000000000001},1.03]
["Median width (ft) - for divided only",null,null,null,null,null,null,null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,11.5,null,{"$f":"+(AA14+AA16)/2","v":1.0049999999999999},{"$f":"+(AB14+AB16)/2","v":1.0024999999999999},{"$f":"+(AC14+AC16)/2","v":1.0150000000000001}]
["Side Slopes - for undivided only",null,null,null,null,null,null,"Not Applicable",null,null,null,"1:7 or flatter",null,null,null,null,null,null,null,null,null,null,null,null,12,null,1,1,1]
["Lighting (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,"Note: The collision types related to lane width to which this CMF applies include run-off-the-road, head-on crashes, and sideswipes."]
["Auto speed enforcement (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present"]
["Calibration Factor, Cr",null,null,null,null,null,null,1,null,null,null,1]
["Average Annual Crash History (3 or 5-yr average)"]
["           Segment crashes",null,null,null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,"If inputs are complete, click for next element"]
[null,null,null,null,null,null,"PDO","Property Damage Only",null,0]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.11-6 in Part C of the HSM)"]
[]
[]
[]
["Worksheet 1B (a) -- Crash Modification Factors for Rural Multilane Divided Roadway Segments"]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,null,"(6)"]
["CMF for Lane Width",null,"CMF for Right Shoulder Width",null,null,"CMF for Median Width",null,"CMF for Lighting",null,"CMF for Automated Speed Enforcement",null,null,"Combined CMF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base AADT"]
[]
["CMF 1rd",null,"CMF 2rd",null,null,"CMF 3rd",null,"CMF 4rd",null,"CMF 5rd",null,null,"CMF comb"]
["from Equation 11-16",null,"from Table 11-17",null,null,"from Table 11-18",null,"from Equation 11-17",null,"from Section 11.7.2",null,null,"(1)*(2)*(3)*(4)*(5)"]
[{"$f":"((IF($H$11>2000,(VLOOKUP($H$12,'Divided Segment Template'!$Y$10:$AC$16,5,FALSE)),IF($H$11<400,(VLOOKUP($H$12,'Divided Segment Template'!$Y$10:$AC$16,3,FALSE)),(VLOOKUP($H$12,'Divided Segment Template'!$Y$10:$AC$16,4)))))-1)*(IF('Segment Tables'!D24=\"No\",'Segment Tables'!E32,'Segment Tables'!I32))+1","v":{"$error":"#N/A"}},null,{"$f":"IF(H14=\"Paved\",VLOOKUP(H13,'Segment Tables'!AC10:AG20,3,FALSE),1)","v":1},null,null,{"$f":"VLOOKUP(H15,'Segment Tables'!AC29:AF38,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF($H$17=\"Present\",(1-(IF('Segment Tables'!$D$53=\"No\",((1-(0.72*'Segment Tables'!$E$57)-(0.83*'Segment Tables'!$F$57))*'Segment Tables'!$G$57),((1-(0.72*'Segment Tables'!$I$57)-(0.83*'Segment Tables'!$J$57))*'Segment Tables'!$K$57)))),1)","v":1},null,{"$f":"IF($H$18=\"Present\",0.94,1)","v":1},null,null,{"$f":"$A$33*$C$33*$F$33*$H$33*$J$33","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1C (a) -- Roadway Segment Crashes for Rural Multilane Divided Roadway Segments"]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)"]
["Crash Severity Level",null,"SPF Coefficients",null,null,"N spf rd",null,"Overdispersion Parameter, k",null,"Combined CMFs",null,"Calibration Factor, Cr","Predicted average crash frequency, N predicted rs(d)"]
[null,null,"from Table 11-5",null,null,null,null,null,null,"(6) from Worksheet   1B (a)"]
[null,null,"a","b","c","from Equation 11-9",null,"from Equation 11-10",null,null,null,null,"(3)*(5)*(6)"]
["Total",null,-9.0250000000000004,1.0489999999999999,1.5489999999999999,{"$f":"EXP($C$42+$D$42*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$42+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F42*J42*L42","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,-8.8369999999999997,0.95799999999999996,1.6870000000000001,{"$f":"EXP($C$43+$D$43*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$43+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F43*J43*L43","v":{"$error":"#NUM!"}}]
["Fatal and Injurya (FIa)",null,-8.5050000000000008,0.874,1.74,{"$f":"EXP($C$44+$D$44*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$44+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F44*J44*L44","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,"--","--","--","--",null,"--",null,"--",null,"--","(7)TOTAL - (7)FI"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M42-M43","v":{"$error":"#NUM!"}}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[]
["Worksheet 1D (a) -- Crashes by Severity Level and Collision Type for Rural Multilane Divided Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)","(5)",null,"(6)","(7)",null,"(8)","(9)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted rs(d) (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)","N predicted rs(d) (FI) (crashes/year)",null,"Proportion of Collision Type (FIa)","N predicted rs (FIa) (crashes/year)",null,"Proportion of Collision Type (PDO)","N predicted rs(d) (PDO) (crashes/year)"]
[]
[]
[null,null,"from Table 11-6","(7)TOTAL from Worksheet 1C (a)",null,"from Table 11-6","(7)FI from Worksheet 1C (a)",null,"from Table 11-6","(7) FIa from Worksheet 1C (a)",null,"from Table 11-6","(7)PDO from Worksheet 1C (a)"]
[]
["Total",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",SUM('Segment Tables'!$E$26:$E$31),SUM('Segment Tables'!$I$26:$I$31))","v":1},{"$f":"+M42","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",SUM('Segment Tables'!$F$26:$F$31),SUM('Segment Tables'!$J$26:$J$31))","v":1},{"$f":"+M43","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",SUM('Segment Tables'!$G$26:$G$31),SUM('Segment Tables'!$K$26:$K$31))","v":1},{"$f":"+M44","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!D$24=\"No\",SUM('Segment Tables'!$H$26:$H$31),SUM('Segment Tables'!$L$26:$L$31))","v":1},{"$f":"+M46","v":{"$error":"#NUM!"}}]
[null,null,null,"(2)*(3)TOTAL",null,null,"(4)x(5)FI",null,null,"(6)*(7) FI a",null,null,"(8)*(9) PDO"]
["Head-on collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E26,'Segment Tables'!I26)","v":6.0000000000000001E-3},{"$f":"+C60*$D$58","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F26,'Segment Tables'!J26)","v":1.2999999999999999E-2},{"$f":"+F60*$G$58","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G26,'Segment Tables'!K26)","v":1.7999999999999999E-2},{"$f":"+$J$58*I60","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H26,'Segment Tables'!L26)","v":2E-3},{"$f":"+$M$58*L60","v":{"$error":"#NUM!"}}]
["Sideswipe collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E27,'Segment Tables'!I27)","v":4.2999999999999997E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F27,'Segment Tables'!J27)","v":2.7E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G27,'Segment Tables'!K27)","v":2.1999999999999999E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H27,'Segment Tables'!L27)","v":5.2999999999999999E-2},{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E28,'Segment Tables'!I28)","v":0.11600000000000001},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F28,'Segment Tables'!J28)","v":0.16300000000000001},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G28,'Segment Tables'!K28)","v":0.114},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H28,'Segment Tables'!L28)","v":8.7999999999999995E-2},{"$error":"#NUM!"}]
["Angle collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E29,'Segment Tables'!I29)","v":4.2999999999999997E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F29,'Segment Tables'!J29)","v":4.8000000000000001E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G29,'Segment Tables'!K29)","v":4.4999999999999998E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H29,'Segment Tables'!L29)","v":4.1000000000000002E-2},{"$error":"#NUM!"}]
["Single-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E30,'Segment Tables'!I30)","v":0.76800000000000002},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F30,'Segment Tables'!J30)","v":0.72699999999999998},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G30,'Segment Tables'!K30)","v":0.77800000000000002},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H30,'Segment Tables'!L30)","v":0.79200000000000004},{"$error":"#NUM!"}]
["Other collision",null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!E31,'Segment Tables'!I31)","v":2.4E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!F31,'Segment Tables'!J31)","v":2.1999999999999999E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!G31,'Segment Tables'!K31)","v":2.3E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$24=\"No\",'Segment Tables'!H31,'Segment Tables'!L31)","v":2.4E-2},{"$error":"#NUM!"}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
["Worksheet 1E (a)  -- Summary Results for Rural Multilane Roadway Segments"]
["(1)",null,null,"(2)",null,null,null,null,"(3)",null,null,"(4)"]
["Crash severity level",null,null,"Predicted average crash frequency (crashes/year)",null,null,null,null,"Roadway segment length (mi)",null,null,"Crash rate (crashes/mi/year)"]
[null,null,null,"(7) from Worksheet 1C (a) or (b)",null,null,null,null,null,null,null,"(2)/(3)"]
["Total",null,null,{"$f":"+M42","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D73/I73","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,null,{"$f":"+M43","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D74/I74","v":{"$error":"#NUM!"}}]
["Fatal and Injurya (FIa)",null,null,{"$f":"+M44","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D75/I75","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,null,{"$f":"+M46","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D76/I76","v":{"$error":"#NUM!"}}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[]
[null,null,"PROJECT ELEMENT RESULTS SUMMARY1"]
[]
[null,null,"Summary for the project element","Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
[null,null,null,"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,null,null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,null,null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[null,null,null,{"$f":"ROUND(D73,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Rural Multilane Site Total'!$B$12:$C$37,$C$7,'Rural Multilane Site Total'!$L$12:$L$37),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(E87>D87,ROUND(E87-D87,1),0),0)","v":0},{"$f":"ROUND(D74,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E87*G87/D87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(H87>G87,ROUND(H87-G87,1),0),0)","v":0},{"$f":"ROUND(D76,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E87*J87/D87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(K87>J87,ROUND(K87-J87,1),0),0)","v":0}]
[null,null,"Special Note: When the project element is not included in the analysis the results will all be zeros. In addition if only the analysis only includes determining the predicted average crash frequency (i.e. EB analysis is not carried out), the results will show zero values where EB results are usually displayed."]
[null,null,"1 The values in this table are rounded values.  For unrounded values, refer to Workdheet 1L."]

{"sheet":"Undivided Segment Template","index":7,"n_rows":89,"n_cols":38,"rows_kept":89,"cut":false,"hidden":true,"merged":[[88,2,88,11],[0,16,0,21],[27,24,27,25],[28,24,29,28],[34,24,35,28],[38,24,38,25],[36,24,37,25],[36,26,36,28],[47,24,50,28],[45,24,45,25],[46,24,46,25],[43,24,43,25],[44,24,44,25],[41,24,41,25],[42,24,42,25],[12,24,13,28],[14,24,15,25],[14,26,14,28],[16,24,16,25],[17,24,17,25],[18,24,18,25],[25,24,25,25],[19,24,19,25],[26,24,26,25],[32,7,32,8],[32,0,32,1],[39,24,39,25],[38,0,40,1],[38,2,38,4],[38,5,39,6],[38,7,39,8],[31,12,31,13],[40,24,40,25],[37,12,37,13],[36,0,36,13],[37,0,37,1],[37,2,37,4],[37,5,37,6],[37,7,37,8],[32,12,32,13],[31,0,31,1],[31,2,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,11],[32,5,32,6],[32,2,32,4],[40,12,40,13],[62,0,62,1],[62,3,62,4],[62,6,62,7],[62,9,62,10],[62,12,62,13],[60,0,60,1],[60,3,60,4],[60,6,60,7],[60,9,60,10],[60,12,60,13],[61,0,61,1],[61,3,61,4],[61,6,61,7],[61,9,61,10],[61,12,61,13],[76,0,76,13],[64,0,64,1],[64,3,64,4],[64,6,64,7],[64,9,64,10],[64,12,64,13],[65,0,65,13],[73,3,73,7],[73,8,73,10],[73,11,73,13],[75,0,75,2],[75,3,75,7],[69,3,69,7],[69,8,69,10],[69,11,69,13],[69,0,69,2],[68,0,68,13],[70,3,70,7],[63,0,63,1],[63,3,63,4],[63,6,63,7],[63,9,63,10],[63,12,63,13],[75,11,75,13],[70,11,70,13],[70,8,71,10],[58,0,58,1],[58,3,58,4],[58,6,58,7],[58,9,58,10],[58,12,58,13],[59,0,59,1],[59,3,59,4],[59,6,59,7],[59,9,59,10],[59,12,59,13],[75,8,75,10],[74,0,74,2],[74,3,74,7],[74,8,74,10],[74,11,74,13],[73,0,73,2],[55,12,56,13],[57,0,57,1],[57,3,57,4],[57,6,57,7],[57,9,57,10],[57,12,57,13],[52,9,54,10],[52,11,54,11],[52,12,54,13],[55,2,56,2],[55,3,56,4],[55,5,56,5],[55,6,56,7],[55,8,56,8],[55,9,56,10],[55,11,56,11],[52,0,56,1],[52,2,54,2],[52,3,54,4],[52,5,54,5],[52,6,54,7],[52,8,54,8],[51,0,51,1],[51,3,51,4],[51,6,51,7],[51,9,51,10],[51,12,51,13],[46,0,46,13],[44,3,45,3],[44,4,45,4],[45,12,45,13],[44,5,45,6],[44,7,45,8],[44,9,45,10],[50,0,50,13],[44,11,45,11],[44,12,44,13],[44,0,45,1],[44,2,45,2],[38,12,39,13],[41,12,41,13],[43,5,43,6],[41,7,41,8],[40,5,40,6],[40,7,40,8],[41,5,41,6],[42,5,42,6],[42,12,42,13],[27,12,27,13],[28,12,29,13],[28,9,29,11],[43,0,43,1],[42,7,42,8],[43,7,43,8],[41,9,41,10],[42,9,42,10],[43,9,43,10],[38,9,38,10],[38,11,40,11],[39,2,39,4],[39,9,40,10],[41,0,41,1],[42,0,42,1],[37,9,37,10],[32,9,32,11],[30,0,30,1],[43,12,43,13],[30,2,30,4],[30,9,30,11],[28,0,29,1],[28,2,29,4],[28,5,29,6],[16,0,16,6],[15,0,15,6],[18,11,18,13],[17,11,17,13],[16,11,16,13],[15,11,15,13],[18,7,18,10],[17,7,17,10],[16,7,16,10],[15,7,15,10],[28,7,29,8],[27,0,27,1],[27,2,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,11],[26,0,26,13],[12,0,12,6],[13,0,13,6],[14,0,14,6],[14,11,14,13],[13,11,13,13],[12,11,12,13],[19,0,19,10],[20,0,21,5],[20,7,20,8],[20,9,20,10],[21,7,21,8],[21,9,21,10],[14,7,14,10],[13,7,13,10],[12,7,12,10],[18,0,18,6],[17,0,17,6],[1,0,1,13],[2,0,2,6],[2,7,2,13],[4,7,4,9],[4,10,4,13],[3,7,3,9],[3,10,3,13],[3,0,3,1],[3,2,3,6],[4,0,4,1],[4,2,4,6],[5,7,5,9],[5,10,5,13],[7,0,7,6],[8,0,8,6],[8,7,8,10],[7,7,7,10],[8,11,8,13],[7,11,7,13],[5,0,5,1],[5,2,5,6],[11,0,11,6],[9,0,9,6],[10,0,10,3],[9,7,9,10],[11,11,11,13],[10,11,10,13],[9,11,9,13],[6,7,6,9],[6,10,6,13],[6,0,6,1],[6,2,6,6],[11,7,11,10],[10,7,10,10],[10,14,10,15],[87,2,87,11],[20,14,24,14],[80,2,81,11],[82,2,86,2],[82,3,82,5],[82,6,82,8],[82,9,82,11],[83,3,83,5],[83,6,83,8],[83,9,83,11],[84,5,85,5],[84,8,85,8],[84,11,85,11],[30,12,30,13],[30,5,30,6],[30,7,30,8],[72,0,72,2],[72,3,72,7],[72,8,72,10],[72,11,72,13],[71,3,71,7],[71,11,71,13],[70,0,71,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["Worksheet 1A (b) -- General Information and Input Data for Rural Multilane Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations for the CMF for Shoulder Type and Widths"]
["General Information",null,null,null,null,null,null,"Location Information"]
["Analyst",null,{"$f":"'Project Information'!B6","v":"John Smith"},null,null,null,null,"Roadway",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Shoulder Width (CMFwrc) :",null,null,null,{"$f":"IF($H$11>2000,(VLOOKUP($H$13,$Y$39:$AC$47,5,FALSE)),IF($H$11<400,(VLOOKUP($H$13,$Y$39:$AC$47,3,FALSE)),(VLOOKUP($H$13,$Y$39:$AC$47,4))))","v":1.1000000000000001}]
["Agency or Company",null,{"$f":"'Project Information'!B7","v":"ABC Company"},null,null,null,null,"Roadway Section",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,3,FALSE)","v":{"$error":"#N/A"}}]
["Date Performed",null,{"$f":"'Project Information'!F5","v":"2011-05-12"},null,null,null,null,"Jurisdiction",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$I$99,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Shoulder Type (CMF trc) :",null,null,null,{"$f":"IF($H$14=\"Paved\",(HLOOKUP($H$13,'Segment Tables'!$P$9:$Z$13,2,FALSE)),(IF($H$14=\"Gravel\",(HLOOKUP($H$13,'Segment Tables'!$P$9:$Z$13,3,FALSE)),(IF($H$14=\"Turf\",(HLOOKUP($H$13,'Segment Tables'!$P$9:$Z$13,5,FALSE)),HLOOKUP($H$13,'Segment Tables'!$P$9:$Z$13,4,FALSE))))))","v":1}]
["Segment for Analysis",null,null,null,null,null,null,"Analysis Year",null,null,{"$f":"'Project Information'!F6","v":2011}]
["Input Data",null,null,null,null,null,null,"Site Conditions",null,null,null,"Base Conditions"]
["Roadway type (divided / undivided)",null,null,null,null,null,null,"Undivided",null,null,null,"Undivided"]
["Length of segment, L (mi)",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors for Specific Segment AADT values:"]
["AADT (veh/day)",null,null,null,"AADTMAX =",33200,"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(H11>F11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Lane width (ft)",null,null,null,null,null,null,null,null,null,null,12]
["Shoulder width (ft) - right shoulder width for divided",null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-11: CMF for Lane Width on Undivided Roadway Segments (CMFRA)"]
["Shoulder type - right shoulder type for divided",null,null,null,null,null,null,null,null,null,null,"Paved"]
["Median width (ft) - for divided only",null,null,null,null,null,null,"Not Applicable",null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Width (ft)",null,"AADT (veh/day)"]
["Side Slopes - for undivided only",null,null,null,null,null,null,null,null,null,null,"1:7 or flatter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 400","400 to 2000","> 2000"]
["Lighting (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,9,null,1.04,{"$f":"1.04+0.000213*($H$11-400)","v":0.95480000000000009},1.38]
["Auto speed enforcement (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,9.5,null,{"$f":"+(AA17+AA19)/2","v":1.03},{"$f":"+(AB17+AB19)/2","v":0.96120000000000005},{"$f":"+(AC17+AC19)/2","v":1.3049999999999999}]
["Calibration Factor, Cr",null,null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.02,{"$f":"1.02+0.000131*($H$11-400)","v":0.96760000000000002},1.23]
["Average Annual Crash History (3 or 5-yr average)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5,null,{"$f":"+(AA19+AA26)/2","v":1.0150000000000001},{"$f":"+(AB19+AB26)/2","v":0.98504000000000003},{"$f":"+(AC19+AC26)/2","v":1.135}]
["           Segment crashes",null,null,null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,"If inputs are complete, click for next element"]
[null,null,null,null,null,null,"PDO","Property Damage Only",null,0]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.11-6 in Part C of the HSM)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,1.01,{"$f":"1.01+0.0000188*($H$11-400)","v":1.00248},1.04]
["Worksheet 1B (b) -- Crash Modification Factors for Rural Multilane Undivided Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.5,null,{"$f":"+(AA26+AA28)/2","v":1.0049999999999999},{"$f":"+(AB26+AB28)/2","v":1.0012400000000001},{"$f":"+(AC26+AC28)/2","v":1.02}]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,null,"(6)",null,null,null,null,null,null,null,null,null,null,null,12,null,1,1,1]
["CMF for Lane Width",null,"CMF for Shoulder Width",null,null,"CMF for Side Slopes",null,"CMF for Lighting",null,"CMF for Automated Speed Enforcement",null,null,"Combined CMF",null,null,null,null,null,null,null,null,null,null,null,"Note: The collision types related to lane width to which this CMF applies include run-off-the-road, head-on crashes, and sideswipes.",null,null,null,null,null,null,null,null,null,null,null,null,"Base AADT"]
[]
["CMF 1ru",null,"CMF 2ru",null,null,"CMF 3ru",null,"CMF 4ru",null,"CMF 5ru",null,null,"CMF comb"]
["from Equation 11-13",null,"from Equation 11-14",null,null,"from Table 11-14",null,"from Equation 11-15",null,"from Section 11.7.1",null,null,"(1)*(2)*(3)*(4)*(5)"]
[{"$f":"((IF($H$11>2000,(VLOOKUP($H$12,'Undivided Segment Template'!$Y$17:$AC$28,5,FALSE)),IF($H$11<400,(VLOOKUP($H$12,'Undivided Segment Template'!$Y$17:$AC$28,3,FALSE)),(VLOOKUP($H$12,'Undivided Segment Template'!$Y$17:$AC$28,4)))))-1)*(IF('Segment Tables'!D7=\"No\",'Segment Tables'!E15,'Segment Tables'!I15))+1","v":{"$error":"#N/A"}},null,{"$f":"(+$AC$4*$AC$6-1)*(IF('Segment Tables'!D7=\"NO\",'Segment Tables'!E15,'Segment Tables'!I15))+1","v":1.0270000000000001},null,null,{"$f":"HLOOKUP(H16,'Segment Tables'!O22:T23,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF($H$17=\"Present\",(1-(IF('Segment Tables'!$D$41=\"No\",((1-(0.72*'Segment Tables'!$E$45)-(0.83*'Segment Tables'!$F$45))*'Segment Tables'!$G$45),((1-(0.72*'Segment Tables'!$I$45)-(0.83*'Segment Tables'!$J$45))*'Segment Tables'!$K$45)))),1)","v":1},null,{"$f":"IF($H$18=\"Present\",0.95,1)","v":1},null,null,{"$f":"$A$33*$C$33*$F$33*$H$33*$J$33","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-12: CMF for Collision Types Related to Shoulder Width (CMFWRA)"]
[]
["Worksheet 1C (b) -- Roadway Segment Crashes for Rural Multilane Undivided Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoulder Width (ft)",null,"AADT (veh/day)"]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)",null,null,null,null,null,null,null,null,null,null,null,null,null,"< 400","400 to 2000","> 2000"]
["Crash Severity Level",null,"SPF Coefficients",null,null,"N spf rs(u)",null,"Overdispersion Parameter, k",null,"Combined CMFs",null,"Calibration Factor, Cr","Predicted average crash frequency, N predicted rs(u)",null,null,null,null,null,null,null,null,null,null,null,0,null,1.1000000000000001,{"$f":"+($H$11-400)*0.00025+1.1","v":1},1.5]
[null,null,"from Table 11-3",null,null,null,null,null,null,"(6) from Worksheet   1B (b)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"+(AA39+AA41)/2","v":1.085},{"$f":"+(AB39+AB41)/2","v":1.0064000000000002},{"$f":"+(AC39+AC41)/2","v":1.4}]
[null,null,"a","b","c","from Equation 11-7",null,"from Equation 11-8",null,null,null,null,"(3)*(5)*(6)",null,null,null,null,null,null,null,null,null,null,null,2,null,1.07,{"$f":"+($H$11-400)*0.000143+1.07","v":1.0128000000000001},1.3]
["Total",null,-9.6530000000000005,1.1759999999999999,1.675,{"$f":"EXP($C$42+$D$42*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$42+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F42*J42*L42","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,3,null,{"$f":"+(AA41+AA43)/2","v":1.0449999999999999},{"$f":"+(AB41+AB43)/2","v":1.0001500000000001},{"$f":"+(AC41+AC43)/2","v":1.2250000000000001}]
["Fatal and Injury (FI)",null,-9.41,1.0940000000000001,1.796,{"$f":"EXP($C$43+$D$43*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$43+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F43*J43*L43","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,4,null,1.02,{"$f":"+($H$11-400)*0.00008125+1.02","v":0.98750000000000004},1.1499999999999999]
["Fatal and Injurya (FIa)",null,-8.577,0.93799999999999994,2.0030000000000001,{"$f":"EXP($C$44+$D$44*LN($H$11)+LN($H$10))","v":{"$error":"#NUM!"}},null,{"$f":"1/(EXP($E$44+LN($H$10)))","v":{"$error":"#NUM!"}},null,{"$f":"+$M$33","v":{"$error":"#N/A"}},null,{"$f":"+$H$19","v":1},{"$f":"+F44*J44*L44","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"+(AA43+AA45)/2","v":1.01},{"$f":"+(AB43+AB45)/2","v":0.99375000000000002},{"$f":"+(AC43+AC45)/2","v":1.075}]
["Property Damage Only (PDO)",null,"--","--","--","--",null,"--",null,"--",null,"--","(7)TOTAL - (7)FI",null,null,null,null,null,null,null,null,null,null,null,6,null,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+M42-M43","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,7,null,{"$f":"+(AA45+AA47)/2","v":0.99},{"$f":"+(AB45+AB47)/2","v":1.0037500000000001},{"$f":"+(AC45+AC47)/2","v":0.93500000000000005}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,0.98,{"$f":"+(($H$11-400)*-0.00006875)+0.98","v":1.0075000000000001},0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: The collision types related to shoulder width to which this CMF applies include single-vehicle run-off-the-road and multiple-vehicle head-on, opposite-direction sideswipe, and same-direction sideswipe crashes."]
[]
[]
["Worksheet 1D (b) -- Crashes by Severity Level and Collision Type for Rural Multilane Undivided Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)","(5)",null,"(6)","(7)",null,"(8)","(9)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted rs(u) (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)","N predicted rs(u) (FI) (crashes/year)",null,"Proportion of Collision Type (FIa)","N predicted rs(u) (FIa) (crashes/year)",null,"Proportion of Collision Type (PDO)","N predicted rs(u) (PDO) (crashes/year)"]
[]
[]
[null,null,"from Table 11-4","(7)TOTAL from Worksheet 1C (b)",null,"  from Table   11-4","(7)FI from Worksheet 1C (b)",null,"from Table 11-4","(7) FIa from Worksheet 1C (b)",null,"from Table 11-4","(7)PDO from Worksheet 1C (b)"]
[]
["Total",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",SUM('Segment Tables'!$E$9:$E$14),SUM('Segment Tables'!$I$9:$I$14))","v":1},{"$f":"+M42","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",SUM('Segment Tables'!$F$9:$F$14),SUM('Segment Tables'!$J$9:$J$14))","v":1},{"$f":"+M43","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",SUM('Segment Tables'!$G$9:$G$14),SUM('Segment Tables'!$K$9:$K$14))","v":1},{"$f":"+M44","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!D$7=\"No\",SUM('Segment Tables'!$H$9:$H$14),SUM('Segment Tables'!$L$9:$L$14))","v":1},{"$f":"+M46","v":{"$error":"#NUM!"}}]
[null,null,null,"(2)*(3)TOTAL",null,null,"(4)x(5)FI",null,null,"(6)*(7) FI a",null,null,"(8)*(9) PDO"]
["Head-on collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E9,'Segment Tables'!I9)","v":8.9999999999999993E-3},{"$f":"+C60*$D$58","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F9,'Segment Tables'!J9)","v":2.9000000000000001E-2},{"$f":"+F60*$G$58","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G9,'Segment Tables'!K9)","v":4.2999999999999997E-2},{"$f":"+$J$58*I60","v":{"$error":"#NUM!"}},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H9,'Segment Tables'!L9)","v":1E-3},{"$f":"+$M$58*L60","v":{"$error":"#NUM!"}}]
["Sideswipe collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E10,'Segment Tables'!I10)","v":9.8000000000000004E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F10,'Segment Tables'!J10)","v":4.8000000000000001E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G10,'Segment Tables'!K10)","v":4.3999999999999997E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H10,'Segment Tables'!L10)","v":0.12},{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E11,'Segment Tables'!I11)","v":0.246},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F11,'Segment Tables'!J11)","v":0.30499999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G11,'Segment Tables'!K11)","v":0.217},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H11,'Segment Tables'!L11)","v":0.22},{"$error":"#NUM!"}]
["Angle collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E12,'Segment Tables'!I12)","v":0.35599999999999998},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F12,'Segment Tables'!J12)","v":0.35199999999999998},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G12,'Segment Tables'!K12)","v":0.34799999999999998},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H12,'Segment Tables'!L12)","v":0.35799999999999998},{"$error":"#NUM!"}]
["Single-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E13,'Segment Tables'!I13)","v":0.23799999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F13,'Segment Tables'!J13)","v":0.23799999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G13,'Segment Tables'!K13)","v":0.30399999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H13,'Segment Tables'!L13)","v":0.23699999999999999},{"$error":"#NUM!"}]
["Other collision",null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!E14,'Segment Tables'!I14)","v":5.2999999999999999E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!F14,'Segment Tables'!J14)","v":2.8000000000000001E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!G14,'Segment Tables'!K14)","v":4.3999999999999997E-2},{"$error":"#NUM!"},null,{"$f":"IF('Segment Tables'!$D$7=\"No\",'Segment Tables'!H14,'Segment Tables'!L14)","v":6.4000000000000001E-2},{"$error":"#NUM!"}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
["Worksheet 1E (b) -- Summary Results for Rural Multilane Roadway Segments"]
["(1)",null,null,"(2)",null,null,null,null,"(3)",null,null,"(4)"]
["Crash severity level",null,null,"Predicted average crash frequency (crashes/year)",null,null,null,null,"Roadway segment length (mi)",null,null,"Crash rate (crashes/mi/year)"]
[null,null,null,"(7) from Worksheet 1C (a) or (b)",null,null,null,null,null,null,null,"(2)/(3)"]
["Total",null,null,{"$f":"+M42","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D73/I73","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,null,{"$f":"+M43","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D74/I74","v":{"$error":"#NUM!"}}]
["Fatal and Injurya (FIa)",null,null,{"$f":"+M44","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D75/I75","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,null,{"$f":"+M46","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"+$H$10","v":0},null,null,{"$f":"+D76/I76","v":{"$error":"#NUM!"}}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[]
[null,null,"PROJECT ELEMENT RESULTS SUMMARY1"]
[]
[null,null,"Summary for the project element","Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
[null,null,null,"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,null,null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,null,null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[null,null,null,{"$f":"ROUND(D73,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Rural Multilane Site Total'!$B$12:$C$37,$C$7,'Rural Multilane Site Total'!$L$12:$L$37),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(E87>D87,ROUND(E87-D87,1),0),0)","v":0},{"$f":"ROUND(D74,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E87*G87/D87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(H87>G87,ROUND(H87-G87,1),0),0)","v":0},{"$f":"ROUND(D76,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E87*J87/D87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(K87>J87,ROUND(K87-J87,1),0),0)","v":0}]
[null,null,"Special Note: When the project element is not included in the analysis the results will all be zeros. In addition if only the analysis only includes determining the predicted average crash frequency (i.e. EB analysis is not carried out), the results will show zero values where EB results are usually displayed."]
[null,null,"1 The values in this table are rounded values.  For unrounded values, refer to Workdheet 1L."]

{"sheet":"Intersection Template","index":8,"n_rows":89,"n_cols":38,"rows_kept":89,"cut":false,"hidden":true,"merged":[[88,1,88,10],[0,15,0,20],[12,10,12,12],[13,6,13,9],[13,10,13,12],[14,6,14,9],[14,10,14,12],[15,6,15,9],[15,10,15,12],[16,0,16,5],[16,6,16,9],[16,10,16,12],[15,0,15,5],[12,0,12,5],[1,0,1,12],[2,0,2,5],[2,6,2,12],[6,6,6,8],[3,9,3,12],[8,0,8,5],[3,0,3,1],[3,2,3,5],[4,0,4,1],[4,2,4,5],[39,7,39,8],[39,5,39,6],[37,0,39,1],[37,5,38,6],[27,11,28,12],[29,5,29,6],[27,2,27,4],[28,2,29,4],[30,11,30,12],[29,11,29,12],[27,0,29,1],[30,2,30,4],[27,7,27,8],[37,2,37,4],[38,2,38,4],[30,5,30,6],[29,7,29,8],[30,7,30,8],[30,0,30,1],[27,9,27,10],[28,9,28,10],[29,9,29,10],[61,11,61,12],[61,6,61,7],[59,0,59,1],[59,11,59,12],[31,11,31,12],[37,11,38,12],[44,11,44,12],[41,11,41,12],[43,11,43,12],[35,0,35,12],[36,11,36,12],[31,0,31,1],[31,2,31,4],[32,0,32,12],[42,11,42,12],[41,5,41,6],[43,0,44,1],[43,2,44,2],[42,0,42,1],[40,7,40,8],[36,7,36,8],[31,5,31,6],[31,7,31,8],[31,9,31,10],[74,6,74,9],[50,8,52,8],[45,0,45,12],[62,0,62,1],[62,3,62,4],[60,11,60,12],[60,6,60,7],[59,3,59,4],[63,0,63,12],[73,2,73,5],[67,2,67,9],[69,2,70,5],[69,6,69,9],[70,6,70,9],[73,6,73,9],[72,2,72,5],[72,6,72,9],[68,2,68,5],[68,6,68,9],[60,0,60,1],[62,11,62,12],[62,6,62,7],[61,0,61,1],[61,3,61,4],[43,10,44,10],[38,9,39,9],[37,10,39,10],[40,5,40,6],[75,2,75,9],[43,5,44,6],[43,7,44,8],[57,6,57,7],[53,6,54,7],[53,8,54,8],[49,6,49,7],[50,5,52,5],[50,6,52,7],[53,5,54,5],[50,9,52,9],[60,3,60,4],[43,3,44,3],[43,4,44,4],[58,6,58,7],[59,6,59,7],[74,2,74,5],[71,2,71,5],[50,3,52,4],[71,6,71,9],[56,0,56,1],[56,3,56,4],[56,6,56,7],[56,11,56,12],[55,0,55,1],[55,3,55,4],[55,6,55,7],[55,11,55,12],[53,10,54,10],[53,11,54,12],[53,9,54,9],[58,0,58,1],[58,3,58,4],[57,0,57,1],[57,3,57,4],[50,0,54,1],[53,2,54,2],[53,3,54,4],[40,0,40,1],[36,0,36,1],[49,0,49,1],[49,3,49,4],[48,0,48,12],[36,5,36,6],[36,2,36,4],[57,11,57,12],[43,9,44,9],[39,11,39,12],[40,11,40,12],[58,11,58,12],[49,11,49,12],[50,10,52,10],[37,7,38,8],[50,11,52,12],[50,2,52,2],[30,9,30,10],[28,5,28,6],[28,7,28,8],[27,5,27,6],[26,9,26,10],[26,7,26,8],[26,0,26,1],[5,2,5,5],[6,0,6,1],[6,2,6,5],[5,0,5,1],[26,2,26,4],[3,6,3,8],[5,6,5,8],[4,6,4,8],[4,9,4,12],[6,9,6,12],[5,9,5,12],[9,0,9,5],[7,0,7,1],[7,2,7,5],[7,6,7,8],[7,9,7,12],[8,6,8,9],[8,10,8,12],[9,6,9,9],[9,10,9,12],[87,1,87,10],[18,13,22,13],[10,6,10,9],[18,0,19,4],[17,0,17,9],[19,6,19,7],[18,6,18,7],[19,8,19,9],[18,8,18,9],[11,0,11,2],[14,0,14,5],[13,0,13,5],[10,10,10,12],[11,6,11,9],[11,10,11,12],[12,6,12,9],[10,0,10,2],[25,0,25,12],[26,11,26,12],[42,5,42,6],[42,7,42,8],[41,7,41,8],[41,0,41,1],[26,5,26,6],[80,1,81,10],[82,1,86,1],[82,2,82,4],[82,5,82,7],[82,8,82,10],[83,2,83,4],[83,5,83,7],[83,8,83,10],[84,4,85,4],[84,7,85,7],[84,10,85,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["Worksheet 2A -- General Information and Input Data for Rural Multilane Highway Intersections"]
["General Information",null,null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Analyst",null,{"$f":"'Project Information'!$B$6","v":"John Smith"},null,null,null,"Roadway",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$95,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1"]
["Agency or Company",null,{"$f":"'Project Information'!$B$7","v":"ABC Company"},null,null,null,"Intersection",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$95,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Date Performed",null,{"$f":"'Project Information'!$F$5","v":"2011-05-12"},null,null,null,"Jurisdiction",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$95,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Intersection",null,"Intersection 1",null,null,null,"Analysis Year",null,null,{"$f":"'Project Information'!$F$6","v":2011},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"3ST"]
["Signalized/Unsignalized",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$95,6,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4ST"]
["Input Data",null,null,null,null,null,"Site Conditions",null,null,null,"Base Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG"]
["Intersection type (3ST, 4ST, 4SG)",null,null,null,null,null,null,null,null,null,"--",null,null,null,{"$f":"IF($G$10=\"3ST\",\"Unsignalized three-leg (stop control on minor-road approaches)\",IF($G$10=\"4ST\",\"Unsignalized four-leg (stop control on minor-road approaches)\",\"Signalized four-leg\"))","v":"Signalized four-leg"}]
["AADTmajor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($G$10=\"3ST\",78300,IF($G$10=\"4ST\",78300,43500))","v":43500},"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(G11>E11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["AADTminor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($G$10=\"3ST\",23000,IF($G$10=\"4ST\",7400,18500))","v":18500},"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(G12>E12,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Intersection skew angle (degrees)",null,null,null,null,null,null,null,null,null,0,null,null,null,"Skew Intersection:"]
["Number of non-STOP-controlled approaches with left-turn lanes (0, 1, 2)",null,null,null,null,null,null,null,null,null,0]
["Number of non-STOP-controlled approaches with right-turn lanes (0, 1, 2, 3, or 4)",null,null,null,null,null,null,null,null,null,0]
["Intersection lighting (present/not present)",null,null,null,null,null,"Not Present",null,null,null,"Not Present"]
["Calibration Factor, Ci",null,null,null,null,null,1,null,null,null,1]
["Average Annual Crash History (3 or 5-yr average)"]
["           Intersection crashes",null,null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,"If inputs are complete, click for next element"]
[null,null,null,null,null,"PDO","Property Damage Only",null,0]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.11-6 in Part C of the HSM)"]
[]
[]
[]
[]
["Worksheet 2B -- Crash Modification Factors for Rural Multilane Highway Intersections"]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,"(6)"]
["Crash Severity Level",null,"CMF for Intersection Skew Angle (CMF 1i )",null,null,"CMF for Left-Turn Lanes",null,"CMF for Right-Turn Lanes",null,"CMF for Lighting",null,"Combined CMF (CMF COMB )"]
[null,null,"from Equations 11-18 or 11-20 and 11-19 or     11-21",null,null,"(CMF 2i )",null,"(CMF 3i )",null,"(CMF 4i )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Year"]
[null,null,null,null,null,"from Table 11-22",null,"from Table 11-23",null,"from Equation 11-22",null,"(2)*(3)*(4)*(5)"]
["Total",null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$10=\"3ST\",(((0.016*$G$13)/(0.98+0.16*$G$13))+1),(((0.053*$G$13)/(1.43+0.53*$G$13))+1)))","v":1},null,null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$14=0,1,IF($G$10=\"3ST\",0.56,(IF($G$14=1,0.72,0.52)))))","v":1},null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$15=0,1,IF($G$10=\"3ST\",0.86,(IF($G$15=1,0.86,0.74)))))","v":1},null,{"$f":"IF($G$10=\"4SG\",\"--\",(IF(($G$16=\"Not Present\"),1,(1-0.38*(IF($G$10=\"3ST\",(IF('Intersection Tables'!D40=\"No\",'Intersection Tables'!G44,'Intersection Tables'!K44)),(IF('Intersection Tables'!D40=\"No\",'Intersection Tables'!G45,'Intersection Tables'!K45))))))))","v":1},null,{"$f":"IF($G$10=\"4SG\",1,C31*F31*H31*J31)","v":1}]
["Fatal and Injury (FI)",null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$10=\"3ST\",(((0.017*$G$13)/(0.52+0.17*$G$13))+1),(((0.048*$G$13)/(0.72+0.48*$G$13))+1)))","v":1},null,null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$14=0,1,IF($G$10=\"3ST\",0.45,(IF($G$14=1,0.65,0.42)))))","v":1},null,{"$f":"IF($G$10=\"4SG\",\"--\",IF($G$15=0,1,IF($G$10=\"3ST\",0.77,(IF($G$15=1,0.77,0.59)))))","v":1},null,{"$f":"IF($G$10=\"4SG\",\"--\",(IF(($G$16=\"Not Present\"),1,(1-0.38*(IF($G$10=\"3ST\",(IF('Intersection Tables'!$D$40=\"No\",'Intersection Tables'!$G$44,'Intersection Tables'!$K$44)),(IF('Intersection Tables'!$D$40=\"No\",'Intersection Tables'!$G$45,'Intersection Tables'!$K$45))))))))","v":1},null,{"$f":"IF($G$10=\"4SG\",1,C32*F32*H32*J32)","v":1}]
["Note:  The 4-leg Signalized Intersection (4SG) models do not have base conditions and so can only be used for estimation purposes.  As a result, there are not CMFs provided for the 4SG condition."]
[]
[]
["Worksheet 2C -- Intersection Crashes for Rural Multilane Highway Intersections"]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)","(6)","(7)"]
["Crash Severity Level",null,"SPF Coefficients",null,null,"N spf int",null,"Overdispersion Parameter, k",null,"Combined CMFs","Calibration Factor, Ci","Predicted average crash frequency, \nN predicted int"]
[null,null,"from Table 11-7 or 11-8",null,null,null,null,null,null,"from (6) of Worksheet 2B"]
[null,null,"a","b","c or d (4SG)","from Equation 11-11 or 11-12",null,"from Table 11-7 or 11-8",null,null,null,"(3)*(5)*(6)"]
["Total",null,{"$f":"IF($G$10=\"3ST\",-12.526,(IF($G$10=\"4ST\",-10.008,-7.182)))","v":-7.1820000000000004},{"$f":"IF($G$10=\"3ST\",1.204,(IF($G$10=\"4ST\",0.848,0.722)))","v":0.72199999999999998},{"$f":"IF($G$10=\"3ST\",0.236,(IF($G$10=\"4ST\",0.448,0.337)))","v":0.33700000000000002},{"$f":"EXP($C$41+$D$41*LN($G$11)+$E$41*LN($G$12))","v":{"$error":"#NUM!"}},null,{"$f":"IF($G$10=\"3ST\",0.46,(IF($G$10=\"4ST\",0.494,0.277)))","v":0.27700000000000002},null,{"$f":"+$L$31","v":1},{"$f":"+$G$17","v":1},{"$f":"+$F$41*$J$41*$K$41","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,{"$f":"IF($G$10=\"3ST\",-12.664,(IF($G$10=\"4ST\",-11.554,-6.393)))","v":-6.3929999999999998},{"$f":"IF($G$10=\"3ST\",1.107,(IF($G$10=\"4ST\",0.888,0.638)))","v":0.63800000000000001},{"$f":"IF($G$10=\"3ST\",0.272,(IF($G$10=\"4ST\",0.525,0.232)))","v":0.23200000000000001},{"$f":"EXP($C$42+$D$42*LN($G$11)+$E$42*LN($G$12))","v":{"$error":"#NUM!"}},null,{"$f":"IF($G$10=\"3ST\",0.569,(IF($G$10=\"4ST\",0.742,0.218)))","v":0.218},null,{"$f":"+$L$32","v":1},{"$f":"+$G$17","v":1},{"$f":"+$F$42*$J$42*$K$42","v":{"$error":"#NUM!"}}]
["Fatal and Injurya (FIa)",null,{"$f":"IF($G$10=\"3ST\",-11.989,(IF($G$10=\"4ST\",-10.734,-12.011)))","v":-12.010999999999999},{"$f":"IF($G$10=\"3ST\",1.013,(IF($G$10=\"4ST\",0.828,\"--\")))","v":"--"},{"$f":"IF($G$10=\"3ST\",0.228,(IF($G$10=\"4ST\",0.412,1.279)))","v":1.2789999999999999},{"$f":"IF(G10=\"4SG\",(EXP(C43+E43*LN(G11+G12))),(EXP($C$43+$D$43*LN($G$11)+$E$43*LN($G$12))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($G$10=\"3ST\",0.566,(IF($G$10=\"4ST\",0.655,0.566)))","v":0.56599999999999995},null,{"$f":"+$L$32","v":1},{"$f":"+$G$17","v":1},{"$f":"+$F$43*$J$43*$K$43","v":{"$error":"#VALUE!"}}]
["Property Damage Only (PDO)",null,"--","--","--","--",null,"--",null,"--","--","(7)TOTAL - (7)FI"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$L$41-$L$42","v":{"$error":"#NUM!"}}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
["Worksheet 2D -- Crashes by Severity Level and Collision Type for Rural Multilane Highway Intersections"]
["(1)",null,"(2)","(3)",null,"(4)","(5)",null,"(6)","(7)","(8)","(9)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted int (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)","N predicted int (FI) (crashes/year)",null,"Proportion of Collision Type (FIa)","N predicted int (FIa) (crashes/year)","Proportion of Collision Type (PDO)","N predicted int (PDO) (crashes/year)"]
[]
[]
[null,null,"from Table 11-9","(7)TOTAL from Worksheet 2C",null,"  from Table   11-9","(7)FI from Worksheet 2C",null,"from Table 11-9","(7) FIa from Worksheet 2C","from Table 11-9","(7)PDO from Worksheet 2C"]
[]
["Total",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",IF($G$10=\"3ST\",SUM('Intersection Tables'!$E$10:$E$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$E$18:$E$23),SUM('Intersection Tables'!$E$26:$E$31))),IF($G$10=\"3ST\",SUM('Intersection Tables'!$I$10:$I$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$I$18:$I$23),SUM('Intersection Tables'!$I$26:$I$31))))","v":1},{"$f":"+L41","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",IF($G$10=\"3ST\",SUM('Intersection Tables'!$F$10:$F$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$F$18:$F$23),SUM('Intersection Tables'!$F$26:$F$31))),IF($G$10=\"3ST\",SUM('Intersection Tables'!$J$10:$J$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$J$18:$J$23),SUM('Intersection Tables'!$J$26:$J$31))))","v":1},{"$f":"+L42","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",IF($G$10=\"3ST\",SUM('Intersection Tables'!$G$10:$G$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$G$18:$G$23),SUM('Intersection Tables'!$G$26:$G$31))),IF($G$10=\"3ST\",SUM('Intersection Tables'!$K$10:$K$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$K$18:$K$23),SUM('Intersection Tables'!$K$26:$K$31))))","v":1},{"$f":"+L43","v":{"$error":"#VALUE!"}},{"$f":"IF('Intersection Tables'!$D$7=\"No\",IF($G$10=\"3ST\",SUM('Intersection Tables'!$H$10:$H$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$H$18:$H$23),SUM('Intersection Tables'!$H$26:$H$31))),IF($G$10=\"3ST\",SUM('Intersection Tables'!$L$10:$L$15),IF($G$10=\"4ST\",SUM('Intersection Tables'!$L$18:$L$23),SUM('Intersection Tables'!$L$26:$L$31))))","v":0.99999999999999989},{"$f":"+L45","v":{"$error":"#NUM!"}}]
[null,null,null,"(2)*(3)TOTAL",null,null,"(4)x(5)FI",null,null,"(6)*(7) FI a",null,"(8)*(9) PDO"]
["Head-on collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E10,(IF($G$10=\"4ST\",'Intersection Tables'!E18,'Intersection Tables'!E26)))),(IF($G$10=\"3ST\",'Intersection Tables'!I10,(IF($G$10=\"4ST\",'Intersection Tables'!I18,'Intersection Tables'!I26)))))","v":5.3999999999999999E-2},{"$f":"+C58*$D$56","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F10,(IF($G$10=\"4ST\",'Intersection Tables'!F18,'Intersection Tables'!F26)))),(IF($G$10=\"3ST\",'Intersection Tables'!J10,(IF($G$10=\"4ST\",'Intersection Tables'!J18,'Intersection Tables'!J26)))))","v":8.3000000000000004E-2},{"$f":"+F58*$G$56","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G10,(IF($G$10=\"4ST\",'Intersection Tables'!G18,'Intersection Tables'!G26)))),(IF($G$10=\"3ST\",'Intersection Tables'!K10,(IF($G$10=\"4ST\",'Intersection Tables'!K18,'Intersection Tables'!K26)))))","v":9.2999999999999999E-2},{"$f":"+I58*$J$56","v":{"$error":"#VALUE!"}},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H10,(IF($G$10=\"4ST\",'Intersection Tables'!H18,'Intersection Tables'!H26)))),(IF($G$10=\"3ST\",'Intersection Tables'!L10,(IF($G$10=\"4ST\",'Intersection Tables'!L18,'Intersection Tables'!L26)))))","v":3.4000000000000002E-2},{"$f":"+K58*$L$56","v":{"$error":"#NUM!"}}]
["Sideswipe collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E11,(IF($G$10=\"4ST\",'Intersection Tables'!E19,'Intersection Tables'!E27)))),(IF($G$10=\"3ST\",'Intersection Tables'!I11,(IF($G$10=\"4ST\",'Intersection Tables'!I19,'Intersection Tables'!I27)))))","v":0.106},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F11,(IF($G$10=\"4ST\",'Intersection Tables'!F19,'Intersection Tables'!F27)))),(IF($G$10=\"3ST\",'Intersection Tables'!J11,(IF($G$10=\"4ST\",'Intersection Tables'!J19,'Intersection Tables'!J27)))))","v":4.7E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G11,(IF($G$10=\"4ST\",'Intersection Tables'!G19,'Intersection Tables'!G27)))),(IF($G$10=\"3ST\",'Intersection Tables'!K11,(IF($G$10=\"4ST\",'Intersection Tables'!K19,'Intersection Tables'!K27)))))","v":3.9E-2},{"$error":"#VALUE!"},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H11,(IF($G$10=\"4ST\",'Intersection Tables'!H19,'Intersection Tables'!H27)))),(IF($G$10=\"3ST\",'Intersection Tables'!L11,(IF($G$10=\"4ST\",'Intersection Tables'!L19,'Intersection Tables'!L27)))))","v":0.14699999999999999},{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E12,(IF($G$10=\"4ST\",'Intersection Tables'!E20,'Intersection Tables'!E28)))),(IF($G$10=\"3ST\",'Intersection Tables'!I12,(IF($G$10=\"4ST\",'Intersection Tables'!I20,'Intersection Tables'!I28)))))","v":0.49199999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F12,(IF($G$10=\"4ST\",'Intersection Tables'!F20,'Intersection Tables'!F28)))),(IF($G$10=\"3ST\",'Intersection Tables'!J12,(IF($G$10=\"4ST\",'Intersection Tables'!J20,'Intersection Tables'!J28)))))","v":0.47199999999999998},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G12,(IF($G$10=\"4ST\",'Intersection Tables'!G20,'Intersection Tables'!G28)))),(IF($G$10=\"3ST\",'Intersection Tables'!K12,(IF($G$10=\"4ST\",'Intersection Tables'!K20,'Intersection Tables'!K28)))))","v":0.314},{"$error":"#VALUE!"},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H12,(IF($G$10=\"4ST\",'Intersection Tables'!H20,'Intersection Tables'!H28)))),(IF($G$10=\"3ST\",'Intersection Tables'!L12,(IF($G$10=\"4ST\",'Intersection Tables'!L20,'Intersection Tables'!L28)))))","v":0.505},{"$error":"#NUM!"}]
["Angle collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E13,(IF($G$10=\"4ST\",'Intersection Tables'!E21,'Intersection Tables'!E29)))),(IF($G$10=\"3ST\",'Intersection Tables'!I13,(IF($G$10=\"4ST\",'Intersection Tables'!I21,'Intersection Tables'!I29)))))","v":0.25600000000000001},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F13,(IF($G$10=\"4ST\",'Intersection Tables'!F21,'Intersection Tables'!F29)))),(IF($G$10=\"3ST\",'Intersection Tables'!J13,(IF($G$10=\"4ST\",'Intersection Tables'!J21,'Intersection Tables'!J29)))))","v":0.315},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G13,(IF($G$10=\"4ST\",'Intersection Tables'!G21,'Intersection Tables'!G29)))),(IF($G$10=\"3ST\",'Intersection Tables'!K13,(IF($G$10=\"4ST\",'Intersection Tables'!K21,'Intersection Tables'!K29)))))","v":0.40699999999999997},{"$error":"#VALUE!"},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H13,(IF($G$10=\"4ST\",'Intersection Tables'!H21,'Intersection Tables'!H29)))),(IF($G$10=\"3ST\",'Intersection Tables'!L13,(IF($G$10=\"4ST\",'Intersection Tables'!L21,'Intersection Tables'!L29)))))","v":0.215},{"$error":"#NUM!"}]
["Single-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E14,(IF($G$10=\"4ST\",'Intersection Tables'!E22,'Intersection Tables'!E30)))),(IF($G$10=\"3ST\",'Intersection Tables'!I14,(IF($G$10=\"4ST\",'Intersection Tables'!I22,'Intersection Tables'!I30)))))","v":6.2E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F14,(IF($G$10=\"4ST\",'Intersection Tables'!F22,'Intersection Tables'!F30)))),(IF($G$10=\"3ST\",'Intersection Tables'!J14,(IF($G$10=\"4ST\",'Intersection Tables'!J22,'Intersection Tables'!J30)))))","v":4.1000000000000002E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G14,(IF($G$10=\"4ST\",'Intersection Tables'!G22,'Intersection Tables'!G30)))),(IF($G$10=\"3ST\",'Intersection Tables'!K14,(IF($G$10=\"4ST\",'Intersection Tables'!K22,'Intersection Tables'!K30)))))","v":7.8E-2},{"$error":"#VALUE!"},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H14,(IF($G$10=\"4ST\",'Intersection Tables'!H22,'Intersection Tables'!H30)))),(IF($G$10=\"3ST\",'Intersection Tables'!L14,(IF($G$10=\"4ST\",'Intersection Tables'!L22,'Intersection Tables'!L30)))))","v":7.6999999999999999E-2},{"$error":"#NUM!"}]
["Other collision",null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E15,(IF($G$10=\"4ST\",'Intersection Tables'!E23,'Intersection Tables'!E31)))),(IF($G$10=\"3ST\",'Intersection Tables'!I15,(IF($G$10=\"4ST\",'Intersection Tables'!I23,'Intersection Tables'!I31)))))","v":0.03},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F15,(IF($G$10=\"4ST\",'Intersection Tables'!F23,'Intersection Tables'!F31)))),(IF($G$10=\"3ST\",'Intersection Tables'!J15,(IF($G$10=\"4ST\",'Intersection Tables'!J23,'Intersection Tables'!J31)))))","v":4.2000000000000003E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G15,(IF($G$10=\"4ST\",'Intersection Tables'!G23,'Intersection Tables'!G31)))),(IF($G$10=\"3ST\",'Intersection Tables'!K15,(IF($G$10=\"4ST\",'Intersection Tables'!K23,'Intersection Tables'!K31)))))","v":6.9000000000000006E-2},{"$error":"#VALUE!"},{"$f":"IF('Intersection Tables'!$D$7=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!H15,(IF($G$10=\"4ST\",'Intersection Tables'!H23,'Intersection Tables'!H31)))),(IF($G$10=\"3ST\",'Intersection Tables'!L15,(IF($G$10=\"4ST\",'Intersection Tables'!L23,'Intersection Tables'!L31)))))","v":2.1999999999999999E-2},{"$error":"#NUM!"}]
["NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[]
[null,null,"Worksheet 2E -- Summary Results for Rural Multilane Highway Intersections"]
[null,null,"(1)",null,null,null,"(2)"]
[null,null,"Crash severity level",null,null,null,"Predicted average crash frequency (crashes / year)"]
[null,null,null,null,null,null,"(7) from Worksheet 2C"]
[null,null,"Total",null,null,null,{"$f":"+L41","v":{"$error":"#NUM!"}}]
[null,null,"Fatal and Injury (FI)",null,null,null,{"$f":"+L42","v":{"$error":"#NUM!"}}]
[null,null,"Fatal and Injurya (FIa)",null,null,null,{"$f":"+L43","v":{"$error":"#VALUE!"}}]
[null,null,"Property Damage Only (PDO)",null,null,null,{"$f":"+L45","v":{"$error":"#NUM!"}}]
[null,null,"NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[]
[]
[null,"PROJECT ELEMENT RESULTS SUMMARY1"]
[]
[null,"Summary for the project element","Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
[null,null,"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[null,null,{"$f":"ROUND(G72,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Rural Multilane Site Total'!$B$12:$C$37,$C$7,'Rural Multilane Site Total'!$L$12:$L$37),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(D87>C87,ROUND(D87-C87,1),0),0)","v":0},{"$f":"ROUND(G73,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+D87*F87/C87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(G87>F87,ROUND(G87-F87,1),0),0)","v":0},{"$f":"ROUND(G75,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+D87*I87/C87),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(J87>I87,ROUND(J87-I87,1),0),0)","v":0}]
[null,"Special Note: When the project element is not included in the analysis the results will all be zeros. In addition if only the analysis only includes determining the predicted average crash frequency (i.e. EB analysis is not carried out), the results will show zero values where EB results are usually displayed."]
[null,"1 The values in this table are rounded values.  For unrounded values, refer to Workdheet 1L."]

{"sheet":"Multi-Year Template","index":9,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[[10,0,10,1],[10,2,10,4],[11,0,11,1],[11,2,11,4],[12,0,12,1],[12,2,12,4],[9,0,9,4],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,9],[5,0,5,1],[5,2,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,9],[7,0,7,1],[0,12,0,22],[0,0,1,9],[2,0,2,9],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9]]}
["MULTIPLE-YEAR ANALYSIS FOR RURAL MULTILANE ROADS - INPUTS",null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
[]
["General Information"]
["Project Name",null,{"$f":"'Project Information'!B3","v":"Practical Case Study"},null,null,"Analyst",null,{"$f":"'Project Information'!B6","v":"John Smith"}]
["Project Description",null,{"$f":"'Project Information'!B4","v":"Three Signalized Intersections"},null,null,"Contact Email",null,{"$f":"'Project Information'!F3","v":"email"}]
["Reference Number",null,{"$f":"'Project Information'!B5","v":"STARS Report A-1"},null,null,"Contact Phone",null,{"$f":"'Project Information'!F4","v":1234567891}]
["Agency/Company",null,{"$f":"'Project Information'!B7","v":"ABC Company"},null,null,"Date Performed",null,{"$f":"'Project Information'!F5","v":"2011-05-12"}]
[]
[]
["Input Data"]
["Base Year",null,2011]
["Analysis Period (Years)",null,1]
["Linear Traffic Growth (annual %)",null,0.01]

{"sheet":"Segment Tables","index":10,"n_rows":57,"n_cols":31,"rows_kept":57,"cut":false,"hidden":true,"merged":[[48,1,49,11],[32,1,32,11],[31,1,31,3],[42,9,43,9],[42,10,43,11],[44,10,44,11],[39,8,41,9],[36,1,37,11],[38,1,39,3],[38,4,38,7],[44,6,44,7],[42,4,43,4],[42,5,43,5],[42,6,43,7],[40,1,40,2],[38,8,38,11],[39,4,41,5],[39,6,41,7],[39,10,41,11],[44,1,44,3],[41,1,43,3],[54,8,55,8],[54,9,55,9],[50,1,51,3],[50,4,50,7],[50,8,50,11],[51,4,53,5],[51,6,53,7],[51,8,53,9],[51,10,53,11],[52,1,52,2],[12,30,12,32],[13,30,13,32],[17,30,17,32],[14,30,14,32],[15,30,15,32],[16,30,16,32],[56,1,56,3],[56,6,56,7],[54,10,55,11],[56,10,56,11],[12,28,12,29],[18,28,18,29],[19,28,19,29],[42,8,43,8],[14,28,14,29],[53,1,55,3],[19,14,20,19],[13,28,13,29],[54,4,55,4],[54,5,55,5],[54,6,55,7],[34,28,34,29],[16,28,16,29],[17,28,17,29],[36,30,36,31],[37,28,37,29],[37,30,37,31],[32,30,32,31],[33,28,33,29],[33,30,33,31],[34,30,34,31],[35,28,35,29],[35,30,35,31],[36,28,36,29],[32,28,32,29],[18,30,18,32],[19,30,19,32],[30,28,30,29],[30,30,30,31],[28,1,28,3],[30,1,30,3],[29,1,29,3],[23,7,24,7],[31,30,31,31],[28,30,28,31],[29,28,29,29],[29,30,29,31],[23,8,24,8],[23,9,24,9],[23,10,24,10],[23,6,24,6],[23,1,23,2],[23,5,24,5],[25,1,25,3],[22,4,22,7],[22,8,22,11],[21,1,22,3],[24,28,26,31],[28,28,28,29],[15,28,15,29],[11,28,11,29],[31,28,31,29],[13,14,14,25],[5,14,6,25],[7,14,8,14],[7,15,7,25],[11,1,11,3],[10,1,10,3],[10,28,10,29],[9,28,9,29],[5,28,6,32],[15,1,15,11],[14,1,14,3],[7,28,8,29],[9,30,9,32],[10,30,10,32],[11,30,11,32],[7,30,8,32],[23,4,24,4],[23,11,24,11],[27,28,27,29],[27,30,27,31],[27,1,27,3],[26,1,26,3],[6,9,7,9],[6,10,7,10],[19,1,20,11],[24,1,24,3],[6,11,7,11],[6,7,7,7],[8,1,8,3],[7,1,7,3],[6,1,6,2],[4,1,5,3],[6,8,7,8],[2,1,3,11],[4,4,4,11],[5,8,5,11],[5,4,5,7],[6,4,7,4],[21,4,21,11],[6,5,7,5],[12,1,12,3],[9,1,9,3],[13,1,13,3],[6,6,7,6]]}
[null,"Tables Affiliated with Crash Statistics:",null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
[]
[null,"Table 11-4: Distribution of Crashes by Collision Type and Crash Severity Level for Undivided Roadway Segments"]
[]
[null,"Collision type",null,null,"Proportion of crashes by collision type and crash severity level"]
[null,null,null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values",null,null,null,null,null,"Table 11-13: CMF for Collision Types Related to Shoulder Types and Shoulder Widths (CMFTRA)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-17: CMF for Right Shoulder Width on Divided Roadway Segments (CMF2rd)"]
[null,"Locally-Derived Values?",null,"No","Total","Fatal and injury","Fatal and injury a","PDO","Total","Fatal and injury","Fatal and injury a","PDO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoulder Type","Shoulder width (ft)",null,null,null,null,null,null,null,null,null,null,null,null,"Average Shoulder Width (ft)",null,"CMF"]
[null,"Head-on",null,null,8.9999999999999993E-3,2.9000000000000001E-2,4.2999999999999997E-2,1E-3,8.9999999999999993E-3,2.9000000000000001E-2,4.2999999999999997E-2,1E-3,null,null,null,0,1,2,3,4,5,6,7,8,9,10]
[null,"Sideswipe",null,null,9.8000000000000004E-2,4.8000000000000001E-2,4.3999999999999997E-2,0.12,9.8000000000000004E-2,4.8000000000000001E-2,4.3999999999999997E-2,0.12,null,null,"Paved",1,1,1,1,1,{"$f":"+(T10+V10)/2","v":1},1,{"$f":"+(V10+X10)/2","v":1},1,{"$f":"+(X10+Z10)/2","v":1},1,null,null,0,null,1.18]
[null,"Rear-end",null,null,0.246,0.30499999999999999,0.217,0.22,0.246,0.30499999999999999,0.217,0.22,null,null,"Gravel",1,1,1.01,1.01,1.01,{"$f":"+(T11+V11)/2","v":1.0150000000000001},1.02,{"$f":"+(V11+X11)/2","v":1.02},1.02,{"$f":"+(X11+Z11)/2","v":1.0249999999999999},1.03,null,null,1,null,{"$f":"+(AE10+AE12)/2","v":1.1549999999999998}]
[null,"Angle",null,null,0.35599999999999998,0.35199999999999998,0.34799999999999998,0.35799999999999998,0.35599999999999998,0.35199999999999998,0.34799999999999998,0.35799999999999998,null,null,"Composite",1,1.01,1.02,1.02,1.03,{"$f":"+(T12+V12)/2","v":1.0350000000000001},1.04,{"$f":"+(V12+X12)/2","v":1.05},1.06,{"$f":"+(X12+Z12)/2","v":1.0649999999999999},1.07,null,null,2,null,1.1299999999999999]
[null,"Single",null,null,0.23799999999999999,0.23799999999999999,0.30399999999999999,0.23699999999999999,0.23799999999999999,0.23799999999999999,0.30399999999999999,0.23699999999999999,null,null,"Turf",1,1.01,1.03,1.04,1.05,{"$f":"+(T13+V13)/2","v":1.0649999999999999},1.08,{"$f":"+(V13+X13)/2","v":1.0950000000000002},1.1100000000000001,{"$f":"+(X13+Z13)/2","v":1.125},1.1399999999999999,null,null,3,null,{"$f":"+(AE12+AE14)/2","v":1.1099999999999999}]
[null,"Other",null,null,5.2999999999999999E-2,2.8000000000000001E-2,4.3999999999999997E-2,6.4000000000000001E-2,5.2999999999999999E-2,2.8000000000000001E-2,4.3999999999999997E-2,6.4000000000000001E-2,null,null,"Note: The values for composite shoulders in this exhibit represent a shoulder for which 50 percent of the shoulder width is paved and 50 percent of the shoulder width is turf.",null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.0900000000000001]
[null,"SV run-off-rd, Head-on, Sideswipe",null,null,0.27,null,null,null,0.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"+(AE14+AE16)/2","v":1.0649999999999999}]
[null,"NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.04]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,{"$f":"+(AE16+AE18)/2","v":1.02}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,1]
[null,"Table 11-6: Distribution of Crashes by Collision Type and Crash Severity Level for Divided Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-14: CMF for Side Slope on Undivided Roadway Segments (CMF3ru)",null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1]
[]
[null,"Collision type",null,null,"Proportion of crashes by collision type and crash severity level",null,null,null,null,null,null,null,null,null,"1:2 or Steeper","1:3","1:4","1:5","1:6","1:7 or Flatter"]
[null,null,null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values",null,null,null,null,null,1.18,1.1499999999999999,1.1200000000000001,1.0900000000000001,1.05,1]
[null,"Locally-Derived Values?",null,"No","Total","Fatal and injury","Fatal and injury a","PDO","Total","Fatal and injury","Fatal and injury a","PDO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 11-18: CMF for Median Width on Divided Roadway Segments without a Median Barrier(CMF3rd)"]
[null,"Head-on",null,null,6.0000000000000001E-3,1.2999999999999999E-2,1.7999999999999999E-2,2E-3]
[null,"Sideswipe",null,null,4.2999999999999997E-2,2.7E-2,2.1999999999999999E-2,5.2999999999999999E-2]
[null,"Rear-end",null,null,0.11600000000000001,0.16300000000000001,0.114,8.7999999999999995E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Width (ft)",null,"CMF"]
[null,"Angle",null,null,4.2999999999999997E-2,4.8000000000000001E-2,4.4999999999999998E-2,4.1000000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.04]
[null,"Single",null,null,0.76800000000000002,0.72699999999999998,0.77800000000000002,0.79200000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,1.02]
[null,"Other",null,null,2.4E-2,2.1999999999999999E-2,2.3E-2,2.4E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,1]
[null,"SV run-off-rd, Head-on, Sideswipe",null,null,0.5,null,null,null,0.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,0.99]
[null,"NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,0.95]
[null,"Table 11-15: Night-time Crash Proportions for Unlighted Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,0.94]
[null,"Roadway Type",null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
[null,null,null,null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night",null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night"]
[null,"Locally-Derived Values?",null,"No"]
[]
[null,null,null,null,"Fatal and injury, pinr","PDO, ppnr","pnr",null,"Fatal and injury, pinr","PDO, ppnr","pnr"]
[]
[null,"4U",null,null,0.36099999999999999,0.63900000000000001,0.255]
[]
[]
[]
[null,"Table 11-19: Night-time Crash Proportions for Unlighted Roadway Segments"]
[]
[null,"Roadway Type",null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
[null,null,null,null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night",null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night"]
[null,"Locally-Derived Values?",null,"No"]
[]
[null,null,null,null,"Fatal and injury, pinr","PDO, ppnr","pnr",null,"Fatal and injury, pinr","PDO, ppnr","pnr"]
[]
[null,"4D",null,null,0.32300000000000001,0.67700000000000005,0.42599999999999999]

{"sheet":"Intersection Tables","index":11,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":true,"merged":[[20,1,20,3],[44,1,44,3],[44,6,44,7],[44,10,44,11],[41,10,42,11],[43,1,43,3],[43,6,43,7],[41,6,42,7],[41,8,42,8],[41,9,42,9],[41,4,42,4],[41,5,42,5],[43,10,43,11],[40,1,42,3],[38,10,40,11],[38,8,40,9],[39,1,39,2],[21,1,21,3],[2,1,3,11],[22,1,22,3],[23,1,23,3],[8,1,8,11],[4,1,5,3],[6,4,7,4],[6,5,7,5],[4,4,4,11],[5,4,5,7],[5,8,5,11],[6,10,7,10],[6,11,7,11],[13,1,13,3],[14,1,14,3],[32,1,32,11],[30,1,30,3],[31,1,31,3],[18,1,18,3],[37,1,38,3],[37,4,37,7],[37,8,37,11],[38,4,40,5],[35,1,36,11],[38,6,40,7],[24,1,24,11],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[11,1,11,3],[6,6,7,6],[6,7,7,7],[6,1,6,2],[19,1,19,3],[12,1,12,3],[16,1,16,11],[17,1,17,3],[15,1,15,3],[6,8,7,8],[6,9,7,9],[7,1,7,3],[9,1,9,3],[10,1,10,3]]}
[null,"Tables Affiliated with Crash Statistics:"]
[]
[null,"Table 11-9: Distribution of Intersection Crashes by Collision Type and Crash Severity"]
[]
[null,"Collision type",null,null,"Proportion of crashes by collision type and crash severity level"]
[null,null,null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
[null,"Locally-Derived Values?",null,"No","Total","Fatal and injury","Fatal and injury a","PDO","Total","Fatal and injury","Fatal and injury a","PDO"]
[]
[null,"Three-leg intersections with minor road stop control"]
[null,"Head-on",null,null,2.9000000000000001E-2,4.2999999999999997E-2,5.1999999999999998E-2,0.02,null,0.1,0.2,0.3]
[null,"Sideswipe",null,null,0.13300000000000001,5.8000000000000003E-2,5.7000000000000002E-2,0.17899999999999999]
[null,"Rear-end",null,null,0.28899999999999998,0.247,0.14199999999999999,0.315]
[null,"Angle",null,null,0.26300000000000001,0.36899999999999999,0.38100000000000001,0.19800000000000001]
[null,"Single",null,null,0.23400000000000001,0.219,0.28399999999999997,0.24399999999999999]
[null,"Other",null,null,5.1999999999999998E-2,6.4000000000000001E-2,8.4000000000000005E-2,4.3999999999999997E-2]
[null,"SV run-off-rd, Head-on, Sideswipe",null,null,0.5,null,null,null,0.33]
[null,"Four-leg intersections with minor road stop control"]
[null,"Head-on",null,null,1.6E-2,1.7999999999999999E-2,2.3E-2,1.4999999999999999E-2,null,0.4,0.5,0.6]
[null,"Sideswipe",null,null,0.107,4.2000000000000003E-2,0.04,0.156]
[null,"Rear-end",null,null,0.22800000000000001,0.21299999999999999,0.108,0.24]
[null,"Angle",null,null,0.39500000000000002,0.53400000000000003,0.57099999999999995,0.29199999999999998]
[null,"Single",null,null,0.20200000000000001,0.14799999999999999,0.19900000000000001,0.24299999999999999]
[null,"Other",null,null,5.1999999999999998E-2,4.4999999999999998E-2,5.8999999999999997E-2,5.3999999999999999E-2]
[null,"SV run-off-rd, Head-on, Sideswipe",null,null,0.5,null,null,null,0.33]
[null,"Four-leg signalized intersections"]
[null,"Head-on",null,null,5.3999999999999999E-2,8.3000000000000004E-2,9.2999999999999999E-2,3.4000000000000002E-2,null,0.7,0.8,0.9]
[null,"Sideswipe",null,null,0.106,4.7E-2,3.9E-2,0.14699999999999999]
[null,"Rear-end",null,null,0.49199999999999999,0.47199999999999998,0.314,0.505]
[null,"Angle",null,null,0.25600000000000001,0.315,0.40699999999999997,0.215]
[null,"Single",null,null,6.2E-2,4.1000000000000002E-2,7.8E-2,7.6999999999999999E-2]
[null,"Other",null,null,0.03,4.2000000000000003E-2,6.9000000000000006E-2,2.1999999999999999E-2]
[null,"SV run-off-rd, Head-on, Sideswipe",null,null,0.5,null,null,null,0.33]
[null,"NOTE: a Using the KABCO scale, these include only KAB crashes. Crashes with severity level C (possible injury) are not included."]
[]
[]
[null,"Table 11-24: Night-time Crash Proportions for Unlighted Intersections"]
[]
[null,"Roadway Type",null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
[null,null,null,null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night",null,"Proportion of total night-time crashes by severity level",null,"Proportion of crashes that occur at night"]
[null,"Locally-Derived Values?",null,"No"]
[]
[null,null,null,null,"Fatal and injury, pini","PDO, ppnr","pni",null,"Fatal and injury, pinr","PDO, ppnr","pnr"]
[]
[null,"3ST",null,null,null,null,0.27600000000000002]
[null,"4ST",null,null,null,null,0.27300000000000002]

{"sheet":"Construction","index":12,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Lane Width",null,"Shoulder Width",null,"RHR"]
[null,9,null,0,null,1]
[null,9.5,null,1,null,2]
[null,10,null,2,null,3]
[null,10.5,null,3,null,4]
[null,11,null,4,null,5]
[null,11.5,null,5,null,6]
[null,12,null,6,null,7]
[null,null,null,7]
[null,null,null,8]
[]
[]
[null,null,null,null,null,null,null,"Centerline",null,"Passing",null,"Local"]
[null,null,null,"Shoulder Type",null,"Spiral",null,"Rumble Strips",null,"Lane",null,"Yes"]
[null,null,null,"Paved",null,"Not Present",null,"Not Present",null,"Not Present",null,"No"]
[null,null,null,"Gravel",null,"Present",null,"Present",null,"Present (1 lane)"]
[null,null,null,"Composite",null,null,null,null,null,"Present (2 lanes)"]
[null,null,null,"Turf"]
[]
[null,null,null,null,null,"TWLTL",null,"Lighting",null,"SpEnforce"]
[null,null,null,null,null,"Not Present",null,"Not Present",null,"Not Present"]
[null,null,null,null,null,"Present",null,"Present",null,"Present"]
[]
[]
[]
[null,null,null,"Itype",null,"Lapproach",null,"Rapproach",null,"Ilight",null,"Differ"]
[null,null,null,"3ST",null,0,null,0,null,"Not Present",null,"Yes"]
[null,null,null,"4ST",null,1,null,1,null,"Present",null,"No"]
[null,null,null,"4SG",null,2,null,2]
[null,null,null,null,null,3,null,3]
[null,null,null,null,null,4,null,4]
[]
[]
[null,null,null,"Mwidth",null,"Division",null,"Sslope2",null,"Shld2",null,"Iapproach",null,"RtApproach",null,"Shld3"]
[null,null,null,10,null,"Divided",null,"1:2 or Steeper",null,0,null,0,null,0,null,0]
[null,null,null,20,null,"Undivided",null,"1:3",null,1,null,1,null,1,null,1]
[null,null,null,30,null,null,null,"1:4",null,2,null,2,null,2,null,2]
[null,null,null,40,null,null,null,"1:5",null,3,null,null,null,3,null,3]
[null,null,null,50,null,null,null,"1:6",null,4,null,null,null,4,null,4]
[null,null,null,60,null,null,null,"1:7 or Flatter",null,5,null,null,null,null,null,5]
[null,null,null,70,null,null,null,null,null,6,null,null,null,null,null,6]
[null,null,null,80,null,null,null,null,null,7,null,null,null,null,null,7]
[null,null,null,90,null,null,null,null,null,8,null,null,null,null,null,8]
[null,null,null,100,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]