Abstract light streaks and reflections
ComplianceESGJuly 21, 2012|UpdatedFebruary 09, 2022

How to do HAZID in Excel?

HAZID stand for Hazard Identification, where you identify the activities within your organization that have the potential to cause harm.

This methodology identifies hazards, potential undesirable consequences and evaluate the severity and likelihood of what is identified. The major hazards identified, require a more detailed risk assessment. We provide a standardized HAZID Excel Template workbook. The HAZID Excel Template workbook is easy to use and customizable to your needs. Let's explore the steps you need to take to do a HAZID in Excel. 

Step 1: Have a HAZID workbook template

If you don’t have the standardized HAZID Excel template workbook on your computer you can contact [email protected] to request the template.

Step 2. Configure the risk matrices

The HAZID workbook consist of two excel sheets: the HAZID sheet and the risk matrices sheet. The risk matrices are pre-made, but editable to your needs. This indicates the frequency and the severity of the top event. The top event is the moment there is no control over the hazard. The frequency indicates how often the top event lead to the consequences in this category and the severity indicates the possible extent of damage when the top event occurs. Under settings you can adjust the ‘high risk hazard score’. For the hazards with this score or higher than this score, a bowtie diagram can be made eventually.

Step 3. Determine the hazards

In the HAZID sheet you list all hazards of your organization and rate these hazards according to your risk matrices. The columns show the code of the hazards, hazard title, location where the hazards occurs, the top event, and the consequences if the top event happens. With a drop-down menu, the list of the different frequency and severity definitions is shown. You select the frequency and severity per hazards and this generates a score.
If this score is equal or higher than the score you have identified in the risk matrices, it automatically shows if the hazard is a ‘high potential hazard’. For these high potential hazards, a bowtie can be made in BowTieXP.

Step 4. Link to BowTieXP

In order to be able to link this template to BowTieXP, BowTieXP Complete is required. Find out if you have BowTieXP Complete in three steps:

  • Open BowTieXP
  • In the menu, click “Help” and select “About…” and a dialog pops up
  • Under “Enable Features”, you should see “Advanced BowTieXP” (see figure below)

If you have made sure you have the BowTieXP Complete installed and the HAZID workbook is completed, the information can be linked to BowTieXP by completing the following steps:

  • Open the HAZID sheet and press the “Prepare for BowTieXP” button. For each of the hazards, a spreadsheet will be generated.
  • Save the file.
  • Open BowTieXP and open Scrap book through the menu (View -> Windows -> Scrap book).
  • Locate the Excel file in Files Explorer and drag it onto the Scrap book.

Notes

Windows may automatically block specific Excel functionality for security reasons. Because of this, you have to unblock this functionality the first time you open the file in Excel. You may see the following warnings:

  • Protected view. This file originated from an Internet location and might be unsafe. To resolve, click “Enable Editing”
  • Security Warning. Macros have been disabled. To resolve, click “Enable Content”


You don't have BowTieXP Complete?

Don't worry, you can request a trial or plan a demonstration with one of our solution experts so you can explore all available features. If you need help with linking your HAZID to BowTieXP, feel free to contact our support team. 

Book Demo
Back To Top