What-If PHA Automated Spreadsheet

Question, scenario, risk, and equipment management simplified by our What-If PHA Automated Spreadsheet. Pre-loaded with a library of popular What-If questions for the chemical and process industries.

Guidelines for PHA

Develop a thorough, orderly, systematic approach for identifying, evaluating, and controlling potential hazards within a process involving potentially hazardous chemicals.

Ammonia Refrigeration PHA Question Set

Ammonia Process Question Set suitable for Refrigeration Systems and OSHA PSM and EPA Risk Management. Question set provided in Microsoft Excel Format.

Instructions for What-If PHA Automated Spreadsheet

Step-by-step instructions accompanied by screenshots for our What-If PHA Automated Spreadsheet. See how your questions, scenarios, risk, and equipment are managed.

  1. Video for Introduction to Process Hazard Analysis

  2. Video for What-If PHA Automated Excel Spreadsheet

  3. Verify System Requirements and Enable Digitally Signed Macros.
    Excel Version 2007 or Newer is required. Mac users may deploy on Parallels Desktop for Mac, vmWare, or similar Windows application hosting environment. The spreadsheet automation macros are digitally signed with our "industrydocs" certificate to ensure integrity and protection from malware. The Excel Trust Center may be configured to trust a Publisher, Location, or Document. For this example, we will use Excel 2016 and trust the document.
    1. Enable digitally signed macros within Excel:
    2. Open the spreadsheet, you will receive a security warning regarding active content that has been disabled, and click the "Enable Content" button as shown below:
  4. Define Site, Process, and Equipment Specific Information.
    View and edit this information within the Lookup Tables worksheet. Data within the Lookup Tables worksheet may be directly edited. Rows may be added by right-clicking on a table cell and choosing Insert->Table Rows Above. Rows may be deleted by selecting a range of rows, right-clicking and choosing Delete->Table Rows. Edits performed within the Lookup Tables worksheet are cascaded to the Master Question Table worksheet. Note: Table columns must not be deleted. Table structures and column headings must not be changed as this will break the underlying VBA automation code.
    1. Define the site Areas:
    2. Define the Processes:
    3. Define the Equipment Types:
    4. Define the Equipment Tags and associate them with their respective Equipment Types, Areas, and Processes. You may freely enter whatever data you would like for the Equipment Tag No. The Equipment Type, Area, and Process entries untilize drop-down lists that reflect the data of their respective tables.
    5. Easily import the above information from steps 1 thru 4 via the "Import Equipment" button shown in the previous Step 4. The Import Equipment screen allows a range of 4 columns containing: Tag No, EQPT Type, Area, and Process to be copied from another spreadsheet. Clicking the "Import Equipment" button displays the following screen:
  5. Review What-If Question Information.
    The What-If PHA Spreadsheet is pre-loaded with 100+ sample questions for the chemical and process industries.
    1. Review Question Categories:
    2. Review Master Question List::
    3. Easily import the above information from steps 1 thru 2 via the "Import Questions" button shown in the previous Step 1. The Import Questions screen allows a range of 3 columns containing: Sequence, Question, and Question Category to be copied from another spreadsheet. Clicking the "Import Questions" button displays the following screen::
    4. Assign questions to specific Equipment Types:
  6. Review/Customize Risk Matrix and Associated Charts.
    1. The Default Risk Assessment Matrix is 5x5, and it may be customized for different dimensions and matrix values. This chart is purely informational and may be edited without concern for rendering worksheet logic inoperative. It is located in the Matrix worksheet and appears as follows:
    2. A Risk Likelihood Definitions sample chart is located in the Matrix worksheet. This chart is purely informational and may be edited without concern for rendering worksheet logic inoperative:
    3. Sample Severity meanings are displayed in this chart located in the Matrix worksheet. This chart is purely informational and may be edited without concern for rendering worksheet logic inoperative:
    4. A sample chart of Risk Assessment values and their meanings is located in the Matrix worksheet as shown below. The following chart may be edited to fit your What-If model; however, Excel Named Ranges are defined on the cells in the Assessment Values column and these Named Ranges are referenced within the formula for Risk calculation located in the Risk cell of the hidden "Template" worksheet. You may modify the text within the Meaning or Accountable Organizations columns without concern for rendering worksheet logic inoperative:
    5. When editing the Risk Matrix dimensions and values, it may be necessary to update the formula and the dynamic color formatting for the Risk cell in the hidden Template worksheet. The dynamic color coding of the Risk cell is achieved through conditional formatting as shown in the following sample from the Matrix sheet:
  7. Filter, Select, and Copy Questions to a New or Existing What-If.
    1. The Select Questions sheet has a filter mechanism whereby the user may choose "ALL" or specific Question Categories and EQPT Types. Choose the filter conditions and click the Apply Filter button to display the matching Questions. Mark the Sel column checkbox for desired Questions and click the Copy To button. A sample from the Select Questions sheet is shown below:
    2. A Copy Questions screen is triggered by the previous step when the user selected Questions and clicked the Copy To button. Now, the user may choose an Existing or New What-If Name and an EQPT Tag for which to apply the previously selected questions. Selecting an EQPT Tag is simplified by filters for Area, Process, and EQPT Type. After locating the desired EQPT Tag, the user clicks to highlight it and then clicks OK to finalize the copy process. A sample Copy Questions screen is shown below:
    3. After choosing OK in the previous step, a What-If worksheet is created or updated as shown below:
    4. Risk Matrix value dropdown lists and formulas are automatically inserted into the Severity, Likelihood, and Risk columns as shown below:
 

