HAZOP worksheet Excel template.
The process safety study, one row per node, parameter and guide word, with the cause, the consequence, the safeguards already in the design, and the action that closes it.
- ANode ID
- BNode Description
- CParameterFlowLevelPressureTemperatureCompositionReactionOther
- DGuide WordNoMoreLessReverseAs Well AsPart OfOther Than
- ECause
- FConsequence
- GSeverity12345
- HLikelihood12345
- IExisting Safeguard
- JRecommendation
- KRecommendation ID
- LAssignee
- MStatusOpenIn ProgressClosedRejected
Frozen header, auto-filter on every column, 48 blank rows ready to fill. No macros.
What each HAZOP worksheet column is for, and who fills it
| Column | What goes in it | Filled by |
|---|---|---|
| Node ID, Node Description | The section of process under study, bounded by one design intent. A node is a line or a vessel with a single intent, not a whole unit. | Facilitator, before the session |
| Parameter | The process variable being deviated: flow, pressure, temperature, level, composition. | Facilitator, before the session |
| Guide Word | No, More, Less, Reverse, As Well As, Part Of, Other Than, applied to the parameter to generate the deviation. IEC 61882 defines the set. | Facilitator, in session |
| Cause | The credible initiating event that produces the deviation. One row per cause, never a list inside one cell. | The team, in session |
| Consequence | What happens if nothing intervenes. The worksheet states which basis the row is written on. | The team, in session |
| Severity, Likelihood | Two numbered columns. The matrix they refer to is recorded in the report front matter. | The team, in session |
| Existing Safeguard | Protection already in the design. The column carries the safeguard as the team recorded it, with the drawing it was read from. | The team, checked against the drawing |
| Recommendation, Recommendation ID | The action, and a stable identifier that survives into the action tracker and the safety requirements specification. | Facilitator, in session |
| Assignee, Status | Who owns it and where it stands. This is what turns a study into a closeable action list. | Project, after the session |
Seven guide words.
Each guide word is applied to each parameter at each node to name a deviation. The Guide Word dropdown offers these seven, with the meanings IEC 61882 gives them; the standard adds Early, Late, Before and After for timing and sequence.
| Guide word | Meaning | Applied to flow |
|---|---|---|
| No | Complete negation of the design intent | No flow |
| More | Quantitative increase | More flow |
| Less | Quantitative decrease | Less flow |
| As Well As | Qualitative increase: something is there in addition | A second phase or a contaminant in the flow |
| Part Of | Qualitative decrease: part of the intent is missing | One component of a mixture missing |
| Reverse | Logical opposite of the design intent | Reverse flow |
| Other Than | Complete substitution | A different material flowing |
Common questions
What is a HAZOP study worksheet.
The HAZOP, hazard and operability worksheet is the process-safety register of every deviation considered during a HAZOP study. One row per, node, parameter, guide word, cause combination with consequence, existing safeguard, recommendation, and assignee. It is the document the LOPA team reads to scope independent protection layers and the action tracker reads to drive closure.
What columns are in this template.
Thirteen columns. Parameter, Guide Word, Severity, Likelihood, and Status are dropdowns. The Guide Word dropdown offers seven: No, More, Less, Reverse, As Well As, Part Of and Other Than.
Does this drive the LOPA worksheet too.
No. LOPA, layer of protection analysis is a separate worksheet that takes the high-consequence HAZOP rows as input. The two documents are linked at the recommendation level. A HAZOP recommendation that calls for additional protection becomes a LOPA scenario with an independent protection layer count.
What is the difference between a HAZOP worksheet and a HAZOP report.
The worksheet is the row-by-row record produced in the session: one row per node, parameter and guide word, carrying the cause, consequence, safeguards and recommendation for each. The report is the document written around it, holding the scope, the team, the risk matrix, the methodology and the conclusions, with the worksheet as its central appendix. Auditors read the report. Engineers work from the worksheet.
How many rows should a HAZOP worksheet carry per node.
One row per credible deviation, meaning one per parameter and guide word combination the team judges to have a credible cause. A node with five parameters against seven guide words has thirty-five combinations, of which perhaps eight to fifteen are credible on a typical process node. Recording only the credible ones is correct. A blank row for every combination makes the worksheet unreadable and buries the real findings.
Can a HAZOP worksheet be reopened during a revalidation.
Yes, and the recommendation identifier is what makes it possible. A revalidation checks whether the original causes and safeguards still hold against the current P&ID. Stable identifiers let the revalidation reference the original finding instead of restating it, so the history of a hazard survives across studies.
What file format should the worksheet be in for handover.
Whatever the operating company process safety information system accepts, which in practice is nearly always a spreadsheet with one row per deviation. Keep the column order stable across studies on the same asset, because the value of the register is comparison across revalidations.
Run it on your drawings.
The template is a manual starting point you fill yourself. Upload the source document instead and review the register Tagsight reads from it.