osha log 300 template

Workplace Injury and Illness Incident Register

This system is designed to track occupational injuries and illnesses for regulatory compliance. It serves as a central repository for incident documentation, classification, and reporting. The scope includes all recordable events occurring within [Company Name] facilities. This log should be updated within 7 days of receiving information that a recordable injury or illness has occurred and maintained for 5 years.

Column Definitions

• Case #: [Numeric/Sequential]. Unique identifier for each entry.
• Date of Incident: [Date]. Format: YYYY-MM-DD.
• [Full Legal Name]: [Text]. The employee's name as it appears on official records.
• Job Title: [Text]. The specific role held at the time of incident.
• Location of Event: [Text]. The specific area or facility where the event occurred.
• Injury/Illness Description: [Text]. Brief summary of the body part and the nature of the condition.
• Resulting Days Away: [Integer]. Total count of calendar days the employee was away from work.

Essential Formulas

Calculate Total Days Away for Year-End Summary:

=SUM(G2:G100)

Calculate Average Days Away per Incident:

=AVERAGEIF(G2:G100, ">0")

Check for Missing Data (Case Number Validation):

=IF(ISBLANK(A2), "MISSING", "OK")

Formatting and Validation Rules

• Data Validation (Date Column): Select the Date column and apply "Data Validation" -> "Criteria: Date" -> "Is valid date" to prevent entry errors.
• Conditional Formatting (Days Away): Apply a "Color Scale" rule to the "Resulting Days Away" column. Set values > 10 to a "Light Red" fill to highlight high-severity incidents.
• Data Validation (Dropdown): Create a list for "Location of Event" using a separate reference sheet to ensure consistent site naming conventions across the organization.