Increase your PHA study productivity with our automated spreadsheet and the included PHA resources.

Processing Tweets

  • Processing Magazine

    RT @PI_ProcessInst: The critical role of material selection in preventing #diaphragm #seal failure | https://t.co/qq20k49NHE @EMR_Automatio

    Fri Apr 16 21:54:00 - 0 Favorite
  • Processing Magazine

    Prioritizing asset importance: Why determining asset criticality matters for #IIoT | https://t.co/Ev2ndDtgXuhttps://t.co/IMnu7jx4qe

    Fri Apr 16 20:26:32 - 0 Favorite
  • Processing Magazine

    Spotlight on pump systems: Top 5 myths debunked. Uncovering common misconceptions around pump system design, setup… https://t.co/kg18N8GSxD

    Thu Apr 15 20:59:08 - 2 Favorite
  • Processing Magazine

    Despite recent attention to combustible dust, many #processors operate in dangerous conditions as standard procedur… https://t.co/0UxLLHeliI

    Wed Apr 14 21:43:02 - 0 Favorite
  • Processing Magazine

    Following catastrophic leaks, product loss and asset failures, three processors moving aggressive materials realize… https://t.co/VQu2bePAL2

    Wed Apr 14 14:07:02 - 2 Favorite
  • Processing Magazine

    Six ways to attack metal contamination to improve product purity and avoid recalls | https://t.co/vVqtxqTPtshttps://t.co/HPFckx7oXA

    Tue Apr 13 18:51:03 - 1 Favorite
  • Processing Magazine

    In this Q&A, Processing connected with Andreas Eschbach to find out more about plant process management and its ben… https://t.co/Vcqulb4tww

    Tue Apr 13 16:13:11 - 2 Favorite
  • Processing Magazine

    Remote alarm notification software is more critical than ever | https://t.co/mXFTV6B63i @WIN911Alarm #foodprocessing https://t.co/dIoLb3dRUW

    Mon Apr 12 20:59:52 - 0 Favorite
  • Processing Magazine

    Learn about the Opti Series of magnetic circuits in this Processing Industry Brief with @IMImagnets: “Magnetic Circ… https://t.co/oCDeGkYp4A

    Thu Apr 08 20:32:06 - 2 Favorite
  • Processing Magazine

    With digital storefronts and online marketplaces, #chemical companies can capitalize on their customers’ growing pr… https://t.co/Vo85XXaA0E

    Wed Apr 07 17:09:08 - 2 Favorite
  • Processing Magazine

    Taking #robotic #process #automation to the next level | https://t.co/IqO3M29HeY @blueprintsys https://t.co/bhkORoa8Ma

    Tue Apr 06 20:01:06 - 3 Favorite
  • Processing Magazine

    Learn about the Opti Series of magnetic circuits in this Processing Industry Brief with @IMImagnets: “Magnetic Circ… https://t.co/CdYDZnM0Rx

    Tue Apr 06 17:31:02 - 1 Favorite
  • Processing Magazine

    In this case study, a #hemp processor improves product quality and reduces waste | https://t.co/78SwA2mqQJ https://t.co/zEUJjkTMNR

    Mon Apr 05 18:20:04 - 2 Favorite
  • Processing Magazine

    Learn about the Opti Series of magnetic circuits in this Processing Industry Brief with @IMImagnets: “Magnetic Circ… https://t.co/lLLfQsoXlo

    Fri Apr 02 16:45:18 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via #SealConnect: "#Oil analysis is key for #lubricationreliability because it reveals how well the seal operates and can help d…

    Thu Apr 01 20:53:11 - 0 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: Nominations are open for our annual Innovation Awards program, recognizing the latest innovations and technology. Submi…

    Thu Apr 01 14:12:01 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: "To make sure #equipment ... has a good #ROI and a good life cycle, it is critical to follow a proven proces…

    Wed Mar 31 18:04:01 - 0 Favorite
  • Processing Magazine

    Check out our new and improved corporate website for @EndeavorMedia. This site will serve as a tool to tell the sto… https://t.co/cHxl0Cu0Ik

    Wed Mar 31 14:09:03 - 2 Favorite
  • Processing Magazine

    Learn about the Opti Series of magnetic circuits in this Processing Industry Brief with @IMImagnets: “Magnetic Circ… https://t.co/xKu7yajNfg

    Tue Mar 30 20:46:02 - 0 Favorite
  • Processing Magazine

    Don’t miss tomorrow’s #webinar, “Industrial Data Digital Transformation: A Blueprint for Success,” with experts fro… https://t.co/RgqWuZMFDn

    Tue Mar 30 18:05:16 - 0 Favorite
  • Processing Magazine

    In this case study, a developer of systems for #pharmaceutical manufacturing and bioprocessing applications finds… https://t.co/IYwixM4DXV

    Tue Mar 30 15:47:08 - 2 Favorite
  • Processing Magazine

    RT @SEPCO: Via #SealConnect: Last year, @ProcessingMag Editor Jesse Osborne and SEPCO Regional Manager David Brewer discussed how to improv…

    Thu Mar 25 20:30:14 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: "Frontline #manufacturing workers want connected #digital tools, but many lack access." Learn more >> https:…

    Thu Mar 25 14:10:01 - 0 Favorite
  • Processing Magazine

    Join us March 31 in a live #webinar with experts from @dataPARCsolutio. You’ll learn step-by-step #digital… https://t.co/3AVaRRi4qV

    Wed Mar 24 18:05:04 - 1 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: #CaseStudy: #Chemical plant safety system features advanced #Coriolis #meters | https://t.co/pLYpzIQgS5 @krohnegroup ht…

    Wed Mar 24 13:43:01 - 0 Favorite
  • Processing Magazine

    See this Bulk Bag Discharging Project in action! Learn how to improve process performance & reduce total cost of ow… https://t.co/TsHW7b6jYV

    Tue Mar 23 17:58:05 - 0 Favorite
  • Processing Magazine

    3 signs it may be time to upgrade your programmable logic controllers (PLCs) | https://t.co/I97F87xZu0 https://t.co/AobeXqYRnv

    Mon Mar 22 18:21:04 - 4 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: Simplifying #temperature #measurement to deliver improved safety and increased productivity | https://t.co/K0h6AK982b h…

    Mon Mar 22 16:08:07 - 0 Favorite
  • Processing Magazine

    Taking the next step in #automation: Overcoming the challenges to automate #manufacturing | https://t.co/I97F87xZu0 https://t.co/3ohyhKyl3u

    Mon Mar 22 15:25:05 - 4 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: "To make sure #equipment ... has a good #ROI and a good life cycle, it is critical to follow a proven proces…

    Fri Mar 19 18:11:05 - 0 Favorite