{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Crash Data","Data Analysis","Graphical Analysis","Histograms","Collision Diagram","Diagram Data","Resurfacing Analysis","Rate Calc Sheet","Severity Calc Sheet","ROR Analysis","Safety App","CRF Table","Help File"],"not_rendered":{"charts":32,"images":98,"macros":1,"external_links":0,"defined_names":36,"comments":3,"pivot_tables":85},"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":"Crash Data","index":0,"n_rows":26,"n_cols":128,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,69,18,70],[18,71,18,72],[18,73,18,74],[18,87,18,88],[18,89,18,90],[17,61,17,66],[17,67,17,72],[17,73,17,92],[18,61,18,62],[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],[18,63,18,64],[18,65,18,66],[18,67,18,68],[9,6,9,8],[9,9,9,10],[3,6,3,8],[6,6,6,8],[6,9,6,10],[7,6,7,8],[7,9,7,10],[8,6,8,8],[8,9,8,10],[4,6,4,8],[3,9,3,10],[5,6,5,8],[4,9,4,10],[5,9,5,10]]}
[null,null,null,null,null,null,"Crash Data","Graphical Analysis","Collision Diagram","Rate Calc Sheet","ROR Analysis","CRF Table"]
["version: 11.02.11",null,null,null,null,null,"Data Analysis","Histograms","Resurfacing Analysis","Severity Calc Sheet","Safety App","Help File"]
[{"$f":"D12&\"-\"&D13&D14&\" - (\"&D15&\"-\"&D16&\")     \"&\"From \"&MID(D17,5,2)&\"/\"&MID(D17,7,2)&\"/\"&LEFT(D17,4)&\" to \"&MID(D18,5,2)&\"/\"&MID(D18,7,2)&\"/\"&LEFT(D18,4)","v":"- - (-)     From // to //"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"\\\\itcfs007\\odrive\\SAFETY\\CEN\\_Crash Analysis Tools\\CAM Tool FS.xls\", \"Launch: CAM Tool FS-Multi Location Excel File\")","v":"Launch: CAM Tool FS-Multi Location Excel File"},null,null,{"$f":"HYPERLINK(CONCATENATE(\"http://www.dps.state.oh.us/OHCrashReports/\"),\"Launch: ODPS Crash Reports\")","v":"Launch: ODPS Crash Reports"}]
[null,null,null,null,null,null,{"$f":"+HYPERLINK(CONCATENATE(\"https://tscas001.dot.state.oh.us/OhioRVX2/Roadview.asp?nlf_id='\",+D21,\"'&offset=\",+E21),\"Launch: Video Log\")","v":"Launch: Video Log"},null,null,{"$f":"HYPERLINK(CONCATENATE(\"https://gcat.dot.state.oh.us/SSL/Login.aspx\"),\"Launch: GIS Crash Analysis Tool (GCAT)\")","v":"Launch: GIS Crash Analysis Tool (GCAT)"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www.dot.state.oh.us/Divisions/Planning/TechServ/prod_services/Documents/DESTAPECnty/DES\"&AY21&\".pdg\",\"Launch: ODOT Destape\")","v":"Launch: ODOT Destape"},null,null,{"$f":"HYPERLINK(CONCATENATE(\"http://maps.google.com/maps?\"),\"Launch: Google Maps\")","v":"Launch: Google Maps"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"O:\\SAFETY\\CEN\\Access_WorkPlan\\Locations Rank Lookup by Year\\Safety Location Rankings Lookup Database.mdb\",\"Launch: Safety Location Lookup Database\")","v":"Launch: Safety Location Lookup Database"},null,null,{"$f":"HYPERLINK(\"http://www.bing.com/maps/default.aspx?v=2&cp=\"&BB21&\"~\"&BC21&\"&style=h&lvl=15\",\"Launch: Bing Maps\")","v":"Launch: Bing Maps"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"O:\\SAFETY\",\"Launch: S/C Work Plan Folder\")","v":"Launch: S/C Work Plan Folder"},null,null,{"$f":"HYPERLINK(\"http://www.mapquest.com/maps/map.adp?formtype=address&country=US&popflag=0&latitude=&longitude=&name=&phone=&level=&addtohistory=&cat=&address=&city=&state=oh&zipcode=\",\"Launch: Mapquest Maps\")","v":"Launch: Mapquest Maps"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www.odotonline.org/techservapps/SLD/default.htm\",\"Launch: Traffic Survey Reports (ADT)\")","v":"Launch: Traffic Survey Reports (ADT)"},null,null,{"$f":"HYPERLINK(\"http://www.buckeyetraffic.org/\",\"Launch: Buckeye Traffic\")","v":"Launch: Buckeye Traffic"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www.dot.state.oh.us/Divisions/Planning/ProgramMgt/ProgramManagement/Pages/Safety.aspx\",\"Launch: Highway Safety Website\")","v":"Launch: Highway Safety Website"},null,null,{"$f":"HYPERLINK(CONCATENATE(\"http://data.mashedworld.com/dualmaps/map.htm?x=\",BC21,\"&y=\",BB21,\"&z=15&gm=0&ve=5&gc=0&bz=1&bd=0&mw=1&sv=1&svb=0&svp=0&svz=0&svm=2&svf=0\"),\"Launch: Mashed Map\")","v":"Launch: Mashed Map"}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BD17=2006,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",L17=\"DAYLIGHT\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",L17=\"DAYLIGHT\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",BH17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",BH17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",BH17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",BH17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",BH17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",BH17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",BH17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",BH17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",BH17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",BH17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",BH17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",BH17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",BI17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",BI17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",BI17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",BI17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",BI17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",BI17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",BI17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",BI17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",BI17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",BI17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",BI17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",BI17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",Q17=\"ROAD - DRY\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",Q17=\"ROAD - DRY\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",Q17=\"ROAD - WET\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",Q17=\"ROAD - WET\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",BG17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",BG17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",BG17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",BG17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",BG17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",BG17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",BG17=\"YES\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",BG17=\"YES\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",BG17=\"YES\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",BG17=\"YES\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",BG17=\"YES\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",BG17=\"YES\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"REAR END\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"REAR END\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"REAR END\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"REAR END\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"REAR END\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"REAR END\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"REAR END\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"REAR END\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"REAR END\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"REAR END\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"REAR END\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"REAR END\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"LEFT TURN\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"LEFT TURN\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"LEFT TURN\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"LEFT TURN\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"LEFT TURN\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"LEFT TURN\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"LEFT TURN\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"LEFT TURN\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"LEFT TURN\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"LEFT TURN\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"LEFT TURN\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"LEFT TURN\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"RIGHT TURN\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"RIGHT TURN\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"ANGLE\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"ANGLE\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"ANGLE\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"ANGLE\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"ANGLE\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"ANGLE\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"ANGLE\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"ANGLE\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"ANGLE\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"ANGLE\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"ANGLE\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"ANGLE\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"HEAD ON\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"HEAD ON\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"HEAD ON\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"HEAD ON\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"HEAD ON\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"HEAD ON\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"HEAD ON\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"HEAD ON\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"HEAD ON\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"HEAD ON\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"HEAD ON\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"HEAD ON\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"SIDESWIPE - PASSING\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"SIDESWIPE - PASSING\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"FIXED OBJECT\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"FIXED OBJECT\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2006\",IF(AND(BD17=2007,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2007\",IF(AND(BD17=2008,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2008\",IF(AND(BD17=2009,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2009\",IF(AND(BD17=2010,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2010\",IF(AND(BD17=2005,BF17=\"NO\",M17=\"PEDESTRIAN\"),\"2005\",\"\")))))))","v":""},{"$f":"IF(BD17=\"\",\"\",IF(AND(BD17=2006,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2006\",IF(AND(BD17=2007,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2007\",IF(AND(BD17=2008,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2008\",IF(AND(BD17=2009,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2009\",IF(AND(BD17=2010,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2010\",IF(AND(BD17=2005,BF17=\"YES\",M17=\"PEDESTRIAN\"),\"2005\",\"\")))))))","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(COUNTIF(BV17:CM17,\"=2006\")+COUNTIF(BV17:CM17,\"=2007\")+COUNTIF(BV17:CM17,\"=2008\")+COUNTIF(BV17:CM17,\"=2009\")+COUNTIF(BV17:CM17,\"=2010\")+COUNTIF(BV17:CM17,\"=2005\")>=1,\"\",\"1\"))","v":""},null,null,null,{"$f":"IF($DP$18=\"\",MID(DP17&$DS$18&DS17&$DQ$18&DQ17&$DR$18&DR17&$DT$18&DT17&$DU$18&DU17&$CY$18&CY17&$CZ$18&CZ17&$CX$18&CX17&$DE$18&DE17&$DF$18&DF17&$DG$18&DG17&$DH$18&DH17&$DV$18&DV17,2,150),DP17&$DS$18&DS17&$DQ$18&DQ17&$DR$18&DR17&$DT$18&DT17&$DU$18&DU17&$CY$18&CY17&$CZ$18&CZ17&$CX$18&CX17&$DE$18&DE17&$DF$18&DF17&$DG$18&DG17&$DH$18&DH17&$DV$18&DV17)","v":""},null,null,null,{"$f":"IF(CX21=\"\",\"\",CX20)","v":""},{"$f":"IF(CY21=\"\",\"\",CY20)","v":""},{"$f":"IF(CZ21=\"\",\"\",CZ20)","v":""},null,null,null,null,{"$f":"IF(DE21=\"\",\"\",DE20)","v":""},{"$f":"IF(DF21=\"\",\"\",DF20)","v":""},{"$f":"IF(DG21=\"\",\"\",DG20)","v":""},{"$f":"IF(DH21=\"\",\"\",DH20)","v":""},null,null,null,null,null,null,null,{"$f":"IF(DP21=\"\",\"\",DP20)","v":""},"","","","","",{"$f":"IF(DV21=\"\",\"\",DV20)","v":""},{"$f":"IF(DW21=\"\",\"\",DW20)","v":""},{"$f":"IF(DX21=\"\",\"\",DX20)","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,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,"/"]
[{"$f":"IF(AQ19=\"\",\"\",HYPERLINK(AQ19,\"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,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",null,null,{"$f":"+HYPERLINK(CONCATENATE(\"https://tscas001.dot.state.oh.us/OhioRVX2/Roadview.asp?nlf_id='\",+D19,\"'&offset=\",+E19),\"Roadview\")","v":"Roadview"},{"$f":"HYPERLINK(CONCATENATE(\"http://maps.google.com/maps?q=\",+BB19,\",+\",+BC19,\"+(Crash+Location)&iwloc=A&hl=en\"),\"Google Maps\")","v":"Google Maps"},{"$f":"HYPERLINK(CONCATENATE(\"http://data.mashedworld.com/dualmaps/map.htm?x=\",BC19,\"&y=\",BB19,\"&z=15&gm=0&ve=5&gc=0&bz=1&bd=0&mw=1&sv=1&svb=0&svp=0&svz=0&svm=2&svf=0\"),\"Mashed Map\")","v":"Mashed Map"},{"$f":"IF($DP$18=\"\",MID(DP19&$DS$18&DS19&$DQ$18&DQ19&$DR$18&DR19&$DT$18&DT19&$DU$18&DU19&$CY$18&CY19&$CZ$18&CZ19&$CX$18&CX19&$DE$18&DE19&$DF$18&DF19&$DG$18&DG19&$DH$18&DH19&$DV$18&DV19&$DW$18&DW19&$DX$18&DX19,2,150),DP19&$DS$18&DS19&$DQ$18&DQ19&$DR$18&DR19&$DT$18&DT19&$DU$18&DU19&$CY$18&CY19&$CZ$18&CZ19&$CX$18&CX19&$DE$18&DE19&$DF$18&DF19&$DG$18&DG19&$DH$18&DH19&$DV$18&DV19&$DW$18&DW19&$DX$18&DX19)","v":"0"},null,null,null,{"$f":"IF($CX$18=\"\",\"\",LEFT(J19,2))","v":""},{"$f":"IF($CY$18=\"\",\"\",RIGHT(BD19,2))","v":""},{"$f":"IF($CZ$18=\"\",\"\",LEFT(O19,1))","v":""},{"$f":"IF(W19=\"\",\"\",LEFT(W19,6))","v":""},{"$f":"IF(AK19=\"\",\"\",LEFT(AK19,6))","v":""},{"$f":"IF(X19=\"\",\"\",LEFT(X19,6))","v":""},{"$f":"IF(AL19=\"\",\"\",LEFT(AL19,6))","v":""},{"$f":"IF($DE$18=\"\",\"\",G19)","v":""},{"$f":"IF($DF$18=\"\",\"\",E19)","v":""},{"$f":"IF($DG$18=\"\",\"\",H19)","v":""},{"$f":"IF($DH$18=\"\",\"\",I19/100)","v":""},null,null,null,null,null,null,null,{"$f":"IF($DP$18=\"\",\"\",CU19)","v":0},{"$f":"IF($DQ$18=\"\",\"\",MID(F19,5,2)&\"-\"&MID(F19,7,2)&\"-\"&RIGHT(BD19,2))","v":""},{"$f":"IF($DR$18=\"\",\"\",K19)","v":""},{"$f":"IF($DS$18=\"\",\"\",B19)","v":""},{"$f":"IF($DT$18=\"\",\"\",IF(L19=\"DARK - LIGHTED\",\"N\",IF(L19=\"DARK - NO LIGHTS\",\"N\",IF(L19=\"DAYLIGHT\",\"D\",\"O\"))))","v":""},{"$f":"IF($DU$18=\"\",\"\",IF(Q19=\"ROAD - WET\",\"W\",IF(Q19=\"ROAD - SNOW\",\"S\",IF(Q19=\"ROAD - ICE\",\"I\",IF(Q19=\"ROAD - DRY\",\"D\",\"O\")))))","v":""},{"$f":"IF($DV$18=\"\",\"\",LEFT(AW19,6))","v":""},{"$f":"IF($DW$18=\"\",\"\",IF(W19=\"\",\"U\",VLOOKUP(W19,'Help File'!$AJ$5:$AK$13,2,FALSE))&\" to \"&IF(X19=\"\",\"U\",VLOOKUP(X19,'Help File'!$AJ$5:$AK$13,2,FALSE)))","v":""},{"$f":"IF($DX$18=\"\",\"\",IF(AK19=\"\",\"U\",VLOOKUP(AK19,'Help File'!$AJ$5:$AK$13,2,FALSE))&\" to \"&IF(AL19=\"\",\"U\",VLOOKUP(AL19,'Help File'!$AJ$5:$AK$13,2,FALSE)))","v":""}]
["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","Roadview","Google","Mashed Map","Label","ID","TYPE","Zone","Day","Year","Severity","DFrom1","DFrom2","DTo1","DTo2","StreetOn","LogPoint","StreetAt","Offset","Box","Symbol",null,null,null,null,null,"RowID","Date","Hour","DocNum","Light Cond","Road Cond","OffsetDirection","Direction1FromTo","Direction2FromTo"]
[{"$f":"IF(AQ21=\"\",\"\",HYPERLINK(AQ21,\"Crash Report\"))","v":"Crash Report"},"096310772","71-0461-71","SROSSR00159**C",2.7,20090410,"SR0159R","MP002.70",0,"FRIDAY","12","DAYLIGHT","REAR END",2,"PROPERTY DAMAGE CRASH","NO ADVERSE WEATHER CONDITION","ROAD - WET","INTERSECTION RELATED","FOLLOWING TOO CLOSE","GOING STRAIGHT","OBJECT NOT STATED","COMPACT","NORTH","SOUTH",76,"MALE","PAVEMENT MARKINGS","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPEED 36-45","POSTED 40","NO DRIVER ERRORS","STOPPED IN TRAFFIC","OTHER VEHICLE",36,"MALE","NORTH","SOUTH","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPECIAL AREA - NOT STATED","ANIMAL NOT STATED","\\\\ITCFS014\\ODPS\\2009\\GENERATED_images\\20096310772.pdf","STRAIGHT - LEVEL",0,0,0,0,null,9,"ROS",3,"SCIOTO",39.373365999999997,-82.975695000000002,2009,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+HYPERLINK(CONCATENATE(\"https://tscas001.dot.state.oh.us/OhioRVX2/Roadview.asp?nlf_id='\",+D21,\"'&offset=\",+E21),\"Roadview\")","v":"Roadview"},{"$f":"HYPERLINK(CONCATENATE(\"http://maps.google.com/maps?q=\",+BB21,\",+\",+BC21,\"+(Crash+Location)&iwloc=A&hl=en\"),\"Google Maps\")","v":"Google Maps"},{"$f":"HYPERLINK(CONCATENATE(\"http://data.mashedworld.com/dualmaps/map.htm?x=\",BC21,\"&y=\",BB21,\"&z=15&gm=0&ve=5&gc=0&bz=1&bd=0&mw=1&sv=1&svb=0&svp=0&svz=0&svm=2&svf=0\"),\"Mashed Map\")","v":"Mashed Map"}]
["Crash Report","106422255","71-0129-71","SROSSR00159**C",2.7,20100119,"SR0159R","MP002.70",0,"TUESDAY","15","DAYLIGHT","SIDESWIPE - PASSING",2,"PROPERTY DAMAGE CRASH","NO ADVERSE WEATHER CONDITION","ROAD - DRY","NON-INTERSECTION","IMPROPER LANE CHANGE","CHANGING LANES","OBJECT NOT STATED","PICKUP TRUCK","NORTH","SOUTH",49,"MALE","PAVEMENT MARKINGS","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPEED 36-45","POSTED 50","NO DRIVER ERRORS","GOING STRAIGHT","MID-SIZE",45,"MALE","NORTH","SOUTH","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPECIAL AREA - NOT STATED","ANIMAL NOT STATED","\\\\ITCFS014\\ODPS\\2010\\GENERATED_images\\20106422255.pdf","STRAIGHT - LEVEL",0,0,0,0,null,9,"ROS",3,"SPRINGFIELD",39.373365999999997,-82.975695000000002,2010,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Mashed Map"]
["Crash Report","106464857","71-0925-71","SROSSR00159**C",2.7,20100814,"SR0159R","MP002.70",0,"SATURDAY","08","DAYLIGHT","REAR END",3,"INJURY CRASH","NO ADVERSE WEATHER CONDITION","ROAD - DRY","INTERSECTION","FOLLOWING TOO CLOSE","GOING STRAIGHT","OBJECT NOT STATED","OTHER VEHICLE","SOUTH","NORTH",49,"FEMALE","PAVEMENT MARKINGS","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPEED 36-45","POSTED 45","NO DRIVER ERRORS","STOPPED IN TRAFFIC","MID-SIZE",71,"FEMALE","SOUTH","NORTH","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPECIAL AREA - NOT STATED","ANIMAL NOT STATED","\\\\ITCFS014\\ODPS\\2010\\GENERATED_images\\20106464857.pdf","STRAIGHT - LEVEL",0,0,3,0,null,9,"ROS",3,"SPRINGFIELD",39.373365999999997,-82.975695000000002,2010,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Mashed Map"]
["Crash Report","106468792","71-1122-71","SROSSR00159**C",2.7,20100917,"SR0159R","MP002.70",0,"FRIDAY","14","DAYLIGHT","REAR END",2,"PROPERTY DAMAGE CRASH","NO ADVERSE WEATHER CONDITION","ROAD - DRY","NON-INTERSECTION","FOLLOWING TOO CLOSE","GOING STRAIGHT","OBJECT NOT STATED","COMPACT","NORTH","SOUTH",24,"FEMALE","PAVEMENT MARKINGS","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPEED 26-35","POSTED 55","NO DRIVER ERRORS","GOING STRAIGHT","MID-SIZE",45,"FEMALE","NORTH","SOUTH","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPECIAL AREA - NOT STATED","ANIMAL NOT STATED","\\\\ITCFS014\\ODPS\\2010\\GENERATED_images\\20106468792.pdf","STRAIGHT - LEVEL",0,0,0,0,null,9,"ROS",3,"SPRINGFIELD",39.373365999999997,-82.975695000000002,2010,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Mashed Map"]
["Crash Report","098012855","09-1047","SROSSR00159**C",2.72,20090122,"SR0159R","001852",1,"THURSDAY","19","DARK - LIGHTED","REAR END",2,"PROPERTY DAMAGE CRASH","NO ADVERSE WEATHER CONDITION","ROAD - DRY","INTERSECTION","FOLLOWING TOO CLOSE","GOING STRAIGHT","NOTHING STRUCK","FULL-SIZE","NORTH","SOUTH",41,"MALE","TRAFFIC SIGNAL","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPEED 20 AND UNDER","POSTED 45","NO DRIVER ERRORS","STOPPED IN TRAFFIC","FULL-SIZE",28,"FEMALE","NORTH","SOUTH","NO ALCOHOL DETECTED","NO DRUGS DETECTED","SPECIAL AREA - NOT STATED","ANIMAL NOT STATED","\\\\ITCFS014\\ODPS\\2009\\8012344-8012933\\200980128557174129.TIF","STRAIGHT - LEVEL",0,0,0,0,null,9,"ROS",3,"SPRINGFIELD",39.373652,-82.975682000000006,2009,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Mashed Map"]
[null,"","","",null,null,"","",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Data Analysis","index":1,"n_rows":295,"n_cols":14,"rows_kept":295,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Crash Data'!A3","v":"- - (-)     From // to //"},null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"- - (-)     From // to //"}]
[]
[null,null,null,null,null,null,null,null,null,null,"SEVERITY","CRASH_SEVERITY"]
[null,"Number",null,null,null,null,null,null,null,null,"TRAFFIC_CRASH_YEAR","(blank)"]
["Total",null,null,null,null,null,null,null,null,null,"(blank)",0]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",0]
[]
[]
["CRASH_SEVERITY","Number","CRASH_SEVERITY","%",null,"TRAFFIC_CRASH_YEAR","Number","TRAFFIC_CRASH_YEAR","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
["DAY_OF_WEEK","Number","DAY_OF_WEEK","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TRAFFIC_CRASH_YEAR","Fatalities","Incapacitating Injuries"]
[null,null,null,null,null,null,null,null,null,null,"(blank)",0,0]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",0,0]
[]
[]
[]
[]
["HOUR_OF_DAY","Number","HOUR_OF_DAY","%",null,"TYPE_OF_CRASH","Number","TYPE_OF_CRASH","%"]
[null,null,null,{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"TRAFFIC_CRASH_YEAR","INJ_TYPE2_SERIOUS_VISIBLE","INJ_TYPE3_MINOR_VISIBLE","INJ_TYPE4_NO_VISIBLE"]
[null,null,null,null,null,null,null,null,null,null,"(blank)",0,0,0]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["WEATHER_CONDITION","Number","WEATHER_CONDITION","%",null,"ROAD_CONDITION","Number","ROAD_CONDITION","%",null,"TYPE_OF_CRASH","CRASH_SEVERITY","Number"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)","(blank)",0]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"(blank) Total",null,0]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LIGHT_CONDITION","Number","LIGHT_CONDITION","%",null,"NUMBER_OF_VEHICLES","Number","NUMBER_OF_VEHICLES","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LOCATION","Number","LOCATION","%",null,"CRASH_MONTH_NBR","Number","CRASH_MONTH_NBR","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ROAD_CONTOUR","Number","ROAD_CONTOUR","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
["SPECIAL_AREA","Number","SPECIAL_AREA","%",null,"ANIMAL_TYPE","Number","ANIMAL_TYPE","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
["ACTION1","Number","ACTION1","%",null,"CONTRIBUTING_FACTOR1","Number","CONTRIBUTING_FACTOR1","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OBJECT_STRUCK1","Number","OBJECT_STRUCK1","%",null,"TRAFFIC_CONTROL1","Number","TRAFFIC_CONTROL1","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DRIVER_ALCOHOL1","Number","DRIVER_ALCOHOL1","%",null,"DRIVER_DRUGS1","Number","DRIVER_DRUGS1","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
["DIRECTION_FROM1","Number","DIRECTION_FROM1","%",null,"DIRECTION_TO1","Number","DIRECTION_TO1","%",null,"TYPE_OF_CRASH","CRASH_SEVERITY","TRAFFIC_CRASH_YEAR","Number"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)","(blank)","(blank)",2]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"(blank) Total",null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,"Grand Total",null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["POSTED_SPEED1","Number","POSTED_SPEED1","%",null,"ESTIMATED_SPEED1","Number","ESTIMATED_SPEED1","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VEHICLE_TYPE1","Number","VEHICLE_TYPE1","%",null,"VEHICLE_TYPE2","Number","VEHICLE_TYPE2","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ACTION2","Number","ACTION2","%",null,"CONTRIBUTING_FACTOR2","Number","CONTRIBUTING_FACTOR2","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DIRECTION_FROM2","Number","DIRECTION_FROM2","%",null,"DIRECTION_TO2","Number","DIRECTION_TO2","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DRIVER_ALCOHOL2","Number","DRIVER_ALCOHOL2","%",null,"DRIVER_DRUGS2","Number","DRIVER_DRUGS2","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"},null,"(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"},null,"Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]

{"sheet":"Graphical Analysis","index":2,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Crash Data'!A3","v":"- - (-)     From // to //"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"- - (-)     From // to //"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"- - (-)     From // to //"}]

{"sheet":"Histograms","index":3,"n_rows":694,"n_cols":169,"rows_kept":694,"cut":false,"hidden":false,"merged":[]}
["Default Bin Size is 0.1 Miles",null,null,{"$f":"'Crash Data'!$A$3","v":"- - (-)     From // to //"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Histogram 1 Graph",null,null,"Click for Histogram 2 Graph",null,null,null,null,"Click for Histogram 3 Graph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Histogram 4 Graph",null,null,null,null,null,null,null,"Click for Histogram 5 Graph",null,null,null,null,null,null,null,null,null,"Click for Histogram 6 Graph",null,null,null,null,null,"Click for Histogram 7 Graph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Histogram 8 Graph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Histogram 9 Graph",null,null,null,null,null,null,null,null,null,"Click for Histogram 10 Graph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Histogram 11 Graph"]
["Click Buttons Below to Modify",null,null,"Histogram 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR",null,null,"Count of ACCIDENTS_POINTS_NBR","CRASH_SEVERITY_TXT",null,null,null,"Count of ACCIDENTS_POINTS_NBR","TYPE_OF_CRASH_TXT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","ROAD_CONDITION_TXT",null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","LIGHT_CONDITION_TXT",null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","ANIMAL_TYPE_TXT",null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","CONTRIBUTING_FACTOR1_TXT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","ACTION1_TXT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","DAY_OF_WEEK_TXT",null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR","HOUR_OF_DAY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of ACCIDENTS_POINTS_NBR",null,"TYPE_OF_CRASH_TXT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","Total",null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","(blank)",null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR","DIRECTION_TO1_TXT","(blank)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,"99.77-99.87",1,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,"99.77-99.87",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87","(blank)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,"99.87-99.97",1,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,"99.87-99.97",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.77-99.87 Total",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",2,null,"Grand Total",2,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,"Grand Total",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97","(blank)",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99.87-99.97 Total",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 2"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 3"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 5"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 6"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 7"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 8"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 9"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 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,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 11"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"$D$1","v":"- - (-)     From // to //"}]
[null,null,null,"Histogram 12"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copy and paste this call-out box for use on the chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click to go to Histogram 1 data"]
["Click to go to Histogram 2 data"]
["Click to go to Histogram 3 data"]
["Click to go to Histogram 4 data"]
["Click to go to Histogram 5 data"]
["Click to go to Histogram 6 data"]
["Click to go to Histogram 7 data"]
["Click to go to Histogram 8 data"]
["Click to go to Histogram 9 data"]
["Click to go to Histogram 10 data"]
["Click to go to Histogram 11 data"]
["Click to go to Histogram 12 data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click for Histogram 12 Graph"]
["Count of ACCIDENTS_POINTS_NBR","DIRECTION_TO1_TXT"]
["LOGPOINT_SLM_NBR","(blank)"]
["99.77-99.87",1]
["99.87-99.97",1]
["Grand Total",2]

{"sheet":"Collision Diagram","index":4,"n_rows":12,"n_cols":43,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LEFT(AO1,1)","v":""},{"$f":"RIGHT(AO1,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,{"$f":"LEFT(AO2,1)","v":""},{"$f":"RIGHT(AO2,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,{"$f":"LEFT(AO3,2)","v":""},{"$f":"RIGHT(AO3,2)","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,{"$f":"LEFT(AO4,2)","v":""},{"$f":"RIGHT(AO4,2)","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,{"$f":"LEFT(AO6,1)","v":""},{"$f":"RIGHT(AO6,2)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Diagram Data","index":5,"n_rows":2,"n_cols":49,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF('Crash Data'!$CU19=\"\",\"\",'Crash Data'!$CU19)","v":""},{"$f":"IF('Crash Data'!$O19=\"\",\"\",IF('Crash Data'!$O19=\"PROPERTY DAMAGE CRASH\",\"PDO\",'Crash Data'!$O19))","v":""},{"$f":"IF('Crash Data'!$M19=\"\",\"\",'Crash Data'!$M19)","v":""},{"$f":"IF('Crash Data'!$F19=\"\",\"\",'Crash Data'!$F19)","v":""},{"$f":"IF('Crash Data'!$K19=\"\",\"\",'Crash Data'!$K19)","v":""},{"$f":"IF('Crash Data'!$J19=\"\",\"\",'Crash Data'!$J19)","v":""},{"$f":"IF('Crash Data'!$L19=\"\",\"\",'Crash Data'!$L19)","v":""},{"$f":"IF('Crash Data'!$Q19=\"\",\"\",'Crash Data'!$Q19)","v":""},{"$f":"IF('Crash Data'!$R19=\"\",\"\",'Crash Data'!$R19)","v":""},{"$f":"IF('Crash Data'!$S19=\"\",\"\",'Crash Data'!$S19)","v":""},{"$f":"IF('Crash Data'!$T19=\"\",\"\",'Crash Data'!$T19)","v":""},{"$f":"IF('Crash Data'!$W19=\"\",\"\",'Crash Data'!$W19)","v":""},{"$f":"IF('Crash Data'!$X19=\"\",\"\",'Crash Data'!$X19)","v":""},{"$f":"IF('Crash Data'!$U19=\"\",\"\",IF('Crash Data'!$U19=\"NOTHING STRUCK\",\"\",'Crash Data'!$U19))","v":""},{"$f":"IF('Crash Data'!$AB19=\"\",\"\",IF('Crash Data'!$AB19=\"NO ALCOHOL DETECTED\",\"\",'Crash Data'!$AB19))","v":""},{"$f":"IF('Crash Data'!$AF19=\"\",\"\",IF('Crash Data'!$AF19=\"NO DRIVER ERRORS\",\"\",'Crash Data'!$AF19))","v":""},{"$f":"IF('Crash Data'!$AG19=\"\",\"\",'Crash Data'!$AG19)","v":""},{"$f":"IF('Crash Data'!$AK19=\"\",\"\",'Crash Data'!$AK19)","v":""},{"$f":"IF('Crash Data'!$AL19=\"\",\"\",'Crash Data'!$AL19)","v":""},{"$f":"IF('Crash Data'!$AM19=\"\",\"\",IF('Crash Data'!$AM19=\"NO ALCOHOL DETECTED\",\"\",'Crash Data'!$AM19))","v":""},{"$f":"IF('Crash Data'!$AR19=\"\",\"\",'Crash Data'!$AR19)","v":""},{"$f":"IF('Crash Data'!$AS19=\"\",\"\",'Crash Data'!$AS19)","v":""},{"$f":"IF('Crash Data'!$AT19=\"\",\"\",'Crash Data'!$AT19)","v":""},{"$f":"IF('Crash Data'!$AU19=\"\",\"\",'Crash Data'!$AU19)","v":""},{"$f":"IF('Crash Data'!$AV19=\"\",\"\",'Crash Data'!$AV19)","v":""},{"$f":"IF('Crash Data'!$B19=\"\",\"\",'Crash Data'!$B19)","v":""},{"$f":"IF('Crash Data'!$C19=\"\",\"\",'Crash Data'!$C19)","v":""},{"$f":"IF('Crash Data'!$D19=\"\",\"\",'Crash Data'!$D19)","v":""},{"$f":"IF('Crash Data'!$E19=\"\",\"\",'Crash Data'!$E19)","v":""},{"$f":"IF('Crash Data'!$G19=\"\",\"\",'Crash Data'!$G19)","v":""},{"$f":"IF('Crash Data'!$H19=\"\",\"\",'Crash Data'!$H19)","v":""},{"$f":"IF('Crash Data'!$I19=\"\",\"\",'Crash Data'!$I19)","v":""},{"$f":"IF('Crash Data'!$AW19=\"\",\"\",'Crash Data'!$AW19)","v":""},{"$f":"IF('Crash Data'!$N19=\"\",\"\",'Crash Data'!$N19)","v":""},{"$f":"IF('Crash Data'!$P19=\"\",\"\",'Crash Data'!$P19)","v":""},{"$f":"IF('Crash Data'!$V19=\"\",\"\",'Crash Data'!$V19)","v":""},{"$f":"IF('Crash Data'!$Y19=\"\",\"\",'Crash Data'!$Y19)","v":""},{"$f":"IF('Crash Data'!$Z19=\"\",\"\",'Crash Data'!$Z19)","v":""},{"$f":"IF('Crash Data'!$AA19=\"\",\"\",'Crash Data'!$AA19)","v":""},{"$f":"IF('Crash Data'!$AC19=\"\",\"\",IF('Crash Data'!$AC19=\"NO DRUGS DETECTED\",\"\",'Crash Data'!$AC19))","v":""},{"$f":"IF('Crash Data'!$AD19=\"\",\"\",'Crash Data'!$AD19)","v":""},{"$f":"IF('Crash Data'!$AE19=\"\",\"\",'Crash Data'!$AE19)","v":""},{"$f":"IF('Crash Data'!$AH19=\"\",\"\",'Crash Data'!$AH19)","v":""},{"$f":"IF('Crash Data'!$AI19=\"\",\"\",'Crash Data'!$AI19)","v":""},{"$f":"IF('Crash Data'!$AJ19=\"\",\"\",'Crash Data'!$AJ19)","v":""},{"$f":"IF('Crash Data'!$AN19=\"\",\"\",IF('Crash Data'!$AN19=\"NO DRUGS DETECTED\",\"\",'Crash Data'!$AN19))","v":""},{"$f":"IF('Crash Data'!$AO19=\"\",\"\",IF('Crash Data'!$AO19=\"SPECIAL AREA - NOT STATED\",\"\",'Crash Data'!$AO19))","v":""},{"$f":"IF('Crash Data'!$BD19=\"\",\"\",'Crash Data'!$BD19)","v":""},{"$f":"IF('Crash Data'!$BE19=\"\",\"\",'Crash Data'!$BE19)","v":""}]
["ROW ID","CRASH SEVERITY","TYPE OF CRASH","CRASH DT","HOUR","DAY","LIGHT CONDITION","ROAD CONDITION","LOCATION","CONTRIBUTING FACTOR1","ACTION1","DIRECTION FROM1","DIRECTION TO1","OBJECT STRUCK1","DRIVER ALCOHOL1","CONTRIBUTING FACTOR2","ACTION2","DIRECTION FROM2","DIRECTION TO2","DRIVER ALCOHOL2","ROAD CONTOUR","FATAL","SERIOUS INJ","MINOR INJ","NO VISIBLE INJ","ACCIDENT NBR","LOCAL REPORT NBR","NLFID","LOGPOINT","STREET1","STREET2 REFERENCE","DISTANCE OFFSET","DIRECTION FROM REF","NUMBER OF VEHICLES","WEATHER CONDITION","VEHICLE TYPE1","DRIVER AGE1","DRIVER GENDER1","TRAFFIC CONTROL1","DRIVER DRUGS1","ESTIMATED SPEED1","POSTED SPEED1","VEHICLE TYPE2","DRIVER AGE2","DRIVER GENDER2","DRIVER DRUGS2","SPECIAL AREA","YEAR","MONTH"]

{"sheet":"Resurfacing Analysis","index":6,"n_rows":212,"n_cols":86,"rows_kept":212,"cut":false,"hidden":false,"merged":[[0,79,0,83],[8,79,8,83],[16,79,16,83],[22,79,22,83],[1,79,2,79],[1,80,1,83],[9,79,10,79],[9,80,9,83],[17,79,18,79],[17,80,17,83],[23,79,24,79],[23,80,23,83]]}
[null,null,{"$f":"'Crash Data'!A3","v":"- - (-)     From // to //"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State System Resurfacing Crash Analysis - Rural",null,null,null,null,null,{"$f":"IF(D4=\"ODOT Let Project\",\"ODOT Central Office\",\"ODOT District Office\")","v":"ODOT District Office"}]
[null,null,"Section 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADT Range","Data Values"]
[null,null,"Section System - State or Local",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D"]
[null,null,"Project Let Type - ODOT or Local",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateRural",400,"400 - 1,000",4,4,4,2.5]
[null,null,"Section Begin Log",{"$f":"IF('Crash Data'!$D$15=\"\",\"None\",'Crash Data'!$D$15+0)","v":"None"},"    Update and Run Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateRural",1001,"1,001 - 2,000",4,4,4,2]
[null,null,"Section End Log",{"$f":"IF('Crash Data'!$D$16=\"\",\"None\",'Crash Data'!$D$16+0)","v":"None"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateRural",2001,"2,001 - 3,000",4,4,4,1.75]
[null,null,"Bin Lenth (Miles)",0.5,"    Default = 0.5 Miles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateRural",3001,"3,001 - 6,000",4,4,4,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE_OF_CRASH_TXT","(All)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateRural",6000.01,"> 6,000",5,4,4,1]
["Must Enter Data for Fields in Yellow!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE_OF_CRASH_TXT","(All)",null,"Excludes Animal Crashes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State System Resurfacing Crash Analysis - Urban"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excludes Animal Crashes",null,null,"Count","LOCATION_TXT2","LOCATION_TXT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADT Range","Data Values"]
[null,null,null,null,null,null,null,null,null,null,"Threshold Values",null,null,null,null,null,null,null,null,null,null,null,"Count",null,null,null,null,null,null,null,null,null,null,null,null,"Count","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,"W","X","Y","Z"]
["Section Comments","Exception Indicator","Section","Section Type \n(Rural/Urban)","ADT","Non-Intersection Crashes\n(w/o Animal)","Intersection Related Crashes\n(w/o Animal)","Total Crashes\n(w/o Animal)","Crash Rate \"R\" - MVMT\n(w/o Animal)",null,{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"A\",\"W\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"B\",\"X\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"C\",\"Y\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"D\",\"Z\"))","v":""},null,{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"A & B Check\",\"W & X Check\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"C Check\",\"Y Check\"))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13=\"Rural\",\"D Check\",\"Z Check\"))","v":""},null,null,null,null,"LOGPOINT_SLM_NBR","Total",null,"LOGPOINT_SLM_NBR",null,null,null,null,null,null,null,null,null,"LOGPOINT_SLM_NBR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateUrban",400,"400 - 6,000",4,4,4,3.5]
[null,{"$f":"IF(AND(P13=\"No\",Q13=\"No\"),\"\",IF(P13=\"Yes\",\"Send Crash Summary to \"&$CH$1,IF(AND(P13=\"No\",Q13=\"Yes\",R13=\"Yes\"),\"Send Crash Summary to \"&$CH$1,\"\")))","v":""},{"$f":"IF(W13=\"\",\"\",VLOOKUP(W13,$W$13:$X$500,1,FALSE))","v":"99.77-100.27"},null,null,{"$f":"IF(C13=\"\",\"\",H13-G13)","v":2},{"$f":"IF(C13=\"\",\"\",IF($AA$11=\"IntersectionRelated\",VLOOKUP(W13,$Z$13:$AF$500,2,FALSE),\"0\"))","v":"0"},{"$f":"IF(W13=\"\",\"\",VLOOKUP(W13,$W$13:$X$500,2,FALSE))","v":2},{"$f":"IF(C13=\"\",\"\",IF(C13=\"Total\",\"\",1000000*((H13))/(365*3*$D$7*E13)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($C13=\"\",\"\",IF($E13<400,\"\",IF($D$3&$D13=\"StateRural\",VLOOKUP($E13,$CA$4:$CF$8,3,TRUE),IF($D$3&$D13=\"StateUrban\",VLOOKUP($E13,$CA$12:$CF$16,3,TRUE),IF($D$3&$D13=\"LocalRural\",VLOOKUP($E13,$CA$20:$CF$22,3,TRUE),IF($D$3&$D13=\"LocalUrban\",VLOOKUP($E13,$CA$26:$CF$30,3,TRUE)))))))","v":""},{"$f":"IF($C13=\"\",\"\",IF($E13<400,\"\",IF($D$3&$D13=\"StateRural\",VLOOKUP($E13,$CA$4:$CF$8,4,TRUE),IF($D$3&$D13=\"StateUrban\",VLOOKUP($E13,$CA$12:$CF$16,4,TRUE),IF($D$3&$D13=\"LocalRural\",VLOOKUP($E13,$CA$20:$CF$22,4,TRUE),IF($D$3&$D13=\"LocalUrban\",VLOOKUP($E13,$CA$26:$CF$30,4,TRUE)))))))","v":""},{"$f":"IF($C13=\"\",\"\",IF($E13<400,\"\",IF($D$3&$D13=\"StateRural\",VLOOKUP($E13,$CA$4:$CF$8,5,TRUE),IF($D$3&$D13=\"StateUrban\",VLOOKUP($E13,$CA$12:$CF$16,5,TRUE),IF($D$3&$D13=\"LocalRural\",VLOOKUP($E13,$CA$20:$CF$22,5,TRUE),IF($D$3&$D13=\"LocalUrban\",VLOOKUP($E13,$CA$26:$CF$30,5,TRUE)))))))","v":""},{"$f":"IF($C13=\"\",\"\",IF($E13<400,\"\",IF($D$3&$D13=\"StateRural\",VLOOKUP($E13,$CA$4:$CF$8,6,TRUE),IF($D$3&$D13=\"StateUrban\",VLOOKUP($E13,$CA$12:$CF$16,6,TRUE),IF($D$3&$D13=\"LocalRural\",VLOOKUP($E13,$CA$20:$CF$22,6,TRUE),IF($D$3&$D13=\"LocalUrban\",VLOOKUP($E13,$CA$26:$CF$30,6,TRUE)))))))","v":""},null,{"$f":"IF(K13=\"\",\"\",IF(AND(F13>K13,G13>L13),\"Yes\",\"No\"))","v":""},{"$f":"IF(M13=\"\",\"\",IF(H13>M13,\"Yes\",\"No\"))","v":""},{"$f":"IF(N13=\"\",\"\",IF(I13>N13,\"Yes\",\"No\"))","v":""},null,null,null,null,"99.77-100.27",2,null,"Total",null,null,null,null,null,null,null,null,null,"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateUrban",6001,"6,001 - 10,000",6,7,4,3.5]
[null,"",{"$f":"IF(W14=\"\",\"\",VLOOKUP(W14,$W$13:$X$500,1,FALSE))","v":"Total"},null,null,2,"0",2,"",null,"","","","",null,{"$f":"IF(K14=\"\",\"\",IF(AND(F14>K14,G14>L14),\"Yes\",\"No\"))","v":""},{"$f":"IF(M14=\"\",\"\",IF(H14>M14,\"Yes\",\"No\"))","v":""},{"$f":"IF(N14=\"\",\"\",IF(I14>N14,\"Yes\",\"No\"))","v":""},null,null,null,null,"Total",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateUrban",10001,"10,001 - 15,000",11,14,4,4.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateUrban",15001,"15,001 - 30,000",19,22,4,4.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StateUrban",30000.01,"> 30,000",35,9,4,1.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Roads Resurfacing Crash Analysis - Rural"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADT Range","Data Values"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalRural",400,"400 - 1,000",4,4,4,5.5]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalRural",1001,"1,001 - 1,500",4,4,4,3.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalRural",1500.01,"> 1,500",4,4,4,2]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local Roads Resurfacing Crash Analysis - Urban"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADT Range","Data Values"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W","X","Y","Z"]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalUrban",400,"400 - 2,500",4,4,4,6.75]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalUrban",2501,"2,501 - 5,000",4,4,4,4.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalUrban",5001,"5,001 - 7,500",5,5,4,4.25]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalUrban",7501,"7,501 - 10,000",7,7,4,3.75]
[null,"","",null,null,"","","","",null,"","","","",null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LocalUrban",10000.01,"> 10,000",13,12,4,4]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,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(AND(P77=\"No\",Q77=\"No\"),\"\",IF(P77=\"Yes\",\"Send Crash Summary to \"&$CH$1,IF(AND(P77=\"No\",Q77=\"Yes\",R77=\"Yes\"),\"Send Crash Summary to \"&$CH$1,\"\")))","v":""},"",null,null,{"$f":"IF(C77=\"\",\"\",H77-G77)","v":""},{"$f":"IF(C77=\"\",\"\",IF($AA$11=\"IntersectionRelated\",VLOOKUP(W77,$Z$13:$AF$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(W77=\"\",\"\",VLOOKUP(W77,$W$13:$X$500,2,FALSE))","v":""},{"$f":"IF(C77=\"\",\"\",IF(C77=\"Total\",\"\",1000000*((H77))/(365*3*$D$7*E77)))","v":""},null,{"$f":"IF($C77=\"\",\"\",IF($E77<400,\"\",IF($D$3&$D77=\"StateRural\",VLOOKUP($E77,$CA$4:$CF$8,3,TRUE),IF($D$3&$D77=\"StateUrban\",VLOOKUP($E77,$CA$12:$CF$16,3,TRUE),IF($D$3&$D77=\"LocalRural\",VLOOKUP($E77,$CA$20:$CF$22,3,TRUE),IF($D$3&$D77=\"LocalUrban\",VLOOKUP($E77,$CA$26:$CF$30,3,TRUE)))))))","v":""},{"$f":"IF($C77=\"\",\"\",IF($E77<400,\"\",IF($D$3&$D77=\"StateRural\",VLOOKUP($E77,$CA$4:$CF$8,4,TRUE),IF($D$3&$D77=\"StateUrban\",VLOOKUP($E77,$CA$12:$CF$16,4,TRUE),IF($D$3&$D77=\"LocalRural\",VLOOKUP($E77,$CA$20:$CF$22,4,TRUE),IF($D$3&$D77=\"LocalUrban\",VLOOKUP($E77,$CA$26:$CF$30,4,TRUE)))))))","v":""},{"$f":"IF($C77=\"\",\"\",IF($E77<400,\"\",IF($D$3&$D77=\"StateRural\",VLOOKUP($E77,$CA$4:$CF$8,5,TRUE),IF($D$3&$D77=\"StateUrban\",VLOOKUP($E77,$CA$12:$CF$16,5,TRUE),IF($D$3&$D77=\"LocalRural\",VLOOKUP($E77,$CA$20:$CF$22,5,TRUE),IF($D$3&$D77=\"LocalUrban\",VLOOKUP($E77,$CA$26:$CF$30,5,TRUE)))))))","v":""},{"$f":"IF($C77=\"\",\"\",IF($E77<400,\"\",IF($D$3&$D77=\"StateRural\",VLOOKUP($E77,$CA$4:$CF$8,6,TRUE),IF($D$3&$D77=\"StateUrban\",VLOOKUP($E77,$CA$12:$CF$16,6,TRUE),IF($D$3&$D77=\"LocalRural\",VLOOKUP($E77,$CA$20:$CF$22,6,TRUE),IF($D$3&$D77=\"LocalUrban\",VLOOKUP($E77,$CA$26:$CF$30,6,TRUE)))))))","v":""},null,"","",""]
[null,"",{"$f":"IF(W78=\"\",\"\",VLOOKUP(W78,$W$13:$X$500,1,FALSE))","v":""},null,null,"","","","",null,"","","","",null,{"$f":"IF(K78=\"\",\"\",IF(AND(F78>K78,G78>L78),\"Yes\",\"No\"))","v":""},{"$f":"IF(M78=\"\",\"\",IF(H78>M78,\"Yes\",\"No\"))","v":""},{"$f":"IF(N78=\"\",\"\",IF(I78>N78,\"Yes\",\"No\"))","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,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,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(AND(P141=\"No\",Q141=\"No\"),\"\",IF(P141=\"Yes\",\"Send Crash Summary to \"&$CH$1,IF(AND(P141=\"No\",Q141=\"Yes\",R141=\"Yes\"),\"Send Crash Summary to \"&$CH$1,\"\")))","v":""},"",null,null,{"$f":"IF(C141=\"\",\"\",H141-G141)","v":""},{"$f":"IF(C141=\"\",\"\",IF($AA$11=\"IntersectionRelated\",VLOOKUP(W141,$Z$13:$AF$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(W141=\"\",\"\",VLOOKUP(W141,$W$13:$X$500,2,FALSE))","v":""},{"$f":"IF(C141=\"\",\"\",IF(C141=\"Total\",\"\",1000000*((H141))/(365*3*$D$7*E141)))","v":""},null,{"$f":"IF($C141=\"\",\"\",IF($E141<400,\"\",IF($D$3&$D141=\"StateRural\",VLOOKUP($E141,$CA$4:$CF$8,3,TRUE),IF($D$3&$D141=\"StateUrban\",VLOOKUP($E141,$CA$12:$CF$16,3,TRUE),IF($D$3&$D141=\"LocalRural\",VLOOKUP($E141,$CA$20:$CF$22,3,TRUE),IF($D$3&$D141=\"LocalUrban\",VLOOKUP($E141,$CA$26:$CF$30,3,TRUE)))))))","v":""},{"$f":"IF($C141=\"\",\"\",IF($E141<400,\"\",IF($D$3&$D141=\"StateRural\",VLOOKUP($E141,$CA$4:$CF$8,4,TRUE),IF($D$3&$D141=\"StateUrban\",VLOOKUP($E141,$CA$12:$CF$16,4,TRUE),IF($D$3&$D141=\"LocalRural\",VLOOKUP($E141,$CA$20:$CF$22,4,TRUE),IF($D$3&$D141=\"LocalUrban\",VLOOKUP($E141,$CA$26:$CF$30,4,TRUE)))))))","v":""},{"$f":"IF($C141=\"\",\"\",IF($E141<400,\"\",IF($D$3&$D141=\"StateRural\",VLOOKUP($E141,$CA$4:$CF$8,5,TRUE),IF($D$3&$D141=\"StateUrban\",VLOOKUP($E141,$CA$12:$CF$16,5,TRUE),IF($D$3&$D141=\"LocalRural\",VLOOKUP($E141,$CA$20:$CF$22,5,TRUE),IF($D$3&$D141=\"LocalUrban\",VLOOKUP($E141,$CA$26:$CF$30,5,TRUE)))))))","v":""},{"$f":"IF($C141=\"\",\"\",IF($E141<400,\"\",IF($D$3&$D141=\"StateRural\",VLOOKUP($E141,$CA$4:$CF$8,6,TRUE),IF($D$3&$D141=\"StateUrban\",VLOOKUP($E141,$CA$12:$CF$16,6,TRUE),IF($D$3&$D141=\"LocalRural\",VLOOKUP($E141,$CA$20:$CF$22,6,TRUE),IF($D$3&$D141=\"LocalUrban\",VLOOKUP($E141,$CA$26:$CF$30,6,TRUE)))))))","v":""},null,"","",""]
[null,"",{"$f":"IF(W142=\"\",\"\",VLOOKUP(W142,$W$13:$X$500,1,FALSE))","v":""},null,null,"","","","",null,"","","","",null,{"$f":"IF(K142=\"\",\"\",IF(AND(F142>K142,G142>L142),\"Yes\",\"No\"))","v":""},{"$f":"IF(M142=\"\",\"\",IF(H142>M142,\"Yes\",\"No\"))","v":""},{"$f":"IF(N142=\"\",\"\",IF(I142>N142,\"Yes\",\"No\"))","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,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,null,"","","","",null,"","","","",null,"","",""]
[null,"","",null,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(AND(P205=\"No\",Q205=\"No\"),\"\",IF(P205=\"Yes\",\"Send Crash Summary to \"&$CH$1,IF(AND(P205=\"No\",Q205=\"Yes\",R205=\"Yes\"),\"Send Crash Summary to \"&$CH$1,\"\")))","v":""},"",null,null,{"$f":"IF(C205=\"\",\"\",H205-G205)","v":""},{"$f":"IF(C205=\"\",\"\",IF($AA$11=\"IntersectionRelated\",VLOOKUP(W205,$Z$13:$AF$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(W205=\"\",\"\",VLOOKUP(W205,$W$13:$X$500,2,FALSE))","v":""},{"$f":"IF(C205=\"\",\"\",IF(C205=\"Total\",\"\",1000000*((H205))/(365*3*$D$7*E205)))","v":""},null,{"$f":"IF($C205=\"\",\"\",IF($E205<400,\"\",IF($D$3&$D205=\"StateRural\",VLOOKUP($E205,$CA$4:$CF$8,3,TRUE),IF($D$3&$D205=\"StateUrban\",VLOOKUP($E205,$CA$12:$CF$16,3,TRUE),IF($D$3&$D205=\"LocalRural\",VLOOKUP($E205,$CA$20:$CF$22,3,TRUE),IF($D$3&$D205=\"LocalUrban\",VLOOKUP($E205,$CA$26:$CF$30,3,TRUE)))))))","v":""},{"$f":"IF($C205=\"\",\"\",IF($E205<400,\"\",IF($D$3&$D205=\"StateRural\",VLOOKUP($E205,$CA$4:$CF$8,4,TRUE),IF($D$3&$D205=\"StateUrban\",VLOOKUP($E205,$CA$12:$CF$16,4,TRUE),IF($D$3&$D205=\"LocalRural\",VLOOKUP($E205,$CA$20:$CF$22,4,TRUE),IF($D$3&$D205=\"LocalUrban\",VLOOKUP($E205,$CA$26:$CF$30,4,TRUE)))))))","v":""},{"$f":"IF($C205=\"\",\"\",IF($E205<400,\"\",IF($D$3&$D205=\"StateRural\",VLOOKUP($E205,$CA$4:$CF$8,5,TRUE),IF($D$3&$D205=\"StateUrban\",VLOOKUP($E205,$CA$12:$CF$16,5,TRUE),IF($D$3&$D205=\"LocalRural\",VLOOKUP($E205,$CA$20:$CF$22,5,TRUE),IF($D$3&$D205=\"LocalUrban\",VLOOKUP($E205,$CA$26:$CF$30,5,TRUE)))))))","v":""},{"$f":"IF($C205=\"\",\"\",IF($E205<400,\"\",IF($D$3&$D205=\"StateRural\",VLOOKUP($E205,$CA$4:$CF$8,6,TRUE),IF($D$3&$D205=\"StateUrban\",VLOOKUP($E205,$CA$12:$CF$16,6,TRUE),IF($D$3&$D205=\"LocalRural\",VLOOKUP($E205,$CA$20:$CF$22,6,TRUE),IF($D$3&$D205=\"LocalUrban\",VLOOKUP($E205,$CA$26:$CF$30,6,TRUE)))))))","v":""},null,"","",""]
[null,"",{"$f":"IF(W206=\"\",\"\",VLOOKUP(W206,$W$13:$X$500,1,FALSE))","v":""},null,null,"","","","",null,"","","","",null,{"$f":"IF(K206=\"\",\"\",IF(AND(F206>K206,G206>L206),\"Yes\",\"No\"))","v":""},{"$f":"IF(M206=\"\",\"\",IF(H206>M206,\"Yes\",\"No\"))","v":""},{"$f":"IF(N206=\"\",\"\",IF(I206>N206,\"Yes\",\"No\"))","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,"","",""]

{"sheet":"Rate Calc Sheet","index":7,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,2,3,4],[9,24,9,25],[7,24,7,25],[3,24,3,25],[4,24,4,25],[5,24,5,25],[6,24,6,25],[3,20,3,21],[4,20,4,21],[5,20,5,21],[8,20,8,21],[6,20,6,21],[3,16,3,17],[4,16,4,17],[5,16,5,17],[7,16,7,17],[26,2,26,4],[4,2,4,4],[6,2,6,4],[5,2,5,4],[7,2,7,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4]]}
[]
[]
[]
[null,"County:",{"$f":"'Crash Data'!D12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Entering Leg 1 ",null,null,null,"Entering Leg 1 ",3400,null,null,"Entering Leg 1 "]
[null,"R1:",{"$f":"'Crash Data'!G21","v":"SR0159R"},null,null,null,null,null,null,null,null,null,null,null,null,"Entering Leg 2 ",null,null,null,"Entering Leg 2 ",5600,null,null,"Entering Leg 2 "]
[null,"R1 Log:",{"$f":"'Crash Data'!D15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Entering Leg 3 ",null,null,null,"Entering Leg 3 ",6250,null,null,"Entering Leg 3 "]
[null,"R2:",{"$f":"'Crash Data'!H21","v":"MP002.70"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entering Leg 4 ",2300,null,null,"Entering Leg 4 "]
[null,"Crash Year Data:",{"$f":"LEFT('Crash Data'!D17,4)&\"-\"&LEFT('Crash Data'!D18,4)","v":"-"},null,null,null,null,null,null,null,null,null,null,null,null,"Entering Vehicles ",{"$f":"SUM(Q4:R6)","v":0},null,null,null,null,null,null,"Entering Leg 5 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entering Vehicles ",{"$f":"SUM(U4:V7)","v":17550}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entering Vehicles ",{"$f":"SUM(Y4:Z8)","v":0}]
[]
["Enter Number of Crashes for Intersection:",null,null,null,null,{"$f":"GETPIVOTDATA(\"DAY_OF_WEEK\",'Data Analysis'!$A$4)","v":0}]
["Enter Number of Years for Crash Data:",null,null,null,null,3]
["Enter Number of Intersection Entering Vehicles:"]
["Number of Days in Year:",null,null,null,null,365]
[]
["Crash Rate per Million Entering Vehicles (MEV):",null,null,null,null,{"$f":"(F12*1000000)/(F14*F13*F15)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[null,"County:",{"$f":"'Crash Data'!D12","v":0}]
[null,"Route:",{"$f":"'Crash Data'!G21","v":"SR0159R"}]
[null,"BLog:",{"$f":"'Crash Data'!D15","v":0}]
[null,"ELog:",{"$f":"'Crash Data'!D16","v":0}]
[null,"Crash Year Data:",{"$f":"LEFT('Crash Data'!D17,4)&\"-\"&LEFT('Crash Data'!D18,4)","v":"-"}]
[]
[]
[]
["Enter Number of Crashes on Section:",null,null,null,null,{"$f":"GETPIVOTDATA(\"DAY_OF_WEEK\",'Data Analysis'!$A$4)","v":0}]
["Enter Number of Years for Crash Data:",null,null,null,null,3]
["Enter Average Daily Traffic on Section (ADT):"]
["Enter Length of Section in Miles",null,null,null,null,{"$f":"C26-C25","v":0}]
["Number of Days in Year:",null,null,null,null,365]
[]
["Crash Rate per Million Vehicle Miles Traveled (MVMT):",null,null,null,null,{"$f":"(F31*1000000)/(F33*F35*F32*F34)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Severity Calc Sheet","index":8,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,3,3,7]]}
["Select Location Type:",null,"Rural Non-Freeway"]
[]
[null,"RSI Value = ",{"$f":"IFERROR(C25/(A25+B25),0)","v":28801.024779765034}]
[null,null,null,"2010 Relative Severity Index"]
["User Override","Auto Fill","Crash Type Severity Calc","Crash Type #","Crash Type","Rural Non-Freeway","Urban Non-Freeway","Freeway"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Not Stated*\"),\"\")","v":0},{"$f":"IF(C$1=F$5,IF(A6=\"\",B6*F6,A6*F6),IF(C$1=G$5,IF(A6=\"\",B6*G6,A6*G6),IF(C$1=H$5,IF(A6=\"\",B6*H6,A6*H6))))","v":0},0,"Not stated",22495.496153846154,35099.914728682168,19558.713592233009]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Head On*\"),\"\")","v":0},0,1,"Head on",139612.73533619457,56730.281786941581,224462.76470588235]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Rear End*\"),\"\")","v":4},114417.26339238358,2,"Rear end",28604.315848095895,25525.24077238551,28134.793720873193]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Backing*\"),\"\")","v":0},0,3,"Backing",26274.989122552575,21673.695509822264,21202.435736677115]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Sideswipe - meeting*\"),\"\")","v":0},0,4,"Sideswipe - meeting",64558.806666666664,35570.730679156906,122237.39719626168]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Sideswipe - passing*\"),\"\")","v":1},29587.860506441582,5,"Sideswipe - passing",29587.860506441582,24436.102608252026,28476.159070367979]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Angle*\")+COUNTIF('Crash Data'!M$21:M$65000,\"Right*\"),\"\")","v":0},0,6,"Angle",50714.097066802307,28670.942599425995,29939.59085580305]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Parked vehicle*\"),\"\")","v":0},0,7,"Parked Vehicle",23668.881625441696,22377.471454545455,39780.077436582113]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Pedestrian*\"),\"\")","v":0},0,8,"Pedestrian",147075.45533769063,67613.518295307789,217965.17808219179,null,"DO NOT MODIFY CELLS IN THIS COLUMN"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Animal*\"),\"\")","v":0},0,9,"Animal",16981.480862563425,27306.548387096773,16185.218889765851]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Train*\"),\"\")","v":0},0,10,"Train",149166.33333333334,46514.244897959186,0,null,"Rural Non-Freeway"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Pedalcycles*\"),\"\")","v":0},0,11,"Pedalcycles",67709.01760563381,41399.148302561051,28890.333333333332,null,"Urban Non-Freeway"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Other non-vehicle*\"),\"\")","v":0},0,12,"Other non-vehicle",37299,32696,0,null,"Freeway"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Fixed object*\")+COUNTIF('Crash Data'!M$21:M$65000,\"Ran*\"),\"\")","v":0},0,13,"Fixed object",31070.352171676343,26392.445748887789,22936.281703499953]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Other object*\"),\"\")","v":0},0,14,"Other object",19878.019058295966,17353.566844919787,16568.747452692867]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Falling from or in vehicle*\"),\"\")","v":0},0,15,"Falling from or in vehicle",0,0,0]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Overturning*\"),\"\")","v":0},0,16,"Overturning",60792.533710756565,50151.644880174295,49417.114379084967]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Other non-collision*\"),\"\")","v":0},0,17,"Other non-collision",19721.838340486411,23835.448458149778,28496.191857222533]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Left*\"),\"\")","v":0},{"$f":"IF(C$1=F$5,IF(A24=\"\",B24*F24,A24*F24),IF(C$1=G$5,IF(A24=\"\",B24*G24,A24*G24),IF(C$1=H$5,IF(A24=\"\",B24*H24,A24*H24))))","v":0},18,"Left Turn",44906.151534526856,34244.558985403208,40148.938080495354]
[{"$f":"SUM(A6:A24)","v":0},{"$f":"SUM(B6:B24)","v":5},{"$f":"SUM(C6:C24)","v":144005.12389882517}]
[]
[]
[]
[null,null,"   Select Appropriate \"Location Type\" and Modify the \"User Override\" Cells in Yellow if Necessary",null,null,null,null,null,null,"TYPE_OF_CRASH_TXT"]
[null,null,null,null,null,null,null,null,null,"LEFT TURN"]
[null,null,null,null,null,null,null,null,null,"RIGHT TURN"]
[null,null,null,null,null,null,null,null,null,"RAN OFF ROAD"]
[null,null,null,null,null,null,null,null,null,"SIDESWIPE - MEETING"]
[null,null,null,null,null,null,null,null,null,"HEAD ON"]
[null,null,null,null,null,null,null,null,null,"OTHER NON-VEHICLE"]
[null,null,null,null,null,null,null,null,null,"SIDESWIPE - PASSING"]
[null,null,null,null,null,null,null,null,null,"OVERTURNING"]
[null,null,null,null,null,null,null,null,null,"PARKED VEHICLE"]
[null,null,null,null,null,null,null,null,null,"FIXED OBJECT"]
[null,null,null,null,null,null,null,null,null,"NOT STATED"]
[null,null,null,null,null,null,null,null,null,"BACKING"]
[null,null,null,null,null,null,null,null,null,"PEDALCYCLES"]
[null,null,null,null,null,null,null,null,null,"ANGLE"]
[null,null,null,null,null,null,null,null,null,"PEDESTRIAN"]
[null,null,null,null,null,null,null,null,null,"TRAIN"]
[null,null,null,null,null,null,null,null,null,"ANIMAL"]
[null,null,null,null,null,null,null,null,null,"OTHER OBJECT"]
[null,null,null,null,null,null,null,null,null,"REAR END"]
[null,null,null,null,null,null,null,null,null,"OTHER NON-COLLISION"]

