{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Crash Data","Data Analysis","Graphical Analysis","Histograms","Collision Diagram","Resurfacing Analysis","Rate Calc Sheet","Severity Calc Sheet","ROR Analysis","Safety App","CRF Table","Help File"],"not_rendered":{"charts":32,"images":89,"macros":1,"external_links":0,"defined_names":33,"comments":2,"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":39,"n_cols":126,"rows_kept":39,"cut":false,"hidden":false,"merged":[[17,61,17,66],[17,67,17,72],[17,73,17,92],[18,61,18,62],[18,63,18,64],[18,65,18,66],[18,67,18,68],[18,69,18,70],[18,71,18,72],[18,73,18,74],[18,87,18,88],[18,89,18,90],[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]]}
[null,null,null,null,null,null,"Crash Data","Graphical Analysis","Collision Diagram","Rate Calc Sheet","ROR Analysis","CRF Table"]
[null,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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[null,null,null,null,null,null,{"$f":"+HYPERLINK(CONCATENATE(\"https://tscas001.dot.state.oh.us/OhioRVX2/Roadview.asp?nlf_id='\",+D21,\"'&offset=\",+D15),\"Launch: Video Log\")","v":"Launch: Video Log"},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(\"http://www.dot.state.oh.us/Divisions/TransSysDev/Innovation/Prod_Services/DESTAPE/Documents/DES\"&D12&\".htm\",\"Launch: ODOT Destape\")","v":"Launch: ODOT Destape"},null,null,{"$f":"HYPERLINK(\"http://maps.yahoo.com/beta/#maxp=search&mvt=m&trf=1&lon=-82.611694&lat=40.061257&mag=10\",\"Launch: Yahoo Maps\")","v":"Launch: Yahoo Maps"}]
[null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://www2.dot.state.oh.us/techservsite/availpro/Road_%20Infor/SLD/default.htm\",\"Launch: Straight Line Diagrams\")","v":"Launch: Straight Line Diagrams"},null,null,{"$f":"HYPERLINK(\"http://local.live.com/default.aspx?v=2&cp=\"&L4&\"~\"&M4&\"&style=h&lvl=15\",\"Launch: Local Live Maps\")","v":"Launch: Local Live 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://tscww012/giswebmap/startGis.asp?majorbus=Crash%20Data&sectionarray=Road%20Inventory,Traffic%20Data,Congestion%20Data,Crash%20Data\",\"Launch: Geomedia WebMap\")","v":"Launch: Geomedia WebMap"}]
[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://www2.dot.state.oh.us/techservsite/offceorg/traffmonit/countinformation/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/TransSysDev/ProgramMgt/CapitalPrograms/Pages/Safety.aspx\",\"Launch: Highway Safety Website\")","v":"Launch: Highway Safety Website"}]
[null,"8"]
[null,"Slm!1County","1","ROS"]
[null,"Slm!2Route","1","0159"]
[null,"Slm!31RouteSuffix","1","R"]
[null,"Slm!3Begin","1","2.5"]
[null,"Slm!4End","1","3.0"]
[null,"TCrashDte!1Begin","1","20060101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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=2004,BF17=\"NO\",L17=\"DAYLIGHT            \"),\"2004\",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=2004,BF17=\"YES\",L17=\"DAYLIGHT            \"),\"2004\",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=2004,BF17=\"NO\",BH17=\"YES\"),\"2004\",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=2004,BF17=\"YES\",BH17=\"YES\"),\"2004\",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=2004,BF17=\"NO\",BI17=\"YES\"),\"2004\",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=2004,BF17=\"YES\",BI17=\"YES\"),\"2004\",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=2004,BF17=\"NO\",Q17=\"ROAD - DRY                    \"),\"2004\",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=2004,BF17=\"YES\",Q17=\"ROAD - DRY                    \"),\"2004\",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=2004,BF17=\"NO\",Q17=\"ROAD - WET                    \"),\"2004\",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=2004,BF17=\"YES\",Q17=\"ROAD - WET                    \"),\"2004\",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=2004,BF17=\"NO\",BG17=\"YES\"),\"2004\",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=2004,BF17=\"YES\",BG17=\"YES\"),\"2004\",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=2004,BF17=\"NO\",M17=\"REAR END                      \"),\"2004\",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=2004,BF17=\"YES\",M17=\"REAR END                      \"),\"2004\",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=2004,BF17=\"NO\",M17=\"LEFT TURN                     \"),\"2004\",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=2004,BF17=\"YES\",M17=\"LEFT TURN                     \"),\"2004\",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=2004,BF17=\"NO\",M17=\"RIGHT TURN                    \"),\"2004\",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=2004,BF17=\"YES\",M17=\"RIGHT TURN                    \"),\"2004\",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=2004,BF17=\"NO\",M17=\"ANGLE                         \"),\"2004\",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=2004,BF17=\"YES\",M17=\"ANGLE                         \"),\"2004\",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=2004,BF17=\"NO\",M17=\"HEAD ON                       \"),\"2004\",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=2004,BF17=\"YES\",M17=\"HEAD ON                       \"),\"2004\",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=2004,BF17=\"NO\",M17=\"SIDESWIPE - PASSING           \"),\"2004\",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=2004,BF17=\"YES\",M17=\"SIDESWIPE - PASSING           \"),\"2004\",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=2004,BF17=\"NO\",M17=\"FIXED OBJECT                  \"),\"2004\",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=2004,BF17=\"YES\",M17=\"FIXED OBJECT                  \"),\"2004\",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=2004,BF17=\"NO\",M17=\"RAN OFF ROAD\"),\"2004\",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=2004,BF17=\"YES\",M17=\"RAN OFF ROAD\"),\"2004\",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=2004,BF17=\"NO\",M17=\"PEDESTRIAN                    \"),\"2004\",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=2004,BF17=\"YES\",M17=\"PEDESTRIAN                    \"),\"2004\",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,\"=2004\")+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":""}]
[null,"TCrashDte!2End","1","20090601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":""},"Logged or Unlogged","1","L",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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://local.live.com/default.aspx?v=2&cp=\",+BB19,\",~\",+BC19,\"&style=h&lvl=16\"),\"Local Live\")","v":"Local Live"},{"$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,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)","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":""}]
["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","Local Live","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"]
[{"$f":"IF(AQ21=\"\",\"\",HYPERLINK(AQ21,\"Crash Report\"))","v":"Crash Report"},"068318054","06027394  ","SROSSR00159**C",2.52,20061228,"SR0159R   ",1680,0,"THURSDAY            ","19","DARK - LIGHTED      ","LEFT TURN                     ",2,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","FAILURE TO YIELD              ","TURNING LEFT                  ","NOTHING STRUCK                ","OTHER VEHICLE                 ","NORTH               ","EAST                ",33,"FEMALE              ","NO TRAFFIC CONTROL DRIVER     ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 20 AND UNDER            ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","OTHER VEHICLE                 ",39,"FEMALE              ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2006\\8317343-8318073\\200683180547114184.TIF  ","STRAIGHT - LEVEL              ",0,0,1,0,null,9,"ROS",1,"CHILLICOTHE",39.370793999999997,-82.975829000000004,2006,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,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://local.live.com/default.aspx?v=2&cp=\",+BB21,\",~\",+BC21,\"&style=h&lvl=16\"),\"Local Live\")","v":"Local Live"}]
["Crash Report","068254439","06022933  ","SROSSR00159**C",2.5299999999999998,20061027,"SR0159R   ",1680,1,"FRIDAY              ","21","DARK - LIGHTED      ","ANGLE                         ",2,"PROPERTY DAMAGE CRASH         ","RAIN                          ","ROAD - WET                    ","NON-INTERSECTION              ","DROVE OFF ROAD-REASON UNKNOWN ","TURNING LEFT                  ","NOTHING STRUCK                ","FULL-SIZE                     ","WEST                ","NORTH               ",38,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 20 AND UNDER            ","POSTED 35                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","PICKUP TRUCK                  ",48,"MALE                ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2006\\8253876-8254803\\200682544397114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,0,"EAST                ",9,"ROS",1,"CHILLICOTHE",39.370938000000002,-82.975821999999994,2006,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","078000025","07000210  ","SROSSR00159**C",2.54,20070104,"SR0159R   ",1655,0,"THURSDAY            ","14","DAYLIGHT            ","SIDESWIPE - PASSING           ",2,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","IMPROPER LANE CHANGE          ","CHANGING LANES                ","MAILBOX                       ","FULL-SIZE                     ","SOUTH               ","NORTH               ",85,"MALE                ","NO TRAFFIC CONTROL DRIVER     ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 21-25                   ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","STRAIGHT TRUCK                ",26,"MALE                ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8000001-8000719\\200780000257114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",1,"CHILLICOTHE",39.371080999999997,-82.975814999999997,2007,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","Local Live"]
["Crash Report","078002666","07000660  ","SROSSR00159**C",2.54,20070111,"SR0159R   ",1655,0,"THURSDAY            ","18","DARK - LIGHTED      ","ANGLE                         ",2,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","FAILURE TO YIELD              ","CHANGING LANES                ","NOTHING STRUCK                ","PICKUP TRUCK                  ","SOUTH               ","NORTHEAST           ",74,"MALE                ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 36-45                   ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","PICKUP TRUCK                  ",52,"MALE                ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8002255-8002990\\200780026667114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",1,"CHILLICOTHE",39.371080999999997,-82.975814999999997,2007,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","Local Live"]
["Crash Report","078182980","07020119  ","SROSSR00159**C",2.54,20070926,"SR0159R   ",1532,0,"WEDNESDAY           ","16","DAYLIGHT            ","REAR END                      ",2,"INJURY CRASH                  ","RAIN                          ","ROAD - WET                    ","NON-INTERSECTION              ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","NOTHING STRUCK                ","COMPACT                       ","NORTH               ","SOUTH               ",25,"MALE                ","NO TRAFFIC CONTROL DRIVER     ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 20 AND UNDER            ","POSTED 40                     ","NO DRIVER ERRORS              ","STOPPED IN TRAFFIC            ","COMPACT                       ",51,"FEMALE              ","NORTH               ","SOUTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8182643-8183427\\200781829807114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,1,null,9,"ROS",1,"CHILLICOTHE",39.371080999999997,-82.975814999999997,2007,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","Local Live"]
["Crash Report","076142429","71-1458-71","SROSSR00159**C",2.54,20071123,"SR0159R   ","MP003.00  ",10,"FRIDAY              ","07","DAWN                ","REAR END                      ",2,"PROPERTY DAMAGE CRASH         ","SNOW                          ","ROAD - WET                    ","NON-INTERSECTION              ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","OBJECT NOT STATED             ","SUB-COMPACT                   ","SOUTH               ","NORTH               ",42,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 26-35                   ","POSTED 40                     ","NO DRIVER ERRORS              ","STOPPED IN TRAFFIC            ","OTHER VEHICLE                 ",55,"FEMALE              ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\6000000-6999999\\20076142429.PDF         ","STRAIGHT - LEVEL              ",0,0,0,0,"NORTH               ",9,"ROS",3,"SCIOTO",39.371080999999997,-82.975814999999997,2007,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,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","086248711","71-0794-71","SROSSR00159**C",2.59,20080724,"SR0159R   ","MP002.00  ",0,"THURSDAY            ","22","DARK - LIGHTED      ","FIXED OBJECT                  ",1,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","DRIVER INATTENTION            ","GOING STRAIGHT                ","GUARDRAIL                     ","MID-SIZE                      ","NORTH               ","SOUTH               ",34,"MALE                ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 36-45                   ","POSTED 40                     ",null,"ACTION NOT STATED             ","VEHICLE NOT STATED            ",0,"NOT STATED          ",null,null,"ALCOHOL NOT STATED            ","DRUGS NOT STATED              ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2008\\ECS___GENERATED\\20086248711.PDF         ","STRAIGHT - LEVEL              ",0,0,1,0,null,9,"ROS",3,"SCIOTO",39.371797000000001,-82.975781999999995,2008,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,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","078049687","07004069  ","SROSSR00159**C",2.67,20070302,"SR0159R   ",1640,0,"FRIDAY              ","20","DARK - LIGHTED      ","SIDESWIPE - PASSING           ",2,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","IMPROPER LANE CHANGE          ","CHANGING LANES                ","NOTHING STRUCK                ","OTHER VEHICLE                 ","SOUTH               ","WEST                ",17,"MALE                ","NO TRAFFIC CONTROL DRIVER     ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 21-25                   ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","OTHER VEHICLE                 ",30,"FEMALE              ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8049602-8050324\\200780496877114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",1,"CHILLICOTHE",39.372943999999997,-82.975728000000004,2007,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,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","078131563","07013811  ","SROSSR00159**C",2.69,20070707,"SR0159R   ",1620,0,"SATURDAY            ","23","DARK - LIGHTED      ","OVERTURNING                   ",1,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","FAILURE TO CONTROL            ","GOING STRAIGHT                ","NOTHING STRUCK                ","MOTORCYCLE - 351CC-750CC      ","NORTH               ","SOUTH               ",49,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 21-25                   ","POSTED 40                     ",null,"ACTION NOT STATED             ","VEHICLE NOT STATED            ",0,"NOT STATED          ",null,null,"ALCOHOL NOT STATED            ","DRUGS NOT STATED              ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8130821-8131585\\200781315637114184.TIF  ","STRAIGHT - LEVEL              ",0,1,0,0,null,9,"ROS",1,"CHILLICOTHE",39.37323,-82.975714999999994,2007,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,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["","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   ",null,"STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",3,"SCIOTO",39.373373999999998,-82.975707999999997,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,"Roadview","Google Maps","Local Live"]
["Crash Report","086259557","71-1030-71","SROSSR00159**C",2.72,20080919,"SR0159R   ","MP002.00  ",0,"FRIDAY              ","14","DAYLIGHT            ","REAR END                      ",2,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","INTERSECTION RELATED          ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","OBJECT NOT STATED             ","COMPACT                       ","SOUTH               ","NORTH               ",24,"FEMALE              ","TRAFFIC SIGNAL                ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 36-45                   ","POSTED 40                     ","NO DRIVER ERRORS              ","STOPPED IN TRAFFIC            ","PICKUP TRUCK                  ",35,"FEMALE              ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2008\\ECS___GENERATED\\20086259557.PDF         ","STRAIGHT - LEVEL              ",0,0,0,1,null,9,"ROS",3,"SCIOTO",39.373660000000001,-82.975695000000002,2008,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","Local Live"]
["Crash Report","086229479","71-0398-71","SROSSR00159**C",2.75,20080404,"SR0159R   ","MP002.00  ",1,"FRIDAY              ","17","DAYLIGHT            ","REAR END                      ",2,"INJURY CRASH                  ","RAIN                          ","ROAD - WET                    ","NON-INTERSECTION              ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","OBJECT NOT STATED             ","MID-SIZE                      ","NORTH               ","SOUTH               ",48,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 36-45                   ","POSTED 40                     ","NO DRIVER ERRORS              ","STOPPED IN TRAFFIC            ","OTHER VEHICLE                 ",65,"FEMALE              ","NORTH               ","SOUTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2008\\ECS___GENERATED\\20086229479.PDF         ","STRAIGHT - LEVEL              ",0,0,1,0,null,9,"ROS",3,"SCIOTO",39.374090000000002,-82.975672000000003,2008,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,"Roadview","Google Maps","Local Live"]
["","096308599","71-0423-71","SROSSR00159**C",2.8,20090402,"SR0159R   ","MP002.80  ",0,"THURSDAY            ","16","DAYLIGHT            ","OVERTURNING                   ",2,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","OBJECT NOT STATED             ","MOTORCYCLE - 351CC-750CC      ","NORTH               ","SOUTH               ",43,"MALE                ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 26-35                   ","POSTED 40                     ","NO DRIVER ERRORS              ","STOPPED IN TRAFFIC            ","MID-SIZE                      ",58,"FEMALE              ","NORTH               ","SOUTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ",null,"STRAIGHT - LEVEL              ",0,0,1,0,null,9,"ROS",3,"SCIOTO",39.374806999999997,-82.975684999999999,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,"Roadview","Google Maps","Local Live"]
["","096367183","71-0682-71","SROSSR00159**C",2.8,20090527,"SR0159R   ","MP003.00  ",20,"WEDNESDAY           ","01","DARK - LIGHTED      ","FIXED OBJECT                  ",1,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","DROVE OFF ROAD-REASON UNKNOWN ","GOING STRAIGHT                ","CURB                          ","MID-SIZE                      ","NORTH               ","SOUTH               ",37,"MALE                ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","USING PRESCRIBED DRUG         ","VEHICLE SPEED NOT STATED      ","POSTED 50                     ",null,"ACTION NOT STATED             ","VEHICLE NOT STATED            ",0,"NOT STATED          ",null,null,"ALCOHOL NOT STATED            ","DRUGS NOT STATED              ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ",null,"STRAIGHT - LEVEL              ",0,1,0,0,"SOUTH               ",9,"ROS",3,"SPRINGFIELD",39.374806999999997,-82.975684999999999,2009,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,"Roadview","Google Maps","Local Live"]
["Crash Report","088170645","08020022  ","SROSSR00159**C",2.82,20081003,"SR0159R   ",1760,0,"FRIDAY              ","13","DAYLIGHT            ","REAR END                      ",2,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","FOLLOWING TOO CLOSE           ","GOING STRAIGHT                ","NOTHING STRUCK                ","MID-SIZE                      ","SOUTH               ","NORTH               ",83,"MALE                ","NO TRAFFIC CONTROL DRIVER     ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 20 AND UNDER            ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","MID-SIZE                      ",45,"MALE                ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2008\\8170346-8171109\\200881706457114184.TIF  ","STRAIGHT - LEVEL              ",0,0,0,1,null,9,"ROS",1,"CHILLICOTHE",39.375093,-82.975684000000001,2008,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","086276627","71-1435-71","SROSSR00159**C",2.83,20081124,"SR0159R   ","MP003.00  ",0,"MONDAY              ","14","DAYLIGHT            ","FIXED OBJECT                  ",1,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - WET                    ","NON-INTERSECTION              ","FAILURE TO CONTROL            ","GOING STRAIGHT                ","GUARDRAIL                     ","COMPACT                       ","NORTH               ","SOUTH               ",17,"MALE                ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 26-35                   ","POSTED 40                     ",null,"ACTION NOT STATED             ","VEHICLE NOT STATED            ",0,"NOT STATED          ",null,null,"ALCOHOL NOT STATED            ","DRUGS NOT STATED              ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2008\\ECS___GENERATED\\20086276627.PDF         ","STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",3,"SCIOTO",39.375236999999998,-82.975683000000004,2008,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,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","078070127","07-5209   ","SROSSR00159**C",2.85,20070331,"SR0159R   ",1720,0,"SATURDAY            ","15","DAYLIGHT            ","SIDESWIPE - PASSING           ",2,"INJURY CRASH                  ","NO ADVERSE WEATHER CONDITION  ","ROAD - WET                    ","NON-INTERSECTION              ","IMPROPER LANE CHANGE          ","CHANGING LANES                ","GUARDRAIL                     ","COMPACT                       ","SOUTH               ","NORTH               ",48,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 26-35                   ","POSTED 40                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","PICKUP TRUCK                  ",31,"MALE                ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2007\\8069683-8070446\\200780701277174129.TIF  ","STRAIGHT - LEVEL              ",0,1,1,0,null,9,"ROS",3,"SPRINGFIELD",39.375523999999999,-82.975680999999994,2007,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,null,null,"Roadview","Google Maps","Local Live"]
["Crash Report","068319018","71-1206-71","SROSSR00159**C",2.95,20061218,"SR0159R   ","MP003.00  ",2,"MONDAY              ","14","DAYLIGHT            ","SIDESWIPE - PASSING           ",2,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","IMPROPER LANE CHANGE          ","CHANGING LANES                ","NOTHING STRUCK                ","OTHER VEHICLE                 ","SOUTH               ","NORTH               ",24,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 46-55                   ","POSTED 55                     ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","COMPACT                       ",16,"FEMALE              ","SOUTH               ","NORTH               ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPECIAL AREA - NOT STATED               ","ANIMAL NOT STATED   ","\\\\ITCFS014\\ODPS\\2006\\8318787-8319765\\200683190187174129.TIF  ","STRAIGHT - LEVEL              ",0,0,0,0,"SOUTH               ",9,"ROS",3,"SPRINGFIELD",39.376956999999997,-82.975646999999995,2006,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,null,null,null,null,null,null,null,null,null,null,null,"Roadview","Google Maps","Local Live"]
["","096290593","71-0040-71","SROSSR00159**C",3,20090109,"SR0159R   ","MP003.00  ",0,"FRIDAY              ","18","DARK - LIGHTED      ","ANIMAL                        ",1,"PROPERTY DAMAGE CRASH         ","NO ADVERSE WEATHER CONDITION  ","ROAD - DRY                    ","NON-INTERSECTION              ","NO DRIVER ERRORS              ","GOING STRAIGHT                ","OBJECT NOT STATED             ","OTHER VEHICLE                 ","SOUTHWEST           ","NORTHEAST           ",50,"FEMALE              ","PAVEMENT MARKINGS             ","NO ALCOHOL DETECTED           ","NO DRUGS DETECTED             ","SPEED 26-35                   ","POSTED 55                     ",null,"ACTION NOT STATED             ","VEHICLE NOT STATED            ",0,"NOT STATED          ",null,null,"ALCOHOL NOT STATED            ","DRUGS NOT STATED              ","SPECIAL AREA - NOT STATED               ","DEER HIT            ",null,"STRAIGHT - LEVEL              ",0,0,0,0,null,9,"ROS",3,"SPRINGFIELD",39.377665,-82.975515000000001,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","Local Live"]

{"sheet":"Data Analysis","index":1,"n_rows":295,"n_cols":14,"rows_kept":295,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Crash Data'!A3","v":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"},null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[]
[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","%"]
["(blank)",null,"(blank)",{"$error":"#DIV/0!"}]
["Grand Total",null,"Grand Total",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
["DAY_OF_WEEK","Number","DAY_OF_WEEK","%",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!"}]
[]
[]
[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","%"]
["(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!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"A1","v":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]

{"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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"},null,null,null,null,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","(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","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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"}]
[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":"Resurfacing Analysis","index":5,"n_rows":500,"n_cols":34,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"'Crash Data'!A3","v":"ROS-0159R - (2.5-3.0)     From 01/01/2006 to 06/01/2009"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resurfacing Analysis Criteria"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADT","Total Crashes ( > )","Intersection  ( > )","Non-Intersection ( > )","Crash Rate w/o Animal  ( > )"]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Section Begin Log",{"$f":"IF('Crash Data'!$D$15=\"\",\"None\",'Crash Data'!$D$15+0)","v":2.5},null,null,null,null,null,null,null,null,null,{"$f":"MIN(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=",0]
[null,null,"Section End Log",{"$f":"IF('Crash Data'!$D$16=\"\",\"None\",'Crash Data'!$D$16+0)","v":3},"    Update and Run Analysis",null,null,null,null,null,null,null,null,{"$f":"MAX(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,">=",401,4]
[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,">=",2001,null,4,10,1.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,">=",10001,null,8,15,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DO NOT MODIFY CELLS BELOW",null,null,null,null,null,null,null,null,null,null,"DO NOT MODIFY CELLS BELOW",">=",25001,null,11,18,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q12=\"INTERSECTION                  \",\"Intersection Related\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC12=\"ANIMAL                        \",\"Animal Crash\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q12 = \"INTERSECTION RELATED          \",\"Intersection Related\",\"\")","v":""},{"$f":"IF(R12 = \"INTERSECTION RELATED          \",\"Intersection Related\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(Q8=R9)","v":true}]
[null,null,null,null,null,"Count",null,null,null,null,null,null,null,null,null,"Count","LOCATION_TXT",null,null,null,null,null,null,null,null,null,null,"Count","Crash Type"]
["Section Comments","Section","ADT","Crash Rate (All Crashes)","Crash Rate (w/o Animal)","LOGPOINT_SLM_NBR","Total",null,"Total Crashes",null,null,null,"Intersection Related Crashes","Non-Intersection Crashes","Exception Indicator","LOGPOINT_SLM_NBR",null,null,null,null,null,null,null,null,null,null,"Animal Crashes","LOGPOINT_SLM_NBR"]
[null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,$F$13:$G$500,1,FALSE))","v":"99.5-100"},null,{"$f":"IF(F13=\"\",\"\",IF(F13=\"Total\",\"\",1000000*((I13))/(365*3*$D$5*C13)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F13=\"\",\"\",IF(F13=\"Total\",\"\",1000000*((I13-AA13))/(365*3*$D$5*C13)))","v":{"$error":"#DIV/0!"}},"99.5-100",2,null,{"$f":"IF(F13=\"\",\"\",VLOOKUP(F13,$F$13:$G$500,2,FALSE))","v":2},{"$f":"IF(F13=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F13,$P$13:$V$500,2,FALSE),\"0\"))","v":"0"},{"$f":"IF(F13=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F13,$P$13:$V$500,2,FALSE),\"0\"))","v":"0"},{"$f":"IF(F13=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F13,$P$13:$V$500,3,FALSE),\"0\"))","v":"0"},{"$f":"IF(F13=\"\",\"\",(J13+K13+L13))","v":0},{"$f":"IF(F13=\"\",\"\",I13-M13)","v":2},null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F13=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F13,$AB$13:$AS$500,2,FALSE),\"0\"))","v":"0"},"Total"]
[null,"Total",null,"","","Total",2,null,2,"0","0","0",0,2,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F77=\"\",\"\",VLOOKUP(F77,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F77=\"\",\"\",IF(F77=\"Total\",\"\",1000000*((I77))/(365*3*$D$5*C77)))","v":""},{"$f":"IF(F77=\"\",\"\",IF(F77=\"Total\",\"\",1000000*((I77-AA77))/(365*3*$D$5*C77)))","v":""},null,null,null,{"$f":"IF(F77=\"\",\"\",VLOOKUP(F77,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F77=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F77,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F77=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F77,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F77=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F77,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F77=\"\",\"\",(J77+K77+L77))","v":""},{"$f":"IF(F77=\"\",\"\",I77-M77)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F77=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F77,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F141=\"\",\"\",VLOOKUP(F141,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F141=\"\",\"\",IF(F141=\"Total\",\"\",1000000*((I141))/(365*3*$D$5*C141)))","v":""},{"$f":"IF(F141=\"\",\"\",IF(F141=\"Total\",\"\",1000000*((I141-AA141))/(365*3*$D$5*C141)))","v":""},null,null,null,{"$f":"IF(F141=\"\",\"\",VLOOKUP(F141,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F141=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F141,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F141=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F141,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F141=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F141,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F141=\"\",\"\",(J141+K141+L141))","v":""},{"$f":"IF(F141=\"\",\"\",I141-M141)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F141=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F141,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F205=\"\",\"\",VLOOKUP(F205,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F205=\"\",\"\",IF(F205=\"Total\",\"\",1000000*((I205))/(365*3*$D$5*C205)))","v":""},{"$f":"IF(F205=\"\",\"\",IF(F205=\"Total\",\"\",1000000*((I205-AA205))/(365*3*$D$5*C205)))","v":""},null,null,null,{"$f":"IF(F205=\"\",\"\",VLOOKUP(F205,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F205=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F205,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F205=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F205,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F205=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F205,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F205=\"\",\"\",(J205+K205+L205))","v":""},{"$f":"IF(F205=\"\",\"\",I205-M205)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F205=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F205,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F269=\"\",\"\",VLOOKUP(F269,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F269=\"\",\"\",IF(F269=\"Total\",\"\",1000000*((I269))/(365*3*$D$5*C269)))","v":""},{"$f":"IF(F269=\"\",\"\",IF(F269=\"Total\",\"\",1000000*((I269-AA269))/(365*3*$D$5*C269)))","v":""},null,null,null,{"$f":"IF(F269=\"\",\"\",VLOOKUP(F269,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F269=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F269,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F269=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F269,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F269=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F269,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F269=\"\",\"\",(J269+K269+L269))","v":""},{"$f":"IF(F269=\"\",\"\",I269-M269)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F269=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F269,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F333=\"\",\"\",VLOOKUP(F333,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F333=\"\",\"\",IF(F333=\"Total\",\"\",1000000*((I333))/(365*3*$D$5*C333)))","v":""},{"$f":"IF(F333=\"\",\"\",IF(F333=\"Total\",\"\",1000000*((I333-AA333))/(365*3*$D$5*C333)))","v":""},null,null,null,{"$f":"IF(F333=\"\",\"\",VLOOKUP(F333,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F333=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F333,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F333=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F333,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F333=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F333,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F333=\"\",\"\",(J333+K333+L333))","v":""},{"$f":"IF(F333=\"\",\"\",I333-M333)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F333=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F333,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F397=\"\",\"\",VLOOKUP(F397,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F397=\"\",\"\",IF(F397=\"Total\",\"\",1000000*((I397))/(365*3*$D$5*C397)))","v":""},{"$f":"IF(F397=\"\",\"\",IF(F397=\"Total\",\"\",1000000*((I397-AA397))/(365*3*$D$5*C397)))","v":""},null,null,null,{"$f":"IF(F397=\"\",\"\",VLOOKUP(F397,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F397=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F397,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F397=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F397,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F397=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F397,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F397=\"\",\"\",(J397+K397+L397))","v":""},{"$f":"IF(F397=\"\",\"\",I397-M397)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F397=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F397,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,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(F461=\"\",\"\",VLOOKUP(F461,$F$13:$G$500,1,FALSE))","v":""},null,{"$f":"IF(F461=\"\",\"\",IF(F461=\"Total\",\"\",1000000*((I461))/(365*3*$D$5*C461)))","v":""},{"$f":"IF(F461=\"\",\"\",IF(F461=\"Total\",\"\",1000000*((I461-AA461))/(365*3*$D$5*C461)))","v":""},null,null,null,{"$f":"IF(F461=\"\",\"\",VLOOKUP(F461,$F$13:$G$500,2,FALSE))","v":""},{"$f":"IF(F461=\"\",\"\",IF($Q$8=\"Intersection Related\",VLOOKUP(F461,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F461=\"\",\"\",IF($Q$9=\"Intersection Related\",VLOOKUP(F461,$P$13:$V$500,2,FALSE),\"0\"))","v":""},{"$f":"IF(F461=\"\",\"\",IF($R$9=\"Intersection Related\",VLOOKUP(F461,$P$13:$V$500,3,FALSE),\"0\"))","v":""},{"$f":"IF(F461=\"\",\"\",(J461+K461+L461))","v":""},{"$f":"IF(F461=\"\",\"\",I461-M461)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F461=\"\",\"\",IF($AB$8=\"Animal Crash\",VLOOKUP(F461,$AB$13:$AS$500,2,FALSE),\"0\"))","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,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"",null,"","",null,null,null,"","","","","","",null,null,null,null,null,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":6,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,20,8,21],[6,20,6,21],[3,16,3,17],[4,16,4,17],[5,16,5,17],[7,16,7,17],[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],[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":"ROS"},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":"2.5"},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":1680},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":"2006-2009"},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":"ROS"}]
[null,"Route:",{"$f":"'Crash Data'!G21","v":"SR0159R   "}]
[null,"BLog:",{"$f":"'Crash Data'!D15","v":"2.5"}]
[null,"ELog:",{"$f":"'Crash Data'!D16","v":"3.0"}]
[null,"Crash Year Data:",{"$f":"LEFT('Crash Data'!D17,4)&\"-\"&LEFT('Crash Data'!D18,4)","v":"2006-2009"}]
[]
[]
[]
["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.5}]
["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":7,"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":"C25/(A25+B25)","v":34367.700550656722}]
[null,null,null,"2008 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",24068.585669781933,28922.169014084506,13469.751412429379]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Head On*\"),\"\")","v":0},0,1,"Head on",137740.53883495147,51696.436018957349,65424.470588235294]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Rear End*\"),\"\")","v":6},166172.19369458128,2,"Rear end",27695.365615763545,24949.70362769486,27543.422671651937]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Backing*\"),\"\")","v":0},0,3,"Backing",26445.545833333334,24297.19978233831,21449.751054852321]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Sideswipe - meeting*\"),\"\")","v":0},0,4,"Sideswipe - meeting",62562.632107843136,37430.161757486501,92341.119850187271]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Sideswipe - passing*\"),\"\")","v":4},124296.32934378869,5,"Sideswipe - passing",31074.082335947172,24272.364495214573,27380.278820375333]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Angle*\")+COUNTIF('Crash Data'!M$21:M$65000,\"Right*\"),\"\")","v":2},85233.740410132683,6,"Angle",42616.870205066341,28552.750670322057,34363.70738636364]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Parked vehicle*\"),\"\")","v":0},0,7,"Parked Vehicle",23966.840037418147,21194.581283446507,31100.204927211646]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Pedestrian*\"),\"\")","v":0},0,8,"Pedestrian",126964.95774647887,74466.377685950414,189291.07619047619,null,"DO NOT MODIFY CELLS IN THIS COLUMN"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Animal*\"),\"\")","v":1},16567.709368737476,9,"Animal",16567.709368737476,18143.47956070775,17037.63251798561]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Train*\"),\"\")","v":0},0,10,"Train",100058.81818181818,200714.25,0,null,"Rural Non-Freeway"]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Pedalcycles*\"),\"\")","v":0},0,11,"Pedacycles",70158.955271565501,41648.656438026475,29083.303030303032,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",31861.200000000001,0,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":3},85444.185430065525,13,"Fixed object",28481.395143355174,25433.61158451084,23462.761279127419]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Other object*\"),\"\")","v":0},0,14,"Other object",23288.416931216932,18485.260489510489,16894.752761257434]
[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":2},129123.82952957615,16,"Overturning",64561.914764788075,42095.851637764936,65612.462328767127]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Other non-collision*\"),\"\")","v":0},0,17,"Other non-collision",20706.44115796098,21600.330239752515,20815.441055718475]
[null,{"$f":"IF(A$6:A$24=\"\",COUNTIF('Crash Data'!M$21:M$65000,\"Left*\"),\"\")","v":1},{"$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":46148.32268559598},18,"Left Turn",46148.32268559598,31608.117784529095,36141.301703163015]
[{"$f":"SUM(A6:A24)","v":0},{"$f":"SUM(B6:B24)","v":19},{"$f":"SUM(C6:C24)","v":652986.31046247773}]
[]
[]
[]
[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":8,"n_rows":87,"n_cols":78,"rows_kept":87,"cut":false,"hidden":false,"merged":[[49,17,49,19],[50,17,50,19],[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],[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],[8,25,8,26],[28,12,28,13],[30,12,30,13],[8,21,8,22],[8,23,8,24],[44,28,44,30],[36,23,36,30],[33,28,33,30],[30,28,30,30],[27,21,27,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],[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],[49,10,49,12],[50,10,50,12],[51,0,51,9],[51,10,51,12],[49,0,49,9],[50,0,50,9],[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],[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],[22,19,22,20],[23,19,23,20],[24,19,24,20],[25,19,25,20],[22,28,22,30],[23,28,23,30],[24,28,24,30],[24,1,24,11],[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],[21,12,21,13],[22,12,22,13],[23,12,23,13],[21,1,21,11],[22,1,22,11],[23,1,23,11],[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],[34,12,34,13],[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],[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],[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":"ROS"},null,null,null,"Main Roadway",null,null,null,{"$f":"'Crash Data'!D13","v":"0159"},null,null,null,null,null,"Begin SLM",null,{"$f":"'Crash Data'!D15","v":"2.5"},null,null,"End SLM",null,{"$f":"'Crash Data'!D16","v":"3.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":"2009-07-23T08:25:46.130"},null,null,null,null,null,null,null,null,"Crash BDate",null,{"$f":"'Crash Data'!D17","v":"20060101"},null,null,"Crash EDate",null,{"$f":"'Crash Data'!D18","v":"20090601"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]"]
[2004,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2004\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2004\")","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"]
[2005,{"$f":"COUNTIF('Crash Data'!BJ$21:BJ$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BK$21:BK$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BL$21:BL$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BM$21:BM$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BN$21:BN$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BO$21:BO$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BP$21:BP$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BQ$21:BQ$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BR$21:BR$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BS$21:BS$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BT$21:BT$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BU$21:BU$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BV$21:BV$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BW$21:BW$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BX$21:BX$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BY$21:BY$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!BZ$21:BZ$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CA$21:CA$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CB$21:CB$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CC$21:CC$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CD$21:CD$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CE$21:CE$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CF$21:CF$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CG$21:CG$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CH$21:CH$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CI$21:CI$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CJ$21:CJ$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CK$21:CK$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CL$21:CL$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CM$21:CM$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CN$21:CN$65000,\"=2005\")","v":0},{"$f":"COUNTIF('Crash Data'!CO$21:CO$65000,\"=2005\")","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"]
[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},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"]
[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,8,"6 Upgrade signs - general"]
[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,9,"7 Lane use signs - overhead"]
[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,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},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 2006-2008 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":{"$error":"#NUM!"}},{"$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":{"$error":"#NUM!"}},-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":10763.095855045003},null,null,"=",{"$f":"V44*Y44","v":0},null,null,null,null,null,null,null,"10 Years",{"$f":"NPV(Z51,AN44:AW44,K52)-K50","v":{"$error":"#NUM!"}},-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":87442.021758686606},null,null,"=",{"$f":"V45*Y45","v":0},null,null,null,null,null,null,null,"15 Years",{"$f":"NPV(Z51,AN45:BB45,K52)-K50","v":{"$error":"#NUM!"}},-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":{"$error":"#NUM!"}},-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":{"$error":"#NUM!"}},-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":{"$error":"#NUM!"}},-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":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 - 2008)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,10763.095855045003,87442.021758686606,"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,8214.4756039791573,81509.623555583021,"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,9265.7248236263622,80792.442163087035,"Cities and Incorporated Villages"]

{"sheet":"Safety App","index":9,"n_rows":51,"n_cols":36,"rows_kept":51,"cut":false,"hidden":false,"merged":[[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]]}
[]
[]
[]
[]
[]
["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":"ROS-0159R"},null,{"$f":"G34","v":"Rural Non-Freeway"},{"$f":"'Crash Data'!D15","v":"2.5"},{"$f":"'Crash Data'!D16","v":"3.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",2008,null,"Rate of Return:  ",{"$f":"'ROR Analysis'!Z51","v":{"$error":"#NUM!"}},null,null,null,null,null,"High Risk Rural Road Calculation:  ",{"$f":"((K7+L7)*100000000)/(M7*365*F7*N7)","v":{"$error":"#DIV/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)"]
[]
[]
[]
[]
[]
["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(B7=\"Intersection\",J7,\"\")","v":""},{"$f":"IF($B$7=\"Section\",\"\",VLOOKUP(A23,$Q$36:$R$46,2,TRUE))","v":{"$error":"#N/A"}},{"$f":"IF(B7=\"Section\",J7/F7, \"\")","v":""},{"$f":"IF($B$7=\"Intersection\",\"\",VLOOKUP(C23,$S$36:$T$46,2,TRUE))","v":{"$error":"#N/A"}},{"$f":"(J7*1000000)/(M7*365*F7*N7)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(E23,$U$36:$V$46,2,TRUE)","v":{"$error":"#DIV/0!"}},{"$f":"G32","v":34367.700550656722},{"$f":"VLOOKUP(G23,$W$36:$X$51,2,TRUE)","v":14},{"$f":"((AI36*G7+AI37*H7+AI38*I7)*1000000)/(N7*M7*365*F7)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(I23,$Y$36:$Z$51,2,TRUE)","v":{"$error":"#DIV/0!"}},{"$f":"O7/N7","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(K23,$AA$36:$AB$51,2,TRUE)","v":{"$error":"#DIV/0!"}},{"$f":"E9","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(M23,$AC$36:$AD$51,2,TRUE)","v":{"$error":"#NUM!"}},{"$f":"P7","v":0},{"$f":"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":34367.700550656722}]
[]
[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,"EPDO Factors"]
[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",88.338935290338,"Section"]
[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",5.2612670012078082,"Intersection"]
[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,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":10,"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 - 2007)"]
[null,"SYSTEM ","PDO ","INJ/FAT"]
[null,"Rural State Highways ",12799.264274302051,84339.832105621041]
[null,"Counties and Unincorporated Villages ",12293.646620126001,78939.529902642564]
[null,"Cities and Incorporated Villages",14768.685326920833,70405.510379566505]

{"sheet":"Help File","index":11,"n_rows":792,"n_cols":67,"rows_kept":792,"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 (5-30-08 Version)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Updated: 8-20-08",null,null,null,null,null,null,null,null,null,null,null,null,null,"REAR END                      ","NORTH               "]
[null,null,null,null,null,null,null,null,null,null,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               "]
[null,null,null,null,null,null,null,null,null,null,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                "]
[null,null,null,null,null,null,null,null,null,null,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                "]
[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 GQL Standard Queries Page with the GQL query!",null,null,null,null,null,null,null,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           "]
[null,null,"Start by running the associated query in GQL on a location",null,null,null,null,null,null,null,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           "]
[null,null,null,null,null,null,null,null,null,null,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           "]
[null,null,null,null,null,null,null,null,null,null,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           "]
[null,null,null,null,null,null,null,null,null,null,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                    "]
[null,null,null,null,null,null,null,null,null,null,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 CD Toolbox (or use the shortcut \"Ctrl\" + \"t\" )"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 GQL Standard Queries Page with the GQL query!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Go to Crash Data Tab"]
[]
["Go to top of page - Help File"]