📦 Resource excel

ISO 12100:2019 Hazard Identification Worksheet (Excel)

The ISO 12100:2019 Hazard Identification Worksheet (Excel) is a structured, spreadsheet-based tool aligned with the principles of ISO 12100:2019 — Safety of machinery — General principles for design — Risk assessment and risk reduction. It supports systematic identification, documentation, and initial evaluation of hazards associated with machinery throughout its lifecycle. The worksheet facilitates traceability, collaborative risk assessment, and integration with subsequent risk reduction planning.

📖 Overview

ISO 12100:2019 establishes a three-stage risk assessment process: hazard identification, risk estimation, and risk evaluation. The Excel worksheet operationalizes the first stage — hazard identification — by providing standardized fields to catalog potential sources of harm (e.g., mechanical, electrical, thermal, noise, ergonomic, or hazardous substances) linked to specific machine functions, operating modes (normal, startup, shutdown, maintenance, fault), and user roles. Each identified hazard is anchored to relevant clauses of ISO 12100:2019 Annex A (which enumerates common hazard categories) and cross-referenced to applicable C-type standards or other harmonized legislation (e.g., EU Machinery Directive 2006/42/EC). The worksheet typically includes columns for hazard description, location, affected persons, contributing factors, existing safeguards, and preliminary severity/likelihood notes — enabling seamless transition to formal risk estimation (e.g., using matrix-based or numeric methods per ISO 14121-1 or ISO/TR 22100-2). Crucially, it emphasizes iterative use: hazards must be re-identified after each design modification or safeguard implementation, ensuring dynamic alignment with the standard’s principle of 'risk reduction as an iterative process'.

📑 Key Components

1 Hazard Description & Classification (per ISO 12100 Annex A)
2 Machine Function / Operating Mode Context
3 Affected Persons & Exposure Conditions
4 Existing Safeguards & Control Measures
5 Traceability Fields (Clause Reference, Revision Log, Assessor Details)

🎯 Applications

  • Pre-market machinery safety compliance documentation for CE marking
  • Internal design review and cross-functional safety workshops
  • Training tool for safety engineers and technical personnel on hazard recognition patterns

📐 Key Formulas

Hazard Index (Optional Ranking)

SEVERITY × LIKELIHOOD × EXPOSURE_FREQUENCY

A simplified numeric scoring aid (not mandated by ISO 12100 but commonly embedded) to prioritize hazards for further risk estimation; values are qualitative inputs mapped to ordinal scales (e.g., 1–5)

Safeguard Effectiveness Rating (SER)

1 − (Residual_Risk / Initial_Risk)

A conceptual ratio used post-safeguard implementation to estimate relative risk reduction; requires calibrated risk estimation inputs beyond basic worksheet scope

🔗 Related Concepts

Risk Estimation (ISO 14121-1) Hierarchy of Controls (Elimination → PPE) Safety Lifecycle (IEC 61508 / ISO 13849) Type A, B, and C Standards Technical File Documentation (EU Machinery Directive)

📚 References

#machinery_safety #risk_assessment #excel_template #ISO_12100 #hazard_identification