{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Instructions","Segment1","Segment2","Segment Tables","Intersection1","Intersection2","Intersection Tables","Rural 2-Lane Site Total","Rural 2-Lane Project Total","Construction - Do Not Delete","Segment1 Crash Cost","Segment2 Crash Cost","Segment Summary Costs","Intersection1 Crash Cost","Intersection2 Crash Cost","Intersection Summary Costs","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":60,"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":130,"n_cols":13,"rows_kept":130,"cut":false,"hidden":false,"merged":[[1,1,1,15],[87,1,87,15],[89,1,89,9],[89,11,89,15],[90,1,90,9],[91,1,91,9],[91,11,118,15],[92,1,92,9],[93,1,93,9],[94,1,94,9],[96,1,96,3],[96,4,96,9],[97,4,97,9],[98,4,98,9],[99,4,99,9],[100,4,100,9],[102,1,102,3],[102,4,102,9],[103,4,103,9],[105,1,105,3],[105,4,105,9],[106,4,106,9],[107,4,107,9],[108,4,108,9],[109,4,109,9],[110,1,110,3],[110,4,110,9],[111,4,111,9],[112,1,112,3],[112,4,112,9],[113,4,113,9],[114,4,114,9],[115,1,115,3],[115,4,115,9],[116,4,116,9],[117,4,117,9],[118,4,118,9],[124,4,124,9],[125,4,125,9],[126,4,126,9],[127,4,127,9],[119,4,119,9],[120,4,120,9],[121,4,121,9],[122,4,122,9],[123,4,123,9]]}
[]
[null,"Highway Safety Manual 1st Edition, Volume 2, Chapter 10 -- Predictive Method for Rural Two-Lane, Two-Way Roads -- Analysis Spreadsheet Summary"]
[]
[null,"Overview",null,null,null,null,null,null,null,null,"Color Coding in the Worksheets"]
[]
[null,"This spreadsheet has been developed to demonstrate the predictive models",null,null,null,null,null,null,null,null,"The worksheets include three specific color options to help users"]
[null,"for rural two-lane highways as contained in the new Highway Safety Manual.",null,null,null,null,null,null,null,null,"identify locations where input data is required.  In some cases,"]
[null,"The content was developed for training purposes and all users should",null,null,null,null,null,null,null,null,"the shaded cells require the user to input specific numbers. In"]
[null,"verify that the answers they obtain with these worksheets correctly",null,null,null,null,null,null,null,null,"other cases the input is restricted to a select set of options"]
[null,"represent their target analysis.",null,null,null,null,null,null,null,null,"included in pull-down lists. The respective color coding is as"]
[null,null,null,null,null,null,null,null,null,null,"follows:"]
[]
[null,"The page tabs shown at the bottom of this file represent the various analyses",null,null,null,null,null,null,null,null,"Color Used",null,"Type of Information Required from User"]
[null,"that can be performed using this spreadsheet tool and the HSM predictive"]
[null,"methods. A user can evaluate an individual road segment or intersection as",null,null,null,null,null,null,null,null,null,null,"Required input information as identified"]
[null,"well as analyze multiple road segments and intersections. If more than one",null,null,null,null,null,null,null,null,null,null,"in the HSM."]
[null,"segment type requires analysis, the user should create a blank worksheet"]
[null,"and then copy the contents of the segment worksheet into the blank",null,null,null,null,null,null,null,null,null,null,"Input data required from the user but "]
[null,"sheet and name the worksheet accordingly.",null,null,null,null,null,null,null,null,null,null,"restricted to options provided in pull-down"]
[null,null,null,null,null,null,null,null,null,null,null,null,"boxes."]
[]
[null,"The current contents of this spreadsheet include the following:",null,null,null,null,null,null,null,null,null,null,"Optional input information that can be used"]
[null,null,null,null,null,null,null,null,null,null,null,null,"to supplement the analysis if this information"]
[null,"Worksheet Name",null,null,"Contents",null,null,null,null,null,null,null,"is available.  This optional input information"]
[null,null,null,null,null,null,null,null,null,null,null,null,"is reserved for locally-derived crash information."]
[null,"Instructions",null,null,"Current worksheet displaying overview, summary",null,null,null,null,null,null,null,"If the analyst elects to use this option so as"]
[null,null,null,null,"of spreadsheet worksheets, and description of",null,null,null,null,null,null,null,"to improve analysis for local crash distribution"]
[null,null,null,null,"color coding included in the worksheets.",null,null,null,null,null,null,null,"trends, each of the Exhibits with the locally-"]
[null,null,null,null,null,null,null,null,null,null,null,null,"derived input also includes a pull-down box"]
[null,"Segment 1",null,null,"Analysis for the rural 2-lane segments that",null,null,null,null,null,null,null,"where the analyst should indicate they are"]
[null,null,null,null,"uses lookup tables from exhibits included",null,null,null,null,null,null,null,"using locally derive crash information.  The"]
[null,null,null,null,"in the worksheet \"Segment Tables.\" The",null,null,null,null,null,null,null,"worksheets will then use the local values"]
[null,null,null,null,"associated HSM worksheets are 1A, 1B, 1C,",null,null,null,null,null,null,null,"instead of the HSM default values."]
[null,null,null,null,"1D, and 1E."]
[]
[null,"Segment 2",null,null,"Duplicate segment worksheet for additional"]
[null,null,null,null,"highway segments."]
[null,null,null,null,null,null,null,null,null,null,"Spreadsheet developed by:"]
[null,"Segment Tables",null,null,"Includes segment tables used for analysis of HSM-",null,null,null,null,null,null,"Karen Dixon, Ph.D., P.E."]
[null,null,null,null,"provided crash trends as well as locally-derived crash ",null,null,null,null,null,null,"Oregon State University"]
[null,null,null,null,"information.  These are HSM Tables 10-3, 10-4,",null,null,null,null,null,null,"School of Civil & Construction Engineering"]
[null,null,null,null,"and 10-12. This worksheet also includes tables",null,null,null,null,null,null,"220 Owen Hall"]
[null,null,null,null,"used for CMF calculations.  These tables",null,null,null,null,null,null,"Corvallis, OR  97330"]
[null,null,null,null,"include Table 10-8, 10-9, and 10-10."]
[null,null,null,null,null,null,null,null,null,null,null,"Email:  karen.dixon@oregonstate.edu"]
[null,"Intersection 1",null,null,"Analysis for the rural 2-lane intersections that",null,null,null,null,null,null,"Phone:  541-737-6337"]
[null,null,null,null,"uses lookup tables from exhibits included"]
[null,null,null,null,"in the worksheet \"Intersection Tables.\" The"]
[null,null,null,null,"associated HSM worksheets are 2A, 2B, 2C,"]
[null,null,null,null,"2D, and 2E."]
[]
[null,"Intersection 2",null,null,"Duplicate intersection worksheet for"]
[null,null,null,null,"additional highway segments."]
[]
[null,"Intersection Tables",null,null,"Includes intersection tables used for analysis of HSM-"]
[null,null,null,null,"provided crash trends as well as locally-derived crash"]
[null,null,null,null,"information. These are HSM Tables 10-5, 10-6,"]
[null,null,null,null,"and 10-15. This worksheet also includes tables"]
[null,null,null,null,"used for CMF calculations. These tables"]
[null,null,null,null,"include Tables 10-13 and 10-14."]
[]
[null,"Rural 2-lane Site Total",null,null,"Analysis for site-specific EB analysis using"]
[null,null,null,null,"results from the rural 2-lane segment as well as"]
[null,null,null,null,"rural 2-lane intersection worksheets. This"]
[null,null,null,null,"analysis can be performed if the analyst"]
[null,null,null,null,"knows the exact location of historic crashes"]
[null,null,null,null,"within the study limits. The associated"]
[null,null,null,null,"HSM worksheets are 3A and 3B."]
[]
[null,"Rural 2-lane Project Total",null,null,"Analysis for project-specific EB analysis using "]
[null,null,null,null,"results from the rural 2-lane segment as well as"]
[null,null,null,null,"rural 2-lane intersection worksheets. This"]
[null,null,null,null,"analysis can be performed if the analyst has"]
[null,null,null,null,"historic crash data, but does not know the"]
[null,null,null,null,"exact location within the project limits at"]
[null,null,null,null,"which the crashes occurred. The associated"]
[null,null,null,null,"HSM worksheets are Worksheets 4A and 4B."]
[]
[null,"Construction -- Do Not Delete",null,null,"Data in this worksheet has been used to"]
[null,null,null,null,"help define the pull-down options in the"]
[null,null,null,null,"analysis worksheets.  There is no need for a"]
[null,null,null,null,"user to work within this worksheet, but the"]
[null,null,null,null,"worksheet should be retained so that the"]
[null,null,null,null,"other worksheets can continue to use the"]
[null,null,null,null,"options included in this sheet."]
[]
[]
[null,"FDOT Developed Crash Costs Spreadsheets"]
[]
[null,"The Florida Department of Transportation (FDOT) has expanded the original spreadsheets",null,null,null,null,null,null,null,null,null,"Crash Cost Computation Methodology "]
[null,"to estimate crash costs for a designated life cycle.  The Npredicted or Nexpected  values shown "]
[null,"in the Rural 2-Lane Site Total tab are brought into the Segment Crash Cost and Intersection ",null,null,null,null,null,null,null,null,null,"Once the previously described data has been entered into the crash cost spreadsheet, the spreadsheet will compute the present value of crash costs for the prescribed life cycle. This computation is done by the spreadsheet as follows.  The Default Distribution for Crash Severity Level factors from Chapter 23, Volume 1 of the FDOT Plans Preparation Manual (PPM) have already been entered into the orange cells at the top right of the spreadsheet.  These percentages are multiplied by the Npredicted or Nexpected in the spreadsheet.  The annual number of crashes is attained for each year of the improvements life cycle.  This value increases with increasing future traffic volumes and Npredicted or Nexpected.  The annual number of crashes is then multiplied by the FDOT KABCO crash costs found in Table 23.5.2 in Volume 1 of the FDOT PPM.  The annualized total crash cost is summed in Column P.  This cost is taken to present value or present worth using the equation shown in Note 1 at the bottom of the spreadsheet.  The annual present value crash costs are summed at the bottom right of the spreadsheed for the life cycle present value crash costs. It should be noted as future editions of the FDOT PPM are provided, the user should confirm the crash distribution factors and the FDOT KABCO crash costs as these will be periodically updated. The data shown in this spreadsheet is based upon the 2016 edition of the FDOT PPM.       "]
[null,"Crash Cost tabs.  The user will need to enter basic information into the spreadsheet as described"]
[null,"below.  As with the previous spreadsheets, the yellow cells identify locations were data needs to"]
[null,"be entered.  The blue cells are pull down menus.  "]
[]
[null,"Minor or Major Growth Rate",null,null,"The Growth Rate is the compunded annual traffic growth rate over  "]
[null,null,null,null,"the analysis period. For the Segment Crash Cost spreadsheet it   "]
[null,null,null,null,"applies to the segment being analyzed.  For the Intersection Crash"]
[null,null,null,null,"Cost spreadsheets it is the compounded annual traffic growth rate "]
[null,null,null,null,"for the major and minor approaches as defined in the Intersection tab."]
[]
[null,"Rate of Return",null,null,"Also referred to as interest rate is defined in Chapter 23; Volume 1 of "]
[null,null,null,null,"the FDOT Plans Preparation Manual as 4%. "]
[]
[null,"Project Opening Year",null,null,"This is the year the project will be completed and open to traffic.  The"]
[null,null,null,null,"Project Opening Year AADT will calculated by using the Current Year   "]
[null,null,null,null,"AADT applying the growth factor. You will notice the spreadsheet  "]
[null,null,null,null,"shifts down to the Project Opening Year for the crash cost analysis.  "]
[]
[null,"Analysis Period",null,null,"This is based upon the improvement's life cycle. "]
[]
[null,"Segment or Intersection",null,null,"Pull down menu for the user to identify segment or intersection to"]
[null,null,null,null,"match site types shown in the Rural 2-Lane Site Total tab."]
[]
[null,"Crash Data Used",null,null,"Pull down menu showing either yes or no.  If crash data has been "]
[null,null,null,null,"entered into the \"Observed Crash\" column of the Rural 2-Lane Site"]
[null,null,null,null,"Total tab, then yes should be the answer and the analysis will be done "]
[null,null,null,null,"using the Nexpected values.  If crash date is not used the analysis will be"]
[null,null,null,null,"done using the Npredicted values.  After selecting Yes or No, it is "]
[null,null,null,null,"important to click the \"Analyze\" button.  If the user selects \"Yes\" for  "]
[null,null,null,null,"crash data, a pop up will appear asking  the user  to select "]
[null,null,null,null,"between an existing or proposed conditions analysis.  If existing,"]
[null,null,null,null,"nothing further is required.  If proposed, the user will see another"]
[null,null,null,null,"pop-up asking the existing conditions Npredicted and Nexpected"]
[null,null,null,null,"crash frequency to be added.  This is for the proposed conditions EB"]
[null,null,null,null,"analysis using the ratio method and provides a proposed conditions "]
[null,null,null,null," Nexpected for the crash cost calculation. EB analysis of a proposed "]
[null,null,null,null,"condition requires data associated with the existing condition "]
[null,null,null,null,"because there is no historical crash data for the proposed condition."]

{"sheet":"Segment1","index":1,"n_rows":85,"n_cols":34,"rows_kept":85,"cut":false,"hidden":false,"merged":[[84,0,84,2],[84,3,84,5],[84,6,84,8],[84,9,84,10],[84,11,84,12],[82,0,82,2],[82,3,82,5],[82,6,82,8],[82,9,82,10],[82,11,82,12],[83,0,83,2],[83,3,83,5],[83,6,83,8],[83,9,83,10],[83,11,83,12],[80,0,81,2],[80,3,80,5],[80,6,80,8],[80,9,81,10],[80,11,80,12],[81,3,81,5],[81,6,81,8],[81,11,81,12],[78,0,78,12],[79,0,79,2],[79,3,79,5],[79,6,79,8],[79,9,79,10],[79,11,79,12],[74,0,74,1],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[73,0,73,1],[73,3,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[72,0,72,1],[72,3,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,11,72,12],[71,0,71,1],[71,3,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[70,0,70,1],[70,3,70,4],[70,5,70,6],[70,7,70,8],[70,9,70,10],[70,11,70,12],[68,0,68,12],[69,0,69,1],[69,3,69,4],[69,5,69,6],[69,7,69,8],[69,9,69,10],[69,11,69,12],[67,0,67,1],[67,3,67,4],[67,5,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[66,0,66,1],[66,3,66,4],[66,5,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[65,0,65,1],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[64,0,64,1],[64,3,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[63,0,63,1],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[62,0,62,1],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[59,7,59,8],[59,9,59,10],[59,11,59,12],[60,0,60,12],[61,0,61,1],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[56,0,57,1],[56,3,56,4],[56,5,56,6],[59,0,59,1],[59,3,59,4],[59,5,59,6],[58,0,58,1],[58,3,58,4],[58,5,58,6],[57,3,57,4],[58,7,58,8],[58,9,58,10],[58,11,58,12],[56,7,56,8],[56,9,56,10],[56,11,56,12],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[54,0,54,12],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[49,0,49,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,11,49,12],[50,0,50,1],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,11,50,12],[47,7,47,8],[47,11,47,12],[46,5,46,6],[46,7,46,8],[48,0,48,1],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,11,48,12],[46,0,47,1],[46,3,46,4],[46,11,46,12],[47,3,47,4],[47,5,47,6],[36,12,39,12],[44,0,44,12],[45,0,45,1],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,11,45,12],[31,12,34,12],[36,0,39,0],[36,1,39,1],[36,2,39,2],[36,3,39,3],[36,4,39,4],[36,5,39,5],[36,9,39,9],[36,10,39,10],[36,11,39,11],[36,6,39,6],[36,7,39,7],[36,8,39,8],[29,0,29,12],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[31,5,34,5],[31,6,34,6],[31,7,34,7],[31,8,34,8],[31,9,34,9],[31,10,34,10],[31,11,34,11],[24,0,24,5],[24,6,24,7],[24,8,24,12],[25,0,25,5],[25,6,25,7],[25,8,25,12],[22,0,22,5],[22,6,22,7],[22,8,22,12],[23,0,23,5],[23,6,23,7],[23,8,23,12],[20,0,20,5],[20,6,20,7],[20,8,20,12],[21,0,21,5],[21,6,21,7],[21,8,21,12],[18,0,18,5],[18,6,18,7],[18,8,18,12],[19,0,19,5],[19,6,19,7],[19,8,19,12],[16,0,16,5],[16,6,16,7],[16,8,16,12],[17,0,17,5],[17,6,17,7],[17,8,17,12],[14,0,14,5],[14,6,14,7],[14,8,14,12],[15,0,15,5],[15,6,15,7],[15,8,15,12],[12,6,12,7],[13,0,13,5],[13,6,13,7],[13,8,13,12],[12,10,12,11],[12,0,12,5],[10,0,10,5],[10,6,10,7],[10,8,10,12],[11,6,11,7],[11,10,11,11],[11,0,11,5],[8,0,8,5],[8,6,8,7],[8,8,8,12],[9,6,9,7],[9,8,9,12],[9,0,9,2],[6,0,6,2],[6,3,6,5],[6,6,6,8],[6,9,6,12],[7,0,7,5],[7,6,7,7],[7,8,7,12],[4,0,4,2],[4,3,4,5],[4,6,4,8],[4,9,4,12],[5,0,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,12],[1,0,1,12],[2,0,2,5],[2,6,2,12],[3,0,3,2],[3,3,3,5],[3,6,3,8],[3,9,3,12],[4,29,5,33],[6,29,7,30],[6,31,6,33],[8,29,8,30],[9,29,9,30],[10,29,10,30],[11,29,11,30],[12,29,12,30],[13,29,13,30],[28,29,28,30],[29,29,29,30],[30,29,30,30],[31,29,31,30],[32,29,32,30],[33,29,36,33],[14,29,14,30],[15,29,18,33],[20,29,21,33],[22,29,23,30],[22,31,22,33],[24,29,24,30],[25,29,25,30],[26,29,26,30],[27,29,27,30]]}
[]
["Worksheet 1A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
["General Information",null,null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,"Supplemental CMF Calculations for Shoulders:"]
["Analyst",null,null,null,null,null,"Roadway"]
["Agency or Company",null,null,null,null,null,"Roadway Section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 10-8: CMF for Lane Width on Roadway Segments (CMFra)"]
["Date Performed",null,null,null,null,null,"Jurisdiction",null,null,null,null,null,null,null,null,null,"Calculated Right Shoulder Width (CMFwra) :",null,null,null,{"$f":"IF($I$10>2000,(VLOOKUP($J$12,$AD$25:$AH$33,5,FALSE)),IF($I$10<400,(VLOOKUP($J$12,$AD$25:$AH$33,3,FALSE)),(VLOOKUP($J$12,$AD$25:$AH$33,4))))","v":1.1000000000000001},null,"Calculated Left Shoulder Width (CMFwra) :",null,null,null,{"$f":"IF($I$10>2000,(VLOOKUP($M$12,$AD$25:$AH$33,5,FALSE)),IF($I$10<400,(VLOOKUP($M$12,$AD$25:$AH$33,3,FALSE)),(VLOOKUP($M$12,$AD$25:$AH$33,4))))","v":1.1000000000000001}]
[null,null,null,null,null,null,"Analysis Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Width (ft.)",null,"AADT (veh/day)"]
["Input Data",null,null,null,null,null,"Base Conditions",null,"Site Conditions",null,null,null,null,null,null,null,"Calculated Right Shoulder Type (CMF tra) :",null,null,null,{"$f":"IF($J$13=\"Paved\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($J$13=\"Gravel\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($J$13=\"Turf\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":1},null,"Calculated Left Shoulder Type (CMF tra) :",null,null,null,{"$f":"IF($M$13=\"Paved\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($M$13=\"Gravel\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($M$13=\"Turf\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":1},null,null,null,null,"< 400","400 to 2000","> 2000"]
["Length of segment, L (mi)",null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,1.05,{"$f":"+($I$10-400)*0.000281+1.05","v":0.93759999999999999},1.5]
["AADT (veh/day)",null,null,"AADTMAX =",17800,"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I10>E10,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"},null,null,"Computed Right Shoulder CMF2r :",null,null,null,{"$f":"(+$U$6*$U$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":1.0574000000000001},null,"Computed Left Shoulder CMF2r :",null,null,null,{"$f":"(+$AA$6*$AA$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":1.0574000000000001},null,null,9.5,null,{"$f":"+(AF9+AF11)/2","v":1.0350000000000001},{"$f":"+(AG9+AG11)/2","v":0.94379999999999997},{"$f":"+(AH9+AH11)/2","v":1.4}]
["Lane width (ft.)",null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.02,{"$f":"+($I$10-400)*0.000175+1.02","v":0.95000000000000007},1.3]
["Shoulder width (ft.)",null,null,null,null,null,6,null,"Right Shld:",null,"Left Shld:",null,null,null,null,null,"Supplemental CMF Calculations for Horizontal Curves:",null,null,null,null,null,null,null,null,null,null,null,null,10.5,null,{"$f":"+(AF11+AF13)/2","v":1.0150000000000001},{"$f":"+(AG11+AG13)/2","v":0.97500000000000009},{"$f":"+(AH11+AH13)/2","v":1.175}]
["Shoulder type",null,null,null,null,null,"Paved",null,"Right Shld:",null,"Left Shld:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,1.01,{"$f":"+($I$10-400)*0.000025+1.01","v":1},1.05]
["Length of horizontal curve (mi)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Adjusted Curve Radius (if less than 100 ft.):",null,null,null,{"$f":"IF($I$15>0,IF($I$15<=100,100,$I$15),0)","v":0},null,null,null,null,null,null,null,null,11.5,null,{"$f":"+(AF13+AF15)/2","v":1.0049999999999999},{"$f":"+(AG13+AG15)/2","v":1},{"$f":"+(AH13+AH15)/2","v":1.0249999999999999}]
["Radius of curvature (ft.)",null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(I14>0,IF(I15=0,\"Value of radius must be > 0\",\"Radius Value OK\"),\"Radius Value OK\")","v":"Radius Value OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1,1,1]
["Spiral transition curve (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Adjusted Curve Length (if less than 100 ft.):",null,null,null,{"$f":"IF($I$14>0,IF($I$14<=100/5280,100/5280,$I$14),0)","v":0},null,null,null,null,null,null,null,null,"Note: The collision types related to lane width to which this CMF applies include single-vehicle run-off-the-road and multiple-vehicle head-on, opposite-direction sideswipe, and same-direction sideswipe crashes."]
["Superelevation variance (ft./ft.)",null,null,null,null,null,"< 0.01"]
["Grade (%)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Numeric Value for S:",null,null,null,{"$f":"IF(I16=\"Present\",1,IF(I16=\"Not Present\",0,0.5))","v":0.5}]
["Driveway density (driveways/mile)",null,null,null,null,null,5]
["Centerline rumble strips (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Calculated Horizontal Curve CMF:",null,null,null,{"$f":"IF( $U$16>0, ((1.55*$U$16)+(80.2/$U$14)-(0.012*(IF($U$18=\"Present\",TRUE,FALSE))))/(1.55*$U$16), 1)","v":1}]
["Passing lanes [present (1 lane) /present (2 lane) / not present)]",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 10-9: CMF for Shoulder Width on Roadway Segments (CMFwra)"]
["Two-way left-turn lane (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Adjusted Horizontal Curve CMF:",null,null,null,{"$f":"IF($U$20<1,1,$U$20)","v":1}]
["Roadside hazard rating (1-7 scale)",null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoulder Width (ft.)",null,"AADT (veh/day)"]
["Segment lighting (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 400","400 to 2000","> 2000"]
["Auto speed enforcement (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,1.1000000000000001,{"$f":"+($I$10-400)*0.00025+1.1","v":1},1.5]
["Calibration Factor, Cr",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"+(AF25+AF27)/2","v":1.085},{"$f":"+(AG25+AG27)/2","v":1.0064000000000002},{"$f":"+(AH25+AH27)/2","v":1.4}]
[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,2,null,1.07,{"$f":"+($I$10-400)*0.000143+1.07","v":1.0128000000000001},1.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,null,null,null,null,null,3,null,{"$f":"+(AF27+AF29)/2","v":1.0449999999999999},{"$f":"+(AG27+AG29)/2","v":1.0001500000000001},{"$f":"+(AH27+AH29)/2","v":1.2250000000000001}]
[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,4,null,1.02,{"$f":"+($I$10-400)*0.00008125+1.02","v":0.98750000000000004},1.1499999999999999]
["Worksheet 1B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"+(AF29+AF31)/2","v":1.01},{"$f":"+(AG29+AG31)/2","v":0.99375000000000002},{"$f":"+(AH29+AH31)/2","v":1.075}]
["(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1,1,1]
["CMF for Lane Width","CMF for Shoulder Width and Type","CMF for Horizontal Curves","CMF for Super-elevation","CMF for Grades","CMF for Driveway Density","CMF for Centerline Rumble Strips","CMF for Passing Lanes","CMF for Two-Way Left-Turn Lane","CMF for Roadside Design","CMF for Lighting","CMF for Automated Speed Enforcement","Combined CMF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,{"$f":"+(AF31+AF33)/2","v":0.99},{"$f":"+(AG31+AG33)/2","v":1.0037500000000001},{"$f":"+(AH31+AH33)/2","v":0.93500000000000005}]
[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,8,null,0.98,{"$f":"+(($I$10-400)*-0.00006875)+0.98","v":1.0075000000000001},0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: The collision types related to shoulder width to which this CMF applies include single-vehicle run-off-the-road and multiple-vehicle head-on, opposite-direction sideswipe, and same-direction sideswipe crashes."]
[]
["CMF 1r","CMF 2r","CMF 3r","CMF 4r","CMR 5r","CMF 6r","CMF 7r","CMF 8r","CMF 9r","CMF 10r","CMF 11r","CMF 12r","CMF comb"]
["from Equation 10-11","from Equation 10-12","from Equation 10-13","from Equations 10-14, 10-15, or 10-16","from Table 10-11","from Equation 10-17","from Section 10.7.1","from Section 10.7.1","from Equation 10-18 & 10-19","from Equation 10-20","from Equation 10-21","from Section 10.7.1","(1)x(2)x … x(11)x(12)"]
[]
[]
[]
[{"$f":"((IF($I$10>2000,(VLOOKUP($I$11,$AD$9:$AH$15,5,FALSE)),IF($I$10<400,(VLOOKUP($I$11,$AD$9:$AH$15,3,FALSE)),(VLOOKUP($I$11,$AD$9:$AH$15,4)))))-1)*(IF( 'Segment Tables'!D23=\"No\", (('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":{"$error":"#N/A"}},{"$f":"($U$10+$AA$10)/2","v":1.0574000000000001},{"$f":"+U22","v":1},{"$f":"IF($I$17>=0.02,(1.06+3*($I$17-0.02)),IF($I$17<0.01,1,(1+6*($I$17-0.01))))","v":1},{"$f":"IF($I$18>6,1.16,(IF($I$18<=3,1,1.1)))","v":1},{"$f":"IF($I$19>5,(0.322+$I$19*(0.05-0.005*LN($I$10)))/(0.322+5*(0.05-0.005*LN($I$10))),1)","v":1},{"$f":"IF(I22=\"Present\",1,IF($I$20=\"Present\",0.94,1))","v":1},{"$f":"IF($I$21=\"Present (1 lane)\",0.75,IF($I$21=\"Present (2 lanes)\", 0.65, 1))","v":1},{"$f":"IF($I$22=\"Not Present\",1,IF($I$19<=5,1,(1-(0.7*0.5*((0.0047*$I$19)+($I$19*$I$19*0.0024))/(1.199+(0.0047*$I$19)+(0.0024*$I$19*$I$19))))))","v":1},{"$f":"EXP($I$23*0.0668-0.6869)/EXP(-0.4865)","v":0.8184033262664786},{"$f":"IF($I$24=\"Present\",(1-((1-(0.72*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$C$49,'Segment Tables'!$I$49))-(0.83*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$E$49,'Segment Tables'!$K$49)))*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$F$49,'Segment Tables'!$L$49))),1)","v":1},{"$f":"IF($I$25=\"Present\",0.93,1)","v":1},{"$f":"+A41*B41*C41*D41*E41*F41*G41*H41*I41*J41*K41*L41","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1C -- Roadway Segment Crashes for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)"]
["Crash Severity Level",null,"N spf rs","Overdispersion Parameter, k",null,"Crash Severity Distribution",null,"N spf rs by Severity Distribution",null,"Combined CMFs","Calibration Factor, Cr","Predicted average crash frequency,      N predicted rs (crashes/year)"]
[null,null,"from  Equation 10-6","  from Equation 10-7",null,"from Table 10-3 (proportion)",null,"(2)TOTAL x (4)",null,"(13) from Worksheet 1B",null,"(5)x(6)x(7)"]
["Total",null,{"$f":"+I10*I9*365*0.000001*EXP(-0.312)","v":0},{"$f":"0.236/I9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Segment Tables'!E15/100","v":1},null,{"$f":"+C49*F49","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H49*J49*K49","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$13/100),('Segment Tables'!$H$13/100))","v":0.32100000000000001},null,{"$f":"+C49*F50","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H50*J50*K50","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$14/100),('Segment Tables'!$H$14/100))","v":0.67900000000000005},null,{"$f":"+C49*F51","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H51*J51*K51","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted rs (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted rs (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted rs (PDO) (crashes/year)"]
[null,null,"  from Table   10-4","(8)TOTAL from Worksheet 1C",null,"from Table 10-4",null,"(8)FI from Worksheet 1C",null,"from Table 10-4",null,"(8)PDO from Worksheet 1C"]
["Total",null,{"$f":"+C68+C75","v":1},{"$f":"+$L$49","v":{"$error":"#N/A"}},null,{"$f":"+F68+F75","v":1},null,{"$f":"+$L$50","v":{"$error":"#N/A"}},null,1,null,{"$f":"+$L$51","v":{"$error":"#N/A"}}]
[null,null,null,"(2)x(3)TOTAL",null,null,null,"(4)x(5)FI",null,null,null,"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G25/100),('Segment Tables'!$K25/100))","v":0.121},{"$f":"+$L$49*C62","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E25/100,'Segment Tables'!$I25/100)","v":3.7999999999999999E-2},null,{"$f":"+$L$50*F62","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F25/100,'Segment Tables'!$J25/100)","v":0.184},null,{"$f":"+$L$51*J62","v":{"$error":"#N/A"}}]
["Collision with bicycle",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G26/100),('Segment Tables'!$K26/100))","v":2E-3},{"$f":"+$L$49*C63","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E26/100,'Segment Tables'!$I26/100)","v":4.0000000000000001E-3},null,{"$f":"+$L$50*F63","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F26/100,'Segment Tables'!$J26/100)","v":1E-3},null,{"$f":"+$L$51*J63","v":{"$error":"#N/A"}}]
["Collision with pedestrian",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G27/100),('Segment Tables'!$K27/100))","v":3.0000000000000001E-3},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E27/100,'Segment Tables'!$I27/100)","v":6.9999999999999993E-3},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F27/100,'Segment Tables'!$J27/100)","v":1E-3},null,{"$error":"#N/A"}]
["Overturned",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G28/100),('Segment Tables'!$K28/100))","v":2.5000000000000001E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E28/100,'Segment Tables'!$I28/100)","v":3.7000000000000005E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F28/100,'Segment Tables'!$J28/100)","v":1.4999999999999999E-2},null,{"$error":"#N/A"}]
["Ran off road",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G29/100),('Segment Tables'!$K29/100))","v":0.52100000000000002},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E29/100,'Segment Tables'!$I29/100)","v":0.54500000000000004},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F29/100,'Segment Tables'!$J29/100)","v":0.505},null,{"$error":"#N/A"}]
["Other single-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G30/100),('Segment Tables'!$K30/100))","v":2.1000000000000001E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E30/100,'Segment Tables'!$I30/100)","v":6.9999999999999993E-3},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F30/100,'Segment Tables'!$J30/100)","v":2.8999999999999998E-2},null,{"$error":"#N/A"}]
["Total single-vehicle crashes",null,{"$f":"+SUM(C62:C67)","v":0.69300000000000006},{"$error":"#N/A"},null,{"$f":"SUM(F62:G67)","v":0.63800000000000001},null,{"$error":"#N/A"},null,{"$f":"SUM(J62:K67)","v":0.73499999999999999},null,{"$error":"#N/A"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G33/100),('Segment Tables'!$K33/100))","v":8.5000000000000006E-2},{"$f":"+$L$49*C70","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E33/100,'Segment Tables'!$I33/100)","v":0.1},null,{"$f":"+$L$50*F70","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F33/100,'Segment Tables'!$J33/100)","v":7.2000000000000008E-2},null,{"$f":"+$L$51*J70","v":{"$error":"#N/A"}}]
["Head-on collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G34/100),('Segment Tables'!$K34/100))","v":1.6E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E34/100,'Segment Tables'!$I34/100)","v":3.4000000000000002E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F34/100,'Segment Tables'!$J34/100)","v":3.0000000000000001E-3},null,{"$f":"+$L$51*J71","v":{"$error":"#N/A"}}]
["Rear-end collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G35/100),('Segment Tables'!$K35/100))","v":0.14199999999999999},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E35/100,'Segment Tables'!$I35/100)","v":0.16399999999999998},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F35/100,'Segment Tables'!$J35/100)","v":0.122},null,{"$f":"+$L$51*J72","v":{"$error":"#N/A"}}]
["Sideswipe collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G36/100),('Segment Tables'!$K36/100))","v":3.7000000000000005E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E36/100,'Segment Tables'!$I36/100)","v":3.7999999999999999E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F36/100,'Segment Tables'!$J36/100)","v":3.7999999999999999E-2},null,{"$f":"+$L$51*J73","v":{"$error":"#N/A"}}]
["Other multiple-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G37/100),('Segment Tables'!$K37/100))","v":2.7000000000000003E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E37/100,'Segment Tables'!$I37/100)","v":2.6000000000000002E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F37/100,'Segment Tables'!$J37/100)","v":0.03},null,{"$f":"+$L$51*J74","v":{"$error":"#N/A"}}]
["Total multiple-vehicle crashes",null,{"$f":"SUM(C70:C74)","v":0.30700000000000005},{"$error":"#N/A"},null,{"$f":"SUM(F70:F74)","v":0.36199999999999999},null,{"$error":"#N/A"},null,{"$f":"SUM(J70:J74)","v":0.26500000000000001},null,{"$f":"SUM(L70:L74)","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1E -- Summary Results for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)",null,"(5)"]
["Crash severity level",null,null,"Crash Severity Distribution (proportion)",null,null,"Predicted average crash frequency (crashes/year)",null,null,"Roadway segment length (mi)",null,"Crash rate (crashes/mi/year)"]
[null,null,null,"(4) from Worksheet 1C",null,null,"(8) from Worksheet 1C",null,null,null,null,"(3)/(4)"]
["Total",null,null,{"$f":"+F49","v":1},null,null,{"$f":"+L49","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G83/J83","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,null,{"$f":"+F50","v":0.32100000000000001},null,null,{"$f":"+L50","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G84/J84","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,null,{"$f":"+F51","v":0.67900000000000005},null,null,{"$f":"+L51","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G85/J85","v":{"$error":"#N/A"}}]

{"sheet":"Segment2","index":2,"n_rows":85,"n_cols":34,"rows_kept":85,"cut":false,"hidden":false,"merged":[[20,0,20,5],[21,0,21,5],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[18,0,18,5],[21,6,21,7],[14,0,14,5],[15,0,15,5],[12,0,12,5],[13,0,13,5],[3,9,3,12],[4,9,4,12],[5,9,5,12],[6,9,6,12],[10,8,10,12],[8,6,8,7],[9,6,9,7],[11,10,11,11],[48,11,48,12],[45,11,45,12],[46,11,46,12],[48,5,48,6],[47,11,47,12],[23,6,23,7],[46,5,46,6],[31,12,34,12],[36,10,39,10],[23,0,23,5],[24,0,24,5],[25,0,25,5],[36,11,39,11],[36,12,39,12],[36,0,39,0],[36,1,39,1],[5,0,5,2],[8,0,8,5],[17,0,17,5],[16,0,16,5],[9,0,9,2],[11,0,11,5],[10,6,10,7],[11,6,11,7],[10,0,10,5],[50,0,50,1],[49,3,49,4],[50,3,50,4],[45,5,45,6],[49,0,49,1],[49,5,49,6],[36,9,39,9],[36,7,39,7],[49,11,49,12],[48,0,48,1],[46,3,46,4],[47,3,47,4],[48,3,48,4],[45,0,45,1],[46,0,47,1],[45,3,45,4],[36,3,39,3],[36,4,39,4],[36,2,39,2],[36,5,39,5],[36,6,39,6],[36,8,39,8],[1,0,1,12],[2,0,2,5],[6,0,6,2],[6,3,6,5],[7,0,7,5],[16,8,16,12],[3,3,3,5],[4,3,4,5],[5,3,5,5],[3,0,3,2],[8,8,8,12],[9,8,9,12],[14,8,14,12],[15,8,15,12],[13,8,13,12],[2,6,2,12],[3,6,3,8],[4,6,4,8],[5,6,5,8],[6,6,6,8],[7,8,7,12],[7,6,7,7],[12,10,12,11],[4,0,4,2],[59,5,59,6],[61,5,61,6],[54,0,54,12],[55,11,55,12],[59,0,59,1],[16,6,16,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[55,3,55,4],[56,3,56,4],[55,0,55,1],[56,0,57,1],[58,0,58,1],[58,5,58,6],[58,3,58,4],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[55,9,55,10],[56,9,56,10],[57,9,57,10],[64,5,64,6],[71,0,71,1],[22,8,22,12],[50,5,50,6],[48,7,48,8],[49,7,49,8],[50,7,50,8],[67,0,67,1],[55,5,55,6],[65,5,65,6],[61,0,61,1],[56,5,56,6],[57,5,57,6],[57,3,57,4],[64,0,64,1],[65,0,65,1],[62,0,62,1],[63,0,63,1],[65,3,65,4],[63,5,63,6],[70,0,70,1],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[69,0,69,1],[68,0,68,12],[66,0,66,1],[66,5,66,6],[59,3,59,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[60,0,60,12],[62,5,62,6],[64,7,64,8],[59,11,59,12],[61,11,61,12],[69,7,69,8],[70,7,70,8],[70,5,70,6],[71,7,71,8],[67,5,67,6],[69,5,69,6],[71,5,71,6],[59,7,59,8],[72,3,72,4],[72,0,72,1],[73,0,73,1],[74,0,74,1],[73,3,73,4],[74,3,74,4],[72,5,72,6],[73,5,73,6],[74,5,74,6],[58,9,58,10],[65,11,65,12],[58,11,58,12],[62,7,62,8],[63,7,63,8],[57,11,57,12],[50,11,50,12],[66,11,66,12],[65,9,65,10],[66,9,66,10],[62,11,62,12],[63,11,63,12],[64,11,64,12],[65,7,65,8],[66,7,66,8],[17,8,17,12],[22,6,22,7],[62,9,62,10],[63,9,63,10],[64,9,64,10],[61,7,61,8],[56,11,56,12],[59,9,59,10],[61,9,61,10],[31,10,34,10],[31,6,34,6],[31,9,34,9],[46,7,46,8],[47,7,47,8],[47,5,47,6],[44,0,44,12],[31,11,34,11],[23,8,23,12],[31,8,34,8],[45,7,45,8],[29,0,29,12],[24,6,24,7],[20,8,20,12],[21,8,21,12],[67,11,67,12],[69,11,69,12],[70,11,70,12],[71,11,71,12],[72,11,72,12],[73,11,73,12],[74,11,74,12],[78,0,78,12],[79,11,79,12],[79,9,79,10],[79,6,79,8],[79,3,79,5],[79,0,79,2],[67,7,67,8],[69,9,69,10],[70,9,70,10],[71,9,71,10],[72,9,72,10],[73,9,73,10],[74,9,74,10],[67,9,67,10],[72,7,72,8],[73,7,73,8],[74,7,74,8],[84,6,84,8],[82,9,82,10],[83,9,83,10],[84,9,84,10],[82,0,82,2],[83,0,83,2],[84,0,84,2],[81,11,81,12],[84,11,84,12],[82,11,82,12],[83,11,83,12],[82,6,82,8],[83,6,83,8],[82,3,82,5],[83,3,83,5],[84,3,84,5],[81,3,81,5],[81,6,81,8],[80,0,81,2],[80,11,80,12],[80,9,81,10],[80,6,80,8],[80,3,80,5],[18,8,18,12],[19,8,19,12],[31,0,34,0],[31,1,34,1],[31,2,34,2],[31,3,34,3],[31,4,34,4],[31,7,34,7],[32,29,32,30],[33,29,36,33],[25,29,25,30],[27,29,27,30],[29,29,29,30],[31,29,31,30],[28,29,28,30],[30,29,30,30],[22,29,23,30],[22,31,22,33],[25,6,25,7],[31,5,34,5],[24,8,24,12],[25,8,25,12],[22,0,22,5],[19,0,19,5],[9,29,9,30],[11,29,11,30],[13,29,13,30],[15,29,18,33],[24,29,24,30],[26,29,26,30],[6,31,6,33],[4,29,5,33],[6,29,7,30],[8,29,8,30],[10,29,10,30],[12,29,12,30],[14,29,14,30],[20,29,21,33]]}
[]
["Worksheet 1A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
["General Information",null,null,null,null,null,"Location Information",null,null,null,null,null,null,null,null,null,"Supplemental CMF Calculations for Shoulders:"]
["Analyst",null,null,null,null,null,"Roadway"]
["Agency or Company",null,null,null,null,null,"Roadway Section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 10-8: CMF for Lane Width on Roadway Segments (CMFra)"]
["Date Performed",null,null,null,null,null,"Jurisdiction",null,null,null,null,null,null,null,null,null,"Calculated Right Shoulder Width (CMFwra) :",null,null,null,{"$f":"IF($I$10>2000,(VLOOKUP($J$12,$AD$25:$AH$33,5,FALSE)),IF($I$10<400,(VLOOKUP($J$12,$AD$25:$AH$33,3,FALSE)),(VLOOKUP($J$12,$AD$25:$AH$33,4))))","v":1.1000000000000001},null,"Calculated Left Shoulder Width (CMFwra) :",null,null,null,{"$f":"IF($I$10>2000,(VLOOKUP($M$12,$AD$25:$AH$33,5,FALSE)),IF($I$10<400,(VLOOKUP($M$12,$AD$25:$AH$33,3,FALSE)),(VLOOKUP($M$12,$AD$25:$AH$33,4))))","v":1.1000000000000001}]
[null,null,null,null,null,null,"Analysis Year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lane Width (ft.)",null,"AADT (veh/day)"]
["Input Data",null,null,null,null,null,"Base Conditions",null,"Site Conditions",null,null,null,null,null,null,null,"Calculated Right Shoulder Type (CMF tra) :",null,null,null,{"$f":"IF($J$13=\"Paved\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($J$13=\"Gravel\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($J$13=\"Turf\",(HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($J$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":1},null,"Calculated Left Shoulder Type (CMF tra) :",null,null,null,{"$f":"IF($M$13=\"Paved\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,2,FALSE)),(IF($M$13=\"Gravel\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,3,FALSE)),(IF($M$13=\"Turf\",(HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,5,FALSE)),HLOOKUP($M$12,'Segment Tables'!$S$8:$AA$12,4,FALSE))))))","v":1},null,null,null,null,"< 400","400 to 2000","> 2000"]
["Length of segment, L (mi)",null,null,null,null,null,"--",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,1.05,{"$f":"+($I$10-400)*0.000281+1.05","v":0.93759999999999999},1.5]
["AADT (veh/day)",null,null,"AADTMAX =",17800,"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I10>E10,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"},null,null,"Computed Right Shoulder CMF2r :",null,null,null,{"$f":"(+$U$6*$U$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":1.0574000000000001},null,"Computed Left Shoulder CMF2r :",null,null,null,{"$f":"(+$AA$6*$AA$8-1)*(IF('Segment Tables'!$D$23=\"No\",(('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":1.0574000000000001},null,null,9.5,null,{"$f":"+(AF9+AF11)/2","v":1.0350000000000001},{"$f":"+(AG9+AG11)/2","v":0.94379999999999997},{"$f":"+(AH9+AH11)/2","v":1.4}]
["Lane width (ft.)",null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.02,{"$f":"+($I$10-400)*0.000175+1.02","v":0.95000000000000007},1.3]
["Shoulder width (ft.)",null,null,null,null,null,6,null,"Right Shld:",null,"Left Shld:",null,null,null,null,null,"Supplemental CMF Calculations for Horizontal Curves:",null,null,null,null,null,null,null,null,null,null,null,null,10.5,null,{"$f":"+(AF11+AF13)/2","v":1.0150000000000001},{"$f":"+(AG11+AG13)/2","v":0.97500000000000009},{"$f":"+(AH11+AH13)/2","v":1.175}]
["Shoulder type",null,null,null,null,null,"Paved",null,"Right Shld:",null,"Left Shld:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,1.01,{"$f":"+($I$10-400)*0.000025+1.01","v":1},1.05]
["Length of horizontal curve (mi)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Adjusted Curve Radius (if less than 100 ft.):",null,null,null,{"$f":"IF($I$15>0,IF($I$15<=100,100,$I$15),0)","v":0},null,null,null,null,null,null,null,null,11.5,null,{"$f":"+(AF13+AF15)/2","v":1.0049999999999999},{"$f":"+(AG13+AG15)/2","v":1},{"$f":"+(AH13+AH15)/2","v":1.0249999999999999}]
["Radius of curvature (ft.)",null,null,null,null,null,0,null,null,null,null,null,null,{"$f":"IF(I14>0,IF(I15=0,\"Value of radius must be > 0\",\"Radius Value OK\"),\"Radius Value OK\")","v":"Radius Value OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1,1,1]
["Spiral transition curve (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Adjusted Curve Length (if less than 100 ft.):",null,null,null,{"$f":"IF($I$14>0,IF($I$14<=100/5280,100/5280,$I$14),0)","v":0},null,null,null,null,null,null,null,null,"Note: The collision types related to lane width to which this CMF applies include single-vehicle run-off-the-road and multiple-vehicle head-on, opposite-direction sideswipe, and same-direction sideswipe crashes."]
["Superelevation variance (ft./ft.)",null,null,null,null,null,"< 0.01"]
["Grade (%)",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"Numeric Value for S:",null,null,null,{"$f":"IF(I16=\"Present\",1,IF(I16=\"Not Present\",0,0.5))","v":0.5}]
["Driveway density (driveways/mile)",null,null,null,null,null,5]
["Centerline rumble strips (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Calculated Horizontal Curve CMF:",null,null,null,{"$f":"IF( $U$16>0, ((1.55*$U$16)+(80.2/$U$14)-(0.012*(IF($U$18=\"Present\",TRUE,FALSE))))/(1.55*$U$16), 1)","v":1}]
["Passing lanes [present (1 lane) /present (2 lane) / not present)]",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 10-9: CMF for Shoulder Width on Roadway Segments (CMFwra)"]
["Two-way left-turn lane (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,"Adjusted Horizontal Curve CMF:",null,null,null,{"$f":"IF($U$20<1,1,$U$20)","v":1}]
["Roadside hazard rating (1-7 scale)",null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shoulder Width (ft.)",null,"AADT (veh/day)"]
["Segment lighting (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 400","400 to 2000","> 2000"]
["Auto speed enforcement (present/not present)",null,null,null,null,null,"Not Present",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,1.1000000000000001,{"$f":"+($I$10-400)*0.00025+1.1","v":1},1.5]
["Calibration Factor, Cr",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,{"$f":"+(AF25+AF27)/2","v":1.085},{"$f":"+(AG25+AG27)/2","v":1.0064000000000002},{"$f":"+(AH25+AH27)/2","v":1.4}]
[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,2,null,1.07,{"$f":"+($I$10-400)*0.000143+1.07","v":1.0128000000000001},1.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,null,null,null,null,null,3,null,{"$f":"+(AF27+AF29)/2","v":1.0449999999999999},{"$f":"+(AG27+AG29)/2","v":1.0001500000000001},{"$f":"+(AH27+AH29)/2","v":1.2250000000000001}]
[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,4,null,1.02,{"$f":"+($I$10-400)*0.00008125+1.02","v":0.98750000000000004},1.1499999999999999]
["Worksheet 1B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,{"$f":"+(AF29+AF31)/2","v":1.01},{"$f":"+(AG29+AG31)/2","v":0.99375000000000002},{"$f":"+(AH29+AH31)/2","v":1.075}]
["(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1,1,1]
["CMF for Lane Width","CMF for Shoulder Width and Type","CMF for Horizontal Curves","CMF for Super-elevation","CMF for Grades","CMF for Driveway Density","CMF for Centerline Rumble Strips","CMF for Passing Lanes","CMF for Two-Way Left-Turn Lane","CMF for Roadside Design","CMF for Lighting","CMF for Automated Speed Enforcement","Combined CMF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,{"$f":"+(AF31+AF33)/2","v":0.99},{"$f":"+(AG31+AG33)/2","v":1.0037500000000001},{"$f":"+(AH31+AH33)/2","v":0.93500000000000005}]
[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,8,null,0.98,{"$f":"+(($I$10-400)*-0.00006875)+0.98","v":1.0075000000000001},0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: The collision types related to shoulder width to which this CMF applies include single-vehicle run-off-the-road and multiple-vehicle head-on, opposite-direction sideswipe, and same-direction sideswipe crashes."]
[]
["CMF 1r","CMF 2r","CMF 3r","CMF 4r","CMR 5r","CMF 6r","CMF 7r","CMF 8r","CMF 9r","CMF 10r","CMF 11r","CMF 12r","CMF comb"]
["from Equation 10-11","from Equation 10-12","from Equation 10-13","from Equations 10-14, 10-15, or 10-16","from Table 10-11","from Equation 10-17","from Section 10.7.1","from Section 10.7.1","from Equation 10-18 & 10-19","from Equation 10-20","from Equation 10-21","from Section 10.7.1","(1)x(2)x … x(11)x(12)"]
[]
[]
[]
[{"$f":"((IF($I$10>2000,(VLOOKUP($I$11,$AD$9:$AH$15,5,FALSE)),IF($I$10<400,(VLOOKUP($I$11,$AD$9:$AH$15,3,FALSE)),(VLOOKUP($I$11,$AD$9:$AH$15,4)))))-1)*(IF( 'Segment Tables'!D23=\"No\", (('Segment Tables'!$G$29+'Segment Tables'!$G$34+'Segment Tables'!$G$36)/100),(('Segment Tables'!$K$29+'Segment Tables'!$K$34+'Segment Tables'!$K$36)/100)))+1","v":{"$error":"#N/A"}},{"$f":"($U$10+$AA$10)/2","v":1.0574000000000001},{"$f":"+U22","v":1},{"$f":"IF($I$17>=0.02,(1.06+3*($I$17-0.02)),IF($I$17<0.01,1,(1+6*($I$17-0.01))))","v":1},{"$f":"IF($I$18>6,1.16,(IF($I$18<=3,1,1.1)))","v":1},{"$f":"IF($I$19>5,(0.322+$I$19*(0.05-0.005*LN($I$10)))/(0.322+5*(0.05-0.005*LN($I$10))),1)","v":1},{"$f":"IF(I22=\"Present\",1,IF($I$20=\"Present\",0.94,1))","v":1},{"$f":"IF($I$21=\"Present (1 lane)\",0.75,IF($I$21=\"Present (2 lanes)\", 0.65, 1))","v":1},{"$f":"IF($I$22=\"Not Present\",1,IF($I$19<=5,1,(1-(0.7*0.5*((0.0047*$I$19)+($I$19*$I$19*0.0024))/(1.199+(0.0047*$I$19)+(0.0024*$I$19*$I$19))))))","v":1},{"$f":"EXP($I$23*0.0668-0.6869)/EXP(-0.4865)","v":0.8184033262664786},{"$f":"IF($I$24=\"Present\",(1-((1-(0.72*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$C$49,'Segment Tables'!$I$49))-(0.83*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$E$49,'Segment Tables'!$K$49)))*IF('Segment Tables'!$E$45=\"No\",'Segment Tables'!$F$49,'Segment Tables'!$L$49))),1)","v":1},{"$f":"IF($I$25=\"Present\",0.93,1)","v":1},{"$f":"+A41*B41*C41*D41*E41*F41*G41*H41*I41*J41*K41*L41","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1C -- Roadway Segment Crashes for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)","(7)","(8)"]
["Crash Severity Level",null,"N spf rs","Overdispersion Parameter, k",null,"Crash Severity Distribution",null,"N spf rs by Severity Distribution",null,"Combined CMFs","Calibration Factor, Cr","Predicted average crash frequency,      N predicted rs (crashes/year)"]
[null,null,"from  Equation 10-6","  from Equation 10-7",null,"from Table 10-3 (proportion)",null,"(2)TOTAL x (4)",null,"(13) from Worksheet 1B",null,"(5)x(6)x(7)"]
["Total",null,{"$f":"+I10*I9*365*0.000001*EXP(-0.312)","v":0},{"$f":"0.236/I9","v":{"$error":"#DIV/0!"}},null,{"$f":"+'Segment Tables'!E15/100","v":1},null,{"$f":"+C49*F49","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H49*J49*K49","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$13/100),('Segment Tables'!$H$13/100))","v":0.32100000000000001},null,{"$f":"+C49*F50","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H50*J50*K50","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,"--","--",null,{"$f":"+IF('Segment Tables'!$D$8=\"No\",('Segment Tables'!$E$14/100),('Segment Tables'!$H$14/100))","v":0.67900000000000005},null,{"$f":"+C49*F51","v":0},null,{"$f":"+M41","v":{"$error":"#N/A"}},{"$f":"+$I$26","v":0},{"$f":"+H51*J51*K51","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted rs (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted rs (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted rs (PDO) (crashes/year)"]
[null,null,"  from Table   10-4","(8)TOTAL from Worksheet 1C",null,"from Table 10-4",null,"(8)FI from Worksheet 1C",null,"from Table 10-4",null,"(8)PDO from Worksheet 1C"]
["Total",null,{"$f":"+C68+C75","v":1},{"$f":"+$L$49","v":{"$error":"#N/A"}},null,{"$f":"+F68+F75","v":1},null,{"$f":"+$L$50","v":{"$error":"#N/A"}},null,1,null,{"$f":"+$L$51","v":{"$error":"#N/A"}}]
[null,null,null,"(2)x(3)TOTAL",null,null,null,"(4)x(5)FI",null,null,null,"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G25/100),('Segment Tables'!$K25/100))","v":0.121},{"$f":"+$L$49*C62","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E25/100,'Segment Tables'!$I25/100)","v":3.7999999999999999E-2},null,{"$f":"+$L$50*F62","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F25/100,'Segment Tables'!$J25/100)","v":0.184},null,{"$f":"+$L$51*J62","v":{"$error":"#N/A"}}]
["Collision with bicycle",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G26/100),('Segment Tables'!$K26/100))","v":2E-3},{"$f":"+$L$49*C63","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E26/100,'Segment Tables'!$I26/100)","v":4.0000000000000001E-3},null,{"$f":"+$L$50*F63","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F26/100,'Segment Tables'!$J26/100)","v":1E-3},null,{"$f":"+$L$51*J63","v":{"$error":"#N/A"}}]
["Collision with pedestrian",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G27/100),('Segment Tables'!$K27/100))","v":3.0000000000000001E-3},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E27/100,'Segment Tables'!$I27/100)","v":6.9999999999999993E-3},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F27/100,'Segment Tables'!$J27/100)","v":1E-3},null,{"$error":"#N/A"}]
["Overturned",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G28/100),('Segment Tables'!$K28/100))","v":2.5000000000000001E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E28/100,'Segment Tables'!$I28/100)","v":3.7000000000000005E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F28/100,'Segment Tables'!$J28/100)","v":1.4999999999999999E-2},null,{"$error":"#N/A"}]
["Ran off road",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G29/100),('Segment Tables'!$K29/100))","v":0.52100000000000002},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E29/100,'Segment Tables'!$I29/100)","v":0.54500000000000004},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F29/100,'Segment Tables'!$J29/100)","v":0.505},null,{"$error":"#N/A"}]
["Other single-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G30/100),('Segment Tables'!$K30/100))","v":2.1000000000000001E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E30/100,'Segment Tables'!$I30/100)","v":6.9999999999999993E-3},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F30/100,'Segment Tables'!$J30/100)","v":2.8999999999999998E-2},null,{"$error":"#N/A"}]
["Total single-vehicle crashes",null,{"$f":"+SUM(C62:C67)","v":0.69300000000000006},{"$error":"#N/A"},null,{"$f":"SUM(F62:G67)","v":0.63800000000000001},null,{"$error":"#N/A"},null,{"$f":"SUM(J62:K67)","v":0.73499999999999999},null,{"$error":"#N/A"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G33/100),('Segment Tables'!$K33/100))","v":8.5000000000000006E-2},{"$f":"+$L$49*C70","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E33/100,'Segment Tables'!$I33/100)","v":0.1},null,{"$f":"+$L$50*F70","v":{"$error":"#N/A"}},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F33/100,'Segment Tables'!$J33/100)","v":7.2000000000000008E-2},null,{"$f":"+$L$51*J70","v":{"$error":"#N/A"}}]
["Head-on collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G34/100),('Segment Tables'!$K34/100))","v":1.6E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E34/100,'Segment Tables'!$I34/100)","v":3.4000000000000002E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F34/100,'Segment Tables'!$J34/100)","v":3.0000000000000001E-3},null,{"$f":"+$L$51*J71","v":{"$error":"#N/A"}}]
["Rear-end collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G35/100),('Segment Tables'!$K35/100))","v":0.14199999999999999},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E35/100,'Segment Tables'!$I35/100)","v":0.16399999999999998},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F35/100,'Segment Tables'!$J35/100)","v":0.122},null,{"$f":"+$L$51*J72","v":{"$error":"#N/A"}}]
["Sideswipe collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G36/100),('Segment Tables'!$K36/100))","v":3.7000000000000005E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E36/100,'Segment Tables'!$I36/100)","v":3.7999999999999999E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F36/100,'Segment Tables'!$J36/100)","v":3.7999999999999999E-2},null,{"$f":"+$L$51*J73","v":{"$error":"#N/A"}}]
["Other multiple-vehicle collision",null,{"$f":"IF('Segment Tables'!$D$23=\"No\",('Segment Tables'!$G37/100),('Segment Tables'!$K37/100))","v":2.7000000000000003E-2},{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$E37/100,'Segment Tables'!$I37/100)","v":2.6000000000000002E-2},null,{"$error":"#N/A"},null,{"$f":"IF('Segment Tables'!$D$23=\"No\",'Segment Tables'!$F37/100,'Segment Tables'!$J37/100)","v":0.03},null,{"$f":"+$L$51*J74","v":{"$error":"#N/A"}}]
["Total multiple-vehicle crashes",null,{"$f":"SUM(C70:C74)","v":0.30700000000000005},{"$error":"#N/A"},null,{"$f":"SUM(F70:F74)","v":0.36199999999999999},null,{"$error":"#N/A"},null,{"$f":"SUM(J70:J74)","v":0.26500000000000001},null,{"$f":"SUM(L70:L74)","v":{"$error":"#N/A"}}]
[]
[]
[]
["Worksheet 1E -- Summary Results for Rural Two-Lane Two-Way Roadway Segments"]
["(1)",null,null,"(2)",null,null,"(3)",null,null,"(4)",null,"(5)"]
["Crash severity level",null,null,"Crash Severity Distribution (proportion)",null,null,"Predicted average crash frequency (crashes/year)",null,null,"Roadway segment length (mi)",null,"Crash rate (crashes/mi/year)"]
[null,null,null,"(4) from Worksheet 1C",null,null,"(8) from Worksheet 1C",null,null,null,null,"(3)/(4)"]
["Total",null,null,{"$f":"+F49","v":1},null,null,{"$f":"+L49","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G83/J83","v":{"$error":"#N/A"}}]
["Fatal and Injury (FI)",null,null,{"$f":"+F50","v":0.32100000000000001},null,null,{"$f":"+L50","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G84/J84","v":{"$error":"#N/A"}}]
["Property Damage Only (PDO)",null,null,{"$f":"+F51","v":0.67900000000000005},null,null,{"$f":"+L51","v":{"$error":"#N/A"}},null,null,{"$f":"+$I$9","v":0},null,{"$f":"+G85/J85","v":{"$error":"#N/A"}}]

{"sheet":"Segment Tables","index":3,"n_rows":50,"n_cols":27,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,7,10,9],[11,1,11,3],[7,1,7,2],[22,1,22,2],[4,1,5,9],[9,4,9,6],[10,4,10,6],[12,7,12,9],[13,7,13,9],[14,7,14,9],[6,4,6,9],[11,7,11,9],[7,7,7,9],[8,4,8,6],[8,7,8,9],[11,4,11,6],[9,7,9,9],[37,10,37,11],[6,1,6,3],[7,4,7,6],[19,4,19,11],[21,5,22,5],[21,6,22,7],[20,4,20,7],[20,8,20,11],[21,8,22,8],[21,9,22,9],[21,10,22,11],[8,1,8,3],[9,1,9,3],[10,1,10,3],[12,4,12,6],[43,2,43,7],[44,11,46,13],[42,1,42,13],[43,1,47,1],[14,1,14,3],[23,6,23,7],[17,1,18,11],[21,4,22,4],[37,6,37,7],[35,6,35,7],[36,6,36,7],[14,4,14,6],[30,10,30,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[12,1,12,3],[13,1,13,3],[38,6,38,7],[31,6,31,7],[33,6,33,7],[34,6,34,7],[30,6,30,7],[32,6,32,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[13,4,13,6],[48,11,48,13],[44,5,46,7],[47,5,47,7],[48,5,48,7],[47,11,47,13],[48,2,48,3],[47,2,47,3],[44,2,44,3],[45,2,46,4],[44,8,46,10],[48,8,48,9],[47,8,47,9],[4,17,5,26],[6,17,7,17],[6,18,6,26],[12,17,13,26],[43,8,43,13],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[38,10,38,11],[23,10,23,11],[28,10,28,11],[29,10,29,11],[31,10,31,11],[32,10,32,11],[27,10,27,11]]}
[]
[null,"Tables Affiliated with Crash Statistics:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tables Affiliated with Crash Modification Factors:"]
[]
[]
[null,"Table 10-3: Distribution for Crash Severity Level on Rural Two-Lane Two-Way Roadway Segments plus Locally-Derived Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 10-10: Crash Modification Factors for Shoulder Types and Shoulder Widths on Roadway Segments (CMFtra)"]
[]
[null,"Crash severity level",null,null,"Percentage of total roadway segment crashes",null,null,null,null,null,null,null,null,null,null,null,null,"Shoulder Type","Shoulder width (ft.)"]
[null,"Locally-Derived Values?",null,"No","HSM-Provided Values",null,null,"Locally-Derived Values (Oregon)",null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8]
[null,"Fatal",null,null,1.3,null,null,3.1,null,null,null,null,null,null,null,null,null,"Paved",1,1,1,1,1,{"$f":"+(W9+Y9)/2","v":1},1,{"$f":"+(Y9+AA9)/2","v":1},1]
[null,"Incapacitating Injury",null,null,5.4,null,null,7.7,null,null,null,null,null,null,null,null,null,"Gravel",1,1,1.01,1.01,1.01,{"$f":"+(W10+Y10)/2","v":1.0150000000000001},1.02,{"$f":"+(Y10+AA10)/2","v":1.02},1.02]
[null,"Nonincapacitating Injury",null,null,10.9,null,null,25.2,null,null,null,null,null,null,null,null,null,"Composite",1,1.01,1.02,1.02,1.03,{"$f":"+(W11+Y11)/2","v":1.0350000000000001},1.04,{"$f":"+(Y11+AA11)/2","v":1.05},1.06]
[null,"Possible Injury",null,null,14.5,null,null,18,null,null,null,null,null,null,null,null,null,"Turf",1,1.01,1.03,1.04,1.05,{"$f":"+(W12+Y12)/2","v":1.0649999999999999},1.08,{"$f":"+(Y12+AA12)/2","v":1.0950000000000002},1.1100000000000001]
[null,"Total Fatal Plus Injury",null,null,{"$f":"SUM(E9:E12)","v":32.1},null,null,{"$f":"SUM(H9:H12)","v":54},null,null,null,null,null,null,null,null,null,"Note: The values for composite shoulders in this exhibit represent a shoulder for which 50 percent of the shoulder width is paved and 50 percent of the shoulder width is turf."]
[null,"Property Damage Only",null,null,{"$f":"100-E13","v":67.900000000000006},null,null,{"$f":"100-H13","v":46}]
[null,"TOTAL",null,null,{"$f":"SUM(E13:E14)","v":100},null,null,{"$f":"SUM(H13:H14)","v":100}]
[null,"Note: HSM-provided crash severity data based on HSIS data for Washington (2002-2006)"]
[]
[null,"Table 10-4: Default Distribution by Collision Type for Specific Crash Severity Levels on Rural Two-Lane Two-Way Roadway Segments plus Locally-Derived Values"]
[]
[null,null,null,null,"Percentage of total roadway segment crashes by crash severity level"]
[null,null,null,null,"HSM-Provided Values",null,null,null,"Locally-Derived Values (Oregon)"]
[null,"Collision type",null,null,"Total fatal and injury","Property damage only","TOTAL (all severity levels combined)",null,"Total fatal and injury","Property damage only","TOTAL (all severity levels combined)"]
[null,"Locally-Derived Values?",null,"No"]
[null,"SINGLE-VEHICLE CRASHES"]
[null,"Collision with animal",null,null,3.8,18.399999999999999,12.1,null,3.1,12,7.2]
[null,"Collision with bicycle",null,null,0.4,0.1,0.2,null,0.6,0,0.3]
[null,"Collision with pedestrian",null,null,0.7,0.1,0.3,null,0.8,0,0.4]
[null,"Overturned",null,null,3.7,1.5,2.5,null,8.6,3.8,6.4]
[null,"Ran off road",null,null,54.5,50.5,52.1,null,47.2,39.1,43.5]
[null,"Other single-vehicle crash",null,null,0.7,2.9,2.1,null,1.7,1.3,1.5]
[null,"Total single-vehicle crashes",null,null,{"$f":"SUM(E25:E30)","v":63.800000000000004},{"$f":"SUM(F25:F30)","v":73.5},{"$f":"SUM(G25:H30)","v":69.3},null,{"$f":"SUM(I25:I30)","v":62.000000000000007},{"$f":"SUM(J25:J30)","v":56.2},{"$f":"SUM(K25:L30)","v":59.3}]
[null,"MULTIPLE-VEHICLE CRASHES"]
[null,"Angle collision",null,null,10,7.2,8.5,null,0.8,0.7,0.8]
[null,"Head-on collision",null,null,3.4,0.3,1.6,null,5.8,1,3.6]
[null,"Rear-end collision",null,null,16.399999999999999,12.2,14.2,null,18.8,21.5,20.100000000000001]
[null,"Sideswipe collision",null,null,3.8,3.8,3.7,null,4.4000000000000004,7.1,5.6]
[null,"Other multiple-vehicle collision",null,null,2.6,3,2.7,null,8.1999999999999993,13.5,10.6]
[null,"Total multiple-vehicle crashes",null,null,{"$f":"SUM(E33:E37)","v":36.199999999999996},{"$f":"SUM(F33:F37)","v":26.5},{"$f":"SUM(G33:H37)","v":30.699999999999996},null,{"$f":"SUM(I33:I37)","v":38},{"$f":"SUM(J33:J37)","v":43.8},{"$f":"SUM(K33:L37)","v":40.700000000000003}]
[null,"TOTAL CRASHES",null,null,{"$f":"+E31+E38","v":100},{"$f":"+F31+F38","v":100},100,null,{"$f":"+I31+I38","v":100},{"$f":"+J31+J38","v":100},100]
[null,"Note:  HSM-provided values based on crash data for Washington (2002-2006); includes approximately 70 percent opposite-direction sideswipe and 30 percent same-direction sideswipe collisions."]
[]
[]
[null,"Table 10-12: Nighttime Crash Proportions for Unlighted Roadway Segments plus Locally-Derived Values"]
[null,"Roadway Type","HSM Default Values",null,null,null,null,null,"Locally Derived Values"]
[null,null,"Locally-Derived Values?",null,"No","Proportion of crashes that occur at night",null,null,"Proportion of total nighttime crashes by severity level",null,null,"Proportion of crashes that occur at night"]
[null,null,"Proportion of total nighttime crashes by severity level"]
[]
[null,null,"Fatal and Injury pinr",null,"PDO ppnr","pnr",null,null,"Fatal and Injury pinr",null,"PDO ppnr","pnr"]
[null,"2U",0.38200000000000001,null,0.61799999999999999,0.37,null,null,0.54,null,0.46,0.28000000000000003]
[null,"Note:  HSM-provided values based on HSIS data for Washington (2002-2006)"]

{"sheet":"Intersection1","index":4,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,0,1,12],[2,0,2,5],[2,6,2,12],[4,0,4,2],[4,3,4,5],[4,6,4,8],[4,9,4,12],[3,0,3,2],[3,3,3,5],[3,9,3,12],[7,0,7,5],[7,6,7,7],[7,8,7,12],[9,6,9,7],[9,8,9,12],[8,0,8,5],[8,6,8,7],[8,8,8,12],[3,6,3,8],[5,0,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,12],[6,0,6,2],[6,3,6,5],[6,6,6,8],[6,9,6,12],[11,10,11,11],[11,6,11,7],[10,6,10,7],[10,8,10,12],[12,0,12,5],[12,6,12,7],[12,8,12,12],[9,0,9,2],[10,0,10,2],[13,0,13,5],[13,6,13,7],[13,8,13,12],[18,0,18,12],[15,0,15,5],[15,6,15,7],[15,8,15,12],[14,0,14,5],[14,6,14,7],[14,8,14,12],[19,11,19,12],[19,5,19,7],[39,0,43,1],[38,0,38,1],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[28,8,29,8],[28,2,29,3],[20,0,20,2],[21,0,21,2],[22,0,22,2],[26,0,26,12],[24,8,24,10],[27,11,27,12],[20,8,20,10],[21,8,21,10],[22,8,22,10],[42,11,43,12],[32,9,32,10],[33,9,33,10],[39,9,41,10],[51,0,51,1],[51,3,51,4],[51,5,51,6],[51,7,51,8],[44,0,44,1],[44,3,44,4],[44,7,44,8],[44,11,44,12],[42,2,43,2],[42,3,43,4],[42,5,43,6],[42,7,43,8],[42,9,43,10],[44,5,44,6],[45,0,45,1],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[48,0,48,1],[48,3,48,4],[48,5,48,6],[48,7,48,8],[28,11,29,12],[30,11,31,12],[47,7,47,8],[56,7,56,8],[53,11,53,12],[47,11,47,12],[52,0,52,1],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,3,53,4],[49,0,49,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[50,0,50,1],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[44,9,44,10],[47,9,47,10],[34,9,34,10],[59,11,59,12],[57,7,57,8],[57,9,57,10],[58,7,58,8],[58,9,58,10],[56,11,56,12],[55,7,55,8],[55,9,55,10],[50,11,50,12],[48,9,48,10],[48,11,48,12],[20,11,20,12],[21,3,21,4],[22,3,22,4],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,8,23,10],[23,11,23,12],[27,9,27,10],[27,2,27,3],[20,3,20,4],[21,11,21,12],[22,11,22,12],[34,0,34,1],[54,0,54,12],[57,3,57,4],[57,5,57,6],[64,0,64,3],[64,4,64,7],[60,0,60,1],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[58,0,58,1],[58,3,58,4],[58,5,58,6],[56,9,56,10],[46,0,46,12],[47,0,47,1],[51,9,51,10],[51,11,51,12],[57,0,57,1],[55,0,55,1],[55,3,55,4],[53,0,53,1],[68,8,68,12],[69,8,69,12],[67,8,67,12],[67,0,67,3],[68,0,68,3],[69,0,69,3],[66,8,66,12],[65,0,66,3],[67,4,67,7],[68,4,68,7],[69,4,69,7],[65,4,65,7],[66,4,66,7],[65,8,65,12],[63,0,63,12],[53,5,53,6],[53,7,53,8],[53,9,53,10],[57,11,57,12],[64,8,64,12],[55,5,55,6],[56,0,56,1],[56,3,56,4],[56,5,56,6],[60,7,60,8],[55,11,55,12],[33,2,33,3],[34,2,34,3],[32,2,32,3],[33,0,33,1],[60,5,60,6],[60,3,60,4],[32,6,32,7],[33,6,33,7],[32,0,32,1],[39,2,41,2],[39,3,41,4],[39,5,41,6],[39,7,41,8],[37,0,37,12],[39,11,41,12],[34,6,34,7],[34,11,34,12],[32,11,32,12],[33,11,33,12],[60,9,60,10],[60,11,60,12],[58,11,58,12],[47,3,47,4],[47,5,47,6],[19,0,19,2],[23,0,23,2],[28,0,31,1],[28,9,31,10],[30,5,31,5],[30,6,31,7],[30,8,31,8],[27,6,27,7],[23,3,23,4],[23,5,23,7],[27,0,27,1],[24,0,24,2],[24,5,24,7],[28,4,29,4],[28,6,29,7],[30,2,31,3],[30,4,31,4],[19,3,19,4],[19,8,19,10],[28,5,29,5]]}
[]
["Worksheet 2A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Intersections"]
["General Information",null,null,null,null,null,"Location Information"]
["Analyst",null,null,null,null,null,"Roadway"]
["Agency or Company",null,null,null,null,null,"Intersection"]
["Date Performed",null,null,null,null,null,"Jurisdiction"]
[null,null,null,null,null,null,"Analysis Year"]
["Input Data",null,null,null,null,null,"Base Conditions",null,"Site Conditions"]
["Intersection type (3ST, 4ST, 4SG)",null,null,null,null,null,"--",null,null,null,null,null,null,null,{"$f":"IF($I$9=\"3ST\",\"Unsignalized three-leg (stop control on minor-road approaches)\",IF($I$9=\"4ST\",\"Unsignalized four-leg (stop control on minor-road approaches)\",\"Signalized four-leg\"))","v":"Signalized four-leg"}]
["AADTmajor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($I$9=\"3ST\",19500,IF($I$9=\"4ST\",14700,25200))","v":25200},"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I10>E10,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["AADTminor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($I$9=\"3ST\",4300,IF($I$9=\"4ST\",3500,12500))","v":12500},"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I11>E11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Intersection skew angle (degrees)",null,"[If 4ST, does skew differ for minor legs?]",null,null,null,0,null,"Skew for Leg 1 (All):",null,"Skew for Leg 2 (4ST only):",null,null,null,"Skew Intersection:"]
["Number of signalized or uncontrolled approaches with a left-turn lane (0, 1, 2, 3, 4)",null,null,null,null,null,0]
["Number of signalized or uncontrolled approaches with a right-turn lane (0, 1, 2, 3, 4)",null,null,null,null,null,0]
["Intersection lighting (present/not present)",null,null,null,null,null,"Not Present"]
["Calibration Factor, Ci",null,null,null,null,null,1]
[]
[]
["Worksheet 2B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,null,"(2)",null,"(3)",null,null,"(4)",null,null,"(5)"]
["CMF for Intersection Skew Angle",null,null,"CMF for Left-Turn Lanes",null,"CMF for Right-Turn Lanes",null,null,"CMF for Lighting",null,null,"Combined CMF"]
["CMF 1i",null,null,"CMF 2i",null,"CMF 3i",null,null,"CMF 4i",null,null,"CMF COMB"]
["from Equations 10-22 or 10-23",null,null,"from Table 10-13",null,"from Table 10-14",null,null,"from Equation 10-24",null,null,"(1)*(2)*(3)*(4)"]
[{"$f":"IF(+$I$9=\"3ST\",(EXP(0.004*$J$12)),(IF(+$I$9=\"4ST\",(IF($F$12=\"No\",(EXP(0.0054*$J$12)),(((EXP(0.0054*$J$12))+(EXP(0.0054*$M$12)))/2))),1)))","v":1},null,null,{"$f":"IF($I$9=\"3ST\",(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,3,FALSE)))),(IF($I$9=\"4ST\",(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,5,FALSE)))),(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,7,FALSE)))))))","v":1},null,{"$f":"IF($I$9=\"3ST\",(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,3,FALSE)))),(IF($I$9=\"4ST\",(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,5,FALSE)))),(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,7,FALSE)))))))","v":1},null,null,{"$f":"IF(($I$15=\"Not Present\"),1,(1-0.38*(IF('Intersection Tables'!$D$49=\"No\",(VLOOKUP( $I$9,'Intersection Tables'!$B$50:$F$52,4,FALSE)),(VLOOKUP($I$9,'Intersection Tables'!B50:H52,6,FALSE))))))","v":{"$error":"#N/A"}},null,null,{"$f":"+A24*D24*F24*I24","v":{"$error":"#N/A"}}]
[]
[]
["Worksheet 2C -- Intersection Crashes for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,"(2)",null,"(3)","(4)","(5)",null,"(6)","(7)",null,"(8)"]
["Crash Severity Level",null,"N spf 3ST, 4ST or 4SG",null,"Overdispersion Parameter, k","Crash Severity Distribution","N spf 3ST, 4ST or 4SG by Severity Distribution",null,"Combined CMFs","Calibration Factor, Ci",null,"Predicted average crash frequency,   N predicted int"]
[]
[null,null,"from Equations 10-8, 10-9, or 10-10",null,"from Section 10.6.2","  from Table  10-5","(2)TOTAL * (4)",null,"from (5) of Worksheet 2B",null,null,"(5)*(6)*(7)"]
[]
["Total",null,{"$f":"IF($I$9=\"3ST\",(EXP(-9.86+0.79*(LN($I$10))+(0.49*(LN($I$11))))),IF($I$9=\"4ST\",(EXP(-8.56+0.6*(LN($I$10))+(0.61*(LN($I$11))))),(EXP(-5.13+(0.6*(LN($I$10)))+(0.2*(LN($I$11)))))))","v":{"$error":"#NUM!"}},null,{"$f":"IF($I$9=\"3ST\",0.54,(IF($I$9=\"4ST\",0.24,0.11)))","v":0.11},{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$18,'Intersection Tables'!$K$18),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$18,'Intersection Tables'!$M$18)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$18,'Intersection Tables'!$O$18)))))/100","v":1},{"$f":"+C33*F33","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G33*I33*J33","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,"--",null,"--",{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$16,'Intersection Tables'!$K$16),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$16,'Intersection Tables'!$M$16)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$16,'Intersection Tables'!$O$16)))))/100","v":0.34},{"$f":"+C33*F34","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G34*I34*J34","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,"--",null,"--",{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$17,'Intersection Tables'!$K$17),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$17,'Intersection Tables'!$M$17)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$17,'Intersection Tables'!$O$17)))))/100","v":0.66},{"$f":"+C33*F35","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G35*I35*J35","v":{"$error":"#NUM!"}}]
[]
[]
["Worksheet 2D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Road Intersections"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted int (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted int (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted int (PDO) (crashes/year)"]
[]
[]
[null,null,"    from Table  10-6","(8)TOTAL from Worksheet 2C",null,"from Table 10-6",null,"(8)FI from Worksheet 2C",null,"from Table 10-6",null,"(8)PDO from Worksheet 2C"]
[]
["Total",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G43,(IF($I$9=\"4ST\",'Intersection Tables'!J43,'Intersection Tables'!M43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P43,(IF($I$9=\"4ST\",+'Intersection Tables'!S43,+'Intersection Tables'!V43)))/100))","v":1},{"$f":"+L33","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E43,(IF($I$9=\"4ST\",'Intersection Tables'!H43,'Intersection Tables'!K43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N43,(IF($I$9=\"4ST\",+'Intersection Tables'!Q43,+'Intersection Tables'!T43)))/100))","v":1},null,{"$f":"+L34","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F43,(IF($I$9=\"4ST\",'Intersection Tables'!I43,'Intersection Tables'!L43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O43,(IF($I$9=\"4ST\",+'Intersection Tables'!R43,+'Intersection Tables'!U43)))/100))","v":1},null,{"$f":"+L35","v":{"$error":"#NUM!"}}]
[null,null,null,"(2)x(3)TOTAL",null,null,null,"(4)x(5)FI",null,null,null,"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G29,(IF($I$9=\"4ST\",'Intersection Tables'!J29,'Intersection Tables'!M29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P29,(IF($I$9=\"4ST\",+'Intersection Tables'!S29,+'Intersection Tables'!V29)))/100))","v":2E-3},{"$f":"+C48*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E29,(IF($I$9=\"4ST\",'Intersection Tables'!H29,'Intersection Tables'!K29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N29,(IF($I$9=\"4ST\",+'Intersection Tables'!Q29,+'Intersection Tables'!T29)))/100))","v":0},null,{"$f":"+$H$45*F48","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F29,(IF($I$9=\"4ST\",'Intersection Tables'!I29,'Intersection Tables'!L29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O29,(IF($I$9=\"4ST\",+'Intersection Tables'!R29,+'Intersection Tables'!U29)))/100))","v":3.0000000000000001E-3},null,{"$f":"+$L$45*J48","v":{"$error":"#NUM!"}}]
["Collision with bicycle",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G30,(IF($I$9=\"4ST\",'Intersection Tables'!J30,'Intersection Tables'!M30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P30,(IF($I$9=\"4ST\",+'Intersection Tables'!S30,+'Intersection Tables'!V30)))/100))","v":1E-3},{"$f":"+C49*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E30,(IF($I$9=\"4ST\",'Intersection Tables'!H30,'Intersection Tables'!K30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N30,(IF($I$9=\"4ST\",+'Intersection Tables'!Q30,+'Intersection Tables'!T30)))/100))","v":1E-3},null,{"$f":"+$H$45*F49","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F30,(IF($I$9=\"4ST\",'Intersection Tables'!I30,'Intersection Tables'!L30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O30,(IF($I$9=\"4ST\",+'Intersection Tables'!R30,+'Intersection Tables'!U30)))/100))","v":1E-3},null,{"$f":"+$L$45*J49","v":{"$error":"#NUM!"}}]
["Collision with pedestrian",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G31,(IF($I$9=\"4ST\",'Intersection Tables'!J31,'Intersection Tables'!M31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P31,(IF($I$9=\"4ST\",+'Intersection Tables'!S31,+'Intersection Tables'!V31)))/100))","v":1E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E31,(IF($I$9=\"4ST\",'Intersection Tables'!H31,'Intersection Tables'!K31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N31,(IF($I$9=\"4ST\",+'Intersection Tables'!Q31,+'Intersection Tables'!T31)))/100))","v":1E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F31,(IF($I$9=\"4ST\",'Intersection Tables'!I31,'Intersection Tables'!L31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O31,(IF($I$9=\"4ST\",+'Intersection Tables'!R31,+'Intersection Tables'!U31)))/100))","v":1E-3},null,{"$error":"#NUM!"}]
["Overturned",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G32,(IF($I$9=\"4ST\",'Intersection Tables'!J32,'Intersection Tables'!M32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P32,(IF($I$9=\"4ST\",+'Intersection Tables'!S32,+'Intersection Tables'!V32)))/100))","v":3.0000000000000001E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E32,(IF($I$9=\"4ST\",'Intersection Tables'!H32,'Intersection Tables'!K32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N32,(IF($I$9=\"4ST\",+'Intersection Tables'!Q32,+'Intersection Tables'!T32)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F32,(IF($I$9=\"4ST\",'Intersection Tables'!I32,'Intersection Tables'!L32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O32,(IF($I$9=\"4ST\",+'Intersection Tables'!R32,+'Intersection Tables'!U32)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"}]
["Ran off road",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G33,(IF($I$9=\"4ST\",'Intersection Tables'!J33,'Intersection Tables'!M33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P33,(IF($I$9=\"4ST\",+'Intersection Tables'!S33,+'Intersection Tables'!V33)))/100))","v":6.4000000000000001E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E33,(IF($I$9=\"4ST\",'Intersection Tables'!H33,'Intersection Tables'!K33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N33,(IF($I$9=\"4ST\",+'Intersection Tables'!Q33,+'Intersection Tables'!T33)))/100))","v":3.2000000000000001E-2},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F33,(IF($I$9=\"4ST\",'Intersection Tables'!I33,'Intersection Tables'!L33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O33,(IF($I$9=\"4ST\",+'Intersection Tables'!R33,+'Intersection Tables'!U33)))/100))","v":8.1000000000000003E-2},null,{"$error":"#NUM!"}]
["Other single-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G34,(IF($I$9=\"4ST\",'Intersection Tables'!J34,'Intersection Tables'!M34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P34,(IF($I$9=\"4ST\",+'Intersection Tables'!S34,+'Intersection Tables'!V34)))/100))","v":5.0000000000000001E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E34,(IF($I$9=\"4ST\",'Intersection Tables'!H34,'Intersection Tables'!K34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N34,(IF($I$9=\"4ST\",+'Intersection Tables'!Q34,+'Intersection Tables'!T34)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F34,(IF($I$9=\"4ST\",'Intersection Tables'!I34,'Intersection Tables'!L34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O34,(IF($I$9=\"4ST\",+'Intersection Tables'!R34,+'Intersection Tables'!U34)))/100))","v":1.8000000000000002E-2},null,{"$error":"#NUM!"}]
["Total single-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G35,(IF($I$9=\"4ST\",'Intersection Tables'!J35,'Intersection Tables'!M35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P35,(IF($I$9=\"4ST\",+'Intersection Tables'!S35,+'Intersection Tables'!V35)))/100))","v":7.6000000000000012E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E35,(IF($I$9=\"4ST\",'Intersection Tables'!H35,'Intersection Tables'!K35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N35,(IF($I$9=\"4ST\",+'Intersection Tables'!Q35,+'Intersection Tables'!T35)))/100))","v":0.04},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F35,(IF($I$9=\"4ST\",'Intersection Tables'!I35,'Intersection Tables'!L35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O35,(IF($I$9=\"4ST\",+'Intersection Tables'!R35,+'Intersection Tables'!U35)))/100))","v":0.10700000000000001},null,{"$error":"#NUM!"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G37,(IF($I$9=\"4ST\",'Intersection Tables'!J37,'Intersection Tables'!M37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P37,(IF($I$9=\"4ST\",+'Intersection Tables'!S37,+'Intersection Tables'!V37)))/100))","v":0.27399999999999997},{"$f":"+C56*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E37,(IF($I$9=\"4ST\",'Intersection Tables'!H37,'Intersection Tables'!K37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N37,(IF($I$9=\"4ST\",+'Intersection Tables'!Q37,+'Intersection Tables'!T37)))/100))","v":0.33600000000000002},null,{"$f":"+$H$45*F56","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F37,(IF($I$9=\"4ST\",'Intersection Tables'!I37,'Intersection Tables'!L37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O37,(IF($I$9=\"4ST\",+'Intersection Tables'!R37,+'Intersection Tables'!U37)))/100))","v":0.24199999999999999},null,{"$f":"+$L$45*J56","v":{"$error":"#NUM!"}}]
["Head-on collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G38,(IF($I$9=\"4ST\",'Intersection Tables'!J38,'Intersection Tables'!M38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P38,(IF($I$9=\"4ST\",+'Intersection Tables'!S38,+'Intersection Tables'!V38)))/100))","v":5.4000000000000006E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E38,(IF($I$9=\"4ST\",'Intersection Tables'!H38,'Intersection Tables'!K38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N38,(IF($I$9=\"4ST\",+'Intersection Tables'!Q38,+'Intersection Tables'!T38)))/100))","v":0.08},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F38,(IF($I$9=\"4ST\",'Intersection Tables'!I38,'Intersection Tables'!L38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O38,(IF($I$9=\"4ST\",+'Intersection Tables'!R38,+'Intersection Tables'!U38)))/100))","v":0.04},null,{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G39,(IF($I$9=\"4ST\",'Intersection Tables'!J39,'Intersection Tables'!M39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P39,(IF($I$9=\"4ST\",+'Intersection Tables'!S39,+'Intersection Tables'!V39)))/100))","v":0.42599999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E39,(IF($I$9=\"4ST\",'Intersection Tables'!H39,'Intersection Tables'!K39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N39,(IF($I$9=\"4ST\",+'Intersection Tables'!Q39,+'Intersection Tables'!T39)))/100))","v":0.40299999999999997},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F39,(IF($I$9=\"4ST\",'Intersection Tables'!I39,'Intersection Tables'!L39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O39,(IF($I$9=\"4ST\",+'Intersection Tables'!R39,+'Intersection Tables'!U39)))/100))","v":0.43799999999999994},null,{"$error":"#NUM!"}]
["Sideswipe collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G40,(IF($I$9=\"4ST\",'Intersection Tables'!J40,'Intersection Tables'!M40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P40,(IF($I$9=\"4ST\",+'Intersection Tables'!S40,+'Intersection Tables'!V40)))/100))","v":0.11800000000000001},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E40,(IF($I$9=\"4ST\",'Intersection Tables'!H40,'Intersection Tables'!K40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N40,(IF($I$9=\"4ST\",+'Intersection Tables'!Q40,+'Intersection Tables'!T40)))/100))","v":5.0999999999999997E-2},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F40,(IF($I$9=\"4ST\",'Intersection Tables'!I40,'Intersection Tables'!L40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O40,(IF($I$9=\"4ST\",+'Intersection Tables'!R40,+'Intersection Tables'!U40)))/100))","v":0.153},null,{"$error":"#NUM!"}]
["Other multiple-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G41,(IF($I$9=\"4ST\",'Intersection Tables'!J41,'Intersection Tables'!M41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P41,(IF($I$9=\"4ST\",+'Intersection Tables'!S41,+'Intersection Tables'!V41)))/100))","v":5.2000000000000005E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E41,(IF($I$9=\"4ST\",'Intersection Tables'!H41,'Intersection Tables'!K41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N41,(IF($I$9=\"4ST\",+'Intersection Tables'!Q41,+'Intersection Tables'!T41)))/100))","v":0.09},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F41,(IF($I$9=\"4ST\",'Intersection Tables'!I41,'Intersection Tables'!L41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O41,(IF($I$9=\"4ST\",+'Intersection Tables'!R41,+'Intersection Tables'!U41)))/100))","v":0.02},null,{"$error":"#NUM!"}]
["Total multiple-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G42,(IF($I$9=\"4ST\",'Intersection Tables'!J42,'Intersection Tables'!M42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P42,(IF($I$9=\"4ST\",+'Intersection Tables'!S42,+'Intersection Tables'!V42)))/100))","v":0.92400000000000004},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E42,(IF($I$9=\"4ST\",'Intersection Tables'!H42,'Intersection Tables'!K42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N42,(IF($I$9=\"4ST\",+'Intersection Tables'!Q42,+'Intersection Tables'!T42)))/100))","v":0.96},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F42,(IF($I$9=\"4ST\",'Intersection Tables'!I42,'Intersection Tables'!L42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O42,(IF($I$9=\"4ST\",+'Intersection Tables'!R42,+'Intersection Tables'!U42)))/100))","v":0.89300000000000002},null,{"$error":"#NUM!"}]
[]
[]
["Worksheet 2E -- Summary Results for Rural Two-Lane Two-Way Road Intersections"]
["(1)",null,null,null,"(2)",null,null,null,"(3)"]
["Crash severity level",null,null,null,"Crash Severity Distribution (proportion)",null,null,null,"Predicted average crash frequency (crashes / year)"]
[null,null,null,null,"(4) from Worksheet 2C",null,null,null,"(8) from Worksheet 2C"]
["Total",null,null,null,{"$f":"+F33","v":1},null,null,null,{"$f":"+L33","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,null,null,{"$f":"+F34","v":0.34},null,null,null,{"$f":"+L34","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,null,null,{"$f":"+F35","v":0.66},null,null,null,{"$f":"+L35","v":{"$error":"#NUM!"}}]

{"sheet":"Intersection2","index":5,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,0,69,3],[69,4,69,7],[69,8,69,12],[67,0,67,3],[67,4,67,7],[67,8,67,12],[68,0,68,3],[68,4,68,7],[68,8,68,12],[63,0,63,12],[64,0,64,3],[64,4,64,7],[64,8,64,12],[65,0,66,3],[65,4,65,7],[65,8,65,12],[66,4,66,7],[66,8,66,12],[60,0,60,1],[60,3,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[59,0,59,1],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[58,0,58,1],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[57,0,57,1],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[56,0,56,1],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[54,0,54,12],[55,0,55,1],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[53,0,53,1],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[52,0,52,1],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[51,0,51,1],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[50,0,50,1],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[49,0,49,1],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[48,0,48,1],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[46,0,46,12],[47,0,47,1],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[45,0,45,1],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[44,0,44,1],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[39,11,41,12],[42,2,43,2],[42,3,43,4],[42,5,43,6],[42,7,43,8],[42,9,43,10],[42,11,43,12],[39,0,43,1],[39,2,41,2],[39,3,41,4],[39,5,41,6],[39,7,41,8],[39,9,41,10],[38,0,38,1],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[34,0,34,1],[34,2,34,3],[34,6,34,7],[34,9,34,10],[34,11,34,12],[37,0,37,12],[32,0,32,1],[32,2,32,3],[32,6,32,7],[32,9,32,10],[32,11,32,12],[33,0,33,1],[33,2,33,3],[33,6,33,7],[33,9,33,10],[33,11,33,12],[28,9,31,10],[28,11,29,12],[30,2,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,7],[30,8,31,8],[30,11,31,12],[28,0,31,1],[28,2,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,7],[28,8,29,8],[24,0,24,2],[24,5,24,7],[24,8,24,10],[26,0,26,12],[27,0,27,1],[27,2,27,3],[27,6,27,7],[27,9,27,10],[27,11,27,12],[22,0,22,2],[22,3,22,4],[22,5,22,7],[22,8,22,10],[22,11,22,12],[23,0,23,2],[23,3,23,4],[23,5,23,7],[23,8,23,10],[23,11,23,12],[20,0,20,2],[20,3,20,4],[20,5,20,7],[20,8,20,10],[20,11,20,12],[21,0,21,2],[21,3,21,4],[21,5,21,7],[21,8,21,10],[21,11,21,12],[15,0,15,5],[15,6,15,7],[15,8,15,12],[18,0,18,12],[19,0,19,2],[19,3,19,4],[19,5,19,7],[19,8,19,10],[19,11,19,12],[13,0,13,5],[13,6,13,7],[13,8,13,12],[14,0,14,5],[14,6,14,7],[14,8,14,12],[10,6,10,7],[10,8,10,12],[11,6,11,7],[11,10,11,11],[12,0,12,5],[12,6,12,7],[12,8,12,12],[10,0,10,2],[8,0,8,5],[8,6,8,7],[8,8,8,12],[9,6,9,7],[9,8,9,12],[9,0,9,2],[6,0,6,2],[6,3,6,5],[6,6,6,8],[6,9,6,12],[7,0,7,5],[7,6,7,7],[7,8,7,12],[4,0,4,2],[4,3,4,5],[4,6,4,8],[4,9,4,12],[5,0,5,2],[5,3,5,5],[5,6,5,8],[5,9,5,12],[1,0,1,12],[2,0,2,5],[2,6,2,12],[3,0,3,2],[3,3,3,5],[3,6,3,8],[3,9,3,12]]}
[]
["Worksheet 2A -- General Information and Input Data for Rural Two-Lane Two-Way Roadway Intersections"]
["General Information",null,null,null,null,null,"Location Information"]
["Analyst",null,null,null,null,null,"Roadway"]
["Agency or Company",null,null,null,null,null,"Intersection"]
["Date Performed",null,null,null,null,null,"Jurisdiction"]
[null,null,null,null,null,null,"Analysis Year"]
["Input Data",null,null,null,null,null,"Base Conditions",null,"Site Conditions"]
["Intersection type (3ST, 4ST, 4SG)",null,null,null,null,null,"--",null,null,null,null,null,null,null,{"$f":"IF($I$9=\"3ST\",\"Unsignalized three-leg (stop control on minor-road approaches)\",IF($I$9=\"4ST\",\"Unsignalized four-leg (stop control on minor-road approaches)\",\"Signalized four-leg\"))","v":"Signalized four-leg"}]
["AADTmajor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($I$9=\"3ST\",19500,IF($I$9=\"4ST\",14700,25200))","v":25200},"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I10>E10,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["AADTminor (veh/day)",null,null,"AADTMAX =",{"$f":"IF($I$9=\"3ST\",4300,IF($I$9=\"4ST\",3500,12500))","v":12500},"(veh/day)","--",null,null,null,null,null,null,{"$f":"IF(I11>E11,\"AADT out of range\",\"AADT OK\")","v":"AADT OK"}]
["Intersection skew angle (degrees)",null,"[If 4ST, does skew differ for minor legs?]",null,null,null,0,null,"Skew for Leg 1 (All):",null,"Skew for Leg 2 (4ST only):",null,null,null,"Skew Intersection:"]
["Number of signalized or uncontrolled approaches with a left-turn lane (0, 1, 2, 3, 4)",null,null,null,null,null,0]
["Number of signalized or uncontrolled approaches with a right-turn lane (0, 1, 2, 3, 4)",null,null,null,null,null,0]
["Intersection lighting (present/not present)",null,null,null,null,null,"Not Present"]
["Calibration Factor, Ci",null,null,null,null,null,1]
[]
[]
["Worksheet 2B -- Crash Modification Factors for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,null,"(2)",null,"(3)",null,null,"(4)",null,null,"(5)"]
["CMF for Intersection Skew Angle",null,null,"CMF for Left-Turn Lanes",null,"CMF for Right-Turn Lanes",null,null,"CMF for Lighting",null,null,"Combined CMF"]
["CMF 1i",null,null,"CMF 2i",null,"CMF 3i",null,null,"CMF 4i",null,null,"CMF COMB"]
["from Equations 10-22 or 10-23",null,null,"from Table 10-13",null,"from Table 10-14",null,null,"from Equation 10-24",null,null,"(1)*(2)*(3)*(4)"]
[{"$f":"IF(+$I$9=\"3ST\",(EXP(0.004*$J$12)),(IF(+$I$9=\"4ST\",(IF($F$12=\"No\",(EXP(0.0054*$J$12)),(((EXP(0.0054*$J$12))+(EXP(0.0054*$M$12)))/2))),1)))","v":1},null,null,{"$f":"IF($I$9=\"3ST\",(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,3,FALSE)))),(IF($I$9=\"4ST\",(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,5,FALSE)))),(IF($I$13=0,1,(HLOOKUP($I$13,'Intersection Tables'!$AC$9:$AF$15,7,FALSE)))))))","v":1},null,{"$f":"IF($I$9=\"3ST\",(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,3,FALSE)))),(IF($I$9=\"4ST\",(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,5,FALSE)))),(IF($I$14=0,1,(HLOOKUP($I$14,'Intersection Tables'!$AC$25:$AF$31,7,FALSE)))))))","v":1},null,null,{"$f":"IF(($I$15=\"Not Present\"),1,(1-0.38*(IF('Intersection Tables'!$D$49=\"No\",(VLOOKUP( $I$9,'Intersection Tables'!$B$50:$F$52,4,FALSE)),(VLOOKUP($I$9,'Intersection Tables'!B50:H52,6,FALSE))))))","v":{"$error":"#N/A"}},null,null,{"$f":"+A24*D24*F24*I24","v":{"$error":"#N/A"}}]
[]
[]
["Worksheet 2C -- Intersection Crashes for Rural Two-Lane Two-Way Roadway Intersections"]
["(1)",null,"(2)",null,"(3)","(4)","(5)",null,"(6)","(7)",null,"(8)"]
["Crash Severity Level",null,"N spf 3ST, 4ST or 4SG",null,"Overdispersion Parameter, k","Crash Severity Distribution","N spf 3ST, 4ST or 4SG by Severity Distribution",null,"Combined CMFs","Calibration Factor, Ci",null,"Predicted average crash frequency,   N predicted int"]
[]
[null,null,"from Equations 10-8, 10-9, or 10-10",null,"from Section 10.6.2","  from Table  10-5","(2)TOTAL * (4)",null,"from (5) of Worksheet 2B",null,null,"(5)*(6)*(7)"]
[]
["Total",null,{"$f":"IF($I$9=\"3ST\",(EXP(-9.86+0.79*(LN($I$10))+(0.49*(LN($I$11))))),IF($I$9=\"4ST\",(EXP(-8.56+0.6*(LN($I$10))+(0.61*(LN($I$11))))),(EXP(-5.13+(0.6*(LN($I$10)))+(0.2*(LN($I$11)))))))","v":{"$error":"#NUM!"}},null,{"$f":"IF($I$9=\"3ST\",0.54,(IF($I$9=\"4ST\",0.24,0.11)))","v":0.11},{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$18,'Intersection Tables'!$K$18),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$18,'Intersection Tables'!$M$18)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$18,'Intersection Tables'!$O$18)))))/100","v":1},{"$f":"+C33*F33","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G33*I33*J33","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,"--",null,"--",{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$16,'Intersection Tables'!$K$16),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$16,'Intersection Tables'!$M$16)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$16,'Intersection Tables'!$O$16)))))/100","v":0.34},{"$f":"+C33*F34","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G34*I34*J34","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,"--",null,"--",{"$f":"IF($I$9=\"3ST\",IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$E$17,'Intersection Tables'!$K$17),(IF($I$9=\"4ST\",(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$G$17,'Intersection Tables'!$M$17)),(IF('Intersection Tables'!$D$10=\"No\",'Intersection Tables'!$I$17,'Intersection Tables'!$O$17)))))/100","v":0.66},{"$f":"+C33*F35","v":{"$error":"#NUM!"}},null,{"$f":"+$L$24","v":{"$error":"#N/A"}},{"$f":"+$I$16","v":0},null,{"$f":"+G35*I35*J35","v":{"$error":"#NUM!"}}]
[]
[]
["Worksheet 2D -- Crashes by Severity Level and Collision Type for Rural Two-Lane Two-Way Road Intersections"]
["(1)",null,"(2)","(3)",null,"(4)",null,"(5)",null,"(6)",null,"(7)"]
["Collision Type",null,"Proportion of Collision Type(TOTAL)","N predicted int (TOTAL) (crashes/year)",null,"Proportion of Collision Type(FI)",null,"N predicted int (FI) (crashes/year)",null,"Proportion of Collision Type(PDO)",null,"N predicted int (PDO) (crashes/year)"]
[]
[]
[null,null,"    from Table  10-6","(8)TOTAL from Worksheet 2C",null,"from Table 10-6",null,"(8)FI from Worksheet 2C",null,"from Table 10-6",null,"(8)PDO from Worksheet 2C"]
[]
["Total",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G43,(IF($I$9=\"4ST\",'Intersection Tables'!J43,'Intersection Tables'!M43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P43,(IF($I$9=\"4ST\",+'Intersection Tables'!S43,+'Intersection Tables'!V43)))/100))","v":1},{"$f":"+L33","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E43,(IF($I$9=\"4ST\",'Intersection Tables'!H43,'Intersection Tables'!K43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N43,(IF($I$9=\"4ST\",+'Intersection Tables'!Q43,+'Intersection Tables'!T43)))/100))","v":1},null,{"$f":"+L34","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F43,(IF($I$9=\"4ST\",'Intersection Tables'!I43,'Intersection Tables'!L43)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O43,(IF($I$9=\"4ST\",+'Intersection Tables'!R43,+'Intersection Tables'!U43)))/100))","v":1},null,{"$f":"+L35","v":{"$error":"#NUM!"}}]
[null,null,null,"(2)x(3)TOTAL",null,null,null,"(4)x(5)FI",null,null,null,"(6)x(7)PDO"]
["SINGLE-VEHICLE"]
["Collision with animal",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G29,(IF($I$9=\"4ST\",'Intersection Tables'!J29,'Intersection Tables'!M29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P29,(IF($I$9=\"4ST\",+'Intersection Tables'!S29,+'Intersection Tables'!V29)))/100))","v":2E-3},{"$f":"+C48*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E29,(IF($I$9=\"4ST\",'Intersection Tables'!H29,'Intersection Tables'!K29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N29,(IF($I$9=\"4ST\",+'Intersection Tables'!Q29,+'Intersection Tables'!T29)))/100))","v":0},null,{"$f":"+$H$45*F48","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F29,(IF($I$9=\"4ST\",'Intersection Tables'!I29,'Intersection Tables'!L29)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O29,(IF($I$9=\"4ST\",+'Intersection Tables'!R29,+'Intersection Tables'!U29)))/100))","v":3.0000000000000001E-3},null,{"$f":"+$L$45*J48","v":{"$error":"#NUM!"}}]
["Collision with bicycle",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G30,(IF($I$9=\"4ST\",'Intersection Tables'!J30,'Intersection Tables'!M30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P30,(IF($I$9=\"4ST\",+'Intersection Tables'!S30,+'Intersection Tables'!V30)))/100))","v":1E-3},{"$f":"+C49*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E30,(IF($I$9=\"4ST\",'Intersection Tables'!H30,'Intersection Tables'!K30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N30,(IF($I$9=\"4ST\",+'Intersection Tables'!Q30,+'Intersection Tables'!T30)))/100))","v":1E-3},null,{"$f":"+$H$45*F49","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F30,(IF($I$9=\"4ST\",'Intersection Tables'!I30,'Intersection Tables'!L30)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O30,(IF($I$9=\"4ST\",+'Intersection Tables'!R30,+'Intersection Tables'!U30)))/100))","v":1E-3},null,{"$f":"+$L$45*J49","v":{"$error":"#NUM!"}}]
["Collision with pedestrian",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G31,(IF($I$9=\"4ST\",'Intersection Tables'!J31,'Intersection Tables'!M31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P31,(IF($I$9=\"4ST\",+'Intersection Tables'!S31,+'Intersection Tables'!V31)))/100))","v":1E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E31,(IF($I$9=\"4ST\",'Intersection Tables'!H31,'Intersection Tables'!K31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N31,(IF($I$9=\"4ST\",+'Intersection Tables'!Q31,+'Intersection Tables'!T31)))/100))","v":1E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F31,(IF($I$9=\"4ST\",'Intersection Tables'!I31,'Intersection Tables'!L31)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O31,(IF($I$9=\"4ST\",+'Intersection Tables'!R31,+'Intersection Tables'!U31)))/100))","v":1E-3},null,{"$error":"#NUM!"}]
["Overturned",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G32,(IF($I$9=\"4ST\",'Intersection Tables'!J32,'Intersection Tables'!M32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P32,(IF($I$9=\"4ST\",+'Intersection Tables'!S32,+'Intersection Tables'!V32)))/100))","v":3.0000000000000001E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E32,(IF($I$9=\"4ST\",'Intersection Tables'!H32,'Intersection Tables'!K32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N32,(IF($I$9=\"4ST\",+'Intersection Tables'!Q32,+'Intersection Tables'!T32)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F32,(IF($I$9=\"4ST\",'Intersection Tables'!I32,'Intersection Tables'!L32)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O32,(IF($I$9=\"4ST\",+'Intersection Tables'!R32,+'Intersection Tables'!U32)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"}]
["Ran off road",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G33,(IF($I$9=\"4ST\",'Intersection Tables'!J33,'Intersection Tables'!M33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P33,(IF($I$9=\"4ST\",+'Intersection Tables'!S33,+'Intersection Tables'!V33)))/100))","v":6.4000000000000001E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E33,(IF($I$9=\"4ST\",'Intersection Tables'!H33,'Intersection Tables'!K33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N33,(IF($I$9=\"4ST\",+'Intersection Tables'!Q33,+'Intersection Tables'!T33)))/100))","v":3.2000000000000001E-2},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F33,(IF($I$9=\"4ST\",'Intersection Tables'!I33,'Intersection Tables'!L33)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O33,(IF($I$9=\"4ST\",+'Intersection Tables'!R33,+'Intersection Tables'!U33)))/100))","v":8.1000000000000003E-2},null,{"$error":"#NUM!"}]
["Other single-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G34,(IF($I$9=\"4ST\",'Intersection Tables'!J34,'Intersection Tables'!M34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P34,(IF($I$9=\"4ST\",+'Intersection Tables'!S34,+'Intersection Tables'!V34)))/100))","v":5.0000000000000001E-3},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E34,(IF($I$9=\"4ST\",'Intersection Tables'!H34,'Intersection Tables'!K34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N34,(IF($I$9=\"4ST\",+'Intersection Tables'!Q34,+'Intersection Tables'!T34)))/100))","v":3.0000000000000001E-3},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F34,(IF($I$9=\"4ST\",'Intersection Tables'!I34,'Intersection Tables'!L34)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O34,(IF($I$9=\"4ST\",+'Intersection Tables'!R34,+'Intersection Tables'!U34)))/100))","v":1.8000000000000002E-2},null,{"$error":"#NUM!"}]
["Total single-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G35,(IF($I$9=\"4ST\",'Intersection Tables'!J35,'Intersection Tables'!M35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P35,(IF($I$9=\"4ST\",+'Intersection Tables'!S35,+'Intersection Tables'!V35)))/100))","v":7.6000000000000012E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E35,(IF($I$9=\"4ST\",'Intersection Tables'!H35,'Intersection Tables'!K35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N35,(IF($I$9=\"4ST\",+'Intersection Tables'!Q35,+'Intersection Tables'!T35)))/100))","v":0.04},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F35,(IF($I$9=\"4ST\",'Intersection Tables'!I35,'Intersection Tables'!L35)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O35,(IF($I$9=\"4ST\",+'Intersection Tables'!R35,+'Intersection Tables'!U35)))/100))","v":0.10700000000000001},null,{"$error":"#NUM!"}]
["MULTIPLE-VEHICLE"]
["Angle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G37,(IF($I$9=\"4ST\",'Intersection Tables'!J37,'Intersection Tables'!M37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P37,(IF($I$9=\"4ST\",+'Intersection Tables'!S37,+'Intersection Tables'!V37)))/100))","v":0.27399999999999997},{"$f":"+C56*$D$45","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E37,(IF($I$9=\"4ST\",'Intersection Tables'!H37,'Intersection Tables'!K37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N37,(IF($I$9=\"4ST\",+'Intersection Tables'!Q37,+'Intersection Tables'!T37)))/100))","v":0.33600000000000002},null,{"$f":"+$H$45*F56","v":{"$error":"#NUM!"}},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F37,(IF($I$9=\"4ST\",'Intersection Tables'!I37,'Intersection Tables'!L37)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O37,(IF($I$9=\"4ST\",+'Intersection Tables'!R37,+'Intersection Tables'!U37)))/100))","v":0.24199999999999999},null,{"$f":"+$L$45*J56","v":{"$error":"#NUM!"}}]
["Head-on collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G38,(IF($I$9=\"4ST\",'Intersection Tables'!J38,'Intersection Tables'!M38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P38,(IF($I$9=\"4ST\",+'Intersection Tables'!S38,+'Intersection Tables'!V38)))/100))","v":5.4000000000000006E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E38,(IF($I$9=\"4ST\",'Intersection Tables'!H38,'Intersection Tables'!K38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N38,(IF($I$9=\"4ST\",+'Intersection Tables'!Q38,+'Intersection Tables'!T38)))/100))","v":0.08},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F38,(IF($I$9=\"4ST\",'Intersection Tables'!I38,'Intersection Tables'!L38)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O38,(IF($I$9=\"4ST\",+'Intersection Tables'!R38,+'Intersection Tables'!U38)))/100))","v":0.04},null,{"$error":"#NUM!"}]
["Rear-end collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G39,(IF($I$9=\"4ST\",'Intersection Tables'!J39,'Intersection Tables'!M39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P39,(IF($I$9=\"4ST\",+'Intersection Tables'!S39,+'Intersection Tables'!V39)))/100))","v":0.42599999999999999},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E39,(IF($I$9=\"4ST\",'Intersection Tables'!H39,'Intersection Tables'!K39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N39,(IF($I$9=\"4ST\",+'Intersection Tables'!Q39,+'Intersection Tables'!T39)))/100))","v":0.40299999999999997},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F39,(IF($I$9=\"4ST\",'Intersection Tables'!I39,'Intersection Tables'!L39)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O39,(IF($I$9=\"4ST\",+'Intersection Tables'!R39,+'Intersection Tables'!U39)))/100))","v":0.43799999999999994},null,{"$error":"#NUM!"}]
["Sideswipe collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G40,(IF($I$9=\"4ST\",'Intersection Tables'!J40,'Intersection Tables'!M40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P40,(IF($I$9=\"4ST\",+'Intersection Tables'!S40,+'Intersection Tables'!V40)))/100))","v":0.11800000000000001},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E40,(IF($I$9=\"4ST\",'Intersection Tables'!H40,'Intersection Tables'!K40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N40,(IF($I$9=\"4ST\",+'Intersection Tables'!Q40,+'Intersection Tables'!T40)))/100))","v":5.0999999999999997E-2},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F40,(IF($I$9=\"4ST\",'Intersection Tables'!I40,'Intersection Tables'!L40)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O40,(IF($I$9=\"4ST\",+'Intersection Tables'!R40,+'Intersection Tables'!U40)))/100))","v":0.153},null,{"$error":"#NUM!"}]
["Other multiple-vehicle collision",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G41,(IF($I$9=\"4ST\",'Intersection Tables'!J41,'Intersection Tables'!M41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P41,(IF($I$9=\"4ST\",+'Intersection Tables'!S41,+'Intersection Tables'!V41)))/100))","v":5.2000000000000005E-2},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E41,(IF($I$9=\"4ST\",'Intersection Tables'!H41,'Intersection Tables'!K41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N41,(IF($I$9=\"4ST\",+'Intersection Tables'!Q41,+'Intersection Tables'!T41)))/100))","v":0.09},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F41,(IF($I$9=\"4ST\",'Intersection Tables'!I41,'Intersection Tables'!L41)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O41,(IF($I$9=\"4ST\",+'Intersection Tables'!R41,+'Intersection Tables'!U41)))/100))","v":0.02},null,{"$error":"#NUM!"}]
["Total multiple-vehicle crashes",null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!G42,(IF($I$9=\"4ST\",'Intersection Tables'!J42,'Intersection Tables'!M42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!P42,(IF($I$9=\"4ST\",+'Intersection Tables'!S42,+'Intersection Tables'!V42)))/100))","v":0.92400000000000004},{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!E42,(IF($I$9=\"4ST\",'Intersection Tables'!H42,'Intersection Tables'!K42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!N42,(IF($I$9=\"4ST\",+'Intersection Tables'!Q42,+'Intersection Tables'!T42)))/100))","v":0.96},null,{"$error":"#NUM!"},null,{"$f":"IF('Intersection Tables'!$D$27=\"No\",(IF($I$9=\"3ST\",'Intersection Tables'!F42,(IF($I$9=\"4ST\",'Intersection Tables'!I42,'Intersection Tables'!L42)))/100),(IF($I$9=\"3ST\",'Intersection Tables'!O42,(IF($I$9=\"4ST\",+'Intersection Tables'!R42,+'Intersection Tables'!U42)))/100))","v":0.89300000000000002},null,{"$error":"#NUM!"}]
[]
[]
["Worksheet 2E -- Summary Results for Rural Two-Lane Two-Way Road Intersections"]
["(1)",null,null,null,"(2)",null,null,null,"(3)"]
["Crash severity level",null,null,null,"Crash Severity Distribution (proportion)",null,null,null,"Predicted average crash frequency (crashes / year)"]
[null,null,null,null,"(4) from Worksheet 2C",null,null,null,"(8) from Worksheet 2C"]
["Total",null,null,null,{"$f":"+F33","v":1},null,null,null,{"$f":"+L33","v":{"$error":"#NUM!"}}]
["Fatal and Injury (FI)",null,null,null,{"$f":"+F34","v":0.34},null,null,null,{"$f":"+L34","v":{"$error":"#NUM!"}}]
["Property Damage Only (PDO)",null,null,null,{"$f":"+F35","v":0.66},null,null,null,{"$f":"+L35","v":{"$error":"#NUM!"}}]

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

{"sheet":"Rural 2-Lane Site Total","index":7,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,7,42,9],[37,1,38,3],[37,4,37,6],[37,7,37,9],[38,4,38,6],[38,7,38,9],[39,1,40,3],[39,4,39,6],[39,7,39,9],[40,4,40,6],[40,7,40,9],[41,1,42,3],[41,4,41,6],[41,7,41,9],[42,4,42,6],[33,1,34,9],[35,1,35,3],[35,4,35,6],[35,7,35,9],[36,1,36,3],[36,4,36,6],[36,7,36,9],[8,9,10,9],[15,1,15,2],[29,1,29,2],[18,1,18,2],[19,1,19,2],[20,1,20,9],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[17,1,17,2],[16,1,16,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[11,1,11,9],[12,1,12,2],[13,1,13,2],[14,1,14,2],[2,1,3,9],[4,1,4,2],[5,1,10,2],[5,3,7,5],[5,6,10,6],[5,7,10,7],[5,8,7,8],[5,9,7,9],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,8,10,8]]}
[]
[]
[null,"Worksheet 3A -- Predicted and Observed Crashes by Severity and Site Type Using the Site-Specific EB Method"]
[]
[null,"(1)",null,"(2)","(3)","(4)","(5)","(6)","(7)","(8)"]
[null,"Site type",null,"Predicted average crash frequency (crashes/year)",null,null,"Observed crashes,   Nobserved (crashes/year)","Overdispersion Parameter, k","Weighted adjustment, w","Expected average crash frequency, Nexpected"]
[]
[]
[null,null,null,"N predicted (TOTAL)"," N predicted      (FI)"," N predicted    (PDO)",null,null,"Equation A-5 from Part C Appendix","Equation   A-4 from Part C Appendix"]
[]
[]
[null,"ROADWAY SEGMENTS",null,null,null,null,null,null,null,null,null,"Ne / Np"]
[null,"Segment1",null,{"$f":"+Segment1!G83","v":{"$error":"#N/A"}},{"$f":"+Segment1!G84","v":{"$error":"#N/A"}},{"$f":"+Segment1!G85","v":{"$error":"#N/A"}},null,{"$f":"+Segment1!D49","v":{"$error":"#DIV/0!"}},{"$f":"1/(1+H13*D13)","v":{"$error":"#DIV/0!"}},{"$f":"+I13*+D13+((1-I13)*G13)","v":{"$error":"#DIV/0!"}},null,{"$f":"J13/D13","v":{"$error":"#DIV/0!"}}]
[null,"Segment2",null,{"$f":"+Segment2!G83","v":{"$error":"#N/A"}},{"$f":"+Segment2!G84","v":{"$error":"#N/A"}},{"$f":"+Segment2!G85","v":{"$error":"#N/A"}},null,{"$f":"+Segment2!D49","v":{"$error":"#DIV/0!"}},{"$f":"1/(1+H14*D14)","v":{"$error":"#DIV/0!"}},{"$f":"+I14*+D14+((1-I14)*G14)","v":{"$error":"#DIV/0!"}}]
[null,"Segment3",null,null,null,null,null,null,{"$f":"1/(1+H15*D15)","v":1},{"$f":"+I15*+D15+((1-I15)*G15)","v":0}]
[null,"Segment4",null,null,null,null,null,null,1,0]
[null,"Segment5",null,null,null,null,null,null,1,0]
[null,"Segment6",null,null,null,null,null,null,1,0]
[null,"Segment7",null,null,null,null,null,null,1,0]
[null,"Segment8",null,null,null,null,null,null,1,0]
[null,"INTERSECTIONS"]
[null,"Intersection1",null,{"$f":"+Intersection1!I68","v":{"$error":"#NUM!"}},{"$f":"+Intersection1!I69","v":{"$error":"#NUM!"}},{"$f":"+Intersection1!I70","v":{"$error":"#NUM!"}},null,{"$f":"+Intersection1!E33","v":0.11},{"$f":"1/(1+H22*D22)","v":{"$error":"#NUM!"}},{"$f":"+I22*+D22+((1-I22)*G22)","v":{"$error":"#NUM!"}}]
[null,"Intersection2",null,{"$f":"+Intersection2!I68","v":{"$error":"#NUM!"}},{"$f":"+Intersection2!I69","v":{"$error":"#NUM!"}},{"$f":"+Intersection2!I70","v":{"$error":"#NUM!"}},null,{"$f":"+Intersection2!E33","v":0.11},{"$f":"1/(1+H23*D23)","v":{"$error":"#NUM!"}},{"$f":"+I23*+D23+((1-I23)*G23)","v":{"$error":"#NUM!"}}]
[null,"Intersection3",null,null,null,null,null,null,{"$f":"1/(1+H24*D24)","v":1},{"$f":"+I24*+D24+((1-I24)*G24)","v":0}]
[null,"Intersection4",null,null,null,null,null,null,1,0]
[null,"Intersection5",null,null,null,null,null,null,1,0]
[null,"Intersection6",null,null,null,null,null,null,1,0]
[null,"Intersection7",null,null,null,null,null,null,1,0]
[null,"Intersection8",null,null,null,null,null,null,1,0]
[null,"COMBINED (sum of column)",null,{"$f":"SUM(D13:D20)+SUM(D22:D29)","v":{"$error":"#N/A"}},{"$f":"SUM(E13:E20)+SUM(E22:E29)","v":{"$error":"#N/A"}},{"$f":"SUM(F13:F20)+SUM(F22:F29)","v":{"$error":"#N/A"}},{"$f":"SUM(G13:G20)+SUM(G22:G29)","v":0},"--","--",{"$f":"SUM(J13:J20)+SUM(J22:J29)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Worksheet 3B -- Site-Specific EB Method Summary Results"]
[]
[null,"(1)",null,null,"(2)",null,null,"(3)"]
[null,"Crash severity level",null,null,"N predicted",null,null,"N expected"]
[null,"Total",null,null,"(2)COMB from Worksheet 3A",null,null,"(8)COMB from Worksheet 3A"]
[null,null,null,null,{"$f":"+D30","v":{"$error":"#N/A"}},null,null,{"$f":"+J30","v":{"$error":"#DIV/0!"}}]
[null,"Fatal and Injury (FI)",null,null,"(3)COMB from Worksheet 3A",null,null,"(3)TOTAL * (2)FI / (2) TOTAL"]
[null,null,null,null,{"$f":"+E30","v":{"$error":"#N/A"}},null,null,{"$f":"+J30*E30/D30","v":{"$error":"#DIV/0!"}}]
[null,"Property Damage Only (PDO)",null,null,"(4)COMB from Worksheet 3A",null,null,"(3)TOTAL * (2)PDO / (2) TOTAL"]
[null,null,null,null,{"$f":"+F30","v":{"$error":"#N/A"}},null,null,{"$f":"+J30*F30/D30","v":{"$error":"#DIV/0!"}}]

{"sheet":"Rural 2-Lane Project Total","index":8,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,1,42,3],[41,4,41,6],[41,7,41,9],[42,4,42,6],[42,7,42,9],[39,1,40,3],[39,4,39,6],[39,7,39,9],[40,4,40,6],[40,7,40,9],[36,1,36,3],[36,4,36,6],[36,7,36,9],[37,1,38,3],[37,4,37,6],[37,7,37,9],[38,4,38,6],[38,7,38,9],[35,1,35,3],[35,4,35,6],[35,7,35,9],[18,1,18,14],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[7,14,8,14],[9,1,9,14],[10,1,10,2],[33,1,34,9],[15,1,15,2],[16,1,16,2],[17,1,17,2],[13,1,13,2],[14,1,14,2],[11,1,11,2],[12,1,12,2],[5,12,6,12],[7,12,8,12],[7,13,8,13],[7,9,8,9],[7,10,8,10],[7,11,8,11],[2,1,3,14],[4,1,4,2],[5,1,8,2],[5,3,6,5],[5,6,8,6],[5,7,8,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,13,6,13],[5,14,6,14],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,8,8,8]]}
[]
[]
[null,"Worksheet 4A -- Predicted and Observed Crashes by Severity and Site Type Using the Project-Level EB Method"]
[]
[null,"(1)",null,"(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)","(10)","(11)","(12)","(13)"]
[null,"Site type",null,"Predicted average crash frequency (crashes/year)",null,null,"Observed crashes,   Nobserved (crashes/year)","Overdispersion Parameter, k","Nw0","Nw1","W0","N0","w1","N1","Np/comb"]
[]
[null,null,null,"N predicted (TOTAL)"," N predicted    (FI)"," N predicted    (PDO)",null,null,"Equation A-8  (6)*(2)2","Equation A-9  sqrt((6)*(2))","Equation   A-10","Equation   A-11","Equation   A-12","Equation   A-13","Equation   A-14"]
[]
[null,"ROADWAY SEGMENTS"]
[null,"Segment 1",null,{"$f":"+Segment1!$G$83","v":{"$error":"#N/A"}},{"$f":"+Segment1!$G$84","v":{"$error":"#N/A"}},{"$f":"+Segment1!$G$85","v":{"$error":"#N/A"}},"--",{"$f":"+Segment1!$D$49","v":{"$error":"#DIV/0!"}},{"$f":"+H11*D11*D11","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(H11*D11)","v":{"$error":"#DIV/0!"}},"--","--","--","--","--"]
[null,"Segment 2",null,{"$f":"+Segment2!$G$83","v":{"$error":"#N/A"}},{"$f":"+Segment2!$G$84","v":{"$error":"#N/A"}},{"$f":"+Segment2!$G$85","v":{"$error":"#N/A"}},"--",{"$f":"+Segment2!$D$49","v":{"$error":"#DIV/0!"}},{"$f":"+H12*D12*D12","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(H12*D12)","v":{"$error":"#DIV/0!"}},"--","--","--","--","--"]
[null,"Segment 3",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Segment 4",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Segment 5",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Segment 6",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Segment 7",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Segment 8",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"INTERSECTIONS"]
[null,"Intersection 1",null,{"$f":"+Intersection1!$I$68","v":{"$error":"#NUM!"}},{"$f":"+Intersection1!$I$69","v":{"$error":"#NUM!"}},{"$f":"+Intersection1!$I$70","v":{"$error":"#NUM!"}},"--",{"$f":"+Intersection1!$E$33","v":0.11},{"$f":"H20*D20*D20","v":{"$error":"#NUM!"}},{"$f":"SQRT(H20*D20)","v":{"$error":"#NUM!"}},"--","--","--","--","--"]
[null,"Intersection 2",null,{"$f":"+Intersection2!$I$68","v":{"$error":"#NUM!"}},{"$f":"+Intersection2!$I$69","v":{"$error":"#NUM!"}},{"$f":"+Intersection2!$I$70","v":{"$error":"#NUM!"}},"--",{"$f":"+Intersection2!$E$33","v":0.11},{"$f":"H21*D21*D21","v":{"$error":"#NUM!"}},{"$f":"SQRT(H21*D21)","v":{"$error":"#NUM!"}},"--","--","--","--","--"]
[null,"Intersection 3",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Intersection 4",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Intersection 5",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Intersection 6",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Intersection 7",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"Intersection 8",null,null,null,null,"--",null,null,null,"--","--","--","--","--"]
[null,"COMBINED",null,{"$f":"SUM(D11:D18)+SUM(D20:D27)","v":{"$error":"#N/A"}},{"$f":"SUM(E11:E18)+SUM(E20:E27)","v":{"$error":"#N/A"}},{"$f":"SUM(F11:F18)+SUM(F20:F27)","v":{"$error":"#N/A"}},null,"--",{"$f":"SUM(I11:I18)+SUM(I20:I27)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J11:J18)+SUM(J20:J27)","v":{"$error":"#DIV/0!"}},{"$f":"1/(1+I28/D28)","v":{"$error":"#DIV/0!"}},{"$f":"K28*D28+((1-K28)*G28)","v":{"$error":"#DIV/0!"}},{"$f":"1/(1+(J28/D28))","v":{"$error":"#DIV/0!"}},{"$f":"+M28*D28+(1-M28)*G28","v":{"$error":"#DIV/0!"}},{"$f":"(L28+N28)/2","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[null,"Worksheet 4B -- Project-Level EB Method Summary Results"]
[]
[null,"(1)",null,null,"(2)",null,null,"(3)"]
[null,"Crash severity level",null,null,"N predicted",null,null,"N expected"]
[null,"Total",null,null,"(2)COMB from Worksheet 4A",null,null,"(13)COMB from Worksheet 4A"]
[null,null,null,null,{"$f":"+D28","v":{"$error":"#N/A"}},null,null,{"$f":"+O28","v":{"$error":"#DIV/0!"}}]
[null,"Fatal and injury (FI)",null,null,"(3)COMB from Worksheet 4A",null,null,"(3)TOTAL * (2)FI / (2) TOTAL"]
[null,null,null,null,{"$f":"+E28","v":{"$error":"#N/A"}},null,null,{"$f":"+O28*E28/D28","v":{"$error":"#DIV/0!"}}]
[null,"Property damage only (PDO)",null,null,"(4)COMB from Worksheet 4A",null,null,"(3)TOTAL * (2)PDO / (2) TOTAL"]
[null,null,null,null,{"$f":"+F28","v":{"$error":"#N/A"}},null,null,{"$f":"+O28*F28/D28","v":{"$error":"#DIV/0!"}}]

{"sheet":"Construction - Do Not Delete","index":9,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Lane Width",null,"Shoulder Width",null,"RHR"]
[null,9,null,0,null,1]
[null,9.5,null,1,null,2]
[null,10,null,2,null,3]
[null,10.5,null,3,null,4]
[null,11,null,4,null,5]
[null,11.5,null,5,null,6]
[null,12,null,6,null,7]
[null,null,null,7]
[null,null,null,8]
[]
[]
[null,null,null,null,null,null,null,"Centerline",null,"Passing",null,"Local"]
[null,null,null,"Shoulder Type",null,"Spiral",null,"Rumble Strips",null,"Lane",null,"Yes"]
[null,null,null,"Paved",null,"Not Present",null,"Not Present",null,"Not Present",null,"No"]
[null,null,null,"Gravel",null,"Present",null,"Present",null,"Present (1 lane)"]
[null,null,null,"Composite",null,"One End Only",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]

{"sheet":"Segment1 Crash Cost","index":10,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,16],[5,1,5,9],[5,10,5,16],[6,2,6,3],[6,5,6,7],[6,11,6,13],[6,15,6,16],[7,1,7,2],[7,3,7,7],[7,11,7,13],[7,15,7,16],[8,1,8,16],[9,10,9,16],[11,5,11,6],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,14,9],[14,10,14,16],[12,5,12,6]]}
[]
[null,"State of Florida Department of Transportation"]
[null,"Present Worth Analysis"]
[null,"Rural Two Lane Road"]
[null,{"$f":"IF(A_Type=\"P\",\"Build Alternative\",\"No-Build Alternative\")","v":"No-Build Alternative"}]
[null,"General Information",null,null,null,null,null,null,null,null,"Site Information"]
[null,"Analyst:",null,null,"Date:",null,null,null,null,null,"Location ID:",null,null,null,"County:"]
[null,"Agency or Company:",null,null,null,null,null,null,null,null,"City:",null,null,null,"M.P. - M.P. "]
[null,"Manual Input from Analysis"]
[null,null,"Growth Rate =",null,"Current Year =",{"$f":"INDIRECT(\"'\" & SegName & \"'!J7\")","v":0},null,"Project Opening Year =",null,null,"Default Distribution for Crash Severity Level (2010-2014 Florida HSM Crash Distribution)"]
[null,null,"Current Year AADT =",{"$f":"INDIRECT(\"'\" & SegName & \"'!AADT\")","v":0},"Rate of Return =",null,null,"Analysis Period =",null,null,null,"Fatality =",3.2000000000000001E-2,null,null,"Possible Injury = ",0.19500000000000001]
[null,null,"Segment Length =",{"$f":"INDIRECT(\"'\" & SegName & \"'!Segment_Length\")","v":0},"Segment =","Segment1",null,"E",null,null,null,"Incapacitating =",0.11600000000000001,null,null,"Property Damage Only =",0.46100000000000002]
[null,null,null,null,"Crash Data Used =","Yes",null,1.1817587284771038,null,null,null,"Non-Incapacitating =",0.19600000000000001,null,null,null,{"$f":"SUM(M11:M13,Q11:Q12)","v":1}]
[]
[null,null,"Year",null,"Annual Number of Crashes",null,null,null,null,null,"Annual Cost"]
[null,null,null,null,"Site Specific (Npredicted / expected)","Fatality","Incap.","Non-Inc.","Possible Injury","PDO","Fatality","Incap.","Non-Inc.","Possible Injury","PDO ","Total Cost","Present Value"]
[null,null,{"$f":"F10","v":0},{"$f":"D11","v":0},null,{"$f":"E17*$M$11","v":0},{"$f":"E17*$M$12","v":0},{"$f":"E17*$M$13","v":0},{"$f":"E17*$Q$11","v":0},{"$f":"E17*$Q$12","v":0},{"$f":"F17*Data!$B$2","v":0},{"$f":"G17*Data!$B$3","v":0},{"$f":"H17*Data!$B$4","v":0},{"$f":"I17*Data!$B$5","v":0},{"$f":"J17*Data!$B$6","v":0},{"$f":"SUM(K17:O17)","v":0},{"$f":"(P17)/((1+$F$11)^(B17))","v":0}]
[null,null,{"$f":"C17+1","v":1},{"$f":"D17*(1+$D$10)","v":0},null,0,0,0,0,0,{"$f":"F18*Data!$B$2","v":0},{"$f":"G18*Data!$B$3","v":0},{"$f":"H18*Data!$B$4","v":0},{"$f":"I18*Data!$B$5","v":0},{"$f":"J18*Data!$B$6","v":0},{"$f":"SUM(K18:O18)","v":0},0]
[null,null,{"$f":"C18+1","v":2},0,null,0,0,0,0,0,{"$f":"F19*Data!$B$2","v":0},{"$f":"G19*Data!$B$3","v":0},{"$f":"H19*Data!$B$4","v":0},{"$f":"I19*Data!$B$5","v":0},{"$f":"J19*Data!$B$6","v":0},0,0]
[null,null,3,0,null,0,0,0,0,0,{"$f":"F20*Data!$B$2","v":0},{"$f":"G20*Data!$B$3","v":0},{"$f":"H20*Data!$B$4","v":0},{"$f":"I20*Data!$B$5","v":0},{"$f":"J20*Data!$B$6","v":0},0,0]
[null,null,4,0,null,0,0,0,0,0,{"$f":"F21*Data!$B$2","v":0},{"$f":"G21*Data!$B$3","v":0},{"$f":"H21*Data!$B$4","v":0},{"$f":"I21*Data!$B$5","v":0},{"$f":"J21*Data!$B$6","v":0},0,0]
[null,null,5,0,null,0,0,0,0,0,{"$f":"F22*Data!$B$2","v":0},{"$f":"G22*Data!$B$3","v":0},{"$f":"H22*Data!$B$4","v":0},{"$f":"I22*Data!$B$5","v":0},{"$f":"J22*Data!$B$6","v":0},0,0]
[null,null,6,0,null,0,0,0,0,0,{"$f":"F23*Data!$B$2","v":0},{"$f":"G23*Data!$B$3","v":0},{"$f":"H23*Data!$B$4","v":0},{"$f":"I23*Data!$B$5","v":0},{"$f":"J23*Data!$B$6","v":0},0,0]
[null,null,7,0,null,0,0,0,0,0,{"$f":"F24*Data!$B$2","v":0},{"$f":"G24*Data!$B$3","v":0},{"$f":"H24*Data!$B$4","v":0},{"$f":"I24*Data!$B$5","v":0},{"$f":"J24*Data!$B$6","v":0},0,0]
[null,null,8,0,null,0,0,0,0,0,{"$f":"F25*Data!$B$2","v":0},{"$f":"G25*Data!$B$3","v":0},{"$f":"H25*Data!$B$4","v":0},{"$f":"I25*Data!$B$5","v":0},{"$f":"J25*Data!$B$6","v":0},0,0]
[null,null,9,0,null,0,0,0,0,0,{"$f":"F26*Data!$B$2","v":0},{"$f":"G26*Data!$B$3","v":0},{"$f":"H26*Data!$B$4","v":0},{"$f":"I26*Data!$B$5","v":0},{"$f":"J26*Data!$B$6","v":0},0,0]
[null,null,10,0,null,{"$f":"E27*$M$11","v":0},{"$f":"E27*$M$12","v":0},{"$f":"E27*$M$13","v":0},{"$f":"E27*$Q$11","v":0},{"$f":"E27*$Q$12","v":0},{"$f":"F27*Data!$B$2","v":0},{"$f":"G27*Data!$B$3","v":0},{"$f":"H27*Data!$B$4","v":0},{"$f":"I27*Data!$B$5","v":0},{"$f":"J27*Data!$B$6","v":0},0,0]
[null,null,11,0,null,{"$f":"E28*$M$11","v":0},{"$f":"E28*$M$12","v":0},{"$f":"E28*$M$13","v":0},{"$f":"E28*$Q$11","v":0},{"$f":"E28*$Q$12","v":0},{"$f":"F28*Data!$B$2","v":0},{"$f":"G28*Data!$B$3","v":0},{"$f":"H28*Data!$B$4","v":0},{"$f":"I28*Data!$B$5","v":0},{"$f":"J28*Data!$B$6","v":0},{"$f":"SUM(K28:O28)","v":0},{"$f":"(P28)/((1+$F$11)^(B28))","v":0}]
[null,null,12,0,null,0,0,0,0,0,{"$f":"F29*Data!$B$2","v":0},{"$f":"G29*Data!$B$3","v":0},{"$f":"H29*Data!$B$4","v":0},{"$f":"I29*Data!$B$5","v":0},{"$f":"J29*Data!$B$6","v":0},0,0]
[null,null,13,0,null,0,0,0,0,0,{"$f":"F30*Data!$B$2","v":0},{"$f":"G30*Data!$B$3","v":0},{"$f":"H30*Data!$B$4","v":0},{"$f":"I30*Data!$B$5","v":0},{"$f":"J30*Data!$B$6","v":0},0,0]
[null,null,14,0,null,0,0,0,0,0,{"$f":"F31*Data!$B$2","v":0},{"$f":"G31*Data!$B$3","v":0},{"$f":"H31*Data!$B$4","v":0},{"$f":"I31*Data!$B$5","v":0},{"$f":"J31*Data!$B$6","v":0},0,0]
[null,null,15,0,null,0,0,0,0,0,{"$f":"F32*Data!$B$2","v":0},{"$f":"G32*Data!$B$3","v":0},{"$f":"H32*Data!$B$4","v":0},{"$f":"I32*Data!$B$5","v":0},{"$f":"J32*Data!$B$6","v":0},0,0]
[null,null,16,0,null,0,0,0,0,0,{"$f":"F33*Data!$B$2","v":0},{"$f":"G33*Data!$B$3","v":0},{"$f":"H33*Data!$B$4","v":0},{"$f":"I33*Data!$B$5","v":0},{"$f":"J33*Data!$B$6","v":0},0,0]
[null,null,17,0,null,0,0,0,0,0,{"$f":"F34*Data!$B$2","v":0},{"$f":"G34*Data!$B$3","v":0},{"$f":"H34*Data!$B$4","v":0},{"$f":"I34*Data!$B$5","v":0},{"$f":"J34*Data!$B$6","v":0},0,0]
[null,null,18,0,null,0,0,0,0,0,{"$f":"F35*Data!$B$2","v":0},{"$f":"G35*Data!$B$3","v":0},{"$f":"H35*Data!$B$4","v":0},{"$f":"I35*Data!$B$5","v":0},{"$f":"J35*Data!$B$6","v":0},0,0]
[null,null,19,0,null,0,0,0,0,0,{"$f":"F36*Data!$B$2","v":0},{"$f":"G36*Data!$B$3","v":0},{"$f":"H36*Data!$B$4","v":0},{"$f":"I36*Data!$B$5","v":0},{"$f":"J36*Data!$B$6","v":0},0,0]
[null,null,20,0,null,0,0,0,0,0,{"$f":"F37*Data!$B$2","v":0},{"$f":"G37*Data!$B$3","v":0},{"$f":"H37*Data!$B$4","v":0},{"$f":"I37*Data!$B$5","v":0},{"$f":"J37*Data!$B$6","v":0},0,0]
[null,null,21,0,null,0,0,0,0,0,{"$f":"F38*Data!$B$2","v":0},{"$f":"G38*Data!$B$3","v":0},{"$f":"H38*Data!$B$4","v":0},{"$f":"I38*Data!$B$5","v":0},{"$f":"J38*Data!$B$6","v":0},0,0]
[null,null,22,0,null,0,0,0,0,0,{"$f":"F39*Data!$B$2","v":0},{"$f":"G39*Data!$B$3","v":0},{"$f":"H39*Data!$B$4","v":0},{"$f":"I39*Data!$B$5","v":0},{"$f":"J39*Data!$B$6","v":0},0,0]
[null,null,23,0,null,0,0,0,0,0,{"$f":"F40*Data!$B$2","v":0},{"$f":"G40*Data!$B$3","v":0},{"$f":"H40*Data!$B$4","v":0},{"$f":"I40*Data!$B$5","v":0},{"$f":"J40*Data!$B$6","v":0},0,0]
[null,null,24,0,null,0,0,0,0,0,{"$f":"F41*Data!$B$2","v":0},{"$f":"G41*Data!$B$3","v":0},{"$f":"H41*Data!$B$4","v":0},{"$f":"I41*Data!$B$5","v":0},{"$f":"J41*Data!$B$6","v":0},0,0]
[null,null,25,0,null,0,0,0,0,0,{"$f":"F42*Data!$B$2","v":0},{"$f":"G42*Data!$B$3","v":0},{"$f":"H42*Data!$B$4","v":0},{"$f":"I42*Data!$B$5","v":0},{"$f":"J42*Data!$B$6","v":0},0,0]
[null,null,26,0,null,0,0,0,0,0,{"$f":"F43*Data!$B$2","v":0},{"$f":"G43*Data!$B$3","v":0},{"$f":"H43*Data!$B$4","v":0},{"$f":"I43*Data!$B$5","v":0},{"$f":"J43*Data!$B$6","v":0},0,0]
[null,null,"Shaded cell indicates the AADT is outside the limits",null,null,null,null,null,null,null,null,null,null,null,null,"Total Present Value",{"$f":"SUM(Q17:Q43)","v":0}]
[]
[]
[null,null,"NOTES:"]
[null,null,"1. Present Value = Future Cash Flow / (1 + Required Rate of Return)Number of Years You Have To Wait For The Cash Flow"]
[null,null,"2. Traffic Growth Rate = [((ADTf / ADTi)(1/(F-I))-1] x 100"]
[null,null,"            where ADTf = Average Daily Traffic for Future Year"]
[null,null,"                         ADTi = Average Daily Traffic for Initial Year"]
[null,null,"                         I = Initial Year for ADT"]
[null,null,"                         F = Future Year for ADT"]

{"sheet":"Segment2 Crash Cost","index":11,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,16],[5,1,5,9],[5,10,5,16],[6,2,6,3],[6,5,6,7],[6,11,6,13],[6,15,6,16],[7,1,7,2],[7,3,7,7],[7,11,7,13],[7,15,7,16],[8,1,8,16],[9,10,9,16],[11,5,11,6],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,14,9],[14,10,14,16],[12,5,12,6]]}
[]
[null,"State of Florida Department of Transportation"]
[null,"Present Worth Analysis"]
[null,"Rural Two Lane Road"]
[null,{"$f":"IF(A_Type=\"P\",\"Build Alternative\",\"No-Build Alternative\")","v":"Build Alternative"}]
[null,"General Information",null,null,null,null,null,null,null,null,"Site Information"]
[null,"Analyst:",null,null,"Date:",null,null,null,null,null,"Location ID:",null,null,null,"County:"]
[null,"Agency or Company:",null,null,null,null,null,null,null,null,"City:",null,null,null,"M.P. - M.P. "]
[null,"Manual Input from Analysis"]
[null,null,"Growth Rate =",null,"Current Year =",{"$f":"INDIRECT(\"'\" & SegName & \"'!J7\")","v":0},null,"Project Opening Year =",null,null,"Default Distribution for Crash Severity Level (2010-2014 Florida HSM Crash Distribution)"]
[null,null,"Current Year AADT =",{"$f":"INDIRECT(\"'\" & SegName & \"'!AADT\")","v":0},"Rate of Return =",null,null,"Analysis Period =",null,null,null,"Fatality =",3.2000000000000001E-2,null,null,"Possible Injury = ",0.19500000000000001]
[null,null,"Segment Length =",{"$f":"INDIRECT(\"'\" & SegName & \"'!Segment_Length\")","v":0},"Segment =","Segment2",null,"P",null,null,null,"Incapacitating =",0.11600000000000001,null,null,"Property Damage Only =",0.46100000000000002]
[null,null,null,null,"Crash Data Used =","Yes",null,0.125,null,null,null,"Non-Incapacitating =",0.19600000000000001,null,null,null,{"$f":"SUM(M11:M13,Q11:Q12)","v":1}]
[]
[null,null,"Year","AADT","Annual Number of Crashes",null,null,null,null,null,"Annual Cost"]
[null,null,null,null,"Site Specific (Npredicted / expected)","Fatality","Incap.","Non-Inc.","Possible Injury","PDO","Fatality","Incap.","Non-Inc.","Possible Injury","PDO ","Total Cost","Present Value"]
[null,null,{"$f":"F10","v":0},{"$f":"D11","v":0},null,{"$f":"E17*$M$11","v":0},{"$f":"E17*$M$12","v":0},{"$f":"E17*$M$13","v":0},{"$f":"E17*$Q$11","v":0},{"$f":"E17*$Q$12","v":0},{"$f":"F17*Data!$B$2","v":0},{"$f":"G17*Data!$B$3","v":0},{"$f":"H17*Data!$B$4","v":0},{"$f":"I17*Data!$B$5","v":0},{"$f":"J17*Data!$B$6","v":0},{"$f":"SUM(K17:O17)","v":0},{"$f":"(P17)/((1+$F$11)^(B17))","v":0}]
[null,null,{"$f":"C17+1","v":1},{"$f":"D17*(1+$D$10)","v":0},null,0,0,0,0,0,{"$f":"F18*Data!$B$2","v":0},{"$f":"G18*Data!$B$3","v":0},{"$f":"H18*Data!$B$4","v":0},{"$f":"I18*Data!$B$5","v":0},{"$f":"J18*Data!$B$6","v":0},{"$f":"SUM(K18:O18)","v":0},0]
[null,null,{"$f":"C18+1","v":2},0,null,0,0,0,0,0,{"$f":"F19*Data!$B$2","v":0},{"$f":"G19*Data!$B$3","v":0},{"$f":"H19*Data!$B$4","v":0},{"$f":"I19*Data!$B$5","v":0},{"$f":"J19*Data!$B$6","v":0},0,0]
[null,null,3,0,null,0,0,0,0,0,{"$f":"F20*Data!$B$2","v":0},{"$f":"G20*Data!$B$3","v":0},{"$f":"H20*Data!$B$4","v":0},{"$f":"I20*Data!$B$5","v":0},{"$f":"J20*Data!$B$6","v":0},0,0]
[null,null,4,0,null,0,0,0,0,0,{"$f":"F21*Data!$B$2","v":0},{"$f":"G21*Data!$B$3","v":0},{"$f":"H21*Data!$B$4","v":0},{"$f":"I21*Data!$B$5","v":0},{"$f":"J21*Data!$B$6","v":0},0,0]
[null,null,5,0,null,0,0,0,0,0,{"$f":"F22*Data!$B$2","v":0},{"$f":"G22*Data!$B$3","v":0},{"$f":"H22*Data!$B$4","v":0},{"$f":"I22*Data!$B$5","v":0},{"$f":"J22*Data!$B$6","v":0},0,0]
[null,null,6,0,null,0,0,0,0,0,{"$f":"F23*Data!$B$2","v":0},{"$f":"G23*Data!$B$3","v":0},{"$f":"H23*Data!$B$4","v":0},{"$f":"I23*Data!$B$5","v":0},{"$f":"J23*Data!$B$6","v":0},0,0]
[null,null,7,0,null,0,0,0,0,0,{"$f":"F24*Data!$B$2","v":0},{"$f":"G24*Data!$B$3","v":0},{"$f":"H24*Data!$B$4","v":0},{"$f":"I24*Data!$B$5","v":0},{"$f":"J24*Data!$B$6","v":0},0,0]
[null,null,8,0,null,0,0,0,0,0,{"$f":"F25*Data!$B$2","v":0},{"$f":"G25*Data!$B$3","v":0},{"$f":"H25*Data!$B$4","v":0},{"$f":"I25*Data!$B$5","v":0},{"$f":"J25*Data!$B$6","v":0},0,0]
[null,null,9,0,null,0,0,0,0,0,{"$f":"F26*Data!$B$2","v":0},{"$f":"G26*Data!$B$3","v":0},{"$f":"H26*Data!$B$4","v":0},{"$f":"I26*Data!$B$5","v":0},{"$f":"J26*Data!$B$6","v":0},0,0]
[null,null,10,0,null,0,{"$f":"E27*$M$12","v":0},0,0,0,{"$f":"F27*Data!$B$2","v":0},{"$f":"G27*Data!$B$3","v":0},{"$f":"H27*Data!$B$4","v":0},{"$f":"I27*Data!$B$5","v":0},{"$f":"J27*Data!$B$6","v":0},0,0]
[null,null,11,0,null,0,{"$f":"E28*$M$12","v":0},0,0,0,{"$f":"F28*Data!$B$2","v":0},{"$f":"G28*Data!$B$3","v":0},{"$f":"H28*Data!$B$4","v":0},{"$f":"I28*Data!$B$5","v":0},{"$f":"J28*Data!$B$6","v":0},0,0]
[null,null,12,0,null,0,0,0,0,0,{"$f":"F29*Data!$B$2","v":0},{"$f":"G29*Data!$B$3","v":0},{"$f":"H29*Data!$B$4","v":0},{"$f":"I29*Data!$B$5","v":0},{"$f":"J29*Data!$B$6","v":0},0,0]
[null,null,13,0,null,0,0,0,0,0,{"$f":"F30*Data!$B$2","v":0},{"$f":"G30*Data!$B$3","v":0},{"$f":"H30*Data!$B$4","v":0},{"$f":"I30*Data!$B$5","v":0},{"$f":"J30*Data!$B$6","v":0},0,0]
[null,null,14,0,null,0,0,0,0,0,{"$f":"F31*Data!$B$2","v":0},{"$f":"G31*Data!$B$3","v":0},{"$f":"H31*Data!$B$4","v":0},{"$f":"I31*Data!$B$5","v":0},{"$f":"J31*Data!$B$6","v":0},0,0]
[null,null,15,0,null,0,0,0,0,0,{"$f":"F32*Data!$B$2","v":0},{"$f":"G32*Data!$B$3","v":0},{"$f":"H32*Data!$B$4","v":0},{"$f":"I32*Data!$B$5","v":0},{"$f":"J32*Data!$B$6","v":0},0,0]
[null,null,16,0,null,0,0,0,0,0,{"$f":"F33*Data!$B$2","v":0},{"$f":"G33*Data!$B$3","v":0},{"$f":"H33*Data!$B$4","v":0},{"$f":"I33*Data!$B$5","v":0},{"$f":"J33*Data!$B$6","v":0},0,0]
[null,null,17,0,null,0,0,0,0,0,{"$f":"F34*Data!$B$2","v":0},{"$f":"G34*Data!$B$3","v":0},{"$f":"H34*Data!$B$4","v":0},{"$f":"I34*Data!$B$5","v":0},{"$f":"J34*Data!$B$6","v":0},0,0]
[null,null,18,0,null,0,0,0,0,0,{"$f":"F35*Data!$B$2","v":0},{"$f":"G35*Data!$B$3","v":0},{"$f":"H35*Data!$B$4","v":0},{"$f":"I35*Data!$B$5","v":0},{"$f":"J35*Data!$B$6","v":0},0,0]
[null,null,19,0,null,0,0,0,0,0,{"$f":"F36*Data!$B$2","v":0},{"$f":"G36*Data!$B$3","v":0},{"$f":"H36*Data!$B$4","v":0},{"$f":"I36*Data!$B$5","v":0},{"$f":"J36*Data!$B$6","v":0},0,0]
[null,null,20,0,null,0,0,0,0,0,{"$f":"F37*Data!$B$2","v":0},{"$f":"G37*Data!$B$3","v":0},{"$f":"H37*Data!$B$4","v":0},{"$f":"I37*Data!$B$5","v":0},{"$f":"J37*Data!$B$6","v":0},0,0]
[null,null,21,0,null,0,0,0,0,0,{"$f":"F38*Data!$B$2","v":0},{"$f":"G38*Data!$B$3","v":0},{"$f":"H38*Data!$B$4","v":0},{"$f":"I38*Data!$B$5","v":0},{"$f":"J38*Data!$B$6","v":0},0,0]
[null,null,22,0,null,0,0,0,0,0,{"$f":"F39*Data!$B$2","v":0},{"$f":"G39*Data!$B$3","v":0},{"$f":"H39*Data!$B$4","v":0},{"$f":"I39*Data!$B$5","v":0},{"$f":"J39*Data!$B$6","v":0},0,0]
[null,null,23,0,null,0,0,0,0,0,{"$f":"F40*Data!$B$2","v":0},{"$f":"G40*Data!$B$3","v":0},{"$f":"H40*Data!$B$4","v":0},{"$f":"I40*Data!$B$5","v":0},{"$f":"J40*Data!$B$6","v":0},0,0]
[null,null,24,0,null,0,0,0,0,0,{"$f":"F41*Data!$B$2","v":0},{"$f":"G41*Data!$B$3","v":0},{"$f":"H41*Data!$B$4","v":0},{"$f":"I41*Data!$B$5","v":0},{"$f":"J41*Data!$B$6","v":0},0,0]
[null,null,25,0,null,0,0,0,0,0,{"$f":"F42*Data!$B$2","v":0},{"$f":"G42*Data!$B$3","v":0},{"$f":"H42*Data!$B$4","v":0},{"$f":"I42*Data!$B$5","v":0},{"$f":"J42*Data!$B$6","v":0},0,0]
[null,null,26,0,null,0,0,0,0,0,{"$f":"F43*Data!$B$2","v":0},{"$f":"G43*Data!$B$3","v":0},{"$f":"H43*Data!$B$4","v":0},{"$f":"I43*Data!$B$5","v":0},{"$f":"J43*Data!$B$6","v":0},0,0]
[null,null,"Shaded cell indicates the AADT is outside the limits",null,null,null,null,null,null,null,null,null,null,null,null,"Total Present Value",{"$f":"SUM(Q17:Q43)","v":0}]
[]
[]
[null,null,"NOTES:"]
[null,null,"1. Present Value = Future Cash Flow / (1 + Required Rate of Return)Number of Years You Have To Wait For The Cash Flow"]
[null,null,"2. Traffic Growth Rate = [((ADTf / ADTi)(1/(F-I))-1] x 100"]
[null,null,"            where ADTf = Average Daily Traffic for Future Year"]
[null,null,"                         ADTi = Average Daily Traffic for Initial Year"]
[null,null,"                         I = Initial Year for ADT"]
[null,null,"                         F = Future Year for ADT"]

{"sheet":"Segment Summary Costs","index":12,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,3,1],[2,2,2,4],[2,5,2,7],[2,8,3,8]]}
[]
[null,"SUMMARY OF TOTAL PRESENT VALUE FOR SEGMENTS"]
[null,"Segment Site","Beginning Year",null,null,"End Year",null,null,"Total Present Value"]
[null,null,"Year","AADT","Npredicted-rs","Year","AADT","Npredicted-rs"]
[null,"Segment1",{"$f":"'Segment1 Crash Cost'!C19","v":2},{"$f":"'Segment1 Crash Cost'!D19","v":0},{"$f":"'Segment1 Crash Cost'!E19","v":0},{"$f":"'Segment1 Crash Cost'!C28","v":11},{"$f":"'Segment1 Crash Cost'!D28","v":0},{"$f":"'Segment1 Crash Cost'!E28","v":0},{"$f":"'Segment1 Crash Cost'!$Q$44","v":0}]
[null,"Segment2",{"$f":"'Segment2 Crash Cost'!C18","v":1},{"$f":"'Segment2 Crash Cost'!D18","v":0},{"$f":"'Segment2 Crash Cost'!E18","v":0},{"$f":"'Segment2 Crash Cost'!C25","v":8},{"$f":"'Segment2 Crash Cost'!D25","v":0},{"$f":"'Segment2 Crash Cost'!E25","v":0},{"$f":"'Segment2 Crash Cost'!$Q$44","v":0}]
[]
[]
[null,"COMBINED",null,null,null,null,null,null,{"$f":"SUM(I5:I8)","v":0}]

{"sheet":"Intersection1 Crash Cost","index":13,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,17],[4,1,4,17],[5,1,5,10],[5,11,5,17],[6,2,6,4],[6,6,6,8],[6,12,6,14],[6,16,6,17],[7,1,7,2],[7,3,7,8],[7,12,7,14],[7,16,7,17],[8,1,8,17],[9,3,9,4],[9,11,9,17],[10,3,10,4],[11,3,11,4],[11,6,11,7],[14,11,14,17],[12,3,12,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,14,10],[12,6,12,7]]}
[]
[null,"State of Florida Department of Transportation"]
[null,"Present Worth Analysis"]
[null,"Rural Two Lane Road"]
[null,{"$f":"IF(A_Type=\"P\",\"Build Alternative\",\"No-Build Alternative\")","v":"Build Alternative"}]
[null,"General Information",null,null,null,null,null,null,null,null,null,"Site Information"]
[null,"Analyst:",null,null,null,"Date:",null,null,null,null,null,"Location ID:",null,null,null,"County:"]
[null,"Agency or Company:",null,null,null,null,null,null,null,null,null,"City:",null,null,null,"M.P. - M.P. "]
[null,"Manual Input from Analysis"]
[null,null,"Major Growth Rate =",null,null,"Current Year =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!J7\")","v":0},null,"Project Opening Year =",null,null,"Default Distribution for Crash Severity Level (2010-2014 Florida HSM Crash Distribution)"]
[null,null,"Minor Growth Rate =",null,null,"Rate of Return =",null,null,"Analysis Period =",null,null,null,"Fatality =",3.2000000000000001E-2,null,null,"Possible Injury = ",0.19500000000000001]
[null,null,"Current Year Major AADT =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!majAADT\")","v":0},null,"Intersection =","Intersection1",null,"P",null,null,null,"Incapacitating =",0.11600000000000001,null,null,"Property Damage Only =",0.46100000000000002]
[null,null,"Current Year Minor AADT =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!minAADT\")","v":0},null,"Crash Data Used =","No",null,10,null,null,null,"Non-Incapacitating =",0.19600000000000001,null,null,null,{"$f":"SUM(N11:N13,R11:R12)","v":1}]
[]
[null,null,"Year","Major AADT","Minor AADT","Annual Number of Crashes",null,null,null,null,null,"Annual Cost"]
[null,null,null,null,null,"Site Specific (Npredicted / expected)","Fatality","Incap.","Non-Inc.","Possible Injury","PDO","Fatality","Incap.","Non-Inc.","Possible Injury","PDO ","Total Cost","Present Value"]
[null,null,{"$f":"G10","v":0},{"$f":"D12","v":0},{"$f":"D13","v":0},null,{"$f":"F17*$N$11","v":0},{"$f":"F17*$N$12","v":0},{"$f":"F17*$N$13","v":0},{"$f":"F17*$R$11","v":0},{"$f":"F17*$R$12","v":0},{"$f":"G17*Data!$B$2","v":0},{"$f":"H17*Data!$B$3","v":0},{"$f":"I17*Data!$B$4","v":0},{"$f":"J17*Data!$B$5","v":0},{"$f":"K17*Data!$B$6","v":0},{"$f":"SUM(L17:P17)","v":0},{"$f":"(Q17)/((1+$G$11)^(B17))","v":0}]
[null,null,{"$f":"C17+1","v":1},{"$f":"D17*(1+$D$10)","v":0},{"$f":"E17*(1+$D$11)","v":0},null,0,0,0,0,0,{"$f":"G18*Data!$B$2","v":0},{"$f":"H18*Data!$B$3","v":0},{"$f":"I18*Data!$B$4","v":0},{"$f":"J18*Data!$B$5","v":0},{"$f":"K18*Data!$B$6","v":0},{"$f":"SUM(L18:P18)","v":0},0]
[null,null,{"$f":"C18+1","v":2},{"$f":"D18*(1+$D$10)","v":0},{"$f":"E18*(1+$D$11)","v":0},null,0,0,0,0,0,{"$f":"G19*Data!$B$2","v":0},{"$f":"H19*Data!$B$3","v":0},{"$f":"I19*Data!$B$4","v":0},{"$f":"J19*Data!$B$5","v":0},{"$f":"K19*Data!$B$6","v":0},0,0]
[null,null,3,0,0,null,0,0,0,0,0,{"$f":"G20*Data!$B$2","v":0},{"$f":"H20*Data!$B$3","v":0},{"$f":"I20*Data!$B$4","v":0},{"$f":"J20*Data!$B$5","v":0},{"$f":"K20*Data!$B$6","v":0},0,0]
[null,null,4,0,0,null,0,0,0,0,0,{"$f":"G21*Data!$B$2","v":0},{"$f":"H21*Data!$B$3","v":0},{"$f":"I21*Data!$B$4","v":0},{"$f":"J21*Data!$B$5","v":0},{"$f":"K21*Data!$B$6","v":0},0,0]
[null,null,5,0,0,null,0,0,0,0,0,{"$f":"G22*Data!$B$2","v":0},{"$f":"H22*Data!$B$3","v":0},{"$f":"I22*Data!$B$4","v":0},{"$f":"J22*Data!$B$5","v":0},{"$f":"K22*Data!$B$6","v":0},0,0]
[null,null,6,0,0,null,0,0,0,0,0,{"$f":"G23*Data!$B$2","v":0},{"$f":"H23*Data!$B$3","v":0},{"$f":"I23*Data!$B$4","v":0},{"$f":"J23*Data!$B$5","v":0},{"$f":"K23*Data!$B$6","v":0},0,0]
[null,null,7,0,0,null,0,0,0,0,0,{"$f":"G24*Data!$B$2","v":0},{"$f":"H24*Data!$B$3","v":0},{"$f":"I24*Data!$B$4","v":0},{"$f":"J24*Data!$B$5","v":0},{"$f":"K24*Data!$B$6","v":0},0,0]
[null,null,8,0,0,null,{"$f":"F25*$N$11","v":0},{"$f":"F25*$N$12","v":0},{"$f":"F25*$N$13","v":0},{"$f":"F25*$R$11","v":0},{"$f":"F25*$R$12","v":0},{"$f":"G25*Data!$B$2","v":0},{"$f":"H25*Data!$B$3","v":0},{"$f":"I25*Data!$B$4","v":0},{"$f":"J25*Data!$B$5","v":0},{"$f":"K25*Data!$B$6","v":0},0,0]
[null,null,9,0,0,null,{"$f":"F26*$N$11","v":0},{"$f":"F26*$N$12","v":0},{"$f":"F26*$N$13","v":0},{"$f":"F26*$R$11","v":0},{"$f":"F26*$R$12","v":0},{"$f":"G26*Data!$B$2","v":0},{"$f":"H26*Data!$B$3","v":0},{"$f":"I26*Data!$B$4","v":0},{"$f":"J26*Data!$B$5","v":0},{"$f":"K26*Data!$B$6","v":0},{"$f":"SUM(L26:P26)","v":0},{"$f":"(Q26)/((1+$G$11)^(B26))","v":0}]
[null,null,10,0,0,null,0,0,0,0,0,{"$f":"G27*Data!$B$2","v":0},{"$f":"H27*Data!$B$3","v":0},{"$f":"I27*Data!$B$4","v":0},{"$f":"J27*Data!$B$5","v":0},{"$f":"K27*Data!$B$6","v":0},0,0]
[null,null,11,0,0,null,0,0,0,0,0,{"$f":"G28*Data!$B$2","v":0},{"$f":"H28*Data!$B$3","v":0},{"$f":"I28*Data!$B$4","v":0},{"$f":"J28*Data!$B$5","v":0},{"$f":"K28*Data!$B$6","v":0},0,0]
[null,null,12,0,0,null,0,0,0,0,0,{"$f":"G29*Data!$B$2","v":0},{"$f":"H29*Data!$B$3","v":0},{"$f":"I29*Data!$B$4","v":0},{"$f":"J29*Data!$B$5","v":0},{"$f":"K29*Data!$B$6","v":0},0,0]
[null,null,13,0,0,null,0,0,0,0,0,{"$f":"G30*Data!$B$2","v":0},{"$f":"H30*Data!$B$3","v":0},{"$f":"I30*Data!$B$4","v":0},{"$f":"J30*Data!$B$5","v":0},{"$f":"K30*Data!$B$6","v":0},0,0]
[null,null,14,0,0,null,0,0,0,0,0,{"$f":"G31*Data!$B$2","v":0},{"$f":"H31*Data!$B$3","v":0},{"$f":"I31*Data!$B$4","v":0},{"$f":"J31*Data!$B$5","v":0},{"$f":"K31*Data!$B$6","v":0},0,0]
[null,null,15,0,0,null,0,0,0,0,0,{"$f":"G32*Data!$B$2","v":0},{"$f":"H32*Data!$B$3","v":0},{"$f":"I32*Data!$B$4","v":0},{"$f":"J32*Data!$B$5","v":0},{"$f":"K32*Data!$B$6","v":0},0,0]
[null,null,16,0,0,null,0,0,0,0,0,{"$f":"G33*Data!$B$2","v":0},{"$f":"H33*Data!$B$3","v":0},{"$f":"I33*Data!$B$4","v":0},{"$f":"J33*Data!$B$5","v":0},{"$f":"K33*Data!$B$6","v":0},0,0]
[null,null,17,0,0,null,0,0,0,0,0,{"$f":"G34*Data!$B$2","v":0},{"$f":"H34*Data!$B$3","v":0},{"$f":"I34*Data!$B$4","v":0},{"$f":"J34*Data!$B$5","v":0},{"$f":"K34*Data!$B$6","v":0},0,0]
[null,null,18,0,0,null,0,0,0,0,0,{"$f":"G35*Data!$B$2","v":0},{"$f":"H35*Data!$B$3","v":0},{"$f":"I35*Data!$B$4","v":0},{"$f":"J35*Data!$B$5","v":0},{"$f":"K35*Data!$B$6","v":0},0,0]
[null,null,19,0,0,null,0,0,0,0,0,{"$f":"G36*Data!$B$2","v":0},{"$f":"H36*Data!$B$3","v":0},{"$f":"I36*Data!$B$4","v":0},{"$f":"J36*Data!$B$5","v":0},{"$f":"K36*Data!$B$6","v":0},0,0]
[null,null,20,0,0,null,0,0,0,0,0,{"$f":"G37*Data!$B$2","v":0},{"$f":"H37*Data!$B$3","v":0},{"$f":"I37*Data!$B$4","v":0},{"$f":"J37*Data!$B$5","v":0},{"$f":"K37*Data!$B$6","v":0},0,0]
[null,null,21,0,0,null,0,0,0,0,0,{"$f":"G38*Data!$B$2","v":0},{"$f":"H38*Data!$B$3","v":0},{"$f":"I38*Data!$B$4","v":0},{"$f":"J38*Data!$B$5","v":0},{"$f":"K38*Data!$B$6","v":0},0,0]
[null,null,22,0,0,null,0,0,0,0,0,{"$f":"G39*Data!$B$2","v":0},{"$f":"H39*Data!$B$3","v":0},{"$f":"I39*Data!$B$4","v":0},{"$f":"J39*Data!$B$5","v":0},{"$f":"K39*Data!$B$6","v":0},0,0]
[null,null,23,0,0,null,0,0,0,0,0,{"$f":"G40*Data!$B$2","v":0},{"$f":"H40*Data!$B$3","v":0},{"$f":"I40*Data!$B$4","v":0},{"$f":"J40*Data!$B$5","v":0},{"$f":"K40*Data!$B$6","v":0},0,0]
[null,null,24,0,0,null,0,0,0,0,0,{"$f":"G41*Data!$B$2","v":0},{"$f":"H41*Data!$B$3","v":0},{"$f":"I41*Data!$B$4","v":0},{"$f":"J41*Data!$B$5","v":0},{"$f":"K41*Data!$B$6","v":0},0,0]
[null,null,25,0,0,null,0,0,0,0,0,{"$f":"G42*Data!$B$2","v":0},{"$f":"H42*Data!$B$3","v":0},{"$f":"I42*Data!$B$4","v":0},{"$f":"J42*Data!$B$5","v":0},{"$f":"K42*Data!$B$6","v":0},0,0]
[null,null,26,0,0,null,0,0,0,0,0,{"$f":"G43*Data!$B$2","v":0},{"$f":"H43*Data!$B$3","v":0},{"$f":"I43*Data!$B$4","v":0},{"$f":"J43*Data!$B$5","v":0},{"$f":"K43*Data!$B$6","v":0},0,0]
[null,null,"Shaded cell indicates the AADT is outside the limits",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Present Value",{"$f":"SUM(R17:R43)","v":0}]
[]
[]
[null,null,"NOTES:"]
[null,null,"1. Present Value = Future Cash Flow / (1 + Required Rate of Return)Number of Years You Have To Wait For The Cash Flow"]
[null,null,"2. Traffic Growth Rate = [((ADTf / ADTi)(1/(F-I))-1] x 100"]
[null,null,"            where ADTf = Average Daily Traffic for Future Year"]
[null,null,"                         ADTi = Average Daily Traffic for Initial Year"]
[null,null,"                         I = Initial Year for ADT"]
[null,null,"                         F = Future Year for ADT"]

{"sheet":"Intersection2 Crash Cost","index":14,"n_rows":53,"n_cols":18,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,17],[2,1,2,17],[3,1,3,17],[4,1,4,17],[5,1,5,10],[5,11,5,17],[6,2,6,4],[6,6,6,8],[6,12,6,14],[6,16,6,17],[7,1,7,2],[7,3,7,8],[7,12,7,14],[7,16,7,17],[8,1,8,17],[9,3,9,4],[9,11,9,17],[10,3,10,4],[11,3,11,4],[11,6,11,7],[14,11,14,17],[12,3,12,4],[14,1,15,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[14,5,14,10],[12,6,12,7]]}
[]
[null,"State of Florida Department of Transportation"]
[null,"Present Worth Analysis"]
[null,"Rural Two Lane Road"]
[null,{"$f":"IF(A_Type=\"P\",\"Build Alternative\",\"No-Build Alternative\")","v":"No-Build Alternative"}]
[null,"General Information",null,null,null,null,null,null,null,null,null,"Site Information"]
[null,"Analyst:",null,null,null,"Date:",null,null,null,null,null,"Location ID:",null,null,null,"County:"]
[null,"Agency or Company:",null,null,null,null,null,null,null,null,null,"City:",null,null,null,"M.P. - M.P. "]
[null,"Manual Input from Analysis"]
[null,null,"Major Growth Rate =",null,null,"Current Year =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!J7\")","v":0},null,"Project Opening Year =",null,null,"Default Distribution for Crash Severity Level (2010-2014 Florida HSM Crash Distribution)"]
[null,null,"Minor Growth Rate =",null,null,"Rate of Return =",null,null,"Analysis Period =",null,null,null,"Fatality =",3.2000000000000001E-2,null,null,"Possible Injury = ",0.19500000000000001]
[null,null,"Current Year Major AADT =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!majAADT\")","v":0},null,"Intersection =","Intersection2",null,"E",null,null,null,"Incapacitating =",0.11600000000000001,null,null,"Property Damage Only =",0.46100000000000002]
[null,null,"Current Year Minor AADT =",{"$f":"INDIRECT(\"'\" & IntxName & \"'!minAADT\")","v":0},null,"Crash Data Used =","Yes",null,10,null,null,null,"Non-Incapacitating =",0.19600000000000001,null,null,null,{"$f":"SUM(N11:N13,R11:R12)","v":1}]
[]
[null,null,"Year","Major AADT","Minor AADT","Annual Number of Crashes",null,null,null,null,null,"Annual Cost"]
[null,null,null,null,null,"Site Specific (Npredicted / expected)","Fatality","Incap.","Non-Inc.","Possible Injury","PDO","Fatality","Incap.","Non-Inc.","Possible Injury","PDO ","Total Cost","Present Value"]
[null,null,{"$f":"G10","v":0},{"$f":"D12","v":0},{"$f":"D13","v":0},null,{"$f":"F17*$N$11","v":0},{"$f":"F17*$N$12","v":0},{"$f":"F17*$N$13","v":0},{"$f":"F17*$R$11","v":0},{"$f":"F17*$R$12","v":0},{"$f":"G17*Data!$B$2","v":0},{"$f":"H17*Data!$B$3","v":0},{"$f":"I17*Data!$B$4","v":0},{"$f":"J17*Data!$B$5","v":0},{"$f":"K17*Data!$B$6","v":0},{"$f":"SUM(L17:P17)","v":0},{"$f":"(Q17)/((1+$G$11)^(B17))","v":0}]
[null,null,{"$f":"C17+1","v":1},{"$f":"D17*(1+$D$10)","v":0},{"$f":"E17*(1+$D$11)","v":0},null,0,0,0,0,0,{"$f":"G18*Data!$B$2","v":0},{"$f":"H18*Data!$B$3","v":0},{"$f":"I18*Data!$B$4","v":0},{"$f":"J18*Data!$B$5","v":0},{"$f":"K18*Data!$B$6","v":0},{"$f":"SUM(L18:P18)","v":0},0]
[null,null,{"$f":"C18+1","v":2},{"$f":"D18*(1+$D$10)","v":0},{"$f":"E18*(1+$D$11)","v":0},null,0,0,0,0,0,{"$f":"G19*Data!$B$2","v":0},{"$f":"H19*Data!$B$3","v":0},{"$f":"I19*Data!$B$4","v":0},{"$f":"J19*Data!$B$5","v":0},{"$f":"K19*Data!$B$6","v":0},0,0]
[null,null,3,0,0,null,0,0,0,0,0,{"$f":"G20*Data!$B$2","v":0},{"$f":"H20*Data!$B$3","v":0},{"$f":"I20*Data!$B$4","v":0},{"$f":"J20*Data!$B$5","v":0},{"$f":"K20*Data!$B$6","v":0},0,0]
[null,null,4,0,0,null,0,0,0,0,0,{"$f":"G21*Data!$B$2","v":0},{"$f":"H21*Data!$B$3","v":0},{"$f":"I21*Data!$B$4","v":0},{"$f":"J21*Data!$B$5","v":0},{"$f":"K21*Data!$B$6","v":0},0,0]
[null,null,5,0,0,null,0,0,0,0,0,{"$f":"G22*Data!$B$2","v":0},{"$f":"H22*Data!$B$3","v":0},{"$f":"I22*Data!$B$4","v":0},{"$f":"J22*Data!$B$5","v":0},{"$f":"K22*Data!$B$6","v":0},0,0]
[null,null,6,0,0,null,0,0,0,0,0,{"$f":"G23*Data!$B$2","v":0},{"$f":"H23*Data!$B$3","v":0},{"$f":"I23*Data!$B$4","v":0},{"$f":"J23*Data!$B$5","v":0},{"$f":"K23*Data!$B$6","v":0},0,0]
[null,null,7,0,0,null,0,0,0,0,0,{"$f":"G24*Data!$B$2","v":0},{"$f":"H24*Data!$B$3","v":0},{"$f":"I24*Data!$B$4","v":0},{"$f":"J24*Data!$B$5","v":0},{"$f":"K24*Data!$B$6","v":0},0,0]
[null,null,8,0,0,null,0,{"$f":"F25*$N$12","v":0},0,0,0,{"$f":"G25*Data!$B$2","v":0},{"$f":"H25*Data!$B$3","v":0},{"$f":"I25*Data!$B$4","v":0},{"$f":"J25*Data!$B$5","v":0},{"$f":"K25*Data!$B$6","v":0},0,0]
[null,null,9,0,0,null,0,{"$f":"F26*$N$12","v":0},0,0,0,{"$f":"G26*Data!$B$2","v":0},{"$f":"H26*Data!$B$3","v":0},{"$f":"I26*Data!$B$4","v":0},{"$f":"J26*Data!$B$5","v":0},{"$f":"K26*Data!$B$6","v":0},0,0]
[null,null,10,0,0,null,0,0,0,0,0,{"$f":"G27*Data!$B$2","v":0},{"$f":"H27*Data!$B$3","v":0},{"$f":"I27*Data!$B$4","v":0},{"$f":"J27*Data!$B$5","v":0},{"$f":"K27*Data!$B$6","v":0},0,0]
[null,null,11,0,0,null,0,0,0,0,0,{"$f":"G28*Data!$B$2","v":0},{"$f":"H28*Data!$B$3","v":0},{"$f":"I28*Data!$B$4","v":0},{"$f":"J28*Data!$B$5","v":0},{"$f":"K28*Data!$B$6","v":0},0,0]
[null,null,12,0,0,null,0,0,0,0,0,{"$f":"G29*Data!$B$2","v":0},{"$f":"H29*Data!$B$3","v":0},{"$f":"I29*Data!$B$4","v":0},{"$f":"J29*Data!$B$5","v":0},{"$f":"K29*Data!$B$6","v":0},0,0]
[null,null,13,0,0,null,0,0,0,0,0,{"$f":"G30*Data!$B$2","v":0},{"$f":"H30*Data!$B$3","v":0},{"$f":"I30*Data!$B$4","v":0},{"$f":"J30*Data!$B$5","v":0},{"$f":"K30*Data!$B$6","v":0},0,0]
[null,null,14,0,0,null,0,0,0,0,0,{"$f":"G31*Data!$B$2","v":0},{"$f":"H31*Data!$B$3","v":0},{"$f":"I31*Data!$B$4","v":0},{"$f":"J31*Data!$B$5","v":0},{"$f":"K31*Data!$B$6","v":0},0,0]
[null,null,15,0,0,null,0,0,0,0,0,{"$f":"G32*Data!$B$2","v":0},{"$f":"H32*Data!$B$3","v":0},{"$f":"I32*Data!$B$4","v":0},{"$f":"J32*Data!$B$5","v":0},{"$f":"K32*Data!$B$6","v":0},0,0]
[null,null,16,0,0,null,0,0,0,0,0,{"$f":"G33*Data!$B$2","v":0},{"$f":"H33*Data!$B$3","v":0},{"$f":"I33*Data!$B$4","v":0},{"$f":"J33*Data!$B$5","v":0},{"$f":"K33*Data!$B$6","v":0},0,0]
[null,null,17,0,0,null,0,0,0,0,0,{"$f":"G34*Data!$B$2","v":0},{"$f":"H34*Data!$B$3","v":0},{"$f":"I34*Data!$B$4","v":0},{"$f":"J34*Data!$B$5","v":0},{"$f":"K34*Data!$B$6","v":0},0,0]
[null,null,18,0,0,null,0,0,0,0,0,{"$f":"G35*Data!$B$2","v":0},{"$f":"H35*Data!$B$3","v":0},{"$f":"I35*Data!$B$4","v":0},{"$f":"J35*Data!$B$5","v":0},{"$f":"K35*Data!$B$6","v":0},0,0]
[null,null,19,0,0,null,0,0,0,0,0,{"$f":"G36*Data!$B$2","v":0},{"$f":"H36*Data!$B$3","v":0},{"$f":"I36*Data!$B$4","v":0},{"$f":"J36*Data!$B$5","v":0},{"$f":"K36*Data!$B$6","v":0},0,0]
[null,null,20,0,0,null,0,0,0,0,0,{"$f":"G37*Data!$B$2","v":0},{"$f":"H37*Data!$B$3","v":0},{"$f":"I37*Data!$B$4","v":0},{"$f":"J37*Data!$B$5","v":0},{"$f":"K37*Data!$B$6","v":0},0,0]
[null,null,21,0,0,null,0,0,0,0,0,{"$f":"G38*Data!$B$2","v":0},{"$f":"H38*Data!$B$3","v":0},{"$f":"I38*Data!$B$4","v":0},{"$f":"J38*Data!$B$5","v":0},{"$f":"K38*Data!$B$6","v":0},0,0]
[null,null,22,0,0,null,0,0,0,0,0,{"$f":"G39*Data!$B$2","v":0},{"$f":"H39*Data!$B$3","v":0},{"$f":"I39*Data!$B$4","v":0},{"$f":"J39*Data!$B$5","v":0},{"$f":"K39*Data!$B$6","v":0},0,0]
[null,null,23,0,0,null,0,0,0,0,0,{"$f":"G40*Data!$B$2","v":0},{"$f":"H40*Data!$B$3","v":0},{"$f":"I40*Data!$B$4","v":0},{"$f":"J40*Data!$B$5","v":0},{"$f":"K40*Data!$B$6","v":0},0,0]
[null,null,24,0,0,null,0,0,0,0,0,{"$f":"G41*Data!$B$2","v":0},{"$f":"H41*Data!$B$3","v":0},{"$f":"I41*Data!$B$4","v":0},{"$f":"J41*Data!$B$5","v":0},{"$f":"K41*Data!$B$6","v":0},0,0]
[null,null,25,0,0,null,0,0,0,0,0,{"$f":"G42*Data!$B$2","v":0},{"$f":"H42*Data!$B$3","v":0},{"$f":"I42*Data!$B$4","v":0},{"$f":"J42*Data!$B$5","v":0},{"$f":"K42*Data!$B$6","v":0},0,0]
[null,null,26,0,0,null,0,0,0,0,0,{"$f":"G43*Data!$B$2","v":0},{"$f":"H43*Data!$B$3","v":0},{"$f":"I43*Data!$B$4","v":0},{"$f":"J43*Data!$B$5","v":0},{"$f":"K43*Data!$B$6","v":0},0,0]
[null,null,"Shaded cell indicates the AADT is outside the limits",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Present Value",{"$f":"SUM(R17:R43)","v":0}]
[]
[]
[null,null,"NOTES:"]
[null,null,"1. Present Value = Future Cash Flow / (1 + Required Rate of Return)Number of Years You Have To Wait For The Cash Flow"]
[null,null,"2. Traffic Growth Rate = [((ADTf / ADTi)(1/(F-I))-1] x 100"]
[null,null,"            where ADTf = Average Daily Traffic for Future Year"]
[null,null,"                         ADTi = Average Daily Traffic for Initial Year"]
[null,null,"                         I = Initial Year for ADT"]
[null,null,"                         F = Future Year for ADT"]

{"sheet":"Intersection Summary Costs","index":15,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,10],[2,1,3,1],[2,2,2,5],[2,6,2,9],[2,10,3,10]]}
[]
[null,"SUMMARY OF TOTAL PRESENT VALUE FOR INTERSECTIONS"]
[null,"Intersection Site","Beginning Year",null,null,null,"End Year",null,null,null,"Total Present Value"]
[null,null,"Year","Major AADT","Minor AADT","Npredicted-rs","Year","Major AADT","Minor AADT","Npredicted-rs"]
[null,"Intersection1",{"$f":"'Intersection1 Crash Cost'!C22","v":5},{"$f":"'Intersection1 Crash Cost'!D22","v":0},{"$f":"'Intersection1 Crash Cost'!E22","v":0},{"$f":"'Intersection1 Crash Cost'!F22","v":0},{"$f":"'Intersection1 Crash Cost'!C30","v":13},{"$f":"'Intersection1 Crash Cost'!D30","v":0},{"$f":"'Intersection1 Crash Cost'!E30","v":0},{"$f":"'Intersection1 Crash Cost'!F30","v":0},{"$f":"'Intersection1 Crash Cost'!$R$44","v":0}]
[null,"Intersection2",{"$f":"'Intersection2 Crash Cost'!C18","v":1},{"$f":"'Intersection2 Crash Cost'!D18","v":0},{"$f":"'Intersection2 Crash Cost'!E18","v":0},{"$f":"'Intersection2 Crash Cost'!F18","v":0},{"$f":"'Intersection2 Crash Cost'!C32","v":15},{"$f":"'Intersection2 Crash Cost'!D32","v":0},{"$f":"'Intersection2 Crash Cost'!E32","v":0},{"$f":"'Intersection2 Crash Cost'!F32","v":0},{"$f":"'Intersection2 Crash Cost'!$R$44","v":0}]
[]
[]
[null,"COMBINED",null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K8)","v":0}]

{"sheet":"Data","index":16,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"Cost of Crashes",null,"2U","4U","4D"]
["Fatal (K)",10230000,null,3.2000000000000001E-2,2.9000000000000001E-2,0.03]
["Severe Injury (A)",580320,null,0.11600000000000001,0.111,0.112]
["Moderate Injury (B)",157170,null,0.19600000000000001,0.182,0.20599999999999999]
["Minor Injury C",97650,null,0.19600000000000001,0.219,0.19700000000000001]
["PDO",7600,null,0.46100000000000002,0.46,0.45300000000000001]