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

    Call for Speakers: The Manufacturing & Technology team invites #manufacturing professionals to submit speaking prop… https://t.co/DqvBjGbQsM

    Thu Jan 21 18:25:08 - 0 Favorite
  • Processing Magazine

    In this Industry Brief, @SEPCO's David Brewer discusses how an air seal system is beneficial when #sealing slurries… https://t.co/s47JSzfyPt

    Thu Jan 21 13:47:01 - 2 Favorite
  • Processing Magazine

    Considerations for selecting the right mixing and blending equipment for #foodandbeverage, #pharmaceutical and… https://t.co/ffQP1Y6GxP

    Wed Jan 20 19:16:03 - 1 Favorite
  • Processing Magazine

    Design considerations and modifications for #industrial #mixing equipment in harsh applications |… https://t.co/J5WSvAITFH

    Wed Jan 20 15:02:03 - 1 Favorite
  • Processing Magazine

    In this Industry Brief, @BlueWhiteInd's Rob Gledhill recaps 2020, gives viewers insight into the company's mission… https://t.co/RQIwJMWaTl

    Tue Jan 19 13:25:02 - 0 Favorite
  • Processing Magazine

    Four technology strategies every process #manufacturer should consider in a post-pandemic world |… https://t.co/zUtSpTh0vK

    Mon Jan 18 13:57:05 - 3 Favorite
  • Processing Magazine

    In this Industry Brief, @SEPCO's David Brewer discusses how an air seal system is beneficial when #sealing slurries… https://t.co/nY0CTohSea

    Fri Jan 15 17:47:07 - 1 Favorite
  • Processing Magazine

    In this Industry Brief, @BlueWhiteInd's Rob Gledhill recaps 2020, gives viewers insight into the company's mission… https://t.co/Nx4bZn0sTC

    Thu Jan 14 15:33:02 - 0 Favorite
  • Processing Magazine

    4 ways to reduce #COVID19 risk in your #foodprocessing facility | https://t.co/ApGNUvhkl3 @StellarGroupInc https://t.co/Cr5HFa9UI7

    Tue Jan 12 14:05:04 - 1 Favorite
  • Processing Magazine

    Processing connected with @AspenTech's Paige Marie Morse to discuss the importance of #digitalization, particularly… https://t.co/7crcpzfBqE

    Mon Jan 11 20:09:11 - 4 Favorite
  • Processing Magazine

    Solving the challenge of unifying goals at all company levels: Production personnel should and can be aiming at sus… https://t.co/ITPfASWcZC

    Fri Jan 08 16:05:10 - 2 Favorite
  • Processing Magazine

    While globe control valves are still a viable solution, modern rotary #controlvalves offer many advantages and serv… https://t.co/gjZ3dJH1nR

    Thu Jan 07 13:40:02 - 2 Favorite
  • Processing Magazine

    In this Industry Brief, @BlueWhiteInd's Rob Gledhill recaps 2020, gives viewers insight into the company's mission… https://t.co/KnZIeSmv71

    Wed Jan 06 17:32:02 - 0 Favorite
  • Processing Magazine

    Read how tailor-made #IIoT monitoring solutions for specific assets can be valuable and sustainable when added to c… https://t.co/3tS2jEnfpz

    Tue Jan 05 14:05:03 - 0 Favorite
  • Processing Magazine

    Congratulations to Processing's 2020 Breakthrough Products Awards winners | https://t.co/7gzApixF9A https://t.co/nCX7AIvXJ8

    Mon Jan 04 23:18:44 - 2 Favorite
  • Processing Magazine

    Industry Brief: Collins McGeorge of @IMImagnets discusses the Opti Series | https://t.co/ttTI0D2uwv

    Tue Dec 29 13:55:01 - 1 Favorite
  • Processing Magazine

    Off-grid #automation platforms support any type of remote monitoring and control application, regardless of whether… https://t.co/4VfY7TgCmo

    Mon Dec 28 14:25:02 - 2 Favorite
  • Processing Magazine

    To be sure equipment such as a conveyor has a good return on investment and a good life cycle, it is critical to fo… https://t.co/BnZMUSKuml

    Wed Dec 23 14:05:03 - 1 Favorite
  • Processing Magazine

    Digital transformation: Realize operational benefits while minimizing risks | https://t.co/xivdG2QWpt @rockautomation

    Tue Dec 22 21:05:02 - 1 Favorite
  • Processing Magazine

    In this Industry Brief, Collins McGeorge of @IMImagnets discusses the Opti Series | https://t.co/ttTI0D2uwv https://t.co/ZbFynWrmES

    Tue Dec 22 18:41:32 - 1 Favorite
  • Processing Magazine

    Metal detection specialist #FortressTechnology examines the different factors that are accelerating the need for sm… https://t.co/fM1bhCF3sT

    Fri Dec 11 20:29:02 - 1 Favorite
  • Processing Magazine

    In this Industry Brief, Collins McGeorge of @IMImagnets discusses the Opti Series | https://t.co/ttTI0D2uwv https://t.co/fhrGhfRfqg

    Fri Dec 11 18:09:55 - 0 Favorite
  • Processing Magazine

    Stuffing box reliability is the topic of discussion for the latest Processing Industry Brief |… https://t.co/FpeYUaM8k5

    Tue Dec 01 21:25:30 - 1 Favorite
  • Processing Magazine

    Finishing a major project on time and on budget could potentially depend on putting the best digital tools in the h… https://t.co/ao2M67noCA

    Tue Nov 24 14:50:05 - 1 Favorite
  • Processing Magazine

    RT @FlowControl_Mag: An expanded view of #flowcontrol: The interaction between flow control and pressure control can create new process met…

    Mon Nov 23 19:05:06 - 0 Favorite
  • Processing Magazine

    Process #manufacturers realize that to persevere and build more resiliency for the future, they’ll need the ability… https://t.co/eSlCnbh3Sd

    Mon Nov 23 13:36:02 - 3 Favorite
  • Processing Magazine

    2021 Offshore Technology Conference postponed to August | https://t.co/ngdKd0DtlB @OTCevents https://t.co/zyjKoEdcTl

    Fri Nov 20 21:05:04 - 0 Favorite
  • Processing Magazine

    Tubular cable conveyors can significantly reduce product damage, energy use, noise and maintenance. #Cablevey… https://t.co/zfkhDciqXl

    Fri Nov 20 17:23:04 - 1 Favorite
  • Processing Magazine

    Effective collaboration among far-flung and even local facilities depends on #digital tools to gather data and conn… https://t.co/1a2VeiKsMr

    Fri Nov 20 13:17:02 - 1 Favorite
  • Processing Magazine

    SOCMA reschedules Specialty & Custom Chemicals Show to April 14-16, 2021 | https://t.co/LbCjB5nPeV @socma https://t.co/s0QPf0pz1F

    Thu Nov 19 22:55:05 - 1 Favorite