Why Excel Datasheets for your Plant?

The use of automated Excel based datasheets in the process industry

In today’s high technology world, some of the most important facets of the modern process facility are being maintained by their owners with outdated paper systems that offer little to the overall control of the configuration. A low-cost solution is now available to get on the fast track to automated datasheets.

The essentiality of process-safety management

Loss of life in the workplace is a tragedy of enormous proportion. One of the tools the Occupational Safety and Health Administration (OSHA) uses to eliminate workplace disasters is the Process Safety Management (PSM) standard issued in 1992. Questions have arisen about whether the standard is sufficient and whether it should be amended. The Chemical Safety and Hazard Investigation Board (CSB) says revision is necessary, but OSHA disagrees.

Shortly after OSHA proposed the PSM standard, the Clean Air Act Amendments (CAAA) were enacted on Nov. 15, 1990. CAA Section 304 requires OSHA to issue a chemical process safety standard to prevent accidental releases of chemicals, which must include a list of chemicals deemed to be highly hazardous chemicals, defined to include toxic, flammable, highly reactive and explosive substances, and specified minimum elements that the OSHA standard required employers to do.

The PSM standard applies to processes containing more than a threshold quantity of any of 137 OSHA-listed chemicals. Coverage is triggered by use of more than a threshold quantity of any chemical listed as being highly hazardous. Some of the minimum elements of the standard require that employers:

• Develop and maintain written safety information identifying workplace chemical and process hazards, equipment used in the processes and technology used in the processes.

• Perform a workplace hazard assessment, including as appropriate, identification of potential sources of accidental releases, identification of any previous release within the facility that had a potential for catastrophic consequences in the workplace, estimation of workplace effects of a range of releases, and estimation of the health and safety effects of such a range on employees.

• Consult with employees and their representatives on the development and conduct of hazard assessments and the development of chemical accident prevention plans and provide access to these and other records required under the standard.

• Establish a system to respond to the workplace hazard assessment findings, which shall address prevention, mitigation and emergency responses.

• Provide written safety and operating information for employees and contract employees and train them in operating procedures by emphasizing hazards and safe practices that must be developed and made available.

• Train and educate all employees and contractors in emergency-response procedures in a manner as comprehensive and effective as that required by the regulation promulgated pursuant to Section 126(d) of the Superfund Amendments and Reauthorization Act.

• Establish a quality assurance program to ensure initial process-related equipment, maintenance materials, and spare parts are fabricated and installed consistent with design specifications;

• Conduct pre-startup safety reviews of all newly installed or modified equipment;

Of critical importance to the success of any PSM plan is the process hazard analysis (PHA). This element consists of a disciplined review of what could go wrong in the workplace, and what measures should be implemented to prevent the kinds of releases that could invite disasters. Employers must update and revalidate their PHAs at least every five years.

OSHA has promoted a voluntary program of enhanced education and outreach efforts to broaden awareness about the hazards posed by reactive chemicals. The enhanced awareness is based on a CSB 2002 on reactive chemical hazards. The CSB recommended that OSHA revise the PSM standard to control reactive chemical hazards that could have catastrophic consequences and to implement a program to define and record information on reactive incidents. OSHA has declined to pursue CSB’s recommendations. OSHA has instead steadfastly maintained that voluntary measures undertaken by industry and OSHA, largely consisting of enhanced education and outreach to broaden awareness of workplace safety hazards, particularly as they relate to reactive chemicals, are all that are necessary. CSB has stated that it believes such efforts are inadequate; however, change to the PSM is not expected anytime soon.

Employers and employees alike must be ever mindful of the unique hazards posed by reactive chemicals, as well as the hazards posed by release of the chemicals the PSM standard was intended to address. Loss of life in the workplace is always tragic, and almost always preventable. 

How does the above equate to Excel formatted equipment datasheets?

1. Automated datasheets makes it substantially easier to maintain a one-for-one relationship to the physical device and the documentation. Automated data sheets can be maintained on a process/tag number basis or by device function

2. The process for testing, by-pass, maintenance, replacement, and the training of operators can be further optimized.

3. Each entry on the datasheet index can be referenced to a unit plot plan for physical location requirements.

4. Automated datasheets can make it easier to conduct accident investigations.

5. The hazard assessment process can be further enhanced when automated datasheets are used.

6. When the electronic datasheet is tied to the P&ID update process and all other process/construction documentation, the overall system promotes lifecycle configuration control.  


Why spend time designing all of your datasheets from scratch? 

Professionally designed datasheets in friendly Excel format that you may modify to suit your needs. Summarize the performance and technical characteristics of equipment and components in sufficient detail to be used by a design engineer for system integration. Specify typical values, ranges, tolerances, and nominal values.

