How to do HAZID in Excel?

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.