{"sheet":"ROR Analysis","index":9,"n_rows":87,"n_cols":78,"rows_kept":87,"cut":false,"hidden":false,"merged":[[51,17,51,19],[36,14,36,20],[37,0,37,32],[26,31,26,32],[27,31,27,32],[29,12,29,13],[30,19,30,20],[29,19,29,20],[36,23,36,30],[33,28,33,30],[30,28,30,30],[27,21,27,22],[28,19,28,20],[26,19,26,20],[27,19,27,20],[8,11,8,12],[36,31,36,32],[36,21,36,22],[8,19,8,20],[28,31,28,32],[29,31,29,32],[29,28,29,30],[51,0,51,9],[51,10,51,12],[49,0,49,9],[50,0,50,9],[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],[30,31,30,32],[29,21,29,22],[30,21,30,22],[45,28,45,30],[42,0,42,32],[39,26,39,27],[40,16,40,19],[43,14,43,19],[40,20,40,21],[40,23,40,24],[39,6,39,7],[39,23,39,24],[8,25,8,26],[38,0,38,4],[39,0,39,4],[40,0,40,4],[39,16,39,19],[40,6,40,7],[40,26,40,27],[39,20,39,21],[50,21,50,24],[43,28,43,30],[43,21,43,22],[44,21,44,22],[46,21,46,22],[46,28,46,30],[43,24,43,26],[44,24,44,26],[46,24,46,26],[48,0,48,32],[49,10,49,12],[50,10,50,12],[44,28,44,30],[49,17,49,19],[50,17,50,19],[8,33,8,34],[28,21,28,22],[22,21,22,22],[23,21,23,22],[25,21,25,22],[25,28,25,30],[26,28,26,30],[27,28,27,30],[26,21,26,22],[22,28,22,30],[23,28,23,30],[24,28,24,30],[8,21,8,22],[8,23,8,24],[3,23,3,25],[20,12,20,13],[20,0,20,11],[20,14,20,22],[20,23,20,32],[8,13,8,14],[8,15,8,16],[8,17,8,18],[8,1,8,2],[8,3,8,4],[7,1,7,6],[7,7,7,12],[3,2,3,5],[5,2,5,5],[3,10,3,15],[4,10,4,15],[5,7,5,9],[33,12,33,13],[25,1,25,11],[21,12,21,13],[22,12,22,13],[23,12,23,13],[21,1,21,11],[22,1,22,11],[23,1,23,11],[24,1,24,11],[28,12,28,13],[30,12,30,13],[3,18,3,20],[35,12,35,13],[31,19,31,20],[31,21,31,22],[32,19,32,20],[32,21,32,22],[33,19,33,20],[33,21,33,22],[31,12,31,13],[32,12,32,13],[34,12,34,13],[22,19,22,20],[23,19,23,20],[24,19,24,20],[25,19,25,20],[33,31,33,32],[8,31,8,32],[31,28,31,30],[31,31,31,32],[22,31,22,32],[23,31,23,32],[24,31,24,32],[25,31,25,32],[28,28,28,30],[21,28,21,30],[5,18,5,20],[5,23,5,25],[7,13,7,32],[32,28,32,30],[32,31,32,32],[24,12,24,13],[24,21,24,22],[25,12,25,13],[26,12,26,13],[27,12,27,13]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE OF RETURN - ECONOMIC ANALYSIS WORKSHEET"]
["Cells in Yellow Require User Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ohio Department of Transportation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office of Systems Planning and Program Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTIMATES OF COUNTERMEASURE EFFECTIVENESS REDUCTION (R) FACTORS"]
["County",null,{"$f":"'Crash Data'!D12","v":0},null,null,null,"Main Roadway",null,null,null,{"$f":"'Crash Data'!D13","v":0},null,null,null,null,null,"Begin SLM",null,{"$f":"'Crash Data'!D15","v":0},null,null,"End SLM",null,{"$f":"'Crash Data'!D16","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(September 1997, Revised July 2007)"]
[null,null,null,null,null,null,"Intersecting Roadway",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number","Description"]
["Prepared by ",null,"JH",null,null,null,"Date",{"$f":"NOW()","v":"2012-01-09T14:14:29.130"},null,null,null,null,null,null,null,null,"Crash BDate",null,{"$f":"'Crash Data'!D17","v":0},null,null,"Crash EDate",null,{"$f":"'Crash Data'!D18","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"1 Upgrade pavement markings - general"]
["Year","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,2,"2 Install raised pavement markers, locations & sections"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"3 Install plastic pavement markings"]
[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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"4 De-slick pavement - sections [except wet pavement crashes]"]
[2006,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2006\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2006\")","v":0},{"$f":"N11+P11+R11+T11+V11+X11+Z11+AB11+AD11+AF11","v":0},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,null,null,5,"5 Resurface - rural sections - 2 lane"]
[2007,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2007\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2007\")","v":0},0,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,null,null,6,"5a Resurface - rural sections > 2 lane"]
[2008,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2008\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2008\")","v":0},0,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,null,null,7,"56 Resurface - urban section > 2 lane"]
[2009,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2009\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2009\")","v":0},0,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,null,null,8,"6 Upgrade signs - general"]
[2010,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2010\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2010\")","v":0},0,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,null,null,9,"7 Lane use signs - overhead"]
[2011,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2011\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2011\")","v":0},0,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,null,null,10,"8 Warning signs at intersection - rural"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"9 Warning signs on section - rural 2 lane"]
["TOTAL",{"$f":"SUM(B13:B15)","v":0},{"$f":"SUM(C13: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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"9a Warning signs on section - rural > 2 lane"]
["AVG.",{"$f":"AVERAGE(B13:B15)","v":0},{"$f":"AVERAGE(C13: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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"57 Install/Improve warning signs on rural curves [curve crashes only]"]
["--The \"TOTAL\" and \"AVERAGE\" row formulas are set to only use 2008-2010 crash data.  If the crash data is not for these three years, the formulas must be modified by the user to calculate the associated year data.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"30 Install warning sign-mounted flasher"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"31 Install PTSWF sign/flasher [for approach speeds > 45 mph]"]
[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. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"58 Install/Improve warning signs on sections - rural 2 lane"]
["R1","",null,null,null,null,null,null,null,null,null,null,{"$f":"P9","v":"LEFT"},null,null,null,null,null,{"$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,null,null,null,null,{"$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},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"58a Install/Improve warning signs on sections - rural > 2 lane"]
["R2","",null,null,null,null,null,null,null,null,null,null,{"$f":"R9","v":"RIGHT"},null,null,null,null,null,0,{"$f":"R19","v":0},null,0,null,null,null,null,null,0,{"$f":"S19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"59 Install/Improve warning signs on sections - urban 2 lane"]
["R3","",null,null,null,null,null,null,null,null,null,null,{"$f":"T9","v":"ANGLE"},null,null,null,null,null,0,{"$f":"T19","v":0},null,0,null,null,null,null,null,0,{"$f":"U19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"59a Install/Improve warning signs on sections - urban > 2 lane"]
["R4","",null,null,null,null,null,null,null,null,null,null,{"$f":"N9","v":"REAR END"},null,null,null,null,null,0,{"$f":"N19","v":0},null,0,null,null,null,null,null,0,{"$f":"O19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"60 Install delineators at curve - rural [Curve crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V9","v":"HEAD ON"},null,null,null,null,null,0,{"$f":"V19","v":0},null,0,null,null,null,null,null,0,{"$f":"W19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"13 Install concrete median barrier [median and cross-median crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X9","v":"SS PASS"},null,null,null,null,null,0,{"$f":"X19","v":0},null,0,null,null,null,null,null,0,{"$f":"Y19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"14 Install painted median"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z9","v":"FIXED OBJ"},null,null,null,null,null,0,{"$f":"Z19","v":0},null,0,null,null,null,null,null,0,{"$f":"AA19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"15 Install two-way left turn lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB9","v":"RAN OFF RD"},null,null,null,null,null,0,{"$f":"AB19","v":0},null,0,null,null,null,null,null,0,{"$f":"AC19","v":0},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"41 Flatten vertical curve"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF9","v":"OTHER"},null,null,null,null,null,0,{"$f":"AF19","v":0},null,0,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"16 Install left turn bay & extra pavement without signal"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NIGHT",null,null,null,null,null,0,{"$f":"F19","v":0},null,0,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"17 Install left turn bay & extra pavement with signal"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J9","v":"WET"},null,null,null,null,null,0,{"$f":"J19","v":0},null,0,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"37 Widen roadway, rural section, no additional lanes"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD9","v":"PEDESTRIAN"},null,null,null,null,null,0,{"$f":"AD19","v":0},null,0,null,null,null,null,null,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,28,"38 Widen roadway, rural section, including additional lanes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,29,"39 Widen for left turn lane, including resurfacing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"40 Widen for right turn lane, including resurfacing"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"42 Stabilize berms - rural section"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"20 Upgrade existing flasher"]
["Project Service Life",null,null,null,null,"20","years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"21 Install flasher"]
["Present ADT (PADT)",null,null,null,null,22465,"veh / day",null,null,null,null,null,null,"Average ADT = ",null,null,"(PADT + FADT)/2   =  (",null,null,null,{"$f":"F40","v":22465},null,"+",{"$f":"F41","v":24560},null,") =",{"$f":"(U40+X40)/2","v":23512.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"22 Upgrade existing signal - general"]
["Future ADT (FADT)",null,null,null,null,24560,"veh / day",null,null,null,null,null,null,"ADT Factor =",null,null,"Average ADT / PADT =",null,null,null,{"$f":"AA40","v":23512.5},null,"/",{"$f":"F40","v":22465},null,"=",{"$f":"U41/X41","v":1.0466280881371022},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,35,"23 Reconstruct existing signal - major"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":-1292872.9413989861},{"$f":"-$K$50","v":-1300000},{"$f":"$AC$47-$K$51","v":0},0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"24 Install traffic signal - all types"]
["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":-1285401.6199770402},-1300000,0,0,{"$f":"$AC$47-$K$51","v":0},0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"25 Revise signal timing"]
["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":9031.9148998330547},null,null,"=",{"$f":"V44*Y44","v":0},null,null,null,null,null,null,null,"10 Years",{"$f":"NPV(Z51,AN44:AW44,K52)-K50","v":-1212342.2128524925},-1300000,0,0,0,0,{"$f":"$AC$47-$K$51","v":0},0,0,0,0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"26 Add pedestrian heads"]
["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,"Rural State Highways",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":88748.190620782727},null,null,"=",{"$f":"V45*Y45","v":0},null,null,null,null,null,null,null,"15 Years",{"$f":"NPV(Z51,AN45:BB45,K52)-K50","v":-773647.92288509023},-1300000,0,0,0,0,0,0,0,0,0,{"$f":"$AC$47-$K$51","v":0},0,0,0,0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"27 Add left turn phase with new left turn lane"]
["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":1860546.4625404645},-1300000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$AC$47-$K$51","v":0},0,0,0,0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"28 Add left turn phase with existing left turn lane"]
["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":1.0466280881371022},null,"*",{"$f":"AC46","v":0},null,null,"=",{"$f":"Y47*V47","v":0},null,null,null,null,null,null,null,"25 Years",{"$f":"NPV(Z51,AN47:BL47,K52)-K50","v":17677894.029847819},-1300000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$AC$47-$K$51","v":0},0,0,0,0,{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,null,null,null,null,null,41,"29 Add left turn phase without left turn lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":112655123.29175965},-1300000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$AC$47-$K$51","v":0},{"$f":"$AC$47-$K$51","v":0},{"$f":"$AC$47-$K$51","v":0},{"$f":"$AC$47-$K$51","v":0},{"$f":"$AC$47-$K$51","v":0},{"$f":"$AC$47-$K$51+$K$52","v":1000},null,null,null,null,42,"32 Install optically programmed heads"]
["Rate of Return",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"33 Remove existing, unwarranted signal"]
["Total Safety Project Cost (Design, Right-of-Way, and Construction)",null,null,null,null,null,null,null,null,null,{"$f":"R50+R51+R52","v":1300000},null,null,null,"Design (PE)",null,null,{"$f":"IF(R52<100000,0,R52*0.1)","v":100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"61 Provide signal interconnection"]
["Annual Maintenance and Energy Costs",null,null,null,null,null,null,null,null,null,0,null,null,null,"Right-of-Way",null,null,200000,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),\"Invalid Year Entry\")))))))","v":-0.30128055054055236},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"34 Install intersection lighting"]
["Salvage Value",null,null,null,null,null,null,null,null,null,1000,null,null,null,"Construction",null,null,1000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"35 Install section lighting"]
["See Text Box Below for Additional Details on Project Costs for ODOT Safety Projects",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"36 Upgrade existing lighting"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"43 Replace culvert"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"44 Replace bridge"]
[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,50,"45 Widen bridge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"46 Widen culvert"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"62 Install guard rail at bridge end [Injury-fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"49 Install guard rail [Injury-fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,"63 Improve guard rail [Injury-fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"50 Remove or relocate fixed object to a safe distance from the roadway"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"64 Make utility pole breakaway [Utility pole fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,"65 Relocate utility pole 3 0' from edge of pavement [Utility pole fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,"66 Remove utility pole [Utility pole fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"67 Remove tree [Tree crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"68 Make sign support breakaway - all sizes [Sign injury-fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"69 Install auto. prot. device at R/R grade crossing [Train-vehicle crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,"48 Install impact attenuator device [Injury-fatal crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,"47 Eliminate fixed objects"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,"55 Improve horizontal alignment - rural section"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"70 Reconstruct curves on rural section - 2 lane [Curve crashes only]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,"10 Eliminate parking"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"11 Speed zone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"12 Prohibit turn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,"18 Close median opening"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"19 Relocate driveway entrance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,"51 Relocate intersection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,"52 Increase cross corner sight distance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,"71 Prohibit right-turn-on-red"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,"53 Install rumble strips"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,"54 Provide proper super-elevation on curve - rural [curve crashes only]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 - 2010)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 ","INJ/FAT","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,9031.9148998330547,88748.190620782727,"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,8441.785553486563,84402.546290216676,"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,9525.0089192509531,78553.117991479274,"Cities and Incorporated Villages"]

{"sheet":"Safety App","index":10,"n_rows":51,"n_cols":38,"rows_kept":51,"cut":false,"hidden":false,"merged":[[11,10,11,12],[18,0,18,15],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[13,10,13,12]]}
[]
[]
[]
[]
[]
["Location","Location Type","Facility Type","Begin Log","End Log","Length","Fatal Crashes","Injury Crashes","PDO Crashes","Total Crashes","Fatalities","Incapacitating Injuries","# of Years","ADT (Or Intersection Entering Volume)","Truck ADT","V/C"]
[{"$f":"'Crash Data'!D12&\"-\"&'Crash Data'!D13&'Crash Data'!D14","v":"-"},null,{"$f":"G34","v":"Rural Non-Freeway"},{"$f":"'Crash Data'!D15","v":0},{"$f":"'Crash Data'!D16","v":0},{"$f":"IF(B7=\"Section\",E7-D7,1)","v":1},{"$f":"IF(ISERROR(VLOOKUP(\"FATAL CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE)),VALUE(0),VLOOKUP(\"FATAL CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(\"INJURY CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE)),VALUE(0),VLOOKUP(\"INJURY CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP(\"PROPERTY DAMAGE CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE)),VALUE(0),VLOOKUP(\"PROPERTY DAMAGE CRASH\",'Data Analysis'!$A$10:$B$12,2,FALSE))","v":0},{"$f":"SUM(G7:I7)","v":0},{"$f":"VLOOKUP(\"Grand Total\",'Data Analysis'!$K$23:$M$39,2,FALSE)","v":0},{"$f":"VLOOKUP(\"Grand Total\",'Data Analysis'!$K$23:$M$39,3,FALSE)","v":0},3]
[]
["Year",2010,null,"Rate of Return:  ",{"$f":"IF(ISERROR('ROR Analysis'!Z51),VALUE(0),'ROR Analysis'!Z51)","v":-0.30128055054055236},null,null,null,null,null,"High Risk Rural Road Calculation:  ",{"$f":"IF(ISERROR(((K7+L7)*100000000)/(M7*365*F7*N7)),VALUE(0),((K7+L7)*100000000)/(M7*365*F7*N7))","v":0}]
["HSP Rank",null,null,null,null,null,null,null," (Fatalities & Incapacitating Injuries per 100 MVMT or Entering Vehicles)"]
["Hot Spot Rank"]
["Congestion Rank",null,null,null,null,null,null,null,null,"Functional Class :  "]
[null,null,null,null,null,null,null,null,"(Must be Rural Major Collector, Minor Collector, or Rural Local Road for HRRR Funding)"]
[null,null,null,null,null,null,null,null,null,"HRRR Eligible :  ",{"$f":"IF(K12=0,\"\",IF(L9>VLOOKUP(K12,$AK$36:$AL$38,2,FALSE),\"Yes\",\"No\"))","v":""}]
[]
[]
[]
[]
["Safety Project Scoring"]
[]
["Crash Frequency (10)",null,"Crash Density (10)",null,"Crash Rate (10)",null,"RSI (15)",null,"EPDO Rate (5)",null,"% Trucks (5)",null,"Rate of Return (5)",null,"V/C Ratio (5)"]
["Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score"]
[{"$f":"IF(ISERROR(IF(B7=\"Intersection\",J7,\"\")),VALUE(0),IF(B7=\"Intersection\",J7,\"\"))","v":""},{"$f":"IF(ISERROR(IF($B$7=\"Section\",\"\",VLOOKUP(A23,$Q$36:$R$46,2,TRUE))),VALUE(0),IF($B$7=\"Section\",\"\",VLOOKUP(A23,$Q$36:$R$46,2,TRUE)))","v":0},{"$f":"IF(ISERROR(IF(B7=\"Section\",J7/F7,\"\")),VALUE(0),IF(B7=\"Section\",J7/F7,\"\"))","v":""},{"$f":"IF(ISERROR(IF($B$7=\"Intersection\",\"\",VLOOKUP(C23,$S$36:$T$46,2,TRUE))),VALUE(0),IF($B$7=\"Intersection\",\"\",VLOOKUP(C23,$S$36:$T$46,2,TRUE)))","v":0},{"$f":"IF(ISERROR((J7*1000000)/(M7*365*F7*N7)),VALUE(0),(J7*1000000)/(M7*365*F7*N7))","v":0},{"$f":"IF(ISERROR(VLOOKUP(E23,$U$36:$V$46,2,TRUE)),VALUE(0),(VLOOKUP(E23,$U$36:$V$46,2,TRUE)))","v":0},{"$f":"IF(ISERROR(G32),VALUE(0),G32)","v":28801.024779765034},{"$f":"IF(ISERROR(VLOOKUP(G23,$W$36:$X$51,2,TRUE)),VALUE(0),VLOOKUP(G23,$W$36:$X$51,2,TRUE))","v":8},{"$f":"IF(ISERROR(((AI36*G7+AI37*H7+AI38*I7)*1000000)/(N7*M7*365*F7)),VALUE(0),((AI36*G7+AI37*H7+AI38*I7)*1000000)/(N7*M7*365*F7))","v":0},{"$f":"IF(ISERROR(VLOOKUP(I23,$Y$36:$Z$51,2,TRUE)),VALUE(0),VLOOKUP(I23,$Y$36:$Z$51,2,TRUE))","v":0},{"$f":"IF(ISERROR(O7/N7),VALUE(0),O7/N7)","v":0},{"$f":"IF(ISERROR(VLOOKUP(K23,$AA$36:$AB$51,2,TRUE)),VALUE(0),VLOOKUP(K23,$AA$36:$AB$51,2,TRUE))","v":0},{"$f":"IF(ISERROR(E9),VALUE(0),E9)","v":-0.30128055054055236},{"$f":"IF(ISERROR(VLOOKUP(M23,$AC$36:$AD$51,2,TRUE)),VALUE(0),VLOOKUP(M23,$AC$36:$AD$51,2,TRUE))","v":0},{"$f":"IF(ISERROR(P7),VALUE(0),P7)","v":0},{"$f":"IF(ISERROR(VLOOKUP(O23,$AE$36:$AF$51,2,TRUE)),VALUE(0),VLOOKUP(O23,$AE$36:$AF$51,2,TRUE))","v":0}]
[]
["Total Score =",{"$f":"IF(B7=\"Section\",D23+F23+H23+J23+L23+N23+P23,IF(B7=\"Intersection\",B23+F23+H23+J23+L23+N23+P23,\"\"))","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"RSI Value = ",{"$f":"'Severity Calc Sheet'!C3","v":28801.024779765034}]
[]
[null,null,null,null,null,null,{"$f":"'Severity Calc Sheet'!C1","v":"Rural Non-Freeway"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crash Frequency","Points","Crash Density","Points","Crash Rate","Points","RSI","Points","EPDO Rate","Points","% Trucks","Points","Rate of Return","Points","V/C","Points",null,2010,null,null,null,"HRRR Local Values"]
[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,"Rural Non-Freeway","Fatal Crash",123.01821930666526,"Section","Rural Major Collector",12.09833323601088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1,10,1,1,1,21000,1,5,1,0.05,1,0.05,1,0.6,1,"Urban Non-Freeway","Injury Crash",7.0787927986100128,"Intersection","Rural Minor Collector",12.860046955122311]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,2,20,2,1.5,2,22000,2,10,2,0.1,2,0.1,2,0.7,2,"Freeway","PDO Crash",1,null,"Rural Local Road",6.5433046749866586]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,3,30,3,2,3,23000,3,20,3,0.15,3,0.15,3,0.8,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,4,40,4,2.5,4,24000,4,30,4,0.2,4,0.2,4,0.9,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,5,50,5,3,5,25000,5,40,5,0.25,5,0.25,5,1,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,6,60,6,3.5,6,26000,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,7,70,7,4,7,27000,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,8,80,8,4.5,8,28000,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,9,90,9,5,9,29000,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,10,100,10,5.5,10,30000,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31000,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32000,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33000,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34000,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35000,15]

{"sheet":"CRF Table","index":11,"n_rows":89,"n_cols":16,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[null,"Estimates of Countermeasure Effectiveness Reduction (CRF) Factors"]
[null,"(September 1997, Revised July 2007)"]
[]
["ID","Description","All","PDO","INJ/FAT","Night","Wet","Pedestrian","Left","Right","Angle","Rear","Head","Side","Fixed","Ran"]
[]
[1,"1 Upgrade pavement markings - general",0.1]
[2,"2 Install raised pavement markers, locations & sections",0.09]
[3,"3 Install plastic pavement markings",0.1]
[4,"4 De-slick pavement - sections [except wet pavement crashes]",0.2,null,null,null,0.5]
[5,"5 Resurface - rural sections - 2 lane",0.12,null,0.21]
[6,"5a Resurface - rural sections > 2 lane",0.44,null,0.59]
[7,"56 Resurface - urban section > 2 lane",0.42,null,0.46]
[8,"6 Upgrade signs - general",0.05]
[9,"7 Lane use signs - overhead",null,null,null,null,null,null,null,null,null,0.1,null,0.2]
[10,"8 Warning signs at intersection - rural",0.2,null,0.25]
[11,"9 Warning signs on section - rural 2 lane",0.36,null,0.32]
[12,"9a Warning signs on section - rural > 2 lane",0.18,null,0.03]
[13,"57 Install/Improve warning signs on rural curves [curve crashes only]",0.2]
[14,"30 Install warning sign-mounted flasher",0.3]
[15,"31 Install PTSWF sign/flasher [for approach speeds > 45 mph]",null,null,null,null,null,null,null,null,null,0.6]
[16,"58 Install/Improve warning signs on sections - rural 2 lane",0.36,null,0.32]
[17,"58a Install/Improve warning signs on sections - rural > 2 lane",0.18,null,0.03]
[18,"59 Install/Improve warning signs on sections - urban 2 lane",0.14000000000000001,null,0.14000000000000001]
[19,"59a Install/Improve warning signs on sections - urban > 2 lane",0.26,null,0.2]
[20,"60 Install delineators at curve - rural [Curve crashes only]",0.16]
[21,"13 Install concrete median barrier [median and cross-median crashes only]",null,null,0.61]
[22,"14 Install painted median",0.12]
[23,"15 Install two-way left turn lane",8.3000000000000004E-2,null,0.2]
[24,"41 Flatten vertical curve",0.2,null,0.51]
[25,"16 Install left turn bay & extra pavement without signal",null,null,null,null,null,null,0.2,null,null,0.2]
[26,"17 Install left turn bay & extra pavement with signal",null,null,null,null,null,null,0.2,null,null,0.2]
[27,"37 Widen roadway, rural section, no additional lanes",0.38,null,0.3]
[28,"38 Widen roadway, rural section, including additional lanes",0.38,null,0.3]
[29,"39 Widen for left turn lane, including resurfacing",null,null,null,null,null,null,0.2,null,null,0.2,null,0.2]
[30,"40 Widen for right turn lane, including resurfacing",null,null,null,null,null,null,null,0.2,null,0.2,null,0.2]
[31,"42 Stabilize berms - rural section",0.38,null,0.3]
[32,"20 Upgrade existing flasher",0.2]
[33,"21 Install flasher",0.5]
[34,"22 Upgrade existing signal - general",0.2]
[35,"23 Reconstruct existing signal - major",0.27]
[36,"24 Install traffic signal - all types",null,null,null,null,null,null,0.1,0.1,0.8,-0.1,null,0.1]
[37,"25 Revise signal timing",0.1]
[38,"26 Add pedestrian heads",null,null,null,null,null,0.5]
[39,"27 Add left turn phase with new left turn lane",null,null,null,null,null,null,0.4,null,null,0.2]
[40,"28 Add left turn phase with existing left turn lane",null,null,null,null,null,null,0.3,null,null,0.1]
[41,"29 Add left turn phase without left turn lane ",null,null,null,null,null,null,0.2]
[42,"32 Install optically programmed heads",null,null,null,null,null,null,0.1,null,0.1,0.1,0.2]
[43,"33 Remove existing, unwarranted signal"]
[44,"61 Provide signal interconnection"]
[45,"34 Install intersection lighting",null,null,null,0.75]
[46,"35 Install section lighting",null,null,null,0.5]
[47,"36 Upgrade existing lighting",null,null,null,0.5]
[48,"43 Replace culvert",null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[49,"44 Replace bridge",null,null,null,null,null,null,null,null,null,null,null,null,0.62]
[50,"45 Widen bridge",null,null,null,null,null,null,null,null,null,null,null,null,0.43]
[51,"46 Widen culvert",null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[52,"62 Install guard rail at bridge end [Injury-fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[53,"49 Install guard rail [Injury-fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.2]
[54,"63 Improve guard rail [Injury-fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[55,"50 Remove or relocate fixed object to a safe distance from the roadway",0.38,null,0.38]
[56,"64 Make utility pole breakaway [Utility pole fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[57,"65 Relocate utility pole 3 0' from edge of pavement [Utility pole fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.32]
[58,"66 Remove utility pole [Utility pole fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[59,"67 Remove tree [Tree crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[60,"68 Make sign support breakaway - all sizes [Sign injury-fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.24]
[61,"69 Install auto. prot. device at R/R grade crossing [Train-vehicle crashes only]",0.28000000000000003]
[62,"48 Install impact attenuator device [Injury-fatal crashes only]",null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[63,"47 Eliminate fixed objects",null,null,null,null,null,null,null,null,null,null,null,null,1]
[64,"55 Improve horizontal alignment - rural section",0.4]
[65,"70 Reconstruct curves on rural section - 2 lane [Curve crashes only]",0.88]
[66,"10 Eliminate parking"]
[67,"11 Speed zone"]
[68,"12 Prohibit turn",0.4]
[69,"18 Close median opening"]
[70,"19 Relocate driveway entrance",null,null,null,null,null,null,0.1,0.1,0.1,0.2,0.2]
[71,"51 Relocate intersection",0.25]
[72,"52 Increase cross corner sight distance",null,null,null,null,null,null,null,null,0.5]
[73,"71 Prohibit right-turn-on-red",null,null,null,null,null,null,null,0.2]
[74,"53 Install rumble strips"]
[75,"54 Provide proper super-elevation on curve - rural [curve crashes only]",0.5]
[]
[]
[null,"When using multiple countermeasures, the total reduction fator is:"]
[null,"R1 + (1-R1)R2 + (1-R1)(1-R2)R3 + (1-R1) (1-R2)(1-R3)R4 + …….. = RT"]
[null,"Cost of crashes for determing ROR (Updated - 2009)"]
[null,"SYSTEM ","PDO ","INJ/FAT"]
[null,"Rural State Highways ",8945.9363393524945,85893.036052249634]
[null,"Counties and Unincorporated Villages ",8388.4027725939741,84367.362061403503]
[null,"Cities and Incorporated Villages",9253.5230132686538,78992.881875751133]

{"sheet":"Help File","index":12,"n_rows":990,"n_cols":67,"rows_kept":990,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Crash Data",null,null,"Graphical Analysis",null,null,"Collision Diagram",null,null,"Rate Calc Sheet",null,null,"ROR Analysis",null,null,"CRF Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAM Tool Created by Jonathan Hughes"]
[null,null,null,"Data Analysis",null,null,"Histograms",null,null,"Resurfacing Analysis",null,null,"Severity Calc Sheet",null,null,"Safety App",null,null,"Help File",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 Rights Reserved"]
[]
["For additional questions contact Jonathan Hughes 614-466-4019 or jonathan.hughes@dot.state.oh.us (Office of Systems Planning and Program Management) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do Not Modify"]
["Click to go to Latest Updates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Crash Data'!A2","v":"version: 11.02.11"},null,null,null,null,null,null,null,null,null,null,null,null,null,"REAR END","NORTH","N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIXED OBJECT","SOUTH","S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANGLE","EAST","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANIMAL","WEST","W"]
[null,null,"DO NOT store this model on your C:drive to use since it may be updated occasionally, the latest version will be on the GIS Crash Analysis Tool Website!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIDESWIPE - PASSING","NORTHEAST","NE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEAD ON","NORTHWEST","NW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIDESWIPE - MEETING","SOUTHWEST","SW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BACKING","SOUTHEAST","SE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PEDESTRIAN","UNKNOWN","U"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARKED VEHICLE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT TURN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT TURN"]
[]
[]
[]
[null,null,"Click the button to access the CAM Tool GCAT Toolbox (or use the shortcut \"Ctrl\" + \"t\" )"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Go to Crash Data Tab"]
[]
["Go to top of page - Help File"]
[]
[]
["For additional questions contact Jonathan Hughes 614-466-4019 or jonathan.hughes@dot.state.oh.us (Office of Systems Planning and Program Managment)"]
[]
["DO NOT store this model on your C:drive to use since it may be updated occasionally, the latest version will be on the GCAT Webpage!"]