Processing Tweets

  • Processing Magazine

    What is your #maintenance program? Ignoring maintenance or only fixing things when they fail (a reactive approach),… https://t.co/Io2ohTGThe

    Tue May 11 17:34:04 - 2 Favorite
  • Processing Magazine

    Automating #valves for system integration: An overview of the pneumatic #actuators, controls and feedback devices t… https://t.co/OCBlimUnM4

    Mon May 10 17:58:04 - 0 Favorite
  • Processing Magazine

    Enhanced anti-surge protection with engineered flow deadband | https://t.co/kensvef14R @EMR_Automation https://t.co/xc5Gzai6lo

    Thu May 06 16:21:02 - 0 Favorite
  • Processing Magazine

    #Digital #transformation for 1,000 oil and #naturalgas wells: Modern technologies enable a fast, stress-free transi… https://t.co/yUyTs5XFap

    Tue May 04 17:27:04 - 1 Favorite
  • Processing Magazine

    Nominations are open for the 2021 #BreakthroughProductsAwards. Submit your nomination by September 30 |… https://t.co/jxFCrOwIp5

    Mon May 03 18:19:04 - 0 Favorite
  • Processing Magazine

    A processor adapts advanced analytics to improve operations #digital #manufacturing | https://t.co/AdGNVjkejfhttps://t.co/xPBhNKqFiC

    Fri Apr 30 17:06:09 - 1 Favorite
  • Processing Magazine

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

    Thu Apr 29 20:57:06 - 0 Favorite
  • Processing Magazine

    RT @Samotics: Fresh from the Samotics “must-read” list 📃, the top 5 #pump design, setup & #maintenance misconceptions uncovered by pump exp…

    Wed Apr 28 21:47:01 - 0 Favorite
  • Processing Magazine

    Understanding the correct material selection process, #valve performance and design considerations, and actuation o… https://t.co/6ugNK0f5Qc

    Wed Apr 28 18:06:04 - 0 Favorite
  • Processing Magazine

    The EASA 2021 Convention + Solutions Expo is heading to Fort Worth, Texas, June 27-29! Check out the program, floor… https://t.co/pQKCsXJbYy

    Wed Apr 28 17:05:09 - 0 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: Critical #measurements and best practices for future-proofing the #refining industry | https://t.co/Jx62NNvaUR #oilandg…

    Wed Apr 28 13:52:01 - 0 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: In this Industry Brief video, SIKA's OEM manager for flow products and instrumentation explains how the new technology…

    Tue Apr 27 20:05:03 - 0 Favorite
  • Processing Magazine

    RT @SAPChemicals: Did you know that #chemical companies can create value at scale by tapping into new markets and providing seamless custom…

    Tue Apr 27 17:34:04 - 0 Favorite
  • Processing Magazine

    Not all #valves are equal: Picking the right material for the job | https://t.co/aINt1PSQCd https://t.co/sEt4dsDgJH

    Tue Apr 27 17:27:04 - 0 Favorite
  • Processing Magazine

    5 factors that impact the lifespan of ball #valves | https://t.co/vagRFXJ0r0 https://t.co/au4MgqHOIK

    Mon Apr 26 18:19:04 - 1 Favorite
  • Processing Magazine

    Nominations are open for the 2021 #BreakthroughProductsAwards. Submit your nomination by September 30 |… https://t.co/8jFSvqU71t

    Fri Apr 23 17:05:19 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: "SEPCO's David Brewer discusses seal #technology solutions for #foodandbeverage processing environments in t…

    Fri Apr 23 13:05:01 - 0 Favorite
  • Processing Magazine

    The evolving and growing value of #asset #management: New digital tools make asset management programs far more cap… https://t.co/x2n48uokUR

    Thu Apr 22 21:28:05 - 1 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: #Multiphase #flowmeter software is taking resolution and #automation to new heights | https://t.co/A4NkqTvQoq @EMR_Auto

    Thu Apr 22 20:33:07 - 0 Favorite
  • Processing Magazine

    RT @PaulEntin: Here's #howto remove ignition sources to avoid #combustible dust events https://t.co/8H0RJflNvY @ProcessingMag #b2b #Wednesd…

    Wed Apr 21 18:05:05 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Find out how #airseals work in this article via @ProcessingMag >> https://t.co/zMP9gxRCfo. https://t.co/B5O8Qqa0un

    Wed Apr 21 17:09:06 - 0 Favorite
  • Processing Magazine

    In this case study, a #petrochemical plant improves visibility, sustainability and worker safety with industrial… https://t.co/mlHf7wAruU

    Tue Apr 20 17:29:04 - 1 Favorite
  • Processing Magazine

    RT @PI_ProcessInst: Hose core tube materials can make or break your application, providing long service lives or creating system problems |…

    Tue Apr 20 14:47:02 - 0 Favorite
  • Processing Magazine

    How the #petrochemical industry can future-proof its activities by looking back to a long-established but underused… https://t.co/rQnhy011Wj

    Mon Apr 19 18:02:08 - 0 Favorite
  • Processing Magazine

    RT @SEPCO: Via @ProcessingMag: "Off-grid #automation platforms support any type of #remotemonitoring and control application, regardless of…

    Mon Apr 19 13:47:01 - 0 Favorite
  • 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 - 7 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