{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["Accident Register","Accident Analysis","Accident Types","Instructions"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Accident Register","index":0,"n_rows":5,"n_cols":17,"rows_kept":5,"merged":[[0,0,2,2],[0,3,0,11],[1,3,1,4],[1,5,1,11],[2,3,2,4],[2,5,2,11]],"flags":["formulas_cached_only"]}
["ACCIDENT REGISTER",null,null,"Insert Company Name Here",{"$nulls":8},"Y",null,null,"Recordable?\nY/N","Preventable?\nY/N"]
[{"$nulls":3},"Dates From:",null,"Begin Date",{"$nulls":6},"N",null,null,"y","y"]
[{"$nulls":3},"To:",null,"End Date"]
[]
["Claim/File No.","Date/Time","Location (City, St)","Driver","Unit Numbers","# of\nInjuries","# of\nFatalities","Towed Vehicle\nY/N","HazMat Spill\nY/N","Citation\nIssued\nY/N","Recordable\nY/N","Preventable\nY/N","Type\n(?)","Description"]

{"sheet":"Accident Analysis","index":1,"n_rows":59,"n_cols":14,"rows_kept":59,"merged":[[1,1,2,4],[1,6,1,8],[2,6,2,15],[7,2,7,4],[7,6,8,15],[10,13,10,15],[11,13,11,15],[12,13,12,15],[13,13,13,15],[18,6,19,14],[28,6,29,8],[30,6,31,15],[32,6,33,15],[34,6,35,15],[36,6,37,15],[38,6,39,15],[40,6,41,15],[42,6,43,15],[44,6,45,15],[46,6,47,15],[48,6,49,15],[50,6,51,15],[52,6,53,15],[54,6,55,15]],"flags":["formulas_cached_only"]}
[]
[null,"ACCIDENT ANALYSIS",{"$nulls":4},"Total Mileage",null,null,"FROM:",null,"Begin Date","TO:","End Date"]
[{"$nulls":6},"Enter Start and End Dates in the Accident Register tab. Click here."]
[null,null,"Recordable\nY/N","Preventable\nY/N"]
[null,null,"y","y"]
[]
[]
[null,null,"Number of Accidents by Type",{"$nulls":3},"Accident Frequency Rates (?)"]
[null,null,"#","|","Type"]
[null,null,"N/A",null,"Not in Use",{"$nulls":4},"Total",null,null,"Frequency"]
[null,null,"N/A",null,"Not in Use",null,"Number of Accidents",null,null,0,null,null,"Input Mileage","accidents per million miles"]
[null,null,"N/A",null,"Not in Use",null,"  Recordable?",null,null,0,null,null,"Input Mileage","accidents per million miles"]
[null,null,"N/A",null,"Not in Use",null,"  Preventable?",null,null,0,null,null,"Input Mileage","accidents per million miles"]
[null,null,"N/A",null,"Not in Use",null,"  Record/Preventable?",null,null,0,null,null,"Input Mileage","accidents per million miles"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use",null,"Other Notables"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use",null,"Number of Accidents Involving:"]
[null,null,"N/A",null,"Not in Use",null,null,"Injuries",null,0,null,"HazMat Spills",null,0]
[null,null,"N/A",null,"Not in Use",null,null,"Fatalities",null,0,null,"Citations",null,0]
[null,null,"N/A",null,"Not in Use",null,null,"Tow-Aways",null,0]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use",null,"Notes"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]
[null,null,"N/A",null,"Not in Use"]

{"sheet":"Accident Types","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"merged":[[0,0,0,1],[1,7,3,14],[5,7,5,14],[6,7,6,10],[6,11,6,14],[7,7,7,10],[7,11,7,14],[8,7,8,10],[8,11,8,14],[9,7,9,10],[9,11,9,14],[10,7,10,10],[10,11,10,14],[11,7,11,10],[11,11,11,14],[12,7,12,10],[12,11,12,14],[13,7,13,10],[13,11,13,14],[14,7,14,10],[14,11,14,14],[15,7,15,10],[15,11,15,14],[16,7,16,10],[16,11,16,14],[17,7,17,10],[17,11,17,14],[18,7,18,10],[18,11,18,14],[19,7,19,10],[19,11,19,14],[20,7,20,10],[20,11,20,14],[21,7,21,10],[21,11,21,14],[22,7,22,10],[22,11,22,14],[23,7,23,10],[23,11,23,14],[24,7,24,10],[24,11,24,14],[25,7,25,10],[25,11,25,14],[26,7,26,10],[26,11,26,14]],"flags":["formulas_cached_only"]}
["Accident Types"]
[{"$nulls":7},"çDevelop your own Accident Type Directory.\n  Input accident types and use the corresponding number in the \"Type\" column of your\n  Accident Register. A list of common types of accidents has been provided below."]
["Type 1","[Empty]",null,"Type 26","[Empty]"]
["Type 2","[Empty]",null,"Type 27","[Empty]"]
["Type 3","[Empty]",null,"Type 28","[Empty]"]
["Type 4","[Empty]",null,"Type 29","[Empty]",null,null,"Example Accident Types:"]
["Type 5","[Empty]",null,"Type 30","[Empty]",null,null,"Backing",{"$nulls":3},"Roll-away and struck #2"]
["Type 6","[Empty]",null,"Type 31","[Empty]",null,null,"Right turn squeeze",{"$nulls":3},"Fire"]
["Type 7","[Empty]",null,"Type 32","[Empty]",null,null,"Rearend (#1 into rear #2)",{"$nulls":3},"Ran off road"]
["Type 8","[Empty]",null,"Type 33","[Empty]",null,null,"Rearend (#2 into rear #1)",{"$nulls":3},"Part from #1 fell off and hit #2"]
["Type 9","[Empty]",null,"Type 34","[Empty]",null,null,"Jackknife",{"$nulls":3},"Part from #2 fell off and hit #1"]
["Type 10","[Empty]",null,"Type 35","[Empty]",null,null,"Hit fixed object",{"$nulls":3},"Equipment defect"]
["Type 11","[Empty]",null,"Type 36","[Empty]",null,null,"Hit parked #2 or movable object",{"$nulls":3},"Tire blow-out/failure"]
["Type 12","[Empty]",null,"Type 37","[Empty]",null,null,"Hit low underpass",{"$nulls":3},"Theft (equipment)"]
["Type 13","[Empty]",null,"Type 38","[Empty]",null,null,"Trailer hit low wires",{"$nulls":3},"Theft (cargo)"]
["Type 14","[Empty]",null,"Type 39","[Empty]",null,null,"Left turn",{"$nulls":3},"Intersection (#1 broadsided #2)"]
["Type 15","[Empty]",null,"Type 40","[Empty]",null,null,"Passing on left of vehicle making left turn",{"$nulls":3},"Intersection (#2 broadsided #1)"]
["Type 16","[Empty]",null,"Type 41","[Empty]",null,null,"#1 made left turn in front of oncoming #2",{"$nulls":3},"Rollover curve, going too fast"]
["Type 17","[Empty]",null,"Type 42","[Empty]",null,null,"#2 made left turn in front of oncoming #1",{"$nulls":3},"U-Turn"]
["Type 18","[Empty]",null,"Type 43","[Empty]",null,null,"Lost control and skidded off roadway",{"$nulls":3},"Trailer disconnected while moving"]
["Type 19","[Empty]",null,"Type 44","[Empty]",null,null,"Lost control and #1 collided with #2",{"$nulls":3},"Trailer door swung out and hit #2"]
["Type 20","[Empty]",null,"Type 45","[Empty]",null,null,"Lost control and #2 collided with #1",{"$nulls":3},"Forced #2 off the road"]
["Type 21","[Empty]",null,"Type 46","[Empty]",null,null,"Sideswipe (passing/changing lanes)",{"$nulls":3},"Struck pedestrian or bicyclist"]
["Type 22","[Empty]",null,"Type 47","[Empty]",null,null,"Sideswipe (merging)",{"$nulls":3},"Struck animal"]
["Type 23","[Empty]",null,"Type 48","[Empty]",null,null,"Sideswipe (head-on)",{"$nulls":3},"Head-on collision; #2 over center lane"]
["Type 24","[Empty]",null,"Type 49","[Empty]",null,null,"#1 was parked or stopped; #2 struck #1",{"$nulls":3},"Head-on collision; #1 over center lane"]
["Type 25","[Empty]",null,"Type 50","[Empty]",null,null,"Roll-away",{"$nulls":3},"Miscellaneous/other"]
[{"$nulls":7},"NOTE: #1 is commonly \"your vehicle\" and #2 the \"other vehicle\""]

{"sheet":"Instructions","index":3,"n_rows":46,"n_cols":6,"rows_kept":46,"merged":[[1,0,1,2],[2,2,2,14],[3,2,3,14],[4,2,5,14],[6,2,7,14],[8,2,9,14],[12,0,12,2],[14,5,14,14],[15,2,15,14],[18,2,19,14],[20,2,22,14],[23,2,26,14],[28,2,30,14],[31,2,32,14],[36,2,37,14],[38,2,39,14],[40,2,40,14],[43,2,44,14],[45,2,46,14]],"flags":["formulas_cached_only"]}
[]
["Getting started:"]
[null,".1.","Select \"Save As\" (F12 on the top of the keyboard). Name the file to include the year the register will be covering and save in a memorable location."]
[null,".2.","Go to the Accident Register (see tabs below) and fill in the appropriate cells for Company name, Begin Date and End Date."]
[null,".3.","Go to the Accident Types tab and create an \"Accident Type Directory\" to be used in the \"Types\" column of the Accident Register. See more notes below."]
[]
[null,"è","The Accident Register is now ready to use. We recommend recording all accidents/incidents, however, if used only as a DOT recordable accident register, the Federal Motor Carrier Safety Administration requires at least the information in the gray columns to be recorded."]
[]
[null,"è","The Accident Analysis can be evaluated at any time; however, for the most accurate accident frequency rates, you must input your most current mileage estimate."]
[]
[]
[]
["Notes for use:"]
[null,"General (all tabs):"]
[null,"\u009f","Shaded yellow cells:",null,null,"are required for the Accident Analysis to work properly. If a shaded yellow cell appears, a value should be placed in it."]
[null,"\u009f","Also take note of any text in red, as it will instruct you as to what should be placed in that cell."]
[]
[null,"Accident Register Tab:"]
[null,"\u009f","The Accident Register can be used as the required DOT recordable accident register, however, has been designed to record all accidents, regardless of fault and/or severity, and includes a column to identify if the accident was DOT recordable. "]
[]
[null,"\u009f","Column headings that include a \"Y/N\" are yes/no columns only. If anything but Y (for yes) or N (for no) is placed in one of these columns a warning will appear, asking you to change the input. Also, if anything but a Y or N is placed in one of these cells, the Accident Analysis will not work properly."]
[]
[]
[null,"\u009f","The Accident Register includes filtering capability, as indicated by the drop-down boxes at the bottom right of each column heading. If, for instance, you would like to see only DOT recordable accidents, click on the Recordable? heading. Clicking the drop-down box will provide a list of all entries in that column. Select \"Y\", and the register will automatically filter, showing only those accidents listed as \"Y\" for recordable. To reset the register, click the drop-down box again and select \"All\"."]
[]
[]
[]
[null,null,"NOTE: If a filter is in affect, the arrow inside the drop-down box will turn from black to blue."]
[null,"\u009f","The Type column can be used to manually input accident types (i.e. typing \"Backing\" directly into the cell); however, it was designed to be a tool for Accident Analysis. The Accident Types tab is for classifying common accident types, creating a directory. The corresponding \"types\" number can then be used in the Type column of the Accident Register, where the Accident Analysis tab will be able to count them by type."]
[]
[]
[null,null,"IMPORTANT: If using accident type classification numbers, be sure to classify your accidents correctly according to the Accident Types listed in your directory, as it will directly affect your Accident Analysis."]
[]
[]
[null,"Accident Analysis Tab:"]
[null,"\u009f","The Accident Analysis is automatically generated from the information you provide in the Accident Register. "]
[null,"\u009f","Accident Frequency Rates are calculated by mileage; to obtain this information, there is a box at the top for total mileage within the given time frame (same as the time frame for the Accident Register)."]
[]
[null,"\u009f","If you are using the Accident Types directory, the \"Accidents by Type\" box will display all types currently in use, along with the total number of accidents associated with that type. The most common type of accident will be automatically highlighted."]
[]
[null,null,"NOTE: To get the most out of the Accident Analysis, an Accident Types Directory should be established."]
[]
[null,"Accident Types Tab:"]
[null,"\u009f","Create your own Accident Types Directory by placing common accident types in the given table and using their corresponding numbers in the Types column of the Accident Register. We have provided a list of common accident types for your convenience, but any type(s) can be used."]
[]
[null,"\u009f","Accident Types can be added at any time during the Register's use. If a new type of accident has occurred and does not fit one of the current accident classifications displayed, add it to the next available row."]