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

    In the latest Movers & Shakers: New senior team members at Prescient, Orion Engineered Carbons… https://t.co/7OhRacaSss

    Tue Feb 25 20:51:40 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: #Coriolis #flowmeters help #Scotchwhisky producers meet strict regulations | https://t.co/awQmCqD1Y3 | @ABBMeasuremen

    Tue Feb 25 14:45:01 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: #Industrynews: Tuthill Corporation, Plastics Pipe Institute (@PPIplasticspipe) and Motion Industries (@MIMotionInd) an…

    Tue Feb 25 14:44:58 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: Developments in leak detection address challenges to reduce #methane emissions from #naturalgas | https://t.co/jdNwMC

    Mon Feb 24 17:28:55 - 0 Favorite
  • Processing Magazine

    Check out this article on the best practices to help reduce the risks to supply chain disruption.… https://t.co/Be8dXpWtOr

    Mon Feb 24 17:20:42 - 0 Favorite
  • Processing Magazine

    RT @WaterTechOnline: A three-phase separation system can separate solids from liquids, as well as fats, oils and grease from wastewater in…

    Fri Feb 21 17:26:58 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: To replace an inadequate #measurement approach, operators at a #drymilling facility add #GWR transmitters to unlock tr…

    Fri Feb 21 17:26:52 - 0 Favorite
  • Processing Magazine

    Check out this article from @Endress_Hauser about how vibronic point level instruments have evolved to diagnose the… https://t.co/trbxvhpVut

    Fri Feb 21 17:24:32 - 2 Favorite
  • Processing Magazine

    Check out this article from @InductiveAuto about a biochemical company that found a software that satisfies FDA req… https://t.co/lM5qeYcoWL

    Thu Feb 20 16:08:50 - 3 Favorite
  • Processing Magazine

    RT @SEPCO: Excited to share that our SEPCO Air Seal (SAS) is featured on the cover of the February issue of @ProcessingMag! Check out the d…

    Thu Feb 20 15:57:27 - 0 Favorite
  • Processing Magazine

    RT @PfannenbergUSA: The energy, maintenance and footprint associated with traditional #enclosurecooling units is often very high. If you're…

    Wed Feb 19 18:20:14 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: “Successful product containment and protection will only occur if the ideal seal technology is chosen. Other…

    Wed Feb 19 18:20:00 - 0 Favorite
  • Processing Magazine

    A process engineer with @fluorcanada explains how to identify risks and design mitigations for liquid overfill upse… https://t.co/OABRTnwwnF

    Wed Feb 19 18:15:51 - 3 Favorite
  • Processing Magazine

    Keith Staninger with @IRProducts discusses data, the IIoT and optimizing manufacturing https://t.co/NrKvUUQESn https://t.co/LiE2p6HXl1

    Tue Feb 18 21:23:10 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: Flow Control is accepting nominations for the 2020 Innovation Awards program. Submit your product here: https://t.co/m

    Tue Feb 18 16:44:59 - 0 Favorite
  • Processing Magazine

    RT @WaterTechOnline: RT @EPAwater: Approximately $1.6B in new federal grant funding is available for the Clean Water State Revolving Fund.…

    Mon Feb 17 19:36:36 - 0 Favorite
  • Processing Magazine

    RT @WaterTechOnline: A variety of #treatment technologies can be used to remove #suspendedsolids, sand and other impurities from #wastewate…

    Mon Feb 17 19:36:16 - 0 Favorite
  • Processing Magazine

    In the latest Company Briefs: LANXESS acquires biocide manufacturer, Hoffmann Neopac acquires hinged lid can produc… https://t.co/sC9dVGSYcp

    Mon Feb 17 19:35:43 - 0 Favorite
  • Processing Magazine

    The director of SonicCorp explains how inline multiple-feed, high-pressure homogenization offers an efficient and c… https://t.co/OEnSEDNwZP

    Mon Feb 17 15:01:48 - 0 Favorite
  • Processing Magazine

    From @thermalcare1: Three ways to reduce costs in your process cooling systems https://t.co/LDXOkw0dOs https://t.co/KPZMzkgmns

    Thu Feb 13 15:24:26 - 0 Favorite
  • Processing Magazine

    RT @APIenergy: Thanks in part to clean natural gas, the U.S. had the largest decline in CO2 emissions worldwide in 2019 even as the economy…

    Wed Feb 12 16:43:28 - 0 Favorite
  • Processing Magazine

    If you want to know how to avoid the top 10 heat exchanger mistakes, then you go to @HRSHeatEx. So that's what we d… https://t.co/rYOo39GNBZ

    Wed Feb 12 16:41:24 - 0 Favorite
  • Processing Magazine

    In the latest Movers & Shakers: LANXESS announces new head for subsidiary Saltigo, new CEO at Innophos Holdings… https://t.co/hQPYMof22r

    Tue Feb 11 19:51:41 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: Deploying #monitoring #sensors communicating via #wireless networks improves plant performance and #energy consumption…

    Tue Feb 11 19:12:36 - 0 Favorite
  • Processing Magazine

    The digital version of Processing's February is now available online. Click here to take a look: https://t.co/aQaLBxurYs

    Tue Feb 11 18:13:22 - 1 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: #QuizCorner: A DP transmitter, accuracy of ±0.05% of span calibrated in the shop & set for 0-100 DP units, to measure…

    Mon Feb 10 18:48:49 - 0 Favorite
  • Processing Magazine

    RT @WaterTechOnline: Landia Chopper Pump 'Chews' Knives at Waste-To-Energy Plant https://t.co/vfuivfIgQH

    Mon Feb 10 18:48:46 - 0 Favorite
  • Processing Magazine

    Check out this article from @apprentice_io about AR and AI applications in the pharmaceutical industry… https://t.co/iI5CtKdakP

    Mon Feb 10 18:48:14 - 1 Favorite
  • Processing Magazine

    RT @WaterTechOnline: RT @WaterWorld: The Weekly Newscast, these top #water and #wastewater stories: - @EPA @USArmy announce #WOTUS replacem…

    Fri Feb 07 17:20:12 - 0 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: #HVAC systems require proper flow management in #chemical, #pharmaceutical and #foodprocessing facilities | https://t.

    Fri Feb 07 17:12:10 - 0 Favorite