{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Instructions","Operational Benefit-Cost","Service Life","CRF","Interest Factors","Control Elements","Chart1","2014 5-year Avg. Cost Per Crash"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":16,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":7,"reason":"not_a_worksheet"}],"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":"Introduction","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,2,25,11],[10,2,10,11],[12,3,13,11],[14,3,16,11],[17,3,18,11],[19,3,21,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Benefit-Cost Analysis Template"]
[]
[null,null,"•","A benefit-cost analysis is a tool for assisting project managers when they are evaluating and comparing different alternatives."]
[]
[null,null,"•","Results from a benefit-cost analysis, along with public input and environmental documentation, can be used to evaluate both the financial and social effects and impacts of alternatives when a decision needs    to be made."]
[]
[]
[null,null,"•","From an economic perspective, are the benefits of location Alternative \"A\" worth the project costs? How does location Alternative “A” compare to Alternative “B” or “C”?"]
[]
[null,null,"•","Safety benefits are one of the principal benefits that can result from transportation improvements. Benefits occur when the number of crashes is reduced and/or the severity of the crashes is reduced on a facility or set of facilities because of the transportation improvement."]
[]
[]
[]
[null,null,"Note:  This template is a useful resource, but it remains necessary to apply engineering judgment and to consider site-specific environmental, traffic, geometric, and operational conditions which will affect the safety impact of a countermeasure."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Rev. 02/2014"]

{"sheet":"Instructions","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,2,3,11],[13,6,13,11]]}
[]
[]
[]
[null,null,"Instructions"]
[null,null,null,"Fill in \"Blue\" areas only"]
[]
[null,null,null,"Select from drop-down list",null,null,"District, County"]
[null,null,null,"Fill in",null,null,"Date Prepared, Location Description, Section No., BMP, EMP"]
[null,null,null,"Select from drop-down list",null,null,"Roadway Type (i.e. 2 - 3 lanes, urban, undivided)"]
[null,null,null,"Select from drop-down list",null,null,"Control Element (i.e. Horizontal Clearance)"]
[null,null,null,"Improvement",null,null,"Description of Improvement"]
[]
[null,null,null,"Fill in",null,null,"Cost for each element, If applicable"]
[null,null,null,"Fill in",null,null,"Service Life for each element; Defaults are entered, See Service Life Tab, make changes as needed"]
[]
[null,null,null,"Enter Total No. of Crashes",null,null,"Crashes in the exception area"]
[null,null,null,"Enter No.of correctable crashes",null,null,"Number of crashes that are correctable by the proposed correction"]
[null,null,null,"Enter No. of Years of crash data",null,null,"Minimum of 5 years"]
[]
[null,null,null,"Primary Crash Reduction Factor",null,null,"Whole value (i.e. 30)",null,"FHWA CRF link or CRF (SSO) tab, other"]
[null,null,null,"Description",null,null,"i.e. pavement grooving"]
[null,null,null,"Additional CRF",null,null,"Not required, but more than one can be used;  Whole value (i.e. 25)"]
[null,null,null,"Description",null,null,"i.e. reconstruct curve"]
[null,null,null,"Additional CRF",null,null,"Not required, but more than one can be used;  Whole value (i.e. 45)"]
[null,null,null,"Description",null,null,"i.e. superelevation"]
[]
[null,null,null,"Comments",null,null,"Enter any additional info including source info for CRF"]
[null,null,null,"Prepared by",null,null,"Name of who prepared the analysis"]

{"sheet":"Operational Benefit-Cost","index":2,"n_rows":68,"n_cols":19,"rows_kept":68,"cut":false,"hidden":false,"merged":[[33,12,33,14],[38,8,38,11],[37,8,37,10],[53,10,53,11],[8,3,8,10],[10,3,10,4],[11,4,11,6],[46,6,47,6],[46,8,47,8],[49,1,51,11],[40,8,40,10],[43,9,43,11],[34,8,34,10],[27,4,27,5],[28,4,28,5],[28,6,28,7],[24,4,24,5],[25,4,25,5],[26,4,26,5],[20,6,20,7],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[4,6,4,10],[6,3,6,4],[6,7,6,8],[14,2,14,5],[19,1,19,11],[13,5,13,7],[15,2,16,10],[32,12,32,14],[21,12,21,14],[49,12,50,14],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[31,12,31,14],[39,12,42,14],[35,8,35,11],[46,9,47,9],[41,8,41,11],[33,1,33,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Counties"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01 - Charlotte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District","02 - Citrus"]
[null,"Rev. 02/2014",null,null,null,null,"Benefit-Cost Analysis",null,null,null,null,null,null,null,null,null,null,"One","03 - Collier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Two","04 - De Soto"]
[null,null,"District:",null,null,null,"County:",null,null,null,"Date Prepared:",null,null,null,null,null,null,"Three","05 - Glades"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Four","06 - Hardee"]
[null,null,"Location:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Five","07 - Hendry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Six","08 - Hernando"]
[null,null,"Section :",null,null,null,"Beg. Milepost :",null,null,"End Milepost :",null,null,null,null,null,null,null,"Seven","09 - Highlands"]
[null,null,null,"Rdway Type:","2 - 3 Lanes Rural Divided",null,null,null,null,null,null,null,null,null,null,null,null,"Turnpike","10 - Hillsborough"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11 - Lake"]
[null,null,null,null,"Control Element:",null,null,null,null,null,null,null,null,null,null,null,null,null,"12 - Lee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13 - Manatee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14 - Pasco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 - Pinellas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 - Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17 - Sarasota"]
[null,"ANNUAL COST OF IMPROVEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18 - Sumter"]
[null,null,null,null,"Type",null,"Cost",null,"Service Life","Capital Recovery Factor","Total",null,null,null,null,null,null,null,"26 - Alachua"]
[null,null,null,null,"ROW",null,null,null,100,{"$f":"LOOKUP(I22,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":4.0800000000000003E-2},{"$f":"J22*G22","v":0},null,null,null,null,null,null,null,"27 - Baker"]
[null,null,null,null,"P.E.C.E.I.",null,null,null,15,{"$f":"LOOKUP(I23,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":8.9899999999999994E-2},0,null,null,null,null,null,null,null,"28 - Bradford"]
[null,null,null,null,"Structure",null,null,null,75,{"$f":"LOOKUP(I24,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":4.2500000000000003E-2},0,null,null,null,null,null,null,null,"29 - Columbia"]
[null,null,null,null,"Roadway",null,null,null,20,{"$f":"LOOKUP(I25,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":7.3599999999999999E-2},0,null,null,null,null,null,null,null,"30 - Dixie"]
[null,null,null,null,"Drainage",null,null,null,20,{"$f":"LOOKUP(I26,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":7.3599999999999999E-2},0,null,null,null,null,null,null,null,"31 - Gilchrist"]
[null,null,null,null,"Signal",null,null,null,20,{"$f":"LOOKUP(I27,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":7.3599999999999999E-2},0,null,null,null,null,null,null,null,"32 - Hamilton"]
[null,null,null,null,"Other",null,null,null,20,{"$f":"LOOKUP(I28,'Interest Factors'!$A$2:$A$49,'Interest Factors'!$D$2:$D$49)","v":7.3599999999999999E-2},0,null,null,null,null,null,null,null,"33 - Lafayette"]
[null,null,null,null,"Sub-Total",null,{"$f":"SUM(G22:G28)","v":0},null,null,null,{"$f":"SUM(K22:K28)","v":0},null,null,null,null,null,null,null,"34 - Levy"]
[null,null,null,null,null,null,null,null,null,"Annual Cost =",{"$f":"SUM(K29:K29)","v":0},null,null,null,null,null,null,null,"36 - Marion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 - Suwannee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"38 - Taylor"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Crash Reduction Factors"]
[null,null,null,null,null,null,null,null,null,null,null,null,"In Order of Preference",null,null,null,null,null,"39 - Union"]
[null,null,null,null,null,"Total number of crashes =",null,null,"Primary crash reduction factor (%):",null,null,null,null,null,null,null,null,null,"46 - Bay"]
[null,null,null,null,null,"# of correctable crashes, PC =",null,null,null,null,null,null,"#1",null,null,null,null,null,"47 -  Calhoun"]
[null,null,null,null,null,"# of years of crash data, YD =",null,null,null,null,null,null,null,null,null,null,null,null,"48 - Escambia"]
[null,null,null,null,null,"PC/YD =",{"$f":"G36/G37","v":{"$error":"#DIV/0!"}},null,"Additional crash reduction factor:",null,null,null,null,null,null,null,null,null,"49 - Franklin"]
[null,null,null,null,null,"Crash reduction factor, CRF =",{"$f":"(L35/100)+((1-L35/100)*L38/100)+(((1-(L35/100))*(1-(L38/100)))*L41/100)","v":0},null,null,null,null,null,null,null,null,null,null,null,"50 - Gadsden"]
[null,null,null,null,null,"CRF x (PC/YD) =",{"$f":"G39*G38","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"< 5 projects to generate the CRF, may not be appropriate for the analysis.  Go to Option #2",null,null,null,null,null,"51 -  Gulf"]
[null,null,null,null,null,"Cost per crash, CPC =",{"$f":"LOOKUP(Rdway_Type,'2014 5-year Avg. Cost Per Crash'!A1:A21,'2014 5-year Avg. Cost Per Crash'!B1:B21)","v":342662},null,"Additional crash reduction factor:",null,null,null,null,null,null,null,null,null,"52 - Holmes"]
[null,null,null,null,null,"Benefit =",{"$f":"G41*G40","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,"53 - Jackson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"54 - Jefferson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - Leon"]
[null,null,null,null,null,null,null,"BENEFIT/COST RATIO",null,null,null,null,"#2",null,null,null,null,null,"56 - Liberty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"57 - Okaloosa"]
[null,null,null,null,null,"Benefit","=",{"$f":"G42","v":{"$error":"#DIV/0!"}},"=",{"$f":"H47/H48","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"58 - Santa Rosa"]
[null,null,null,null,null,"Cost",null,{"$f":"K30","v":0},null,null,null,null,null,null,null,null,null,null,"59 - Wakulla"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - Walton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"61 - Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - Brevard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"71 - Clay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"72 - Duval"]
[null,null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,null,"73 - Flagler"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"74 - Nassau"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"76 - Putnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"77 - Seminole"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"78 - St Johns"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"79 - Volusia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"86 - Broward"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"87 - Dade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"88 - Indian River"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"89 - Martin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"90 - Monroe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"91 - Okeechobee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"92 - Osceola"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"93 - Palm Beach"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"94 - St Lucie"]

{"sheet":"Service Life","index":3,"n_rows":79,"n_cols":2,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Recommended Service Life Criteria"]
[]
["Intersection & Traffic Control ","Years"]
["Channelization, left-turn bay",10]
["Install New Traffic Signals  ",10]
["Upgrade Traffic Signals  ",10]
["Improve Sight Distance  ",10]
["Construct Roundabout  ",20]
["Retime Coordinated System  ",5]
["Other intersection improvements, except structures",10]
[]
["Pedestrian & Bicycle Safety ","Years"]
["Construct Sidewalk  ",20]
["Install Fencing and Pedestrian Barrier  ",10]
["Construct Bikeway  ",20]
["   ","   "]
["Structures ","Years"]
["Widening bridge or major structure",20]
["Replace bridge or major structure",30]
["New bridge or major structure",50]
["Replace/Improve Minor structure",20]
["Upgrade Bridge Rail  ",20]
["Pedestrian & Bicycle  Overpass/Underpass  ",50]
["Mechanically Stabilized Earth (MSE) Walls",75]
["Mechanically Stabilized Earth (MSE) Walls:  supporting abutments on spread footings",100]
["Other structure",20]
[]
[" Roadway","Years"]
["Pavement widening, no lanes added",20]
["Lanes added without new median",20]
["Highway divided, new median",20]
["Shoulder widening or improvement",20]
["Skid treatment – grooving",10]
["Skid treatment – overlay",10]
["Flattening, clearing side slopes",20]
["Other cross section",20]
["Horizontal alignment changes (except at railroads)",20]
["Vertical alignment changes",20]
["Other alignments",20]
[]
["Roadside Appurtenances","Years"]
["Traffic signs",6]
["Breakaway sign or luminaire supports",10]
["Road edge guardrail",10]
["Median barrier",15]
["Markings, delineators",2]
["Lighting",15]
["Improve drainage structure",20]
["Fencing",10]
["Impact attenuators",10]
["Install Breakaway Utility Poles  ",10]
["Relocate Utility Poles  ",20]
["Install Guardrail End Treatment  ",10]
["Upgrade Guardrail  ",10]
["Upgrade or Install Concrete Median Barrier  ",20]
["Upgrade or Install Cable Median Barrier  ",10]
["Other roadside improvements",10]
[]
["Railroad Grade Crossings","Years"]
["Flashing lights replacing signs",10]
["Elimination by new or reconstructed grade separation",50]
["Elimination by relocation of highway or railroad",50]
["Illumination",15]
["Flashing lights replacing active devices",15]
["Automatic gates replacing signs",15]
["Automatic gates replacing active devices",15]
["Signing, marking",10]
["Crossing surface improvement",15]
["Other railroad grade crossing improvement",15]
[]
["Other Safety Improvements","Years"]
["Remove Obstacles  ",20]
["Install Edge Treatments  ",7]
["Install Centerline Rumble Strips  ",7]
["Raised pavement markers",5]
["Guide markers",5]
["Painted stripes",2]
["Safety provisions for roadside features and appurtenances",20]
["All projects not otherwise classifiable",20]

{"sheet":"CRF","index":4,"n_rows":156,"n_cols":35,"rows_kept":156,"cut":false,"hidden":false,"merged":[[1,0,1,34],[2,0,2,34],[3,1,3,33],[4,2,4,15],[4,0,5,0],[4,1,5,1],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,23,5,23],[4,24,5,24],[141,0,141,34],[139,0,139,34],[142,0,142,34],[4,25,5,25],[4,26,5,26],[4,27,5,27],[4,33,5,33],[4,34,5,34],[4,28,5,28],[4,29,5,29],[4,30,5,30],[4,31,5,31],[4,32,5,32],[140,0,140,34]]}
[]
["Crash Reduction Factors (as of 02/14/2014)               "]
["Florida Department of Transportation               "]
[null,"Note:  Use of CRFs based on less than 5 projects (Column C) are not recommended for use in B/C analysis.  Positive CRFs imply reduced crashes.  Negative CRFs imply increased crashes.            "]
["ID","Improvement","Potential Controlling Criteria Application",null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Projects","Total","Fatal","Injury","PDO","Urban","Rural","Night","Day","Rear-End","Angle","Left-Turn","Right-Turn","Sideswipe","Fixed-Object","Head-On","Pedestrian","Ran-Off-Road","Wet Surface"]
[null,null,"DS","LW","SW","BW","HA","SE","VA","G","SSD","CS","VC","HC","SC","Other"]
[1,"New signal at channelized intersection",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,31,12,15,20,-1,13,7,4,16,-51,53,16,70,10,-40,53,-90,-90,20]
[2,"New signal at non-channelized intersection",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,11,15,58,15,14,20,-27,21,13,-5,11,34,23,23,51,-46,13,26,11]
[3,"Add signal and channelization",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,19,19,-8,25,13,17,21,-41,31,-8,40,50,26,-16,-3,48,58,51,34]
[4,"Modify signal at channelized intersection",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,7,11,null,31,-18,11,null,-13,18,29,20,17,7,-4,-272,-272,7,-86,22]
[5,"Modify signal at non-channelized intersection",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,2,-99,-23,-118,-85,38,-141,-126,-73,-48,-94,-188,100,-23,38,null,null,null,-48]
[6,"Modify both signal and channelization",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,15,24,50,33,13,25,-20,7,29,6,30,66,-4,4,4,-59,34,-164,33]
[7,"Modify signal and add channelization",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,10,28,-87,27,29,28,30,-1,35,11,37,49,25,-42,-20,-87,null,38,-17]
[8,"Remove signal",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[9,"Add flashing warning signal (signalization)",null,null,null,null,"x",null,"x",null,"x",null,null,null,null,null,4,-2,100,-37,28,null,-2,59,-22,80,-30,-117,100,-63,100,null,null,100,46]
[10,"Interconnect traffic signals","x",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,"New LT channelization w/ LT phase (signalized)","x",null,null,null,null,null,null,null,null,null,null,null,null,null,9,17,59,36,-9,16,44,16,19,5,16,50,-42,12,-1,15,29,68,18]
[12,"New LT channelization w/o LT phase (signalized)","x",null,null,null,null,null,null,null,null,null,null,null,null,null,10,31,79,35,26,31,39,33,30,18,46,61,42,39,-26,38,41,12,49]
[13,"New LT channelization (nonsignalized intersection)","x",null,null,null,null,null,null,null,null,null,null,null,null,null,46,3,61,9,-6,-6,20,-26,9,-5,7,24,42,1,-19,-26,6,0,21]
[14,"Modify intersection at signalized intersection",null,null,null,null,"x",null,null,null,"x",null,null,"x",null,null,28,6,-24,13,0,5,78,1,8,7,10,28,11,3,21,-9,16,24,18]
[15,"Modify intersection at non-signalized intersection",null,null,null,null,"x",null,null,null,"x",null,null,"x",null,null,5,18,66,32,6,18,100,13,15,10,25,59,43,31,-53,39,-2,-2,17]
[16,"Modify channelization and add signal",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,2,22,null,21,22,22,null,-131,18,11,16,39,33,-6,58,-68,16,-26,5]
[17,"Increase storage lane",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",8,11,-76,15,9,20,-10,-9,17,0,8,15,-36,7,1,-68,17,-6,17]
[18,"Add turn bay",null,"x","x",null,null,null,"x",null,"x",null,null,null,null,null,8,10,52,16,-1,10,10,1,11,5,6,21,36,20,-222,-190,null,36,48]
[19,"Add right turn","x","x","x",null,null,null,null,null,null,null,null,null,null,null,8,9,67,9,8,0,52,-6,3,11,16,37,1,-20,-39,-33,-49,100,16]
[20,"Add LT (T-intersection)","x","x","x",null,null,null,null,null,null,null,null,null,null,null,3,42,9,56,31,42,43,-39,61,37,84,84,-81,55,-55,100,null,48,-81]
[21,"Add LT (Y-intersection)","x","x","x",null,null,null,null,null,null,null,null,null,null,null,1,42,-118,53,31,42,null,24,56,52,48,84,46,17,32,69,-118,27,64]
[22,"Add 2nd LT lane in same direction as existing",null,"x","x",null,null,null,null,null,null,null,null,null,null,"x",15,4,0,13,-3,1,92,0,2,1,22,30,45,-33,28,-135,-25,13,15]
[23,"Guardrail at bridges end",null,null,null,"x",null,null,null,null,null,null,null,"x",null,null,0]
[24,"Guardrail at steep embankments",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,3,-5,-3,3,-16,-2,-19,-63,2,3,-184,-55,null,74,-120,100,null,5,-9]
[25,"Guardrail at steep embankments with curve",null,"x","x",null,null,"x",null,null,null,null,null,"x",null,null,1,-256,null,-78,null,null,-256,null,-167,null,null,null,null,100,null,null,null,null,11]
[26,"Guardrail at roadside obstacles (piers, sign posts, poles, etc.)",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,1,52,null,60,37,52,null,27,62,44,100,null,null,68,37,100,100,null,54]
[27,"Guardrail end treatments",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,0]
[28,"Guardrail relocation",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,0]
[29,"Guardrail removal",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,0]
[30,"Add painted median",null,"x","x",null,null,null,null,null,null,null,null,null,null,"x",2,43,78,43,40,null,43,-273,25,33,14,68,66,62,-72,57,83,-15,39]
[31,"Add raised median",null,"x","x",null,null,null,null,null,null,null,null,null,null,"x",18,20,38,19,20,20,null,22,19,2,29,48,23,41,-2,45,22,-37,27]
[32,"Increase median width",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,4,-2,-12,0,-3,-10,100,-19,3,3,-43,5,3,-28,30,-699,-224,60,45]
[33,"Add two-way LT lanes","x","x","x",null,null,null,null,null,null,null,null,null,null,null,12,41,35,45,39,40,44,33,44,58,32,36,32,38,34,18,-24,27,24]
[34,"Install concrete median barrier",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,1,-37,56,-27,-46,-37,null,-71,-36,-46,-407,56,94,29,-112,9,-58,-73,-48]
[35,"Install double sided guardrail on wider median",null,"x","x",null,null,null,null,null,null,null,null,"x",null,null,12,-16,33,1,-38,-29,1,-15,-17,3,-4,2,null,19,-83,61,-96,28,-54]
[36,"Install attenuator type (IBC) barrier",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,0]
[37,"Upgrade to concrete median barrier",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,0]
[38,"Upgrade to attenuator barrier",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,0]
[39,"Pavement deslicking",null,null,null,null,null,null,null,null,null,"x","x",null,null,null,4,-3,-30,-13,2,-2,-20,-34,3,17,-24,-7,8,-43,8,-399,35,-127,30]
[40,"Skid Hazard overlay",null,null,null,null,null,null,null,null,null,"x","x",null,null,null,95,-6,-53,-5,-6,-5,-19,-11,-3,2,-35,0,5,-11,-9,-19,-13,-7,18]
[41,"Pavement grooving",null,null,null,null,null,null,null,null,null,"x","x",null,null,null,0]
[42,"Eliminate parking",null,"x","x",null,null,null,null,null,"x",null,null,null,"x",null,4,12,100,11,12,12,null,8,13,2,29,32,46,25,14,13,63,null,26]
[43,"Change two-way operation to one-way",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,0]
[44,"Prohibit turns",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,2,-190,100,-99,-309,-190,null,-43,-360,-198,-138,null,null,null,-19,-19,-19,null,-99]
[45,"Modify speed limit (increase or decrease)","x",null,null,null,null,"x","x",null,"x",null,null,null,"x",null,1,52,56,50,53,null,52,null,54,-18,75,85,null,71,56,null,null,100,78]
[46,"Delineation of right edge lines",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,0]
[47,"Delineation of painted median edge lines",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,1,-76,null,-18,-155,-76,null,-65,-85,-85,7,-85,null,31,-410]
[48,"Centerline striping",null,"x",null,null,null,null,null,null,null,null,null,null,null,null,0]
[49,"Delineation of no passing stripes",null,"x",null,null,"x",null,"x",null,"x",null,null,null,null,null,0]
[50,"Delineation of reflectorized guide markers",null,"x","x",null,"x",null,null,null,null,null,null,null,null,null,0]
[51,"Delineation of reflectorized raised pavement markers (center line)",null,"x",null,null,"x",null,null,null,null,null,null,null,null,null,1,10,23,11,5,null,21,16,3,7,7,-62,100,81,-36,38,100,25,7]
[52,"Delineation of general pavement markings (stop bar, ped. crossing, code 46-51)",null,"x","x",null,null,null,null,null,"x",null,null,null,null,null,0]
[53,"Delineation of guide posts on curves",null,null,null,null,"x","x",null,null,null,null,null,null,null,null,0]
[54,"Intersection delineation",null,"x",null,null,"x",null,null,null,"x",null,null,null,null,null,0]
[55,"Curve warning Signing","x",null,null,null,"x","x",null,null,null,null,null,null,null,null,2,35,null,6,49,44,-306,56,21,72,-2,32,null,49,49,-2,null,null,-19]
[56,"Chevrons Signing","x",null,null,null,"x","x",null,null,null,null,null,null,null,null,1,30,null,12,63,null,30,-120,78,-120,null,100,null,100,-65,100,100,45,-120]
[57,"All-way stops Signing",null,null,null,null,null,null,null,null,"x",null,null,null,null,null,0]
[58,"Overhead directional (where to turn) Signing",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",3,-7,100,-9,-5,-7,null,-17,-4,-15,16,9,41,14,-13,-383,-45,null,-11]
[59,"Roadside directional (where to turn) Signing",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[60,"Overhead lane designation Signing",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[61,"Minor leg stop control Signing",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,0]
[62,"Yield sign",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,0]
[63,"Advanced warning signs",null,null,null,"x","x","x","x","x","x",null,"x",null,"x","x",1,60,null,60,null,null,60,null,60,null,null,100]
[64,"Intersection directional or warning signs",null,null,null,null,"x",null,null,null,null,null,null,null,null,"x",0]
[65,"New roadway segment lighting",null,null,null,null,null,null,"x",null,"x",null,null,"x",null,null,58,2,23,10,-9,2,26,14,-5,-2,-4,25,20,1,-16,-11,33,16,6]
[66,"Upgrade roadway segment lighting",null,null,null,null,null,null,"x",null,"x",null,null,"x",null,null,7,-12,15,-11,-14,-12,100,0,-18,-22,-27,23,57,-1,-8,-39,-1,12,0]
[67,"New lighting at intersection",null,null,null,null,null,null,"x",null,"x",null,null,"x",null,null,9,-2,5,-11,8,-4,-1,31,-15,-30,-15,9,41,12,24,-42,-279,41,-26]
[68,"Upgrade lighting at intersection",null,null,null,null,null,null,"x",null,"x",null,null,"x",null,null,0]
[70,"Bridge approach lighting",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,1,9,null,-5,21,null,9,null,32,-42,null,null,null,62,37,null,null,-26,24]
[71,"Underpass lighting",null,null,null,null,null,null,null,null,null,null,"x",null,null,null,0]
[72,"Intersection flashers four leg red-yellow",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,2,-59,null,null,100,null,-59,null,36,null,-91,52]
[73,"Intersection flashers three leg red-yellow",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,0]
[74,"Intersection flashers four way red",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-105]
[76,"Advanced warning flashers (curve & intersection)",null,null,null,null,"x","x",null,null,"x",null,null,null,null,null,1]
[77,"Install flashing warning signal (flashing beacon)",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,5,-29,null,-65,-12,-52,23,-111,-11,-80,-55,6,48,11,-48,100,null,29,-46]
[78,"Obstacle Removal/Hazard Mitigation",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,5,25,28,37,5,26,19,33,19,22,37,44,14,4,19,6,-38,61,28]
[79,"Relocate obstacle 30 feet from road",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,0]
[80,"Convert to breakaway",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,0]
[81,"Cushion attenuators",null,null,null,null,null,null,null,null,null,null,null,"x",null,null,0]
[82,"Install guardrail",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,9,-38,43,-9,-77,-57,16,-44,-37,-19,-37,19,100,-32,-82,-49,27,-6,-67]
[83,"Upgrade substandard bridgerail",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,1,25,null,100,-125,25,null,100,-12,null,null,null,null,null,-12]
[84,"Realignment",null,null,null,null,"x",null,"x",null,"x",null,null,null,null,null,3,60,50,71,50,-50,100,33,60,57,100,100,null,null,-200,null,null,null,0]
[85,"Superelevation",null,null,null,null,"x","x",null,null,null,null,null,null,null,null,1]
[86,"Modify/Close median openings","x",null,null,null,null,null,null,null,"x",null,null,null,null,null,27,18,40,26,9,18,92,6,21,6,29,58,25,11,-18,-46,-25,45,20]
[87,"Relocate drives",null,null,null,null,null,"x",null,null,"x",null,null,null,null,"x",0]
[88,"Curtail turning movements",null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",0]
[89,"Increase radii at intersection",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,2,38,100,16,58,null,57,21,44,-5,48,-5,null,null,null,null,100,null,-109]
[90,"Widen travel way",null,"x",null,null,null,"x",null,null,null,null,null,null,null,null,2,-52,27,-31,-66,null,-2,-149,-40,7,-56,-136,-164,-27,-10,45,-10,-147,-65]
[91,"Widen shoulder",null,null,"x",null,null,null,null,null,"x",null,null,null,null,null,1,-9,26,-11,-11,null,16,-845,-18,5,-178,-48,-233,72,-39,-48,null,-78,1]
[92,"Add 4 foot shoulders (bike lane)",null,null,"x",null,null,null,null,null,null,null,null,null,null,null,1,6,null,15,3,6,null,-95,17,-15,-37,57,59,51,-173,null,null,67,-18]
[93,"Construct grade separation",null,null,null,null,"x",null,"x",null,"x",null,null,null,null,"x",0]
[94,"Widen bridge (min. of 6 feet)",null,"x","x","x",null,null,null,null,null,null,null,null,null,null,5,55,-39,19,73,-39,65,7,61,48,-109,54,100,69,51,30,30,79,25]
[95,"Reconstruct road & shoulders",null,"x","x",null,null,"x",null,"x",null,null,null,null,null,null,10,-11,-99,-13,-8,-23,66,-41,-2,-1,-51,-9,9,-10,-35,-43,-29,-73,12]
[96,"Reconstruct curve",null,null,null,null,"x","x",null,null,null,null,null,null,null,null,3,42,100,53,43,40,54,28,53,23,27,58,100,78,48,100,17,64,27]
[97,"Construct interchange",null,null,null,null,"x",null,"x",null,"x",null,null,null,null,null,1,-60,100,-188,-24,null,100,100,-99,-61,null,null,null,-13,-50,null,null,25,-126]
[98,"Lengthen accel/decel lanes","x",null,null,null,null,null,null,null,"x",null,null,null,null,null,1]
[99,"Extend drop lane","x",null,null,null,null,null,null,null,"x",null,null,null,null,null,0]
[100,"Install rumble strips",null,"x","x","x","x","x",null,null,"x",null,null,null,null,null,9,22,50,19,22,4,23,38,7,0,14,17,-56,48,4,36,-56,46,20]
[101,"Flatten side slopes",null,null,"x",null,null,null,null,null,null,null,null,"x",null,null,0]
[102,"Install Accel/Decel lane","x",null,null,null,null,null,null,null,"x",null,null,null,null,null,2,20,100,9,8,null,20,52,10,39,22,-7,null,46,null,null,100,57,-115]
[103,"Upgrade signal and add pedestrian feature",null,null,null,null,null,null,null,null,"x",null,null,null,null,"x",17,-5,10,16,-20,-5,null,-7,-7,-20,-20,19,-9,0,19,-78,0,37,-2]
[104,"Sight distance improvements",null,null,null,null,"x",null,null,null,"x",null,null,null,null,null,3,25,-93,38,10,24,25,61,4,13,49,81,null,52,100,null,null,null,4]
[105,"Minor structures replaced or improved for safety",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,1,14,null,32,-23,14,null,23,5,3,22,45,56,-14,56,100,-17,null,-86]
[106,"Lanes added to travel way",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,4,13,69,18,5,13,null,26,5,-2,35,72,6,-15,-26,-214,-183,53,6]
[107,"Upgraded guardrail",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,1,-22,-46,-16,-33,2,-44,8,-44,-25,-7,-155,-292,29,-85,-370,74,-10,-1]
[108,"Sidewalk construction",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",15,-11,-9,1,-29,-11,null,2,-19,-16,-11,14,3,-34,-2,43,15,-15,1]
[109,"Over/Under passes for pedestrians and/or bicycles",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",2,37,null,7,67,37,null,31,35,20,100,null,null,57,null,13,null,null,48]
[110,"Fencing or other pedestrian barriers",null,null,null,null,null,null,null,null,null,null,null,"x",null,"x",2,-4,100,11,-43,-4,null,-61,4,3,10,27,100,-107,-12,3,-45,null,1]
[111,"Ramps on existing curbs",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[112,"New bikeway/multi-use path construction",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[113,"Bicycle non-construction improvements",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",0]
[114,"Impact Attenuators",null,null,"x","x",null,null,null,null,null,null,null,"x",null,null,3,2,null,16,-27,2,null,-14,4,-3,-14,45,-36,26,-70,-2,-2,74,2]
[115,"Signing and Pavement Markings",null,"x","x","x",null,"x",null,null,null,"x",null,null,null,null,11,11,1,11,11,11,6,0,13,10,5,20,4,-21,13,23,-14,8,15]
[116,"Install Traffic Calming Features","x",null,null,null,null,null,null,null,null,null,null,null,null,null,2,8,100,3,-16,8,null,13,20,42,36,null,null,42,-132,100,null,71,42]
[117,"Add paved shoulders",null,null,"x",null,null,"x",null,null,null,"x",null,null,null,null,21,5,-6,12,-9,8,2,9,2,-1,-5,22,40,11,-2,-2,24,4,19]
[118,"Add turn lane/s & pavement resurfacing",null,"x","x",null,null,"x",null,null,null,"x",null,null,null,null,6,35,3,47,21,35,null,45,31,49,20,53,51,-15,3,51,3,-46,33]
[119,"Reconstruct bicycle/multi-use path",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",1,37,100,40,33,37,null,64,24,17,38,52,4,61,36,52,null,null,71]
[120,"Construct median, add signal, & pavmnt.resurfacing",null,"x","x",null,null,"x",null,null,null,"x",null,null,null,null,4,9,-104,34,-30,9,null,-6,13,31,4,22,-53,-55,-13,32,null,100,33]
[121,"Reconstruct median/median improvments",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,16,-14,56,-6,-27,-25,40,0,-19,-31,-57,14,13,-27,-5,-10,-26,26,-23]
[122,"Construct LT and RT lanes",null,"x","x",null,null,null,null,null,null,null,null,null,null,null,5,-8,-7,-4,-12,-12,39,5,-8,-1,-76,11,-22,-107,5,-114,20,47,19]
[123,"Paved shoulders & rumble strips",null,"x","x",null,null,"x",null,null,null,"x",null,null,null,null,3,3,69,8,-17,-79,51,-1,11,-38,-57,62,65,-5,-10,25,100,5,24]
[124,"Upgrade traffic signal",null,null,null,null,null,null,null,null,"x",null,"x",null,null,"x",3,16,null,21,12,16,null,20,11,34,14,-27,-45,-31,30,-24,31,null,35]
[125,"Traffic signals, guardrail, signing & lighting",null,null,null,null,null,null,null,null,"x",null,null,"x",null,"x",0]
[126,"Traffic signals, resurfacing, turn lanes, lighting",null,"x","x",null,null,null,"x",null,null,null,null,"x",null,null,4,-51,100,-27,-87,-36,-158,-105,-48,-52,-32,-47,-67,-80,-128,-42,-24,29,-37]
[127,"Resurface, guardrail, signing & pavt. markings",null,"x","x",null,null,"x",null,null,null,"x",null,"x",null,null,1,-23,null,25,-161,-23,null,-112,2,-71,16,76,null,null,100,null,null,-96,-96]
[128,"Add Ped crossing mid-block with signals",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",3,-23,-93,-21,-24,-23,null,-25,-16,-60,-19,null,-286,4,4,null,52,null,-148]
[129,"Add Ped crossing mid-block without signals",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",1,-52,-46,-27,-108,-52,null,-37,-58,-70,-22,19,-191,-154,-240,-122,-73,100,-37]
[130,"Add roundabout to intersection","x",null,null,"x",null,null,null,null,"x",null,null,null,null,null,2,46,100,58,32,46,null,41,47,65,17,76,-90,44,5,-1607,-8,100,66]
[131,"Convert shldr inverted rumble to audible edgeline",null,null,"x",null,null,null,null,null,null,null,null,null,null,null,0]
[132,"New inverted AUDIBLE marking on CL or edgeline",null,"x","x",null,"x","x",null,null,null,"x",null,null,null,null,12,6,4,14,-6,-5,11,3,9,-19,18,35,21,55,15,17,15,40,4]
[133,"Use of ITS safety system device(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,"x",1,-16,null,52,-42,-16,null,-3,-8,-267,31,-3,-106,-158,-3,83,100,null,-106]
[134,"High friction surface treatment (tyregrip, etc.)",null,null,null,null,"x","x",null,"x",null,"x",null,null,null,null,1]
[135,"Modify signal timing and phasing","x",null,null,null,null,null,null,null,null,null,null,null,null,"x",2,14,null,30,-1,14,null,-9,20,-22,31,66,-20,-17,33,100,-141,null,36]
[]
["1. Source of Crash Data: The Department of Highway Safety and Motor Vehicles (DHSMV) is the official custodian of the crash reports. The numbers that DHSMV reports are the official numbers. The Florida Department of Transportation (FDOT) Safety Office maintains its own database with crash data obtained from DHSMV, and conducts analyses based on this data for internal FDOT purposes."]
["2. Use Restrictions: The information on the Traffic Safety Web Portal has been compiled from information collected for the purpose of identifying, evaluating or planning safety enhancements. It is used to develop highway safety construction improvements projects which may be implemented utilizing Federal Aid Highway funds. Any document displaying this notice shall be used only for the purposes deemed appropriate by the Florida Department of Transportation. See Title 23, United States Code, Section 409."]
["3. Crash Reduction Factors Parameters - ID: 465, From Year: Any Year, To Year: 2009, Before Month: 36, Min. Before Month: 12, After Month: 36, Min. After Month: 12"]
[null,null,"DS","-","Design Speed"]
[null,null,"LW","-","Lane Width"]
[null,null,"SW","-","Shoulder Width"]
[null,null,"BW","-","Bridge Width"]
[null,null,"HA","-","Horizontal Alignment"]
[null,null,"SE","-","Superelevation"]
[null,null,"VA","-","Vertical Alignment"]
[null,null,"G","-","Grade"]
[null,null,"SSD","-","Stopping Sight Distance"]
[null,null,"CS","-","Cross Slope"]
[null,null,"VC","-","Vertical Clearance"]
[null,null,"HC","-","Horizontal Clearance"]
[null,null,"SC","-","Structural Capacity"]

{"sheet":"Interest Factors","index":5,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Year",0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2]
[1,1.02,1.03,1.04,1.05,1.06,1.07]
[2,0.51500000000000001,0.52259999999999995,0.5302,0.53779999999999994,0.5454,0.55310000000000004]
[3,0.3468,0.35349999999999998,0.36030000000000001,0.36720000000000003,0.37409999999999999,0.38109999999999999]
[4,0.2626,0.26900000000000002,0.27550000000000002,0.28299999999999997,0.28860000000000002,0.29520000000000002]
[5,0.2122,0.21840000000000001,0.22459999999999999,0.23100000000000001,0.2374,0.24390000000000001]
[6,0.17849999999999999,0.18459999999999999,0.1908,0.19700000000000001,0.2034,0.20979999999999999]
[7,0.1545,0.1605,0.1666,0.17280000000000001,0.17910000000000001,0.18559999999999999]
[8,0.13650000000000001,0.14249999999999999,0.14849999999999999,0.1547,0.161,0.16750000000000001]
[9,0.1225,0.12839999999999999,0.13450000000000001,0.14069999999999999,0.14699999999999999,0.1535]
[10,0.1113,0.1172,0.12330000000000001,0.1295,0.13589999999999999,0.1424]
[11,0.1022,0.1081,0.11409999999999999,0.12039999999999999,0.1268,0.13339999999999999]
[12,9.4600000000000004E-2,0.10050000000000001,0.1066,0.1128,0.1193,0.12590000000000001]
[13,8.8099999999999998E-2,9.4E-2,0.10009999999999999,0.1065,0.113,0.1197]
[14,8.2600000000000007E-2,8.8499999999999995E-2,9.4700000000000006E-2,0.10100000000000001,0.1076,0.1143]
[15,7.7799999999999994E-2,8.3799999999999999E-2,8.9899999999999994E-2,9.6299999999999997E-2,0.10299999999999999,0.10979999999999999]
[16,7.3700000000000002E-2,7.9600000000000004E-2,8.5800000000000001E-2,9.2299999999999993E-2,9.9000000000000005E-2,0.10589999999999999]
[17,7.0000000000000007E-2,7.5999999999999998E-2,8.2199999999999995E-2,8.8700000000000001E-2,9.5399999999999999E-2,0.1024]
[18,6.6699999999999995E-2,7.2700000000000001E-2,7.9000000000000001E-2,8.5599999999999996E-2,9.2399999999999996E-2,9.9400000000000002E-2]
[19,6.3799999999999996E-2,6.9800000000000001E-2,7.6100000000000001E-2,8.2799999999999999E-2,8.9599999999999999E-2,9.6799999999999997E-2]
[20,6.1199999999999997E-2,6.7199999999999996E-2,7.3599999999999999E-2,8.0199999999999994E-2,8.72E-2,9.4399999999999998E-2]
[21,5.8799999999999998E-2,6.4899999999999999E-2,7.1300000000000002E-2,7.8E-2,8.5000000000000006E-2,9.2299999999999993E-2]
[22,5.6599999999999998E-2,6.2700000000000006E-2,6.9199999999999998E-2,7.6E-3,8.3000000000000004E-2,9.0399999999999994E-2]
[23,5.4699999999999999E-2,6.08E-2,6.7299999999999999E-2,7.4099999999999999E-2,8.1299999999999997E-2,8.8700000000000001E-2]
[24,5.2900000000000003E-2,5.8999999999999997E-2,6.5600000000000006E-2,7.2499999999999995E-2,7.9699999999999993E-2,8.72E-2]
[25,5.1200000000000002E-2,5.74E-2,6.4000000000000001E-2,7.0999999999999994E-2,7.8200000000000006E-2,8.5800000000000001E-2]
[26,4.9700000000000001E-2,5.5899999999999998E-2,6.2600000000000003E-2,6.9599999999999995E-2,7.6899999999999996E-2,8.4599999999999995E-2]
[27,4.8300000000000003E-2,5.4600000000000003E-2,6.1199999999999997E-2,6.83E-2,7.5700000000000003E-2,8.3400000000000002E-2]
[28,4.7E-2,5.33E-2,0.06,6.7100000000000007E-2,7.46E-2,8.2400000000000001E-2]
[29,4.58E-2,5.21E-2,5.8900000000000001E-2,6.6000000000000003E-2,7.3599999999999999E-2,8.14E-2]
[30,4.4600000000000001E-2,5.0999999999999997E-2,5.7799999999999997E-2,6.5100000000000005E-2,7.2599999999999998E-2,8.0600000000000005E-2]
[36,3.9199999999999999E-2,4.58E-2,5.2900000000000003E-2,6.0400000000000002E-2,6.8400000000000002E-2,7.6700000000000004E-2]
[40,3.6600000000000001E-2,4.3299999999999998E-2,5.0500000000000003E-2,5.8299999999999998E-2,6.6500000000000004E-2,7.4999999999999997E-2]
[48,3.2599999999999997E-2,3.9600000000000003E-2,4.7199999999999999E-2,5.5300000000000002E-2,6.3899999999999998E-2,7.2800000000000004E-2]
[50,3.1800000000000002E-2,3.8899999999999997E-2,4.6600000000000003E-2,5.4800000000000001E-2,6.3399999999999998E-2,7.2499999999999995E-2]
[52,3.1099999999999999E-2,3.8199999999999998E-2,4.5999999999999999E-2,5.4300000000000001E-2,6.3E-2,7.2099999999999997E-2]
[60,2.8799999999999999E-2,3.61E-2,4.4200000000000003E-2,5.28E-2,6.1899999999999997E-2,7.1199999999999999E-2]
[70,2.6700000000000002E-2,3.4299999999999997E-2,4.2700000000000002E-2,5.1700000000000003E-2,6.0999999999999999E-2,7.0599999999999996E-2]
[72,2.63E-2,3.4099999999999998E-2,4.2500000000000003E-2,5.1499999999999997E-2,6.0900000000000003E-2,7.0499999999999993E-2]
[80,2.52E-2,3.3099999999999997E-2,4.1799999999999997E-2,5.0999999999999997E-2,6.0600000000000001E-2,7.0300000000000001E-2]
[84,2.47E-2,3.27E-2,4.1500000000000002E-2,5.0799999999999998E-2,6.0499999999999998E-2,7.0199999999999999E-2]
[90,2.4E-2,3.2300000000000002E-2,4.1200000000000001E-2,5.0599999999999999E-2,6.0299999999999999E-2,7.0199999999999999E-2]
[96,2.35E-2,3.1899999999999998E-2,4.0899999999999999E-2,5.0500000000000003E-2,6.0199999999999997E-2,7.0099999999999996E-2]
[100,2.3199999999999998E-2,3.1600000000000003E-2,4.0800000000000003E-2,5.04E-2,6.0199999999999997E-2,7.0099999999999996E-2]
[104,2.29E-2,3.15E-2,4.07E-2,5.0299999999999997E-2,6.0100000000000001E-2,7.0099999999999996E-2]
[120,2.1999999999999999E-2,3.09E-2,4.0399999999999998E-2,5.0099999999999999E-2,6.0100000000000001E-2,7.0000000000000007E-2]
[240,2.0199999999999999E-2,0.03,0.04,0.05,0.06,7.0000000000000007E-2]
[360,0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2]
[480,0.02,0.03,0.04,0.05,0.06,0.7]

{"sheet":"Control Elements","index":6,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Control Element"]
["Design Speed"]
["Structural Capacity"]
["Superelevation"]
["Horizontal Clearance"]
["Lane Widths"]
["Vertical Clearance"]
["Horizontal Alignment"]
["Shoulder Width"]
["Grades"]
["Vertical Alignment"]
["Bridge Widths"]
["Cross Slope"]
["Stopping Sight Distance"]
["Other (describe in box below)"]

{"sheet":"2014 5-year Avg. Cost Per Crash","index":8,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Category","Cost/Injury"]
["2 - 3 Lanes Rural Divided",342662]
["2 - 3 Lanes Rural UnDivided",526887]
["2 - 3 Lanes Suburban Divided",187990]
["2 - 3 Lanes Suburban UnDivided",245281]
["2 - 3 Lanes Urban Divided",109686]
["2 - 3 Lanes Urban UnDivided",125974]
["4 - 5 Lanes Rural Divided",464901]
["4 - 5 Lanes Rural UnDivided",115320]
["4 - 5 Lanes Suburban Divided",216234]
["4 - 5 Lanes Suburban UnDivided",161173]
["4 - 5 Lanes Urban Divided",119072]
["4 - 5 Lanes Urban UnDivided",107908]
["6+ Lanes Rural Divided",313317]
["6+ Lanes Suburban Divided",153957]
["6+ Lanes Urban Divided",117867]
["ALL CRASH RATE CATEGORIES",155695]
["Interstate Rural Divided",341754]
["Interstate Urban Divided",153963]
["Turnpike Rural Divided",254951]
["Turnpike Urban Divided",147939]