osha 300 log injury type

Workplace Injury and Illness Recordkeeping Log

This system serves as the primary repository for tracking work-related incidents to ensure regulatory compliance. It is designed to capture the nature of injuries, medical treatment, and lost workdays. This log must be updated within seven calendar days of receiving information that a recordable injury or illness has occurred and be maintained for five years.

Column Definitions

• Case Number: [Unique Identifier/Alpha-numeric]. Must be sequential.
• Date of Incident: [Date]. Use YYYY-MM-DD format.
• [Full Legal Name]: [Text]. Employee's full name as per payroll.
• Job Title: [Text]. Current role at time of incident.
• Location/Department: [Dropdown]. Select from [List of Facilities].
• Description of Injury: [Text]. Must include part of body and object/substance involved.
• Days Away from Work: [Integer]. Total count of calendar days the employee was unable to work.

Calculation Formulas

Total Days Away from Work (Summary Cell):

=SUM(G2:G100)

Count of Recordable Incidents:

=COUNTA(A2:A100)

Average Days Lost per Incident:

=IFERROR(AVERAGE(G2:G100), 0)

Data Validation and Formatting

1. Date Validation: Apply "Data Validation" to the Date column. Select "Date" criteria and set to "is valid date" to prevent entry errors.
2. Conditional Formatting (High Severity): Apply a rule to the "Days Away from Work" column. If cell value > 5, highlight the cell in Light Red Fill with Dark Red Text to flag significant lost-time cases.
3. Dropdown Menu: Create a named range for "Locations" and apply "Data Validation" > "List" to the Location/Department column to ensure standardized reporting across all sites.