{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Safety Calculator","Formulas","Safety Countermeasure ","Lifespan-Safety Countermeasures","Developer Sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":5,"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":"Safety Calculator","index":0,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,2,23,4],[19,2,19,4],[13,2,13,4],[10,8,10,10],[10,2,10,4],[3,1,3,2],[3,3,3,11],[8,2,8,4],[1,1,1,11],[5,1,5,2],[5,3,5,11],[7,1,7,11],[2,10,2,11],[4,10,4,11]]}
[]
[null,"11.16.18                                                                                  Safety Calculator                                                                              "]
[]
[null,"Sponsoring Agency:"]
[]
[null,"Project Title:"]
[]
[null,"* When entering the data below, be sure to use the number of crashes and NOT the number of injuries/people involved. For example: If there was a crash that had one fatality and two minor injuries, sponsors would enter this as one fatal crash. The crash should be documented as the \"highest\" severity listed in the crash report. \n* Sponsors should ONLY use crashes that happen WITHIN the project limits. "]
[]
[]
[null,null,"Benefit/Cost Ratio",null,null,null,null,null,"Outputs"]
[null,null,null,null,null,null,null,null,null,null,"5 Year Crash Data (per 100 million miles)"]
[null,null,null,"Value","Comment",null,null,null,"Crash Rate",null,{"$f":"IFERROR((D19*100000000)/((IF(D21=\"Segment\",D23,1))*D22*5*365), \"-      \")","v":"-      "}]
[null,null,"Number of Crashes from 2012-2016:"]
[null,null,"Fatal (K)",null,"Input",null,null,null,"Fatality & Serious Injury Crash Rate",null,{"$f":"IFERROR(((D15+D16)*100000000)/((IF(D21=\"Segment\",D23,1))*D22*5*365), \"-       \")","v":"-       "}]
[null,null,"Serious Injury (A)",null,"Input"]
[null,null,"Minor Injury (B,C)",null,"Input",null,null,null,"Benefit/Cost Ratio",null,{"$f":"K33","v":0}]
[null,null,"Property Damage Only (O)",null,"Input"]
[null,null,"Total",{"$f":"SUM(D15:D18)","v":0}]
[null,null,"Project Type:"]
[null,null,"Segment or Intersection",null,"Select from drop down list",null,null,null,"CHECKS"]
[null,null,{"$f":"IFERROR(VLOOKUP(D21,'Developer Sheet'!A11:C12,2,FALSE), \"  \")","v":"  "},null,"Number of vehicles (current)"]
[null,null,{"$f":"IF(D21=\"Intersection\", \"   \",\"         Project Length\")","v":"         Project Length"},null,"in miles",null,null,null,"Annual Benefit",null,{"$f":"IF(AND(D19>0,ISBLANK(D27)), \"Please Enter CMF\",(D15*'Developer Sheet'!F3+D16*'Developer Sheet'!F4+D17*'Developer Sheet'!F5+D18*'Developer Sheet'!F6)*(1-D27)/5)","v":0}]
[null,null,"Countermeasure Detail, Implementation, and Cost:"]
[null,null,"Lifespan of Countermeasure",null,"Years",null,null,null,"PVB",null,{"$f":"IFERROR(-PV('Developer Sheet'!A8,'Safety Calculator'!D25,'Safety Calculator'!K23,,0)/((1+'Developer Sheet'!A8)^('Safety Calculator'!D28+'Safety Calculator'!D29)),\"Please Check Input\")","v":0}]
[null,null,"Maintenance Cost of Countermeasure",null,"Annual dollars"]
[null,null,"CMF",null,"One value only/Don't average multiple CMFs",null,null,null,"PVC",null,{"$f":"K29+K31","v":0}]
[null,null,"Years To Construction Phase",null,"Years"]
[null,null,"Duration of Construction Phase",null,"Years, minimum of one year*",null,null,null,"PVC Construction",null,{"$f":"IFERROR(-PV('Developer Sheet'!A8,D29,(D30/D29),,0)/((1+'Developer Sheet'!A8)^('Safety Calculator'!D28)),0)","v":0}]
[null,null,"Total Project Cost",null,"Dollars, include all phases of the project"]
[null,null,null,null,null,null,null,null,"PVC Maintenance",null,{"$f":"IFERROR(-PV('Developer Sheet'!A8,'Safety Calculator'!D25,'Safety Calculator'!D26,,0)/(1+'Developer Sheet'!A8)^('Safety Calculator'!D28+'Safety Calculator'!D29),0)","v":0}]
[null,null,"Key:",null,"*Show projects with less than one year of construction as one year"]
[null,null,"Inputs",null,null,null,null,null,"BCR",null,{"$f":"IFERROR(K25/K27,0)","v":0}]
[]
[null,null,"Results"]

{"sheet":"Formulas","index":1,"n_rows":59,"n_cols":32,"rows_kept":59,"cut":false,"hidden":false,"merged":[[54,2,54,10],[19,3,19,4],[20,3,20,4],[21,3,21,4],[25,2,25,4],[25,5,25,9],[20,5,20,7],[21,5,21,7],[37,15,37,27],[11,2,14,10],[12,17,14,24],[28,2,52,10],[25,17,27,24],[32,17,33,24],[18,3,18,4],[17,3,17,4],[23,2,23,10],[27,2,27,10],[1,1,1,25],[3,1,3,25],[24,17,24,24],[6,2,6,9],[10,2,10,10],[8,2,8,9],[6,17,6,24],[11,17,11,24],[19,17,19,24],[20,17,22,24],[7,17,9,24],[24,2,24,10],[15,2,15,10],[17,5,17,7],[18,5,18,7],[19,5,19,7]]}
[]
[null,"  11.16.18                                                                                                        Safety Calculator Formulas                                                                                                             "]
[]
[null,"This page is for informational reasons only.  The formulas below are the formulas used in the Safety Calculator to develop crash rates and the benefit/cost ratio."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n\n\n"]
[null,null,"Benefit/Cost Ratio Formula",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment Crash Rate Formula"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Number of total crashes) X 100,000,000 vehicle miles traveled\n(Project Length) X (Project Average Daily Traffic) X (Number of Crash Years) X 365"]
[null,null,"Benefit/Cost Ratio= Present Value of Benefits (PVB)/Present Value of Costs (PVC)"]
[]
[null,null,"Present Value of Benefits (PVB) Formula"]
[null,null,"*Use the costs below when entering in the cost of crashes by severity level in the Annual Benefit formula. Both Missouri and Illinois projects should use these costs. East-West Gateway is using the National Safety Council’s average comprehensive costs by injury severity. These 2015 costs are from the National Safety Council Injury Facts, 2017 Edition and are updated by multiplying the 2016 Consumer Price Index. The report can be found here:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intersection Crash Rate Formula"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Number of Accidents) X 100,000,000 million entering vehicles\n(Number of crash years) X (Entering AADT) X 365 days/year"]
[]
[]
[null,null,"http://viewer.zmags.com/publication/20020222#/20020222/1"]
[]
[null,null,null,"Average Comprehensive Cost by Severity",null,"2016 Costs"]
[null,null,null,"Fatal (K)",null,{"$f":"'Developer Sheet'!F3","v":10207160.5}]
[null,null,null,"Serious Injury (A)",null,{"$f":"'Developer Sheet'!F4","v":1113876.6399999999},null,null,null,null,null,null,null,null,null,null,null,"Segment Fatality & Serious Injury Crash Rate Formula"]
[null,null,null,"Minor Injury (B,C)",null,{"$f":"'Developer Sheet'!F5","v":205879},null,null,null,null,null,null,null,null,null,null,null,"(Number of fatal and serious injury crashes) X 100,000,000 vehicle miles traveled\n(Project Length) X (Project Average Daily Traffic) X (Number of Crash Years) X 365"]
[null,null,null,"Property Damage Only (O)",null,{"$f":"'Developer Sheet'!F6","v":8607.23}]
[]
[null,null,"*To find the lifespan of countermeasures use the 'Lifespan-Safety Countermeasures' tab in the Safety Supplement."]
[null,null,"*To find the Crash Modification Factor (CMF) go to the 'Safety Countermeasure' tab in the Safety Supplement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intersection Fatality & Serious Injury Crash Rate Formula"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Number of fatal and serious injury crashes) X 100,000,000 million entering vehicles\n(Number of crash years) X (Entering AADT) X 365 days/year"]
[]
[null,null,"Present Value of Costs (PVC) Formula"]
[null,null,"PVC= PV Construction Cost of Project+ PV Maintenance Cost \n\nPV Construction Cost of Project: \nThis includes all phases of the project (PE, ROW, and construction). \nOrdinary Simple Annuity to get construction cost in start of construction year (CY) dollars, assuming the cost is uniformly divided over the construction period. \n       PVCY= Annual Benefit X [(1+i)ⁿ-1/i(1+i)ⁿ]\n   i= 3%\n   n= Duration of construction\n\nTake this $ amount to the TIP approval year (AY):\n       PVAY= PVCY /(1+i)ⁿ                n= years between TIP approval year to start of construction year\n\nPV Maintenance cost :\nOrdinary Simple Annuity to get maintenance cost over the project lifetime back to opening year value (OpenY):     \n       PVOpenY = Annual Maintenance Cost X [(1+i)ⁿ-1/i(1+i)ⁿ]\n   i= 3%\n   n= Lifespan of countermeasure in years\n\nTake this $ amount to the TIP approval year (AY):\n       PVAY= PVOpenY /(1+i)ⁿ           n= years between TIP approval year to opening year\n\nLifespan of countermeasure= can be found in Appendix F of IDOT’s Benefit-Cost Tool User Guide\n\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crash Modification Factor (CMF)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Crash Modification Factor (CMF) is a multiplicative factor that indicates the proportion of crashes that would be expected after implementing a countermeasure. "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bringing it all to TIP approval year dollar"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      TIP Approval",null,null,null,"          Construction",null,null,"Opening",null,null,null,"End"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance and Annual Benefits",null,null,null,"Thick Line = Ordinary Annuity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thin Line = Compound Interest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction"]
[]
[]
[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,"Updated: "]
[null,null,"Note: All Present Value calculations used excel PV function, with payments due at end of period",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,"04.04.18",null,"LS"]
[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,"09.17.18",null,"LS"]
[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,"11.01.18",null,"LS"]
[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,"11.06.18",null,"LS"]
[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,"11.16.18",null,"RP"]

{"sheet":"Safety Countermeasure ","index":2,"n_rows":89,"n_cols":9,"rows_kept":89,"cut":false,"hidden":false,"merged":[[79,3,80,3],[79,4,80,4],[55,3,56,3],[55,4,56,4],[75,3,76,3],[75,4,76,4],[77,3,78,3],[77,4,78,4],[46,3,47,3],[46,4,47,4],[48,3,49,3],[48,4,49,4],[50,3,51,3],[50,4,51,4],[39,3,40,3],[39,4,40,4],[41,3,42,3],[41,4,42,4],[43,3,44,3],[43,4,44,4],[1,1,1,10],[3,1,3,10],[4,4,4,5],[4,6,4,8],[36,3,38,3],[36,4,38,4]]}
[]
[null,"11.16.18                                          Safety Countermeasure List                                                                                                       "]
[]
[null,"This page is for informational reasons only.  "]
[]
[]
[null,null,null,"Countermeasure Category","Countermeasure","CMF","Crash Type","Crash Severity","CMF Clearinghouse ID"]
[null,null,null,"Access management","Provide a raised median",0.61,"All","Fatal, Serious Injury,  Minor Injury",21]
[null,null,null,"Access management","Increase intersection median width by 3 ft increments",0.96,"Multiple vehicle","All",298]
[null,null,null,"Access management","Replace direct left-turn with right-turn/U-turn",0.8,"All","All",351]
[null,null,null,"Alignment","Increase in horizontal curvature by one degree",1.05,"Run off road","All",60]
[null,null,null,"Alignment","Increase vertical grade by 1%",1.04,"Run off road, Single vehicle","All",61]
[null,null,null,"Alignment","Flatten crest vertical curve",0.49,"All","Fatal, Serious Injury, Minor Injury",721]
[null,null,null,"Bicyclists","Install bicycle lanes",1.05,"All","All",2159]
[null,null,null,"Bicyclists","Install bicycle boulevard",0.37,"Vehicle / bicycle","All",3092]
[null,null,null,"Delineation","Install post-mounted delineators",1.04,"All","Serious Injury, Minor Injury",80]
[null,null,null,"Delineation","Place standard edgeline marking (4-6 in)",0.97,"All","Serious Injury, Minor Injury",83]
[null,null,null,"Delineation","Place centerline markings",0.99,"All","Serious Injury, Minor Injury",87]
[null,null,null,"Delineation","Add lane lines on multilane roadway segments",0.82,"All","All",89]
[null,null,null,"Delineation","Install edgelines and centerlines at sites with higher incidences of crashes",0.87,"All","All",100]
[null,null,null,"Delineation","Place edgeline and centerline markings",0.76,"All","Serious Injury, Minor Injury",101]
[null,null,null,"Delineation","Install edgelines, centerlines, and post-mounted delineators",0.55000000000000004,"All","Serious Injury, Minor Injury",102]
[null,null,null,"Delineation","Provide \"Stop Ahead\" pavement markings",0.69,"All","All",397]
[null,null,null,"Delineation","Install wider edgelines (4 in to 6 in)",0.83,"All","All",4736]
[null,null,null,"Delineation","Install wider markings and edgeline rumble strips with resurfacing",0.76,"All","Fatal, Serious Injury, Minor Injury",4778]
[null,null,null,"Highway lighting","Provide intersection illumination",0.62,"Nighttime","Serious Injury, Minor Injury",433]
[null,null,null,"Intersection geometry","Convert four-leg intersection into two three-leg intersections",1.35,"All","Serious Injury, Minor Injury",200]
[null,null,null,"Intersection geometry","Conversion of stop-controlled intersection into single-lane roundabout",0.28000000000000003,"All","All",206]
[null,null,null,"Intersection geometry","Conversion of signalized intersection into single- or multi-lane roundabout",0.26,"All","Serious Injury, Minor Injury",212]
[null,null,null,"Intersection geometry","Convert intersection with minor-road stop control to modern roundabout",0.56000000000000005,"All","All",227]
[null,null,null,"Intersection geometry","Convert all-way, stop-controlled intersection to roundabout",1.03,"All","All",242]
[null,null,null,"Intersection geometry","Provide a channelized left-turn lane on both major- and minor-road approaches",0.73,"All","Serious Injury, Minor Injury",249]
[null,null,null,"Intersection geometry","Painted channelization of left-turn lane on major road",0.78,"All","Serious injury, Minor injury",251]
[null,null,null,"Intersection geometry","Provide a left-turn lane on one major-road approach",0.56000000000000005,"All","All",253]
[null,null,null,"Intersection geometry","Provide a left-turn lane on both major-road approaches",0.52,"All","All",268]
[null,null,null,"Intersection geometry","Provide a right-turn lane on one major-road approach",0.86,"All","All",285]
[null,null,null,"Intersection traffic control","Convert minor-road stop control to all-way stop control",0.25,"Angle","All",310]
[null,null,null,null,null,0.82,"Rear-end","All",311]
[null,null,null,null,null,0.52,"All","All",315]
[null,null,null,"Intersection traffic control","Install a traffic signal",0.86,"All","Fatal, Serious Injury, Minor Injury",316]
[null,null,null,null,null,0.33,"Angle","Fatal, Serious Injury, Minor Injury",320]
[null,null,null,"Intersection traffic control","Remove unwarranted signal (one-lane, one-way streets, excluding major arterials)",0.76,"Angle, Left turn, Right turn","All",329]
[null,null,null,null,null,0.76,"All","All",332]
[null,null,null,"Intersection traffic control","Change from permitted or permitted-protected to protected",0.01,"Angle","All",333]
[null,null,null,null,null,0.99,"All","All",334]
[null,null,null,"Intersection traffic control","Permit right-turn-on-red",1.43,"Vehicle / pedestrian","All",369]
[null,null,null,"Intersection traffic control","Modify change plus clearance interval to ITE 1985 Proposed Recommended Practice",0.92,"All","All",380]
[null,null,null,null,null,1.1200000000000001,"Rear-end","All",381]
[null,null,null,"Intersection traffic control","Replace Night-Time Flash with Steady Operation",0.66,"Angle, Nighttime","All",388]
[null,null,null,null,null,0.65,"Nighttime","All",389]
[null,null,null,"Intersection traffic control","Prohibit left-turns with \"No Left Turn\" sign",0.36,"Left turn","All",390]
[null,null,null,null,null,0.32,"All","All",391]
[null,null,null,"On-street parking","Prohibit on-street parking",0.57999999999999996,"All","All",155]
[null,null,null,"On-street parking","Implement time-limited parking restrictions",0.89,"All","All",161]
[null,null,null,"On-street parking","Convert angle parking to parallel parking",0.65,"All","All",163]
[null,null,null,"On-street parking","Prohibit on-street parking",0.78,"All","Fatal, Serious Injury, Minor Injury",4574]
[null,null,null,null,null,0.72,"All","Property Damage Only (PDO)",4575]
[null,null,null,"Pedestrians","Raised median with marked crosswalk (uncontrolled)",0.54,"Vehicle / pedestrian","All",175]
[null,null,null,"Pedestrians","Installation of a High intensity Activated crossWalK (HAWK) pedestrian-activated beacon at an intersection",0.71,"All","All",2911]
[null,null,null,"Pedestrians","Install crosswalk on one minor approach",0.35,"All","All",3019]
[null,null,null,"Roadside","Flatten sideslope from 1V:3H to 1V:4H",0.57999999999999996,"All","Serious Injury, Minor Injury",26]
[null,null,null,"Roadside","Increase distance to roadside features from 3.3 ft to 16.7 ft",0.78,"All","All",35]
[null,null,null,"Roadside","New guardrail along embankment",0.93,"Run off road","All",39]
[null,null,null,"Roadway","Decrease lane width from 11 ft to 10 ft",1.0900000000000001,"All","All",2]
[null,null,null,"Roadway","Increase lane width from 11 ft to 12 ft",0.95,"All","All",3]
[null,null,null,"Roadway","Install centerline rumble strips",0.86,"All","All",124]
[null,null,null,"Roadway","Road diet (Convert 4-lane undivided road to 2-lanes plus turning lane)",0.71,"All","All",199]
[null,null,null,"Roadway","Introduce TWLTL (two-way left turn lanes) on rural two lane roads",0.64,"All","All",583]
[null,null,null,"Roadway","Convert 12 ft lanes and 6 ft shoulders to 10 ft lanes and 3 ft shoulders",1.1299999999999999,"Run off road","All",2002]
[null,null,null,"Roadway","Install transverse rumble strips on stop controlled approaches in rural areas (minor arterial)",1.22,"All","All",2698]
[null,null,null,"Roadway","Install edgeline rumble strips",0.71,"Run off road","Fatal, Serious Injury, Minor Injury",3388]
[null,null,null,"Shoulder treatments","Widen paved shoulder from 3 ft to 4 ft",0.97,"All","All",10]
[null,null,null,"Shoulder treatments","Pave a 3 to 4 ft sod shoulder",0.81,"All","All",18]
[null,null,null,"Shoulder treatments","Install curb and gutter",0.89,"All","All",2375]
[null,null,null,"Shoulder treatments","Installation of safety edge treatment",0.92,"All","All",4303]
[null,null,null,"Signs","Install signs to conform to MUTCD",0.85,"All","Serious Injury, Minor Injury",62]
[null,null,null,null,null,0.93,"All","Property Damage Only (PDO)",63]
[null,null,null,"Signs","Install combination horizontal alignment/ advisory speed signs",0.87,"All","Serious Injury, Minor Injury",73]
[null,null,null,null,null,0.71,"All","Property Damage Only (PDO)",74]
[null,null,null,"Signs","Install chevron signs and curve warning signs",0.59,"All","All",1905]
[null,null,null,null,null,0.66,"Nighttime","All",1906]
[null,null,null,"Speed management","Apply converging chevron pattern markings on roadway segments",0.68,"All","All",112]
[null,null,null,"Speed management","Traffic calming",0.68,"All","All",128]
[null,null,null,"Speed management","Install speed humps",0.6,"All","Serious Injury, Minor Injury",132]
[null,null,null,"Speed management","Install transverse rumble strips as traffic calming device",0.66,"All","All",138]
[null,null,null,"Speed management","5% reduction in mean speed",0.83,"All","Fatal",141]
[null,null,null,"Speed management","Area-wide or corridor-specific traffic calming",0.89,"All","Serious Injury, Minor Injury",586]
[]
[null,null,null,"Source: ","Missouri Department of Transportation S-HAL",null,"http://epg.modot.org/files/3/35/907.5_SHAL.pdf"]

{"sheet":"Lifespan-Safety Countermeasures","index":3,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[66,7,69,7],[1,1,1,11],[3,1,3,11],[4,5,4,6],[4,7,4,9],[6,3,6,5],[6,7,6,9]]}
[]
[null,"11.16.18                       Lifespan of Safety Countermeasures                                                                                                 "]
[]
[null,"This page is for informational reasons only.  "]
[]
[]
[null,null,null,"INTERSECTION",null,null,null,"NON-INTERSECTION"]
[null,null,null,"Safety Countermeasure",null,"Lifespan",null,"Safety Countermeasure",null,"Lifespan"]
[null,null,null,1,"General",null,null,6,"Pavement Treatments"]
[null,null,null,null,"AA – Improvement",15,null,null,"FA – Widen/Resurface",15]
[null,null,null,null,"AB – Realignment",15,null,null,"FB – Widening",15]
[null,null,null,null,"AC – Reconstruction",15,null,null,"FC – Resurfacing",10]
[null,null,null,2,"Pavement",null,null,null,"FD – Skid Proofing",5]
[null,null,null,null,"BA – Widen/Resurface",15,null,null,"FE – Grooving",7]
[null,null,null,null,"BB – Widening",15,null,null,"FF – Rumble Stripping",3]
[null,null,null,null,"BC – Resurfacing",10,null,null,"FG – Seal Coating",3]
[null,null,null,null,"BD – Skid Proofing",5,null,7,"Pavement Marking"]
[null,null,null,null,"BE – Grooving",7,null,null,"GA – General Pavement Marking",1]
[null,null,null,null,"BF – Rumble Stripping",3,null,null,"GB – Center Line",1]
[null,null,null,null,"BG – Seal Coating",3,null,null,"GC – Edge Line",1]
[null,null,null,3,"Channelization",null,null,null,"GD – Raised Reflector",4]
[null,null,null,null,"CA – Raised Curb Median",15,null,null,"GE – No-Pass Stripping",1]
[null,null,null,null,"CB – Raised Reflector Median",7,null,null,"GF – Thermo-Plastic Tape",3]
[null,null,null,null,"CC – Rumble Strip Median",10,null,null,"GG – Paint",1]
[null,null,null,null,"CD – Thermo-Plastic Tape",3,null,8,"Railroad Crossing"]
[null,null,null,null,"CE – Paint",2,null,null,"HA – Modification",15]
[null,null,null,null,"CF – Lane Transition",15,null,null,"HB –Gates",15]
[null,null,null,null,"CG – Lane Addition",15,null,null,"HC – Crossbucks",15]
[null,null,null,null,"CH – Left turn Lane/Throat Widening",15,null,null,"HD – Flashing Lights",15]
[null,null,null,null,"CI – Right Turn Lane",15,null,null,"HE – Flashing Beacons",15]
[null,null,null,null,"CJ – Left Turn Lane",15,null,null,"JH – Warning Bells",15]
[null,null,null,null,"CK – Bi-Directional Turn Lane",15,null,null,"HG – Pavement Markings",2]
[null,null,null,null,"CL – Left Turn Acceleration",15,null,null,"HH – Warning Signs-Standard",2]
[null,null,null,null,"CM – Right Turn Acceleration Lane",15,null,null,"HI – Warning Signs-Special",5]
[null,null,null,null,"CN – Deceleration Lane",15,null,null,"HJ – Delineators",4]
[null,null,null,null,"CO – One-Way Couple",15,null,null,"HK – Safety Lighting",15]
[null,null,null,4,"Signing",null,null,null,"HL – Resurfacing",10]
[null,null,null,null,"DA – Modernization",6,null,null,"HM – Grade Separation",20]
[null,null,null,null,"DB – Installation",6,null,null,"HN – Removal",20]
[null,null,null,null,"DC – Speed",6,null,9,"Bridge"]
[null,null,null,null,"DD – Advanced Warning",6,null,null,"IA – General Repair",10]
[null,null,null,null,"DE – Street Name",6,null,null,"IB – Widen/Resurface",15]
[null,null,null,null,"DF – Four-Way Stop",5,null,null,"IC – Widening",15]
[null,null,null,null,"DG – Minor Leg Stop",5,null,null,"ID – Resurfacing",10]
[null,null,null,null,"DH – Yield",5,null,null,"IE – Skid Proofing",5]
[null,null,null,null,"DI – Changeable Message",6,null,null,"IF – Grooving",7]
[null,null,null,null,"DJ – No-Turn-On-Red",4,null,null,"IG – Frost/Ice Detectors –Sign",10]
[null,null,null,null,"DK – Delineators",4,null,null,"IH – Frost/Ice Detectors-Radio",10]
[null,null,null,null,"DL – Flexible Post",4,null,null,"II – Guardrail",10]
[null,null,null,null,"DM – Overhead Truss",15,null,null,"IJ – Pedestrian Handrail",15]
[null,null,null,null,"DH – Yield",5,null,null,"IK – Safety Lighting",15]
[null,null,null,null,"DI – Changeable Message",6,null,null,"IL – Delineators",4]
[null,null,null,null,"DJ – No-Turn-On-Red",4,null,null,"IM – Impact Attenuators",3]
[null,null,null,null,"DK – Delineators",4,null,null,"IN – Reconstruction",20]
[null,null,null,null,"DL – Flexible Post",4,null,null,"IO – Removal",20]
[null,null,null,null,"DM – Overhead Truss",15,null,10,"Curve"]
[null,null,null,5,"Signalization",null,null,null,"JA – Realignment",15]
[null,null,null,null,"EA – Modernization",10,null,null,"JB – Reconstruction",15]
[null,null,null,null,"EB – Installation",15,null,null,"JC – Superelevation",15]
[null,null,null,null,"EC – Relocation",15,null,null,"JD – Daylighting",15]
[null,null,null,null,"ED – Warning Flasher",10,null,null,"JE – Widen/Resurface",15]
[null,null,null,null,"EF – Red Flashing Beacon",10,null,null,"JF – Widening",15]
[null,null,null,null,"EG – Left Turn with Lane",10,null,null,"JG – Resurfacing",10]
[null,null,null,null,"EH – Left Turn without Lane",15,null,null,"JH – Skid Proofing",5]
[null,null,null,null,"EI – Phase Adjustment",10,null,null,"JI – Grooving",7]
[null,null,null,null,"EJ – Twelve Inch Lens",10,null,null,"JJ – Guardrail",10]
[null,null,null,null,"EK – Traffic Actuated",10,null,null,"JK – Advance Warning Sign",5]
[null,null,null,null,"EL – Time Lane Control",10,null,null,"JL – Warning Flasher",10]
[null,null,null,null,"EM – Optical Programmed",10,null,null,"JM – Delineators",4]
[null,null,null,null,"EN – Pedestrian Control",10,null,null,"JN – Relocation",15]
[null,null,null,null,"EO – Mast Arming",15,null,11,"Roadside Safety"]
[null,null,null,null,"EP – Safety Lighting",15,null,null,"KA – General Obstacle Removal",20]
[null,null,null,null,null,null,null,null,"KB – Fixed Object Removal",20]
[null,null,null,null,null,null,null,null,"KC – Fringe Parking Removal",20]
[null,null,null,null,null,null,null,null,"KD – Bike Path Removal",20]
[null,null,null,null,null,null,null,null,"KE – Guardrail Installation",10]
[null,null,null,null,null,null,null,null,"KF – Utility Adjustment",15]
[null,null,null,null,null,null,null,null,"KG – Drainage Improvement",10]
[null,null,null,null,null,null,null,null,"KH – Shoulder Repair",5]
[null,null,null,null,null,null,null,null,"KI – Slope Stabilization",10]
[null,null,null,null,null,null,null,null,"KJ – Impact Attenuators",3]
[null,null,null,null,null,null,null,null,"KK – Glare Shields",10]
[null,null,null,null,null,null,null,null,"KL – Fencing",10]
[null,null,null,null,null,null,null,null,"KM – Access Control",20]
[null,null,null,null,null,null,null,12,"Other"]
[null,null,null,null,null,null,null,null,"OA – Turnabout",15]
[null,null,null,null,null,null,null,null,"OB – Ramp Improvement",15]
[null,null,null,null,null,null,null,null,"OC – Right of Way",20]
[null,null,"Source:",null," IDOT Safety and Engineering Policy Memorandum"]

{"sheet":"Developer Sheet","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,6]]}
["This is the developer sheet. DO NOT make any changes on this page."]
["Calculations",null,null,null,"Average Comprehensive Cost by Injury Severity MODOT's 2014 updated numbers","2014 Costs"]
["Crash Rate",null,null,null,"Fatal (K)",10207160.5]
["Fatality & Serious Injury Crash Rate",null,null,null,"Serious Injury (A)",1113876.6399999999]
["Benefit/Cost Ratio",null,null,null,"Minor Injury (B,C)",205879]
[null,null,null,null,"Property Damage Only (O)",8607.23]
["Interest Rate"]
[0.03]
[]
["Project Site","Traffic"]
["Segment","Project Average Daily Traffic"]
["Intersection","Entering AADT"]
[null,null,null,null,"http://www.buyupside.com/calculators/annuityordinarypresentvalue.htm"]
[]
[]
["Accident Type"]
["Fatality"]
["Serious Injury"]
["Minor Injury"]
["Property Damage Only"]
[]
[]
[]
["Time in years"]
[0.5]
[1]
[1.5]
[2]
[2.5]
[3]
[3.5]
[4]
[4.5]
[5]