{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1-Project Desc","2-Crashes","3-ROR Worksheet","4-RSI Calculations Worksheet","5-Scoring Worksheet","CRF Table_Rev","Scoring Table","RefTables"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":40,"comments":1,"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":"1-Project Desc","index":0,"n_rows":95,"n_cols":13,"rows_kept":95,"cut":false,"hidden":false,"merged":[[41,2,41,5],[32,0,32,4],[33,0,33,4],[86,2,86,3],[80,1,80,4],[81,1,81,4],[82,1,82,4],[83,1,83,4],[70,0,78,5],[59,0,67,5],[40,0,40,1],[41,0,41,1],[40,2,40,5],[39,0,39,5]]}
[]
["HSIP FUNDING APPLICATION"]
[]
[null,{"$f":"IF(B10=\"\",\"\",CONCATENATE(B10,\" - \",'3-ROR Worksheet'!K4)&IF('3-ROR Worksheet'!K5=\"\",CONCATENATE(\"; \",'3-ROR Worksheet'!S4,\" to \",'3-ROR Worksheet'!X4),CONCATENATE(\" at \",'3-ROR Worksheet'!K5)))","v":""}]
["Page 1"]
[]
["DATE"]
[null,null,null,null,null,null,null,null,null,"Adams County",null,"Local Let"]
["Project Information:",null,null,null,null,null,null,null,null,"Allen County",null,"ODOT Let"]
["COUNTY",null,null,null,null,null,null,null,null,"Ashland County"]
[null,null,null,null,null,null,null,null,null,"Ashtabula County"]
["LOCATION TYPE",null,null,null,null,null,null,null,null,"Athens County"]
["PROJECT SERVICE LIFE",null,"years",null,null,null,null,null,null,"Auglaize County"]
[null,null,null,null,null,null,null,null,null,"Belmont County"]
["SEGMENT INFORMATION",null,null,null,null,null,null,null,null,"Brown County"]
["ROUTE",null,null,null,null,null,null,null,null,"Butler County"]
["BEGIN SLM",null,null,null,null,null,null,null,null,"Carroll County"]
["END SLM",null,null,null,null,null,null,null,null,"Champaign County"]
["PRESENT YEAR ADT",null,null,null,null,null,null,null,null,"Clark County"]
["FUTURE YEAR ADT",null,null,null,null,null,null,null,null,"Clermont County"]
[null,null,null,null,null,null,null,null,null,"Clinton County"]
[null,null,null,null,null,null,null,null,null,"Columbiana County"]
[null,null,null,null,null,null,null,null,null,"Coshocton County"]
[null,null,null,null,null,null,null,null,null,"Crawford County"]
[null,null,null,null,null,null,null,null,null,"Cuyahoga County"]
[null,null,null,null,null,null,null,null,null,"Darke County"]
["INTERSECTION INFORMATION",null,null,null,null,null,null,null,null,"Defiance County"]
[null,"Major Road - Leg 1","Major Road - Leg 2","Cross Road - Leg 3","Cross Road - Leg 4","Cross Road - Leg 5",null,null,null,"Delaware County"]
["ROUTE NUMBER (or NAME)",null,null,null,null,null,null,null,null,"Erie County"]
["SLM",null,null,null,null,null,null,null,null,"Fairfield County"]
["PRESENT YEAR ADT",null,null,null,null,null,null,null,null,"Fayette County"]
["FUTURE YEAR ADT",null,null,null,null,null,null,null,null,"Franklin County"]
["*When analyzing an intersection, an ADT must be provided for each Cross Street Leg.\n",null,null,null,null,null,null,null,null,"Fulton County"]
[null,null,null,null,null,null,null,null,null,"Gallia County"]
["CRASH INFORMATION",null,null,null,null,null,null,null,null,"Geauga County"]
["Fatal Crashes","Injury Crashes","PDO Crashes","Total Crashes","Fatalities","Incapacitating Injuries",null,null,null,"Greene County"]
[{"$f":"COUNTIF('2-Crashes'!$O$21:$O$65000,'1-Project Desc'!$M$37)","v":0},{"$f":"COUNTIF('2-Crashes'!$O$21:$O$65000,'1-Project Desc'!$M$38)","v":0},{"$f":"COUNTIF('2-Crashes'!$O$21:$O$65000,'1-Project Desc'!$M$39)","v":0},{"$f":"SUM(A37:C37)","v":0},{"$f":"SUM('2-Crashes'!AS21:AS65000)","v":0},{"$f":"SUM('2-Crashes'!AT21:AT65000)","v":0},null,null,null,"Guernsey County",null,null,"Fatal Crash"]
["*Blue cells will be filled out automatically if you use the CAMTool layout on the Crashes Worksheet",null,null,null,null,null,null,null,null,"Hamilton County",null,null,"Injury Crash"]
[null,null,null,null,null,null,null,null,null,"Hancock County",null,null,"Property Damage Crash"]
["Ohio Strategic Highway Safety Plan",null,null,null,null,null,null,null,null,"Hardin County"]
["Emphasis Area",null,null,null,null,null,null,null,null,"Harrison County"]
["Emphasis Area Subcategory",null,null,null,null,null,null,null,null,"Henry County"]
[null,null,null,null,null,null,null,null,null,"Highland County"]
["Page 2",null,null,null,null,null,null,null,null,"Hocking County"]
[null,null,null,null,null,null,null,null,null,"Holmes County"]
["Project Administration: (Select One)",null,null,null,null,null,null,null,null,"Huron County"]
["LETTING TYPE",null,null,null,null,null,null,null,null,"Jackson County"]
[null,null,null,null,null,null,null,null,null,"Jefferson County"]
["Funding:*",null,null,null,null,null,null,null,null,"Knox County"]
["FISCAL YEAR REQUESTED",null,null,null,null,null,null,null,null,"Lake County"]
["Design Cost",{"$f":"B53*0.1","v":0},null,null,null,null,null,null,null,"Lawrence County"]
["Right-of-Way Cost",null,null,null,null,null,null,null,null,"Licking County"]
["Construction Cost",null,null,null,null,null,null,null,null,"Logan County"]
["TOTAL COST ESTIMATE",{"$f":"SUM(B51:B53)","v":0},null,"HSIP COST ESTIMATE",{"$f":"B53*0.8","v":0},null,null,null,null,"Lorain County"]
["*1. Submit cost estimate in current year dollars and 10% CE funding for projects under $1 millions or 7% CE funding for projects $1 millions or more.",null,null,null,null,null,null,null,null,"Lucas County"]
["*2. Requested year and Estimated Costs may differ from the actual approved by the CSTP/LBR Committee",null,null,null,null,null,null,null,null,"Madison County"]
["*3. HSIP funds are for construction phase only.  Therefore, the HSIP Cost Estimate is base on 80% of the construction cost dollar amount",null,null,null,null,null,null,null,null,"Mahoning County"]
[null,null,null,null,null,null,null,null,null,"Marion County"]
["Describe Existing Roadway Conditions and Existing Crash Problem(s) at Project Location",null,null,null,null,null,null,null,null,"Medina County"]
[null,null,null,null,null,null,null,null,null,"Meigs County"]
[null,null,null,null,null,null,null,null,null,"Mercer County"]
[null,null,null,null,null,null,null,null,null,"Miami County"]
[null,null,null,null,null,null,null,null,null,"Monroe County"]
[null,null,null,null,null,null,null,null,null,"Montgomery County"]
[null,null,null,null,null,null,null,null,null,"Morgan County"]
[null,null,null,null,null,null,null,null,null,"Morrow County"]
[null,null,null,null,null,null,null,null,null,"Muskingum County"]
[null,null,null,null,null,null,null,null,null,"Noble County"]
[null,null,null,null,null,null,null,null,null,"Ottawa County"]
["Describe Proposed Countermeasures to Address the Crash Pattern ",null,null,null,null,null,null,null,null,"Paulding County"]
[null,null,null,null,null,null,null,null,null,"Perry County"]
[null,null,null,null,null,null,null,null,null,"Pickaway County"]
[null,null,null,null,null,null,null,null,null,"Pike County"]
[null,null,null,null,null,null,null,null,null,"Portage County"]
[null,null,null,null,null,null,null,null,null,"Preble County"]
[null,null,null,null,null,null,null,null,null,"Putnam County"]
[null,null,null,null,null,null,null,null,null,"Richland County"]
[null,null,null,null,null,null,null,null,null,"Ross County"]
[null,null,null,null,null,null,null,null,null,"Sandusky County"]
[null,null,null,null,null,null,null,null,null,"Scioto County"]
["Countermeasure 1",null,null,null,null,null,null,null,null,"Seneca County"]
["Countermeasure 2",null,null,null,null,null,null,null,null,"Shelby County"]
["Countermeasure 3",null,null,null,null,null,null,null,null,"Stark County"]
["Countermeasure 4",null,null,null,null,null,null,null,null,"Summit County"]
[null,null,null,null,null,null,null,null,null,"Trumbull County"]
[null,null,null,null,null,null,null,null,null,"Tuscarawas County"]
["NAME OF PERSON COMPLETING APPLICATION",null,null,null,null,null,null,null,null,"Union County"]
[null,null,null,null,null,null,null,null,null,"Van Wert County"]
[null,null,null,null,null,null,null,null,null,"Vinton County"]
[null,null,null,null,null,null,null,null,null,"Warren County"]
[null,null,null,null,null,null,null,null,null,"Washington County"]
[null,null,null,null,null,null,null,null,null,"Wayne County"]
[null,null,null,null,null,null,null,null,null,"Williams County"]
[null,null,null,null,null,null,null,null,null,"Wood County"]
[null,null,null,null,null,null,null,null,null,"Wyandot County"]

