{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Project Information","Report","Urban Site Total","Intersection Tables","Segment Tables","Segment Template","Intersection Template","Multi-Year Template","Multi-Year Summary","Multi-Year Analysis Report","Construction - do not delete"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":47,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Project Information","index":1,"n_rows":29,"n_cols":38,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,10,0,21],[3,1,3,2],[2,1,2,2],[11,1,11,2],[10,1,10,2],[6,1,6,2],[5,1,5,2],[4,1,4,2],[18,0,18,7],[16,0,16,7],[0,0,0,7],[1,0,1,7],[12,4,15,4],[13,6,13,7],[14,1,15,1],[14,2,15,2],[14,5,15,5],[13,1,13,2],[13,0,15,0],[13,3,15,3],[14,6,15,6],[14,7,15,7],[12,5,12,7],[12,0,12,3]]}
["PROJECT SAFETY PERFORMANCE ANALYSIS INPUT SHEET",null,null,null,null,null,null,null,null,null,"User Work Space"]
["General Information"]
["Project Name","Practical Case Study",null,"Contact Email",null,"email"]
["Project Description","Three Signalized Intersections",null,"Contact Phone",null,1234567891]
["Reference Number","STARS Report A-1",null,"Date Performed",null,"2011-05-12"]
["Analyst","John Smith",null,"Analysis Year",null,2011]
["Agency/Company","ABC Company",null,"Multiple Year Analysis?"]
[]
[]
[]
["# of Segments in Analysis",1,null,"Predicted/expected crashes"]
["# of Intersections in Analysis",1]
[null,null,null,null,"ANALYSIS YEAR"]
["INDIVIDUAL PROJECT ELEMENTS","LOCATION INFORMATION",null,"JURISDICTION",null,"INTERSECTIONS ONLY","DETERMINING FOR PROJECT ELEMENT:"]
[null,"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"]
[null,null,null,null,null,null,"Yes","Yes"]
["INTERSECTIONS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Year"]

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

{"sheet":"Urban Site Total","index":3,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[44,4,44,5],[40,6,40,7],[2,1,3,11],[7,6,9,6],[5,9,5,11],[5,6,6,8],[6,9,9,9],[8,10,9,10],[7,7,9,7],[7,8,9,8],[8,11,9,11],[6,11,7,11],[6,10,7,10],[4,1,4,2],[22,1,22,2],[5,3,6,5],[45,0,46,3],[39,6,39,7],[40,0,40,3],[45,4,45,5],[42,4,42,5],[46,4,46,5],[44,6,44,7],[46,6,46,7],[43,6,43,7],[45,6,45,7],[42,6,42,7],[41,6,41,7],[43,0,44,3],[41,0,42,3],[41,4,41,5],[43,4,43,5],[7,3,9,3],[7,5,9,5],[23,1,23,2],[24,1,24,2],[25,1,25,2],[7,4,9,4],[5,1,9,2],[46,12,46,13],[40,8,40,9],[39,8,39,9],[39,12,39,13],[42,8,42,9],[43,10,43,11],[44,10,44,11],[45,10,45,11],[46,10,46,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[41,12,41,13],[44,8,44,9],[46,8,46,9],[43,8,43,9],[45,8,45,9],[45,12,45,13],[43,12,43,13],[42,12,42,13],[44,12,44,13],[26,1,27,4],[28,1,28,2],[29,1,29,2],[40,12,40,13],[41,8,41,9],[39,0,39,3],[39,4,39,5],[40,4,40,5],[37,1,38,13],[36,1,36,2],[35,1,35,2]]}
[]
[]
[null,"Worksheet 3A -- Predicted Crashes by Severity and Site Type and Observed Crashes Using the Site-Specific EB Method for Urban and Suburban Arterials"]
[]
[null,"(1)",null,"(2)","(3)","(4)","(5)","(5a)","(5b)","(6)","(7)","(8)"]
[null,"Collision type / Site type",null,"Predicted average crash frequency (crashes/year)",null,null,"Observed crashes,   Nobserved (crashes/year)",null,null,"Total Crashes"]
[null,null,null,null,null,null,null,null,null,"Overdispersion Parameter, k","Weighted adjustment, w","Expected average crash frequency, Nexpected"]
[null,null,null,"N predicted (TOTAL)"," N predicted      (FI)"," N predicted    (PDO)","KABCO","KABC","PDO"]
[null,null,null,null,null,null,null,null,null,null,"Equation A-5 from Part C Appendix","Equation   A-4 from Part C Appendix"]
[]
[null,"ROADWAY SEGMENTS"]
[null,"Multiple-vehicle nondriveway"]
[]
[null,"Single-vehicle (Seg)"]
[]
[null,"Multiple-vehicle driveway-related"]
[]
[null,"INTERSECTIONS"]
[null,"Multiple-vehicle (Intx)"]
[]
[null,"Single-vehicle (Intx)"]
[]
[null,"COMBINED (sum of column)"]
[]
[]
[]
[null,"Worksheet 3B -- Predicted Pedestrian and Bicycle Crashes for Urban and Suburban Arterials"]
[]
[null,"(1)",null,"(2)","(3)"]
[null,"Site Type",null,"Nped","Nbicycle"]
[null,"ROADWAY SEGMENTS"]
[]
[null,"INTERSECTIONS"]
[]
[null,"COMBINED (sum of column)"]
[]
[]
["Worksheet 3C -- Site-Specific EB Method Summary Results for Urban and Suburban Arterials","Worksheet 3C -- Site-Specific EB Method Summary Results for Urban and Suburban Arterials"]
[]
["(1)",null,null,null,"(2)",null,"(3)",null,"(4)",null,"(6)",null,"(5)"]
["Crash severity level",null,null,null,"N predicted(SV+MV)",null,"N predicted(ped)",null,"N predicted(bicycle)",null,"N predicted(PROJECT)",null,"N expected (PROJECT)"]
["Total",null,null,null,"(2)COMB from Worksheet 3A",null,"(2)COMB from Worksheet 3B",null,"(3)COMB from Worksheet 3B",null,"(2)+(3)+(4)",null,"(8)COMB Worksheet 3A + (3) + (4)"]
[null,null,null,null,{"$f":"+D23","v":0},null,{"$f":"+D35","v":0},null,{"$f":"+E35","v":0},null,{"$f":"+SUM(E43:J43)","v":0},null,{"$f":"+L23+G43+I43","v":0}]
["Fatal and injury (FI)",null,null,null,"(3)COMB from Worksheet 3A",null,"(2)COMB from Worksheet 3B",null,"(3)COMB from Worksheet 3B",null,"(2)+(3)+(4)",null,"(5)TOTAL * (2)FI / (2) TOTAL"]
[null,null,null,null,{"$f":"+E23","v":0},null,{"$f":"+D35","v":0},null,{"$f":"+E35","v":0},null,{"$f":"+SUM(E45:J45)","v":0},null,{"$f":"+IF(M43>0,(+M43*K45/K43),0)","v":0}]
["Property damage only (PDO)",null,null,null,"(4)COMB from Worksheet 3A",null,"--",null,"--",null,"(2)+(3)+(4)",null,"(5)TOTAL * (2)PDO / (2) TOTAL"]
[null,null,null,null,{"$f":"+F23","v":0},null,0,null,0,null,{"$f":"+SUM(E47:J47)","v":0},null,{"$f":"+IF(M43>0,(+M43*K47/K43),0)","v":0}]

{"sheet":"Intersection Tables","index":4,"n_rows":87,"n_cols":31,"rows_kept":87,"cut":false,"hidden":true,"merged":[[2,24,3,30],[12,24,12,30],[13,24,13,30],[17,24,18,30],[19,24,22,24],[19,25,22,26],[19,27,20,30],[21,27,22,27],[21,28,22,28],[21,29,22,29],[4,24,7,24],[4,25,7,26],[6,27,7,27],[6,28,7,28],[6,29,7,29],[6,30,7,30],[4,27,5,30],[21,30,22,30],[23,25,23,26],[24,25,24,26],[25,25,25,26],[26,25,26,26],[8,25,8,26],[9,25,9,26],[10,25,10,26],[11,25,11,26],[83,1,83,2],[27,24,27,30],[28,24,28,30],[69,1,69,2],[70,1,70,2],[71,1,71,2],[72,1,72,2],[74,1,74,2],[78,1,79,6],[73,1,73,2],[53,1,54,10],[66,1,68,2],[66,3,66,10],[67,3,67,4],[67,5,67,6],[67,7,67,8],[32,3,32,10],[33,3,33,10],[42,3,42,10],[41,1,41,10],[32,1,33,1],[32,2,33,2],[85,3,85,4],[81,3,82,4],[81,5,82,6],[83,5,83,6],[84,5,84,6],[85,5,85,6],[84,1,84,2],[85,1,85,2],[80,3,80,6],[80,1,81,1],[80,2,81,2],[82,1,82,2],[83,3,83,4],[84,3,84,4],[57,7,57,8],[57,9,57,10],[59,1,59,2],[46,1,46,2],[43,3,43,4],[43,7,43,8],[43,9,43,10],[56,3,56,10],[49,1,49,2],[55,1,56,1],[55,2,56,2],[45,1,45,2],[55,3,55,10],[67,9,67,10],[60,1,60,2],[61,1,61,2],[62,1,62,2],[64,1,64,2],[65,1,65,10],[2,15,3,21],[4,15,6,15],[4,21,6,21],[7,15,7,21],[2,8,3,12],[4,8,6,8],[4,12,6,12],[2,1,3,5],[4,1,6,1],[4,5,6,5],[7,1,7,5],[12,1,12,5],[17,1,17,5],[30,1,31,10],[63,1,63,2],[57,1,58,2],[57,3,57,4],[57,5,57,6],[86,1,86,2],[86,3,86,4],[86,5,86,6],[7,8,7,12],[12,8,12,12],[17,8,17,12],[48,1,48,2],[24,8,24,12],[23,8,23,12],[44,11,44,12],[34,11,34,12],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[34,1,35,2],[34,3,34,4],[34,5,34,6],[34,7,34,8],[47,1,47,2],[40,1,40,2],[42,1,44,2],[34,9,34,10],[43,5,43,6]]}
[null,"Tables Affiliated with SPF Computation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
[]
[null,"Table 12-10: SPF Coefficients for Multiple-Vehicle Collisions at Intersections",null,null,null,null,null,null,"Table 12-12: SPF Coefficients for Single-Vehicle Crashes at Intersections",null,null,null,null,null,null,"Table 12-14: SPF for Vehicle-Pedestrian Collisions at Signalized Intersections",null,null,null,null,null,null,null,null,"Table 12-24: Crash Modification Factor (CMF1i) for Installation of Left-Turn Lanes on Intersection Approaches"]
[]
[null,"Intersection type","Coefficients use in Eqn. 12-21",null,null,"Overdispersion    parameter     (k)",null,null,"Intersection type","Coefficients use in Eqn. 12-24",null,null,"Overdispersion    parameter     (k)",null,null,"Intersection type","Coefficients use in Eqn. 12-29",null,null,null,null,"Overdispersion    parameter     (k)",null,null,"Intersection Type","Intersection traffic control",null,"Number of approaches with left-turn lanes a"]
[null,null,"Intercept","AADTmaj","AADTmin",null,null,null,null,"Intercept","AADTmaj","AADTmin",null,null,null,null,"Intercept","AADTtot","AADTmin/AADTmaj","PedVol","nlanesx"]
[null,null,"(a)","(b)","(c)",null,null,null,null,"(a)","(b)","(c)",null,null,null,null,"(a)","(b)","(c)","(d)","(e)",null,null,null,null,null,null," One  approach","Two approaches","Three approaches","Four approaches"]
[null,"Total crashes",null,null,null,null,null,null,"Total crashes",null,null,null,null,null,null,"Total crashes"]
[null,"3ST",-13.36,1.1100000000000001,0.41,0.8,null,null,"3ST",-6.81,0.16,0.51,1.1399999999999999,null,null,"3SG",-6.6,0.05,0.24,0.41,0.09,0.52,null,null,"3ST","Minor-road STOP controlb",null,0.67,0.45,"--","--"]
[null,"3SG",-12.13,1.1100000000000001,0.26,0.33,null,null,"3SG",-9.02,0.42,0.4,0.36,null,null,"4SG",-9.5299999999999994,0.4,0.26,0.45,0.04,0.24,null,null,"3SG","Traffic signal",null,0.93,0.86,0.8,"--"]
[null,"4ST",-8.9,0.82,0.25,0.4,null,null,"4ST",-5.33,0.33,0.12,0.65,null,null,null,null,null,null,null,null,null,null,null,"4ST","Minor-road STOP controla",null,0.73,0.53,"--","--"]
[null,"4SG",-10.99,1.07,0.23,0.39,null,null,"4SG",-10.210000000000001,0.68,0.27,0.36,null,null,null,null,null,null,null,null,null,null,null,"4SG","Traffic signal",null,0.9,0.81,0.73,0.66]
[null,"Fatal-and-injury crashes",null,null,null,null,null,null,"Fatal-and-injury crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a STOP-controlled approaches are not considered in determining the number of approaches with left-turn lanes."]
[null,"3ST",-14.01,1.1599999999999999,0.3,0.69,null,null,"3ST","--","--","--","--",null,null,null,null,null,null,null,null,null,null,null,"b Stop signs present on minor-road approaches only."]
[null,"3SG",-11.58,1.02,0.17,0.3,null,null,"3SG",-9.75,0.27,0.51,0.24]
[null,"4ST",-11.13,0.93,0.28000000000000003,0.48,null,null,"4ST","--","--","--","--"]
[null,"4SG",-13.14,1.18,0.22,0.33,null,null,"4SG",-9.25,0.43,0.28999999999999998,0.09]
[null,"Property-damage-only crashes",null,null,null,null,null,null,"Property-damage-only crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 12-26: Crash Modification Factor (CMF3i) for Installation of Right-Turn Lanes on Intersection Approaches"]
[null,"3ST",-15.38,1.2,0.51,0.77,null,null,"3ST",-8.36,0.25,0.55000000000000004,1.29]
[null,"3SG",-13.24,1.1399999999999999,0.3,0.36,null,null,"3SG",-9.08,0.45,0.33,0.53,null,null,null,null,null,null,null,null,null,null,null,"Intersection Type","Intersection traffic control",null,"Number of approaches with right-turn lanes a"]
[null,"4ST",-8.74,0.77,0.23,0.4,null,null,"4ST",-7.04,0.36,0.25,0.54]
[null,"4SG",-11.02,1.02,0.24,0.44,null,null,"4SG",-11.34,0.78,0.25,0.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null," One  approach","Two approaches","Three approaches","Four approaches"]
[null,null,null,null,null,null,null,null,"Note:  Where no models are available, Equations 12-27 is used."]
[null,null,null,null,null,null,null,null,"Equation 12-27:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3ST","Minor-road STOP controlb",null,0.86,0.74,"--","--"]
[null,null,null,null,null,null,null,null,"Nbisv(FI) = Nbisv(TOTAL) x fbisv",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3SG","Traffic signal",null,0.96,0.92,"--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4ST","Minor-road STOP controla",null,0.86,0.74,"--","--"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG","Traffic signal",null,0.96,0.92,0.88,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a STOP-controlled approaches are not considered in determining the number of approaches with right-turn lanes."]
[null,"Tables Affiliated with Crash Statistics:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b Stop signs present on minor-road approaches only."]
[]
[null,"Table 12-11: Distribution of Multiple-Vehicle Collisions for Intersections by Collision Type"]
[]
[null,"Locally-Derived Values?","No","Proportion of crashes by severity level for specific intersection types"]
[null,null,null,"HSM-Provided Values"]
[null,"Collision type",null,"3ST",null,"3SG",null,"4ST",null,"4SG"]
[null,null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
[null,"Rear-end collision",null,0.42099999999999999,0.44,0.54900000000000004,0.54600000000000004,0.33800000000000002,0.374,0.45,0.48299999999999998]
[null,"Head-on collision",null,4.4999999999999998E-2,2.3E-2,3.7999999999999999E-2,0.02,4.1000000000000002E-2,0.03,4.9000000000000002E-2,0.03]
[null,"Angle collision",null,0.34300000000000003,0.26200000000000001,0.28000000000000003,0.20399999999999999,0.44,0.33500000000000002,0.34699999999999998,0.24399999999999999]
[null,"Sideswipe",null,0.126,0.04,7.5999999999999998E-2,3.2000000000000001E-2,0.121,4.3999999999999997E-2,9.9000000000000005E-2,3.2000000000000001E-2]
[null,"Other multiple-vehicle collision",null,6.5000000000000002E-2,0.23499999999999999,5.7000000000000002E-2,0.19800000000000001,0.06,0.217,5.5E-2,0.21099999999999999]
[null,"Source: HSIS data for Washington (2002-2006)"]
[null,"Collision type",null,"Locally-Derived Values"]
[null,null,null,"3ST",null,"3SG",null,"4ST",null,"4SG"]
[null,null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
[null,"Rear-end collision",null,0.5,0.1,null,null,0.75]
[null,"Head-on collision",null,0.51,0.11,null,null,0.65]
[null,"Angle collision",null,0.52,0.12,null,null,0.55000000000000004]
[null,"Sideswipe",null,0.53,0.13,null,null,0.45]
[null,"Other multiple-vehicle collision",null,0.55000000000000004,0.15,null,null,0.25]
[null,"Note:  HSM-Provided values based on HSIS data for California (2002-2006)"]
[]
[]
[null,"Table 12-13: Distribution of Single-Vehicle Crashes for Intersections by Collision Type"]
[]
[null,"Locally-Derived Values?","No","Proportion of crashes by severity level for specific intersection types"]
[null,null,null,"HSM-Provided Values"]
[null,"Collision type",null,"3ST",null,"3SG",null,"4ST",null,"4SG"]
[null,null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
[null,"Collision with parked vehicle",null,1E-3,3.0000000000000001E-3,1E-3,1E-3,1E-3,1E-3,1E-3,1E-3]
[null,"Collision with animal",null,3.0000000000000001E-3,1.7999999999999999E-2,1E-3,3.0000000000000001E-3,1E-3,2.5999999999999999E-2,2E-3,2E-3]
[null,"Collision with fixed object",null,0.76200000000000001,0.83409999999999995,0.65300000000000002,0.89500000000000002,0.67900000000000005,0.84699999999999998,0.74399999999999999,0.87]
[null,"Collision with other object",null,0.09,9.1999999999999998E-2,9.0999999999999998E-2,6.9000000000000006E-2,8.8999999999999996E-2,7.0000000000000007E-2,7.1999999999999995E-2,7.0000000000000007E-2]
[null,"Other single-vehicle collision",null,3.9E-2,2.3E-2,4.4999999999999998E-2,1.7999999999999999E-2,5.0999999999999997E-2,7.0000000000000001E-3,0.04,2.3E-2]
[null,"Noncollision",null,0.105,0.03,0.20899999999999999,1.4E-2,0.17899999999999999,4.9000000000000002E-2,0.14099999999999999,3.4000000000000002E-2]
[null,"Source: HSM-Provided values base on HSIS data for California (2002-2006)"]
[null,"Collision type",null,"Locally-Derived Values"]
[null,null,null,"3ST",null,"3SG",null,"4ST",null,"4SG"]
[null,null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
[null,"Collision with parked vehicle",null,0.5,0.1,null,null,0.75]
[null,"Collision with animal",null,0.51,0.11,null,null,0.65]
[null,"Collision with fixed object",null,0.52,0.12,null,null,0.55000000000000004]
[null,"Collision with other object",null,0.53,0.13,null,null,0.45]
[null,"Other single-vehicle collision",null,0.54,0.14000000000000001,null,null,0.35]
[null,"Noncollision",null,0.55000000000000004,0.15,null,null,0.25]
[]
[]
[]
[null,"Table 12-27: Nighttime Crash Proportions for Unlighted Intersections"]
[]
[null,"Locally-Derived Values?","No","Proportion of crashes that occur at night, pni"]
[null,null,null,"HSM-Provided Values",null,"Locally-Derived Values"]
[null,"Intersection Type"]
[null,"3ST",null,0.23799999999999999,null,0.3]
[null,"4ST",null,0.22900000000000001,null,0.31]
[null,"3SG",null,0.23499999999999999,null,0.32]
[null,"4SG",null,0.23499999999999999,null,0.33]

{"sheet":"Segment Tables","index":5,"n_rows":128,"n_cols":27,"rows_kept":128,"cut":false,"hidden":true,"merged":[[93,0,93,1],[93,2,93,3],[93,4,93,5],[98,0,99,9],[94,0,94,1],[94,2,94,3],[94,4,94,5],[94,6,94,7],[94,8,94,9],[95,2,95,3],[95,4,95,5],[97,0,97,1],[97,2,97,3],[96,6,96,7],[96,8,96,9],[97,4,97,5],[97,6,97,7],[97,8,97,9],[95,0,95,1],[96,0,96,1],[96,2,96,3],[96,4,96,5],[92,0,92,1],[92,2,92,3],[92,4,92,5],[92,6,92,7],[90,1,91,1],[90,2,90,9],[91,2,91,5],[91,6,91,9],[92,8,92,9],[112,5,112,6],[73,0,74,9],[78,8,78,9],[79,6,79,7],[80,6,80,7],[79,8,79,9],[77,2,77,3],[123,0,123,2],[124,0,124,2],[109,5,109,6],[110,3,110,4],[108,0,108,2],[113,0,113,2],[112,0,112,2],[109,3,109,4],[117,0,118,12],[122,0,122,2],[111,5,111,6],[112,3,112,4],[122,8,122,9],[122,11,122,12],[80,0,80,1],[78,4,78,5],[80,4,80,5],[75,0,76,0],[75,1,76,1],[76,2,76,5],[46,22,46,23],[47,22,47,23],[48,22,48,23],[49,22,49,23],[50,22,50,23],[106,5,108,6],[93,6,93,7],[93,8,93,9],[82,4,82,5],[81,8,81,9],[105,0,106,2],[106,3,108,4],[78,6,78,7],[82,8,82,9],[82,0,82,1],[82,6,82,7],[82,2,82,3],[83,0,84,9],[90,0,91,0],[95,6,95,7],[95,8,95,9],[44,0,44,1],[66,0,66,1],[56,0,57,1],[56,2,56,3],[60,0,60,1],[110,0,110,2],[30,22,31,25],[77,6,77,7],[76,6,76,9],[77,8,77,9],[79,4,79,5],[77,4,77,5],[75,2,75,9],[80,8,80,9],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,6,81,7],[81,0,81,1],[81,2,81,3],[88,0,89,9],[81,4,81,5],[79,0,79,1],[33,0,33,1],[18,0,18,3],[113,3,113,4],[113,5,113,6],[37,0,37,1],[38,0,38,1],[36,0,36,1],[26,22,26,23],[24,24,24,25],[27,0,28,11],[27,24,27,25],[25,24,25,25],[26,24,26,25],[24,22,24,23],[25,22,25,23],[27,22,27,23],[28,22,29,25],[35,22,38,24],[39,22,39,23],[40,22,40,23],[41,22,41,23],[42,22,42,23],[43,22,43,23],[44,22,44,23],[45,22,45,23],[13,13,13,19],[12,0,12,3],[11,13,11,14],[12,13,12,14],[19,22,19,23],[41,6,41,7],[41,8,41,9],[3,13,4,14],[3,15,3,19],[9,13,9,14],[10,13,10,14],[12,6,12,9],[8,13,8,14],[6,13,6,14],[7,13,7,14],[17,22,18,25],[18,6,18,9],[30,2,30,11],[31,4,31,5],[15,13,15,19],[17,13,17,19],[19,13,19,19],[14,13,14,14],[16,13,16,14],[1,22,2,26],[6,6,6,9],[1,13,2,19],[5,13,5,19],[6,0,6,3],[3,23,3,26],[3,22,7,22],[5,24,7,24],[5,23,7,23],[4,23,4,24],[1,0,2,3],[3,3,5,3],[3,0,5,0],[5,26,7,26],[4,25,4,26],[5,25,7,25],[1,6,2,9],[3,6,5,6],[3,9,5,9],[41,4,41,5],[40,2,40,11],[41,2,41,3],[19,24,19,25],[20,22,20,23],[20,24,20,25],[43,0,43,1],[31,10,31,11],[29,0,30,0],[29,1,30,1],[29,2,29,11],[31,6,31,7],[31,8,31,9],[31,0,32,1],[31,2,31,3],[34,0,34,1],[35,0,35,1],[21,22,21,23],[22,22,22,23],[21,24,21,25],[22,24,22,25],[23,24,23,25],[23,22,23,23],[21,13,22,19],[127,3,127,4],[126,8,126,9],[125,8,125,9],[119,0,120,2],[121,0,121,1],[122,3,122,4],[120,3,121,5],[119,8,119,12],[120,6,121,7],[122,6,122,7],[119,3,119,7],[125,3,125,4],[127,11,127,12],[123,6,123,7],[124,6,124,7],[123,8,123,9],[124,8,124,9],[127,8,127,9],[126,6,126,7],[127,6,127,7],[125,6,125,7],[126,3,126,4],[120,8,121,10],[120,11,121,12],[126,11,126,12],[111,0,111,2],[111,3,111,4],[77,0,77,1],[78,0,78,1],[56,6,56,7],[67,0,67,1],[68,0,68,1],[110,5,110,6],[103,0,104,6],[109,0,109,2],[105,3,105,4],[107,0,107,1],[105,5,105,6],[69,0,69,1],[63,0,65,1],[63,2,63,11],[64,2,64,3],[64,4,64,5],[64,6,64,7],[58,0,58,1],[59,0,59,1],[56,4,56,5],[125,0,125,2],[18,13,18,14],[20,13,20,14],[64,10,64,11],[126,0,126,2],[127,0,127,2],[123,3,123,4],[124,3,124,4],[47,0,47,1],[48,0,48,1],[41,10,41,11],[123,11,123,12],[124,11,124,12],[125,11,125,12],[45,0,45,1],[46,0,46,1],[40,0,42,1],[64,8,64,9],[56,8,56,9],[56,10,56,11],[52,0,53,11],[54,0,55,0],[54,1,55,1],[54,2,54,11],[55,2,55,11]]}
["Tables Affiliated with SPF Computation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
["Table 12-3: SPF Coefficients for Multiple-Vehicle Nondriveway Collisions on Roadway Segments",null,null,null,null,null,"Table 12-5: SPF Coefficients for Single-Vehicle Collisions on Roadway Segments",null,null,null,null,null,null,"Table 12-7: SPF Coefficients for Multiple-Vehicle Driveway Related Collisions",null,null,null,null,null,null,null,null,"Table 12-19: Values of fpk Used in Determing the CMF for On-Street Parking"]
[]
["Road type","Coefficients use in Eqn. 12-10",null,"Overdispersion    parameter     (k)",null,null,"Road type","Coefficients use in Eqn. 12-11",null,"Overdispersion    parameter     (k)",null,null,null,"Driveway type (j)",null,"Coefficients for specific roadway types",null,null,null,null,null,null,"Road Type","Type of Parking and Land Use"]
[null,"Intercept","AADT",null,null,null,null,"Intercept","AADT",null,null,null,null,null,null,"2U","3T","4U","4D","5T",null,null,null,"Parallel Parking",null,"Angle Parking"]
[null,"(a)","(b)",null,null,null,null,"(a)","(b)",null,null,null,null,"Number of driveway-related collisions per driveway per year (Nj)",null,null,null,null,null,null,null,null,null,"Residential/  Other","Commercial or Industrial/ Institutional","Residential/  Other","Commercial or Industrial/ Institutional"]
["Total crashes",null,null,null,null,null,"Total crashes",null,null,null,null,null,null,"Major commercial",null,0.158,0.10199999999999999,0.182,3.3000000000000002E-2,0.16500000000000001]
["2U",-15.22,1.68,0.84,null,null,"2U",-5.47,0.56000000000000005,0.81,null,null,null,"Minor commercial",null,0.05,3.2000000000000001E-2,5.8000000000000003E-2,1.0999999999999999E-2,5.2999999999999999E-2]
["3T",-12.4,1.41,0.66,null,null,"3T",-5.74,0.54,1.37,null,null,null,"Major industrial / industrial",null,0.17199999999999999,0.11,0.19800000000000001,3.5999999999999997E-2,0.18099999999999999,null,null,"2U",1.4650000000000001,2.0739999999999998,3.4279999999999999,4.8529999999999998]
["4U",-11.63,1.33,1.01,null,null,"4U",-7.99,0.81,0.91,null,null,null,"Minor industrial / institutional",null,2.3E-2,1.4999999999999999E-2,2.5999999999999999E-2,5.0000000000000001E-3,2.4E-2,null,null,"3T",1.4650000000000001,2.0739999999999998,3.4279999999999999,4.8529999999999998]
["4D",-12.34,1.36,1.32,null,null,"4D",-5.05,0.47,0.86,null,null,null,"Major residential",null,8.3000000000000004E-2,5.2999999999999999E-2,9.6000000000000002E-2,1.7999999999999999E-2,8.6999999999999994E-2,null,null,"4U",1.1000000000000001,1.7090000000000001,2.5739999999999998,3.9990000000000001]
["5T",-9.6999999999999993,1.17,0.81,null,null,"5T",-4.82,0.54,0.52,null,null,null,"Minor residential",null,1.6E-2,0.01,1.7999999999999999E-2,3.0000000000000001E-3,1.6E-2,null,null,"4D",1.1000000000000001,1.7090000000000001,2.5739999999999998,3.9990000000000001]
["Fatal-and-injury crashes",null,null,null,null,null,"Fatal-and-injury crashes",null,null,null,null,null,null,"Other",null,2.5000000000000001E-2,1.6E-2,2.9000000000000001E-2,5.0000000000000001E-3,2.7E-2,null,null,"5T",1.1000000000000001,1.7090000000000001,2.5739999999999998,3.9990000000000001]
["2U",-16.22,1.66,0.65,null,null,"2U",-3.96,0.23,0.5,null,null,null,"Regression coefficient for AADT (t)"]
["3T",-16.45,1.69,0.59,null,null,"3T",-6.37,0.47,1.06,null,null,null,"All driveways",null,1,1,1.1719999999999999,1.1060000000000001,1.1719999999999999]
["4U",-12.08,1.25,0.99,null,null,"4U",-7.37,0.61,0.54,null,null,null,"Overdispersion parameter (k)"]
["4D",-12.76,1.28,1.31,null,null,"4D",-8.7100000000000009,0.66,0.28000000000000003,null,null,null,"All driveways",null,0.81,1.1000000000000001,0.81,1.39,0.1]
["5T",-10.47,1.1200000000000001,0.62,null,null,"5T",-4.43,0.35,0.36,null,null,null,"Proportion of fatal-and-injury crashes (fdwy)",null,null,null,null,null,null,null,null,"Table 12-20: Fixed-Object Offset Factor"]
["Property-damage-only crashes",null,null,null,null,null,"Property-damage-only crashes",null,null,null,null,null,null,"All driveways",null,0.32300000000000001,0.24299999999999999,0.34200000000000003,0.28399999999999997,0.26900000000000002]
["2U",-15.62,1.69,0.87,null,null,"2U",-6.51,0.64,0.87,null,null,null,"Proportion of property-damage-only crashes",null,null,null,null,null,null,null,null,"Offset to fixed objects",null,"Fixed-Object Offset Factor"]
["3T",-11.95,1.33,0.59,null,null,"3T",-6.29,0.56000000000000005,1.93,null,null,null,"All driveways",null,0.67700000000000005,0.75700000000000001,0.65800000000000003,0.71599999999999997,0.73099999999999998,null,null,"(Ofo) (ft)",null,"(foffset)"]
["4U",-12.53,1.38,1.08,null,null,"4U",-8.5,0.84,0.97,null,null,null,"Note: Includes only unsignalized driveways; signalized driveways are analyzed as signalized intersections. Majjor driveways serve 50 or more parking spaces; minor driveways serve less thanh 50 parking spaces.",null,null,null,null,null,null,null,null,2,null,0.23200000000000001]
["4D",-12.81,1.38,1.34,null,null,"4D",-5.04,0.45,1.06,null,null,null,null,null,null,null,null,null,null,null,null,5,null,0.13300000000000001]
["5T",-9.9700000000000006,1.17,0.88,null,null,"5T",-5.83,0.61,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,10,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,6.8000000000000005E-2]
["Tables Affiliated with Crash Statistics:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,5.7000000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,4.9000000000000002E-2]
["Table 12-4: Distribution of Multiple-Vehicle Nondriveway Collisions for Roadway Segments by Manner of Collision Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"≥ 30",null,4.3999999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note:  Values from 2 to 30 can be estimated using the following equation:"]
["Locally-Derived Values?","No","Proportion of crashes by severity level for specific road types"]
[null,null,"HSM-Provided Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y=0.3566 x-0.614"]
["Collision type",null,"2U",null,"3T",null,"4U",null,"4D",null,"5T"]
[null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
["Rear-end collision",null,0.73,0.77800000000000002,0.84499999999999997,0.84199999999999997,0.51100000000000001,0.50600000000000001,0.83199999999999996,0.66200000000000003,0.84599999999999997,0.65100000000000002]
["Head-on collision",null,6.8000000000000005E-2,4.0000000000000001E-3,3.4000000000000002E-2,0.02,7.6999999999999999E-2,4.0000000000000001E-3,0.02,7.0000000000000001E-3,2.1000000000000001E-2,4.0000000000000001E-3]
["Angle collision",null,8.5000000000000006E-2,7.9000000000000001E-2,6.9000000000000006E-2,0.02,0.18099999999999999,0.13,0.04,3.5999999999999997E-2,0.05,5.8999999999999997E-2,null,null,null,null,null,null,null,null,null,null,"Table 12-22: CMFs for Median Widths on Divided Roadway Segments without a Median Barrier (CMF3r)"]
["Sideswipe, same direction",null,1.4999999999999999E-2,3.1E-2,1E-3,7.8E-2,9.2999999999999999E-2,0.249,0.05,0.223,6.0999999999999999E-2,0.248]
["Sideswipe, opposite direction",null,7.2999999999999995E-2,5.5E-2,1.7000000000000001E-2,0.02,8.2000000000000003E-2,3.1E-2,0.01,1E-3,4.0000000000000001E-3,8.9999999999999993E-3]
["Other multiple-vehicle collision",null,2.9000000000000001E-2,5.2999999999999999E-2,3.4000000000000002E-2,0.02,5.6000000000000001E-2,0.08,4.8000000000000001E-2,7.0999999999999994E-2,1.7999999999999999E-2,2.9000000000000001E-2]
["Source: HSIS data for Washington (2002-2006)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Width (ft)",null,"CMF"]
["Collision type",null,"Locally-Derived Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.01]
[null,null,"2U",null,"3T",null,"4U",null,"4D",null,"5T",null,null,null,null,null,null,null,null,null,null,null,15,null,1]
[null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO","FI","PDO",null,null,null,null,null,null,null,null,null,null,20,null,0.99]
["Rear-end collision",null,0.5,0.1,null,null,0.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,0.98]
["Head-on collision",null,0.51,0.11,null,null,0.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,0.97]
["Angle collision",null,0.52,0.12,null,null,0.55000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,0.96]
["Sideswipe, same direction",null,0.53,0.13,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,0.95]
["Sideswipe, opposite direction",null,0.54,0.14000000000000001,null,null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,0.94]
["Other multiple-vehicle collision",null,0.55000000000000004,0.15,null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,0.93]
["Note:  HSM-Provided values based on HSIS data for Washington (2002-2006)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,0.92]
[]
["Table 12-6: Distribution of Single-Vehicle Collisions for Roadway Segments by Collision Type"]
[]
["Locally-Derived Values?","No","Proportion of crashes by severity level for specific road types"]
[null,null,"HSM-Provided Values"]
["Collision type",null,"2U",null,"3T",null,"4U",null,"4D",null,"5T"]
[null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
["Collision with animal",null,2.5999999999999999E-2,6.6000000000000003E-2,1E-3,1E-3,1E-3,1E-3,1E-3,6.3E-2,1.6E-2,4.9000000000000002E-2]
["Collision with fixed object",null,0.72299999999999998,0.75900000000000001,0.68799999999999994,0.96299999999999997,0.61199999999999999,0.80900000000000005,0.5,0.81299999999999994,0.39800000000000002,0.76800000000000002]
["Collision with other object",null,0.01,1.2999999999999999E-2,1E-3,1E-3,0.02,2.9000000000000001E-2,2.8000000000000001E-2,1.6E-2,5.0000000000000001E-3,6.0999999999999999E-2]
["Other single-vehicle collision",null,0.24099999999999999,0.16200000000000001,0.31,3.5000000000000003E-2,0.36699999999999999,0.161,0.47099999999999997,0.108,0.58099999999999996,0.122]
["Source: HSIS data for Washington (2002-2006)"]
["Collision type",null,"Locally-Derived Values"]
[null,null,"2U",null,"3T",null,"4U",null,"4D",null,"5T"]
[null,null,"FI","PDO","FI","PDO","FI","PDO","FI","PDO","FI","PDO"]
["Collision with animal",null,0.52,0.12,null,null,0.55000000000000004]
["Collision with fixed object",null,0.53,0.13,null,null,0.45]
["Collision with other object",null,0.54,0.14000000000000001,null,null,0.35]
["Other single-vehicle collision",null,0.55000000000000004,0.15,null,null,0.25]
[]
[]
[]
["Table 12-8: Pedestrian Crash Adjustment Factor for Roadway Segments"]
[]
["Locally-Derived Values?","No","Pedestrian Crash Adjustment Factor (fpedr)"]
[null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
["Road type",null,"Posted Speed 30 mph or Lower",null,"Posted Speed Greater than 30 mph",null,"Posted Speed 30 mph or Lower",null,"Posted Speed Greater than 30 mph"]
["2U",null,3.5999999999999997E-2,null,5.0000000000000001E-3,null,4.1000000000000002E-2,null,6.0999999999999999E-2]
["3T",null,4.1000000000000002E-2,null,1.2999999999999999E-2,null,4.2000000000000003E-2,null,6.2E-2]
["4U",null,2.1999999999999999E-2,null,8.9999999999999993E-3,null,4.2999999999999997E-2,null,6.3E-2]
["4D",null,6.7000000000000004E-2,null,1.9E-2,null,4.3999999999999997E-2,null,6.4000000000000001E-2]
["5T",null,0.03,null,2.3E-2,null,4.4999999999999998E-2,null,6.5000000000000002E-2]
["Note:  These factors apply to the methodology for predicting total crashes (all seerity levels combined). All pedestrian collisions resulting from this adjustment factor are treated as fatal-and-injury crashes and none as property-damage-only crashes.  Source:  HSIS data for Washington (2002-2006)"]
[]
[]
[]
[]
["Table 12-9: Bicycle Crash Adjustment Factor for Roadway Segments"]
[]
["Locally-Derived Values?","No","Bicycle Crash Adjustment Factor (fbiker)"]
[null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values"]
["Road type",null,"Posted Speed 30 mph or Lower",null,"Posted Speed Greater than 30 mph",null,"Posted Speed 30 mph or Lower",null,"Posted Speed Greater than 30 mph"]
["2U",null,1.7999999999999999E-2,null,4.0000000000000001E-3,null,2.1000000000000001E-2,null,3.1E-2]
["3T",null,2.7E-2,null,7.0000000000000001E-3,null,2.1999999999999999E-2,null,3.2000000000000001E-2]
["4U",null,1.0999999999999999E-2,null,2E-3,null,2.3E-2,null,3.3000000000000002E-2]
["4D",null,1.2999999999999999E-2,null,5.0000000000000001E-3,null,2.4E-2,null,3.4000000000000002E-2]
["5T",null,0.05,null,1.2E-2,null,2.5000000000000001E-2,null,3.5000000000000003E-2]
["Note:  These factors apply to the methodology for predicting total crashes (all seerity levels combined). All bicycle collisions resulting from this adjustment factor are treated as fatal-and-injury crashes and none as property-damage-only crashes.  Source:  HSIS data for Washington (2002-2006)"]
[]
[]
[]
[]
["Table 12-21: Proportion of Fixed-Object Collisions"]
[]
["Road Type",null,null,"HSM-Provided Values",null,"Locally-Derived Values"]
[null,null,null,"Proportion of Fixed-Object Collisions (pfo)",null,"Proportion of Fixed-Object Collisions (pfo)"]
["Locally-Derived Values?",null,"No"]
[]
["2U",null,null,5.8999999999999997E-2,null,0.05]
["3T",null,null,3.4000000000000002E-2,null,0.06]
["4U",null,null,3.6999999999999998E-2,null,7.0000000000000007E-2]
["4D",null,null,3.5999999999999997E-2,null,0.08]
["5T",null,null,1.6E-2,null,0.08]
[]
[]
[]
["Table 12-23: Nighttime Crash Proportions for Unlighted Roadway Segments"]
[]
["Road Type",null,null,"HSM-Provided Values",null,null,null,null,"Locally-Derived Values"]
[null,null,null,"Proportion of Total Nighttime Crashes by Severity Level",null,null,"Proportion of Crashes that Occur at Night",null,"Proportion of Total Nighttime Crashes by Severity Level",null,null,"Proportion of Crashes that Occur at Night"]
["Locally-Derived Values?",null,"No"]
[null,null,null,"Fatal and Injury (pinr)",null,"PDO (ppnr)","(pnr)",null,"Fatal and Injury (pinr)",null,"PDO (ppnr)","(pnr)"]
["2U",null,null,0.42399999999999999,null,0.57599999999999996,0.316,null,0.1,null,0.15,0.9]
["3T",null,null,0.42899999999999999,null,0.57099999999999995,0.30399999999999999,null,0.2,null,0.25,0.8]
["4U",null,null,0.51700000000000002,null,0.48299999999999998,0.36499999999999999,null,0.3,null,0.35,0.7]
["4D",null,null,0.36399999999999999,null,0.63600000000000001,0.41,null,0.4,null,0.45,0.6]
["5T",null,null,0.432,null,0.56799999999999995,0.27400000000000002,null,0.5,null,0.55000000000000004,0.5]

{"sheet":"Segment Template","index":6,"n_rows":206,"n_cols":38,"rows_kept":206,"cut":false,"hidden":true,"merged":[[7,14,8,14],[0,16,0,21],[0,0,1,13],[2,0,2,4],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[6,2,6,4],[3,2,3,4],[7,0,7,4],[8,0,8,4],[4,2,4,4],[5,2,5,4],[3,5,3,6],[4,5,4,6],[3,7,3,13],[4,7,4,13],[5,7,5,13],[6,7,6,13],[2,5,2,13],[7,10,7,13],[8,10,8,13],[192,10,192,12],[193,10,193,12],[194,10,194,12],[5,5,5,6],[22,5,22,9],[187,7,187,9],[6,5,6,6],[134,12,134,13],[135,12,135,13],[140,12,140,13],[29,5,29,6],[193,4,193,6],[194,4,194,6],[105,3,105,4],[105,5,105,6],[187,4,187,6],[193,1,193,3],[187,1,187,3],[32,0,33,3],[188,1,191,3],[106,0,106,2],[131,3,132,4],[129,0,132,2],[129,3,130,4],[144,6,144,7],[112,0,115,2],[116,0,116,2],[116,3,116,4],[111,0,111,2],[112,7,113,8],[111,5,111,6],[111,7,111,8],[111,3,111,4],[117,5,117,6],[118,5,118,6],[145,6,145,7],[168,0,168,4],[169,0,169,4],[109,0,110,13],[145,0,145,1],[123,12,123,13],[123,3,123,4],[128,0,128,2],[128,3,128,4],[128,5,128,6],[123,7,123,8],[128,8,128,9],[131,12,132,13],[129,5,130,6],[129,7,130,7],[129,8,130,9],[129,12,130,13],[133,8,133,9],[133,12,133,13],[134,8,134,9],[133,10,133,11],[134,10,134,11],[133,5,133,6],[133,3,133,4],[170,0,170,4],[171,0,171,4],[172,0,172,4],[173,0,173,4],[171,5,171,7],[142,12,143,13],[142,8,143,9],[135,5,135,6],[140,0,140,1],[140,2,140,3],[135,8,135,9],[135,10,135,11],[135,0,135,2],[170,11,170,13],[171,11,171,13],[172,11,172,13],[168,8,168,10],[169,8,169,10],[170,8,170,10],[172,5,172,7],[168,5,168,7],[169,5,169,7],[170,5,170,7],[150,6,150,7],[182,0,182,4],[181,5,181,7],[175,0,175,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,0,120,2],[120,3,120,4],[121,3,121,4],[117,0,117,2],[118,0,118,2],[119,0,119,2],[119,5,119,6],[120,5,120,6],[121,5,121,6],[121,0,121,2],[122,5,122,6],[123,5,123,6],[144,0,144,1],[142,6,143,7],[140,4,140,5],[140,6,140,7],[134,0,134,2],[133,0,133,2],[118,7,118,8],[119,7,119,8],[120,7,120,8],[121,7,121,8],[117,9,117,11],[119,9,119,11],[120,9,120,11],[122,7,122,8],[122,9,122,11],[112,9,113,11],[116,7,116,8],[116,5,116,6],[115,9,115,11],[114,7,115,8],[114,5,115,6],[114,9,114,11],[112,3,115,4],[116,9,116,11],[112,5,113,6],[106,7,106,8],[106,9,106,10],[106,11,106,13],[105,7,105,8],[105,9,105,10],[102,0,102,2],[102,3,102,4],[102,5,102,6],[102,7,102,8],[102,9,102,10],[102,11,102,13],[103,11,103,13],[105,11,105,13],[106,3,106,4],[106,5,106,6],[103,0,103,2],[103,3,103,4],[103,5,103,6],[104,0,104,2],[104,3,104,4],[104,5,104,6],[104,7,104,8],[101,0,101,2],[101,3,101,4],[101,5,101,6],[96,0,100,2],[99,5,100,6],[96,3,98,4],[104,9,104,10],[104,11,104,13],[105,0,105,2],[99,11,100,13],[101,7,101,8],[101,11,101,13],[55,13,56,13],[55,12,56,12],[50,13,51,13],[52,13,53,13],[54,6,54,7],[55,6,56,7],[55,11,56,11],[55,8,55,9],[46,2,46,4],[52,2,52,3],[50,4,51,5],[50,11,51,11],[52,11,53,11],[49,8,49,9],[52,4,53,5],[52,6,53,7],[52,10,53,10],[50,6,51,7],[50,8,53,9],[50,12,53,12],[50,10,51,10],[55,10,56,10],[23,10,23,13],[24,10,24,13],[25,10,25,13],[26,10,26,13],[24,5,24,9],[23,5,23,9],[49,6,49,7],[44,12,44,13],[40,9,41,11],[40,5,41,6],[44,7,44,8],[44,9,44,11],[44,5,44,6],[42,12,42,13],[43,12,43,13],[32,5,32,6],[33,5,33,6],[39,12,39,13],[40,12,41,13],[30,5,30,6],[31,5,31,6],[27,0,27,13],[28,0,29,3],[28,5,28,6],[39,2,39,4],[39,5,39,6],[43,0,43,1],[43,2,43,4],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,11],[43,9,43,11],[43,5,43,6],[43,7,43,8],[39,7,39,8],[40,7,41,8],[9,10,9,13],[10,10,10,13],[12,5,12,9],[11,5,11,9],[11,0,11,4],[12,0,12,4],[11,10,11,13],[12,10,12,13],[9,0,9,4],[15,5,15,9],[13,5,13,9],[14,5,14,9],[17,5,17,9],[18,5,18,9],[19,5,19,9],[7,5,7,9],[9,5,9,9],[8,5,8,9],[10,5,10,9],[57,2,58,2],[57,3,58,3],[57,4,58,5],[21,5,21,9],[16,5,16,9],[20,5,20,9],[44,2,44,4],[30,0,31,3],[63,9,63,10],[50,2,51,3],[54,8,54,9],[56,8,56,9],[55,2,56,2],[55,3,56,3],[54,0,54,1],[55,0,56,1],[63,3,63,4],[55,4,56,5],[54,4,54,5],[57,0,58,1],[40,0,41,1],[40,2,41,4],[39,9,39,11],[39,0,39,1],[57,12,58,12],[57,13,58,13],[57,8,57,9],[57,6,58,7],[57,10,58,10],[57,11,58,11],[86,6,86,7],[86,8,86,9],[81,6,81,7],[84,6,85,7],[75,7,75,8],[75,9,75,10],[76,9,76,10],[63,5,63,6],[75,11,75,13],[76,7,76,8],[63,7,63,8],[72,11,72,13],[73,11,73,13],[74,11,74,13],[74,9,74,10],[72,9,72,10],[73,9,73,10],[72,7,72,8],[95,0,95,2],[95,3,95,4],[76,3,76,4],[79,0,80,13],[93,0,94,13],[87,0,88,1],[82,12,85,12],[89,11,90,11],[82,11,83,11],[90,8,90,9],[82,8,85,9],[87,6,88,7],[81,8,81,9],[84,11,85,11],[84,13,85,13],[87,8,87,9],[87,10,88,10],[89,0,90,1],[89,2,90,2],[89,3,90,3],[89,4,90,5],[89,6,90,7],[89,8,89,9],[95,5,95,6],[64,7,66,8],[64,9,66,10],[67,7,68,8],[67,9,68,10],[75,0,75,2],[76,0,76,2],[87,2,88,2],[75,5,75,6],[76,5,76,6],[87,3,88,3],[87,4,88,5],[67,5,68,6],[64,5,66,6],[64,3,66,4],[67,3,68,4],[74,5,74,6],[50,0,53,1],[49,2,49,3],[70,3,70,4],[71,0,71,2],[70,0,70,2],[63,0,63,2],[61,0,62,13],[63,11,63,13],[64,11,66,13],[67,11,68,13],[69,11,69,13],[70,9,70,10],[70,11,70,13],[71,9,71,10],[71,11,71,13],[70,7,70,8],[71,7,71,8],[69,3,69,4],[69,7,69,8],[69,0,69,2],[69,5,69,6],[69,9,69,10],[64,0,68,2],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[58,8,58,9],[74,0,74,2],[72,0,72,2],[99,3,100,4],[49,0,49,1],[49,4,49,5],[73,0,73,2],[86,0,86,1],[86,4,86,5],[82,0,85,1],[82,2,83,3],[82,4,83,5],[81,2,81,3],[81,4,81,5],[84,2,84,3],[84,4,85,5],[81,0,81,1],[71,5,71,6],[72,5,72,6],[73,5,73,6],[76,11,76,13],[112,12,113,13],[101,9,101,10],[99,7,100,8],[103,7,103,8],[111,12,111,13],[89,12,90,12],[89,13,90,13],[95,11,95,13],[87,13,88,13],[88,8,88,9],[82,6,83,7],[96,7,98,8],[96,9,98,10],[96,11,98,13],[82,13,83,13],[82,10,83,10],[96,5,98,6],[87,11,88,11],[87,12,88,12],[84,10,85,10],[95,7,95,8],[95,9,95,10],[89,10,90,10],[168,11,168,13],[182,8,182,10],[175,5,175,7],[176,5,176,7],[177,5,177,7],[178,5,178,7],[181,0,181,4],[161,8,161,10],[114,12,115,13],[128,10,128,11],[131,7,132,7],[131,8,132,9],[129,10,132,11],[131,5,132,6],[126,0,127,13],[128,12,128,13],[123,9,123,11],[122,0,122,2],[122,3,122,4],[123,0,123,2],[116,12,122,13],[118,9,118,11],[121,9,121,11],[117,7,117,8],[99,9,100,10],[182,5,182,7],[179,11,179,13],[180,11,180,13],[175,11,175,13],[176,11,176,13],[177,11,177,13],[164,11,164,13],[173,11,173,13],[160,5,160,7],[178,11,178,13],[175,8,175,10],[176,8,176,10],[177,8,177,10],[178,8,178,10],[164,5,164,7],[162,8,162,10],[163,8,164,10],[162,11,162,13],[181,11,181,13],[182,11,182,13],[171,8,171,10],[172,8,172,10],[173,5,173,7],[180,0,180,4],[179,0,179,4],[179,5,179,7],[169,11,169,13],[26,5,26,9],[33,7,33,8],[32,7,32,8],[145,8,145,9],[140,8,140,9],[134,5,134,6],[37,0,38,13],[47,0,48,13],[42,0,42,1],[141,8,141,9],[141,11,143,11],[134,3,134,4],[135,3,135,4],[141,4,141,5],[142,4,143,5],[141,2,141,3],[103,9,103,10],[142,10,143,10],[111,9,111,11],[73,7,73,8],[160,8,160,10],[160,11,160,13],[154,12,154,13],[151,11,153,11],[179,8,179,10],[181,8,181,10],[180,8,180,10],[180,5,180,7],[167,11,167,13],[162,5,162,7],[163,5,163,7],[166,8,166,10],[167,8,167,10],[166,5,166,7],[173,8,173,10],[174,0,174,13],[165,0,165,13],[167,0,167,4],[166,11,166,13],[161,0,164,4],[167,5,167,7],[176,0,176,4],[177,0,177,4],[178,0,178,4],[13,10,13,13],[14,10,14,13],[15,10,15,13],[16,10,16,13],[154,4,154,5],[154,8,154,9],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[154,0,154,1],[154,2,154,3],[17,10,17,13],[18,10,18,13],[19,10,19,13],[20,10,20,13],[21,10,21,13],[22,10,22,13],[25,5,25,9],[150,8,150,9],[150,12,150,13],[144,2,144,3],[145,2,145,3],[154,6,154,7],[44,0,44,1],[142,2,143,3],[138,0,139,13],[141,0,143,1],[141,6,141,7],[141,12,141,13],[151,0,153,1],[151,2,151,3],[151,4,151,5],[151,6,151,7],[151,8,151,9],[152,2,153,3],[152,4,153,5],[152,6,153,7],[152,8,153,9],[151,12,151,13],[152,10,153,10],[152,12,153,13],[74,7,74,8],[70,5,70,6],[71,3,71,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[31,7,31,8],[30,7,30,8],[29,7,29,8],[28,7,28,8],[145,4,145,5],[201,5,202,5],[201,8,202,8],[201,11,202,11],[204,2,204,11],[199,2,203,2],[199,3,199,5],[199,6,199,8],[199,9,199,11],[200,3,200,5],[200,6,200,8],[200,9,200,11],[163,11,163,13],[161,5,161,7],[166,0,166,4],[158,0,159,13],[161,11,161,13],[160,0,160,4],[155,0,155,1],[155,2,155,3],[155,4,155,5],[155,6,155,7],[155,8,155,9],[155,12,155,13],[205,2,205,11],[28,14,33,14],[185,1,186,12],[197,2,198,11],[192,7,192,9],[193,7,193,9],[188,10,190,12],[191,10,191,12],[187,10,187,12],[188,4,190,6],[188,7,191,9],[191,4,191,6],[192,1,192,3],[194,1,194,3],[192,4,192,6],[194,7,194,9],[145,12,145,13],[144,4,144,5],[144,8,144,9],[144,12,144,13],[148,0,149,13],[150,0,150,1],[150,2,150,3],[150,4,150,5]]}
["WORKSHEET 1A -- GENERAL INFORMATION AND INPUT DATA FOR URBAN AND SUBURBAN ROADWAY SEGMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
[]
["General Information",null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations for CMF for Roadside Fixed Objects",null,null,null,null,"Nighttime crash Proportion for CMF for Lighting"]
["Analyst",null,{"$f":"'Project Information'!B6","v":"John Smith"},null,null,"Roadway",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$16:$H$92,2,FALSE)","v":{"$error":"#N/A"}}]
["Agency or Company",null,{"$f":"'Project Information'!B7","v":"ABC Company"},"ABC Company","ABC Company","Roadway Section",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$16:$H$92,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"foffset",null,{"$f":"POWER($F$26,-0.614)*0.3566","v":4.4180323182145667E-2}]
["Date Performed",null,{"$f":"'Project Information'!F5","v":"2011-05-12"},"2011-05-12","2011-05-12","Jurisdiction",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$16:$H$92,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pinr:",{"$f":"IF('Segment Tables'!$C$122=\"No\",(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,4,FALSE)),(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,9,FALSE)))","v":{"$error":"#N/A"}}]
["Segment for Analysis",null,"Segment 1",null,null,"Analysis Year",null,{"$f":"'Project Information'!$F$6","v":2011}]
["Input Data",null,null,null,null,"Site Conditions",null,null,null,null,"Base Conditions",null,null,null,{"$f":"IF($F$9=\"2U\",\"Two-lane undivided arterials\",IF($F$9=\"3T\",\"Three-lane arterials including a center two-way left-turn lane (TWLTL)\", IF($F$9=\"4U\",\"Four-lane undivided arterials\", IF($F$9=\"4D\", \"Four-lane divided arterials (i.e., including a raised or depressed median)\",\"Five-lane arterials including a center two-way left-turn lane (TWLTL)\"))))","v":"Five-lane arterials including a center two-way left-turn lane (TWLTL)"},null,null,null,null,null,null,null,null,null,null,null,"Calculated CMF2r",null,{"$f":"$AC$5*$F$25*(IF('Segment Tables'!$C$108=\"No\",(VLOOKUP($F$9,'Segment Tables'!$A$110:$G$114,4,FALSE)),(VLOOKUP($F$10,'Segment Tables'!$A$110:$G$114,6,FALSE))))+(1-(IF('Segment Tables'!$C$108=\"No\",(VLOOKUP($F$9,'Segment Tables'!$A$110:$G$114,4,FALSE)),(VLOOKUP($F$9,'Segment Tables'!$A$110:$G$114,6,FALSE)))))","v":{"$error":"#N/A"}},null,null,"ppnr:",{"$f":"IF('Segment Tables'!$C$122=\"No\",(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,6,FALSE)),(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,11,FALSE)))","v":{"$error":"#N/A"}}]
["Roadway type (2U, 3T, 4U, 4D, 5T)",null,null,null,null,null,null,null,null,null,"--"]
["Length of segment, L (mi)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted CMF2r",null,{"$f":"IF(+AC8<1,1,AC8)","v":{"$error":"#N/A"}},null,null,"pnr:",{"$f":"IF('Segment Tables'!$C$122=\"No\",(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,7,FALSE)),(VLOOKUP($F$9,'Segment Tables'!$A$124:$M$128,12,FALSE)))","v":{"$error":"#N/A"}}]
["AADT (veh/day)",{"$f":"IF(F11>D11,\" is out of range\",\" is within range\")","v":" is within range"},"AADTMAX =",{"$f":"IF($F$9=\"2U\",32600,IF($F$9=\"3T\",32900,IF($F$9=\"4U\",40100,IF($F$9=\"4D\",66000,53800))))","v":53800},"(veh/day)",null,null,null,null,null,"--",null,null,null,{"$f":"IF(F11>D11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Type of on-street parking (none/parallel/angle)",null,null,null,null,"None",null,null,null,null,"None"]
["Proportion of curb length with on-street parking",null,null,null,null,null,null,null,null,null,"--"]
["Median width (ft) - for divided only",null,null,null,null,null,null,null,null,null,15]
["Lighting (present / not present)",null,null,null,null,"Not Present",null,null,null,null,"Not Present"]
["Auto speed enforcement (present / not present)",null,null,null,null,"Not Present",null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrier"]
["Major commercial driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Minor commercial driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Major industrial / institutional driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
["Minor industrial / institutional driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
["Major residential driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
["Minor residential driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
["Other driveways (number)",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
["Speed Category",null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
["Roadside fixed object density (fixed objects / mi)",null,null,null,null,0,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
["Offset to roadside fixed objects (ft) [If greater than 30 or Not Present, input 30]",null,null,null,null,30,null,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
["Calibration Factor, Cr",null,null,null,null,1,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
["Average Annual Crash History (3 or 5-yr average)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Present"]
["           Multiple vehicle driveway crashes",null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,null,null,"If inputs are complete, click for next element",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base AADT"]
[null,null,null,null,"PDO","Property Damage Only",null,0]
["           Multiple vehicle nondriveway crashes",null,null,null,"KABC","Fatal and Injury Only",null,0]
[null,null,null,null,"PDO","Property Damage Only",null,0]
["           Single-vehicle crashes",null,null,null,"KABC","Fatal and Injury Only",null,0]
[null,null,null,null,"PDO","Property Damage Only",null,0]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.12-8 in Part C of the HSM)"]
[]
[]
["WORKSHEET 1B -- CRASH MODIFICATION FACTORS FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,"(2)",null,null,"(3)",null,"(4)",null,"(5)",null,null,"(6)"]
["CMF for On-Street Parking",null,"CMF for Roadside Fixed Objects",null,null,"CMF for Median Width",null,"CMF for Lighting",null,"CMF for Automated Speed Enforcement",null,null,"Combined CMF"]
[]
["CMF 1r",null,"CMF 2r",null,null,"CMF 3r",null,"CMF 4r",null,"CMF 5r",null,null,"CMF comb"]
["from Equation 12-32",null,"from Equation 12-33",null,null,"from Table 12-22",null,"from Equation 12-34",null,"from Section 12.7.1",null,null,"(1)*(2)*(3)*(4)*(5)"]
[{"$f":"1+$F$13*(IF($F$12=\"None\",1,(IF($F$12=\"Parallel (Residential)\",VLOOKUP($F$9,'Segment Tables'!$W$9:$AA$13,2,FALSE),(IF($F$12=\"Parallel (Comm/Ind)\",VLOOKUP($F$9,'Segment Tables'!$W$9:$AA$13,3,FALSE),(IF($F$12=\"Angle (Residential)\",(VLOOKUP($F$9,'Segment Tables'!$W$9:$AA$13,4,FALSE)),(VLOOKUP($F$9,'Segment Tables'!$W$9:$AA$13,5,FALSE)))))))))-1)","v":1},null,{"$f":"$AC$10","v":{"$error":"#N/A"}},null,null,{"$f":"IF(F9=\"4D\",VLOOKUP(F14,'Segment Tables'!W41:Y51,3,FALSE),1)","v":1},null,{"$f":"IF($F$15=\"Present\",(1-($AG$10*(1-(0.72*$AG$6)-(0.83*$AG$8)))),1)","v":1},null,{"$f":"IF($F$16=\"Present\",0.95,1)","v":1},null,null,{"$f":"$A$45*$C$45*$F$45*$H$45*$J$45","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1C -- MULTIPLE-VEHICLE NONDRIVEWAY COLLISIONS BY SEVERITY LEVEL FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)","(9)"]
["Crash Severity Level",null,"SPF Coefficients",null,"Overdispersion Parameter, k",null,"Initial Nbrmv",null,"Proportion of Total Crashes",null,"Adjusted Nbrmv","Combined CMFs","Calibration Factor, Cr","Predicted Nbrmv"]
[]
[null,null,"from Table 12-3",null,"from Table 12-3",null,"from Equation 12-10",null,null,null,"(4)TOTAL*(5)","(6) from Worksheet 1B",null,"(6)*(7)*(8)"]
[null,null,"a","b"]
["Total",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$8:$D$12,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$8:$D$12,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$8:$D$12,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C55+($D55*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,1,null,{"$f":"G55*I55","v":{"$error":"#N/A"}},{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K55*L55*M55","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$14:$D$18,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$14:$D$18,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$14:$D$18,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C56+($D56*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,"(4)FI/((4)FI+(4)PDO)",null,{"$f":"G55*I57","v":{"$error":"#N/A"}},{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K56*L56*M56","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"G56/(G56+G58)","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$20:$D$24,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$20:$D$24,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$A$20:$D$24,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C58+($D58*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,"(5)TOTAL-(5)FI",null,{"$f":"G55*I59","v":{"$error":"#N/A"}},{"$f":"+M45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K58*L58*M58","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"I55-I57","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1D -- MULTIPLE-VEHICLE NONDRIVEWAY COLLISIONS BY COLLISION TYPE FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)"]
["Collision Type",null,null,"Proportion of Collision Type(FI)",null,"Predicted N brmv (FI) (crashes/year)",null,"Proportion of Collision Type (PDO)",null,"Predicted N brmv (PDO) (crashes/year)",null,"Predicted N brmv (TOTAL) (crashes/year)"]
[]
[]
[null,null,null,"from Table 12-4",null,"(9)FI from Worksheet 1C",null,"from Table 12-4",null,"(9)PDO from Worksheet 1C",null,"(9)TOTAL from Worksheet 1C"]
[]
["Total",null,null,1,null,{"$f":"+N56","v":{"$error":"#N/A"}},null,1,null,{"$f":"+N58","v":{"$error":"#N/A"}},null,{"$f":"+N55","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"(2)*(3)FI",null,null,null,"(4)*(5)PDO",null,"(3)+(5)"]
["Rear-end collision",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,3,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,3,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+$F$70*$D72","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D34,IF($F$9=\"3T\",'Segment Tables'!F34,IF($F$9=\"4U\",'Segment Tables'!H34,IF($F$9=\"4D\",'Segment Tables'!J34,'Segment Tables'!L34)))),IF($F$9=\"2U\",'Segment Tables'!D44,IF($F$9=\"3T\",'Segment Tables'!F44,IF($F$9=\"4U\",'Segment Tables'!H44,IF($F$9=\"4D\",'Segment Tables'!J44,'Segment Tables'!L44)))))","v":0.65100000000000002},null,{"$f":"+$J$70*H72","v":{"$error":"#N/A"}},null,{"$f":"+F72+J72","v":{"$error":"#N/A"}}]
["Head-on collision",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,4,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,4,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D35,IF($F$9=\"3T\",'Segment Tables'!F35,IF($F$9=\"4U\",'Segment Tables'!H35,IF($F$9=\"4D\",'Segment Tables'!J35,'Segment Tables'!L35)))),IF($F$9=\"2U\",'Segment Tables'!D45,IF($F$9=\"3T\",'Segment Tables'!F45,IF($F$9=\"4U\",'Segment Tables'!H45,IF($F$9=\"4D\",'Segment Tables'!J45,'Segment Tables'!L45)))))","v":4.0000000000000001E-3},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Angle collision",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,5,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,5,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D36,IF($F$9=\"3T\",'Segment Tables'!F36,IF($F$9=\"4U\",'Segment Tables'!H36,IF($F$9=\"4D\",'Segment Tables'!J36,'Segment Tables'!L36)))),IF($F$9=\"2U\",'Segment Tables'!D46,IF($F$9=\"3T\",'Segment Tables'!F46,IF($F$9=\"4U\",'Segment Tables'!H46,IF($F$9=\"4D\",'Segment Tables'!J46,'Segment Tables'!L46)))))","v":5.8999999999999997E-2},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Sideswipe, same direction",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,6,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,6,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D37,IF($F$9=\"3T\",'Segment Tables'!F37,IF($F$9=\"4U\",'Segment Tables'!H37,IF($F$9=\"4D\",'Segment Tables'!J37,'Segment Tables'!L37)))),IF($F$9=\"2U\",'Segment Tables'!D47,IF($F$9=\"3T\",'Segment Tables'!F47,IF($F$9=\"4U\",'Segment Tables'!H47,IF($F$9=\"4D\",'Segment Tables'!J47,'Segment Tables'!L47)))))","v":0.248},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Sideswipe, opposite direction",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,7,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,7,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D38,IF($F$9=\"3T\",'Segment Tables'!F38,IF($F$9=\"4U\",'Segment Tables'!H38,IF($F$9=\"4D\",'Segment Tables'!J38,'Segment Tables'!L38)))),IF($F$9=\"2U\",'Segment Tables'!D48,IF($F$9=\"3T\",'Segment Tables'!F48,IF($F$9=\"4U\",'Segment Tables'!H48,IF($F$9=\"4D\",'Segment Tables'!J48,'Segment Tables'!L48)))))","v":8.9999999999999993E-3},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Other multiple-vehicle collision",null,null,{"$f":"IF('Segment Tables'!$B$30=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$32:$L$39,8,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$42:$L$49,8,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$B$30=\"No\",IF($F$9=\"2U\",'Segment Tables'!D39,IF($F$9=\"3T\",'Segment Tables'!F39,IF($F$9=\"4U\",'Segment Tables'!H39,IF($F$9=\"4D\",'Segment Tables'!J39,'Segment Tables'!L39)))),IF($F$9=\"2U\",'Segment Tables'!D49,IF($F$9=\"3T\",'Segment Tables'!F49,IF($F$9=\"4U\",'Segment Tables'!H49,IF($F$9=\"4D\",'Segment Tables'!J49,'Segment Tables'!L49)))))","v":2.9000000000000001E-2},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
["WORKSHEET 1E -- SINGLE-VEHICLE COLLISIONS BY SEVERITY LEVEL FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)","(9)"]
["Crash Severity Level",null,"SPF Coefficients",null,"Overdispersion Parameter, k",null,"Initial Nbrsv",null,"Proportion of Total Crashes",null,"Adjusted Nbrsv","Combined CMFs","Calibration Factor, Cr","Predicted Nbrsv"]
[]
[null,null,"from Table 12-5",null,"from Table 12-5",null,"from Equation 12-13",null,null,null,"(4)TOTAL*(5)","(6) from Worksheet 1B",null,"(6)*(7)*(8)"]
[null,null,"a","b"]
["Total",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$8:$J$12,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$8:$J$12,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$8:$J$12,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C87+($D87*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,1,null,{"$f":"$G$87*I87","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K87*L87*M87","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$14:$J$18,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$14:$J$18,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$14:$J$18,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C88+($D88*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,"(4)FI/((4)FI+(4)PDO)",null,{"$f":"$G$87*I89","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K88*L88*M88","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"G88/(G88+G90)","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$20:$J$24,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$20:$J$24,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F$9,'Segment Tables'!$G$20:$J$24,4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP($C90+($D90*LN($F$11))+LN($F$10))","v":{"$error":"#N/A"}},null,"(5)TOTAL-(5)FI",null,{"$f":"$G$87*I91","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+K90*L90*M90","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"I87-I89","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1F -- SINGLE-VEHICLE COLLISIONS BY COLLISION TYPE FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)"]
["Collision Type",null,null,"Proportion of Collision Type(FI)",null,"Predicted N brsv (FI) (crashes/year)",null,"Proportion of Collision Type (PDO)",null,"Predicted N brsv (PDO) (crashes/year)",null,"Predicted N brsv (TOTAL) (crashes/year)"]
[]
[]
[null,null,null,"from Table 12-6",null,"(9)FI from Worksheet 1E",null,"from Table 12-6",null,"(9)PDO from Worksheet 1E",null,"(9)TOTAL from Worksheet 1E"]
[]
["Total",null,null,1,null,{"$f":"+N88","v":{"$error":"#N/A"}},null,1,null,{"$f":"+N90","v":{"$error":"#N/A"}},null,{"$f":"+N87","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"(2)*(3)FI",null,null,null,"(4)*(5)PDO",null,"(3)+(5)"]
["Collision with animal",null,null,{"$f":"IF('Segment Tables'!$B$55=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$57:$L$62,3,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$65:$L$70,3,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+$F$102*$D104","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$55=\"No\",IF($F$9=\"2U\",'Segment Tables'!D59,IF($F$9=\"3T\",'Segment Tables'!F59,IF($F$9=\"4U\",'Segment Tables'!H59,IF($F$9=\"4D\",'Segment Tables'!J59,'Segment Tables'!L59)))),IF($F$9=\"2U\",'Segment Tables'!D67,IF($F$9=\"3T\",'Segment Tables'!F67,IF($F$9=\"4U\",'Segment Tables'!H67,IF($F$9=\"4D\",'Segment Tables'!J67,'Segment Tables'!L67)))))","v":4.9000000000000002E-2},null,{"$f":"+$J$102*H104","v":{"$error":"#N/A"}},null,{"$f":"+F104+J104","v":{"$error":"#N/A"}}]
["Collision with fixed object",null,null,{"$f":"IF('Segment Tables'!$B$55=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$57:$L$62,4,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$65:$L$70,4,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+$F$102*$D105","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$55=\"No\",IF($F$9=\"2U\",'Segment Tables'!D60,IF($F$9=\"3T\",'Segment Tables'!F60,IF($F$9=\"4U\",'Segment Tables'!H60,IF($F$9=\"4D\",'Segment Tables'!J60,'Segment Tables'!L60)))),IF($F$9=\"2U\",'Segment Tables'!D68,IF($F$9=\"3T\",'Segment Tables'!F68,IF($F$9=\"4U\",'Segment Tables'!H68,IF($F$9=\"4D\",'Segment Tables'!J68,'Segment Tables'!L68)))))","v":0.76800000000000002},null,{"$f":"+$J$102*H105","v":{"$error":"#N/A"}},null,{"$f":"+F105+J105","v":{"$error":"#N/A"}}]
["Collision with other object",null,null,{"$f":"IF('Segment Tables'!$B$55=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$57:$L$62,5,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$65:$L$70,5,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+$F$102*$D106","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$55=\"No\",IF($F$9=\"2U\",'Segment Tables'!D61,IF($F$9=\"3T\",'Segment Tables'!F61,IF($F$9=\"4U\",'Segment Tables'!H61,IF($F$9=\"4D\",'Segment Tables'!J61,'Segment Tables'!L61)))),IF($F$9=\"2U\",'Segment Tables'!D69,IF($F$9=\"3T\",'Segment Tables'!F69,IF($F$9=\"4U\",'Segment Tables'!H69,IF($F$9=\"4D\",'Segment Tables'!J69,'Segment Tables'!L69)))))","v":6.0999999999999999E-2},null,{"$f":"+$J$102*H106","v":{"$error":"#N/A"}},null,{"$f":"+F106+J106","v":{"$error":"#N/A"}}]
["Other single-vehicle collision",null,null,{"$f":"IF('Segment Tables'!$B$55=\"No\", HLOOKUP($F$9,'Segment Tables'!$C$57:$L$62,6,FALSE),HLOOKUP($F$9,'Segment Tables'!$C$65:$L$70,6,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+$F$102*$D107","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$55=\"No\",IF($F$9=\"2U\",'Segment Tables'!D62,IF($F$9=\"3T\",'Segment Tables'!F62,IF($F$9=\"4U\",'Segment Tables'!H62,IF($F$9=\"4D\",'Segment Tables'!J62,'Segment Tables'!L62)))),IF($F$9=\"2U\",'Segment Tables'!D70,IF($F$9=\"3T\",'Segment Tables'!F70,IF($F$9=\"4U\",'Segment Tables'!H70,IF($F$9=\"4D\",'Segment Tables'!J70,'Segment Tables'!L70)))))","v":0.122},null,{"$f":"+$J$102*H107","v":{"$error":"#N/A"}},null,{"$f":"+F107+J107","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1G -- MULTIPLE-VEHICLE DRIVEWAY-RELATED COLLISIONS BY DRIVEWAY TYPE FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,null,"(6)"]
["Driveway Type ",null,null,"  Number of driveways,   nj",null,"Crashes per driveway per year, Nj",null,"Coefficient for traffic adjustment, t",null,"Initial Nbrdwy",null,null,"Overdispersion parameter, k"]
[]
[null,null,null,null,null,"from Table 12-7",null,"from Table 12-7",null,"Equation 12-16",null,null,"from Table 12-7"]
[null,null,null,null,null,null,null,null,null,"nj * Nj * (AADT/15,000)t"]
["Major commercial",null,null,{"$f":"+F17","v":0},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"POWER(($F$11/15000),H117)*D117*F117","v":{"$error":"#N/A"}},null,null,"--"]
["Minor commercial",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,4,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Major industrial/institutional",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Minor industrial/institutional",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,6,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Major residential",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,7,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Minor residential",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,8,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Other",null,null,0,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$13,9,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,11,FALSE)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"}]
["Total",null,null,"--",null,"--",null,"--",null,{"$f":"SUM(J117:L123)","v":{"$error":"#N/A"}},null,null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,13,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1H -- MULTIPLE-VEHICLE DRIVEWAY-RELATED COLLISIONS BY SEVERITY LEVEL FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)","(5)",null,"(6)",null,"(7)"]
["Crash Severity Level",null,null,"Initial Nbrdwy",null,"Proportion of total crashes (fdwy)",null,"Adjusted Nbrdwy","Combined CMFs",null,"Calibration factor, Cr",null,"Predicted Nbrdwy"]
[]
[null,null,null,"(5)TOTAL from Worksheet 1G",null,"from Table 12-7",null,"(2)TOTAL * (3)","(6) from Worksheet 1B",null,null,null,"(4)*(5)*(6)"]
[]
["Total",null,null,{"$f":"+J124","v":{"$error":"#N/A"}},null,1,null,{"$f":"+$D$134*F134","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},null,{"$f":"+$F$27","v":1},null,{"$f":"+H134*I134*K134","v":{"$error":"#N/A"}}]
["Fatal and injury (FI)",null,null,"--",null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,15,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"+$D$134*F135","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},null,{"$f":"+$F$27","v":1},null,{"$f":"+H135*I135*K135","v":{"$error":"#N/A"}}]
["Property damage only (PDO)",null,null,"--",null,{"$f":"HLOOKUP($F$9,'Segment Tables'!$P$5:$T$21,17,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"+$D$134*F136","v":{"$error":"#N/A"}},{"$f":"+$M$45","v":{"$error":"#N/A"}},null,{"$f":"+$F$27","v":1},null,{"$f":"+H136*I136*K136","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1I -- VEHICLE-PEDESTRIAN COLLISIONS FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)"]
["Crash Severity Level",null,"Predicted Nbrmv",null,"Predicted Nbrsv",null,"Predicted Nbrdwy",null,"Predicted Nbr",null,"fpedr","Calibration factor, Cr","Predicted Npedr"]
[null,null,"(9) from Worksheet 1C",null,"(9) from Worksheet 1E",null,"(7) from Worksheet 1H",null,"(2)+(3)+(4)",null,"from Table 12-8",null,"(5)*(6)*(7)"]
[]
["Total",null,{"$f":"+$N$55","v":{"$error":"#N/A"}},null,{"$f":"+$N$87","v":{"$error":"#N/A"}},null,{"$f":"+$M$134","v":{"$error":"#N/A"}},null,{"$f":"+C145+E145+G145","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$76=\"No\", (IF($F$24=\"Posted Speed 30 mph or Lower\",VLOOKUP($F$9,'Segment Tables'!$A$79:$J$83,3,FALSE),VLOOKUP($F$9,'Segment Tables'!$A$79:$J$83,5,FALSE))),(IF($F$24=\"Posted Speed 30 mph or Lower\", VLOOKUP($F$9,'Segment Tables'!$A$79:$J$83,7,FALSE),VLOOKUP($F$9,'Segment Tables'!$A$79:$J$83,9,FALSE))))","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+$I$145*$K$145*$L$145","v":{"$error":"#N/A"}}]
["Fatal and injury (FI)",null,"--",null,"--",null,"--",null,"--",null,"--",{"$f":"+$F$27","v":1},{"$f":"+$I$145*$K$145*$L$145","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1J -- VEHICLE-BICYCLE COLLISIONS FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)"]
["Crash Severity Level",null,"Predicted Nbrmv",null,"Predicted Nbrsv",null,"Predicted Nbrdwy",null,"Predicted Nbr",null,"fbiker","Calibration factor, Cr","Predicted Nbiker"]
[null,null,"(9) from Worksheet 1C",null,"(9) from Worksheet 1E",null,"(7) from Worksheet 1H",null,"(2)+(3)+(4)",null,"from Table 12-9",null,"(5)*(6)*(7)"]
[]
["Total",null,{"$f":"+$N$55","v":{"$error":"#N/A"}},null,{"$f":"+$N$87","v":{"$error":"#N/A"}},null,{"$f":"+$M$134","v":{"$error":"#N/A"}},null,{"$f":"+C155+E155+G155","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$B$91=\"No\", (IF($F$24=\"Posted Speed 30 mph or Lower\",VLOOKUP($F$9,'Segment Tables'!$A$94:$J$98,3,FALSE),VLOOKUP($F$9,'Segment Tables'!$A$94:$J$98,5,FALSE))),(IF($F$24=\"Posted Speed 30 mph or Lower\", VLOOKUP($F$9,'Segment Tables'!$A$94:$J$98,7,FALSE),VLOOKUP($F$9,'Segment Tables'!$A$94:$J$98,9,FALSE))))","v":{"$error":"#N/A"}},{"$f":"+$F$27","v":1},{"$f":"+$I$155*$K$155*$L$155","v":{"$error":"#N/A"}}]
["Fatal and injury (FI)",null,"--",null,"--",null,"--",null,"--",null,"--",{"$f":"+$F$27","v":1},{"$f":"+$I$155*$K$155*$L$155","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 1K -- CRASH SEVERITY DISTRIBUTION FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
["(1)",null,null,null,null,"(2)",null,null,"(3)",null,null,"(4)"]
["Collision type",null,null,null,null,"Fatal and injury (FI)",null,null,"Property damage only (PDO)",null,null,"Total"]
[null,null,null,null,null,"(3) from Worksheet 1D and 1F;",null,null,"(5) from Worksheet 1D and 1F; and",null,null,"(6) from Worksheet 1D and 1F;"]
[null,null,null,null,null,"(7) from Worksheet 1H; and",null,null,"(7) from Worksheet 1H",null,null,"(7) from Worksheet 1H; and"]
[null,null,null,null,null,"(8) from Worksheet 1I and 1J",null,null,null,null,null,"(8) from Worksheet 1I and 1J"]
["MULTIPLE-VEHICLE"]
["Rear-end collisions (from Worksheet 1D)",null,null,null,null,{"$f":"+F72","v":{"$error":"#N/A"}},null,null,{"$f":"+J72","v":{"$error":"#N/A"}},null,null,{"$f":"+L72","v":{"$error":"#N/A"}}]
["Head-on collisions (from Worksheet 1D)",null,null,null,null,{"$f":"+F73","v":{"$error":"#N/A"}},null,null,{"$f":"+J73","v":{"$error":"#N/A"}},null,null,{"$f":"+L73","v":{"$error":"#N/A"}}]
["Angle collisions (from Worksheet 1D)",null,null,null,null,{"$f":"+F74","v":{"$error":"#N/A"}},null,null,{"$f":"+J74","v":{"$error":"#N/A"}},null,null,{"$f":"+L74","v":{"$error":"#N/A"}}]
["Sideswipe, same direction (from Worksheet 1D)",null,null,null,null,{"$f":"+F75","v":{"$error":"#N/A"}},null,null,{"$f":"+J75","v":{"$error":"#N/A"}},null,null,{"$f":"+L75","v":{"$error":"#N/A"}}]
["Sideswipe, opposite direction (from Worksheet 1D)",null,null,null,null,{"$f":"+F76","v":{"$error":"#N/A"}},null,null,{"$f":"+J76","v":{"$error":"#N/A"}},null,null,{"$f":"+L76","v":{"$error":"#N/A"}}]
["Driveway-related collisions (from Worksheet 1H)",null,null,null,null,{"$f":"+M135","v":{"$error":"#N/A"}},null,null,{"$f":"+M136","v":{"$error":"#N/A"}},null,null,{"$f":"+M134","v":{"$error":"#N/A"}}]
["Other multiple-vehicle collision (from Worksheet 1D)",null,null,null,null,{"$f":"+F77","v":{"$error":"#N/A"}},null,null,{"$f":"+J77","v":{"$error":"#N/A"}},null,null,{"$f":"+L77","v":{"$error":"#N/A"}}]
["Subtotal",null,null,null,null,{"$f":"SUM(F167:H173)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(I167:K173)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(L167:N173)","v":{"$error":"#N/A"}}]
["SINGLE-VEHICLE"]
["Collision with animal (from Worksheet 1F)",null,null,null,null,{"$f":"+F104","v":{"$error":"#N/A"}},null,null,{"$f":"+J104","v":{"$error":"#N/A"}},null,null,{"$f":"+L104","v":{"$error":"#N/A"}}]
["Collision with fixed object (from Worksheet 1F)",null,null,null,null,{"$f":"+F105","v":{"$error":"#N/A"}},null,null,{"$f":"+J105","v":{"$error":"#N/A"}},null,null,{"$f":"+L105","v":{"$error":"#N/A"}}]
["Collision with other object (from Worksheet 1F)",null,null,null,null,{"$f":"+F106","v":{"$error":"#N/A"}},null,null,{"$f":"+J106","v":{"$error":"#N/A"}},null,null,{"$f":"+L106","v":{"$error":"#N/A"}}]
["Other single-vehicle collision (from Worksheet 1F)",null,null,null,null,{"$f":"+F107","v":{"$error":"#N/A"}},null,null,{"$f":"+J107","v":{"$error":"#N/A"}},null,null,{"$f":"+L107","v":{"$error":"#N/A"}}]
["Collision with pedestrian (from Worksheet 1I)",null,null,null,null,{"$f":"+M146","v":{"$error":"#N/A"}},null,null,0,null,null,{"$f":"+M145","v":{"$error":"#N/A"}}]
["Collision with bicycle (from Worksheet 1J)",null,null,null,null,{"$f":"+M156","v":{"$error":"#N/A"}},null,null,0,null,null,{"$f":"+M155","v":{"$error":"#N/A"}}]
["Subtotal",null,null,null,null,{"$f":"SUM(F176:H181)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(I176:K181)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(L176:N181)","v":{"$error":"#N/A"}}]
["Total",null,null,null,null,{"$f":"+F174+F182","v":{"$error":"#N/A"}},null,null,{"$f":"+I174+I182","v":{"$error":"#N/A"}},null,null,{"$f":"+L174+L182","v":{"$error":"#N/A"}}]
[]
[]
[null,"WORKSHEET 1L -- SUMMARY RESULTS FOR URBAN AND SUBURBAN ROADWAY SEGMENTS"]
[]
[null,"(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)"]
[null,"Crash Severity Level",null,null,"Predicted average crash frequency,      \nN predicted rs (crashes/year)",null,null,"Roadway segment length, L (mi)",null,null,"Crash rate (crashes/mi/year)"]
[]
[]
[null,null,null,null,"(Total) from Worksheet 1K",null,null,null,null,null,"(2) / (3)"]
[null,"Total",null,null,{"$f":"+L183","v":{"$error":"#N/A"}},null,null,{"$f":"+$F$10","v":0},null,null,{"$f":"+E193/H193","v":{"$error":"#N/A"}}]
[null,"Fatal and injury (FI)",null,null,{"$f":"+F183","v":{"$error":"#N/A"}},null,null,{"$f":"+$F$10","v":0},null,null,{"$f":"+E194/H194","v":{"$error":"#N/A"}}]
[null,"Property damage only (PDO)",null,null,{"$f":"+I183","v":{"$error":"#N/A"}},null,null,{"$f":"+$F$10","v":0},null,null,{"$f":"+E195/H195","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"PROJECT ELEMENT RESULTS SUMMARY1"]
[]
[null,null,"Summary for the project element","Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
[null,null,null,"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,null,null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,null,null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[null,null,null,{"$f":"ROUND(E193,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Urban Site Total'!$B$11:$C$37,$C$7,'Urban Site Total'!$L$11:$L$37)+L180+L181,1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(E204>D204,ROUND(E204-D204,1),0),0)","v":0},{"$f":"ROUND(E194,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+$E$204*$G$204/$D$204),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(H204>G204,ROUND(H204-G204,1),0),0)","v":0},{"$f":"ROUND(E195,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+$E$204*$J$204/$D$204),1),0)","v":0},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",IF(K204>J204,ROUND(K204-J204,1),0),0)","v":0}]
[null,null,"Special Note: When the project element is not included in the analysis the results will all be zeros. In addition if only the analysis only includes determining the predicted average crash frequency (i.e. EB analysis is not carried out), the results will show zero values where EB results are usually displayed."]
[null,null,"1 The values in this table are rounded values.  For unrounded values, refer to Workdheet 1L."]

{"sheet":"Intersection Template","index":7,"n_rows":204,"n_cols":38,"rows_kept":204,"cut":false,"hidden":true,"merged":[[43,12,44,13],[36,5,36,6],[7,2,7,4],[7,5,7,6],[7,7,7,13],[7,14,7,16],[45,12,45,13],[45,8,45,9],[0,17,0,22],[2,5,2,13],[42,6,42,7],[22,0,22,6],[31,0,31,6],[45,6,45,7],[45,2,45,3],[35,5,35,6],[33,0,34,3],[35,0,36,3],[43,10,44,11],[43,8,44,9],[43,6,44,7],[45,4,45,5],[42,10,42,11],[45,0,45,1],[3,24,3,25],[4,0,4,1],[5,0,5,1],[3,0,3,1],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[5,7,5,13],[6,7,6,13],[3,2,3,4],[4,2,4,4],[5,2,5,4],[43,2,44,3],[25,0,25,6],[24,0,24,6],[36,7,36,8],[45,10,45,11],[34,5,34,6],[35,7,35,8],[34,7,34,8],[33,7,33,8],[21,0,21,6],[42,8,42,9],[43,0,44,1],[43,4,44,5],[58,10,59,10],[58,11,59,11],[58,12,59,12],[58,13,59,13],[59,8,59,9],[50,0,51,13],[52,5,52,6],[53,2,54,4],[47,6,47,7],[58,4,59,4],[58,0,59,1],[58,2,59,2],[58,3,59,3],[58,8,58,9],[57,5,57,6],[58,5,59,6],[58,7,59,7],[57,0,57,1],[57,8,57,9],[49,0,49,1],[52,2,52,4],[47,0,47,1],[47,2,47,3],[105,11,105,13],[102,9,103,10],[102,11,103,13],[84,11,85,11],[84,12,87,12],[84,13,85,13],[98,0,98,2],[98,3,98,4],[98,5,98,6],[98,7,98,8],[98,9,98,10],[98,11,98,13],[84,0,88,1],[87,2,88,2],[87,3,88,3],[87,4,88,4],[92,10,93,10],[92,11,93,11],[92,12,93,12],[52,8,52,9],[55,2,55,4],[105,9,105,10],[147,12,147,13],[142,10,142,11],[136,8,136,9],[73,11,73,13],[139,8,140,9],[105,7,105,8],[153,8,153,9],[153,10,153,11],[153,12,153,13],[127,7,127,9],[127,10,127,12],[90,13,91,13],[91,8,91,9],[90,10,91,10],[90,11,91,11],[90,12,91,12],[152,0,152,2],[152,3,152,4],[152,5,152,6],[152,8,152,9],[152,10,152,11],[139,2,139,6],[141,0,141,1],[152,12,152,13],[92,13,93,13],[147,8,147,9],[147,10,147,11],[148,0,151,2],[129,7,129,9],[128,10,129,12],[128,1,128,3],[130,7,130,9],[130,10,130,12],[147,0,147,2],[147,3,147,4],[147,5,147,6],[122,10,122,11],[122,12,122,13],[127,1,127,3],[127,4,127,6],[179,11,179,13],[176,11,176,13],[177,0,177,4],[177,5,177,7],[169,0,169,13],[175,5,175,7],[174,11,174,13],[179,0,179,4],[179,5,179,7],[179,8,179,10],[172,5,172,7],[173,5,173,7],[173,8,173,10],[170,5,170,7],[175,8,175,10],[174,0,174,4],[174,8,174,10],[171,0,171,4],[176,8,176,10],[170,0,170,4],[173,0,173,4],[176,0,176,4],[176,5,176,7],[178,0,178,4],[178,5,178,7],[178,8,178,10],[170,8,170,10],[153,0,153,2],[153,3,153,4],[153,5,153,6],[162,0,162,13],[163,0,163,4],[163,5,163,7],[163,8,163,10],[163,11,163,13],[161,5,161,7],[161,11,161,13],[161,8,161,10],[160,5,160,7],[178,11,178,13],[159,0,161,4],[165,0,165,4],[165,5,165,7],[165,8,165,10],[171,8,171,10],[172,0,172,4],[171,11,171,13],[172,8,172,10],[175,0,175,4],[160,11,160,13],[177,11,177,13],[3,7,3,13],[4,7,4,13],[129,1,129,3],[128,4,128,6],[128,7,128,9],[129,4,129,6],[136,0,136,1],[136,2,136,6],[137,2,138,6],[137,0,140,1],[130,1,130,3],[130,4,130,6],[137,7,140,7],[131,1,131,3],[131,4,131,6],[131,7,131,9],[122,0,122,2],[122,3,122,4],[122,5,122,6],[73,7,73,8],[73,9,73,10],[202,2,202,11],[137,13,138,13],[137,8,138,9],[137,10,138,11],[139,10,140,11],[198,6,198,8],[198,9,198,11],[137,12,140,12],[173,11,173,13],[167,8,167,10],[167,11,167,13],[175,11,175,13],[170,11,170,13],[172,11,172,13],[174,5,174,7],[142,8,142,9],[139,13,140,13],[171,5,171,7],[197,2,201,2],[197,3,197,5],[197,6,197,8],[197,9,197,11],[198,3,198,5],[177,8,177,10],[164,0,164,4],[168,8,168,10],[167,0,167,4],[167,5,167,7],[168,0,168,4],[165,11,165,13],[166,0,166,4],[166,5,166,7],[166,8,166,10],[166,11,166,13],[168,5,168,7],[168,11,168,13],[164,5,164,7],[164,8,164,10],[164,11,164,13],[158,11,158,13],[159,5,159,7],[159,8,159,10],[159,11,159,13],[160,8,160,10],[158,0,158,4],[142,0,142,1],[131,10,131,12],[141,8,141,9],[158,5,158,7],[158,8,158,10],[150,3,151,4],[150,5,151,6],[150,7,151,7],[150,8,151,9],[150,12,151,13],[148,3,149,4],[148,5,149,6],[148,7,149,7],[148,12,149,13],[148,8,149,9],[148,10,151,11],[141,10,141,11],[136,10,136,11],[121,0,121,2],[121,3,121,4],[121,5,121,6],[121,8,121,9],[121,10,121,11],[121,12,121,13],[122,8,122,9],[117,12,118,13],[119,3,120,4],[119,5,120,6],[119,7,120,7],[119,8,120,9],[119,12,120,13],[117,0,120,2],[117,3,118,4],[117,5,118,6],[117,7,118,7],[117,8,118,9],[117,10,120,11],[116,0,116,2],[116,3,116,4],[116,5,116,6],[116,8,116,9],[116,10,116,11],[116,12,116,13],[108,0,108,2],[108,3,108,4],[108,5,108,6],[108,7,108,8],[108,9,108,10],[108,11,108,13],[111,0,111,2],[111,3,111,4],[111,5,111,6],[111,7,111,8],[111,9,111,10],[111,11,111,13],[110,0,110,2],[110,3,110,4],[110,5,110,6],[110,7,110,8],[110,9,110,10],[110,11,110,13],[109,0,109,2],[109,3,109,4],[109,5,109,6],[109,7,109,8],[109,9,109,10],[109,11,109,13],[107,0,107,2],[107,3,107,4],[107,5,107,6],[107,7,107,8],[107,9,107,10],[107,11,107,13],[106,0,106,2],[106,3,106,4],[106,5,106,6],[106,7,106,8],[106,9,106,10],[106,11,106,13],[99,0,103,2],[99,3,101,4],[99,5,101,6],[105,0,105,2],[105,3,105,4],[105,5,105,6],[104,0,104,2],[104,3,104,4],[104,5,104,6],[102,3,103,4],[104,7,104,8],[104,9,104,10],[104,11,104,13],[99,7,101,8],[99,9,101,10],[99,11,101,13],[102,5,103,6],[102,7,103,8],[92,0,93,1],[92,2,93,2],[92,3,93,3],[92,4,93,4],[92,5,93,6],[89,0,89,1],[89,5,89,6],[89,8,89,9],[90,0,91,1],[90,2,91,2],[90,3,91,3],[90,4,91,4],[90,5,91,6],[90,7,91,7],[90,8,90,9],[92,7,93,7],[92,8,92,9],[93,8,93,9],[86,2,86,4],[86,10,87,10],[86,11,87,11],[86,13,87,13],[78,0,78,2],[78,3,78,4],[78,5,78,6],[78,7,78,8],[78,9,78,10],[78,11,78,13],[84,2,85,4],[84,5,85,6],[84,7,85,7],[84,8,87,9],[84,10,85,10],[86,5,88,6],[86,7,88,7],[77,0,77,2],[77,3,77,4],[77,5,77,6],[77,7,77,8],[77,9,77,10],[77,11,77,13],[83,0,83,1],[83,2,83,4],[83,5,83,6],[83,8,83,9],[81,0,82,13],[76,0,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,13],[75,0,75,2],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,13],[74,0,74,2],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,13],[67,0,71,2],[67,3,69,4],[67,5,69,6],[73,0,73,2],[73,3,73,4],[73,5,73,6],[72,0,72,2],[72,3,72,4],[72,5,72,6],[70,3,71,4],[72,7,72,8],[72,9,72,10],[72,11,72,13],[67,7,69,8],[67,9,69,10],[67,11,69,13],[53,7,54,7],[66,5,66,6],[66,7,66,8],[66,9,66,10],[70,5,71,6],[70,7,71,8],[70,9,71,10],[70,11,71,13],[60,5,61,6],[60,7,61,7],[66,11,66,13],[64,0,65,13],[66,3,66,4],[60,0,61,1],[60,2,61,2],[66,0,66,2],[60,12,61,12],[60,13,61,13],[60,3,61,3],[60,8,60,9],[60,10,61,10],[60,11,61,11],[60,4,61,4],[61,8,61,9],[42,12,42,13],[46,12,46,13],[53,11,54,11],[53,12,56,12],[53,0,56,1],[53,8,56,9],[53,10,54,10],[53,5,54,6],[55,5,56,6],[55,7,56,7],[46,8,46,9],[46,4,46,5],[55,10,56,10],[53,13,56,13],[55,11,56,11],[46,10,46,11],[47,10,47,11],[47,8,47,9],[52,0,52,1],[47,12,47,13],[46,6,46,7],[46,2,46,3],[47,4,47,5],[46,0,46,1],[7,0,7,1],[15,0,15,6],[42,4,42,5],[28,0,28,6],[27,0,27,6],[40,0,41,13],[26,7,26,10],[31,11,31,13],[31,7,31,10],[30,7,30,10],[29,7,29,10],[28,7,28,10],[27,7,27,10],[33,5,33,6],[16,0,16,6],[23,0,23,6],[15,11,15,13],[30,0,30,6],[19,0,19,6],[26,0,26,6],[20,0,20,6],[42,0,42,1],[42,2,42,3],[32,0,32,13],[184,2,184,6],[182,2,183,11],[9,0,9,6],[0,0,1,13],[18,7,18,10],[19,7,19,10],[20,7,20,10],[21,7,21,10],[22,7,22,10],[23,7,23,10],[24,7,24,10],[25,7,25,10],[8,0,8,6],[12,0,12,6],[10,0,10,3],[11,0,11,3],[9,7,9,10],[10,7,10,10],[11,7,11,10],[12,7,12,10],[13,7,13,10],[15,7,15,10],[16,7,16,10],[8,7,8,10],[29,0,29,6],[195,2,196,11],[17,0,17,13],[14,0,14,13],[2,0,2,4],[6,0,6,1],[6,2,6,4],[96,0,97,13],[114,0,115,13],[125,1,126,12],[134,0,135,13],[145,0,146,13],[156,0,157,13],[191,7,191,11],[190,7,190,11],[189,7,189,11],[188,7,188,11],[185,7,187,11],[184,7,184,11],[191,2,191,6],[190,2,190,6],[189,2,189,6],[188,2,188,6],[185,2,187,6],[203,2,203,11],[13,0,13,6],[18,0,18,6],[33,14,36,14],[8,11,8,13],[30,11,30,13],[29,11,29,13],[28,11,28,13],[27,11,27,13],[26,11,26,13],[25,11,25,13],[24,11,24,13],[23,11,23,13],[22,11,22,13],[21,11,21,13],[20,11,20,13],[19,11,19,13],[18,11,18,13],[16,11,16,13],[13,11,13,13],[12,11,12,13],[11,11,11,13],[10,11,10,13],[9,11,9,13]]}
["WORKSHEET 2A -- GENERAL INFORMATION AND INPUT DATA FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
[]
["General Information",null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations for CMF2i"]
["Analyst",null,{"$f":"'Project Information'!B6","v":"John Smith"},null,null,"Roadway",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$19:$H$92,2,FALSE)","v":{"$error":"#N/A"}}]
["Agency or Company",null,{"$f":"'Project Information'!B7","v":"ABC Company"},null,null,"Location Information",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$19:$H$92,3,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leg #1 CMF:",{"$f":"IF($H$21>0,IF($H$10=\"3ST\",1,IF($H$10=\"4ST\",1,IF($H$22=\"Permissive\",1,IF($H$22=\"Protected\",0.94,0.99)))),1)","v":1}]
["Date Performed",null,{"$f":"'Project Information'!F5","v":"2011-05-12"},null,null,"Jurisdiction",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$19:$H$92,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leg #2 CMF:",{"$f":"IF($H$21>1,IF($H$10=\"3ST\",1,IF($H$10=\"4ST\",1,IF($H$23=\"Permissive\",1,IF($H$23=\"Protected\",0.94,0.99)))),1)","v":1}]
["Intersection",null,"Intersection 1",null,null,"Analysis Year",null,{"$f":"'Project Information'!F6","v":2011},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leg #3 CMF:",{"$f":"IF($H$24=\"Not Applicable\",1,IF($H$10=\"3ST\",1,IF($H$10=\"4ST\",1,IF($H$24=\"Permissive\",1,IF($H24=\"Protected\",0.94,0.99)))))","v":0.99}]
["Signalized/Unsignalized",null,{"$f":"VLOOKUP($C$7,'Project Information'!$A$19:$H$92,6,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"IF($C$8=\"Signalized\",\"Ped Volume (after Intx Type)\",\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,{"$f":"IF(F8=\"Ped Volume (after Intx Type)\",\"Select whether or not ped volume is known\",\"\")","v":{"$error":"#N/A"}}]
["Input Data",null,null,null,null,null,null,"Site Conditions",null,null,null,"Base Conditions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leg #4 CMF:",{"$f":"IF($H$25=\"Not Applicable\",1,IF($H$10=\"3SG\",1,IF($H$10=\"3ST\",1,IF($H$10=\"4ST\",1,IF($H$25=\"Permissive\",1,IF($H$25=\"Protected\",0.94,0.99))))))","v":0.99}]
["Intersection type (3ST, 3SG, 4ST, 4SG)",null,null,null,null,null,null,null,null,null,null,"--",null,null,{"$f":"IF($H$10=\"3ST\",\"Unsignalized three-leg intersection (stop control on minor-road approaches)\",IF($H$10=\"3SG\",\"Signalized three-leg intersections\",IF($H$10=\"4ST\",\"Unsignalized four-leg intersection (stop control on minor-road approaches)\",\"Signalized four-leg intersections\")))","v":"Signalized four-leg intersections"},null,null,null,null,null,null,null,null,null,null,null,"Composite Value:",{"$f":"AB5*AB6*AB7*AB9","v":0.98009999999999997}]
["AADT major (veh/day) (total entering on major approaches)*",null,null,null,"AADTMAX =",{"$f":"IF($H$10=\"3ST\",45700,IF($H$10=\"4ST\",46800,IF($H$10=\"3SG\",58100,67700)))","v":67700},"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(H11>F11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["AADT minor (veh/day) (total entering on minor approaches)*",null,null,null,"AADTMAX =",{"$f":"IF($H$10=\"3ST\",9300,IF($H$10=\"4ST\",5900,IF($H$10=\"3SG\",16400,33400)))","v":33400},"(veh/day)",null,null,null,null,"--",null,null,{"$f":"IF(H12>F12,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Intersection lighting (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present"]
["Calibration factor, Ci",null,null,null,null,null,null,1,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations for CMF6i"]
["Data for unsignalized intersections only:"]
["           Number of major-road approaches with left-turn lanes (0,1,2)",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pramv(FI) :",{"$f":"IF('Intersection Tables'!$C$33=\"No\",(IF($J$10=\"3ST\",'Intersection Tables'!$D$39,IF($J$10=\"3SG\",'Intersection Tables'!$F$39,IF($J$10=\"4ST\",'Intersection Tables'!$H$39,'Intersection Tables'!$J$39)))),(IF($J$10=\"3ST\",'Intersection Tables'!$D$48,IF($J$10=\"3SG\",'Intersection Tables'!$F$48,IF($J$10=\"4ST\",'Intersection Tables'!$H$48,'Intersection Tables'!$J$48)))))","v":0.34699999999999998},"premv(FI) :",{"$f":"IF('Intersection Tables'!$C$33=\"No\",(IF($J$10=\"3ST\",'Intersection Tables'!$D$37,IF($J$10=\"3SG\",'Intersection Tables'!$F$37,IF($J$10=\"4ST\",'Intersection Tables'!$H$37,'Intersection Tables'!$J$37)))),(IF($J$10=\"3ST\",'Intersection Tables'!$D$46,IF($J$10=\"3SG\",'Intersection Tables'!$F$46,IF($J$10=\"4ST\",'Intersection Tables'!$H$46,'Intersection Tables'!$J$46)))))","v":0.45}]
["           Number of major-road approaches with right-turn lanes (0,1,2)",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pramv(PDO) :",{"$f":"IF('Intersection Tables'!$C$33=\"No\",(IF($J$10=\"3ST\",'Intersection Tables'!$E$39,IF($J$10=\"3SG\",'Intersection Tables'!$G$39,IF($J$10=\"4ST\",'Intersection Tables'!$I$39,'Intersection Tables'!$K$39)))),(IF($J$10=\"3ST\",'Intersection Tables'!$E$48,IF($J$10=\"3SG\",'Intersection Tables'!$G$48,IF($J$10=\"4ST\",'Intersection Tables'!$I$48,'Intersection Tables'!$K$48)))))","v":0.24399999999999999},"premv(PDO) :",{"$f":"IF('Intersection Tables'!$C$33=\"No\",(IF($J$10=\"3ST\",'Intersection Tables'!$E$37,IF($J$10=\"3SG\",'Intersection Tables'!$G$37,IF($J$10=\"4ST\",'Intersection Tables'!$I$37,'Intersection Tables'!$K$37)))),(IF($J$10=\"3ST\",'Intersection Tables'!$E$46,IF($J$10=\"3SG\",'Intersection Tables'!$G$46,IF($J$10=\"4ST\",'Intersection Tables'!$I$46,'Intersection Tables'!$K$46)))))","v":0.48299999999999998}]
["Data for signalized intersections only:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nbimv(FI) :",{"$f":"+$K$59","v":{"$error":"#N/A"}},"Nbimv(FI) :",{"$f":"+$K$59","v":{"$error":"#N/A"}}]
["           Number of approaches with left-turn lanes (0,1,2,3,4) [for 3SG, use maximum value of 3]",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nbimv(PDO) :",{"$f":"+$K$61","v":{"$error":"#N/A"}},"Nbimv(PDO) :",{"$f":"+$K$61","v":{"$error":"#N/A"}}]
["           Number of approaches with right-turn lanes (0,1,2,3,4) [for 3SG, use maximum value of 3]",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nbisv :",{"$f":"+$H$90","v":{"$error":"#N/A"}},"Nbisv :",{"$f":"+$H$90","v":{"$error":"#N/A"}}]
["           Number of approaches with left-turn signal phasing [for 3SG, use maximum value of 3]",null,null,null,null,null,null,0,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pra :",{"$f":"((+AB16*AB18)+(+AB17*AB19))/(+AB18+AB19+AB20)","v":{"$error":"#N/A"}},"pre :",{"$f":"((+AD16*AD18)+(+AD17*AD19))/(+AD18+AD19+AD20)","v":{"$error":"#N/A"}}]
["           Type of left-turn signal phasing for Leg #1",null,null,null,null,null,null,"Permissive",null,null,null,"Permissive"]
["           Type of left-turn signal phasing for Leg #2",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CMF6i :",{"$f":"1-(AB21*(1-0.74))-(AD21*(1-1.18))","v":{"$error":"#N/A"}}]
["           Type of left-turn signal phasing for Leg #3",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,1,"Link",1]
["           Type of left-turn signal phasing for Leg #4 (if applicable)",null,null,null,null,null,null,null,null,null,null,"--"]
["           Number of approaches with right-turn-on-red prohibited [for 3SG, use maximum value of 3]",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"\"\"","v":""},null,"3SG","4SG"]
["           Intersection red light cameras (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Not Applicable",2,"Known",null,1700]
["           Sum of all pedestrian crossing volumes  (PedVol) -- Signalized intersections only",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Permissive",3,"Not Known",null,750]
["           Maximum number of lanes crossed by a pedestrian (nlanesx)",null,null,null,null,null,null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Protected",null,null,null,400,null,null,null,null,"Base AADT"]
["           Number of bus stops within 300 m (1,000 ft) of the intersection",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Protected/Permissive",null,null,null,120]
["           Schools within 300 m (1,000 ft) of the intersection (present/not present)",null,null,null,null,null,null,"Not Present",null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Permissive/Protected",null,null,null,20]
["           Number of alcohol sales establishments within 300 m (1,000 ft) of the intersection",null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Input"]
["Average Annual Crash History (3 or 5-yr average)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3SG",null,3200]
["           Multiple vehicle crashes",null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,null,null,"If inputs are complete, click for next element",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4SG",null,1500]
[null,null,null,null,"PDO","Property Damage Only",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3ST",null,700]
["           Single-vehicle crashes",null,null,null,"KABC","Fatal and Injury Only",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4ST",null,240]
[null,null,null,null,"PDO","Property Damage Only",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
["NOTES: * AADT: It is important to remember that the AADT(major) = AADT(major approach1) + AADT(minor approach2) (refer to p.12-8 in Part C of the HSM)"]
[]
[]
["WORKSHEET 2B -- CRASH MODIFICATION FACTORS FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["CMF for Left-Turn Lanes",null,"CMF for Left-Turn Signal Phasing",null,"CMF for Right-Turn Lanes",null,"CMF for Right Turn on Red",null,"CMF for Lighting",null,"CMF for Red Light Cameras",null,"Combined CMF"]
[]
["CMF 1i",null,"CMF 2i",null,"CMF 3i",null,"CMF 4i",null,"CMF 5i",null,"CMF 6i",null,"CMF COMB"]
["from Table 12-24",null,"from Table 12-25",null,"from Table 12-26",null,"from Equation 12-35",null,"from Equation 12-36",null,"from Equation 12-37",null,"(1)*(2)*(3)*(4)*(5)*(6)"]
[{"$f":"IF(H10=\"3ST\",IF(H16=0,1,IF(H16=1,'Intersection Tables'!AB9,'Intersection Tables'!AC9)),IF(H10=\"4ST\",IF(H16=0,1,IF(H16=1,'Intersection Tables'!AB11,'Intersection Tables'!AC11)),IF(H19=0,1,IF(H19=1,VLOOKUP(H10,'Intersection Tables'!Y10:AE12,4,FALSE),IF(H19=2,VLOOKUP(H10,'Intersection Tables'!Y10:AE12,5,FALSE),IF(H19=3,VLOOKUP(H10,'Intersection Tables'!Y10:AE12,6,FALSE),VLOOKUP(H10,'Intersection Tables'!Y10:AE12,7,FALSE)))))))","v":1},null,{"$f":"IF($H$10=\"3ST\",1,IF($H$10=\"4ST\",1,AB10))","v":0.98009999999999997},null,{"$f":"IF(H10=\"3ST\",IF(H17=0,1,IF(H17=1,'Intersection Tables'!AB24,'Intersection Tables'!AC24)),IF(H10=\"4ST\",IF(H17=0,1,IF(H17=1,'Intersection Tables'!AB26,'Intersection Tables'!AC26)),IF(H20=0,1,IF(H20=1,VLOOKUP(H10,'Intersection Tables'!Y24:AE27,4,FALSE),IF(H20=2,VLOOKUP(H10,'Intersection Tables'!Y24:AE27,5,FALSE),IF(H20=3,VLOOKUP(H10,'Intersection Tables'!Y24:AE27,6,FALSE),VLOOKUP(H10,'Intersection Tables'!Y24:AE27,7,FALSE)))))))","v":1},null,{"$f":"IF($H$10=\"3ST\",1,IF(H$10=\"4ST\",1,POWER(0.98,$H$26)))","v":1},null,{"$f":"IF($H$13=\"Not Present\",1,(1-(IF('Intersection Tables'!$C$81=\"No\",VLOOKUP($H$10,'Intersection Tables'!$B$84:$G$87,3,FALSE),VLOOKUP($H$10,'Intersection Tables'!$B$84:$G$87,5,FALSE)))*0.38))","v":1},null,{"$f":"IF(RIGHT(H10,2)=\"SG\",IF($H$27=\"Not Present\",1,$AB$23),1)","v":1},null,{"$f":"+A48*C48*E48*G48*I48*K48","v":0.98009999999999997}]
[]
[]
["WORKSHEET 2C -- MULTIPLE-VEHICLE COLLISIONS BY SEVERITY LEVEL FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,"(2)",null,null,"(3)",null,"(4)","(5)",null,"(6)","(7)","(8)","(6)*(7)*(8)"]
["Crash Severity Level",null,"SPF Coefficients",null,null,"Overdispersion Parameter, k",null,"Initial Nbimv","Proportion of Total Crashes",null,"Adjusted Nbimv","Combined CMFs","Calibration Factor, Ci","Predicted Nbimv"]
[]
[null,null,"from Table 12-10",null,null,"from Table 12-10",null,"from Equation 12-21",null,null,"(4)TOTAL*(5)","(7) from Worksheet 2B"]
[null,null,"a","b","c"]
["Total",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$9:$F$12,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$9:$F$12,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$9:$F$12,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$9:$F$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP(C58+(D58*LN($H$11))+(E58*LN($H$12)))","v":{"$error":"#N/A"}},1,null,{"$f":"H58*I58","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K58*L58*M58","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$14:$F$17,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$14:$F$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$14:$F$17,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$14:$F$17,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP(C59+(D59*LN($H$11))+(E59*LN($H$12)))","v":{"$error":"#N/A"}},"(4)FI/((4)FI+(4)PDO)",null,{"$f":"H58*I60","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K59*L59*M59","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"+H59/(H59+H61)","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$19:$F$22,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$19:$F$22,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$19:$F$22,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$B$19:$F$22,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP(C61+(D61*LN($H$11))+(E61*LN($H$12)))","v":{"$error":"#N/A"}},"(5)TOTAL-(5)FI",null,{"$f":"H58*I62","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K61*L61*M61","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"I58-I60","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 2D -- MULTIPLE-VEHICLE COLLISIONS BY COLLISION TYPE FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)"]
["Collision Type",null,null,"Proportion of Collision Type(FI)",null,"Predicted N bimv (FI) (crashes/year)",null,"Proportion of Collision Type (PDO)",null,"Predicted N bimv (PDO) (crashes/year)",null,"Predicted N bimv (TOTAL) (crashes/year)"]
[]
[]
[null,null,null,"from Table 12-11",null,"(9)FI from Worksheet 2C",null,"from Table 12-11",null,"(9)PDO from Worksheet 2C",null,"(9)PDO from Worksheet 2C"]
[]
["Total",null,null,1,null,{"$f":"+N59","v":{"$error":"#N/A"}},null,1,null,{"$f":"N61","v":{"$error":"#N/A"}},null,{"$f":"+N58","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"(2)*(3)FI",null,null,null,"(4)*(5)PDO",null,"(3)+(5)"]
["Rear-end collision",null,null,{"$f":"IF('Intersection Tables'!$C$33=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$35:$K$41,3,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$44:$K$50,3,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D75*$F$73","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$33=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E37,IF($H$10=\"3SG\",'Intersection Tables'!G37,IF($H$10=\"4ST\",'Intersection Tables'!I37,'Intersection Tables'!K37))),IF($H$10=\"3ST\",'Intersection Tables'!E46,IF($H$10=\"3SG\",'Intersection Tables'!G46,IF($H$10=\"4ST\",'Intersection Tables'!I46,'Intersection Tables'!K46))))","v":0.48299999999999998},null,{"$f":"+H75*$J$73","v":{"$error":"#N/A"}},null,{"$f":"+F75+J75","v":{"$error":"#N/A"}}]
["Head-on collision",null,null,{"$f":"IF('Intersection Tables'!$C$33=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$35:$K$41,4,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$44:$K$50,4,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D76*$F$73","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$33=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E38,IF($H$10=\"3SG\",'Intersection Tables'!G38,IF($H$10=\"4ST\",'Intersection Tables'!I38,'Intersection Tables'!K38))),IF($H$10=\"3ST\",'Intersection Tables'!E47,IF($H$10=\"3SG\",'Intersection Tables'!G47,IF($H$10=\"4ST\",'Intersection Tables'!I47,'Intersection Tables'!K47))))","v":0.03},null,{"$f":"+H76*$J$73","v":{"$error":"#N/A"}},null,{"$f":"+F76+J76","v":{"$error":"#N/A"}}]
["Angle collision",null,null,{"$f":"IF('Intersection Tables'!$C$33=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$35:$K$41,5,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$44:$K$50,5,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D77*$F$73","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$33=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E39,IF($H$10=\"3SG\",'Intersection Tables'!G39,IF($H$10=\"4ST\",'Intersection Tables'!I39,'Intersection Tables'!K39))),IF($H$10=\"3ST\",'Intersection Tables'!E48,IF($H$10=\"3SG\",'Intersection Tables'!G48,IF($H$10=\"4ST\",'Intersection Tables'!I48,'Intersection Tables'!K48))))","v":0.24399999999999999},null,{"$f":"+H77*$J$73","v":{"$error":"#N/A"}},null,{"$f":"+F77+J77","v":{"$error":"#N/A"}}]
["Sideswipe",null,null,{"$f":"IF('Intersection Tables'!$C$33=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$35:$K$41,6,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$44:$K$50,6,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D78*$F$73","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$33=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E40,IF($H$10=\"3SG\",'Intersection Tables'!G40,IF($H$10=\"4ST\",'Intersection Tables'!I40,'Intersection Tables'!K40))),IF($H$10=\"3ST\",'Intersection Tables'!E49,IF($H$10=\"3SG\",'Intersection Tables'!G49,IF($H$10=\"4ST\",'Intersection Tables'!I49,'Intersection Tables'!K49))))","v":3.2000000000000001E-2},null,{"$f":"+H78*$J$73","v":{"$error":"#N/A"}},null,{"$f":"+F78+J78","v":{"$error":"#N/A"}}]
["Other multiple-vehicle collision",null,null,{"$f":"IF('Intersection Tables'!$C$33=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$35:$K$41,7,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$44:$K$50,7,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D79*$F$73","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$33=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E41,IF($H$10=\"3SG\",'Intersection Tables'!G41,IF($H$10=\"4ST\",'Intersection Tables'!I41,'Intersection Tables'!K41))),IF($H$10=\"3ST\",'Intersection Tables'!E50,IF($H$10=\"3SG\",'Intersection Tables'!G50,IF($H$10=\"4ST\",'Intersection Tables'!I50,'Intersection Tables'!K50))))","v":0.21099999999999999},null,{"$f":"+H79*$J$73","v":{"$error":"#N/A"}},null,{"$f":"+F79+J79","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 2E -- SINGLE-VEHICLE COLLISIONS BY SEVERITY LEVEL FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,"(2)",null,null,"(3)",null,"(4)","(5)",null,"(6)","(7)","(8)","(9)"]
["Crash Severity Level",null,"SPF Coefficients",null,null,"Overdispersion Parameter, k",null,"Initial Nbisv","Proportion of Total Crashes",null,"Adjusted Nbimv","Combined CMFs","Calibration Factor, Ci","Predicted Nbisv"]
[]
[null,null,"from Table 12-12",null,null,"from Table 12-12",null,"from Eqn. 12-24; (FI) from Eqn. 12-24 or 12-27",null,null,"(4)TOTAL*(5)","(7) from Worksheet 2B",null,"(6)*(7)*(8)"]
[null,null,"a","b","c"]
[]
["Total",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$9:$M$12,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$9:$M$12,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$9:$M$12,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$9:$M$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP(C90+(D90*LN($H$11))+(E90*LN($H$12)))","v":{"$error":"#N/A"}},1,null,{"$f":"H90*I90","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K90*L90*M90","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$14:$M$17,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$14:$M$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$14:$M$17,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$14:$M$17,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(H10=\"3ST\",H90*0.31,IF(H10=\"4ST\",H90*0.28,(EXP(C91+(D91*LN($H$11))+(E91*LN($H$12))))))","v":{"$error":"#N/A"}},"(4)FI/((4)FI+(4)PDO)",null,{"$f":"H90*I92","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K91*L91*M91","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"+H91/(H91+H93)","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$19:$M$22,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$19:$M$22,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$19:$M$22,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($H$10,'Intersection Tables'!$I$19:$M$22,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"EXP(C93+(D93*LN($H$11))+(E93*LN($H$12)))","v":{"$error":"#N/A"}},"(5)TOTAL-(5)FI",null,{"$f":"H90*I94","v":{"$error":"#N/A"}},{"$f":"+M48","v":0.98009999999999997},{"$f":"+$H$14","v":1},{"$f":"+K93*L93*M93","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,{"$f":"I90-I92","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 2F -- SINGLE-VEHICLE COLLISIONS BY COLLISION TYPE FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)",null,"(5)",null,"(6)"]
["Collision Type",null,null,"Proportion of Collision Type(FI)",null,"Predicted N bisv (FI) (crashes/year)",null,"Proportion of Collision Type (PDO)",null,"Predicted N bisv (PDO) (crashes/year)",null,"Predicted N bisv (TOTAL) (crashes/year)"]
[]
[]
[null,null,null,"from Table 12-13",null,"(9)FI from Worksheet 2E",null,"from Table 12-13",null,"(9)PDO from Worksheet 2E",null,"(9)PDO from Worksheet 2E"]
[]
["Total",null,null,1,null,{"$f":"+N91","v":{"$error":"#N/A"}},null,1,null,{"$f":"+N93","v":{"$error":"#N/A"}},null,{"$f":"+N90","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"(2)*(3)FI",null,null,null,"(4)*(5)PDO",null,"(3)+(5)"]
["Collision with parked vehicle",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,3,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,3,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"+D107*$F$105","v":{"$error":"#N/A"}},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E60,IF($H$10=\"3SG\",'Intersection Tables'!G60,IF($H$10=\"4ST\",'Intersection Tables'!I60,'Intersection Tables'!K60))),IF($H$10=\"3ST\",'Intersection Tables'!E70,IF($H$10=\"3SG\",'Intersection Tables'!G70,IF($H$10=\"4ST\",'Intersection Tables'!I70,'Intersection Tables'!K70))))","v":1E-3},null,{"$f":"+H107*$J$105","v":{"$error":"#N/A"}},null,{"$f":"+F107+J107","v":{"$error":"#N/A"}}]
["Collision with animal",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,4,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,4,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E61,IF($H$10=\"3SG\",'Intersection Tables'!G61,IF($H$10=\"4ST\",'Intersection Tables'!I61,'Intersection Tables'!K61))),IF($H$10=\"3ST\",'Intersection Tables'!E71,IF($H$10=\"3SG\",'Intersection Tables'!G71,IF($H$10=\"4ST\",'Intersection Tables'!I71,'Intersection Tables'!K71))))","v":2E-3},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Collision with fixed object",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,5,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,5,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E62,IF($H$10=\"3SG\",'Intersection Tables'!G62,IF($H$10=\"4ST\",'Intersection Tables'!I62,'Intersection Tables'!K62))),IF($H$10=\"3ST\",'Intersection Tables'!E72,IF($H$10=\"3SG\",'Intersection Tables'!G72,IF($H$10=\"4ST\",'Intersection Tables'!I72,'Intersection Tables'!K72))))","v":0.87},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Collision with other object",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,6,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,6,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E63,IF($H$10=\"3SG\",'Intersection Tables'!G63,IF($H$10=\"4ST\",'Intersection Tables'!I63,'Intersection Tables'!K63))),IF($H$10=\"3ST\",'Intersection Tables'!E73,IF($H$10=\"3SG\",'Intersection Tables'!G73,IF($H$10=\"4ST\",'Intersection Tables'!I73,'Intersection Tables'!K73))))","v":7.0000000000000007E-2},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Other single-vehicle collision",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,7,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,7,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E64,IF($H$10=\"3SG\",'Intersection Tables'!G64,IF($H$10=\"4ST\",'Intersection Tables'!I64,'Intersection Tables'!K64))),IF($H$10=\"3ST\",'Intersection Tables'!E74,IF($H$10=\"3SG\",'Intersection Tables'!G74,IF($H$10=\"4ST\",'Intersection Tables'!I74,'Intersection Tables'!K74))))","v":2.3E-2},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
["Single-vehicle noncollision",null,null,{"$f":"IF('Intersection Tables'!$C$56=\"No\", HLOOKUP($H$10,'Intersection Tables'!$B$58:$K$65,8,FALSE),HLOOKUP($H$10,'Intersection Tables'!$B$68:$K$75,8,FALSE))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},null,{"$f":"IF('Intersection Tables'!$C$56=\"No\",IF($H$10=\"3ST\",'Intersection Tables'!E65,IF($H$10=\"3SG\",'Intersection Tables'!G65,IF($H$10=\"4ST\",'Intersection Tables'!I65,'Intersection Tables'!K65))),IF($H$10=\"3ST\",'Intersection Tables'!E75,IF($H$10=\"3SG\",'Intersection Tables'!G75,IF($H$10=\"4ST\",'Intersection Tables'!I75,'Intersection Tables'!K75))))","v":3.4000000000000002E-2},null,{"$error":"#N/A"},null,{"$error":"#N/A"}]
[]
[]
["WORKSHEET 2G -- VEHICLE-PEDESTRIAN COLLISIONS FOR URBAN AND SUBURBAN ARTERIAL STOP-CONTROLLED INTERSECTIONS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)","(5)",null,"(6)",null,"(7)"]
["Crash Severity Level",null,null,"Predicted Nbimv",null,"Predicted Nbisv",null,"Predicted Nbi","fpedi",null,"Calibration factor, Ci",null,"Predicted Npedi"]
[]
[null,null,null,"(9) from Worksheet 2C",null,"(9) from Worksheet 2E",null,"(2) + (3)","from Table 12-16",null,null,null,"(4)*(5)*(6)"]
[]
["Total",null,null,{"$f":"IF($H$10=\"3SG\",\"--\",IF($H$10=\"4SG\",\"--\",N58))","v":{"$error":"#N/A"}},null,{"$f":"IF($H$10=\"3SG\",\"--\",IF($H$10=\"4SG\",\"--\",N90))","v":{"$error":"#N/A"}},null,{"$f":"IF($H$10=\"3SG\",\"--\",IF($H$10=\"4SG\",\"--\",(D122+F122)))","v":{"$error":"#N/A"}},{"$f":"IF(H10=\"3ST\",0.021,IF(H10=\"4ST\",0.022,\"--\"))","v":"--"},null,{"$f":"+$H$14","v":1},null,{"$f":"IF(H10=\"3SG\",\"--\",IF(H10=\"4SG\",\"--\",$H$122*$I$122*$K$122))","v":{"$error":"#N/A"}}]
["Fatal and injury (FI)",null,null,"--",null,"--",null,"--","--",null,{"$f":"+$H$14","v":1},null,{"$f":"+M122","v":{"$error":"#N/A"}}]
[]
[]
[null,"WORKSHEET 2H -- CRASH MODIFICATION FACTORS FOR VEHICLE-PEDESTRIAN COLLISIONS FOR URBAN AND SUBURBAN ARTERIAL SIGNALIZED INTERSECTIONS"]
[]
[null,"(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)"]
[null,"CMF for Bus Stops",null,null,"CMF for Schools",null,null,"CMF for Alcohol Sales Establishments",null,null,"Combined CMF"]
[null,"CMF1p",null,null,"CMF2p",null,null,"CMF3p"]
[null,"from Table 12-28",null,null,"from Table 12-29",null,null,"from Table 12-30",null,null,"(1)*(2)*(3)"]
[null,{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",IF($H$30=0,1,IF($H$30=\"1 or 2\",2.78,4.15))))","v":1},null,null,{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",IF($H$31=\"Present\",1.35,1)))","v":1},null,null,{"$f":"IF(H10=\"3ST\",\"--\",IF(H10=\"4ST\",\"--\",IF(H32=0,1,IF(H32=\"1 to 8\",1.12,1.56))))","v":1},null,null,{"$f":"IF(H10=\"3ST\",\"--\",IF(H10=\"4ST\",\"--\",B132*E132*H132))","v":1}]
[]
[]
["WORKSHEET 2I -- VEHICLE-PEDESTRIAN COLLISIONS FOR URBAN AND SUBURBAN ARTERIAL SIGNALIZED INTERSECTIONS"]
[]
["(1)",null,"(2)",null,null,null,null,"(3)","(4)",null,"(5)",null,"(6)","(7)"]
["Crash Severity Level",null,"SPF Coefficients",null,null,null,null,"Overdispersion Parameter, k","Npedbase",null,"Combined CMF",null,"Calibration factor, Ci","Predicted Npedi"]
[]
[null,null,"from Table 12-14",null,null,null,null,null,"from Equation 12-29",null,"(4) from Worksheet 2H",null,null,"(4)*(5)*(6)"]
[null,null,"a","b","c","d","e"]
["Total",null,{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,2,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,3,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,4,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,5,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,6,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(VLOOKUP($H$10,'Intersection Tables'!$P$9:$V$10,7,FALSE))))","v":{"$error":"#N/A"}},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",EXP(+$C142+($D142*LN($H$11+H$12))+(E$142*LN($H$12/$H$11))+(F$142*LN($H$28))+(G$142*$H$29))))","v":{"$error":"#N/A"}},null,{"$f":"+$K$132","v":1},null,{"$f":"+$H$14","v":1},{"$f":"IF($H$10=\"3ST\",\"--\",IF($H$10=\"4ST\",\"--\",(I142*K142*M142)))","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,"--","--","--","--","--","--","--",null,"--",null,{"$f":"+$H$14","v":1},{"$f":"N142","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 2J -- VEHICLE-BICYCLE COLLISIONS FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,null,"(2)",null,"(3)",null,"(4)","(5)",null,"(6)",null,"(7)"]
["Crash Severity Level",null,null,"Predicted Nbimv",null,"Predicted Nbisv",null,"Predicted Nbi","fbikei",null,"Calibration factor, Ci",null,"Predicted Nbikei"]
[]
[null,null,null,"(9) from Worksheet 2C",null,"(9) from Worksheet 2E",null,"(2) + (3)","from Table 12-17",null,null,null,"(4)*(5)*(6)"]
[]
["Total",null,null,{"$f":"+$N$58","v":{"$error":"#N/A"}},null,{"$f":"+$N$90","v":{"$error":"#N/A"}},null,{"$f":"+D153+F153","v":{"$error":"#N/A"}},{"$f":"IF(H10=\"3ST\",0.016,IF(H10=\"3SG\",0.011,IF(H10=\"4ST\",0.018,0.015)))","v":1.4999999999999999E-2},null,{"$f":"+$H$14","v":1},null,{"$f":"+$H$153*$I$153*K153","v":{"$error":"#N/A"}}]
["Fatal and injury (FI)",null,null,"--",null,"--",null,"--","--",null,{"$f":"+$H$14","v":1},null,{"$f":"+$H$153*$I$153*K154","v":{"$error":"#N/A"}}]
[]
[]
["WORKSHEET 2K -- CRASH SEVERITY DISTRIBUTION FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
["(1)",null,null,null,null,"(2)",null,null,"(3)",null,null,"(4)"]
["Collision type",null,null,null,null,"Fatal and injury (FI)",null,null,"Property damage only (PDO)",null,null,"Total"]
[null,null,null,null,null,"(3) from Worksheet 2D and 2F;",null,null,"(5) from Worksheet 2D and 2F",null,null,"(6) from Worksheet 2D and 2F;"]
[null,null,null,null,null,"(7) from 2G or 2I and 2J",null,null,null,null,null,"(7) from 2G or 2I and 2J"]
["MULTIPLE-VEHICLE"]
["Rear-end collisions (from Worksheet 2D)",null,null,null,null,{"$f":"+F75","v":{"$error":"#N/A"}},null,null,{"$f":"+J75","v":{"$error":"#N/A"}},null,null,{"$f":"+L75","v":{"$error":"#N/A"}}]
["Head-on collisions (from Worksheet 2D)",null,null,null,null,{"$f":"+F76","v":{"$error":"#N/A"}},null,null,{"$f":"+J76","v":{"$error":"#N/A"}},null,null,{"$f":"+L76","v":{"$error":"#N/A"}}]
["Angle collisions (from Worksheet 2D)",null,null,null,null,{"$f":"+F77","v":{"$error":"#N/A"}},null,null,{"$f":"+J77","v":{"$error":"#N/A"}},null,null,{"$f":"+L77","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"MV","KABCO",{"$f":"+L169","v":{"$error":"#N/A"}},"L162"]
["Sideswipe (from Worksheet 2D)",null,null,null,null,{"$f":"+F78","v":{"$error":"#N/A"}},null,null,{"$f":"+J78","v":{"$error":"#N/A"}},null,null,{"$f":"+L78","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KABC",{"$f":"+F169","v":{"$error":"#N/A"}},"F162"]
["Other multiple-vehicle collision (from Worksheet 2D)",null,null,null,null,{"$f":"+F79","v":{"$error":"#N/A"}},null,null,{"$f":"+J79","v":{"$error":"#N/A"}},null,null,{"$f":"+L79","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"+I169","v":{"$error":"#N/A"}},"I162"]
["Subtotal",null,null,null,null,{"$f":"SUM(F164:H168)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(I164:K168)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(L164:N168)","v":{"$error":"#N/A"}}]
["SINGLE-VEHICLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SV","KABCO",{"$f":"+L179","v":{"$error":"#N/A"}},"L172"]
["Collision with parked vehicle (from Worksheet 2F)",null,null,null,null,{"$f":"+F107","v":{"$error":"#N/A"}},null,null,{"$f":"+J107","v":{"$error":"#N/A"}},null,null,{"$f":"+L107","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KABC",{"$f":"+F179","v":{"$error":"#N/A"}},"F172"]
["Collision with animal (from Worksheet 2F)",null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO",{"$f":"+I179","v":{"$error":"#N/A"}},"I172"]
["Collision with fixed object (from Worksheet 2F)",null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
["Collision with other object (from Worksheet 2F)",null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,"VPED",null,{"$f":"+N142","v":{"$error":"#N/A"}},"N135"]
["Other single-vehicle collision (from Worksheet 2F)",null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,"VBICYCLE",null,{"$f":"+M153","v":{"$error":"#N/A"}},"M146"]
["Single-vehicle noncollision (from Worksheet 2F)",null,null,null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
["Collision with pedestrian (from Worksheet 2G or 2I)",null,null,null,null,{"$f":"IF(H10=\"3ST\",M123,IF(H10=\"4ST\",M123,N143))","v":{"$error":"#N/A"}},null,null,0,null,null,{"$f":"+F177+I177","v":{"$error":"#N/A"}}]
["Collision with bicycle (from Worksheet 2J)",null,null,null,null,{"$f":"+M154","v":{"$error":"#N/A"}},null,null,0,null,null,{"$f":"+F178+I178","v":{"$error":"#N/A"}}]
["Subtotal",null,null,null,null,{"$f":"SUM(F171:H178)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(I171:K178)","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(L171:N178)","v":{"$error":"#N/A"}}]
["Total",null,null,null,null,{"$f":"+F169+F179","v":{"$error":"#N/A"}},null,null,{"$f":"+I169+I179","v":{"$error":"#N/A"}},null,null,{"$f":"+L169+L179","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"WORKSHEET 2L -- SUMMARY RESULTS FOR URBAN AND SUBURBAN ARTERIAL INTERSECTIONS"]
[]
[null,null,"(1)",null,null,null,null,"(2)"]
[null,null,"Crash severity level",null,null,null,null,"Predicted average crash frequency, Npredicted int (crashes/year)"]
[]
[]
[null,null,null,null,null,null,null,"(Total) from Worksheet 2K"]
[null,null,"Total",null,null,null,null,{"$f":"+L180","v":{"$error":"#N/A"}}]
[null,null,"Fatal and injury (FI)",null,null,null,null,{"$f":"+F180","v":{"$error":"#N/A"}}]
[null,null,"Property damage only (PDO)",null,null,null,null,{"$f":"+I180","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,"PROJECT ELEMENT RESULTS SUMMARY1"]
[]
[null,null,"Summary for the project element","Total Crashes/yr",null,null,"Fatal and Injury Crashes/yr",null,null,"Property Damage Only Crashes/yr"]
[null,null,null,"(KABCO)",null,null,"(KABC)",null,null,"(PDO)"]
[null,null,null,"Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency ","Potential for Improvement ","Predicted average crash frequency","Expected average crash frequency","Potential for Improvement"]
[null,null,null,"Npredicted (KABCO)","Nexpected (KABCO)",null,"Npredicted (KABC)","Nexpected (KABC)",null,"Npredicted (O)","Nexpected (O)"]
[null,null,null,{"$f":"ROUND(H190,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",ROUND(SUMIF('Urban Site Total'!$B$14:$C$37,$C$7,'Urban Site Total'!$L$14:$L$37)+L177+L178,1),0)","v":0},{"$f":"+IF('Project Information'!$F$11=\"Predicted & Expected\",(+ROUND(+IF(E202>D202,E202-D202,0),1)),0)","v":0},{"$f":"ROUND(H191,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+$E$202*$G$202/$D$202),1),0)","v":0},{"$f":"+IF('Project Information'!$F$11=\"Predicted & Expected\",(+ROUND(+IF(H202>G202,H202-G202,0),1)),0)","v":0},{"$f":"ROUND(H192,1)","v":{"$error":"#N/A"}},{"$f":"IF('Project Information'!$F$11=\"Predicted & Expected\",+ROUND((+$E$202*$J$202/$D$202),1),0)","v":0},{"$f":"+IF('Project Information'!$F$11=\"Predicted & Expected\",(+ROUND(+IF(K202>J202,K202-J202,0),1)),0)","v":0}]
[null,null,"Special Note: When the project element is not included in the analysis the results will all be zeros. In addition if only the analysis only includes determining the predicted average crash frequency (i.e. EB analysis is not carried out), the results will show zero values where EB results are usually displayed."]
[null,null,"1 The values in this table are rounded values.  For unrounded values, refer to Workdheet 1L."]

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

{"sheet":"Multi-Year Summary","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[10,7,10,9],[10,4,10,6],[10,0,11,0],[6,0,6,1],[5,0,5,1],[10,1,10,3],[3,0,3,3],[6,2,6,3],[5,2,5,3],[4,2,4,3],[4,0,4,1]]}
["MULTIPLE-YEAR ANALYSIS SUMMARY FOR URBAN AND SUBURBAN ARTERIALS"]
[]
[]
["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":10,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,12,0,22],[34,0,34,8],[35,0,35,8],[15,0,15,9],[27,0,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[32,0,32,8],[33,0,33,8],[25,0,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,0,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[23,4,23,5],[23,6,23,7],[23,8,23,9],[24,4,24,5],[24,6,24,7],[24,8,24,9],[12,1,12,9],[13,0,13,9],[16,0,17,0],[16,1,16,3],[16,4,16,6],[16,7,16,9],[11,1,11,9],[0,0,0,9],[1,0,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[10,1,10,9]]}
["MULTIPLE YEAR PROJECT SAFETY PERFORMANCE SUMMARY REPORT FOR URBAN AND SUBURBAN ARTERIAL",null,null,null,null,null,null,null,null,null,null,null,"User Work Space"]
["General Information"]
["Project Name",{"$f":"'Project Information'!B3","v":"Practical Case Study"}]
["Project Description",{"$f":"'Project Information'!B4","v":"Three Signalized Intersections"}]
["Reference Number",{"$f":"'Project Information'!B5","v":"STARS Report A-1"}]
["Analyst",{"$f":"'Project Information'!B6","v":"John Smith"}]
["Agency/Company",{"$f":"'Project Information'!B7","v":"ABC Company"}]
["Contact Email",{"$f":"'Project Information'!F3","v":"email"}]
["Contact Phone",{"$f":"'Project Information'!F4","v":1234567891}]
["Date Completed",{"$f":"'Project Information'!F5","v":"2011-05-12"}]
["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 Urban and Suburban Arterial Project"]
[null,null,null,null,"N predicted(PROJECT)",null,"N expected (PROJECT)",null,"N potential for improvement (PROJECT)"]
["Crash severity level",null,null,null,{"$f":"+CONCATENATE(\"Predicted average crash frequency - Average safety performance of projects consisting of similar elements (anticipated total number of crashes over \",B12,\" years)\")","v":"Predicted average crash frequency - Average safety performance of projects consisting of similar elements (anticipated total number of crashes over  years)"},null,{"$f":"+CONCATENATE(\"Expected average crash frequency - Average long-term safety performance of the project (anticipated total number of crashes over \",B12,\" years)\")","v":"Expected average crash frequency - Average long-term safety performance of the project (anticipated total number of crashes over  years)"},null,{"$f":"+CONCATENATE(\"Potential safety performance - Average project performance compared to threshold set by typical other similar projects (anticipated total number of crashes over \",B12,\" years)\")","v":"Potential safety performance - Average project performance compared to threshold set by typical other similar projects (anticipated total number of crashes over  years)"}]
["Fatal and injury crashes (KABC)",null,null,null,{"$f":"+B20","v":0},null,{"$f":"+E20","v":0},null,{"$f":"+IF(G26>E26,+G26-E26,\"N/A\")","v":"N/A"}]
["Property damage only crashes (PDO)",null,null,null,{"$f":"+C20","v":0},null,{"$f":"+F20","v":0},null,{"$f":"+IF(G27>E27,+G27-E27,\"N/A\")","v":"N/A"}]
["Total crashes (KABCO)",null,null,null,{"$f":"+D20","v":0},null,{"$f":"+G20","v":0},null,{"$f":"+IF(G28>E28,+G28-E28,\"N/A\")","v":"N/A"}]
[]
[]
[]
["Discussion of Results"]
[{"$f":"+CONCATENATE(\"Given the potential effects of project characteristics on safety performance and assuming a \",100*B13, \" % growth in AADT over a \",B12, \" year analysis period with \",B11,\" as the base year, results indicate that:\")","v":"Given the potential effects of project characteristics on safety performance and assuming a 0 % growth in AADT over a  year analysis period with  as the base year, results indicate that:"}]
[{"$f":"IFERROR(+CONCATENATE(\"1.  The project is anticipated, on average, to experience \", +ROUND(G28,1),\" crashes  over a \",B12, \" year analysis period (\",+(ROUND(G26,1)),\" fatal and injury crashes; and \",+ROUND(G27,1),\" property damage only crashes).\"),\"\")","v":"1.  The project is anticipated, on average, to experience 0 crashes  over a  year analysis period (0 fatal and injury crashes; and 0 property damage only crashes)."}]
[{"$f":"IFERROR(+CONCATENATE(\"2. A similar project is anticipated, on average, to experience \", +(ROUND(E28,1)),\" crashes  over a \",B12, \" year analysis period (\", +ROUND(E26,1),\" fatal and injury crashes over \",B12,\" years; and \",+ROUND(E27,1),\" property damage only crashes over \",B12,\" years).\"),\"\")","v":"2. A similar project is anticipated, on average, to experience 0 crashes  over a  year analysis period (0 fatal and injury crashes over  years; and 0 property damage only crashes over  years)."}]
[{"$f":"IFERROR(+IF(I28=\"N/A\",\"\",+CONCATENATE(\"3.  It is anticipated the project will have an average potential for safety improvement of \",ROUND(I28,1),\" crashes  over a \",B12, \" year analysis period (\",+ROUND(I26,1),\" fatal and injury crashes over \",B12,\" years; and \",+ROUND(I27,1),\" property damage only crashes over \",B12,\" years).\")),\"\")","v":""}]

{"sheet":"Construction - do not delete","index":11,"n_rows":75,"n_cols":14,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Lane Width",null,"Shoulder Width",null,"RHR"]
[null,9,null,0,null,1]
[null,9.5,null,1,null,2]
[null,10,null,2,null,3]
[null,10.5,null,3,null,4]
[null,11,null,4,null,5]
[null,11.5,null,5,null,6]
[null,12,null,6,null,7]
[null,null,null,7]
[null,null,null,8]
[]
[]
[null,null,null,null,null,null,null,"Centerline",null,"Passing",null,"Local"]
[null,null,null,"Shoulder Type",null,"Spiral",null,"Rumble Strips",null,"Lane",null,"Yes"]
[null,null,null,"Paved",null,"Not Present",null,"Not Present",null,"Not Present",null,"No"]
[null,null,null,"Gravel",null,"Present",null,"Present",null,"Present (1 lane)"]
[null,null,null,"Composite",null,null,null,null,null,"Present (2 lanes)"]
[null,null,null,"Turf"]
[]
[null,null,null,null,null,"TWLTL",null,"Lighting",null,"SpEnforce"]
[null,null,null,null,null,"Not Present",null,"Not Present",null,"Not Present"]
[null,null,null,null,null,"Present",null,"Present",null,"Present"]
[]
[]
[]
[null,null,null,"Itype",null,"Lapproach",null,"Rapproach",null,"Ilight",null,"Differ"]
[null,null,null,"3ST",null,0,null,0,null,"Not Present",null,"Yes"]
[null,null,null,"4ST",null,1,null,1,null,"Present",null,"No"]
[null,null,null,"4SG",null,2,null,2]
[null,null,null,null,null,3,null,3]
[null,null,null,null,null,4,null,4]
[]
[]
[null,null,null,"Mwidth",null,"Division",null,"Sslope",null,"Shld2",null,"Iapproach"]
[null,null,null,10,null,"Divided",null,"1:2 or Steeper",null,0,null,0]
[null,null,null,20,null,"Undivided",null,"1:4",null,1,null,1]
[null,null,null,30,null,null,null,"1:5",null,2,null,2]
[null,null,null,40,null,null,null,"1:6",null,3]
[null,null,null,50,null,null,null,"1:7 or Flatter",null,4]
[null,null,null,60,null,null,null,null,null,5]
[null,null,null,70,null,null,null,null,null,6]
[null,null,null,80,null,null,null,null,null,7]
[null,null,null,90,null,null,null,null,null,8]
[null,null,null,100,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[]
[]
[]
[null,null,null,"Urban / Suburban Fields:"]
[]
[]
[null,null,null,"Rtype",null,"UMedWidth",null,"PresOrNot",null,"OnStreetType",null,"OffsetFO",null,"Posted"]
[null,null,null,"2U",null,"Not Present",null,"Not Present",null,"None",null,2,null,"Posted Speed 30 mph or Lower"]
[null,null,null,"3T",null,10,null,"Present",null,"Parallel (Residential)",null,5,null,"Posted Speed Greater than 30 mph"]
[null,null,null,"4U",null,15,null,null,null,"Parallel (Comm/Ind)",null,10]
[null,null,null,"4D",null,20,null,null,null,"Angle (Residential)",null,15]
[null,null,null,"5T",null,30,null,null,null,"Angle (Comm/Ind)",null,20]
[null,null,null,null,null,40,null,null,null,null,null,25]
[null,null,null,null,null,50,null,null,null,null,null,"≥ 30"]
[null,null,null,null,null,60]
[null,null,null,null,null,70]
[null,null,null,null,null,80]
[null,null,null,null,null,90]
[null,null,null,null,null,100]
[]
[]
[]
[null,null,null,"Tlanes",null,"Itype2",null,"Phasing",null,"UnsigApproach",null,"Phasing2"]
[null,null,null,0,null,"3ST",null,"Permissive",null,0,null,"Not Applicable"]
[null,null,null,1,null,"3SG",null,"Protected",null,1,null,"Permissive"]
[null,null,null,2,null,"4ST",null,"Protected / Permissive",null,2,null,"Protected"]
[null,null,null,3,null,"4SG",null,"Permissive / Protected",null,null,null,"Protected / Permissive"]
[null,null,null,4,null,null,null,null,null,null,null,"Permissive / Protected"]