# Hazard Identification and Risk Ranking Worksheet > Source: https://netray.co/tools/hazard-identification-risk-ranking-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Log hazards, score likelihood and severity before and after controls, and rank risks with a 5x5 matrix score. ## Category ehs-workforce ## Industry Manufacturing ## Audience - EHS manager - Quality engineer - Plant manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Area or task **Key:** area **Type:** text #### Hazard **Key:** hazard **Type:** text #### Potential harm **Key:** harm **Type:** text #### Likelihood (1-5) **Key:** l **Type:** number #### Severity (1-5) **Key:** sv **Type:** number #### Initial score **Key:** score **Type:** number **Expr:** l * sv **Format:** integer #### Initial band **Key:** band **Type:** text #### Controls **Key:** control **Type:** text #### Residual likelihood **Key:** l2 **Type:** number #### Residual severity **Key:** sv2 **Type:** number #### Residual score **Key:** score2 **Type:** number **Expr:** l2 * sv2 **Format:** integer #### Owner **Key:** owner **Type:** text **Rows:** **Area:** CNC machining **Hazard:** Rotating spindle during chip clearing **Harm:** Entanglement, laceration **L:** 3 **Sv:** 4 **Score:** 12 **Band:** High **Control:** Interlocked door, chip hook, LOTO **L2:** 1 **Sv2:** 4 **Owner:** Prod Mgr **Area:** Wash station **Hazard:** Hot alkaline solution **Harm:** Chemical burn **L:** 3 **Sv:** 3 **Score:** 9 **Band:** Medium **Control:** Splash guard, gloves, eyewash **L2:** 1 **Sv2:** 3 **Owner:** EHS **Area:** Material handling **Hazard:** Forklift and pedestrian crossing **Harm:** Crush injury **L:** 2 **Sv:** 5 **Score:** 10 **Band:** High **Control:** Marked lanes, mirrors, speed limit **L2:** 1 **Sv2:** 5 **Owner:** Logistics **Area:** Assembly **Hazard:** Manual lifting of housing 18 kg **Harm:** Back strain **L:** 4 **Sv:** 2 **Score:** 8 **Band:** Medium **Control:** Lift assist, job rotation **L2:** 2 **Sv2:** 2 **Owner:** Prod Mgr **Totals:** #### Total initial score **Key:** score **Agg:** sum **Format:** integer #### Total residual score **Key:** score2 **Agg:** sum **Format:** integer **Summary:** #### Overall risk reduction **Key:** cut **Expr:** if(gt(sum_score,0), 100 * (sum_score - sum_score2) / sum_score, 0) **Format:** percent **Notes:** Typical banding on a 5x5 matrix: 1-4 low, 5-9 medium, 10-16 high, 17-25 intolerable. Set your own bands and follow local law. This worksheet is a record aid, not a safety certification. ## Content **Intro:** A hazard log is the simplest risk tool in the plant: list hazards, score them, add controls and score again. This worksheet does the multiplication and keeps the before and after view in one table. **Sections:** #### How to use the worksheet **Body:** Walk the area with the people who do the job. For each hazard, record the harm, score likelihood and severity from 1 to 5 and write down the existing controls. Enter residual likelihood and severity after the controls. Type your band name next to each score. Sort by score in Excel to see the top risks first. **Bullets:** - Assess tasks, not only machines - Include non-routine work such as maintenance - Score without controls first, then with - Assign a named owner for each high risk #### The 5x5 matrix **Body:** Risk score equals likelihood times severity. With a 5x5 matrix the score runs from 1 to 25. Plants usually define bands, for example low up to 4, medium 5 to 9, high 10 to 16 and intolerable above 16, and tie each band to a required response. Use your own company bands; the numbers above are an example. #### Hierarchy of controls **Body:** Reduce risk in this order: eliminate the hazard, substitute something safer, apply engineering controls such as guards and interlocks, use administrative controls such as procedures and training, and only then rely on personal protective equipment. A residual score that depends mostly on PPE or training is fragile and should be revisited. #### Common mistakes **Body:** Scoring after controls only hides the true hazard. Rating severity by the usual outcome rather than the credible worst case understates risk. Forgetting to review after a process change leaves old scores in force. Treat the log as a living document with a review date. **Cta:** If incidents and permits live in your ERP or EHS system, Netray can connect them to this log. Ask for a short review. **Faq:** #### Is this a HIRA or JSA? **Answer:** It is a general hazard identification and risk ranking log, similar in structure to a HIRA. A job safety analysis breaks one task into steps; this log works at area or task level. Use whichever your procedure requires. #### What do the bands mean? **Answer:** They are an example. Companies define their own bands and required responses, such as stop work, immediate action or monitor. Use your EHS procedure and local legal requirements. #### Does it replace a legal risk assessment? **Answer:** No. Many jurisdictions require specific assessments, for example for machinery, chemicals or noise. This worksheet is a working record and does not certify compliance. #### How often should it be reviewed? **Answer:** At least annually, and after incidents, process changes, new equipment or layout changes. High risks deserve more frequent review until residual risk is acceptable. ## Search terms hazard identification worksheet, risk ranking worksheet excel, hira template, 5x5 risk matrix worksheet, risk assessment form manufacturing, residual risk worksheet, hazard log template, workplace risk assessment excel --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json