{"sheet":"2-Crashes","index":1,"n_rows":20,"n_cols":94,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,91,18,92],[18,75,18,76],[18,77,18,78],[18,79,18,80],[18,81,18,82],[18,83,18,84],[18,85,18,86],[17,61,17,66],[17,67,17,72],[17,73,17,92],[18,61,18,62],[18,63,18,64],[18,65,18,66],[18,67,18,68],[18,69,18,70],[18,71,18,72],[18,73,18,74],[18,87,18,88],[18,89,18,90]]}
["County: ",{"$f":"'3-ROR Worksheet'!$C$4","v":0},"Main Roadway: ",{"$f":"'3-ROR Worksheet'!$K$4","v":0},"Begin SLM:",{"$f":"'3-ROR Worksheet'!$S$4","v":0},"End SLM: ",{"$f":"'3-ROR Worksheet'!$X$4","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BK1=\"\",\"\",HYPERLINK(BK1,\"Crash Report\"))","v":""},{"$f":"IF(BL1=\"\",\"\",HYPERLINK(BL1,\"Crash Report\"))","v":""}]
[null,null,"Intersecting Roadway: ",{"$f":"'3-ROR Worksheet'!$K$5","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
["Prepared by : ",{"$f":"'3-ROR Worksheet'!$C$6","v":""},"Date:",{"$f":"IF('1-Project Desc'!B7<>0,'1-Project Desc'!B7,\"\")","v":""},"Crash Bdate:",{"$f":"'3-ROR Worksheet'!$S$6","v":"00:00:00"},"Crash Edate: ",{"$f":"'3-ROR Worksheet'!$X$6","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO","YES","NO","YES","NO","YES","NO","YES","NO","YES","NO","YES","NO","YES","NO","YES","NO","YES","NO","YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rear End","Rear End","Left Turn","Left Turn","Right Turn","Right Turn","Angle","Angle","Head on","Head On","Sideswipe - Passing","Sideswipe - Passing","Fixed Object","Fixed Object","RAN OFF RD","RAN OFF RD","Pedestrian","Pedestrian","Other","Other"]
[{"$f":"IF(AQ17=\"\",\"\",HYPERLINK(AQ17,\"Crash Report\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BD17=\"\",\"\",IF(OR(O17=\"INJURY CRASH\",O17=\"FATAL CRASH\"),\"YES\",\"NO\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(OR(Q17=\"ROAD - SNOW\",Q17=\"ROAD - ICE\"),\"YES\",\"NO\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(OR(L17=\"DAWN\",L17=\"DUSK\"),\"YES\",\"NO\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(OR(L17=\"DARK - NO LIGHTS\",L17=\"DARK - LIGHTED\"),\"YES\",\"NO\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",L17=\"DAYLIGHT\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"YES\",L17=\"DAYLIGHT\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",BH17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2012,BF17=\"YES\",BH17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",BI17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"YES\",BI17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",Q17=\"ROAD - DRY\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"YES\",Q17=\"ROAD - DRY\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",Q17=\"ROAD - WET\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(,BF17=\"YES\",Q17=\"ROAD - WET\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",BG17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(,BF17=\"YES\",BG17=\"YES\"),$BD17,\"\"))","v":""},{"$f":"IF($BD17=\"\",\"\",IF(AND($BF17=BV$15,$M17=BV$16),$BD17,\"\"))","v":""},{"$f":"IF($BD17=\"\",\"\",IF(AND($BF17=BW$15,$M17=BW$16),$BD17,\"\"))","v":""},"","","","","","","","","","","","","","","","",{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"NO\",CP17=\"1\"),BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BF17=\"YES\",CP17=\"1\"),BD17,\"\"))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(COUNT(BV17:CM17)>=1,\"\",\"1\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIME OF DAY",null,null,null,null,null,"ROADWAY CONDITION",null,null,null,null,null,"CRASH TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DAY",null,"DAWN/DUSK",null,"DARK",null,"DRY",null,"WET",null,"SNOW / ICE",null,"REAR END",null,"LEFT",null,"RIGHT",null,"ANGLE",null,"HEAD ON",null,"SS PASS",null,"FIXED OBJ",null,"RAN OFF RD",null,"PEDESTRIAN",null,"OTHER"]
["HYPERLINK","ACCIDENTS_POINTS_NBR","LOCAL_REPORT_NBR","NLF ID","LOGPOINT_SLM_NBR","CRASH_DT","STREET1","STREET2_REFERENCE","DISTANCE_OFFSET","DAY_OF_WEEK_TXT","HOUR_OF_DAY","LIGHT_CONDITION_TXT","TYPE_OF_CRASH_TXT","NUMBER_OF_VEHICLES","CRASH_SEVERITY_TXT","WEATHER_CONDITION_TXT","ROAD_CONDITION_TXT","LOCATION_TXT","CONTRIBUTING_FACTOR1_TXT","ACTION1_TXT","OBJECT_STRUCK1_TXT","VEHICLE_TYPE1_TXT","DIRECTION_FROM1_TXT","DIRECTION_TO1_TXT","DRIVER_AGE1","DRIVER_GENDER1_TXT","TRAFFIC_CONTROL1_TXT","DRIVER_ALCOHOL1_TXT","DRIVER_DRUGS1_TXT","ESTIMATED_SPEED1_TXT","POSTED_SPEED1_TXT","CONTRIBUTING_FACTOR2_TXT","ACTION2_TXT","VEHICLE_TYPE2_TXT","DRIVER_AGE2","DRIVER_GENDER2_TXT","DIRECTION_FROM2_TXT","DIRECTION_TO2_TXT","DRIVER_ALCOHOL2_TXT","DRIVER_DRUGS2_TXT","SPECIAL_AREA_TXT","ANIMAL_TYPE_TXT","Filename Nme","ROAD_CONTOUR_TXT","INJ_TYPE1_FATAL","INJ_TYPE2_SERIOUS_VISIBLE","INJ_TYPE3_MINOR_VISIBLE","INJ_TYPE4_NO_VISIBLE","DIRECTION_FROM_REF_TXT","DISTRICT_NBR","COUNTY_CD","City Village Twp Cd","City Village Twp Nme","Latitude Nbr","Longitude Nbr","TRAFFIC_CRASH_YEAR","CRASH_MONTH_NBR","INJ/FAT","SNOW/ICE","DAWN/DUSK","DARK","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","OTHER CRASH TYPE"]

{"sheet":"3-ROR Worksheet","index":2,"n_rows":89,"n_cols":78,"rows_kept":89,"cut":false,"hidden":false,"merged":[[8,15,8,16],[23,19,23,20],[31,19,31,20],[27,19,27,20],[21,12,21,13],[22,12,22,13],[23,12,23,13],[8,11,8,12],[25,1,25,11],[26,12,26,13],[22,19,22,20],[20,12,20,13],[20,0,20,11],[20,14,20,22],[8,13,8,14],[8,3,8,4],[28,19,28,20],[8,17,8,18],[26,19,26,20],[25,12,25,13],[24,19,24,20],[25,19,25,20],[24,12,24,13],[27,12,27,13],[32,28,32,30],[32,31,32,32],[31,28,31,30],[30,28,30,30],[29,21,29,22],[33,19,33,20],[29,31,29,32],[29,28,29,30],[32,21,32,22],[33,31,33,32],[0,0,0,32],[7,1,7,6],[7,7,7,12],[3,2,3,5],[5,2,5,5],[5,23,5,25],[7,13,7,32],[5,18,5,20],[3,10,3,15],[4,10,4,15],[5,7,5,9],[3,18,3,20],[3,23,3,25],[24,31,24,32],[26,21,26,22],[27,21,27,22],[32,19,32,20],[31,31,31,32],[30,21,30,22],[24,21,24,22],[8,33,8,34],[28,21,28,22],[22,21,22,22],[23,21,23,22],[25,21,25,22],[8,31,8,32],[26,31,26,32],[27,31,27,32],[8,25,8,26],[21,28,21,30],[22,28,22,30],[23,28,23,30],[24,28,24,30],[25,28,25,30],[26,28,26,30],[27,28,27,30],[23,31,23,32],[28,31,28,32],[22,31,22,32],[25,31,25,32],[28,28,28,30],[20,23,20,32],[46,24,46,26],[46,28,46,30],[39,26,39,27],[40,16,40,19],[40,23,40,24],[40,26,40,27],[43,28,43,30],[42,0,42,32],[39,20,39,21],[39,23,39,24],[31,21,31,22],[40,0,40,4],[39,16,39,19],[21,1,21,11],[22,1,22,11],[36,21,36,22],[28,12,28,13],[30,12,30,13],[29,12,29,13],[51,0,51,9],[51,10,51,12],[49,0,49,9],[43,21,43,22],[44,21,44,22],[46,21,46,22],[49,17,49,19],[50,17,50,19],[51,17,51,19],[43,14,43,19],[50,0,50,9],[50,21,50,24],[48,0,48,32],[44,24,44,26],[49,10,49,12],[50,10,50,12],[45,28,45,30],[44,28,44,30],[43,24,43,26],[7,33,7,34],[38,6,38,7],[8,29,8,30],[8,9,8,10],[8,7,8,8],[8,5,8,6],[8,27,8,28],[8,21,8,22],[30,19,30,20],[8,19,8,20],[23,1,23,11],[24,1,24,11],[30,31,30,32],[37,0,37,32],[38,0,38,4],[36,14,36,20],[36,23,36,30],[26,0,36,11],[35,12,35,13],[34,12,34,13],[36,31,36,32],[33,28,33,30],[8,23,8,24],[8,1,8,2],[32,12,32,13],[40,20,40,21],[39,0,39,4],[40,6,40,7],[39,6,39,7],[33,21,33,22],[29,19,29,20],[33,12,33,13],[31,12,31,13]]}
["RATE OF RETURN - ECONOMIC ANALYSIS WORKSHEET"]
[]
["Cells in Green Require User Review"]
["County",null,{"$f":"'1-Project Desc'!B10","v":0},null,null,null,"Main Roadway",null,null,null,{"$f":"IF('1-Project Desc'!B12=\"Section\",'1-Project Desc'!B16,'1-Project Desc'!B29)","v":0},null,null,null,null,null,"Begin SLM",null,{"$f":"IF('1-Project Desc'!B12=\"Section\",'1-Project Desc'!B17,'1-Project Desc'!B30)","v":0},null,null,"End SLM",null,{"$f":"IF('1-Project Desc'!B12=\"Section\",'1-Project Desc'!B18,\"\")","v":""}]
[null,null,null,null,null,null,"Intersecting Roadway",null,null,null,{"$f":"IF('1-Project Desc'!B12=\"Section\",\"\",IF('1-Project Desc'!D29<>0,'1-Project Desc'!D29,\"\")&IF('1-Project Desc'!E29<>0,IF('1-Project Desc'!E29='1-Project Desc'!D29,\"\",\" / \"&'1-Project Desc'!E29),\"\")&IF('1-Project Desc'!F29<>0,IF('1-Project Desc'!F29='1-Project Desc'!E29,\"\",\" / \"&'1-Project Desc'!F29),\"\"))","v":""}]
["Prepared by ",null,{"$f":"IF('1-Project Desc'!C87<>0,'1-Project Desc'!C87,\"\")","v":""},null,null,null,"Date",{"$f":"IF('1-Project Desc'!B7<>0,'1-Project Desc'!B7,\"\")","v":""},null,null,null,null,null,null,null,null,"Crash BDate",null,null,null,null,"Crash EDate"]
[]
["Year","TIME OF DAY",null,null,null,null,null,"ROADWAY CONDITION",null,null,null,null,null,"CRASH TYPE"]
[null,"DAY",null,"DAWN/DUSK",null,"DARK",null,"DRY",null,"WET",null,"SNOW / ICE",null,"REAR END",null,"LEFT",null,"RIGHT",null,"ANGLE",null,"HEAD ON",null,"SS PASS",null,"FIXED OBJ",null,"RAN OFF RD",null,"PEDESTRIAN",null,"OTHER",null,"TOTAL"]
[null,"PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F","PDO","I/F"]
[2018,{"$f":"COUNTIF('2-Crashes'!BJ$21:BJ$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BK$21:BK$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BL$21:BL$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BM$21:BM$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BN$21:BN$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BO$21:BO$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BP$21:BP$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BQ$21:BQ$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BR$21:BR$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BS$21:BS$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BT$21:BT$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BU$21:BU$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BV$21:BV$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BW$21:BW$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BX$21:BX$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BY$21:BY$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!BZ$21:BZ$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CA$21:CA$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CB$21:CB$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CC$21:CC$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CD$21:CD$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CE$21:CE$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CF$21:CF$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CG$21:CG$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CH$21:CH$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CI$21:CI$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CJ$21:CJ$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CK$21:CK$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CL$21:CL$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CM$21:CM$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CN$21:CN$65000,\"=\"&$A11)","v":0},{"$f":"COUNTIF('2-Crashes'!CO$21:CO$65000,\"=\"&$A11)","v":0},{"$f":"N11+P11+R11+T11+V11+X11+Z11+AB11+AD11+AF11","v":0},{"$f":"O11+Q11+S11+U11+W11+Y11+AA11+AC11+AE11+AG11","v":0}]
[{"$f":"A11+1","v":2019},{"$f":"COUNTIF('2-Crashes'!BJ$21:BJ$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BK$21:BK$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BL$21:BL$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BM$21:BM$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BN$21:BN$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BO$21:BO$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BP$21:BP$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BQ$21:BQ$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BR$21:BR$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BS$21:BS$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BT$21:BT$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BU$21:BU$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BV$21:BV$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BW$21:BW$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BX$21:BX$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BY$21:BY$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!BZ$21:BZ$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CA$21:CA$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CB$21:CB$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CC$21:CC$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CD$21:CD$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CE$21:CE$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CF$21:CF$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CG$21:CG$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CH$21:CH$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CI$21:CI$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CJ$21:CJ$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CK$21:CK$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CL$21:CL$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CM$21:CM$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CN$21:CN$65000,\"=\"&$A12)","v":0},{"$f":"COUNTIF('2-Crashes'!CO$21:CO$65000,\"=\"&$A12)","v":0},0,0]
[{"$f":"A12+1","v":2020},{"$f":"COUNTIF('2-Crashes'!BJ$21:BJ$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BK$21:BK$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BL$21:BL$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BM$21:BM$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BN$21:BN$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BO$21:BO$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BP$21:BP$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BQ$21:BQ$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BR$21:BR$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BS$21:BS$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BT$21:BT$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BU$21:BU$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BV$21:BV$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BW$21:BW$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BX$21:BX$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BY$21:BY$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!BZ$21:BZ$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CA$21:CA$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CB$21:CB$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CC$21:CC$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CD$21:CD$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CE$21:CE$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CF$21:CF$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CG$21:CG$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CH$21:CH$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CI$21:CI$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CJ$21:CJ$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CK$21:CK$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CL$21:CL$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CM$21:CM$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CN$21:CN$65000,\"=\"&$A13)","v":0},{"$f":"COUNTIF('2-Crashes'!CO$21:CO$65000,\"=\"&$A13)","v":0},0,0]
[{"$f":"A13+1","v":2021},{"$f":"COUNTIF('2-Crashes'!BJ$21:BJ$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BK$21:BK$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BL$21:BL$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BM$21:BM$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BN$21:BN$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BO$21:BO$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BP$21:BP$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BQ$21:BQ$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BR$21:BR$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BS$21:BS$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BT$21:BT$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BU$21:BU$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BV$21:BV$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BW$21:BW$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BX$21:BX$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BY$21:BY$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!BZ$21:BZ$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CA$21:CA$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CB$21:CB$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CC$21:CC$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CD$21:CD$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CE$21:CE$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CF$21:CF$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CG$21:CG$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CH$21:CH$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CI$21:CI$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CJ$21:CJ$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CK$21:CK$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CL$21:CL$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CM$21:CM$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CN$21:CN$65000,\"=\"&$A14)","v":0},{"$f":"COUNTIF('2-Crashes'!CO$21:CO$65000,\"=\"&$A14)","v":0},0,0]
[{"$f":"A14+1","v":2022},{"$f":"COUNTIF('2-Crashes'!BJ$21:BJ$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BK$21:BK$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BL$21:BL$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BM$21:BM$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BN$21:BN$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BO$21:BO$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BP$21:BP$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BQ$21:BQ$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BR$21:BR$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BS$21:BS$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BT$21:BT$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BU$21:BU$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BV$21:BV$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BW$21:BW$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BX$21:BX$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BY$21:BY$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!BZ$21:BZ$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CA$21:CA$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CB$21:CB$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CC$21:CC$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CD$21:CD$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CE$21:CE$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CF$21:CF$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CG$21:CG$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CH$21:CH$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CI$21:CI$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CJ$21:CJ$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CK$21:CK$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CL$21:CL$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CM$21:CM$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CN$21:CN$65000,\"=\"&$A15)","v":0},{"$f":"COUNTIF('2-Crashes'!CO$21:CO$65000,\"=\"&$A15)","v":0},0,0]
[]
[]
["TOTAL",{"$f":"SUM(B11:B15)","v":0},{"$f":"SUM(C11:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVG.",{"$f":"AVERAGE(B11:B15)","v":0},{"$f":"AVERAGE(C11:C15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["--The \"TOTAL\" and \"AVERAGE\" row formulas are set to only use 2016-2020 crash data.  If the crash data is not for these five years, the formulas must be modified by the user to calculate the associated year data."]
["RECOMMENDED IMPROVEMENTS",null,null,null,null,null,null,null,null,null,null,null,"CRASH TYPE",null,"PDO CRASHES",null,null,null,null,null,null,null,null,"INJ. - FAT.  CRASHES"]
[null,"Select Countermeasures",null,null,null,null,null,null,null,null,null,null,null,null,"R1","R2","R3","R4","RT","AVG PDO",null,"EST. RED. ",null,"R1","R2","R3","R4","RT","AVG INJ-FAT",null,null,"EST. RED. "]
["R1",{"$f":"IF('1-Project Desc'!B81:E81>0,'1-Project Desc'!B81:E81,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"P9","v":"LEFT"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"O23+(1-O23)*P23+(1-O23)*(1-P23)*Q23+(1-O23)*(1-P23)*(1-Q23)*R23","v":0},{"$f":"P19","v":0},null,{"$f":"S23*T23","v":0},null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M23,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"X23+(1-X23)*Y23+(1-X23)*(1-Y23)*Z23+(1-X23)*(1-Y23)*(1-Z23)*AA23","v":0},{"$f":"Q19","v":0},null,null,{"$f":"AB23*AC23","v":0}]
["R2",{"$f":"IF('1-Project Desc'!B82:E82>0,'1-Project Desc'!B82:E82,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"R9","v":"RIGHT"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"R19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M24,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"S19","v":0},null,null,0]
["R3",{"$f":"IF('1-Project Desc'!B83:E83>0,'1-Project Desc'!B83:E83,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"T9","v":"ANGLE"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"T19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M25,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"U19","v":0},null,null,0]
["R4",{"$f":"IF('1-Project Desc'!B84:E84>0,'1-Project Desc'!B84:E84,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"N9","v":"REAR END"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"N19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M26,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"O19","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V9","v":"HEAD ON"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"V19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M27,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"W19","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X9","v":"SS PASS"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"X19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M28,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"Y19","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z9","v":"FIXED OBJ"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"Z19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M29,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"AA19","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB9","v":"RAN OFF RD"},null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$D$5:$Q$60000,14,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$D$5:$Q$60000,14,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$D$5:$Q$60000,14,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$D$5:$Q$60000,14,FALSE),0))","v":0},0,{"$f":"AB19","v":0},null,0,null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$AA$5:$AD$60000,4,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$AA$5:$AD$60000,4,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$AA$5:$AD$60000,4,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,6,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$AA$5:$AD$60000,4,FALSE),0))","v":0},0,{"$f":"AC19","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF9","v":"OTHER"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"AF19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M31,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"AG19","v":0},null,null,0,null,null,null,null,null,"Do Not Modify Cells Below"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NIGHT",null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$D$5:$Q$60000,12,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$D$5:$Q$60000,12,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$D$5:$Q$60000,12,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$D$5:$Q$60000,12,FALSE),0))","v":0},0,{"$f":"F19","v":0},null,0,null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$AA$5:$AD$60000,2,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$AA$5:$AD$60000,2,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$AA$5:$AD$60000,2,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,5,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$AA$5:$AD$60000,2,FALSE),0))","v":0},0,{"$f":"G19","v":0},null,null,0,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J9","v":"WET"},null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$D$5:$Q$60000,13,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$D$5:$Q$60000,13,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$D$5:$Q$60000,13,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$D$5:$Q$60000,13,FALSE),0))","v":0},0,{"$f":"J19","v":0},null,0,null,{"$f":"IF($B$23=\"\",,IF(VLOOKUP($B$23,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$23,'CRF Table_Rev'!$AA$5:$AD$60000,3,FALSE),0))","v":0},{"$f":"IF($B$24=\"\",,IF(VLOOKUP($B$24,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$24,'CRF Table_Rev'!$AA$5:$AD$60000,3,FALSE),0))","v":0},{"$f":"IF($B$25=\"\",,IF(VLOOKUP($B$25,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$25,'CRF Table_Rev'!$AA$5:$AD$60000,3,FALSE),0))","v":0},{"$f":"IF($B$26=\"\",,IF(VLOOKUP($B$26,'CRF Table_Rev'!$D:$I,4,FALSE)=\"Yes\",VLOOKUP($B$26,'CRF Table_Rev'!$AA$5:$AD$60000,3,FALSE),0))","v":0},0,{"$f":"K19","v":0},null,null,0,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD9","v":"PEDESTRIAN"},null,{"$f":"IF($B$23=\"\",0,IF(OR($O$32>0,$O$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($P$32>0,$P$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Q$32>0,$Q$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($R$32>0,$R$33>0),,INDEX('CRF Table_Rev'!$D$5:$Z$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$D$5:$Z$5,0))))","v":0},0,{"$f":"AD19","v":0},null,0,null,{"$f":"IF($B$23=\"\",0,IF(OR($X$32>0,$X$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$23,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$24=\"\",0,IF(OR($Y$32>0,$Y$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$24,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$25=\"\",0,IF(OR($Z$32>0,$Z$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$25,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},{"$f":"IF($B$26=\"\",0,IF(OR($AA$32>0,$AA$33>0),,INDEX('CRF Table_Rev'!$AA$5:$AM$60000,MATCH($B$26,'CRF Table_Rev'!$D$5:$D$60000,0),MATCH($M34,'CRF Table_Rev'!$AA$5:$AM$5,0))))","v":0},0,{"$f":"AE19","v":0},null,null,0,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTIMATED PDO CRASH REDUCTION = ",null,null,null,null,null,null,{"$f":"SUM(V23:W34)","v":0},null,"ESTIMATED INJ. - FAT.   CRASH REDUCTION = ",null,null,null,null,null,null,null,{"$f":"SUM(AF23:AG34)","v":0},null,null,null,null,null,25]
["ADT Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
["Project Service Life",null,null,null,null,{"$f":"'1-Project Desc'!B13","v":0},"years"]
["Present ADT (PADT)",null,null,null,null,{"$f":"IF('1-Project Desc'!B12=\"Section\",'1-Project Desc'!B19,SUM('1-Project Desc'!B31:F31)/2)","v":0},"veh / day",null,null,null,null,null,null,"Average ADT = ",null,null,"(PADT + FADT)/2   =  (",null,null,null,{"$f":"F40","v":0},null,"+",{"$f":"F41","v":0},null,") =",{"$f":"(U40+X40)/2","v":0}]
["Future ADT (FADT)",null,null,null,null,{"$f":"IF('1-Project Desc'!B12=\"Section\",'1-Project Desc'!B20,SUM('1-Project Desc'!B32:F32)/2)","v":0},"veh / day",null,null,null,null,null,null,"ADT Factor =",null,null,"Average ADT / PADT =",null,null,null,{"$f":"AA40","v":0},null,"/",{"$f":"F40","v":0},null,"=",{"$f":"U41/X41","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,"NPV",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Years",{"$f":"NPV($Z$51,AN42:BG42,$K$52)-$K$50","v":{"$error":"#DIV/0!"}},{"$f":"-$K$50","v":0},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["Average Annual Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 Years",{"$f":"NPV($Z$51,AN43:BG43,$K$52)-$K$50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["Annual PDO Benefits = Estimated PDO Crash Reduction * Avg PDO Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Facility Type Below:",null,null,null,null,null,"=",{"$f":"V37","v":0},null,"*",{"$f":"IF(O45=\"Rural State Highways\",BX85,IF(O45=\"Counties and Unincorporated Villages\",BX86,BX87))","v":10560},null,null,"=",{"$f":"V44*Y44","v":0},null,null,null,null,null,null,null,"10 Years",{"$f":"NPV(Z51,AN44:AW44,K52)-K50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["Annual INJ.-FAT. Benefits = Estimated INJ.-FAT. Crash Reduction * Avg INJ.-FAT. Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,"Counties and Unincorporated Villages",null,null,null,null,null,"=",{"$f":"AF37","v":0},null,"*",{"$f":"IF(O45=\"Rural State Highways\",BY85,IF(O45=\"Counties and Unincorporated Villages\",BY86,BY87))","v":105839.67999999999},null,null,"=",{"$f":"V45*Y45","v":0},null,null,null,null,null,null,null,"15 Years",{"$f":"NPV(Z51,AN45:BB45,K52)-K50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["Total Benefits",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,"=",{"$f":"SUM(AC44:AE45)","v":0},null,null,null,null,null,null,null,"20 Years",{"$f":"NPV($Z$51,AN46:BG46,$K$52)-$K$50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["AverageAnnual Benefits = Total Benefits *  ADT Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"AA41","v":{"$error":"#DIV/0!"}},null,"*",{"$f":"AC46","v":0},null,null,"=",{"$f":"Y47*V47","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"25 Years",{"$f":"NPV(Z51,AN47:BL47,K52)-K50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 Years",{"$f":"NPV(Z51,AN48:BQ48,K52)-K50","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$f":"$AC$47-$K$51","v":{"$error":"#DIV/0!"}},{"$f":"$AC$47-$K$51+$K$52","v":{"$error":"#DIV/0!"}}]
["Rate of Return"]
["Total Safety Project Cost (Design, Right-of-Way, and Construction)",null,null,null,null,null,null,null,null,null,{"$f":"'1-Project Desc'!B54","v":0},null,null,null,"Design (PE)",null,null,{"$f":"'1-Project Desc'!B51","v":0}]
["Annual Maintenance and Energy Costs",null,null,null,null,null,null,null,null,null,0,null,null,null,"Right-of-Way",null,null,{"$f":"'1-Project Desc'!B52","v":0},null,null,null,"Rate of Return",null,null,null,{"$f":"IF(F39=20,IRR(AM46:BG46,-0.2),IF(F39=10,IRR(AM44:AW44,-0.2),IF(F39=15,IRR(AM45:BB45,-0.2),IF(F39=25,IRR(AM47:BL47,-0.2),IF(F39=30,IRR(AM48:BQ48,-0.2),IF(F39=5,IRR(AM43:AR43,-0.2),IF(F39=3,IRR(AM42:AP42,-0.2),0)))))))","v":0}]
["Salvage Value",null,null,null,null,null,null,null,null,null,0,null,null,null,"Construction",null,null,{"$f":"'1-Project Desc'!B53","v":0}]
["See Text Box Below for Additional Details on Project Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please note:  if the ROR value is displayed as #NUM! or #DIV/0!, the ROR is "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"either an extremely large positive or negative value and cannot be calculated "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"within a reasonable number of iterations."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of crashes for determing ROR (Updated - 6/22/2023)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDO ","FI","SYSTEM "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10560,105839.67999999999,"Rural State Highways"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10560,105839.67999999999,"Counties and Unincorporated Villages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10560,105839.67999999999,"Cities and Incorporated Villages"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\\\itcfs007\\odrive\\SAFETY\\CEN\\HSP - Highway Safety Program\\HSP 2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use \"2 Code\" in blue"]

{"sheet":"4-RSI Calculations Worksheet","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,1,10,5],[8,4,8,6]]}
[]
["HSIP FUNDING APPLICATION"]
["Page 4"]
[]
["County: ",{"$f":"'3-ROR Worksheet'!$C$4","v":0},"Main Roadway: ",{"$f":"'3-ROR Worksheet'!$K$4","v":0},"Begin SLM:",{"$f":"'3-ROR Worksheet'!$S$4","v":0},"End SLM: ",{"$f":"'3-ROR Worksheet'!$X$4","v":""}]
[null,null,"Intersecting Roadway: ",{"$f":"'3-ROR Worksheet'!$K$5","v":""}]
["Prepared by : ",{"$f":"'3-ROR Worksheet'!$C$6","v":""},"Date:",{"$f":"IF('1-Project Desc'!B7<>0,'1-Project Desc'!B7,\"\")","v":""},"Crash Bdate:",{"$f":"'3-ROR Worksheet'!$S$6","v":"00:00:00"},"Crash Edate: ",{"$f":"'3-ROR Worksheet'!$X$6","v":"00:00:00"}]
[]
[null,"RSI Value = ",{"$f":"IF(ISERROR(D33/(C33)),VALUE(0),D33/(C33))","v":0},null,"Cells in Green Require User Review"]
[]
[null,"Fill in the Number of Crashes by Crash Type"]
[null,"Crash Type","Number of Crashes","Crash Type Severity Calc","Crash Type #","Rural Non-Freeway*"]
[null,"Not Stated",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B13)","v":0},{"$f":"C13*F13","v":0},0,24994]
[null,"Head On",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B14)","v":0},0,1,119357]
[null,"Rear End",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B15)","v":0},0,2,39254]
[null,"Backing",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B16)","v":0},0,3,16393]
[null,"Sideswipe - Meeting",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B17)","v":0},0,4,57515]
[null,"Sideswipe - Passing",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B18)","v":0},0,5,38202]
[null,"Angle",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B19)","v":0},0,6,73653]
[null,"Parked Vehicle",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B20)","v":0},0,7,37042]
[null,"Pedestrian",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B21)","v":0},0,8,249162]
[null,"Animal",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B22)","v":0},0,9,15205]
[null,"Train",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B23)","v":0},0,10,81585]
[null,"Pedalcycles",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B24)","v":0},0,11,186509]
[null,"Other Non-Vehicle",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B25)","v":0},0,12,107226]
[null,"Fixed Object",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B26)","v":0},0,13,51712]
[null,"Other Object",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B27)","v":0},0,14,21125]
[null,"Falling From Or In Vehicle",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B28)","v":0},0,15,104377]
[null,"Overturning",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B29)","v":0},0,16,111577]
[null,"Other Non-Collision",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B30)","v":0},0,17,30523]
[null,"Left Turn",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B31)","v":0},{"$f":"C31*F31","v":0},18,48273]
[null,"Right Turn",{"$f":"COUNTIF('2-Crashes'!M$21:M$65008,B32)","v":0},{"$f":"C32*F32","v":0},18,32462]
[null,"Totals",{"$f":"SUM(C13:C32)","v":0},{"$f":"SUM(D13:D32)","v":0}]

{"sheet":"5-Scoring Worksheet","index":4,"n_rows":52,"n_cols":43,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,3,3,4],[4,3,4,4],[23,0,23,7],[10,2,10,3],[33,0,33,1],[25,0,25,1],[25,4,25,5],[25,2,25,3],[29,0,29,1],[29,2,29,3],[33,2,33,3],[38,18,38,21],[29,5,31,5],[29,6,31,6],[39,18,39,19],[39,20,39,21],[33,4,33,5]]}
[]
["HSIP FUNDING APPLICATION"]
["Page 5"]
["County: ",{"$f":"'3-ROR Worksheet'!$C$4","v":0},"Main Roadway: ",{"$f":"'3-ROR Worksheet'!$K$4","v":0},null,"Begin SLM:",{"$f":"'3-ROR Worksheet'!$S$4","v":0},"End SLM: ",{"$f":"'3-ROR Worksheet'!$X$4","v":""}]
[null,null,"Intersecting Roadway: ",{"$f":"IF('3-ROR Worksheet'!$K$5=0,\"\",'3-ROR Worksheet'!$K$5)","v":""}]
["Prepared by : ",{"$f":"'3-ROR Worksheet'!$C$6","v":""},"Date:",{"$f":"IF('1-Project Desc'!B7<>0,'1-Project Desc'!B7,\"\")","v":""},null,"Crash Bdate:",{"$f":"'3-ROR Worksheet'!$S$6","v":"00:00:00"},"Crash Edate: ",{"$f":"'3-ROR Worksheet'!$X$6","v":"00:00:00"}]
[]
[]
[]
[]
[null,{"$f":"IF('1-Project Desc'!B12=0,\"\",'1-Project Desc'!B12)","v":""},"Rural Non-Freeway"]
["Location","Location Type","Facility Type","Begin Log","End Log","Length","ADT Used for Calculations"]
[{"$f":"'3-ROR Worksheet'!K4&IF('3-ROR Worksheet'!K5=\"\",,\" at \"&'3-ROR Worksheet'!K5)","v":"0"},{"$f":"IF(B11=0,\"\",B11)","v":""},{"$f":"IF(C11=0,\"\",C11)","v":"Rural Non-Freeway"},{"$f":"'3-ROR Worksheet'!S4","v":0},{"$f":"'3-ROR Worksheet'!X4","v":""},{"$f":"IF(B13=\"Section\",E13-D13,1)","v":1},{"$f":"'3-ROR Worksheet'!F40","v":0}]
[]
["Fatal Crashes","Injury Crashes","PDO Crashes","Total Crashes","Fatalities","Incapacitating Injuries","# of Years"]
[{"$f":"'1-Project Desc'!A37","v":0},{"$f":"'1-Project Desc'!B37","v":0},{"$f":"'1-Project Desc'!C37","v":0},{"$f":"'1-Project Desc'!D37","v":0},{"$f":"'1-Project Desc'!E37","v":0},{"$f":"'1-Project Desc'!F37","v":0},{"$f":"YEAR('3-ROR Worksheet'!X6)-YEAR('3-ROR Worksheet'!S6)+1","v":1}]
[]
[null,null,"Rate of Return:  ",{"$f":"IF(ISERROR('3-ROR Worksheet'!Z51),VALUE(0),'3-ROR Worksheet'!Z51)","v":0}]
[]
[]
[]
[]
[]
["Safety Project Scoring"]
[]
["Crash Rate (20)",null,"Rate of Return (20)",null,"RSI (20)"]
["Value","Score","Value","Score","Value","Score"]
[{"$f":"IFERROR(IF('1-Project Desc'!B12=\"Intersection\",(D16*1000000)/(G16*365*G13),(D16*1000000)/(G16*365*IF(F13<0.4,1,F13)*G13)),0)","v":0},{"$f":"IF(B13=\"Section\",IF(ISERROR(VLOOKUP(A28,$U$42:$V$52,2,TRUE)),VALUE(0),(VLOOKUP(A28,$U$42:$V$52,2,TRUE))),IF(ISERROR(VLOOKUP(A28,$S$42:$T$52,2,TRUE)),VALUE(0),(VLOOKUP(A28,$S$42:$T$52,2,TRUE))))","v":0},{"$f":"IF(ISERROR(D18),VALUE(0),D18)","v":0},{"$f":"IF(ISERROR(VLOOKUP(C28,$AA$42:$AB$57,2,TRUE)),VALUE(0),VLOOKUP(C28,$AA$42:$AB$57,2,TRUE))","v":0},{"$f":"IF(ISERROR('4-RSI Calculations Worksheet'!C9),VALUE(0),'4-RSI Calculations Worksheet'!C9)","v":0},{"$f":"IF(ISERROR(VLOOKUP(E28,$W$42:$X$57,2,TRUE)),VALUE(0),VLOOKUP(E28,$W$42:$X$57,2,TRUE))","v":0}]
[]
["EPDO Value (20)",null,"Funding Request (20)",null,null,"Total Score",{"$f":"B28+D28+F28+D32+B32","v":0}]
["Value","Score","Value","Score"]
[{"$f":"IF(ISERROR((AI42*A16+AI43*B16+AI44*C16)),VALUE(0),(AI42*A16+AI43*B16+AI44*C16))","v":0},{"$f":"IF(ISERROR(VLOOKUP(A32,$Y$42:$Z$57,2,TRUE)),VALUE(0),VLOOKUP(A32,$Y$42:$Z$57,2,TRUE))","v":0},{"$f":"IF(ISERROR('1-Project Desc'!E54),VALUE(0),'1-Project Desc'!E54)","v":0},{"$f":"IF(C32=0,0,IF(C32<AC46,AD46,IF(C32<AC45,AD45,IF(C32<AC44,AD44,IF(C32<AC43,AD43,IF(C32<1600000,AD46,0))))))","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEAO",2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crash Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intersection",null,"Section"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crash Rate","Points","Crash Rate","Points","RSI","Points","EPDO Value","Points","Rate of Return","Points","HSIP Funding Request","Points",null,null,null,"2020-07-24",2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,"> $1,600,000",0,null,null,"Rural Non-Freeway","Fatal Crash",194.63,"Section",null,null,"Intersection","Rural Non-Freeway","Signalized","Undivided","2 Lanes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,1,2,30000,2,25,2,{"$f":"AA42+0.02","v":0.02},2,1600000,5,null,null,"Urban Non-Freeway","Injury Crash",6.53,"Intersection",null,null,"Section",null,"Non-Signalized","Divided","4 Lanes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,2,4,35000,4,50,4,{"$f":"AA43+0.02","v":0.04},4,1200000,10,null,null,"Freeway","PDO Crash",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,3,6,37500,6,75,6,0.06,6,800001,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,8,4,8,40000,8,100,8,0.08,8,400000,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,5,10,42500,10,125,10,0.1,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,12,6,12,45000,12,150,12,0.12000000000000001,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,14,7,14,47500,14,175,14,0.14000000000000001,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,16,8,16,50000,16,200,16,0.16,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,18,9,18,55000,18,225,18,0.18,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,20,10,20,60000,20,250,20,0.19999999999999998,20]

{"sheet":"CRF Table_Rev","index":5,"n_rows":150,"n_cols":39,"rows_kept":150,"cut":false,"hidden":false,"merged":[[1,14,3,25],[1,27,3,38],[0,4,2,5]]}
["Estimates of Countermeasure Effectiveness Reduction (CRF) Factors",null,null,null,"Find Addiational Countermeasures Here:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property Damage Only Crashes",null,null,null,null,null,null,null,null,null,null,null,null,"Injury / Fatal Crashes"]
[]
[]
["CMF ID","Study Title","Countermeasure Category","Countermeasure","Service Life","Intersection Related (Y/N)","Wet Pavement Related","Night Related","Ran off Road","Publication Year","Star Quality Rating","All","PDO","INJ/FAT","Night","WET","RAN OFF RD","LEFT","RIGHT","ANGLE","REAR END","HEAD ON","SS PASS","FIXED OBJ","PEDESTRIAN","OTHER",{"$f":"D5","v":"Countermeasure"},"Night","WET","RAN OFF RD","LEFT","RIGHT","ANGLE","REAR END","HEAD ON","SS PASS","FIXED OBJ","PEDESTRIAN","OTHER"]
[22,"Handbook of Road Safety Measures","Access management","Provide a median - Urban",20,null,null,null,null,2004,4,null,-0.09,0.39,null,null,null,{"$f":"$M6","v":-0.09},-0.09,-0.09,-0.09,-0.09,-0.09,-0.09,-0.09,-0.09,{"$f":"D6","v":"Provide a median - Urban"},null,null,null,{"$f":"$N6","v":0.39},0.39,0.39,0.39,0.39,0.39,0.39,0.39,0.39]
[24,"Handbook of Road Safety Measures","Access management","Provide a median - Rural",20,null,null,null,null,2004,4,null,0.18,0.12,null,null,null,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,"Provide a median - Rural",null,null,null,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
[2514,"Modeling and Evaluating the Safety Impacts of Access Management (AM) Features in the Las Vegas Valley","Access management","Replace TWLTL with raised median - Urban Only",20,null,null,null,"Yes",2010,3,null,null,null,null,null,0.33,0.36,null,0.36,0.19,0.47,0.21,0.33,null,null,"Replace TWLTL with raised median - Urban Only",null,null,0.33,0.36,null,0.36,0.19,0.47,0.21,0.21]
[3034,"Analyzing Raised Median Safety Impacts Using Bayesian Methods","Access management","Install raised median",20,null,null,null,null,2011,4,0.39,null,0.44,null,null,null,{"$f":"$L9","v":0.39},0.39,0.39,0.39,0.39,0.39,0.39,0.39,0.39,"Install raised median",null,null,null,{"$f":"$N9","v":0.44},0.44,0.44,0.44,0.44,0.44,0.44,0.44,0.44]
[78,"Handbook of Road Safety Measures","Advanced technology and ITS","Install changeable speed warning signs for individual drivers",5,"Yes",null,null,null,2004,4,0.46,null,null,null,null,null,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46,"Install changeable speed warning signs for individual drivers",null,null,null,{"$f":"$L10","v":0.46},0.46,0.46,0.46,0.46,0.46,0.46,0.46,0.46]
[721,"Development of Crash Reduction Factors","Alignment","Flatten crest vertical curve",30,null,null,null,null,2005,3,0.2,null,0.51,null,null,null,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,"Flatten crest vertical curve",null,null,null,{"$f":"$N11","v":0.51},0.51,0.51,0.51,0.51,0.51,0.51,0.51,0.51]
[192,"Handbook of Road Safety Measures","Highway lighting","Provide highway lighting",10,null,null,null,null,2004,4,null,0.18,0.28000000000000003,null,null,null,{"$f":"$M12","v":0.18},0.18,0.18,0.18,0.18,0.18,0.18,0.18,0.18,"Provide highway lighting",null,null,null,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003]
[433,"Handbook of Road Safety Measures","Highway lighting","Lighting in intersections",10,"Yes",null,null,null,2004,4,null,0.31,0.38,null,null,null,0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31,0.31,"Lighting in intersections",null,null,null,{"$f":"$N13","v":0.38},0.38,0.38,0.38,0.38,0.38,0.38,0.42,{"$f":"$N13","v":0.38}]
[459,"Revision of the Hand Book of Road Safety Measures","Interchange design","Convert at-grade intersection to grade-separated interchange",30,"Yes",null,null,null,2007,4,0.42,0.36,0.56999999999999995,null,null,null,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,0.36,"Convert at-grade intersection to grade-separated interchange",null,null,null,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,0.56999999999999995,{"$f":"$N14","v":0.56999999999999995},{"$f":"$N14","v":0.56999999999999995}]
[473,"Revision of the Hand Book of Road Safety Measures","Interchange design","Design diamond, trumpet or cloverleaf interchange with crossroad above freeway",30,"Yes",null,null,null,2007,3,0.04,null,null,null,null,null,{"$f":"$L15","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,"Design diamond, trumpet or cloverleaf interchange with crossroad above freeway",null,null,null,{"$f":"$L15","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[474,"Handbook of Road Safety Measures","Interchange design","Extend acceleration lane by approx. 98 ft (30 m)",20,null,null,null,null,2004,5,0.11,null,null,null,null,null,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,"Extend acceleration lane by approx. 98 ft (30 m)",null,null,null,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
[475,"Handbook of Road Safety Measures","Interchange design","Extend deceleration lane by approx. 98 ft (30 m)",20,null,null,null,null,2004,3,7.0000000000000007E-2,null,null,null,null,null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,"Extend deceleration lane by approx. 98 ft (30 m)",null,null,null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[476,"Revision of the Hand Book of Road Safety Measures","Interchange design","Modify two-lane to one-lane merge/ diverge area",20,null,null,null,null,2007,5,0.32,null,null,null,null,null,0.32,0.32,0.32,0.32,0.32,0.32,0.32,0.32,0.32,"Modify two-lane to one-lane merge/ diverge area",null,null,null,0.32,0.32,0.32,0.32,0.32,0.32,0.32,0.32,0.32]
[255,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Installation of left-turn lane on single major road approach - Urban",20,"Yes",null,null,null,2002,5,0.27,null,0.28999999999999998,null,null,null,0.27,0.27,0.27,0.27,0.27,0.27,0.27,0.27,0.27,"Installation of left-turn lane on single major road approach - Urban",null,null,null,{"$f":"$N19","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998]
[265,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Installation of left-turn lane on single major road approach - Rural",20,"Yes",null,null,null,2002,5,0.28000000000000003,null,0.35,null,null,null,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,0.28000000000000003,"Installation of left-turn lane on single major road approach - Rural",null,null,null,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[269,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Add left-turn lanes to major road approaches at intersections - Urban",20,"Yes",null,null,null,2002,5,0.47,null,0.17,null,null,null,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,"Add left-turn lanes to major road approaches at intersections - Urban",null,null,null,0.17,0.17,0.17,0.17,0.17,0.17,0.17,0.17,0.17]
[272,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Add left-turn lanes to major road approaches at intersections - Rural",20,"Yes",null,null,null,2002,5,null,null,0.57999999999999996,null,null,null,0,0,0,0,0,0,0,0,0,"Add left-turn lanes to major road approaches at intersections - Rural",null,null,null,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996,0.57999999999999996]
[276,"Right-Angle Crash Occurance at Signalized Intersections","Intersection geometry","Introducing zero or positive offset left-turn lane on crossing roadway",20,"Yes",null,null,null,2007,3,null,null,null,null,null,null,0.2,null,0.26,null,null,null,null,null,null,"Introducing zero or positive offset left-turn lane on crossing roadway",null,null,null,0.2,null,0.26]
[285,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Installation of right-turn lane on single major road approach - Stop Controlled",20,"Yes",null,null,null,2002,4,0.14000000000000001,null,0.23,null,null,null,{"$f":"$L24","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,"Installation of right-turn lane on single major road approach - Stop Controlled",null,null,null,{"$f":"$N24","v":0.23},0.23,0.23,0.23,0.23,0.23,0.23,0.23,0.23]
[290,"Safety Effectiveness of Intersection Left- and Right-Turn Lanes","Intersection geometry","Installation of right-turn lane on both major road approaches - Signalized",20,"Yes",null,null,null,2002,5,0.08,null,null,null,null,null,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08,"Installation of right-turn lane on both major road approaches - Signalized",null,null,null,{"$f":"$L25","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[307,"Handbook of Road Safety Measures","Intersection geometry","Increase triangle sight distance",10,"Yes",null,null,null,2004,3,null,0.11,0.48,null,null,null,{"$f":"$M26","v":0.11},0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,"Increase triangle sight distance",null,null,null,{"$f":"$N26","v":0.48},0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48]
[329,"Crash Reductions Related to Traffic Signal Removal in Philadelphia","Intersection traffic control","Remove an unwarranted signal (one-way streets)",5,"Yes",null,null,null,1997,4,0.24,null,null,null,null,null,{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},0.28999999999999998,{"$f":"$L27","v":0.24},0.24,0.24,0.18,{"$f":"$L27","v":0.24},"Remove an unwarranted signal (one-way streets)",null,null,null,{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},0.28999999999999998,{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},{"$f":"$L27","v":0.24},0.18,{"$f":"$L27","v":0.24}]
[380,"Field Evaluation of Two Methods for Restricting Right Turn on Red to Promote Pedestrian Safety","Intersection traffic control","Retiming signal change intervals to ITE standards",5,"Yes",null,null,null,2002,3,0.08,null,0.12,null,null,null,{"$f":"$L28","v":0.08},0.08,0.04,-0.12,0.08,0.08,0.08,0.39,0.08,"Retiming signal change intervals to ITE standards",null,null,null,{"$f":"$N28","v":0.12},0.12,0.04,-0.08,{"$f":"$N28","v":0.12},0.12,0.12,0.37,{"$f":"$N28","v":0.12}]
[227,"NCHRP Report 572: Applying Roundabouts in the United States","Intersection traffic control","Convert two-way stop-controlled intersection to roundabout",20,"Yes",null,null,null,2007,5,0.44,null,0.82,null,null,null,0.44,0.44,{"$f":"$L29","v":0.44},0.44,0.44,0.44,0.44,{"$f":"$L29","v":0.44},0.44,"Convert two-way stop-controlled intersection to roundabout",null,null,null,0.82,0.82,{"$f":"$N29","v":0.82},{"$f":"$N29","v":0.82},0.82,0.82,0.82,{"$f":"$N29","v":0.82},{"$f":"$N29","v":0.82}]
[229,"NCHRP Report 572: Applying Roundabouts in the United States","Intersection traffic control","Convert two-way stop-controlled intersection to roundabout - Rural",20,"Yes",null,null,null,2007,5,0.71,null,0.87,null,null,null,0.71,0.71,0.71,0.71,0.71,0.71,0.71,{"$f":"$L30","v":0.71},0.71,"Convert two-way stop-controlled intersection to roundabout - Rural",null,null,null,0.87,0.87,{"$f":"$N30","v":0.87},{"$f":"$N30","v":0.87},0.87,0.87,0.87,{"$f":"$N30","v":0.87},{"$f":"$N30","v":0.87}]
[208,"Observational Before-After Study of the Safety Effect of U.S. Roundabout Conversions Using the Empirical Bayes Method","Intersection traffic control","Conversion of stop-controlled intersection into multi-lane roundabout - Urban",20,"Yes",null,null,null,2001,3,0.05,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,{"$f":"$L31","v":0.05},0.05,"Conversion of stop-controlled intersection into multi-lane roundabout - Urban",null,null,null,{"$f":"$L31","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[209,"Observational Before-After Study of the Safety Effect of U.S. Roundabout Conversions Using the Empirical Bayes Method","Intersection traffic control","Conversion of signalized intersection into single- or multi-lane roundabout - Urban",20,"Yes",null,null,null,2001,3,0.35,null,0.74,null,null,null,0.35,0.35,0.35,0.35,0.35,0.35,0.35,{"$f":"$L32","v":0.35},0.35,"Conversion of signalized intersection into single- or multi-lane roundabout - Urban",null,null,null,{"$f":"$N32","v":0.74},0.74,0.74,0.74,0.74,0.74,0.74,0.74,0.74]
[315,"Prediction of the Expected Safety Performance of Rural Two-Lane Highways","Intersection traffic control","Convert two-way to all-way stop control",10,"Yes",null,null,"Yes",1986,5,0.48,null,0.77,null,null,{"$f":"$L33","v":0.48},0.48,0.48,0.75,0.18,0.48,0.48,0.48,0.43,0.48,"Convert two-way to all-way stop control",null,null,null,{"$f":"$N33","v":0.77},{"$f":"$N33","v":0.77},0.75,0.18,{"$f":"$N33","v":0.77},{"$f":"$N33","v":0.77},{"$f":"$N33","v":0.77},0.43,{"$f":"$N33","v":0.77}]
[325,"Accident Modification Factors for Traffic Engineering and ITS Improvements","Intersection traffic control","Convert stop-control to signal",10,"Yes",null,null,"Yes",2008,5,0.44,null,null,null,null,{"$f":"$L34","v":0.44},0.44,0.44,0.77,-0.57999999999999996,0.44,0.44,0.44,0.44,0.44,"Convert stop-control to signal",null,null,null,{"$f":"$L34","v":0.44},0.44,0.77,-0.57999999999999996,{"$f":"$L34","v":0.44},0.44,0.44,0.44,0.44]
[333,"Accident Modification Factors for Traffic Engineering and ITS Improvements","Intersection traffic control","Change from permitted or permitted-protected to protected - Urban",5,"Yes",null,null,"Yes",2008,5,0.01,null,null,null,null,{"$f":"$L35","v":0.01},0.01,0.01,0.99,{"$f":"$L35","v":0.01},0.01,0.01,0.01,{"$f":"$L35","v":0.01},0.01,"Change from permitted or permitted-protected to protected - Urban",null,null,null,0.01,0.01,0.99,{"$f":"$L35","v":0.01},0.01,0.01,0.01,0.01,0.01]
[377,"Handbook of Road Safety Measures","Intersection traffic control","Permit Right-Turn-On-Red",5,"Yes",null,null,"Yes",2004,5,-0.05,null,null,null,null,{"$f":"$L36","v":-0.05},-0.05,-0.05,-0.1,{"$f":"$L36","v":-0.05},-0.05,-0.05,-0.05,{"$f":"$L36","v":-0.05},-0.05,"Permit Right-Turn-On-Red",null,null,null,-0.05,-0.05,-0.1,{"$f":"$L36","v":-0.05},-0.05,-0.05,-0.05,-0.05,-0.05]
[388,"Accident Modification Factors for Traffic Engineering and ITS Improvements","Intersection traffic control","Replace Night-Time Flash with Steady Operation",5,"Yes",null,"Yes",null,2008,3,0.27,null,0.23,0.35,null,null,0.27,0.27,{"$f":"$L37","v":0.27},{"$f":"$L37","v":0.27},0.27,0.27,0.27,{"$f":"$L37","v":0.27},0.27,"Replace Night-Time Flash with Steady Operation",0.35,null,null,{"$f":"$N37","v":0.23},0.23,0.23,0.23,0.23,0.23,0.23,0.23,0.23]
[2333,"Evaluation of the Safety Effectiveness of Selected Treatments at Urban Signalized Intersections","Intersection traffic control","Replace 8-inch red signal heads with 12-inch",10,"Yes",null,null,null,2008,4,0.03,null,null,null,null,null,0.03,0.03,0.42,{"$f":"$L38","v":0.03},0.03,0.03,0.03,{"$f":"$L38","v":0.03},0.03,"Replace 8-inch red signal heads with 12-inch",null,null,null,{"$f":"$L38","v":0.03},{"$f":"$L38","v":0.03},0.42,{"$f":"$L38","v":0.03},0.03,0.03,0.03,0.03,0.03]
[446,"Safety Evaluation of Flashing Beacons at Stop Controlled Intersections","Intersection traffic control","Flashing beacons at four leg stop controlled intersections on two lane roads; Standard and actuated beacons",10,"Yes",null,null,null,2008,3,0.05,null,0.1,null,null,null,0.05,0.05,0.57999999999999996,0.08,0.05,0.05,0.05,{"$f":"$L39","v":0.05},0.05,"Flashing beacons at four leg stop controlled intersections on two lane roads; Standard and actuated beacons",null,null,null,{"$f":"$L39","v":0.05},{"$f":"$L39","v":0.05},0.13,0.08,{"$f":"$L39","v":0.05},{"$f":"$L39","v":0.05},{"$f":"$L39","v":0.05},{"$f":"$L39","v":0.05},{"$f":"$L39","v":0.05}]
[153,"Handbook of Road Safety Measures","On-street parking","Prohibit on-street parking - Minor Arterial",10,"No",null,null,null,2004,5,null,0.27,0.2,null,null,null,{"$f":"$M40","v":0.27},0.27,0.27,0.27,0.27,0.27,0.27,0.27,0.27,"Prohibit on-street parking - Minor Arterial",null,null,null,{"$f":"$N40","v":0.2},0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[153,"Handbook of Road Safety Measures","On-street parking","Prohibit on-street parking - Principal Arterial",10,"No",null,null,null,2004,4,0.42,0.48,0.35,null,null,null,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,0.48,"Prohibit on-street parking - Principal Arterial",null,null,null,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35,0.35]
[2911,"Safety Effectiveness of the HAWK Pedestrian Crossing Treatment","Pedestrians and bicyclists","Installation of a High intensity Activated crossWalK (HAWK) pedestrian-activated beacon at an intersection - Urban",10,null,null,null,null,2010,4,0.28999999999999998,null,null,null,null,null,{"$f":"$L42","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,"Installation of a High intensity Activated crossWalK (HAWK) pedestrian-activated beacon at an intersection - Urban",null,null,null,{"$f":"$L42","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998]
[482,"Handbook of Road Safety Measures","Railroad grade crossings","Upgrading signs to flashing lights and sound signals",5,null,null,null,null,2004,5,0.5,null,null,null,null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,"Upgrading signs to flashing lights and sound signals",null,null,null,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[487,"Collision Frequency Analysis Using Tree-Based Stratification","Railroad grade crossings","Upgrade signs to flashing lights",5,null,null,null,null,2005,5,0.77,null,null,null,null,null,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77,"Upgrade signs to flashing lights",null,null,null,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77]
[493,"Collision Frequency Analysis Using Tree-Based Stratification","Railroad grade crossings","Installing gates at crossings with signs",20,null,null,null,null,2005,5,0.93,null,null,null,null,null,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,"Installing gates at crossings with signs",null,null,null,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93,0.93]
[494,"Handbook of Road Safety Measures","Railroad grade crossings","Installing gates at crossings with flashing lights and sound signals",20,null,null,null,null,2004,4,0.45,null,null,null,null,null,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,"Installing gates at crossings with flashing lights and sound signals",null,null,null,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45]
[38,"Handbook of Road Safety Measures","Roadside","New guardrail along embankment",20,"No",null,null,"Yes",2004,5,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"New guardrail along embankment",null,null,0.47,null,null,null,null,null,null,0.47]
[40,"Handbook of Road Safety Measures","Roadside","Change barrier along embankment to less rigid type",20,"No",null,null,"Yes",2004,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change barrier along embankment to less rigid type",null,null,0.32,null,null,null,null,null,null,0.32]
[42,"Handbook of Road Safety Measures","Roadside","Install median guardrails on divided highways",20,"No",null,null,null,2004,4,null,-0.24,0.3,null,null,null,{"$f":"$M49","v":-0.24},-0.24,-0.24,-0.24,-0.24,-0.24,-0.24,-0.24,-0.24,"Install median guardrails on divided highways",null,null,null,{"$f":"$N49","v":0.3},0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[55,"Handbook of Road Safety Measures","Roadside","Install crash cushions at permanent objects",20,"No",null,null,null,2004,3,null,null,null,null,null,null,null,null,null,null,null,null,0.46,null,null,"Install crash cushions at permanent objects",null,null,null,null,null,null,null,null,null,0.69]
[974,"Development of Crash Reduction Factors","Roadside","Install median barrier",20,"No",null,null,null,2005,3,0.86,null,0.88,null,null,null,{"$f":"$L51","v":0.86},0.86,0.86,0.86,0.86,0.86,0.86,0.86,0.86,"Install median barrier",null,null,null,{"$f":"$N51","v":0.88},0.88,0.88,0.88,0.88,0.88,0.88,0.88,0.88]
[3172,"Hierarchical Bayesian Modeling for Before and After Studies","Roadside","Installation of cable barriers in freeway medians",20,"No",null,null,null,2011,3,null,null,0.44,null,null,null,null,null,null,null,null,null,null,null,null,"Installation of cable barriers in freeway medians",null,null,null,0.44,0.44,0.44,0.44,0.44,0.44,0.44,0.44,0.44]
[194,"Crash Reduction Factors for Traffic Engineering and ITS Improvements","Roadway","Increased pavement friction",10,null,"Yes",null,null,2008,5,0.24,null,null,null,0.56999999999999995,null,{"$f":"$L53","v":0.24},0.24,0.24,0.17,{"$f":"$L53","v":0.24},0.24,0.24,0.24,0.24,"Increased pavement friction",null,0.56999999999999995,null,{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24},0.17,{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24},{"$f":"$L53","v":0.24}]
[2341,"Safety Evaluation of Installing Center Two-Way Left-Turn Lanes on Two-Lane Roads","Roadway","Install TWLTL (two-way left turn lane) on two lane road",20,null,null,null,null,2008,5,0.20300000000000001,null,0.26100000000000001,null,null,null,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.38700000000000001,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.20300000000000001,"Install TWLTL (two-way left turn lane) on two lane road",null,null,null,{"$f":"$N54","v":0.26100000000000001},0.26100000000000001,0.26100000000000001,0.38700000000000001,{"$f":"$N54","v":0.26100000000000001},0.26100000000000001,0.26100000000000001,0.26100000000000001,0.26100000000000001]
[583,"Safety Evaluation of Installing Center Two-Way Left-Turn Lanes on Two-Lane Roads","Roadway","Introduce TWLTL (two-way left turn lanes) on rural two lane roads",20,null,null,null,null,2008,5,0.36,null,0.35,null,null,null,0.36,0.36,0.36,0.47,0.36,0.36,0.36,0.36,0.36,"Introduce TWLTL (two-way left turn lanes) on rural two lane roads",null,null,null,0.35,0.35,0.35,0.47,0.35,0.35,0.35,0.35,0.35]
[199,"Crash Reduction Factors for Traffic Engineering and ITS Improvements","Roadway","Road diet (Convert 4-lane undivided road to 2-lanes plus turning lane) - Minor Arterial",5,null,null,null,null,2008,5,0.28999999999999998,null,null,null,null,null,0.28999999999999998,0.28999999999999998,0.28999999999999998,{"$f":"$L56","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,"Road diet (Convert 4-lane undivided road to 2-lanes plus turning lane) - Minor Arterial",null,null,null,{"$f":"$L56","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998]
[2341,"Safety Evaluation of Installing Center Two-Way Left-Turn Lanes on Two-Lane Roads","Roadway","Install TWLTL (two-way left turn lane) on two lane road",20,null,null,null,null,2008,5,0.20300000000000001,null,0.26100000000000001,null,null,null,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.49399999999999999,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.20300000000000001,0.20300000000000001,"Install TWLTL (two-way left turn lane) on two lane road",null,null,null,{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001},0.49399999999999999,{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001},{"$f":"$N57","v":0.26100000000000001}]
[2841,"Comparison of empirical Bayes and full Bayes approaches for before\u0013after road safety evaluations","Roadway","Converting four-lane roadways to three-lane roadways with center turn lane (road diet) - Suburban",5,null,null,null,null,2010,4,0.53,null,null,null,null,null,0.53,0.53,0.53,{"$f":"$L58","v":0.53},0.53,0.53,0.53,0.53,0.53,"Converting four-lane roadways to three-lane roadways with center turn lane (road diet) - Suburban",null,null,null,{"$f":"$L58","v":0.53},0.53,0.53,0.53,0.53,0.53,0.53,0.53,0.53]
[2975,"Safety Evaluation of Multilane Arterials in Florida","Roadway","Resurface pavement",20,"No",null,null,null,2009,4,-0.01,null,0.05,null,null,null,{"$f":"$L59","v":-0.01},{"$f":"$L59","v":-0.01},{"$f":"$L59","v":-0.01},0.01,-0.01,-0.01,-0.01,-0.01,-0.01,"Resurface pavement",null,null,null,{"$f":"$N59","v":0.05},0.05,0.05,0.01,{"$f":"$N59","v":0.05},{"$f":"$N59","v":0.05},{"$f":"$N59","v":0.05},{"$f":"$N59","v":0.05},{"$f":"$N59","v":0.05}]
[3341,"NCHRP Report 641: Guidance for the Design and Application of Shoulder and Centerline Rumble Strips","Roadway","Install centerline rumble strips - Urban",20,"No",null,null,null,2009,5,-0.02,null,0.09,null,null,null,-0.02,-0.02,-0.02,-0.02,0.4,0.4,{"$f":"$L60","v":-0.02},-0.02,-0.02,"Install centerline rumble strips - Urban",null,null,null,0.09,0.09,0.09,{"$f":"$N60","v":0.09},0.4,0.4,{"$f":"$N60","v":0.09},0.09,0.09]
[3341,"NCHRP Report 641: Guidance for the Design and Application of Shoulder and Centerline Rumble Strips","Roadway","Install centerline rumble strips - Rural",20,"No",null,null,null,2009,5,0.11,null,0.09,null,null,null,0.11,0.11,0.11,0.11,0.49,0.49,0.11,0.11,0.11,"Install centerline rumble strips - Rural",null,null,null,0.09,0.09,0.09,{"$f":"$N61","v":0.09},0.49,0.49,0.09,0.09,0.09]
[3388,"NCHRP Report 641: Guidance for the Design and Application of Shoulder and Centerline Rumble Strips","Roadway","Install edgeline rumble strips - Undivided",20,"No",null,null,null,2009,4,null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,"Install edgeline rumble strips - Undivided",null,null,null,0.25,0.25,0.25,{"$f":"$N62","v":0.25},{"$f":"$N62","v":0.25},0.25,0.25,0.25,0.25]
[87,"Handbook of Road Safety Measures","Roadway delineation","Add centerlines on roadway segments (2 lane roadway)",5,"No",null,null,null,2004,3,null,-0.01,0.01,null,null,null,{"$f":"$M63","v":-0.01},-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,-0.01,"Add centerlines on roadway segments (2 lane roadway)",null,null,null,0.01,0.01,0.01,{"$f":"$N63","v":0.01},0.01,0.01,0.01,0.01,0.01]
[102,"Handbook of Road Safety Measures","Roadway delineation","Install a combination of edgelines, centerlines and delineators on roadway segments",5,"No",null,null,null,2004,4,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,"Install a combination of edgelines, centerlines and delineators on roadway segments",null,null,null,0.45,0.45,0.45,{"$f":"$N64","v":0.45},0.45,0.45,0.45,0.45,0.45]
[1965,"Safety Impact of Cable Barriers on Rural Interstates","Roadway delineation","Install cable median barrier (low or high tension) - Rural",20,"No",null,null,"Yes",2009,5,null,null,null,null,null,0.25,null,null,null,0.14000000000000001,0.94,0.14000000000000001,null,null,null,"Install cable median barrier (low or high tension) - Rural",null,null,null,null,null,null,0.14000000000000001,0.94,0.14000000000000001,0.25,null,0.25]
[73,"Handbook of Road Safety Measures","Roadway signs and traffic control","Provide static combination horizontal alignment / advisory speed signs",5,"No",null,null,null,2004,3,null,0.28999999999999998,0.13,null,null,null,{"$f":"$M66","v":0.28999999999999998},0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,0.28999999999999998,"Provide static combination horizontal alignment / advisory speed signs",null,null,null,{"$f":"$N66","v":0.13},0.13,0.13,0.13,0.13,0.13,0.13,0.13,0.13]
[2431,"Safety Evaluation of Improved Curve Delineation","Roadway signs and traffic control","Install new fluorescent curve signs or upgrade existing curve signs to fluorescent sheeting - Rural",5,"No",null,"Yes","Yes",2009,4,0.18,null,0.25,0.35,null,0.34,{"$f":"$L67","v":0.18},0.18,0.18,0.18,0.34,0.34,0.34,{"$f":"$L67","v":0.18},0.18,"Install new fluorescent curve signs or upgrade existing curve signs to fluorescent sheeting - Rural",0.35,null,null,{"$f":"$N67","v":0.25},0.25,0.25,0.25,0.34,0.34,0.34,{"$f":"$N67","v":0.25},0.34]
[2436,"Safety Evaluation of Improved Curve Delineation","Roadway signs and traffic control","Install chevron signs on horizontal curves - Rural",5,"No",null,"Yes","Yes",2009,4,0.04,null,0.16,0.25,null,0.06,0.04,0.04,0.04,0.04,0.06,0.06,0.06,0.04,0.04,"Install chevron signs on horizontal curves - Rural",0.25,null,null,0.16,0.16,0.16,0.16,0.06,0.06,0.06,{"$f":"$N68","v":0.16},0.06]
[10,"Highway Safety Manual Knowledge Document","Shoulder treatments","Widen paved shoulder from 3 ft to 4 ft",20,"No",null,null,null,2009,3,0.03,null,null,null,null,null,0.03,0.03,0.03,0.03,{"$f":"$L69","v":0.03},0.03,0.03,0.03,0.03,"Widen paved shoulder from 3 ft to 4 ft",null,null,null,{"$f":"$L69","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[11,"Highway Safety Manual Knowledge Document","Shoulder treatments","Widen paved shoulder from 3 ft to 5 ft",20,"No",null,null,null,2009,3,0.05,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,{"$f":"D70","v":"Widen paved shoulder from 3 ft to 5 ft"},null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[12,"Highway Safety Manual Knowledge Document","Shoulder treatments","Widen paved shoulder from 3 ft to 6 ft",20,"No",null,null,null,2009,3,7.0000000000000007E-2,null,null,null,null,null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,{"$f":"D71","v":"Widen paved shoulder from 3 ft to 6 ft"},null,null,null,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[13,"Highway Safety Manual Knowledge Document","Shoulder treatments","Widen paved shoulder from 3 ft to 7 ft",20,"No",null,null,null,2009,3,0.1,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,{"$f":"D72","v":"Widen paved shoulder from 3 ft to 7 ft"},null,null,null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[14,"Highway Safety Manual Knowledge Document","Shoulder treatments","Widen paved shoulder from 3 ft to 8 ft",20,"No",null,null,null,2009,3,0.12,null,null,null,null,null,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,{"$f":"D73","v":"Widen paved shoulder from 3 ft to 8 ft"},null,null,null,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
[16,"Paved Highway Shoulders and Accident Experience","Shoulder treatments","Pave a 3 to 4 ft sod shoulder",20,"No",null,null,null,2009,3,0.19,0.22,0.14000000000000001,null,null,null,{"$f":"$M74","v":0.22},0.22,0.22,0.22,0.22,0.22,0.22,0.22,0.22,{"$f":"D74","v":"Pave a 3 to 4 ft sod shoulder"},null,null,null,{"$f":"$N74","v":0.14000000000000001},0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001,0.14000000000000001]
[null,"Highway Safety Manual","Lane widening","Widen lane width from 9 ft or less to 12 ft",20,"No",null,null,null,2010,5,{"$f":"ROUND(1/1.5,2)","v":0.67},{"$f":"L75","v":0.67},{"$f":"M75","v":0.67},null,null,null,{"$f":"$L75","v":0.67},{"$f":"$L75","v":0.67},0.67,0.67,0.67,0.67,0.67,0.67,0.67,{"$f":"D75","v":"Widen lane width from 9 ft or less to 12 ft"},null,null,null,{"$f":"$L75","v":0.67},0.67,0.67,0.67,0.67,0.67,0.67,0.67,0.67]
[null,"Highway Safety Manual","Lane widening","Widen lane width from 10 ft to 12 ft",20,"No",null,null,null,2010,5,{"$f":"ROUND(1/1.3,2)","v":0.77},{"$f":"L76","v":0.77},0.77,null,null,null,{"$f":"$L76","v":0.77},0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77,"Widen lane width from 10 ft to 12 ft",null,null,null,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77,0.77]
[null,"Highway Safety Manual","Lane widening","Widen lane width from 11 ft to 12 ft",20,"No",null,null,null,2010,5,{"$f":"ROUND(1/1.05,2)","v":0.95},{"$f":"L77","v":0.95},0.95,null,null,null,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,"Widen lane width from 11 ft to 12 ft",null,null,null,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D139","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Scoring Table","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,11],[1,8,1,11]]}
["Safety Project Scoring Matrix"]
["Safety Conditions",null,null,null,null,null,null,null,"Economic Analysis"]
["Crash Rate (Intersection)","Points","Crash Rate (Section)","Points","RSI","Points","EPDO Value","Points","HSIP Funding Request","Points","Rate of Return (%)","Points"]
[">=10",20,">=10",20,">= 60,000",20,">= 250",20,"< $400,000",20,">=20",20]
["9 to 9.99",18,"9 to 9.99",18,"55000 to 60000",18,"225 to 250",18,"$400,000 to $800,000",15,"18 to 20",18]
["8 to 8.99",16,"8 to 8.99",16,"50000 to 55000",16,"200 to 225",16,"$800,000 to $1,200,000",10,"16 to 18",16]
["7 to 7.99",14,"7 to 7.99",14,"47500 to 50000",14,"175 to 200",14,"$1,200,000 to $1,600,000",5,"14 to 16",14]
["6 to 6.99",12,"6 to 6.99",12,"45000 to 47500",12,"150 to 175",12,">= $1,600,000",0,"12 to 14",12]
["5 to 5.99",10,"5 to 5.99",10,"42500 to 45000",10,"125 to 150",10,null,null,"10 to 12",10]
["4 to 4.99",8,"4 to 4.99",8,"40000 to 42500",8,"100 to 125",8,null,null,"8 to 10",8]
["3 to 3.99",6,"3 to 3.99",6,"37500 to 40000",6,"75 to 100",6,null,null,"6 to 8",6]
["2 to 2.99",4,"2 to 2.99",4,"35000 to 37500",4,"50 to 75",4,null,null,"4 to 6",4]
["1 to 1.99",2,"1 to 1.99",2,"30000 to 35000",2,"25 to 50",2,null,null,"2 to 4",2]
["0 to 0.99",0,"0 to 0.99",0,"0 to 30000",0,"0 to 25",0,null,null,"0 to 2",0]

{"sheet":"RefTables","index":7,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Ohio SHSP Emphasis Area"]
["Serious Crash Types"]
["High Risk Drivers and Behaviors"]
["Special Vehicles and Roadway Users"]
["Data"]
[]
[]
["Data"]
["Timely Data"]
["Reliable Data"]
["Comprehensive Data"]
["Integrated Data and Analysis Systems"]
[]
["SeriousCrashTypes"]
["Roadway Departure"]
["Intersection"]
["Rear End Crashes"]
["Highway Railroad Crossing"]
[]
["HighRiskDriversandBehaviors"]
["Impaired Drivers"]
["Seat Belt"]
["Speed"]
["Young Drivers"]
["Older Drivers"]
["Distracted Drivers"]
[]
["SpecialVehiclesandRoadwayUsers"]
["Bicycle Riders"]
["Pedestrians"]
["Commercial Vehicles"]
["Motorcycles"]