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

Step 1: Have a HAZID workbook template

If you don’t have the standardized Hazid Excel template workbook on your computer you can contact support@cgerisk.com 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 high 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, the Advanced edition of the software is required. Find out what edition you have 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” (see figure below)

If you have made sure you have the advanced edition of BowTieXP 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 Windows 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”