{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Project Information","Report","Rural 2-Lane Site Total","Multi-Year Summary","Multi-Year Analysis Report","Multi-Year Template","Segment Template","Intersection Template","Segment Tables","Intersection Tables","Construction - Do Not Delete"],"not_rendered":{"charts":3,"images":2,"macros":1,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"merged":[[1,2,1,14],[4,2,4,14],[19,2,19,14],[23,2,23,14],[24,2,24,14],[25,2,25,14],[26,2,26,14],[27,2,27,14],[28,2,28,14],[29,2,29,14],[30,2,30,14],[31,2,31,14],[32,2,32,14],[35,2,35,14],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,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"]
[]
[{"$nulls":3},"    Required user input data"]
[]
[{"$nulls":3},"    Required user input data restricted to dropdown values"]
[]
[{"$nulls":3},"    Automatically updated information based on previous user input data"]
[]
[{"$nulls":3},"    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":30,"n_cols":38,"rows_kept":30,"merged":[[0,0,0,7],[0,10,0,21],[1,0,1,7],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[10,1,10,2],[11,1,11,2],[12,0,12,3],[12,4,15,4],[12,5,12,7],[13,0,15,0],[13,1,13,2],[13,3,15,3],[13,6,13,7],[14,1,15,1],[14,2,15,2],[14,5,15,5],[14,6,15,6],[14,7,15,7],[16,0,16,7],[18,0,18,7]]}
["PROJECT SAFETY PERFORMANCE ANALYSIS INPUT SHEET - RURAL 2-LANE ROADS",{"$nulls":9},"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]
[{"$nulls":4},"ANALYSIS YEAR"]
["INDIVIDUAL PROJECT ELEMENTS","LOCATION INFORMATION",null,"JURISDICTION",null,"INTERSECTIONS ONLY","DETERMINING FOR PROJECT ELEMENT:"]
[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)"]
[]
["SEGMENTS"]
[{"$nulls":6},"Yes","No"]
["INTERSECTIONS"]
{"$rows_empty":9}
[{"$nulls":37},"Base Year"]
[{"$nulls":37},2011]

{"sheet":"Report","index":2,"n_rows":35,"n_cols":48,"rows_kept":35,"merged":[[0,0,0,9],[0,13,0,23],[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],[11,1,11,3],[11,4,11,6],[11,7,11,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],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[29,47,29,56],[30,47,30,49],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9]]}
["PROJECT SAFETY PERFORMANCE SUMMARY REPORT",{"$nulls":12},"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 2-Lane Roads"]
[]
["Crash severity level",{"$nulls":3},"N predicted(PROJECT)",null,"N expected (PROJECT)",null,"N potential for improvement (PROJECT)"]
[{"$nulls":4},"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)",{"$nulls":3},{"$f":"+E20","v":{"v":0,"d":"0.0"}},null,{"$f":"+F20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G26>=E26,+G26-E26,\"N/A\")","v":{"v":0,"d":"0.0"}}]
["Property damage only (PDO)",{"$nulls":3},{"$f":"+H20","v":{"v":0,"d":"0.0"}},null,{"$f":"+I20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G27>=E27,+G27-E27,\"N/A\")","v":{"v":0,"d":"0.0"}}]
["Total (KABCO)",{"$nulls":3},{"$f":"+B20","v":{"v":0,"d":"0.0"}},null,{"$f":"+C20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G28>=E28,+G28-E28,\"N/A\")","v":{"v":0,"d":"0.0"}}]
[]
[{"$nulls":47},"PROJECT SUMMARY"]
["Discussion of Results",{"$nulls":46},"Fatal and Injury Crashes/yr"]
["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 2-Lane Site Total","index":3,"n_rows":29,"n_cols":15,"rows_kept":29,"hidden":true,"merged":[[2,1,3,11],[2,14,2,24],[4,1,4,2],[5,1,10,2],[5,3,7,5],[5,6,7,8],[5,9,10,9],[5,10,7,10],[5,11,7,11],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,10,6],[8,7,10,7],[8,8,10,8],[8,10,10,10],[8,11,10,11],[15,1,15,2],[19,2,20,10],[21,2,21,4],[21,5,21,7],[21,8,21,10],[22,2,22,4],[22,5,22,7],[22,8,22,10],[23,2,24,4],[23,5,23,7],[23,8,23,10],[24,5,24,7],[24,8,24,10],[25,2,26,4],[25,5,25,7],[25,8,25,10],[26,5,26,7],[26,8,26,10],[27,2,28,4],[27,5,27,7],[27,8,27,10],[28,5,28,7],[28,8,28,10],[29,47,31,47]]}
[]
[]
[null,"Worksheet 3A -- Predicted and Observed Crashes by Severity and Site Type Using the Site-Specific EB Method",{"$nulls":12},"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,   Nobserved (crashes/year)",null,null,"Overdispersion Parameter, k","Weighted adjustment, w","Expected average crash frequency, Nexpected"]
[]
[]
[{"$nulls":3},"N predicted (TOTAL)"," N predicted      (FI)"," N predicted    (PDO)","N predicted (TOTAL)"," N predicted      (FI)"," N predicted    (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"]
[{"$nulls":5},{"$f":"+D16","v":{"v":0,"d":"0.000"}},null,null,{"$f":"+L16","v":{"v":0,"d":"0.0"}}]
[null,null,"Fatal and Injury (FI)",null,null,"(3)COMB from Worksheet 3A",null,null,"(3)TOTAL * (2)FI / (2) TOTAL"]
[{"$nulls":5},{"$f":"+E16","v":{"v":0,"d":"0.000"}},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"]
[{"$nulls":5},{"$f":"+F16","v":{"v":0,"d":"0.000"}},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,"hidden":true,"merged":[[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],[10,0,11,0],[10,1,10,3],[10,4,10,6],[10,7,10,9]]}
["MULTIPLE-YEAR ANALYSIS SUMMARY FOR RURAL 2-LANE 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,"hidden":true,"merged":[[0,0,0,9],[0,12,0,22],[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],[11,1,11,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],[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],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[31,0,31,8],[32,0,32,8],[33,0,33,8],[34,0,34,8]]}
["MULTIPLE YEAR PROJECT SAFETY PERFORMANCE SUMMARY REPORT FOR RURAL 2-LANE ROADS",{"$nulls":11},"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"}]
["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 2-Lane Roads"]
[{"$nulls":4},"N predicted(PROJECT)",null,"N expected (PROJECT)",null,"N potential for improvement (PROJECT)"]
["Crash severity level",{"$nulls":3},{"$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)",{"$nulls":3},{"$f":"+B20","v":{"v":0,"d":"0.0"}},null,{"$f":"+E20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G26>=E26,+G26-E26,\"N/A\")","v":{"v":0,"d":"0.0"}}]
["Property damage only crashes (PDO)",{"$nulls":3},{"$f":"+C20","v":{"v":0,"d":"0.0"}},null,{"$f":"+F20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G27>=E27,+G27-E27,\"N/A\")","v":{"v":0,"d":"0.0"}}]
["Total crashes (KABCO)",{"$nulls":3},{"$f":"+D20","v":{"v":0,"d":"0.0"}},null,{"$f":"+G20","v":{"v":0,"d":"0.0"}},null,{"$f":"+IF(G28>=E28,+G28-E28,\"N/A\")","v":{"v":0,"d":"0.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":"+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":"+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":"+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":"Multi-Year Template","index":6,"n_rows":13,"n_cols":13,"rows_kept":13,"hidden":true,"merged":[[0,0,1,9],[0,12,0,22],[2,0,2,9],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[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],[9,0,9,4],[10,0,10,1],[10,2,10,4],[11,0,11,1],[11,2,11,4],[12,0,12,1],[12,2,12,4]]}
["MULTIPLE-YEAR ANALYSIS FOR RURAL 2-LANE ROADS - INPUTS",{"$nulls":11},"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,{"v":0.01,"d":"1.0%"}]

{"sheet":"Segment Template","index":7,"n_rows":102,"n_cols":48,"rows_kept":102,"hidden":true,"merged":[[0,0,1,12],[0,15,0,20],[2,0,2,5],[2,6,2,12],[3,0,3,1],[3,2,3,5],[3,6,3,8],[3,9,3,12],[4,0,4,1],[4,2,4,5],[4,6,4,8],[4,9,4,12],[4,37,5,41],[5,0,5,1],[5,2,5,5],[5,6,5,8],[5,9,5,12],[6,0,6,1],[6,2,6,5],[6,6,6,8],[6,9,6,12],[6,37,7,38],[6,39,6,41],[7,0,7,5],[7,6,7,9],[7,10,7,12],[8,0,8,5],[8,6,8,9],[8,10,8,12],[8,37,8,38],[9,0,9,2],[9,6,9,9],[9,10,9,12],[9,37,9,38],[10,0,10,5],[10,6,10,9],[10,10,10,12],[10,37,10,38],[11,0,11,5],[11,10,11,12],[11,37,11,38],[12,0,12,5],[12,10,12,12],[12,37,12,38],[13,0,13,5],[13,6,13,9],[13,10,13,12],[13,37,13,38],[14,0,14,5],[14,6,14,9],[14,10,14,12],[14,37,14,38],[15,0,15,5],[15,6,15,9],[15,10,15,12],[15,37,18,41],[16,0,16,5],[16,6,16,9],[16,10,16,12],[17,0,17,5],[17,6,17,9],[17,10,17,12],[18,0,18,5],[18,6,18,9],[18,10,18,12],[19,0,19,5],[19,6,19,9],[19,10,19,12],[20,0,20,5],[20,6,20,9],[20,10,20,12],[20,37,21,41],[21,0,21,5],[21,6,21,9],[21,10,21,12],[22,0,22,5],[22,6,22,9],[22,10,22,12],[22,37,23,38],[22,39,22,41],[23,0,23,5],[23,6,23,9],[23,10,23,12],[24,0,24,5],[24,6,24,9],[24,10,24,12],[24,37,24,38],[25,0,25,5],[25,6,25,9],[25,10,25,12],[25,37,25,38],[26,0,26,9],[26,37,26,38],[27,0,28,4],[27,6,27,7],[27,8,27,9],[27,13,31,13],[27,37,27,38],[28,6,28,7],[28,8,28,9],[28,37,28,38],[29,37,29,38],[30,37,30,38],[31,37,31,38],[32,37,32,38],[33,0,33,12],[33,37,36,41],[35,0,38,0],[35,1,38,1],[35,2,38,2],[35,3,38,3],[35,4,38,4],[35,5,38,5],[35,6,38,6],[35,7,38,7],[35,8,38,8],[35,9,38,9],[35,10,38,10],[35,11,38,11],[35,12,38,12],[40,0,43,0],[40,1,43,1],[40,2,43,2],[40,3,43,3],[40,4,43,4],[40,5,43,5],[40,6,43,6],[40,7,43,7],[40,8,43,8],[40,9,43,9],[40,10,43,10],[40,11,43,11],[40,12,43,12],[48,0,48,12],[49,0,49,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,11,49,12],[50,0,51,1],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,11,50,12],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,11,51,12],[52,0,52,1],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,11,52,12],[53,0,53,1],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,11,53,12],[54,0,54,1],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,11,54,12],[58,0,58,12],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[60,0,61,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[64,0,64,12],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[68,0,68,1],[68,3,68,4],[68,5,68,6],[68,7,68,8],[68,9,68,10],[68,11,68,12],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[69,9,69,10],[69,11,69,12],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[70,9,70,10],[70,11,70,12],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[72,0,72,12],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[75,0,75,1],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[76,0,76,1],[76,3,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,0,77,1],[77,3,77,4],[77,5,77,6],[77,7,77,8],[77,9,77,10],[77,11,77,12],[78,0,78,1],[78,3,78,4],[78,5,78,6],[78,7,78,8],[78,9,78,10],[78,11,78,12],[82,0,82,12],[83,0,83,2],[83,3,83,5],[83,6,83,8],[83,9,83,10],[83,11,83,12],[84,0,85,2],[84,3,84,5],[84,6,84,8],[84,9,85,10],[84,11,84,12],[85,3,85,5],[85,6,85,8],[85,11,85,12],[86,0,86,2],[86,3,86,5],[86,6,86,8],[86,9,86,10],[86,11,86,12],[87,0,87,2],[87,3,87,5],[87,6,87,8],[87,9,87,10],[87,11,87,12],[88,0,88,2],[88,3,88,5],[88,6,88,8],[88,9,88,10],[88,11,88,12],[93,1,94,10],[95,1,99,1],[95,2,95,4],[95,5,95,7],[95,8,95,10],[96,2,96,4],[96,5,96,7],[96,8,96,10],[97,4,98,4],[97,7,98,7],[97,10,98,10],[100,1,100,10],[101,1,101,10]]}
["Worksheet 1A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Segments",{"$nulls":14},"User Work Space"]
[{"$nulls":37},"Tables Affiliated with Crash Modification Factors:"]
["General Information",{"$nulls":5},"Location Information",{"$nulls":17},"Supplemental CMF Calculations for Shoulders:"]
["Analyst",null,{"$f":"'Project Information'!$B$6","v":"John Smith"},{"$nulls":3},"Roadway",null,null,{"$f":"VLOOKUP('Segment Template'!$C$7,'Project Information'!$A$16:$H$103,2,FALSE)","v":{"$error":"#N/A"}}]
["Agency or Company",null,{"$f":"'Project Information'!$B$7","v":"ABC Company"},{"$nulls":3},"Roadway Section",null,null,{"$f":"VLOOKUP('Segment Template'!$C$7,'Project Information'!$A$16:$H$103,3,FALSE)","v":{"$error":"#N/A"}},{"$nulls":27},"Table 10-8: CMF for Lane Width on Roadway Segments (CMFra)"]
["Date Performed",null,{"$f":"'Project Information'!$F$5","v":"2011-05-12"},{"$nulls":3},"Jurisdiction",null,null,{"$f":"VLOOKUP('Segment Template'!$C$7,'Project Information'!$A$16:$H$103,4,FALSE)","v":{"$error":"#N/A"}},{"$nulls":14},"Calculated Right Shoulder Width (CMFwra) :",{"$nulls":3},{"$f":"IF($G$10>2000,(VLOOKUP($H$12,$AL$25:$AP$33,5,FALSE)),IF($G$10<400,(VLOOKUP($H$12,$AL$25:$AP$33,3,FALSE)),(VLOOKUP($H$12,$AL$25:$AP$33,4))))","v":{"v":1.1,"d":"1.10"}},null,"Calculated Left Shoulder Width (CMFwra) :",{"$nulls":3},{"$f":"IF($G$10>2000,(VLOOKUP($J$12,$AL$25:$AP$33,5,FALSE)),IF($G$10<400,(VLOOKUP($J$12,$AL$25:$AP$33,3,FALSE)),(VLOOKUP($J$12,$AL$25:$AP$33,4))))","v":{"v":1.1,"d":"1.10"}}]
["Segment for Analysis",null,"Segment 1",{"$nulls":3},"Analysis Year",null,null,{"$f":"'Project Information'!$F$6","v":2011},{"$nulls":27},"Lane Width (ft)",null,"AADT (veh/day)"]
["Input Data",{"$nulls":5},"Site Conditions",{"$nulls":3},"Base Conditions",{"$nulls":13},"Calculated Right Shoulder Type (CMF tra) :",{"$nulls":3},{"$f":"IF($H$13=\"Paved\",(HLOOKUP($H$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($H$13=\"Gravel\",(HLOOKUP($H$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($H$13=\"Turf\",(HLOOKUP($H$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($H$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":{"v":1,"d":"1.00"}},null,"Calculated Left Shoulder Type (CMF tra) :",{"$nulls":3},{"$f":"IF($J$13=\"Paved\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($J$13=\"Gravel\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($J$13=\"Turf\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":{"v":1,"d":"1.00"}},{"$nulls":4},"< 400","400 to 2000","> 2000"]
["Length of segment, L (mi)",{"$nulls":9},"--",{"$nulls":26},9,null,1.05,{"$f":"+($G$10-400)*0.000281+1.05","v":{"v":0.9376,"d":"0.94"}},{"v":1.5,"d":"1.50"}]
["AADT (veh/day)",null,null,"AADTMAX =",{"v":17800,"d":"17,800"},"(veh/day)",{"$nulls":4},"--",null,null,{"$f":"IF(G10>E10,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"},{"$nulls":10},"Computed Right Shoulder CMF2r :",{"$nulls":3},{"$f":"(+$AC$6*$AC$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":{"v":1.0574000000000001,"d":"1.06"}},null,"Computed Left Shoulder CMF2r :",{"$nulls":3},{"$f":"(+$AI$6*$AI$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":{"v":1.0574000000000001,"d":"1.06"}},null,null,9.5,null,{"$f":"+(AN9+AN11)/2","v":{"v":1.0350000000000001,"d":"1.04"}},{"$f":"+(AO9+AO11)/2","v":{"v":0.9438,"d":"0.94"}},{"$f":"+(AP9+AP11)/2","v":{"v":1.4,"d":"1.40"}}]
["Lane width (ft)",{"$nulls":9},12,{"$nulls":26},10,null,1.02,{"$f":"+($G$10-400)*0.000175+1.02","v":{"v":0.9500000000000001,"d":"0.95"}},{"v":1.3,"d":"1.30"}]
["Shoulder width (ft)",{"$nulls":5},"Right Shld:",null,"Left Shld:",null,6,{"$nulls":13},"Supplemental CMF Calculations for Horizontal Curves:",{"$nulls":12},10.5,null,{"$f":"+(AN11+AN13)/2","v":{"v":1.0150000000000001,"d":"1.02"}},{"$f":"+(AO11+AO13)/2","v":{"v":0.9750000000000001,"d":"0.98"}},{"$f":"+(AP11+AP13)/2","v":{"v":1.175,"d":"1.18"}}]
["Shoulder type",{"$nulls":5},"Right Shld:",null,"Left Shld:",null,"Paved",{"$nulls":26},11,null,1.01,{"$f":"+($G$10-400)*0.000025+1.01","v":{"v":1,"d":"1.00"}},1.05]
["Length of horizontal curve (mi)",{"$nulls":9},0,{"$nulls":13},"Adjusted Curve Radius (if less than 100 ft):",{"$nulls":3},{"$f":"IF($G$15>0,IF($G$15<=100,100,$G$15),0)","v":0},{"$nulls":8},11.5,null,{"$f":"+(AN13+AN15)/2","v":{"v":1.005,"d":"1.01"}},{"$f":"+(AO13+AO15)/2","v":{"v":1,"d":"1.00"}},{"$f":"+(AP13+AP15)/2","v":{"v":1.025,"d":"1.03"}}]
["Radius of curvature (ft)",{"$nulls":9},0,null,null,{"$f":"IF(G14>0,IF(G15=0,\"Value of radius must be > 0\",\"Radius Value OK\"),\"Radius Value OK\")","v":"Radius Value OK"},{"$nulls":23},12,null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Spiral transition curve (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":13},"Adjusted Curve Length (if less than 100 ft):",{"$nulls":3},{"$f":"IF($G$14>0,IF($G$14<=100/5280,100/5280,$G$14),0)","v":0},{"$nulls":8},"Note: The collision types related to lane 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."]
["Superelevation variance (ft/ft)",{"$nulls":9},"< 0.01"]
["Grade (%)",{"$nulls":9},0,{"$nulls":13},"Numeric Value for S:",{"$nulls":3},{"$f":"IF(G16=\"Present\",1,IF(G16=\"Not Present\",0,0.5))","v":0}]
["Driveway density (driveways/mile)",{"$nulls":9},5]
["Centerline rumble strips (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":13},"Calculated Horizonatal Curve CMF:",{"$nulls":3},{"$f":"IF( $AC$16>0, ((1.55*$AC$16)+(80.2/$AC$14)-(0.012*(IF($AC$18=\"Present\",TRUE,FALSE))))/(1.55*$AC$16), 1)","v":{"v":1,"d":"1.000"}}]
["Passing lanes [present (1 lane) /present (2 lane) / not present)]",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":26},"Table 10-9: CMF for Shoulder Width on Roadway Segments (CMFwra)"]
["Two-way left-turn lane (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":13},"Adjusted Horizontal Curve CMF:",{"$nulls":3},{"$f":"IF($AC$20<1,1,$AC$20)","v":{"v":1,"d":"1.000"}}]
["Roadside hazard rating (1-7 scale)",{"$nulls":9},3,{"$nulls":26},"Shoulder Width (ft)",null,"AADT (veh/day)"]
["Segment lighting (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":28},"< 400","400 to 2000","> 2000"]
["Auto speed enforcement (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present",{"$nulls":26},0,null,{"v":1.1,"d":"1.10"},{"$f":"+($G$10-400)*0.00025+1.1","v":{"v":1,"d":"1.00"}},{"v":1.5,"d":"1.50"}]
["Calibration Factor, Cr",{"$nulls":5},{"v":1,"d":"1.00"},{"$nulls":3},1,{"$nulls":26},1,null,{"$f":"+(AN25+AN27)/2","v":{"v":1.085,"d":"1.09"}},{"$f":"+(AO25+AO27)/2","v":{"v":1.0064000000000002,"d":"1.01"}},{"$f":"+(AP25+AP27)/2","v":{"v":1.4,"d":"1.40"}}]
["Average Annual Crash History (3 or 5-yr average)",{"$nulls":36},2,null,1.07,{"$f":"+($G$10-400)*0.000143+1.07","v":{"v":1.0128000000000001,"d":"1.01"}},{"v":1.3,"d":"1.30"}]
["           Segment crashes",{"$nulls":4},"KABC","Fatal and Injury Only",null,{"v":0,"d":"0.0"},{"$nulls":4},"If inputs are complete, click for next element",{"$nulls":23},3,null,{"$f":"+(AN27+AN29)/2","v":{"v":1.045,"d":"1.05"}},{"$f":"+(AO27+AO29)/2","v":{"v":1.00015,"d":"1.00"}},{"$f":"+(AP27+AP29)/2","v":{"v":1.225,"d":"1.23"}}]
[{"$nulls":5},"PDO","Property Damage Only",null,{"v":0,"d":"0.0"},{"$nulls":28},4,null,1.02,{"$f":"+($G$10-400)*0.00008125+1.02","v":{"v":0.9875,"d":"0.99"}},1.15,{"$nulls":5},"Base AADT"]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.10-6 in Part C of the HSM)",{"$nulls":36},5,null,1.01,{"$f":"(AO31+AO29)/2","v":{"v":0.99375,"d":"0.99"}},1.08]
[{"$nulls":37},6,null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[{"$nulls":37},7,null,0.99,{"$f":"+(AO31+AO33)/2","v":{"v":1.0037500000000001,"d":"1.00"}},0.94]
[{"$nulls":37},8,null,0.98,{"$f":"+(($G$10-400)*-0.00006875)+0.98","v":{"v":1.0075,"d":"1.01"}},0.87]
["Worksheet 1B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Segments",{"$nulls":36},"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."]
["(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)"]
["CMF for Lane Width","CMF for Shoulder Width and Type","CMF for Horizontal Curves","CMF for Super-elevation","CMF for Grades","CMF for Driveway Density","CMF for Centerline Rumble Strips","CMF for Passing Lanes","CMF for Two-Way Left-Turn Lane","CMF for Roadside Design","CMF for Lighting","CMF for Automated Speed Enforcement","Combined CMF"]
[]
[]
[]
["CMF 1r","CMF 2r","CMF 3r","CMF 4r","CMR 5r","CMF 6r","CMF 7r","CMF 8r","CMF 9r","CMF 10r","CMF 11r","CMF 12r","CMF comb"]
["from Equation 10-11","from Equation 10-12","from Equation 10-13","from Equations 10-14, 10-15, or 10-16","from Table 10-11","from Equation 10-17","from Section 10.7.1","from Section 10.7.1","from Equation 10-18 & 10-19","from Equation 10-20","from Equation 10-21","from Section 10.7.1","(1)x(2)x … x(11)x(12)"]
[]
[]
[]
[{"$f":"((IF($G$10>2000,(VLOOKUP($G$11,$AL$9:$AP$15,5,FALSE)),IF($G$10<400,(VLOOKUP($G$11,$AL$9:$AP$15,3,FALSE)),(VLOOKUP($G$11,$AL$9:$AP$15,4)))))-1)*(IF( 'Segment Tables'!D23=\"No\", (('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":{"$error":"#N/A"}},{"$f":"($AC$10+$AI$10)/2","v":{"v":1.0574000000000001,"d":"1.06"}},{"$f":"+AC22","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$17>=0.02,(1.06+3*($G$17-0.02)),IF($G$17<0.01,1,(1+6*($G$17-0.01))))","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$18>6,1.16,(IF($G$18<=3,1,1.1)))","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$19>5,(0.322+$G$19*(0.05-0.005*LN($G$10)))/(0.322+5*(0.05-0.005*LN($G$10))),1)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G22=\"Present\",1,IF($G$20=\"Present\",0.94,1))","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$21=\"Present (1 lane)\",0.75,IF($G$21=\"Present (2 lanes)\", 0.65, 1))","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$22=\"Not Present\",1,IF($G$19<=5,1,(1-(0.7*0.5*((0.0047*$G$19)+($G$19*$G$19*0.0024))/(1.199+(0.0047*$G$19)+(0.0024*$G$19*$G$19))))))","v":{"v":1,"d":"1.00"}},{"$f":"EXP($G$23*0.0668-0.6869)/EXP(-0.4865)","v":{"v":0.8184033262664786,"d":"0.82"}},{"$f":"IF($G$24=\"Present\",(1-((1-(0.72*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$C$49,'Segment Tables'!$I$49))-(0.83*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$E$49,'Segment Tables'!$K$49)))*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$F$49,'Segment Tables'!$L$49))),1)","v":{"v":1,"d":"1.00"}},{"$f":"IF($G$25=\"Present\",0.93,1)","v":{"v":1,"d":"1.00"}},{"$f":"+A45*B45*C45*D45*E45*F45*G45*H45*I45*J45*K45*L45","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1C -- Roadway Segment Crashes for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)"]
["Crash Severity Level",null,"N spf rs","Overdispersion Parameter, k",null,"Crash Severity Distribution",null,"N spf rs by Severity Distribution",null,"Combined CMFs","Calibration Factor, Cr","Predicted average crash frequency, N predicted rs (crashes/year)"]
[null,null,"from  Equation 10-6","  from Equation 10-7",null,"from Table 10-3 (proportion)",null,"(2)TOTAL x (4)",null,"(13) from Worksheet 1B",null,"(5)x(6)x(7)"]
["Total",null,{"$f":"+G10*G9*365*0.000001*EXP(-0.312)","v":{"v":0,"d":"0.000"}},{"$f":"0.236/G9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Segment Tables'!E15/100","v":{"v":1,"d":"1.000"}},null,{"$f":"+C53*F53","v":{"v":0,"d":"0.000"}},null,{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$G$26","v":{"v":1,"d":"1.00"}},{"$f":"+H53*J53*K53","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$13/100),('Segment Tables'!$H$13/100))","v":0.321},null,{"$f":"+C53*F54","v":{"v":0,"d":"0.000"}},null,{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$G$26","v":{"v":1,"d":"1.00"}},{"$f":"+H54*J54*K54","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$14/100),('Segment Tables'!$H$14/100))","v":0.679},null,{"$f":"+C53*F55","v":{"v":0,"d":"0.000"}},null,{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$G$26","v":{"v":1,"d":"1.00"}},{"$f":"+H55*J55*K55","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted rs (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted rs (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted rs (PDO) (crashes/year)"]
[null,null,"  from Table   10-4","(8)TOTAL from Worksheet 1C",null,"from Table 10-4",null,"(8)FI from Worksheet 1C",null,"from Table 10-4",null,"(8)PDO from Worksheet 1C"]
["Total",null,{"$f":"+C72+C79","v":{"v":1,"d":"1.000"}},{"$f":"+$L$53","v":{"$error":"#N/A"}},null,{"$f":"+F72+F79","v":{"v":1,"d":"1.000"}},null,{"$f":"+$L$54","v":{"$error":"#N/A"}},null,{"v":1,"d":"1.000"},null,{"$f":"+$L$55","v":{"$error":"#N/A"}}]
[{"$nulls":3},"(2)x(3)TOTAL",{"$nulls":3},"(4)x(5)FI",{"$nulls":3},"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G25/100),('Segment Tables'!$K25/100))","v":0.121},{"$f":"+$L$53*C66","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E25/100,'Segment Tables'!$I25/100)","v":0.038},null,{"$f":"+$L$54*F66","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F25/100,'Segment Tables'!$J25/100)","v":0.184},null,{"$f":"+$L$55*J66","v":{"$error":"#N/A"}}]
["Collision with bicycle",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G26/100),('Segment Tables'!$K26/100))","v":{"v":2E-3,"d":"0.002"}},{"$f":"+$L$53*C67","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E26/100,'Segment Tables'!$I26/100)","v":0.004},null,{"$f":"+$L$54*F67","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F26/100,'Segment Tables'!$J26/100)","v":1E-3},null,{"$f":"+$L$55*J67","v":{"$error":"#N/A"}}]
["Collision with pedestrian",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G27/100),('Segment Tables'!$K27/100))","v":0.003},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E27/100,'Segment Tables'!$I27/100)","v":0.006999999999999999},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F27/100,'Segment Tables'!$J27/100)","v":1E-3},null,{"$error":"#N/A"}]
["Overturned",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G28/100),('Segment Tables'!$K28/100))","v":0.025},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E28/100,'Segment Tables'!$I28/100)","v":0.037000000000000005},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F28/100,'Segment Tables'!$J28/100)","v":0.015},null,{"$error":"#N/A"}]
["Ran off road",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G29/100),('Segment Tables'!$K29/100))","v":0.521},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E29/100,'Segment Tables'!$I29/100)","v":0.545},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F29/100,'Segment Tables'!$J29/100)","v":0.505},null,{"$error":"#N/A"}]
["Other single-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G30/100),('Segment Tables'!$K30/100))","v":0.021},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E30/100,'Segment Tables'!$I30/100)","v":0.006999999999999999},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F30/100,'Segment Tables'!$J30/100)","v":0.028999999999999998},null,{"$error":"#N/A"}]
["Total single-vehicle crashes",null,{"$f":"+SUM(C66:C71)","v":0.6930000000000001},{"$error":"#N/A"},null,{"$f":"SUM(F66:G71)","v":0.638},null,{"$error":"#N/A"},null,{"$f":"SUM(J66:K71)","v":0.735},null,{"$error":"#N/A"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G33/100),('Segment Tables'!$K33/100))","v":0.085},{"$f":"+$L$53*C74","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E33/100,'Segment Tables'!$I33/100)","v":{"v":0.1,"d":"0.100"}},null,{"$f":"+$L$54*F74","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F33/100,'Segment Tables'!$J33/100)","v":{"v":0.07200000000000001,"d":"0.072"}},null,{"$f":"+$L$55*J74","v":{"$error":"#N/A"}}]
["Head-on collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G34/100),('Segment Tables'!$K34/100))","v":0.016},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E34/100,'Segment Tables'!$I34/100)","v":0.034},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F34/100,'Segment Tables'!$J34/100)","v":0.003},null,{"$f":"+$L$55*J75","v":{"$error":"#N/A"}}]
["Rear-end collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G35/100),('Segment Tables'!$K35/100))","v":0.142},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E35/100,'Segment Tables'!$I35/100)","v":{"v":0.16399999999999998,"d":"0.164"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F35/100,'Segment Tables'!$J35/100)","v":0.122},null,{"$f":"+$L$55*J76","v":{"$error":"#N/A"}}]
["Sideswipe collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G36/100),('Segment Tables'!$K36/100))","v":{"v":0.037000000000000005,"d":"0.037"}},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E36/100,'Segment Tables'!$I36/100)","v":0.038},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F36/100,'Segment Tables'!$J36/100)","v":0.038},null,{"$f":"+$L$55*J77","v":{"$error":"#N/A"}}]
["Other multiple-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G37/100),('Segment Tables'!$K37/100))","v":{"v":0.027000000000000003,"d":"0.027"}},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E37/100,'Segment Tables'!$I37/100)","v":{"v":0.026000000000000002,"d":"0.026"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F37/100,'Segment Tables'!$J37/100)","v":{"v":0.03,"d":"0.030"}},null,{"$f":"+$L$55*J78","v":{"$error":"#N/A"}}]
["Total multiple-vehicle crashes",null,{"$f":"SUM(C74:C78)","v":0.30700000000000005},{"$error":"#N/A"},null,{"$f":"SUM(F74:F78)","v":0.362},null,{"$error":"#N/A"},null,{"$f":"SUM(J74:J78)","v":0.265},null,{"$f":"SUM(L74:L78)","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1E -- Summary Results for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)",null,"(5)"]
["Crash severity level",null,null,"Crash Severity Distribution (proportion)",null,null,"Predicted average crash frequency (crashes/year)",null,null,"Roadway segment length (mi)",null,"Crash rate (crashes/mi/year)"]
[{"$nulls":3},"(4) from Worksheet 1C",null,null,"(8) from Worksheet 1C",{"$nulls":4},"(3)/(4)"]
["Total",null,null,{"$f":"+F53","v":{"v":1,"d":"1.000"}},null,null,{"$f":"+L53","v":{"$error":"#N/A"}},null,null,{"$f":"+$G$9","v":0},null,{"$f":"+G87/J87","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,null,{"$f":"+F54","v":0.321},null,null,{"$f":"+L54","v":{"$error":"#N/A"}},null,null,{"$f":"+$G$9","v":0},null,{"$f":"+G88/J88","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,null,{"$f":"+F55","v":0.679},null,null,{"$f":"+L55","v":{"$error":"#N/A"}},null,null,{"$f":"+$G$9","v":0},null,{"$f":"+G89/J89","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[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(G87,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Rural 2-Lane Site Total'!$B$12:$C$37,$C$7,'Rural 2-Lane Site Total'!$L$12:$L$37),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(D100>C100,ROUND(D100-C100,1),0),0)","v":{"v":0,"d":"0.0"}},{"$f":"ROUND(G88,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+D100*F100/C100),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(G100>F100,ROUND(G100-F100,1),0),0)","v":{"v":0,"d":"0.0"}},{"$f":"ROUND(G89,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+D100*I100/C100),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(J100>I100,ROUND(J100-I100,1),0),0)","v":{"v":0,"d":"0.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":"Intersection Template","index":8,"n_rows":87,"n_cols":48,"rows_kept":87,"hidden":true,"merged":[[0,0,1,12],[0,20,0,25],[2,0,2,5],[2,6,2,12],[3,0,3,1],[3,2,3,5],[3,6,3,8],[3,9,3,12],[4,0,4,1],[4,2,4,5],[4,6,4,8],[4,9,4,12],[5,0,5,1],[5,2,5,5],[5,6,5,8],[5,9,5,12],[6,0,6,1],[6,2,6,5],[6,6,6,8],[6,9,6,12],[7,0,7,1],[7,2,7,5],[7,6,7,8],[7,9,7,12],[8,0,8,5],[8,6,8,9],[8,10,8,12],[9,0,9,5],[9,6,9,9],[9,10,9,12],[10,0,10,2],[10,6,10,9],[10,10,10,12],[11,0,11,2],[11,6,11,9],[11,10,11,12],[12,10,12,12],[13,0,13,5],[13,6,13,9],[13,10,13,12],[14,0,14,5],[14,6,14,9],[14,10,14,12],[15,0,15,5],[15,6,15,9],[15,10,15,12],[16,0,16,5],[16,6,16,9],[16,10,16,12],[17,0,17,10],[17,13,22,13],[18,0,19,5],[18,9,18,10],[19,9,19,10],[23,0,23,12],[24,0,24,2],[24,3,24,4],[24,5,24,7],[24,8,24,10],[24,11,24,12],[25,0,25,2],[25,3,25,4],[25,5,25,7],[25,8,25,10],[25,11,25,12],[26,0,26,2],[26,3,26,4],[26,5,26,7],[26,8,26,10],[26,11,26,12],[27,0,27,2],[27,3,27,4],[27,5,27,7],[27,8,27,10],[27,11,27,12],[28,0,28,2],[28,3,28,4],[28,5,28,7],[28,8,28,10],[28,11,28,12],[29,0,29,2],[29,5,29,7],[29,8,29,10],[31,0,31,12],[32,0,32,1],[32,2,32,3],[32,6,32,7],[32,9,32,10],[32,11,32,12],[33,0,36,1],[33,2,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,7],[33,8,34,8],[33,9,36,10],[33,11,34,12],[35,2,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,7],[35,8,36,8],[35,11,36,12],[37,0,37,1],[37,2,37,3],[37,6,37,7],[37,9,37,10],[37,11,37,12],[38,0,38,1],[38,2,38,3],[38,6,38,7],[38,9,38,10],[38,11,38,12],[39,0,39,1],[39,2,39,3],[39,6,39,7],[39,9,39,10],[39,11,39,12],[42,0,42,12],[43,0,43,1],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,0,48,1],[44,2,46,2],[44,3,46,4],[44,5,46,6],[44,7,46,8],[44,9,46,10],[44,11,46,12],[47,2,48,2],[47,3,48,4],[47,5,48,6],[47,7,48,8],[47,9,48,10],[47,11,48,12],[49,0,49,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[50,0,50,1],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[51,0,51,12],[52,0,52,1],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,0,53,1],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[54,0,54,1],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[59,0,59,12],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[68,0,68,12],[69,0,69,3],[69,4,69,7],[69,8,69,12],[70,0,71,3],[70,4,70,7],[70,8,70,12],[71,4,71,7],[71,8,71,12],[72,0,72,3],[72,4,72,7],[72,8,72,12],[73,0,73,3],[73,4,73,7],[73,8,73,12],[74,0,74,3],[74,4,74,7],[74,8,74,12],[78,2,79,11],[80,2,84,2],[80,3,80,5],[80,6,80,8],[80,9,80,11],[81,3,81,5],[81,6,81,8],[81,9,81,11],[82,5,83,5],[82,8,83,8],[82,11,83,11],[85,2,85,11],[86,2,86,11]]}
["Worksheet 2A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Intersections",{"$nulls":19},"User Work Space"]
[]
["General Information",{"$nulls":5},"Location Information"]
["Analyst",null,{"$f":"'Project Information'!$B$6","v":"John Smith"},{"$nulls":3},"Roadway",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$103,2,FALSE)","v":{"$error":"#N/A"}}]
["Agency or Company",null,{"$f":"'Project Information'!$B$7","v":"ABC Company"},{"$nulls":3},"Intersection",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$103,3,FALSE)","v":{"$error":"#N/A"}}]
["Date Performed",null,{"$f":"'Project Information'!$F$5","v":"2011-05-12"},{"$nulls":3},"Jurisdiction",null,null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$103,4,FALSE)","v":{"$error":"#N/A"}}]
["Intersection",null,"Intersection 1",{"$nulls":3},"Analysis Year",null,null,{"$f":"'Project Information'!$F$6","v":2011}]
["Signalized/Unsignalized",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$17:$H$103,6,FALSE)","v":{"$error":"#N/A"}}]
["Input Data",{"$nulls":5},"Site Conditions",{"$nulls":3},"Base Conditions"]
["Intersection type (3ST, 4ST, 4SG)",{"$nulls":9},"--",{"$nulls":3},{"$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\",19500,IF($G$10=\"4ST\",14700,25200))","v":{"v":25200,"d":"25,200"}},"(veh/day)",{"$nulls":4},"--",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\",4300,IF($G$10=\"4ST\",3500,12500))","v":{"v":12500,"d":"12,500"}},"(veh/day)",{"$nulls":4},"--",null,null,{"$f":"IF(G12>E12,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Intersection skew angle (degrees)",null,"[If 4ST, does skew differ for minor legs? Else, No.]",{"$nulls":3},"Skew for Leg 1 (All):",0,"Skew for Leg 2 (4ST only):",0,0,{"$nulls":3},"Skew Intersection:"]
["Number of signalized or uncontrolled approaches with a left-turn lane (0, 1, 2, 3, 4)",{"$nulls":9},0]
["Number of signalized or uncontrolled approaches with a right-turn lane (0, 1, 2, 3, 4)",{"$nulls":9},0]
["Intersection lighting (present/not present)",{"$nulls":5},"Not Present",{"$nulls":3},"Not Present"]
["Calibration Factor, Ci",{"$nulls":5},{"v":1,"d":"1.00"},{"$nulls":3},{"v":1,"d":"1.00"}]
["Average Annual Crash History (3 or 5-yr average)",{"$nulls":12},"If inputs are complete, click for next element"]
["           Intersection crashes",{"$nulls":5},"KABC","Fatal and Injury Only",null,{"v":0,"d":"0.0"}]
[{"$nulls":6},"PDO","Property Damage Only",null,{"v":0,"d":"0.0"}]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.10-6 in Part C of the HSM)"]
[]
[]
["Worksheet 2B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,null,"(2)",null,"(3)",null,null,"(4)",null,null,"(5)"]
["CMF for Intersection Skew Angle",null,null,"CMF for Left-Turn Lanes",null,"CMF for Right-Turn Lanes",null,null,"CMF for Lighting",null,null,"Combined CMF"]
["CMF 1i",null,null,"CMF 2i",null,"CMF 3i",null,null,"CMF 4i",null,null,"CMF COMB"]
["from Equations 10-22 or 10-23",null,null,"from Table 10-13",null,"from Table 10-14",null,null,"from Equation 10-24",null,null,"(1)*(2)*(3)*(4)"]
[{"$f":"IF(+$G$10=\"3ST\",(EXP(0.004*$H$13)),(IF(+$G$10=\"4ST\",(IF($F$13=\"No\",(EXP(0.0054*$H$13)),(((EXP(0.0054*$H$13))+(EXP(0.0054*$J$13)))/2))),1)))","v":{"v":1,"d":"1.00"}},null,null,{"$f":"IF($G$10=\"3ST\",(IF($G$14=0,1,(HLOOKUP($G$14,'Intersection Tables'!$AC$9:$AF$15,3,FALSE)))),(IF($G$10=\"4ST\",(IF($G$14=0,1,(HLOOKUP($G$14,'Intersection Tables'!$AC$9:$AF$15,5,FALSE)))),(IF($G$14=0,1,(HLOOKUP($G$14,'Intersection Tables'!$AC$9:$AF$15,7,FALSE)))))))","v":{"v":1,"d":"1.00"}},null,{"$f":"IF($G$10=\"3ST\",(IF($G$15=0,1,(HLOOKUP($G$15,'Intersection Tables'!$AC$25:$AF$31,3,FALSE)))),(IF($G$10=\"4ST\",(IF($G$15=0,1,(HLOOKUP($G$15,'Intersection Tables'!$AC$25:$AF$31,5,FALSE)))),(IF($G$15=0,1,(HLOOKUP($G$15,'Intersection Tables'!$AC$25:$AF$31,7,FALSE)))))))","v":{"v":1,"d":"1.00"}},null,null,{"$f":"IF(($G$16=\"Not Present\"),1,(1-0.38*(IF('Intersection Tables'!$D$49=\"No\",(VLOOKUP( $G$10,'Intersection Tables'!$B$50:$F$52,4,FALSE)),(VLOOKUP($G$10,'Intersection Tables'!B50:H52,6,FALSE))))))","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+A29*D29*F29*I29","v":{"v":1,"d":"1.00"}},{"$nulls":35},"Base AADT"]
[]
[]
["Worksheet 2C -- Intersection Crashes for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,"(2)",null,"(3)","(4)","(5)",null,"(6)","(7)",null,"(8)"]
["Crash Severity Level",null,"N spf 3ST, 4ST or 4SG",null,"Overdispersion Parameter, k","Crash Severity Distribution","N spf 3ST, 4ST or 4SG by Severity Distribution",null,"Combined CMFs","Calibration Factor, Ci",null,"Predicted average crash frequency,   N predicted int"]
[]
[null,null,"from Equations 10-8, 10-9, or 10-10",null,"from Section 10.6.2","  from Table  10-5","(2)TOTAL * (4)",null,"from (5) of Worksheet 2B",null,null,"(5)*(6)*(7)",{"$nulls":4},"3ST",0]
[{"$nulls":16},"4ST",1]
["Total",null,{"$f":"IF($G$10=\"3ST\",(EXP(-9.86+0.79*(LN($G$11))+(0.49*(LN($G$12))))),IF($G$10=\"4ST\",(EXP(-8.56+0.6*(LN($G$11))+(0.61*(LN($G$12))))),(EXP(-5.13+(0.6*(LN($G$11)))+(0.2*(LN($G$12)))))))","v":{"$error":"#NUM!"}},null,{"$f":"IF($G$10=\"3ST\",0.54,(IF($G$10=\"4ST\",0.24,0.11)))","v":0.11},{"$f":"IF($G$10=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$18,'Intersection Tables'!$K$18),(IF($G$10=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$18,'Intersection Tables'!$M$18)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$18,'Intersection Tables'!$O$18)))))/100","v":{"v":1,"d":"1.000"}},{"$f":"+C38*F38","v":{"$error":"#NUM!"}},null,{"$f":"+$L$29","v":{"v":1,"d":"1.00"}},{"$f":"+$G$17","v":{"v":1,"d":"1.00"}},null,{"$f":"+G38*I38*J38","v":{"$error":"#NUM!"}},{"$nulls":4},"4SG",2]
["Fatal and Injury (FI)",null,"--",null,"--",{"$f":"IF($G$10=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$16,'Intersection Tables'!$K$16),(IF($G$10=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$16,'Intersection Tables'!$M$16)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$16,'Intersection Tables'!$O$16)))))/100","v":{"v":0.34,"d":"0.340"}},{"$f":"+C38*F39","v":{"$error":"#NUM!"}},null,{"$f":"+$L$29","v":{"v":1,"d":"1.00"}},{"$f":"+$G$17","v":{"v":1,"d":"1.00"}},null,{"$f":"+G39*I39*J39","v":{"$error":"#NUM!"}},{"$nulls":5},3]
["Property Damage Only (PDO)",null,"--",null,"--",{"$f":"IF($G$10=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$17,'Intersection Tables'!$K$17),(IF($G$10=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$17,'Intersection Tables'!$M$17)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$17,'Intersection Tables'!$O$17)))))/100","v":{"v":0.66,"d":"0.660"}},{"$f":"+C38*F40","v":{"$error":"#NUM!"}},null,{"$f":"+$L$29","v":{"v":1,"d":"1.00"}},{"$f":"+$G$17","v":{"v":1,"d":"1.00"}},null,{"$f":"+G40*I40*J40","v":{"$error":"#NUM!"}},{"$nulls":5},4]
[]
[{"$nulls":16},"Yes"]
["Worksheet 2D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Road Intersections",{"$nulls":15},"No"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted int (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted int (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted int (PDO) (crashes/year)"]
[]
[]
[null,null,"    from Table  10-6","(8)TOTAL from Worksheet 2C",null,"from Table 10-6",null,"(8)FI from Worksheet 2C",null,"from Table 10-6",null,"(8)PDO from Worksheet 2C"]
[]
["Total",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G43,(IF($G$10=\"4ST\",'Intersection Tables'!J43,'Intersection Tables'!M43)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P43,(IF($G$10=\"4ST\",+'Intersection Tables'!S43,+'Intersection Tables'!V43)))/100))","v":{"v":1,"d":"1.000"}},{"$f":"+L38","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E43,(IF($G$10=\"4ST\",'Intersection Tables'!H43,'Intersection Tables'!K43)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N43,(IF($G$10=\"4ST\",+'Intersection Tables'!Q43,+'Intersection Tables'!T43)))/100))","v":{"v":1,"d":"1.000"}},null,{"$f":"+L39","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F43,(IF($G$10=\"4ST\",'Intersection Tables'!I43,'Intersection Tables'!L43)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O43,(IF($G$10=\"4ST\",+'Intersection Tables'!R43,+'Intersection Tables'!U43)))/100))","v":{"v":1,"d":"1.000"}},null,{"$f":"+L40","v":{"$error":"#NUM!"}}]
[{"$nulls":3},"(2)x(3)TOTAL",{"$nulls":3},"(4)x(5)FI",{"$nulls":3},"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G29,(IF($G$10=\"4ST\",'Intersection Tables'!J29,'Intersection Tables'!M29)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P29,(IF($G$10=\"4ST\",+'Intersection Tables'!S29,+'Intersection Tables'!V29)))/100))","v":{"v":2E-3,"d":"0.002"}},{"$f":"+C53*$D$50","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E29,(IF($G$10=\"4ST\",'Intersection Tables'!H29,'Intersection Tables'!K29)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N29,(IF($G$10=\"4ST\",+'Intersection Tables'!Q29,+'Intersection Tables'!T29)))/100))","v":{"v":0,"d":"0.000"}},null,{"$f":"+$H$50*F53","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F29,(IF($G$10=\"4ST\",'Intersection Tables'!I29,'Intersection Tables'!L29)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O29,(IF($G$10=\"4ST\",+'Intersection Tables'!R29,+'Intersection Tables'!U29)))/100))","v":0.003},null,{"$f":"+$L$50*J53","v":{"$error":"#NUM!"}}]
["Collision with bicycle",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G30,(IF($G$10=\"4ST\",'Intersection Tables'!J30,'Intersection Tables'!M30)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P30,(IF($G$10=\"4ST\",+'Intersection Tables'!S30,+'Intersection Tables'!V30)))/100))","v":{"v":1E-3,"d":"0.001"}},{"$f":"+C54*$D$50","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E30,(IF($G$10=\"4ST\",'Intersection Tables'!H30,'Intersection Tables'!K30)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N30,(IF($G$10=\"4ST\",+'Intersection Tables'!Q30,+'Intersection Tables'!T30)))/100))","v":{"v":1E-3,"d":"0.001"}},null,{"$f":"+$H$50*F54","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F30,(IF($G$10=\"4ST\",'Intersection Tables'!I30,'Intersection Tables'!L30)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O30,(IF($G$10=\"4ST\",+'Intersection Tables'!R30,+'Intersection Tables'!U30)))/100))","v":{"v":1E-3,"d":"0.001"}},null,{"$f":"+$L$50*J54","v":{"$error":"#NUM!"}}]
["Collision with pedestrian",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G31,(IF($G$10=\"4ST\",'Intersection Tables'!J31,'Intersection Tables'!M31)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P31,(IF($G$10=\"4ST\",+'Intersection Tables'!S31,+'Intersection Tables'!V31)))/100))","v":{"v":1E-3,"d":"0.001"}},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E31,(IF($G$10=\"4ST\",'Intersection Tables'!H31,'Intersection Tables'!K31)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N31,(IF($G$10=\"4ST\",+'Intersection Tables'!Q31,+'Intersection Tables'!T31)))/100))","v":{"v":1E-3,"d":"0.001"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F31,(IF($G$10=\"4ST\",'Intersection Tables'!I31,'Intersection Tables'!L31)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O31,(IF($G$10=\"4ST\",+'Intersection Tables'!R31,+'Intersection Tables'!U31)))/100))","v":{"v":1E-3,"d":"0.001"}},null,{"$error":"#NUM!"}]
["Overturned",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G32,(IF($G$10=\"4ST\",'Intersection Tables'!J32,'Intersection Tables'!M32)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P32,(IF($G$10=\"4ST\",+'Intersection Tables'!S32,+'Intersection Tables'!V32)))/100))","v":0.003},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E32,(IF($G$10=\"4ST\",'Intersection Tables'!H32,'Intersection Tables'!K32)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N32,(IF($G$10=\"4ST\",+'Intersection Tables'!Q32,+'Intersection Tables'!T32)))/100))","v":0.003},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F32,(IF($G$10=\"4ST\",'Intersection Tables'!I32,'Intersection Tables'!L32)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O32,(IF($G$10=\"4ST\",+'Intersection Tables'!R32,+'Intersection Tables'!U32)))/100))","v":0.003},null,{"$error":"#NUM!"}]
["Ran off road",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G33,(IF($G$10=\"4ST\",'Intersection Tables'!J33,'Intersection Tables'!M33)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P33,(IF($G$10=\"4ST\",+'Intersection Tables'!S33,+'Intersection Tables'!V33)))/100))","v":0.064},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E33,(IF($G$10=\"4ST\",'Intersection Tables'!H33,'Intersection Tables'!K33)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N33,(IF($G$10=\"4ST\",+'Intersection Tables'!Q33,+'Intersection Tables'!T33)))/100))","v":0.032},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F33,(IF($G$10=\"4ST\",'Intersection Tables'!I33,'Intersection Tables'!L33)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O33,(IF($G$10=\"4ST\",+'Intersection Tables'!R33,+'Intersection Tables'!U33)))/100))","v":0.081},null,{"$error":"#NUM!"}]
["Other single-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G34,(IF($G$10=\"4ST\",'Intersection Tables'!J34,'Intersection Tables'!M34)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P34,(IF($G$10=\"4ST\",+'Intersection Tables'!S34,+'Intersection Tables'!V34)))/100))","v":0.005},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E34,(IF($G$10=\"4ST\",'Intersection Tables'!H34,'Intersection Tables'!K34)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N34,(IF($G$10=\"4ST\",+'Intersection Tables'!Q34,+'Intersection Tables'!T34)))/100))","v":0.003},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F34,(IF($G$10=\"4ST\",'Intersection Tables'!I34,'Intersection Tables'!L34)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O34,(IF($G$10=\"4ST\",+'Intersection Tables'!R34,+'Intersection Tables'!U34)))/100))","v":{"v":0.018000000000000002,"d":"0.018"}},null,{"$error":"#NUM!"}]
["Total single-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G35,(IF($G$10=\"4ST\",'Intersection Tables'!J35,'Intersection Tables'!M35)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P35,(IF($G$10=\"4ST\",+'Intersection Tables'!S35,+'Intersection Tables'!V35)))/100))","v":{"v":0.07600000000000001,"d":"0.076"}},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E35,(IF($G$10=\"4ST\",'Intersection Tables'!H35,'Intersection Tables'!K35)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N35,(IF($G$10=\"4ST\",+'Intersection Tables'!Q35,+'Intersection Tables'!T35)))/100))","v":{"v":0.04,"d":"0.040"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F35,(IF($G$10=\"4ST\",'Intersection Tables'!I35,'Intersection Tables'!L35)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O35,(IF($G$10=\"4ST\",+'Intersection Tables'!R35,+'Intersection Tables'!U35)))/100))","v":{"v":0.10700000000000001,"d":"0.107"}},null,{"$error":"#NUM!"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G37,(IF($G$10=\"4ST\",'Intersection Tables'!J37,'Intersection Tables'!M37)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P37,(IF($G$10=\"4ST\",+'Intersection Tables'!S37,+'Intersection Tables'!V37)))/100))","v":{"v":0.27399999999999997,"d":"0.274"}},{"$f":"+C61*$D$50","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E37,(IF($G$10=\"4ST\",'Intersection Tables'!H37,'Intersection Tables'!K37)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N37,(IF($G$10=\"4ST\",+'Intersection Tables'!Q37,+'Intersection Tables'!T37)))/100))","v":0.336},null,{"$f":"+$H$50*F61","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F37,(IF($G$10=\"4ST\",'Intersection Tables'!I37,'Intersection Tables'!L37)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O37,(IF($G$10=\"4ST\",+'Intersection Tables'!R37,+'Intersection Tables'!U37)))/100))","v":0.242},null,{"$f":"+$L$50*J61","v":{"$error":"#NUM!"}}]
["Head-on collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G38,(IF($G$10=\"4ST\",'Intersection Tables'!J38,'Intersection Tables'!M38)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P38,(IF($G$10=\"4ST\",+'Intersection Tables'!S38,+'Intersection Tables'!V38)))/100))","v":{"v":0.054000000000000006,"d":"0.054"}},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E38,(IF($G$10=\"4ST\",'Intersection Tables'!H38,'Intersection Tables'!K38)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N38,(IF($G$10=\"4ST\",+'Intersection Tables'!Q38,+'Intersection Tables'!T38)))/100))","v":{"v":0.08,"d":"0.080"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F38,(IF($G$10=\"4ST\",'Intersection Tables'!I38,'Intersection Tables'!L38)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O38,(IF($G$10=\"4ST\",+'Intersection Tables'!R38,+'Intersection Tables'!U38)))/100))","v":{"v":0.04,"d":"0.040"}},null,{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G39,(IF($G$10=\"4ST\",'Intersection Tables'!J39,'Intersection Tables'!M39)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P39,(IF($G$10=\"4ST\",+'Intersection Tables'!S39,+'Intersection Tables'!V39)))/100))","v":0.426},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E39,(IF($G$10=\"4ST\",'Intersection Tables'!H39,'Intersection Tables'!K39)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N39,(IF($G$10=\"4ST\",+'Intersection Tables'!Q39,+'Intersection Tables'!T39)))/100))","v":{"v":0.40299999999999997,"d":"0.403"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F39,(IF($G$10=\"4ST\",'Intersection Tables'!I39,'Intersection Tables'!L39)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O39,(IF($G$10=\"4ST\",+'Intersection Tables'!R39,+'Intersection Tables'!U39)))/100))","v":{"v":0.43799999999999994,"d":"0.438"}},null,{"$error":"#NUM!"}]
["Sideswipe collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G40,(IF($G$10=\"4ST\",'Intersection Tables'!J40,'Intersection Tables'!M40)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P40,(IF($G$10=\"4ST\",+'Intersection Tables'!S40,+'Intersection Tables'!V40)))/100))","v":{"v":0.11800000000000001,"d":"0.118"}},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E40,(IF($G$10=\"4ST\",'Intersection Tables'!H40,'Intersection Tables'!K40)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N40,(IF($G$10=\"4ST\",+'Intersection Tables'!Q40,+'Intersection Tables'!T40)))/100))","v":0.051},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F40,(IF($G$10=\"4ST\",'Intersection Tables'!I40,'Intersection Tables'!L40)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O40,(IF($G$10=\"4ST\",+'Intersection Tables'!R40,+'Intersection Tables'!U40)))/100))","v":0.153},null,{"$error":"#NUM!"}]
["Other multiple-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G41,(IF($G$10=\"4ST\",'Intersection Tables'!J41,'Intersection Tables'!M41)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P41,(IF($G$10=\"4ST\",+'Intersection Tables'!S41,+'Intersection Tables'!V41)))/100))","v":{"v":0.052000000000000005,"d":"0.052"}},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E41,(IF($G$10=\"4ST\",'Intersection Tables'!H41,'Intersection Tables'!K41)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N41,(IF($G$10=\"4ST\",+'Intersection Tables'!Q41,+'Intersection Tables'!T41)))/100))","v":{"v":0.09,"d":"0.090"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F41,(IF($G$10=\"4ST\",'Intersection Tables'!I41,'Intersection Tables'!L41)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O41,(IF($G$10=\"4ST\",+'Intersection Tables'!R41,+'Intersection Tables'!U41)))/100))","v":{"v":0.02,"d":"0.020"}},null,{"$error":"#NUM!"}]
["Total multiple-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!G42,(IF($G$10=\"4ST\",'Intersection Tables'!J42,'Intersection Tables'!M42)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!P42,(IF($G$10=\"4ST\",+'Intersection Tables'!S42,+'Intersection Tables'!V42)))/100))","v":0.924},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!E42,(IF($G$10=\"4ST\",'Intersection Tables'!H42,'Intersection Tables'!K42)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!N42,(IF($G$10=\"4ST\",+'Intersection Tables'!Q42,+'Intersection Tables'!T42)))/100))","v":{"v":0.96,"d":"0.960"}},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($G$10=\"3ST\",'Intersection Tables'!F42,(IF($G$10=\"4ST\",'Intersection Tables'!I42,'Intersection Tables'!L42)))/100),(IF($G$10=\"3ST\",'Intersection Tables'!O42,(IF($G$10=\"4ST\",+'Intersection Tables'!R42,+'Intersection Tables'!U42)))/100))","v":0.893},null,{"$error":"#NUM!"}]
[]
[]
["Worksheet 2E -- Summary Results for Rural Two-Lane Two-Way Road Intersections"]
["(1)",{"$nulls":3},"(2)",{"$nulls":3},"(3)"]
["Crash severity level",{"$nulls":3},"Crash Severity Distribution (proportion)",{"$nulls":3},"Predicted average crash frequency (crashes / year)"]
[{"$nulls":4},"(4) from Worksheet 2C",{"$nulls":3},"(8) from Worksheet 2C"]
["Total",{"$nulls":3},{"$f":"+F38","v":{"v":1,"d":"1.000"}},{"$nulls":3},{"$f":"+L38","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",{"$nulls":3},{"$f":"+F39","v":{"v":0.34,"d":"0.340"}},{"$nulls":3},{"$f":"+L39","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",{"$nulls":3},{"$f":"+F40","v":{"v":0.66,"d":"0.660"}},{"$nulls":3},{"$f":"+L40","v":{"$error":"#NUM!"}}]
[]
[]
[]
[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"]
[{"$nulls":3},"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[{"$nulls":3},"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"]
[{"$nulls":3},"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[{"$nulls":3},{"$f":"ROUND(I73,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Rural 2-Lane Site Total'!$B$12:$C$37,$C$7,'Rural 2-Lane Site Total'!$L$12:$L$37),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(E85>D85,ROUND(E85-D85,1),0),0)","v":{"v":0,"d":"0.0"}},{"$f":"ROUND(I74,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E85*G85/D85),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(H85>G85,ROUND(H85-G85,1),0),0)","v":{"v":0,"d":"0.0"}},{"$f":"ROUND(I75,1)","v":{"$error":"#NUM!"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+E85*J85/D85),1),0)","v":{"v":0,"d":"0.0"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(K85>J85,ROUND(K85-J85,1),0),0)","v":{"v":0,"d":"0.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":"Segment Tables","index":9,"n_rows":50,"n_cols":27,"rows_kept":50,"hidden":true,"merged":[[4,1,5,9],[4,17,5,26],[6,1,6,3],[6,4,6,9],[6,17,7,17],[6,18,6,26],[7,1,7,2],[7,4,7,6],[7,7,7,9],[8,1,8,3],[8,4,8,6],[8,7,8,9],[9,1,9,3],[9,4,9,6],[9,7,9,9],[10,1,10,3],[10,4,10,6],[10,7,10,9],[11,1,11,3],[11,4,11,6],[11,7,11,9],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,17,13,26],[13,1,13,3],[13,4,13,6],[13,7,13,9],[14,1,14,3],[14,4,14,6],[14,7,14,9],[17,1,18,11],[19,4,19,11],[20,4,20,7],[20,8,20,11],[21,4,22,4],[21,5,22,5],[21,6,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,11],[22,1,22,2],[23,6,23,7],[23,10,23,11],[24,6,24,7],[24,10,24,11],[25,6,25,7],[25,10,25,11],[26,6,26,7],[26,10,26,11],[27,6,27,7],[27,10,27,11],[28,6,28,7],[28,10,28,11],[29,6,29,7],[29,10,29,11],[30,6,30,7],[30,10,30,11],[31,6,31,7],[31,10,31,11],[32,6,32,7],[32,10,32,11],[33,6,33,7],[33,10,33,11],[34,6,34,7],[34,10,34,11],[35,6,35,7],[35,10,35,11],[36,6,36,7],[36,10,36,11],[37,6,37,7],[37,10,37,11],[38,6,38,7],[38,10,38,11],[42,1,42,13],[43,1,47,1],[43,2,43,7],[43,8,43,13],[44,2,44,3],[44,5,46,7],[44,8,46,10],[44,11,46,13],[45,2,46,4],[47,2,47,3],[47,5,47,7],[47,8,47,9],[47,11,47,13],[48,2,48,3],[48,5,48,7],[48,8,48,9],[48,11,48,13]]}
[]
[null,"Tables Affiliated with Crash Statistics:",{"$nulls":15},"Tables Affiliated with Crash Modification Factors:"]
[]
[]
[null,"Table 10-3: Distribution for Crash Severity Level on Rural Two-Lane Two-Way Roadway Segments plus Locally-Derived Values",{"$nulls":15},"Table 10-10: Crash Modification Factors for Shoulder Types and Shoulder Widths on Roadway Segments (CMFtra)"]
[]
[null,"Crash severity level",null,null,"Percentage of total roadway segment crashes",{"$nulls":12},"Shoulder Type","Shoulder width (ft)"]
[null,"Locally-Derived Values?",null,"No","HSM-Provided Values",null,null,"Locally-Derived Values (Oregon)",{"$nulls":10},0,1,2,3,4,5,6,7,8]
[null,"Fatal",null,null,1.3,null,null,3.1,{"$nulls":9},"Paved",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"+(W9+Y9)/2","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"},{"$f":"+(Y9+AA9)/2","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"}]
[null,"Incapacitating Injury",null,null,5.4,null,null,7.7,{"$nulls":9},"Gravel",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},1.01,1.01,1.01,{"$f":"+(W10+Y10)/2","v":{"v":1.0150000000000001,"d":"1.02"}},1.02,{"$f":"+(Y10+AA10)/2","v":1.02},1.02]
[null,"Nonincapacitating Injury",null,null,10.9,null,null,25.2,{"$nulls":9},"Composite",{"v":1,"d":"1.00"},1.01,1.02,1.02,1.03,{"$f":"+(W11+Y11)/2","v":{"v":1.0350000000000001,"d":"1.04"}},1.04,{"$f":"+(Y11+AA11)/2","v":1.05},1.06]
[null,"Possible Injury",null,null,14.5,null,null,{"v":18,"d":"18.0"},{"$nulls":9},"Turf",{"v":1,"d":"1.00"},1.01,1.03,1.04,1.05,{"$f":"+(W12+Y12)/2","v":{"v":1.065,"d":"1.07"}},1.08,{"$f":"+(Y12+AA12)/2","v":{"v":1.0950000000000002,"d":"1.10"}},1.11]
[null,"Total Fatal Plus Injury",null,null,{"$f":"SUM(E9:E12)","v":32.1},null,null,{"$f":"SUM(H9:H12)","v":{"v":54,"d":"54.0"}},{"$nulls":9},"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,"Property Damage Only",null,null,{"$f":"100-E13","v":67.9},null,null,{"$f":"100-H13","v":{"v":46,"d":"46.0"}}]
[null,"TOTAL",null,null,{"$f":"SUM(E13:E14)","v":{"v":100,"d":"100.0"}},null,null,{"$f":"SUM(H13:H14)","v":{"v":100,"d":"100.0"}}]
[null,"Note: HSM-provided crash severity data based on HSIS data for Washington (2002-2006)"]
[]
[null,"Table 10-4: Default Distribution by Collision Type for Specific Crash Severity Levels on Rural Two-Lane Two-Way Roadway Segments plus Locally-Derived Values"]
[]
[{"$nulls":4},"Percentage of total roadway segment crashes by crash severity level"]
[{"$nulls":4},"HSM-Provided Values",{"$nulls":3},"Locally-Derived Values (Oregon)"]
[null,"Collision type",null,null,"Total fatal and injury","Property damage only","TOTAL (all severity levels combined)",null,"Total fatal and injury","Property damage only","TOTAL (all severity levels combined)"]
[null,"Locally-Derived Values?",null,"No"]
[null,"SINGLE-VEHICLE CRASHES"]
[null,"Collision with animal",null,null,3.8,18.4,12.1,null,3.1,{"v":12,"d":"12.0"},7.2]
[null,"Collision with bicycle",null,null,0.4,0.1,0.2,null,0.6,{"v":0,"d":"0.0"},0.3]
[null,"Collision with pedestrian",null,null,0.7,0.1,0.3,null,0.8,{"v":0,"d":"0.0"},0.4]
[null,"Overturned",null,null,3.7,1.5,2.5,null,8.6,3.8,6.4]
[null,"Ran off road",null,null,54.5,50.5,52.1,null,47.2,39.1,43.5]
[null,"Other single-vehicle crash",null,null,0.7,2.9,2.1,null,1.7,1.3,1.5]
[null,"Total single-vehicle crashes",null,null,{"$f":"SUM(E25:E30)","v":63.800000000000004},{"$f":"SUM(F25:F30)","v":73.5},{"$f":"SUM(G25:H30)","v":69.3},null,{"$f":"SUM(I25:I30)","v":{"v":62.00000000000001,"d":"62.0"}},{"$f":"SUM(J25:J30)","v":56.2},{"$f":"SUM(K25:L30)","v":59.3}]
[null,"MULTIPLE-VEHICLE CRASHES"]
[null,"Angle collision",null,null,{"v":10,"d":"10.0"},7.2,8.5,null,0.8,0.7,0.8]
[null,"Head-on collision",null,null,3.4,0.3,1.6,null,5.8,{"v":1,"d":"1.0"},3.6]
[null,"Rear-end collision",null,null,16.4,12.2,14.2,null,18.8,21.5,20.1]
[null,"Sideswipe collision",null,null,3.8,3.8,3.7,null,4.4,7.1,5.6]
[null,"Other multiple-vehicle collision",null,null,2.6,{"v":3,"d":"3.0"},2.7,null,8.2,13.5,10.6]
[null,"Total multiple-vehicle crashes",null,null,{"$f":"SUM(E33:E37)","v":36.199999999999996},{"$f":"SUM(F33:F37)","v":26.5},{"$f":"SUM(G33:H37)","v":30.699999999999996},null,{"$f":"SUM(I33:I37)","v":{"v":38,"d":"38.0"}},{"$f":"SUM(J33:J37)","v":43.8},{"$f":"SUM(K33:L37)","v":40.7}]
[null,"TOTAL CRASHES",null,null,{"$f":"+E31+E38","v":{"v":100,"d":"100.0"}},{"$f":"+F31+F38","v":{"v":100,"d":"100.0"}},{"v":100,"d":"100.0"},null,{"$f":"+I31+I38","v":{"v":100,"d":"100.0"}},{"$f":"+J31+J38","v":{"v":100,"d":"100.0"}},{"v":100,"d":"100.0"}]
[null,"Note:  HSM-provided values based on crash data for Washington (2002-2006); includes approximately 70 percent opposite-direction sideswipe and 30 percent same-direction sideswipe collisions."]
[]
[]
[null,"Table 10-12: Nighttime Crash Proportions for Unlighted Roadway Segments plus Locally-Derived Values"]
[null,"Roadway Type","HSM Default Values",{"$nulls":5},"Locally Derived Values"]
[null,null,"Locally-Derived Values?",null,"No","Proportion of crashes that occur at night",null,null,"Proportion of total nighttime crashes by severity level",null,null,"Proportion of crashes that occur at night"]
[null,null,"Proportion of total nighttime crashes by severity level"]
[]
[null,null,"Fatal and Injury pinr",null,"PDO ppnr","pnr",null,null,"Fatal and Injury pinr",null,"PDO ppnr","pnr"]
[null,"2U",0.382,null,0.618,{"v":0.37,"d":"0.370"},null,null,{"v":0.54,"d":"0.540"},null,{"v":0.46,"d":"0.460"},{"v":0.28,"d":"0.280"}]
[null,"Note:  HSM-provided values based on HSIS data for Washington (2002-2006)"]

{"sheet":"Intersection Tables","index":10,"n_rows":53,"n_cols":32,"rows_kept":53,"hidden":true,"merged":[[4,1,5,15],[4,24,5,31],[6,1,8,3],[6,4,6,15],[6,24,9,25],[6,26,9,27],[6,28,7,31],[7,4,7,9],[7,10,7,15],[8,4,9,5],[8,6,9,7],[8,8,9,9],[8,10,9,11],[8,12,9,13],[8,14,9,15],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[9,1,9,2],[10,1,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,24,11,25],[10,26,11,27],[10,28,11,28],[10,29,11,29],[10,30,11,30],[10,31,11,31],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,1,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[12,24,14,25],[12,26,13,27],[12,28,13,28],[12,29,13,29],[12,30,13,30],[12,31,13,31],[13,1,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[14,1,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,26,14,27],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[15,25,16,31],[16,1,16,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[17,1,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[20,1,21,21],[20,24,21,31],[22,1,25,3],[22,4,22,12],[22,13,22,21],[22,24,25,25],[22,26,25,27],[22,28,23,31],[23,4,24,6],[23,7,24,9],[23,10,24,12],[23,13,24,15],[23,16,24,18],[23,19,24,21],[24,28,25,28],[24,29,25,29],[24,30,25,30],[24,31,25,31],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[25,16,26,16],[25,17,26,17],[25,18,26,18],[25,19,26,19],[25,20,26,20],[25,21,26,21],[26,1,26,2],[26,24,27,25],[26,26,27,27],[26,28,27,28],[26,29,27,29],[26,30,27,30],[26,31,27,31],[27,1,27,12],[27,13,27,21],[28,1,28,3],[28,24,30,25],[28,26,29,27],[28,28,29,28],[28,29,29,29],[28,30,29,30],[28,31,29,31],[29,1,29,3],[30,1,30,3],[30,26,30,27],[31,1,31,3],[31,25,32,31],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,12],[35,13,35,21],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[45,1,46,7],[47,1,47,3],[47,4,47,7],[48,1,48,2],[49,1,49,3],[49,4,49,5],[49,6,49,7],[50,1,50,3],[50,4,50,5],[50,6,50,7],[51,1,51,3],[51,4,51,5],[51,6,51,7]]}
[]
[null,"Tables Affiliated with Crash Statistics:",{"$nulls":22},"Tables Affiliated with Crash Modification Factors:"]
[]
[]
[null,"Table 10-5: Default Distribution for Crash Severity Level at Rural Two-Lane Two-Way Intersections plus Locally-Derived Values",{"$nulls":22},"Table 10-13: CMF for Installation of Left-Turn Lanes on Intersection Approaches (CMF2i)"]
[]
[null,"Collision type",null,null,"Percentage of total crashes",{"$nulls":19},"Intersection type",null,"Intersection traffic control",null,"Number of approaches with left-turn lanes a"]
[{"$nulls":4},"HSM-Provided Values",{"$nulls":5},"Locally-Derived Values"]
[{"$nulls":4},"3ST",null,"4ST",null,"4SG",null,"3ST",null,"4ST",null,"4SG",{"$nulls":13},1,2,3,4]
[null,"Locally-Derived Values?",null,"No"]
[{"$nulls":24},"Three-leg intersection",null,"Minor road stop control b",null,0.56,0.31,0.31,0.31]
[null,"Fatal",null,null,1.7,null,1.8,null,0.9,null,{"v":4,"d":"4.0"},null,{"v":17,"d":"17.0"}]
[null,"Incapacitating injury",null,null,{"v":4,"d":"4.0"},null,4.3,null,2.1,{"$nulls":15},"Four-leg intersection",null,"Minor road stop control b",null,0.72,0.52,0.52,0.52]
[null,"Nonincapacitating injury",null,null,16.6,null,16.2,null,10.5]
[null,"Possible injury",null,null,19.2,null,20.8,null,20.5,{"$nulls":17},"Traffic signal",null,0.82,0.67,0.55,0.45]
[null,"Total fatal plus injury",null,null,{"$f":"SUM(E12:E15)","v":41.5},null,{"$f":"SUM(G12:G15)","v":{"v":43.099999999999994,"d":"43.1"}},null,{"$f":"SUM(I12:I15)","v":{"v":34,"d":"34.0"}},null,{"$f":"SUM(K12:K15)","v":{"v":4,"d":"4.0"}},null,{"$f":"SUM(M12:M15)","v":{"v":17,"d":"17.0"}},null,{"$f":"SUM(O12:O15)","v":{"v":0,"d":"0.0"}},{"$nulls":9},"Note:","a Stop-controlled approaches are not considered in determing the number of approaches with left-turn lanes"]
[null,"Property damage only",null,null,{"$f":"100-E16","v":58.5},null,{"$f":"100-G16","v":{"v":56.900000000000006,"d":"56.9"}},null,{"$f":"100-I16","v":{"v":66,"d":"66.0"}},null,{"$f":"100-K16","v":{"v":96,"d":"96.0"}},null,{"$f":"100-M16","v":{"v":83,"d":"83.0"}},null,{"$f":"100-O16","v":{"v":100,"d":"100.0"}}]
[null,"TOTAL",null,null,{"$f":"SUM(E16:E17)","v":{"v":100,"d":"100.0"}},null,{"$f":"SUM(G16:G17)","v":{"v":100,"d":"100.0"}},null,{"$f":"SUM(I16:I17)","v":{"v":100,"d":"100.0"}},null,{"$f":"SUM(K16:K17)","v":{"v":100,"d":"100.0"}},null,{"$f":"SUM(M16:M17)","v":{"v":100,"d":"100.0"}},null,{"$f":"SUM(O16:O17)","v":{"v":100,"d":"100.0"}},{"$nulls":10},"b Stop signs present on minor road approaches only."]
[null,"Note:  HSM-Provided values based on HSIS data for California (2002-2006)"]
[]
[null,"Table 10-6: Default Distribution for Collision Type and Manner of Collision at Rural Two-Way Intersections plus Locally-Derived Values",{"$nulls":22},"Table 10-14: CMF for Installation of Right-Turn Lanes on Intersection Approaches (CMF3i)"]
[]
[null,"Collision type",null,null,"Percentage of total crashes by collision type ( HSM Default Values)",{"$nulls":8},"Percentage of total crashes by collision type (Locally Derived Values)",{"$nulls":10},"Intersection type",null,"Intersection traffic control",null,"Number of approaches with left-turn lanes a"]
[{"$nulls":4},"Three-leg stop-controlled intersections",null,null,"Four-leg stop-controlled intersections",null,null,"Four-leg signalized intersections",null,null,"Three-leg stop-controlled intersections",null,null,"Four-leg stop-controlled intersections",null,null,"Four-leg signalized intersections"]
[{"$nulls":28},1,2,3,4]
[{"$nulls":4},"Fatal and Injury","Property damage only","Total","Fatal and injury","Property damage only","Total","Fatal and injury","Property damage only","Total","Fatal and Injury","Property damage only","Total","Fatal and injury","Property damage only","Total","Fatal and injury","Property damage only","Total"]
[null,"Locally-Derived Values?",null,"No",{"$nulls":20},"Three-leg intersection",null,"Minor road stop control b",null,0.86,0.74,0.74,0.74]
[null,"SINGLE-VEHICLE CRASHES",{"$nulls":11},"SINGLE-VEHICLE CRASHES"]
[null,"Collision with animal",null,null,0.8,2.6,1.9,0.6,1.4,{"v":1,"d":"1.0"},{"v":0,"d":"0.0"},0.3,0.2,null,null,{"v":1,"d":"1.0"},null,null,{"v":1,"d":"1.0"},null,null,{"v":1,"d":"1.0"},null,null,"Four-leg intersection",null,"Minor road stop control b",null,0.86,0.74,0.74,0.74]
[null,"Collision with bicycle",null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,null,null,0.1,null,null,0.1,null,null,0.1]
[null,"Collision with pedestrian",null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,null,null,0.2,null,null,0.2,null,null,0.2,{"$nulls":4},"Traffic signal",null,0.96,0.92,0.88,0.85]
[null,"Overturned",null,null,2.2,0.7,1.3,0.6,0.4,0.5,0.3,0.3,0.3,null,null,0.3,null,null,0.3,null,null,0.3,null,null,"Note:","a Stop-controlled approaches are not considered in determing the number of approaches with right-turn lanes"]
[null,"Ran off road",null,null,{"v":24,"d":"24.0"},24.7,24.4,9.4,14.4,12.2,3.2,8.1,6.4,null,null,{"v":11,"d":"11.0"},null,null,{"v":11,"d":"11.0"},null,null,{"v":11,"d":"11.0"}]
[null,"Other single-vehicle crash",null,null,1.1,{"v":2,"d":"2.0"},1.6,0.4,{"v":1,"d":"1.0"},0.8,0.3,1.8,0.5,null,null,1.7,null,null,1.7,null,null,1.7,{"$nulls":3},"b Stop signs present on minor road approaches only."]
[null,"Total single-vehicle crashes",null,null,{"$f":"SUM(E29:E34)","v":28.3},30.2,29.4,{"v":11.200000000000001,"d":"11.2"},17.4,14.7,{"v":4,"d":"4.0"},{"v":10.700000000000001,"d":"10.7"},{"v":7.6000000000000005,"d":"7.6"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":14.299999999999999,"d":"14.3"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":14.299999999999999,"d":"14.3"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":14.299999999999999,"d":"14.3"}]
[null,"MULTIPLE-VEHICLE CRASHES",{"$nulls":11},"MULTIPLE-VEHICLE CRASHES"]
[null,"Angle collision",null,null,27.5,{"v":21,"d":"21.0"},23.7,53.2,35.4,43.1,33.6,24.2,27.4,null,null,{"v":43,"d":"43.0"},null,null,{"v":43,"d":"43.0"},null,null,{"v":43,"d":"43.0"}]
[null,"Head-on collision",null,null,8.1,3.2,5.2,{"v":6,"d":"6.0"},2.5,{"v":4,"d":"4.0"},{"v":8,"d":"8.0"},{"v":4,"d":"4.0"},5.4,null,null,7.7,null,null,7.7,null,null,7.7]
[null,"Rear-end collision",null,null,{"v":26,"d":"26.0"},29.2,27.8,{"v":21,"d":"21.0"},26.6,24.2,40.3,43.8,42.6,null,null,{"v":23,"d":"23.0"},null,null,{"v":23,"d":"23.0"},null,null,{"v":23,"d":"23.0"}]
[null,"Sideswipe collision",null,null,5.1,13.1,9.7,4.4,14.4,10.1,5.1,15.3,11.8,null,null,{"v":9,"d":"9.0"},null,null,{"v":9,"d":"9.0"},null,null,{"v":9,"d":"9.0"}]
[null,"Other multiple-vehicle collision",null,null,{"v":5,"d":"5.0"},3.3,4.2,4.2,3.7,3.9,{"v":9,"d":"9.0"},{"v":2,"d":"2.0"},5.2,null,null,{"v":3,"d":"3.0"},null,null,{"v":3,"d":"3.0"},null,null,{"v":3,"d":"3.0"}]
[null,"Total multiple-vehicle crashes",null,null,{"$f":"SUM(E37:E41)","v":71.7},69.8,{"v":70.60000000000001,"d":"70.6"},{"v":88.80000000000001,"d":"88.8"},{"v":82.60000000000001,"d":"82.6"},85.3,{"v":96,"d":"96.0"},89.3,92.4,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},85.7,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},85.7,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},85.7]
[null,"TOTAL CRASHES",null,null,{"$f":"+E35+E42","v":{"v":100,"d":"100.0"}},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100.00000000000001,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":100,"d":"100.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":100,"d":"100.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":100,"d":"100.0"}]
[null,"Note:  HSM-Provided values based on HSIS data for California (2002-2006)"]
[]
[null,"Table 10-15: Nighttime Crash Proportions for Unlighted Intersections"]
[]
[null,"Intersection Type",null,null,"Proportion of crashes that occur at night, pni"]
[null,"Locally-Derived Values?",null,"No","HSM Provided Values",null,"Locally-Derived Values"]
[null,"3ST",null,null,{"v":0.26,"d":"0.260"},null,{"v":0.3,"d":"0.300"}]
[null,"4ST",null,null,0.244,null,{"v":0.3,"d":"0.300"}]
[null,"4SG",null,null,0.286,null,{"v":0.3,"d":"0.300"}]
[null,"Note:  HSM-Provided values based on HSIS data for California (2002-2006)"]

{"sheet":"Construction - Do Not Delete","index":11,"n_rows":47,"n_cols":12,"rows_kept":47,"hidden":true}
[]
[]
[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]
[{"$nulls":3},7]
[{"$nulls":3},8]
[]
[]
[{"$nulls":7},"Centerline",null,"Passing",null,"Local"]
[{"$nulls":3},"Shoulder Type",null,"Spiral",null,"Rumble Strips",null,"Lane",null,"Yes"]
[{"$nulls":3},"Paved",null,"Not Present",null,"Not Present",null,"Not Present",null,"No"]
[{"$nulls":3},"Gravel",null,"Present",null,"Present",null,"Present (1 lane)"]
[{"$nulls":3},"Composite",null,"One End Only",{"$nulls":3},"Present (2 lanes)"]
[{"$nulls":3},"Turf"]
[]
[{"$nulls":5},"TWLTL",null,"Lighting",null,"SpEnforce"]
[{"$nulls":5},"Not Present",null,"Not Present",null,"Not Present"]
[{"$nulls":5},"Present",null,"Present",null,"Present"]
[]
[]
[]
[{"$nulls":3},"Itype",null,"Lapproach",null,"Rapproach",null,"Ilight",null,"Differ"]
[{"$nulls":3},"3ST",null,0,null,0,null,"Not Present",null,"Yes"]
[{"$nulls":3},"4ST",null,1,null,1,null,"Present",null,"No"]
[{"$nulls":3},"4SG",null,2,null,2]
[{"$nulls":5},3,null,3]
[{"$nulls":5},4,null,4]
[]
[]
[{"$nulls":3},"Mwidth",null,"Division",null,"Sslope",null,"Shld2",null,"Iapproach"]
[{"$nulls":3},10,null,"Divided",null,"1:2 or Steeper",null,0,null,0]
[{"$nulls":3},20,null,"Undivided",null,"1:4",null,1,null,1]
[{"$nulls":3},30,{"$nulls":3},"1:5",null,2,null,2]
[{"$nulls":3},40,{"$nulls":3},"1:6",null,3]
[{"$nulls":3},50,{"$nulls":3},"1:7 or Flatter",null,4]
[{"$nulls":3},60,{"$nulls":5},5]
[{"$nulls":3},70,{"$nulls":5},6]
[{"$nulls":3},80,{"$nulls":5},7]
[{"$nulls":3},90,{"$nulls":5},8]
[{"$nulls":3},100,{"$nulls":5},9]
[{"$nulls":9},10]