{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Instructions","Safety Application","DSRTSignature","Project Scoring","ScoringCalculations","ScoringTable","RefTables","CMS","Coordinates","SafetyPriority","Import"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[11,0,11,8],[30,0,30,8],[31,0,31,8],[32,0,32,8],[33,0,33,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[23,0,23,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[0,0,0,8],[21,0,21,8],[22,0,22,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[14,0,14,8],[1,0,1,8],[2,0,2,8],[6,0,6,8],[7,0,7,8],[9,0,9,8],[10,0,10,8],[12,0,12,8],[13,0,13,8]]}
["Application and Scoring Tool Instructions",null,null,null,null,null,null,null,null,null,"Version",20171212]
[]
["The instructions can be used to understand the functionality of the tool.  The tool attempts to complete as many fields as possible form information entered in the Economic Crash Analysis Tool (ECAT).  "]
[]
["The worksheets have been protected because the tool is standardized to import into the ODOT Central Office Database. Once submitted, the complete data layouts will be imported into the current database.  At this point, the district will be able to make any changes desired prior to the HSIP Program Committee Review."]
[]
[]
["I recommend starting a new application by importing data from existing ECAT Tool(s).  The import functionality will obtain information from (1) an ECAT Tool that does not have a fundamental change in Safety Performance Function (SPF) ('No' response in Cell \"K14\" on the Project Information Worksheet) or (2) an ECAT Tool that has have a fundamental change in Safety Performance Function (SPF) ('Yes' response in Cell \"K14\" on the Project Information Worksheet).  Follow the coded prompts.  Two files will be required for Item (2).  The order of import is does not matter.  Following the import process, please verify the data as assumptions have been made.  For example, it was assumed that only one route (major route) was used in the Project Element Description Table when determining project limits (All NLFIDs match in Column F).\n\nNote:  If you choose to import a new dataset, any previous information will be overridden."]
[]
[]
["At times, it will be necessary to change the font size of cells to make the text visible.  Once the tool is activated, select the cells you desire to decrease / increase the font size (selection can be contiguous or noncontiguous cells).  Once the cells have been selected, select the desired functionality."]
[]
[]
["This tool can be used to add rows of details for either work locations of funding sources.  Submitters can add up to a total of 10 work locations.  Similarly, there are a ten (10) total funding sources possible (including the three already defined).  For funding sources, we are asking that each source be individually itemized."]
[]
["ODOT Internal Only Functionality:"]
["I apologize but this functionality requires ODBC connection to ODOT's Sybase Tables.  These tools are reserved for only internal use only."]
[]
[]
["This tool will find the associated coordinates stored in the BTRS_LOG_POINTS Table.  This table includes all State, County and Township Routes.  This tool appears twice in the application.  It will only populate the attributes immediately adjacent to the button."]
[]
[]
["This tool searches the Safety Analyst Priority List Locations (Top 500 Locations only), HSP Locations, Hot Spot Locations, High Risk Rural Roads (State and Local Systems), and the Five Percent Report Locations for the previous 10 years.  See records retention details for more information:"]
["http://apps.das.ohio.gov/rims/SelectMenu/Selection.asp"]
[]
[]
["This tool queries from the BTRS_CONGESTION_SEGMENTS table residing in Sybase.  The data is based on counted volumes and statewide model projects for current year volumes.  \nNOTE: The data is only available for state system at this time."]

{"sheet":"Safety Application","index":1,"n_rows":108,"n_cols":28,"rows_kept":108,"cut":false,"hidden":false,"merged":[[107,0,107,9],[105,0,105,2],[69,0,69,2],[72,0,72,2],[47,4,47,9],[48,4,48,9],[49,4,49,9],[50,4,50,9],[51,4,51,9],[52,4,52,9],[53,4,53,9],[65,6,65,9],[66,6,66,9],[70,0,70,2],[71,0,71,2],[69,9,71,9],[56,6,56,9],[57,6,57,9],[58,6,58,9],[59,6,59,9],[60,6,60,9],[61,6,61,9],[62,6,62,9],[63,6,63,9],[64,6,64,9],[57,10,57,11],[57,12,57,13],[57,14,57,15],[58,14,58,15],[59,14,59,15],[60,14,60,15],[61,14,61,15],[62,14,62,15],[63,14,63,15],[62,12,62,13],[63,10,63,11],[63,12,63,13],[64,14,64,15],[65,14,65,15],[66,14,66,15],[58,10,58,11],[58,12,58,13],[59,10,59,11],[59,12,59,13],[60,10,60,11],[60,12,60,13],[61,10,61,11],[61,12,61,13],[62,10,62,11],[64,10,64,11],[64,12,64,13],[65,10,65,11],[65,12,65,13],[66,10,66,11],[66,12,66,13],[0,0,0,9],[6,0,6,2],[1,3,1,9],[2,3,2,9],[3,3,3,9],[4,3,4,9],[5,3,5,9],[6,3,6,9],[4,0,4,2],[5,0,5,2],[2,0,2,2],[3,0,3,2],[16,0,16,9],[15,0,15,9],[1,0,1,2],[9,7,9,9],[10,7,10,9],[8,0,8,9],[9,0,9,1],[10,0,10,1],[11,0,11,1],[9,5,9,6],[10,5,10,6],[11,5,11,6],[11,7,11,9],[9,2,9,4],[10,2,10,4],[11,2,11,4],[13,0,13,1],[12,2,12,4],[13,5,13,6],[12,7,12,9],[12,0,12,1],[12,5,12,6],[13,2,13,4],[13,7,13,9],[38,0,38,6],[39,0,39,6],[40,0,40,6],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[30,0,30,9],[23,0,23,9],[22,0,22,9],[32,0,32,3],[34,0,34,9],[35,0,35,6],[36,0,36,6],[37,0,37,6],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[29,0,29,4],[28,0,28,4],[41,0,41,6],[42,0,42,6],[43,0,43,6],[68,0,68,9],[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[46,0,46,9],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[57,0,57,1],[55,0,55,9],[56,0,56,1],[44,0,44,7],[79,0,79,2],[75,0,75,2],[80,0,80,2],[73,0,73,2],[74,0,74,2],[87,4,87,6],[87,7,87,9],[90,4,90,6],[90,7,90,9],[83,0,83,9],[84,0,84,9],[88,4,88,6],[88,7,88,9],[89,4,89,6],[89,7,89,9],[78,0,78,2],[86,0,86,9],[76,0,76,2],[77,0,77,2],[87,0,87,3],[88,0,88,3],[89,0,89,3],[90,0,90,3],[101,0,101,9],[96,5,96,7],[95,8,95,9],[96,8,96,9],[95,5,95,7],[81,0,81,2],[98,8,98,9],[97,0,97,7],[98,0,98,7],[97,8,97,9],[92,4,92,6],[92,7,92,9],[91,4,91,6],[91,7,91,9],[95,0,95,4],[96,0,96,4],[91,0,91,3],[92,0,92,3],[94,0,94,9]]}
["General Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show Conditional Format:","Yes"]
["Project Sponsoring Agency",null,null,"ODOT District 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lat Long Format:","Yes"]
["Project Name",null,null,"Courtright Rd Bridge over I-70",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priority Rank Format:","Yes"]
["PID",null,null,109659]
["Project Manager",null,null,"Drew Hurst"]
["Contact Phone",null,null,"740-833-8345"]
["Contact Email",null,null,"andrew.hurst@dot.ohio.gov"]
[]
["Location Information"]
["ODOT District",null,6,null,null,"County",null,"FRA"]
["Route Number",null,70,null,null,"Road Name",null,"Courtright Rd"]
["Begin Logpoint",null,20.29,null,null,"End Logpoint",null,{"$f":"IF(D58=\"\",\"\",D58)","v":""}]
["Begin Latitude",null,39.9315,null,null,"Begin Longitude",null,-82.898099999999999]
["End Latitude",null,39.936599999999999,null,null,"End Longitude",null,-82.8977]
[]
["Project Description"]
["Summary of Crash Patterns"]
["One pedestrian-related crash has occurred in the past 5 years on Courtright between Deshler Ave. and Groves Rd, along with several other crashes including rear ends and sideswipes. There is evidence of pedestrian traffic, including worn paths leading up to the bridge.  "]
["Summary of Recommended Countermeasures"]
["Add sidewalk to Courtright Rd from Deshler Ave to Groves Rd, including the IR 70 overpass.  City of Columbus has an upcoming project to add sidewalks along Courtright Rd. to the south."]
["Project Priority Information"]
["There have been numerous community requests to add sidewalk across IR 70, and this would tie into a bridge deck replacement project.  There are no other potential pedestrian crossings over I-70 for a mile in each direction, and there are COTA bus stops on both sides of the bridge.  "]
["Crash Data"]
["Crash Totals"]
[null,null,null,null,null,"Fatal & Serious Injury  (KA)","Visible Injury (B)","Non-Visible (C)","Property Damage Only (O)","Total"]
["Existing Conditions: Predicted Crash Frequency",null,null,null,null,{"$f":"IF(ScoringCalculations!D36=0,\"\",ScoringCalculations!D36)","v":2.0399999999999998E-2},{"$f":"IF(ScoringCalculations!E36=0,\"\",ScoringCalculations!E36)","v":5.0900000000000001E-2},{"$f":"IF(ScoringCalculations!F36=0,\"\",ScoringCalculations!F36)","v":6.1800000000000008E-2},{"$f":"IF(ScoringCalculations!G36=0,\"\",ScoringCalculations!G36)","v":0.29210000000000003},{"$f":"ROUND(SUM(F26:I26),2)","v":0.43}]
["Existing Conditions: Expected Crash Frequency",null,null,null,null,{"$f":"IF(ScoringCalculations!D37=0,\"\",ScoringCalculations!D37)","v":2.0199999999999999E-2},{"$f":"IF(ScoringCalculations!E37=0,\"\",ScoringCalculations!E37)","v":5.28E-2},{"$f":"IF(ScoringCalculations!F37=0,\"\",ScoringCalculations!F37)","v":6.090000000000001E-2},{"$f":"IF(ScoringCalculations!G37=0,\"\",ScoringCalculations!G37)","v":0.30929999999999996},{"$f":"ROUND(SUM(F27:I27),2)","v":0.44}]
["Potential for Safety Improvement",null,null,null,null,{"$f":"IF(ScoringCalculations!D38=0,\"\",ScoringCalculations!D38)","v":-1.9999999999999879E-4},{"$f":"IF(ScoringCalculations!E38=0,\"\",ScoringCalculations!E38)","v":1.8999999999999989E-3},{"$f":"IF(ScoringCalculations!F38=0,\"\",ScoringCalculations!F38)","v":-8.9999999999999802E-4},{"$f":"IF(ScoringCalculations!G38=0,\"\",ScoringCalculations!G38)","v":1.7199999999999938E-2},0.02]
[{"$f":"\"Proposed Conditions: \"&IF('Project Scoring'!H7=\"ECAT - Change in base SPF\",\"Predicted\",\"Expected\")&\" Crash Frequency\"","v":"Proposed Conditions: Expected Crash Frequency"},null,null,null,null,{"$f":"IF(ScoringCalculations!D39=0,\"\",ScoringCalculations!D39)","v":2.0199999999999999E-2},{"$f":"IF(ScoringCalculations!E39=0,\"\",ScoringCalculations!E39)","v":5.28E-2},{"$f":"IF(ScoringCalculations!F39=0,\"\",ScoringCalculations!F39)","v":6.0900000000000003E-2},{"$f":"IF(ScoringCalculations!G39=0,\"\",ScoringCalculations!G39)","v":0.30930000000000002},0.44]
["Observed Crashes",null,null,null,null,{"$f":"IF(ScoringCalculations!D40=\"\",\"\",ScoringCalculations!D40)","v":0},{"$f":"IF(ScoringCalculations!E40=\"\",\"\",ScoringCalculations!E40)","v":0.5},{"$f":"IF(ScoringCalculations!F40=\"\",\"\",ScoringCalculations!F40)","v":0},{"$f":"IF(ScoringCalculations!G40=\"\",\"\",ScoringCalculations!G40)","v":0.5},1]
["Observed People Injury Totals"]
[null,null,null,null,null,"Fatal Injury  (K)","Serious Injury  (A)","Visible Injury (B)","Non-Visible (C)","Total"]
["Observed People Injury Totals",null,null,null,null,{"$f":"IF(ScoringCalculations!D46=\"\",\"\",ScoringCalculations!D46)","v":0},{"$f":"IF(ScoringCalculations!E46=\"\",\"\",ScoringCalculations!E46)","v":0},{"$f":"IF(ScoringCalculations!F46=\"\",\"\",ScoringCalculations!F46)","v":1.3332999999999999},{"$f":"IF(ScoringCalculations!G46=\"\",\"\",ScoringCalculations!G46)","v":0.5},{"$f":"ROUND(SUM(F33:I33),2)","v":1.83}]
[]
["Application Scoring"]
["Category",null,null,null,null,null,null,"Scoring Value","Points Awarded","Points Possible"]
["Expected Crash Frequency",null,null,null,null,null,null,{"$f":"IF(J27=0,\"\",J27)","v":0.44},{"$f":"IFERROR(VLOOKUP(H37,ScoringTable!AA:AB,2,TRUE),\"\")","v":0},{"$f":"MAX(ScoringTable!AB:AB)","v":10}]
["Ratio of Observed Fatal and Serious Injuries to Observed Total Crashes",null,null,null,null,null,null,{"$f":"IF(J30=0,\"\",ROUND(SUM(ScoringCalculations!D46:E46)/J30,2))","v":0},{"$f":"IFERROR(VLOOKUP(H38,ScoringTable!AC:AD,2,TRUE),\"\")","v":0},{"$f":"MAX(ScoringTable!AD:AD)","v":5}]
["% of the Potential for Safety Improvement to Total Expected Crashes",null,null,null,null,null,null,{"$f":"IF(J27=0,\"\",IF(J28<0,0,IFERROR(ROUND(J28/J27,4),0)))","v":4.5499999999999999E-2},{"$f":"IFERROR(VLOOKUP(H39,ScoringTable!AE:AF,2,TRUE),\"\")","v":8},{"$f":"MAX(ScoringTable!AF:AF)","v":20}]
["Relative Severity Index",null,null,null,null,null,null,{"$f":"IF(ScoringCalculations!B29=0,\"\",ScoringCalculations!B29)","v":24668.01},{"$f":"IFERROR(VLOOKUP(H40,ScoringTable!AG:AH,2,TRUE),\"\")","v":2},{"$f":"MAX(ScoringTable!AH:AH)","v":10}]
["Equivalent Property Damage Only Index",null,null,null,null,null,null,{"$f":"IF(ScoringCalculations!H42=0,\"\",ScoringCalculations!H42/IF(ScoringCalculations!H37=0,ScoringCalculations!H40,ScoringCalculations!H37))","v":3.9090909090909092},{"$f":"IFERROR(VLOOKUP(H41,ScoringTable!AI:AJ,2,TRUE),\"\")","v":3},{"$f":"MAX(ScoringTable!AJ:AJ)","v":5}]
["Volume to Capacity Ratio",null,null,null,null,null,null,{"$f":"IF(ScoringCalculations!D59=\"\",\"\",ScoringCalculations!D59)","v":0.5},{"$f":"IFERROR(VLOOKUP(H42,ScoringTable!AM:AN,2,TRUE),\"\")","v":0},{"$f":"MAX(ScoringTable!AN:AN)","v":10}]
["Benefit Cost Ratio",null,null,null,null,null,null,{"$f":"IF(ScoringCalculations!D54=\"Unable to Calculate\",\"\",ScoringCalculations!D54)","v":0},{"$f":"IFERROR(IF(H43<0,0,VLOOKUP(H43,ScoringTable!AO:AP,2,TRUE)),\"\")","v":0},{"$f":"MAX(ScoringTable!AP:AP)","v":30}]
["Safety Funding Request Percentage",null,null,null,null,null,null,{"$f":"IF(SUM(J73:J74)=0,\"\",ROUND(SUM(J73:J74)/J83,4))","v":0.34210000000000002},{"$f":"IFERROR(VLOOKUP(H44,ScoringTable!AQ:AR,2,TRUE),\"\")","v":10},{"$f":"MAX(ScoringTable!AR:AR)","v":10}]
["Total",null,null,null,null,null,null,null,{"$f":"IF(SUM(I37:I44)=0,\"\",SUM(I37:I44))","v":23},{"$f":"SUM(J37:J44)","v":100}]
[]
["Strategic Highway Safety Plan"]
["Functional Class",null,null,null,"Interstates"]
["Major Route AADT",null,null,null,95340]
["Ohio Emphasis Area",null,null,null,"Emphasis Area IV - Special Vehicles/Roadway Users"]
["Ohio Emphasis Area Subcategory",null,null,null,"Pedestrians"]
["FHWA Emphasis Area",null,null,null,"Making walking and street crossing easier"]
["FHWA Improvement Category",null,null,null,"Pedestrians and bicyclists"]
["FHWA Improvement Subcategory",null,null,null,"Install sidewalk"]
[]
["Work Locations"]
["NLFID",null,"Begin Logpoint","End \nLogpoint","Begin \nLatitude","Begin Longitude","Location Termini\n(i.e. from Street 1 to Street 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EndLatitude","EndLongitude"]
["SFRAIR00070**C",null,20.29,null,39.933999999999997,-82.897999999999996,"Courtright Rd overpass",null,null,null,{"$f":"IF(OR(E58=\"\",F58=\"\"),\"\",HYPERLINK(CONCATENATE(\"http://maps.google.com/maps?q=\",+E58,\",+\",+F58,\"+(Begin Project)&iwloc=A&hl=en\"),\"Google Map\"))","v":"Google Map"},null,{"$f":"IF(OR(E58=\"\",F58=\"\"),\"\",HYPERLINK(CONCATENATE(\"http://bing.com/maps/default.aspx?rtop=1~0&rtp=pos.\",E58,\"_\",F58,\"_\",\"Begin Project\"),\"Bing Maps\"))","v":"Bing Maps"},null,{"$f":"IF(A58=\"\",\"\",IF(OR(MID(A58,5,2)=\"IR\",MID(A58,5,2)=\"SR\",MID(A58,5,2)=\"US\"),IF(RIGHT(A58,1)=\"C\",HYPERLINK(\"http://pathweb.pathwayservices.com/ohiopublic/?nlfid='\"&A58&\"'&logpoint=\"&C58,\"Pathway Images\"),\"Not Available\"),\"Not Available\"))","v":"Pathway Images"}]
["CFRACR00114**C",null,2.0499999999999998,2.35,39.932000000000002,-82.897999999999996,"Groves Rd to Deshler Ave",null,null,null,{"$f":"IF(OR(E59=\"\",F59=\"\"),\"\",HYPERLINK(CONCATENATE(\"http://maps.google.com/maps?q=\",+E59,\",+\",+F59,\"+(Begin Project)&iwloc=A&hl=en\"),\"Google Map\"))","v":"Google Map"},null,{"$f":"IF(OR(E59=\"\",F59=\"\"),\"\",HYPERLINK(CONCATENATE(\"http://bing.com/maps/default.aspx?rtop=1~0&rtp=pos.\",E59,\"_\",F59,\"_\",\"Begin Project\"),\"Bing Maps\"))","v":"Bing Maps"},null,"Not Available"]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,"",null,""]
[]
["Project Funding"]
["Project Phase",null,null,"Safety Study","Interchange Mod. Study","PE - Environmental","PE - Detailed Design","Right of Way /Utilities","Construction","Total"]
["Fiscal Year",null,null,null,null,2020,2020,2021,2022]
["Project Phase Completed",null,null,null,null,null,null,null,"N/A"]
["Previous Safety",null,null,null,null,null,null,null,null,{"$f":"SUM(D73:I73)","v":0}]
["New Safety",null,null,null,null,null,null,null,1300000,{"$f":"SUM(D74:I74)","v":1300000}]
["Sponsor Funding",null,null,null,null,null,null,null,2500000,2500000]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D73:D82)","v":0},{"$f":"SUM(E73:E82)","v":0},0,0,0,3800000,3800000]
["Additional Funding Detail"]
["Other funds used to replace bridge deck and superstructure."]
[]
["Project Development"]
["Project Phase",null,null,null,"Completed by",null,null,"Completion Date"]
["Safety Study"]
["Interchange Modification Study"]
["PE-Environmental"]
["PE-Detailed Design"]
["Right of Way / Utilities"]
[]
["Applicant Information"]
["Name",null,null,null,null,"Title",null,null,"Phone Number"]
["Drew Hurst",null,null,null,null,"Traffic Safety Engineer",null,null,{"$f":"IF(D6=\"\",\"\",D6)","v":"740-833-8345"}]
["Signature",null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-05-07T16:56:40.090"}]
[]
[null,null,null,null,null,null,null,null,"Version:",20150917]
["The following information should be included in submission of the safety project application:\n1. An electronic copy of the Safety Engineering Study\n2. All Excel Analysis Files\n      May include Crash Analysis Module (CAM) Tool, Economic Crash Analysis Tool (ECAT), HSIP Application and Scoring Tool.\n3. Benefit-Cost Results (Economic Analysis)\n4. DSRT approval signatures"]
[]
["ODOT Use Only:"]
["Application ID:"]
["201905D06-04"]
["Document Library on Odrive:"]
["O:\\SAFETY\\D06\\SAFETY APPLICATIONS\\FRA-70-20.29"]

{"sheet":"DSRTSignature","index":2,"n_rows":47,"n_cols":27,"rows_kept":47,"cut":false,"hidden":true,"merged":[[3,0,3,2],[3,3,3,9],[0,0,0,9],[1,0,1,2],[1,3,1,9],[2,0,2,2],[2,3,2,9],[23,0,23,4],[8,0,8,9],[9,0,9,9],[4,0,4,2],[4,3,4,9],[5,0,5,2],[5,3,5,9],[6,0,6,2],[6,3,6,9],[10,0,10,9],[11,0,11,9],[12,0,12,9],[17,0,17,4],[17,5,17,7],[13,0,13,9],[14,0,14,9],[46,0,46,9],[41,0,41,9],[42,0,42,4],[42,5,42,7],[43,0,43,4],[43,5,43,7],[44,0,44,7],[44,8,44,9],[45,0,45,7],[45,8,45,9],[40,0,40,7],[40,8,40,9],[35,0,35,7],[36,0,36,9],[34,0,34,7],[34,8,34,9],[35,8,35,9],[39,8,39,9],[37,0,37,4],[37,5,37,7],[38,0,38,4],[38,5,38,7],[39,0,39,7],[30,0,30,7],[24,8,24,9],[25,0,25,7],[29,8,29,9],[29,0,29,7],[30,8,30,9],[25,8,25,9],[26,0,26,9],[16,0,16,9],[27,0,27,4],[27,5,27,7],[28,0,28,4],[28,5,28,7],[23,5,23,7],[24,0,24,7],[19,0,19,7],[19,8,19,9],[20,0,20,7],[20,8,20,9],[18,0,18,4],[18,5,18,7],[21,0,21,9],[22,0,22,4],[22,5,22,7],[31,0,31,9],[32,0,32,4],[32,5,32,7],[33,0,33,4],[33,5,33,7]]}
["General Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show Conditional Format:","Yes"]
["Project Sponsoring Agency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lat Long Format:","Yes"]
["Project Name",null,null,"","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priority Rank Format:","Yes"]
["PID",null,null,"","","","","","",""]
["Project Manager"]
["Contact Phone"]
["Contact Email"]
[]
["Project Description"]
["Summary of Crash Patterns"]
[]
["Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures","Summary of Recommended Countermeasures"]
[]
["Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information","Project Priority Information"]
[]
[]
["District Safety Review Team Signatures"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Planning & Engineering Administrator",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Highway Management Adminstrator",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Design Engineer",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Planning Manager",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Traffic Engineer",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]
["Name",null,null,null,null,"Title",null,null,"Approve","Disapprove"]
[null,null,null,null,null,"Other",null,null,"¨","¨"]
["Signature",null,null,null,null,null,null,null,"Date"]
[]
["Comments:"]

{"sheet":"Project Scoring","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,0,5,1],[5,2,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,9],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,9],[4,0,4,1],[4,2,4,4],[4,5,4,6],[4,7,4,9],[0,0,0,9],[1,0,1,9],[2,0,2,1],[2,2,2,4],[2,5,2,6],[2,7,2,9],[16,1,16,6],[8,1,8,6],[18,1,18,7],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[10,1,10,6],[9,1,9,6],[11,1,11,6]]}
["Project Scoring Summary"]
["General Project Information"]
["Project Name",null,"FRA-70",null,null,"Contact Email"]
["Project Description",null,"add sidewalk to overpass",null,null,"Contact Phone"]
["Reference Number",null,1,null,null,"Date Performed"]
["Analyst",null,null,null,null,"Analysis Year"]
["Agency/Company",null,null,null,null,"Analysis Type Performed",null,"ECAT - No Change in base SPF"]
[]
[null,"Category",null,null,null,null,null,"Value","Points Awarded"]
[null,"Expected Crash Frequency",null,null,null,null,null,{"$f":"IF('Safety Application'!H37=\"\",\"\",'Safety Application'!H37)","v":0.44},{"$f":"IF('Safety Application'!I37=\"\",\"\",'Safety Application'!I37)","v":0}]
[null,"Ratio of Observed Fatal and Serious Injuries to Observed Total Crashes",null,null,null,null,null,{"$f":"IF('Safety Application'!H38=\"\",\"\",'Safety Application'!H38)","v":0},{"$f":"IF('Safety Application'!I38=\"\",\"\",'Safety Application'!I38)","v":0}]
[null,"% of the Potential for Safety Improvement to Total Expected Crashes",null,null,null,null,null,{"$f":"IF('Safety Application'!H39=\"\",\"\",'Safety Application'!H39)","v":4.5499999999999999E-2},{"$f":"IF('Safety Application'!I39=\"\",\"\",'Safety Application'!I39)","v":8}]
[null,"Relative Severity Index",null,null,null,null,null,{"$f":"IF('Safety Application'!H40=\"\",\"\",'Safety Application'!H40)","v":24668.01},{"$f":"IF('Safety Application'!I40=\"\",\"\",'Safety Application'!I40)","v":2}]
[null,"Equivalent Property Damage Only Index",null,null,null,null,null,{"$f":"IF('Safety Application'!H41=\"\",\"\",'Safety Application'!H41)","v":3.9090909090909092},{"$f":"IF('Safety Application'!I41=\"\",\"\",'Safety Application'!I41)","v":3}]
[null,"Volume to Capacity Ratio",null,null,null,null,null,{"$f":"IF('Safety Application'!H42=\"\",\"\",'Safety Application'!H42)","v":0.5},{"$f":"IF('Safety Application'!I42=\"\",\"\",'Safety Application'!I42)","v":0}]
[null,"Benefit Cost Ratio",null,null,null,null,null,{"$f":"IF('Safety Application'!H43=\"\",\"\",'Safety Application'!H43)","v":0},{"$f":"IF('Safety Application'!I43=\"\",\"\",'Safety Application'!I43)","v":0}]
[null,"Safety Funding Request Percentage",null,null,null,null,null,{"$f":"IF('Safety Application'!H44=\"\",\"\",'Safety Application'!H44)","v":0.34210000000000002},{"$f":"IF('Safety Application'!I44=\"\",\"\",'Safety Application'!I44)","v":10}]
[]
[null,"Safety Application Score",null,null,null,null,null,null,{"$f":"SUM(I10:I17)","v":23}]

{"sheet":"ScoringCalculations","index":4,"n_rows":59,"n_cols":35,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,3,2],[5,0,5,5],[0,0,0,5],[33,0,33,7],[28,1,28,2],[32,0,32,7],[43,0,43,7],[44,0,44,2],[45,0,45,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[39,0,39,2],[38,0,38,2],[41,0,41,2],[40,0,40,2],[58,0,58,2],[57,0,57,3],[48,0,48,7],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[43,26,43,28],[33,26,33,33],[34,26,34,28],[35,26,35,28],[36,26,36,28],[37,26,37,28],[38,26,38,28],[40,26,40,33],[41,26,41,28],[42,26,42,28]]}
["Relative Severity Index Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Sites"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLFID:",null,null,null,"FindTruck",0,null,null,"HSM Elements Only"]
["Site 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,"Blog:",null,null,null,"FindVC",0,null,null,"Observed Elements Only"]
["Urban Non-Freeway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elog:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WAADT:"]
["Fill in the Number of Crashes by 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,"WAADTT:"]
["Crash Type","Number of Crashes","Crash Type Severity Calc","Rural Non-Freeway","Urban Non-Freeway","Freeway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WVCRatio:"]
["Not Stated",8.9999999999999998E-4,{"$f":"IF($A$4=\"\",\"\",IF($A$4=D$7,B8*D8,IF($A$4=E$7,B8*E8,IF($A$4=F$7,B8*F8))))","v":29.321330808950087},57175.982758620688,32579.256454388986,20119.272727272728,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TotalLength:"]
["Head On",3.1000000000000003E-3,{"$f":"IF($A$4=\"\",\"\",IF($A$4=D$7,B9*D9,IF($A$4=E$7,B9*E9,IF($A$4=F$7,B9*F9))))","v":265.67335007743208},271494.18433670752,85701.080670139374,249708.12738853504,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Functional Class:",null,{"$f":"IFERROR(VLOOKUP(AB9,RefTables!E27:F34,2,FALSE),\"Other\")","v":"Other"}]
["Rear End",0.18820000000000001,3725.7547590397267,29092.43537414966,19796.784054408748,23786.410013252833,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truck %:",{"$f":"IFERROR(ROUND(AB6/AB5,4),\"\")","v":""}]
["Backing",9.1000000000000004E-3,104.46308875099443,13986.433275563259,11479.460302307079,14260.695249130938]
["Sideswipe - Meeting",1.5899999999999997E-2,513.43029266081032,58652.003942440373,32291.213374893738,54020.501940491595]
["Sideswipe - Passing",3.6799999999999999E-2,543.9528012676476,29066.041413515188,14781.326121403466,19413.608245495128]
["Angle",1.9300000000000001E-2,496.13362955571159,57046.96055979644,25706.405676461738,33071.52156699312]
["Parked Vehicle",4.2000000000000003E-2,700.83442061575261,35937.319115734717,16686.533824184586,26992.086463118078]
["Pedestrian",1.6300000000000002E-2,2022.5681868808012,233843.96984924623,124083.93784544792,361506.54545454547]
["Animal",0.11330000000000001,1248.5979938612647,11933.13039348711,11020.282381829344,11682.503698645727]
["Train",0,0,246848.16,96186.178010471209,12417.846153846154]
["Pedalcycles",4.4000000000000003E-3,307.20209912536444,143918.04109589042,69818.658892128282,64977.652892561986]
["Other Non-Vehicle",0,0,108688.41025641025,19875.428571428572,11696]
["Fixed Object",8.8999999999999996E-2,3159.0685932748434,44241.784379187389,35495.15273342521,31807.092549175442]
["Other Object",4.7999999999999996E-3,102.4320473489519,20701.672727272726,21340.00986436498,13042.35049401976]
["Overturning",2.3E-3,176.14297114427862,84936.813961145861,76583.900497512441,75106.516154145589]
["Other Non-Collision",6.7999999999999996E-3,164.24159305245863,21907.63573085847,24153.175448890976,15969.351374644488]
["Left Turn",4.3E-3,167.9302293429343,88417.336671978148,39053.54170765914,36359.089999999997]
["Right Turn",0,0,{"$f":"D14","v":57046.96055979644},{"$f":"E14","v":25706.405676461738},33071.52156699312]
["Totals",{"$f":"SUM(B8:B26)","v":0.55649999999999999},{"$f":"SUM(C8:C26)","v":13727.747386807921}]
[]
["RSI Value = ",{"$f":"IF(ISERROR(C27/(B27)),VALUE(0),ROUND(C27/(B27),2))","v":24668.01}]
[]
[]
[]
["All Sites"]
["Crash Frequencies Per Year Summary Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project EB Method Summary Results (Without Animal Crashes)"]
[null,null,null,"KA","B","C","O","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KA","B","C","O","Total"]
["Existing Conditions: Predicted Crash Frequency",null,null,{"$f":"IF($AH$36+$AH$43=0,\"\",IF($A$33=$AI$3,AD43,IF($A$33=$AI$2,AD36,AD36+AD43)))","v":2.0399999999999998E-2},{"$f":"IF($AH$36+$AH$43=0,\"\",IF($A$33=$AI$3,AE43,IF($A$33=$AI$2,AE36,AE36+AE43)))","v":5.0900000000000001E-2},6.1800000000000008E-2,0.29210000000000003,{"$f":"ROUND(SUM(D36:G36),2)","v":0.43},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Conditions: Predicted Crash Frequency",null,null,2.0399999999999998E-2,5.0900000000000001E-2,6.1800000000000008E-2,0.29210000000000003,0.42520000000000002]
["Existing Conditions: Expected Crash Frequency",null,null,{"$f":"IF($AH$37+$AH$43=0,\"\",IF($A$34=$AI$3,AD43,IF($A$34=$AI$2,AD37,AD37+AD43)))","v":2.0199999999999999E-2},{"$f":"IF($AH$37+$AH$43=0,\"\",IF($A$34=$AI$3,AE43,IF($A$34=$AI$2,AE37,AE37+AE43)))","v":5.28E-2},6.090000000000001E-2,0.30929999999999996,0.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Conditions: Expected Crash Frequency",null,null,2.0199999999999999E-2,5.28E-2,6.090000000000001E-2,0.30929999999999996,0.44319999999999998]
["Potential for Safety Improvement",null,null,{"$f":"IF($AH$36+$AH$43=0,\"\",D37-D36)","v":-1.9999999999999879E-4},{"$f":"IF($AH$36+$AH$43=0,\"\",E37-E36)","v":1.8999999999999989E-3},-8.9999999999999802E-4,1.7199999999999938E-2,0.02,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potential for Safety Improvement",null,null,-1.9999999999999879E-4,1.8999999999999989E-3,-8.9999999999999802E-4,1.7199999999999938E-2,1.799999999999996E-2]
[{"$f":"\"Proposed Conditions: \"&IF('Project Scoring'!$H$7=\"ECAT - Change in base SPF\",\"Predicted\",\"Expected\")&\" Crash Frequency\"","v":"Proposed Conditions: Expected Crash Frequency"},null,null,{"$f":"IF($AH$39+$AH$44=0,\"\",IF($A$36=$AI$3,AD44,IF($A$36=$AI$2,AD39,AD39+AD44)))","v":2.0199999999999999E-2},{"$f":"IF($AH$39+$AH$44=0,\"\",IF($A$36=$AI$3,AE44,IF($A$36=$AI$2,AE39,AE39+AE44)))","v":5.28E-2},6.0900000000000003E-2,0.30930000000000002,0.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Proposed Conditions: \"&IF('Project Scoring'!$H$7=\"ECAT - Change in base SPF\",\"Predicted\",\"Expected\")&\" Crash Frequency\"","v":"Proposed Conditions: Expected Crash Frequency"},null,null,2.0199999999999999E-2,5.28E-2,6.0900000000000003E-2,0.30930000000000002,0.44320000000000004]
["Observed Crashes",null,null,0,0.5,0,0.5,1]
["Equivalent Property Damage Only Cost",null,null,39.24,6.55,4.4400000000000004,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project EB Method Summary Results (Without Animal Crashes)"]
["Equivalent Property Damage Only Value",null,null,{"$f":"IF($H$37=0,D41*D40,D37*D41)","v":0.79264800000000002},{"$f":"IF($H$37=0,E41*E40,E37*E41)","v":0.34583999999999998},0.27039600000000008,0.30929999999999996,{"$f":"ROUND(SUM(D42:G42),2)","v":1.72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KA","B","C","O","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Conditions Observed Crashes",null,null,0,0,0,0,0]
["People Injuries Per Year Summary Results ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proposed Conditions Observed Crashes",null,null,0,0,0,0,0]
[null,null,null,"K","A","B","C","Total"]
["Observed Totals",null,null,0,0,1.3332999999999999,0.5,{"$f":"ROUND(SUM(D46:G46),2)","v":1.83}]
[]
[]
["Benefit - Cost Ratio Calculations"]
[]
[null,null,"Net Present Value of Project",1]
[null,null,"Net Present Value of Safety Benefits",0]
[null,null,"Net Benefit",-1]
[null,null,"Benefit / Cost Ratio",0]
[]
[]
[]
["Traffic Criteria"]
["Volume to Capacity Ratio",null,null,0.5]

{"sheet":"ScoringTable","index":5,"n_rows":40,"n_cols":44,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,9,39,9],[36,9,37,9],[1,40,1,41],[2,6,2,7],[2,8,2,9],[0,40,0,43],[1,42,1,43],[0,0,0,9],[0,26,0,35],[0,36,0,39],[1,26,1,27],[1,28,1,29],[1,30,1,31],[1,32,1,33],[1,34,1,35],[1,36,1,37],[1,38,1,39],[1,0,1,9],[2,0,2,1],[2,2,2,3],[2,4,2,5],[22,0,22,1],[21,0,21,1],[21,2,21,5],[22,2,22,3],[22,4,22,5]]}
["ODOT Highway Safety Improvement Program (HSIP) Scoring Matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Safety Criteria",null,null,null,null,null,null,null,null,null,"Traffic Criteria",null,null,null,"Economic Analysis"]
["Safety Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Crash Frequency",null,"Ratio of Observed Fatal and Serious Injuries to Observed Total Crashes",null,"Percentage of the Potential for Safety Improvement to Total Expected Crashes",null,"Relative Severity Index",null,"Equivalent Property Damage Only Index",null,"Truck Percentage",null,"Volume to Capacity Ratio",null,"Benefit Cost Ratio",null,"Safety Request Percentage"]
["Expected Crash Frequency",null,"Ratio of Observed Fatal and Serious Injuries to Observed Total Crashes",null,"Percentage of the Potential for Safety Improvement to Total Expected Crashes",null,"Relative Severity Index",null,"Equivalent Property Damage Only Index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value","Points","Value","Points","Value","Points","Value","Points","Value","Points","Value","Points","Value","Points","Value","Points","Value","Points"]
["Value","Points","Value","Points","Value","Points","Value","Points","Value","Points",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,0,0,0,0,0,0,0,10]
[{"$f":"\"< \"&AA5","v":"< 3"},{"$f":"IF(AB4=\"\",\"\",AB4)","v":0},{"$f":"\"< \"&AC5","v":"< 0.01"},{"$f":"IF(AD4=\"\",\"\",AD4)","v":0},{"$f":"\"< \"&AE5*100&\"%\"","v":"< 1%"},{"$f":"IF(AF4=\"\",\"\",AF4)","v":0},{"$f":"\"< \"&TEXT(AG5,\"00,000\")","v":"< 20,000"},{"$f":"IF(AH4=\"\",\"\",AH4)","v":0},{"$f":"\"< \"&AI5","v":"< 1"},{"$f":"IF(AJ4=\"\",\"\",AJ4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,2,0.01,1,0.01,2,20000,2,1,1,0.01,null,0.55000000000000004,2,1,3,0.7,8]
[{"$f":"AA5&\"-\"&AA6-0.01","v":"3-5.99"},{"$f":"IF(AB5=\"\",\"\",AB5)","v":2},"0.01-0.02",1,{"$f":"AE5*100&\"-\"&(AE6-0.0001)*100&\"%\"","v":"1-1.99%"},2,{"$f":"TEXT(AG5,\"00,000\")&\"-\"&TEXT(AG6-0.01,\"00,000.00\")","v":"20,000-24,999.99"},2,"1-1.99",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"AB5+2","v":4},0.03,2,0.02,4,25000,4,2,2,0.02,null,{"$f":"AM5+0.1","v":0.65},4,{"$f":"AO5+0.15","v":1.1499999999999999},6,0.75,6]
["6-8.99",4,"0.03-0.04",2,{"$f":"AE6*100&\"-\"&(AE7-0.0001)*100&\"%\"","v":"2-2.99%"},4,{"$f":"TEXT(AG6,\"00,000\")&\"-\"&TEXT(AG7-0.01,\"00,000.00\")","v":"25,000-29,999.99"},4,"2-2.99",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"AB6+2","v":6},0.05,3,0.03,6,30000,6,3,3,0.03,null,{"$f":"AM6+0.1","v":0.75},6,{"$f":"AO6+0.15","v":1.2999999999999998},9,0.8,4]
["9-11.99",6,"0.05-0.06",3,"3-3.99%",6,"30,000-34,999.99",6,"3-3.99",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,8,7.0000000000000007E-2,4,0.04,8,35000,8,4,4,0.04,null,0.85,8,1.4499999999999997,12,0.85,2]
["12-14.99",8,"0.07-0.08",4,"4-4.99%",8,"35,000-39,999.99",8,"4-4.99",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,10,0.09,5,0.05,10,40000,10,5,5,0.05,null,0.95,10,1.5999999999999996,15,0.9,0]
[{"$f":"\"≥ \"&AA9","v":"≥ 15"},10,{"$f":"\"≥ \"&AC9","v":"≥ 0.09"},5,"5-5.99%",10,{"$f":"\"≥ \"&TEXT(AG9,\"00,000\")","v":"≥ 40,000"},10,{"$f":"\"≥ \"&AI9","v":"≥ 5"},5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.0000000000000005E-2,12,null,null,null,null,null,null,null,null,1.7499999999999996,18,null,{"$f":"IF(BR9=\"\",\"\",BR9)","v":""}]
[null,"",null,"","6-6.99%",12,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,14,null,null,null,null,null,null,null,null,1.8999999999999995,21,null,""]
[null,"",null,"","7-7.99%",14,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,16,null,null,null,null,null,null,null,null,2.0499999999999994,24,null,""]
[null,"",null,"","8-8.99%",16,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,18,null,null,null,null,null,null,null,null,2.1999999999999993,27,null,""]
[null,"",null,"","9-9.99%",18,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999992E-2,20,null,null,null,null,null,null,null,null,2.3499999999999992,30,null,""]
[null,"",null,"",{"$f":"\"≥ \"&AE14*100&\"%\"","v":"≥ 10%"},20,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"",null,"",null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
["Traffic Criteria",null,"Economic Analysis"]
["Volume to Capacity Ratio",null,"Benefit Cost Ratio",null,"Safety Request Percentage"]
["Value","Points","Value","Points","Value","Points"]
[{"$f":"\"< \"&AM5","v":"< 0.55"},{"$f":"IF(AN4=\"\",\"\",AN4)","v":0},{"$f":"\"< \"&AO5","v":"< 1"},{"$f":"IF(AP4=\"\",\"\",AP4)","v":0},{"$f":"\"< \"&AQ5*100&\"%\"","v":"< 70%"},{"$f":"IF(AR4=\"\",\"\",AR4)","v":10}]
[{"$f":"AM5&\"-\"&AM6-0.01","v":"0.55-0.64"},2,{"$f":"AO5&\"-\"&AO6-0.01","v":"1-1.14"},3,{"$f":"AQ5*100&\"-\"&(AQ6-0.0001)*100&\"%\"","v":"70-74.99%"},8]
[{"$f":"AM6&\"-\"&AM7-0.01","v":"0.65-0.74"},4,"1.15-1.29",6,{"$f":"AQ6*100&\"-\"&(AQ7-0.0001)*100&\"%\"","v":"75-79.99%"},6]
[{"$f":"AM7&\"-\"&AM8-0.01","v":"0.75-0.84"},6,"1.3-1.44",9,{"$f":"AQ7*100&\"-\"&(AQ8-0.0001)*100&\"%\"","v":"80-84.99%"},4]
[{"$f":"AM8&\"-\"&AM9-0.01","v":"0.85-0.94"},8,"1.45-1.59",12,{"$f":"AQ8*100&\"-\"&(AQ9-0.0001)*100&\"%\"","v":"85-89.99%"},2]
[{"$f":"\"≥ \"&AM9","v":"≥ 0.95"},10,"1.6-1.74",15,{"$f":"\"≥ \"&AQ9*100&\"%\"","v":"≥ 90%"},0]
[null,"","1.75-1.89",18,null,""]
[null,"","1.9-2.04",21,null,""]
[null,"","2.05-2.19",24,null,""]
[null,"","2.2-2.34",27,null,""]
[null,"",{"$f":"\"≥ \"&AO14","v":"≥ 2.35"},30,null,""]
[null,null,null,""]
[null,null,null,"",null,null,null,null,null,"Total Points"]
[null,null,null,""]
[null,null,null,"",null,null,null,null,null,{"$f":"SUM(MAX(AB4:AB1000),MAX(AD4:AD1000),MAX(AF4:AF1000),MAX(AH4:AH1000),MAX(AJ4:AJ1000),MAX(AL4:AL1000),MAX(AN4:AN1000),MAX(AP4:AP1000),MAX(AR4:AR1000))","v":100}]
[null,null,null,""]

{"sheet":"RefTables","index":6,"n_rows":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
["County Code","District Number",null,"Ohio SHSP Emphasis Area",null,"FHWA SHSP Emphasis Area",null,"Improvement Type","Access management","Advanced technology and ITS","Alignment","Interchange design","Intersection geometry"]
["ADA",9,null,"Emphasis Area I - Data and Support Systems",null,"Creating more effective processes and safety management systems",null,"Access management",null,null,"Alignment - other","Acceleration / deceleration / merge lane"]
["ALL",1,null,"Emphasis Area II - Serious Crash Types",null,"Curbing aggressive driving",null,"Advanced technology and ITS","Access management - other","AdvancedtechnologyandITS","Horizontal curve realignment","Convert at-grade intersection to interchange","Auxiliary lanes - add acceleration lane"]
["ASD",3,null,"Emphasis Area III - High-Risk Behaviors/Drivers",null,"Designing safer work zones",null,"Alignment","Change in access - close or restrict existing access","Advanced technology and ITS - other","Horizontal and vertical alignment","Extend existing lane on ramp","Auxiliary lanes - add auxiliary through lane"]
["ATB",4,null,"Emphasis Area IV - Special Vehicles/Roadway Users",null,"Enhancing emergency medical capabilities to increase survivability",null,"Animal-related","Change in access - miscellaneous/unspecified","Congestion detection / traffic monitoring system","Vertical alignment or elevation change","Improve intersection radius at ramp terminus","Auxiliary lanes - add left-turn lane"]
["ATH",10,null,"Emphasis Area V - Incident and Congestion Related Crashes",null,"Ensuring drivers are licensed and fully competent",null,"Interchange design","Grassed median - extend existing","Dynamic message signs",null,"Installation of new lane on ramp","Auxiliary lanes - add right-turn lane"]
["AUG",7,null,null,null,"Ensuring safer bicycle travel",null,"Intersection geometry","Median crossover - close crossover","Over height vehicle detection","Roadside","Interchange design - other","Auxiliary lanes - add right-turn lane (free-flow)"]
["BEL",11,null,"EmphasisAreaIDataandSupportSystems",null,"Improving information and decision support systems",null,"Intersection traffic control","Median crossover - directional crossover",null,null,"Ramp closure","Auxiliary lanes - add slip lane"]
["BRO",9,null,"Timely Data",null,"Improving motorcycle safety and increasing motorcycle awareness",null,"Lighting","Median crossover - relocate existing",null,"Barrier end treatments (crash cushions, terminals)","Ramp metering","Auxiliary lanes - add two-way left-turn lane"]
["BUT",8,null,"Reliable Data",null,"Improving the design and operation of highway intersections",null,"Miscellaneous","Median crossover - unspecified",null,"Barrier transitions",null,"Auxiliary lanes - extend acceleration/deceleration lane"]
["CAR",11,null,"Comprehensive Data",null,"Increasing driver safety awareness",null,"Non-infrastructure ","Raised island - install new",null,"Barrier - cable",null,"Auxiliary lanes - extend existing left-turn lane"]
["CHP",7,null,"Integrated Data and Analysis Systems",null,"Increasing safety enhancements in vehicles",null,"Parking","Raised island - modify existing",null,"Barrier - concrete",null,"Auxiliary lanes - extend existing right-turn lane"]
["CLA",7,null,null,null,"Increasing seat belt use and improving airbag effectiveness",null,"Pedestrians and bicyclists","Raised island - remove existing",null,"Barrier- metal",null,"Auxiliary lanes - miscellaneous/other/unspecified"]
["CLE",8,null,"EmphasisAreaIISeriousCrashTypes",null,"Instituting graduated licensing for younger drivers",null,"Railroad grade crossings","Raised island - unspecified",null,"Barrier - other",null,"Auxiliary lanes - modify acceleration lane"]
["CLI",8,null,"Roadway Departure Crashes",null,"Keeping drivers alert",null,"Roadside",null,null,"Barrier - removal",null,"Auxiliary lanes - modify auxiliary through lane"]
["COL",11,null,"Intersection Crashes",null,"Keeping vehicles in the roadway",null,"Roadway",null,null,"Curb or curb and gutter",null,"Auxiliary lanes - modify free-flow turn  lane"]
["COS",5,null,"Cross-Median Crashes",null,"Making truck travel safer",null,"Roadway delineation",null,null,"Drainage improvements",null,"Auxiliary lanes - modify left-turn lane offset"]
["CRA",3,null,"Highway/Railroad Crossing Crashes",null,"Making walking and street crossing easier",null,"Roadway signs and traffic control",null,null,"Fencing",null,"Auxiliary lanes - modify right-turn lane offset"]
["CUY",12,null,null,null,"Minimizing the consequences of leaving the road",null,"Shoulder treatments",null,null,"Removal of roadside objects (trees, poles, etc.)",null,"Auxiliary lanes - modify turn lane storage"]
["DAR",7,null,"EmphasisAreaIIIHighRiskBehaviorsDrivers",null,"Reducing head-on and across-median crashes",null,"Speed management",null,null,"Roadside grading",null,"Auxiliary lanes - modify turn lane taper"]
["DEF",1,null,"Occupant Protection Devices – Nonuse and Misuse",null,"Reducing impaired driving",null,"Work Zone",null,null,"Roadside - other",null,"Auxiliary lanes - modify two-way left-turn lane"]
["DEL",6,null,"Impaired by Alcohol",null,"Reducing vehicle-train crashes",null,null,null,null,null,null,"Intersection geometrics - miscellaneous/other/unspecified"]
["ERI",3,null,"Young Driver – 15 to 25",null,"Sustaining proficiency in older drivers",null,null,null,null,null,null,"Intersection geometrics - modify intersection corner radius"]
["FAI",5,null,"Distracted or Fatigued Driver",null,"Other",null,"Animal-related","Intersection traffic control","Lighting","Roadway",null,"Intersection geometrics - modify skew angle"]
["FAY",6,null,"Aggressive Driving",null,null,null,null,null,null,null,null,"Intersection geometrics - realignment to align offset cross streets"]
["FRA",6,null,"Older Driver – 65 or Older",null,"Functional Class",null,null,"Intersection flashers - add \"when flashing\" warning sign-mounted","Continuous roadway lighting","Install / remove / modify passing zone",null,"Intersection geometrics - realignment to increase cross street offset"]
["FUL",2,null,null,1,"Interstates",null,null,"Intersection flashers - add advance emergency vehicle warning sign-mounted","Intersection lighting","Pavement surface - high friction surface",null,"Intersection geometrics - re-assign existing lane use"]
["GAL",10,null,"EmphasisAreaIVSpecialVehiclesRoadwayUsers",2,"Other Freeways or Expressways",null,null,"Intersection flashers - add advance heavy vehicle warning sign-mounted","Lighting - other","Pavement surface - miscellaneous",null,"Intersection geometry - other"]
["GEA",12,null,"Commercial Vehicles",3,"Other Principal Arterial Roadway",null,null,"Intersection flashers - add advance intersection warning sign-mounted","Site lighting - horizontal curve ","Roadway narrowing (road diet, roadway reconfiguration)",null,"Splitter island - install on one or more approaches"]
["GRE",8,null,"Motorcycles",4,"Minor Arterial Roadway",null,null,"Intersection flashers - add miscellaneous/other/unspecified","Site lighting - intersection","Roadway - other",null,"Splitter island - remove from one or more approaches"]
["GUE",5,null,"Bicycles",5,"Major Collector Roadway",null,null,"Intersection flashers - add overhead (actuated)","Site lighting - interchange","Roadway - restripe to revise separation between opposing lanes and/or shoulder widths ",null,"Splitter island - unspecified"]
["HAM",8,null,"Pedestrians",6,"Minor Collector Roadway",null,null,"Intersection flashers - add overhead (continuous)","Site lighting - pedestrian crosswalk","Roadway widening - add lane(s) along segment",null,"Through lanes - add additional through lane"]
["HAN",1,null,null,7,"Local Roadway",null,null,"Intersection flashers - add stop sign-mounted",null,"Roadway widening - curve "]
["HAR",1,null,"EmphasisAreaVIncidentandCongestionRelatedCrashes",99,"Other Roadway",null,null,"Intersection flashers - modify existing",null,"Roadway widening - travel lanes"]
["HAS",11,null,"Rear End Crashes",null,null,null,null,"Intersection flashers - remove existing","Parking","Rumble strips - center"]
["HEN",2,null,"Work Zone Crashes",null,null,null,null,"Intersection signing - add basic advance warning",null,"Rumble strips - edge or shoulder"]
["HIG",9,null,null,null,null,null,null,"Intersection signing - add enhanced advance warning (double-up and/or oversize)","Modify parking","Rumble strips - transverse"]
["HOC",10,null,null,null,null,null,null,"Intersection signing - add enhanced regulatory sign (double-up and/or oversize)","Parking - other","Rumble strips - unspecified or other"]
["HOL",11,null,null,null,null,null,null,"Intersection signing - miscellaneous/other/unspecified","Remove parking","Superelevation / cross slope"]
["HUR",3,null,null,null,null,null,null,"Intersection signing - relocate existing regulatory sign","Restrict parking"]
["JAC",9,null,null,null,null,null,null,"Intersection traffic control - other","Truck parking facilities"]
["JEF",11,null,null,null,null,null,null,"Modify control - all-way stop to roundabout"]
["KNO",5,null,null,null,null,null,null,"Modify control - modifications to roundabout","Pedestrians and bicyclists","Roadway delineation"]
["LAK",12,null,null,null,null,null,null,"Modify control - no control to roundabout"]
["LAW",9,null,null,null,null,null,null,"Modify control - no control to two-way stop","Crosswalk","Improve retroreflectivity"]
["LIC",5,null,null,null,null,null,null,"Modify control - remove right-turn yield","Install new \"smart\" crosswalk","Longitudinal pavement markings - new"]
["LOG",7,null,null,null,null,null,null,"Modify control - reverse priority of stop condition","Install new crosswalk","Longitudinal pavement markings - remarking"]
["LOR",3,null,null,null,null,null,null,"Modify control - traffic signal to roundabout","Install sidewalk","Delineators post-mounted or on barrier "]
["LUC",2,null,null,null,null,null,null,"Modify control - two-way stop to all-way stop","Medians and pedestrian refuge areas","Raised pavement markers"]
["MAD",6,null,null,null,null,null,null,"Modify control - two-way stop to signal operation","Miscellaneous pedestrians and bicyclists","Roadway delineation - other"]
["MAH",4,null,null,null,null,null,null,"Modify control - two-way stop to roundabout","Modify existing crosswalk"]
["MAR",6,null,null,null,null,null,null,"Modify control - two-way yield to two-way stop","Pedestrian beacons"]
["MED",3,null,null,null,null,null,null,"Pavement Markings - add advance signal ahead","Pedestrian bridge","Roadway signs and traffic control"]
["MEG",10,null,null,null,null,null,null,"Pavement markings - add advance stop ahead","Pedestrian signal"]
["MER",7,null,null,null,null,null,null,"Pavement markings - add dashed edge line along mainline","Pedestrian signal - audible device","Curve-related warning signs and flashers"]
["MIA",7,null,null,null,null,null,null,"Pavement markings - add lane use symbols","Pedestrian signal - Pedestrian Hybrid Beacon","Sign sheeting - upgrade or replacement"]
["MOE",10,null,null,null,null,null,null,"Pavement markings - add stop line","Pedestrian signal - install new at intersection","Roadway signs and traffic control - other"]
["MOT",7,null,null,null,null,null,null,"Pavement markings - add yield line","Pedestrian signal - install new at non-intersection location","Roadway signs (including post) - new or updated"]
["MRG",10,null,null,null,null,null,null,"Pavement markings - miscellaneous/other/unspecified","Pedestrian signal - modify existing"]
["MRW",6,null,null,null,null,null,null,"Pavement markings - refresh existing pavement markings","Pedestrian signal - remove existing"]
["MUS",5,null,null,null,null,null,null,"Modify traffic signal - add additional signal heads","Pedestrian warning signs - add/modify flashers"]
["NOB",10,null,null,null,null,null,null,"Modify traffic signal - add backplates","Pedestrian warning signs - overhead"]
["OTT",2,null,null,null,null,null,null,"Modify traffic signal - add backplates with retroreflective borders"]
["PAU",1,null,null,null,null,null,null,"Modify traffic signal - add closed loop system","Railroad grade crossings"]
["PER",5,null,null,null,null,null,null,"Modify traffic signal - add emergency vehicle preemption"]
["PIC",6,null,null,null,null,null,null,"Modify traffic signal - add flashing yellow arrow","Grade separation"]
["PIK",9,null,null,null,null,null,null,"Modify traffic signal - add long vehicle detection","Model enforcement activity"]
["POR",4,null,null,null,null,null,null,"Modify traffic signal - add railroad preemption","Protective devices"]
["PRE",8,null,null,null,null,null,null,"Modify traffic signal - add wireless system","Railroad grade crossing gates"]
["PUT",1,null,null,null,null,null,null,"Modify traffic signal - miscellaneous/other/unspecified","Railroad grade crossing signing"]
["RIC",3,null,null,null,null,null,null,"Modify traffic signal - modernization/replacement","Railroad grade crossings - other","Speed management"]
["ROS",9,null,null,null,null,null,null,"Modify traffic signal - modify signal mounting (spanwire to mast arm)","Surface treatment"]
["SAN",2,null,null,null,null,null,null,"Modify traffic signal - remove existing signal","Upgrade railroad crossing signal","Modify speed limit"]
["SCI",9,null,null,null,null,null,null,"Modify traffic signal - replace existing indications (incandescent-to-LED and/or 8-to-12 inch dia.)","Widen crossing for additional lane","Radar speed signs"]
["SEN",2,null,null,null,null,null,null,"Modify traffic signal timing - left-turn phasing (permissive to protected/permissive)",null,"Speed detection system / truck warning"]
["SHE",7,null,null,null,null,null,null,"Modify traffic signal timing - left-turn phasing (permissive to protected-only)",null,"Speed management - other"]
["STA",4,null,null,null,null,null,null,"Modify traffic signal timing - adjust clearance interval (yellow change and/or all-red)",null,"Traffic calming feature"]
["SUM",4,null,null,null,null,null,null,"Modify traffic signal timing - general retiming"]
["TRU",4,null,null,null,null,null,null,"Modify traffic signal timing - signal coordination"]
["TUS",11,null,null,null,null,null,null,"Systemic improvements - signal-controlled"]
["UNI",6,null,null,null,null,null,null,"Systemic improvements - stop-controlled","Miscellaneous"]
["VAN",1]
["VIN",10]
["WAR",8]
["WAS",10,null,null,null,null,null,"Non-infrastructure ","Shoulder treatments","Work Zone"]
["WAY",3,null,null,null,null,null,"Educational efforts","Widen shoulder – paved or other"]
["WIL",2,null,null,null,null,null,"Enforcement","Pave existing shoulders"]
["WOO",2,null,null,null,null,null,"Data/traffic records","Shoulder grading"]
["WYA",1,null,null,null,null,null,"Non-infrastructure - other","Shoulder treatments - other"]
[null,null,null,null,null,null,null,"Outreach"]
[null,null,null,null,null,null,null,"Road safety audits"]
[null,null,null,null,null,null,null,"Training and workforce development"]
[null,null,null,null,null,null,null,"Transportation safety planning"]

{"sheet":"CMS","index":7,"n_rows":5,"n_cols":15,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["NLF_ID","LOGPOINT_COUNTY_NBR","BTRS_CONGESTION_SEGMENTS6.LOGPOINT_COUNTY_NBR+BTRS_CONGESTION_SEGMENTS6.SECTION_LENGTH_NBR","SECTION_LENGTH_NBR","FUNCTIONAL_CLASS_CD","TOTAL_VOLUME_NBR","TRUCK_VOLUME_NBR","VOLUME_CAPACITY_RATIO_NBR"]
[null,null,null,null,null,null,null,null,null,"NLFID:","NLFID",null,null,null,{"$f":"IF(N2=\"\",\"\",VALUE(N2))","v":""}]
[null,null,null,null,null,null,null,null,null,"Blog:"]
[null,null,null,null,null,null,null,null,null,"Elog:"]
[null,null,null,null,null,null,null,null,null,"Error:",1]

{"sheet":"Coordinates","index":8,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["NLF_ID","LOGPOINT_COUNTY_NBR","LATITUDE_NBR","LONGITUDE_NBR"]
["SFRAIR00071**C",5.31,39.833392000000003,-83.101623000000004,null,null,"NLFID:"]
[null,null,null,null,null,null,"Logpoint:"]

{"sheet":"SafetyPriority","index":9,"n_rows":4,"n_cols":40,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["KeyID","List_Year","Time Period","Location Type","Freeway/Non-Freeway","District","County","Route","Suffix","NLF_ID","TRANS_ROUTE_CD","TRANS_ROUTE_ID","Begin Log","End Log","Length","Rank","INTERSECTION","STREET_AT","Crash Frequency","Fatal Crashes","Injury Crashes","Fatalities","Injuries","V/C","ADT","TOTLANES","WIDTH","FUNCLASS","LOS","Crash Rate_MVMT","Injury Crash Rate_MVMT","Fatal Crash Rate_100MVMT","Fatalities_SeriousInjuries","Crash_Density(PerMilePerYear)","Serious_Injuries","Fatality_Serious_Injury_Rate","Hazard Value Rank_TotCRxFatIncRatexFatIncInjuries",null,"Safety Year:",2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NLFID:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blog:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elog:"]

{"sheet":"Import","index":10,"n_rows":63,"n_cols":75,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Application ID:",null,{"$f":"IF('Safety Application'!A106=\"\",\"Not Assigned\",'Safety Application'!A106)","v":"201905D06-04"}]
[]
[]
["General Application Data"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/AppData/ImportView.aspx"]
["Title","Cycle","AppID","District","CountyCd","Sponsor","Project Name","PID","ProjectManager","PM_Phone","PM_Email","Applicant_Name","Applicant_Title","Applicant_Phone","ApplicationDt","RouteNbr","RouteName","Blog","Elog","FolderPath"]
[{"$f":"C7","v":"201905D06-04"},{"$f":"LEFT(C7,6)","v":"201905"},{"$f":"C1","v":"201905D06-04"},{"$f":"'Safety Application'!C10","v":6},{"$f":"'Safety Application'!H10","v":"FRA"},{"$f":"IF('Safety Application'!D2=\"\",\"\",'Safety Application'!D2)","v":"ODOT District 6"},{"$f":"IF('Safety Application'!D3=\"\",\"\",'Safety Application'!D3)","v":"Courtright Rd Bridge over I-70"},{"$f":"IF('Safety Application'!D4=\"\",\"\",'Safety Application'!D4)","v":109659},{"$f":"IF('Safety Application'!D5=\"\",\"\",'Safety Application'!D5)","v":"Drew Hurst"},{"$f":"IF('Safety Application'!D6=\"\",\"\",'Safety Application'!D6)","v":"740-833-8345"},{"$f":"IF('Safety Application'!D7=\"\",\"\",'Safety Application'!D7)","v":"andrew.hurst@dot.ohio.gov"},{"$f":"IF('Safety Application'!A97=\"\",\"\",'Safety Application'!A97)","v":"Drew Hurst"},{"$f":"IF('Safety Application'!F97=\"\",\"\",'Safety Application'!F97)","v":"Traffic Safety Engineer"},{"$f":"'Safety Application'!I97","v":"740-833-8345"},{"$f":"IF('Safety Application'!I99=\"\",\"\",MONTH('Safety Application'!I99)&\"/\"&DAY('Safety Application'!I99)&\"/\"&YEAR('Safety Application'!I99))","v":"5/7/2019"},{"$f":"'Safety Application'!C11","v":70},{"$f":"'Safety Application'!H11","v":"Courtright Rd"},{"$f":"'Safety Application'!C12","v":20.29},{"$f":"'Safety Application'!H12","v":""},{"$f":"IF(LEFT('Safety Application'!A108,1)=\"\\\",'Safety Application'!A108,\"\\\\itcfs007.dot.state.oh.us\\odrive\"&MID('Safety Application'!A108,FIND(\"\\\",'Safety Application'!A108,1),100))","v":"\\\\itcfs007.dot.state.oh.us\\odrive\\SAFETY\\D06\\SAFETY APPLICATIONS\\FRA-70-20.29"}]
[]
[]
["Project Priority"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/PriorityInfo/ImportView.aspx"]
["AppID","PriorityText"]
[{"$f":"C1","v":"201905D06-04"},{"$f":"IF('Safety Application'!A22=\"\",\"\",'Safety Application'!A22)","v":"There have been numerous community requests to add sidewalk across IR 70, and this would tie into a bridge deck replacement project.  There are no other potential pedestrian crossings over I-70 for a mile in each direction, and there are COTA bus stops on both sides of the bridge.  "}]
[]
[]
["Application Summary of Crash Patterns and Recommended Countermeasures"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/CrashPatterns/ImportView.aspx"]
["AppID","SummaryText","RecCountermeasure"]
[{"$f":"A13","v":"201905D06-04"},{"$f":"'Safety Application'!A18","v":"One pedestrian-related crash has occurred in the past 5 years on Courtright between Deshler Ave. and Groves Rd, along with several other crashes including rear ends and sideswipes. There is evidence of pedestrian traffic, including worn paths leading up to the bridge.  "},{"$f":"'Safety Application'!A20","v":"Add sidewalk to Courtright Rd from Deshler Ave to Groves Rd, including the IR 70 overpass.  City of Columbus has an upcoming project to add sidewalks along Courtright Rd. to the south."}]
[]
[]
["Application Crash Data"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/CrashData/ImportView.aspx"]
["AppID","Pred_Ex_KA","Pred_Ex_B","Pred_Ex_C","Pred_Ex_O","Exp_Ex_KA","Exp_Ex_B","Exp_Ex_C","Exp_Ex_O","PSI_KA","PSI_B","PSI_C","PSI_O","Prop_Type","Prop_KA","Prop_B","Prop_C","Prop_O","Obs_KA","Obs_B","Obs_C","Obs_O","Obs_People_K","Obs_People_A","Obs_People_B","Obs_People_C"]
[{"$f":"A19","v":"201905D06-04"},{"$f":"'Safety Application'!F26","v":2.0399999999999998E-2},{"$f":"'Safety Application'!G26","v":5.0900000000000001E-2},{"$f":"'Safety Application'!H26","v":6.1800000000000008E-2},{"$f":"'Safety Application'!I26","v":0.29210000000000003},{"$f":"'Safety Application'!F27","v":2.0199999999999999E-2},{"$f":"'Safety Application'!G27","v":5.28E-2},{"$f":"'Safety Application'!H27","v":6.090000000000001E-2},{"$f":"'Safety Application'!I27","v":0.30929999999999996},{"$f":"'Safety Application'!F28","v":-1.9999999999999879E-4},{"$f":"'Safety Application'!G28","v":1.8999999999999989E-3},{"$f":"'Safety Application'!H28","v":-8.9999999999999802E-4},{"$f":"'Safety Application'!I28","v":1.7199999999999938E-2},{"$f":"IF('Project Scoring'!H7=\"ECAT - Change in base SPF\",\"Predicted\",\"Expected\")","v":"Expected"},{"$f":"'Safety Application'!F29","v":2.0199999999999999E-2},{"$f":"'Safety Application'!G29","v":5.28E-2},{"$f":"'Safety Application'!H29","v":6.0900000000000003E-2},{"$f":"'Safety Application'!I29","v":0.30930000000000002},{"$f":"'Safety Application'!F30","v":0},{"$f":"'Safety Application'!G30","v":0.5},{"$f":"'Safety Application'!H30","v":0},{"$f":"'Safety Application'!I30","v":0.5},{"$f":"'Safety Application'!F33","v":0},{"$f":"'Safety Application'!G33","v":0},{"$f":"'Safety Application'!H33","v":1.3332999999999999},{"$f":"'Safety Application'!I33","v":0.5}]
[]
[]
["Application Scoring"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/AppScoring/ImportView.aspx"]
["AppID","Expected_Value","Expected_Points","ObservedFSI_Value","ObservedFSI_Points","PercPSI_Value","PercPSI_Points","RSI_Value","RSI_Points","EPDO_Value","EPDO_Points","VCRatio_Value","VCRatio_Points","BCRatio_Value","BCRatio_Points","FundRequest_Value","FundRequest_Points"]
[{"$f":"A25","v":"201905D06-04"},{"$f":"'Safety Application'!H37","v":0.44},{"$f":"'Safety Application'!I37","v":0},{"$f":"'Safety Application'!H38","v":0},{"$f":"'Safety Application'!I38","v":0},{"$f":"'Safety Application'!H39","v":4.5499999999999999E-2},{"$f":"'Safety Application'!I39","v":8},{"$f":"'Safety Application'!H40","v":24668.01},{"$f":"'Safety Application'!I40","v":2},{"$f":"'Safety Application'!H41","v":3.9090909090909092},{"$f":"'Safety Application'!I41","v":3},{"$f":"'Safety Application'!H42","v":0.5},{"$f":"'Safety Application'!I42","v":0},{"$f":"'Safety Application'!H43","v":0},{"$f":"'Safety Application'!I43","v":0},{"$f":"'Safety Application'!H44","v":0.34210000000000002},{"$f":"'Safety Application'!I44","v":10}]
[]
[]
["Strategic Highway Safety Plan"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/SHSP/ImportView.aspx"]
["AppID","Functional Class","MajAADT","OhioEmpArea","OhioEmpSub","FHWAEmpArea","FHWA_ImprovCat","FHWA_ImprovSubCat"]
[{"$f":"A31","v":"201905D06-04"},{"$f":"'Safety Application'!E48","v":"Interstates"},{"$f":"'Safety Application'!E49","v":95340},{"$f":"'Safety Application'!E50","v":"Emphasis Area IV - Special Vehicles/Roadway Users"},{"$f":"'Safety Application'!E51","v":"Pedestrians"},{"$f":"'Safety Application'!E52","v":"Making walking and street crossing easier"},{"$f":"'Safety Application'!E53","v":"Pedestrians and bicyclists"},{"$f":"'Safety Application'!E54","v":"Install sidewalk"}]
[]
[]
["Application Work Locations"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/WorkLocations/ImportView.aspx"]
["RouteID","AppID","Location ID","NLFID","Begin Logpoint","End Logpoint","startLatitude","startLongitude","endLatitude","endLongitude","Termini"]
[{"$f":"IF(D43=\"\",\"\",MID(D43,5,2)&\"-\"&IFERROR(MID(D43,7,5)*1,MID(D43,7,5))&IF(LEFT(D43,1)=\"S\",IF(RIGHT(D43,2)=\"*C\",\"\",MID(D43,13,1)),IF(RIGHT(D43,3)=\"**C\",\"\",MID(D43,12,1))))","v":"IR-70"},{"$f":"IF(C43=\"\",\"\",$A$37)","v":"201905D06-04"},{"$f":"IF(D43=\"\",\"\",1)","v":1},{"$f":"IF('Safety Application'!A58=0,\"\",'Safety Application'!A58)","v":"SFRAIR00070**C"},{"$f":"IF(D43=\"\",\"\",'Safety Application'!C58)","v":20.29},{"$f":"IF(D43=\"\",\"\",'Safety Application'!D58)","v":0},{"$f":"IF(D43=\"\",\"\",'Safety Application'!E58)","v":39.933999999999997},{"$f":"IF(D43=\"\",\"\",'Safety Application'!F58)","v":-82.897999999999996},{"$f":"IF(D43=\"\",\"\",'Safety Application'!AA58)","v":0},{"$f":"IF(D43=\"\",\"\",'Safety Application'!AB58)","v":0},{"$f":"IF(D43=\"\",\"\",'Safety Application'!G58)","v":"Courtright Rd overpass"}]
[{"$f":"IF(D44=\"\",\"\",MID(D44,5,2)&\"-\"&IFERROR(MID(D44,7,5)*1,MID(D44,7,5))&IF(LEFT(D44,1)=\"S\",IF(RIGHT(D44,2)=\"*C\",\"\",MID(D44,13,1)),IF(RIGHT(D44,3)=\"**C\",\"\",MID(D44,12,1))))","v":"CR-114"},{"$f":"IF(C44=\"\",\"\",$A$37)","v":"201905D06-04"},{"$f":"IF(D44=\"\",\"\",C43+1)","v":2},{"$f":"IF('Safety Application'!A59=0,\"\",'Safety Application'!A59)","v":"CFRACR00114**C"},{"$f":"IF(D44=\"\",\"\",'Safety Application'!C59)","v":2.0499999999999998},{"$f":"IF(D44=\"\",\"\",'Safety Application'!D59)","v":2.35},{"$f":"IF(D44=\"\",\"\",'Safety Application'!E59)","v":39.932000000000002},{"$f":"IF(D44=\"\",\"\",'Safety Application'!F59)","v":-82.897999999999996},null,null,{"$f":"IF(D44=\"\",\"\",'Safety Application'!G59)","v":"Groves Rd to Deshler Ave"}]
["","",{"$f":"IF(D45=\"\",\"\",C44+1)","v":""},{"$f":"IF('Safety Application'!A60=0,\"\",'Safety Application'!A60)","v":""},{"$f":"IF(D45=\"\",\"\",'Safety Application'!C60)","v":""},{"$f":"IF(D45=\"\",\"\",'Safety Application'!D60)","v":""},{"$f":"IF(D45=\"\",\"\",'Safety Application'!E60)","v":""},{"$f":"IF(D45=\"\",\"\",'Safety Application'!F60)","v":""},null,null,{"$f":"IF(D45=\"\",\"\",'Safety Application'!G60)","v":""}]
["","","",{"$f":"IF('Safety Application'!A61=0,\"\",'Safety Application'!A61)","v":""},{"$f":"IF(D46=\"\",\"\",'Safety Application'!C61)","v":""},{"$f":"IF(D46=\"\",\"\",'Safety Application'!D61)","v":""},{"$f":"IF(D46=\"\",\"\",'Safety Application'!E61)","v":""},{"$f":"IF(D46=\"\",\"\",'Safety Application'!F61)","v":""},null,null,{"$f":"IF(D46=\"\",\"\",'Safety Application'!G61)","v":""}]
["","","",{"$f":"IF('Safety Application'!A62=0,\"\",'Safety Application'!A62)","v":""},{"$f":"IF(D47=\"\",\"\",'Safety Application'!C62)","v":""},{"$f":"IF(D47=\"\",\"\",'Safety Application'!D62)","v":""},{"$f":"IF(D47=\"\",\"\",'Safety Application'!E62)","v":""},{"$f":"IF(D47=\"\",\"\",'Safety Application'!F62)","v":""},null,null,{"$f":"IF(D47=\"\",\"\",'Safety Application'!G62)","v":""}]
["","","",{"$f":"IF('Safety Application'!A63=0,\"\",'Safety Application'!A63)","v":""},{"$f":"IF(D48=\"\",\"\",'Safety Application'!C63)","v":""},{"$f":"IF(D48=\"\",\"\",'Safety Application'!D63)","v":""},{"$f":"IF(D48=\"\",\"\",'Safety Application'!E63)","v":""},{"$f":"IF(D48=\"\",\"\",'Safety Application'!F63)","v":""},null,null,{"$f":"IF(D48=\"\",\"\",'Safety Application'!G63)","v":""}]
["","","",{"$f":"IF('Safety Application'!A64=0,\"\",'Safety Application'!A64)","v":""},{"$f":"IF(D49=\"\",\"\",'Safety Application'!C64)","v":""},{"$f":"IF(D49=\"\",\"\",'Safety Application'!D64)","v":""},{"$f":"IF(D49=\"\",\"\",'Safety Application'!E64)","v":""},{"$f":"IF(D49=\"\",\"\",'Safety Application'!F64)","v":""},null,null,{"$f":"IF(D49=\"\",\"\",'Safety Application'!G64)","v":""}]
["","","",{"$f":"IF('Safety Application'!A65=0,\"\",'Safety Application'!A65)","v":""},{"$f":"IF(D50=\"\",\"\",'Safety Application'!C65)","v":""},{"$f":"IF(D50=\"\",\"\",'Safety Application'!D65)","v":""},{"$f":"IF(D50=\"\",\"\",'Safety Application'!E65)","v":""},{"$f":"IF(D50=\"\",\"\",'Safety Application'!F65)","v":""},null,null,{"$f":"IF(D50=\"\",\"\",'Safety Application'!G65)","v":""}]
["","","",{"$f":"IF('Safety Application'!A66=0,\"\",'Safety Application'!A66)","v":""},{"$f":"IF(D51=\"\",\"\",'Safety Application'!C66)","v":""},{"$f":"IF(D51=\"\",\"\",'Safety Application'!D66)","v":""},{"$f":"IF(D51=\"\",\"\",'Safety Application'!E66)","v":""},{"$f":"IF(D51=\"\",\"\",'Safety Application'!F66)","v":""},null,null,{"$f":"IF(D51=\"\",\"\",'Safety Application'!G66)","v":""}]
["","","",{"$f":"IF('Safety Application'!A67=0,\"\",'Safety Application'!A67)","v":""},{"$f":"IF(D52=\"\",\"\",'Safety Application'!C67)","v":""},{"$f":"IF(D52=\"\",\"\",'Safety Application'!D67)","v":""},{"$f":"IF(D52=\"\",\"\",'Safety Application'!E67)","v":""},{"$f":"IF(D52=\"\",\"\",'Safety Application'!F67)","v":""},null,null,{"$f":"IF(D52=\"\",\"\",'Safety Application'!G67)","v":""}]
[]
["Project Funding"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/Funding/ImportView.aspx"]
["AppID","FY_SafetyStudy","FY_IMS","FY_PE_Enviro","FY_PE_Design","FY_ROW","FY_Const","NewSafety_AMT_SafetyStudy","NewSafety_AMT_IMS","NewSafety_AMT_PE_Enviro","NewSafety_AMT_PE_Design","NewSafety_AMT_ROW","NewSafety_AMT_Const","PrevSafety_AMT_SafetyStudy","PrevSafety_AMT_IMS","PrevSafety_AMT_PE_Enviro","PrevSafety_AMT_PE_Design","PrevSafety_AMT_ROW","PrevSafety_AMT_Const","Sponsor_AMT_SafetyStudy","Sponsor_AMT_IMS","Sponsor_AMT_PE_Enviro","Sponsor_AMT_PE_Design","Sponsor_AMT_ROW","Sponsor_AMT_Const","Alt1_Source","Alt1_AMT_SafetyStudy","Alt1_AMT_IMS","Alt1_AMT_PE_Enviro","Alt1_AMT_PE_Design","Alt1_AMT_ROW","Alt1_AMT_Const","Alt2_Source","Alt2_AMT_SafetyStudy","Alt2_AMT_IMS","Alt2_AMT_PE_Enviro","Alt2_AMT_PE_Design","Alt2_AMT_ROW","Alt2_AMT_Const","Alt3_Source","Alt3_AMT_SafetyStudy","Alt3_AMT_IMS","Alt3_AMT_PE_Enviro","Alt3_AMT_PE_Design","Alt3_AMT_ROW","Alt3_AMT_Const","Alt4_Source","Alt4_AMT_SafetyStudy","Alt4_AMT_IMS","Alt4_AMT_PE_Enviro","Alt4_AMT_PE_Design","Alt4_AMT_ROW","Alt4_AMT_Const","Alt5_Source","Alt5_AMT_SafetyStudy","Alt5_AMT_IMS","Alt5_AMT_PE_Enviro","Alt5_AMT_PE_Design","Alt5_AMT_ROW","Alt5_AMT_Const","Alt6_Source","Alt6_AMT_SafetyStudy","Alt6_AMT_IMS","Alt6_AMT_PE_Enviro","Alt6_AMT_PE_Design","Alt6_AMT_ROW","Alt6_AMT_Const","Alt7_Source","Alt7_AMT_SafetyStudy","Alt7_AMT_IMS","Alt7_AMT_PE_Enviro","Alt7_AMT_PE_Design","Alt7_AMT_ROW","Alt7_AMT_Const","AddtlDetails"]
[{"$f":"A37","v":"201905D06-04"},{"$f":"'Safety Application'!D71","v":0},{"$f":"'Safety Application'!E71","v":0},{"$f":"'Safety Application'!F71","v":2020},{"$f":"'Safety Application'!G71","v":2020},{"$f":"'Safety Application'!H71","v":2021},{"$f":"'Safety Application'!I71","v":2022},{"$f":"'Safety Application'!D74","v":0},{"$f":"'Safety Application'!E74","v":0},{"$f":"'Safety Application'!F74","v":0},{"$f":"'Safety Application'!G74","v":0},{"$f":"'Safety Application'!H74","v":0},{"$f":"'Safety Application'!I74","v":1300000},{"$f":"'Safety Application'!D73","v":0},{"$f":"'Safety Application'!E73","v":0},{"$f":"'Safety Application'!F73","v":0},{"$f":"'Safety Application'!G73","v":0},{"$f":"'Safety Application'!H73","v":0},{"$f":"'Safety Application'!I73","v":0},{"$f":"'Safety Application'!D75","v":0},{"$f":"'Safety Application'!E75","v":0},{"$f":"'Safety Application'!F75","v":0},{"$f":"'Safety Application'!G75","v":0},{"$f":"'Safety Application'!H75","v":0},{"$f":"'Safety Application'!I75","v":2500000},{"$f":"'Safety Application'!A76","v":0},{"$f":"'Safety Application'!D76","v":0},{"$f":"'Safety Application'!E76","v":0},{"$f":"'Safety Application'!F76","v":0},{"$f":"'Safety Application'!G76","v":0},{"$f":"'Safety Application'!H76","v":0},{"$f":"'Safety Application'!I76","v":0},{"$f":"'Safety Application'!A77","v":0},{"$f":"'Safety Application'!D77","v":0},{"$f":"'Safety Application'!E77","v":0},{"$f":"'Safety Application'!F77","v":0},{"$f":"'Safety Application'!G77","v":0},{"$f":"'Safety Application'!H77","v":0},{"$f":"'Safety Application'!I77","v":0},{"$f":"'Safety Application'!A78","v":0},{"$f":"'Safety Application'!D78","v":0},{"$f":"'Safety Application'!E78","v":0},{"$f":"'Safety Application'!F78","v":0},{"$f":"'Safety Application'!G78","v":0},{"$f":"'Safety Application'!H78","v":0},{"$f":"'Safety Application'!I78","v":0},{"$f":"'Safety Application'!A79","v":0},{"$f":"'Safety Application'!D79","v":0},{"$f":"'Safety Application'!E79","v":0},{"$f":"'Safety Application'!F79","v":0},{"$f":"'Safety Application'!G79","v":0},{"$f":"'Safety Application'!H79","v":0},{"$f":"'Safety Application'!I79","v":0},{"$f":"'Safety Application'!A80","v":0},{"$f":"'Safety Application'!D80","v":0},{"$f":"'Safety Application'!E80","v":0},{"$f":"'Safety Application'!F80","v":0},{"$f":"'Safety Application'!G80","v":0},{"$f":"'Safety Application'!H80","v":0},{"$f":"'Safety Application'!I80","v":0},{"$f":"'Safety Application'!A81","v":0},{"$f":"'Safety Application'!D81","v":0},{"$f":"'Safety Application'!E81","v":0},{"$f":"'Safety Application'!F81","v":0},{"$f":"'Safety Application'!G81","v":0},{"$f":"'Safety Application'!H81","v":0},{"$f":"'Safety Application'!I81","v":0},{"$f":"'Safety Application'!A82","v":0},{"$f":"'Safety Application'!D82","v":0},{"$f":"'Safety Application'!E82","v":0},{"$f":"'Safety Application'!F82","v":0},{"$f":"'Safety Application'!G82","v":0},{"$f":"'Safety Application'!H82","v":0},{"$f":"'Safety Application'!I82","v":0},{"$f":"'Safety Application'!A85","v":"Other funds used to replace bridge deck and superstructure."}]
[]
[]
["Project Development"]
["https://extranet.dot.state.oh.us/divisions/Planning/plan/HSIP_applications/Lists/ProjectDevelopment/ImportView.aspx"]
["AppID","SafetyStudy_CompBy","SafetyStudy_CompDt","IMS_CompBy","IMS__CompDt","PE_Enviro_CompBy","PE_Enviro_CompDt","PE_Design_CompBy","PE_Design_CompDt","ROW_CompBy","ROW_CompDt"]
[{"$f":"A57","v":"201905D06-04"},{"$f":"'Safety Application'!E89","v":0},{"$f":"IF('Safety Application'!H89=\"\",\"\",MONTH('Safety Application'!H89)&\"/\"&DAY('Safety Application'!H89)&\"/\"&YEAR('Safety Application'!H89))","v":""},{"$f":"'Safety Application'!E90","v":0},{"$f":"IF('Safety Application'!H90=\"\",\"\",MONTH('Safety Application'!H90)&\"/\"&DAY('Safety Application'!H90)&\"/\"&YEAR('Safety Application'!H90))","v":""},{"$f":"'Safety Application'!E91","v":0},{"$f":"IF('Safety Application'!H91=\"\",\"\",MONTH('Safety Application'!H91)&\"/\"&DAY('Safety Application'!H91)&\"/\"&YEAR('Safety Application'!H91))","v":""},{"$f":"'Safety Application'!E92","v":0},{"$f":"IF('Safety Application'!H92=\"\",\"\",MONTH('Safety Application'!H92)&\"/\"&DAY('Safety Application'!H92)&\"/\"&YEAR('Safety Application'!H92))","v":""},{"$f":"'Safety Application'!E93","v":0},{"$f":"IF('Safety Application'!H93=\"\",\"\",MONTH('Safety Application'!H93)&\"/\"&DAY('Safety Application'!H93)&\"/\"&YEAR('Safety Application'!H93))","v":""}]