osha 300 log excel template

Annual Workplace Injury and Illness Recordkeeping System

This system provides a structured framework for recording reportable work-related injuries and illnesses as required by federal safety regulations. This template is designed for use by [Safety Manager Name] at [Company Name] for the reporting year [Year]. Updates should be performed within 7 days of receiving information that a recordable injury or illness has occurred.

Column Definitions

• Case Number: Numeric; unique identifier for the reporting year.
• Date of Incident: Date format (YYYY-MM-DD); when the event occurred.
• [Full Legal Name]: Text; the employee involved.
• Job Title: Text; the employee's official position.
• Location of Incident: Text; specific facility or department area.
• Injury/Illness Description: Text; brief description of the body part and object/substance involved.
• Result: Dropdown; select from: Death, Days Away, Job Transfer, Other Recordable.

Calculation Formulas

Use these formulas to track totals for your annual summary:

Total Days Away from Work:

=SUM(G2:G100) 

(Note: Ensure column G contains only numeric values for days count)

Count of Recordable Incidents:

=COUNTA(A2:A100)

Percentage of Incidents resulting in "Days Away":

=COUNTIF(G2:G100, "Days Away") / COUNTA(A2:A100)

Data Validation & Formatting

1. Dropdown Selection: Select the "Result" column range, go to Data > Data Validation > Criteria: List of items. Enter: Death, Days Away, Job Transfer, Other Recordable.
2. Date Validation: Select the "Date of Incident" column, go to Data > Data Validation > Criteria: Date > Is valid date.
3. Conditional Formatting: Highlight the "Result" column. Set a rule: If text is "Days Away", change cell background to light red. If text is "Job Transfer", change background to light yellow.