Operational Trend for Excel- Guided Tour
1 Introduction
CTRL Designer LLC (CDL) is a leading provider of state-based control (SBC) (procedural control) based on ISA106 solutions to the process industries.
Its software portfolio and work processes help process control engineers develop an overall process control design and convert it automatically to the selected control system code. These solutions allow users to make smarter decisions to improve safety, reliability, efficiency, and sustainability.
The products are divided into phases:
- P1- Industrial Plant Assessment™ (IPA)
- P2- Level of Automation (LoA) [Service]
- P3- Operating Trends for Excel™ (OT)
- P4- Standard Operating Procedure Analyzer™ (SOP)
- P5-URS-to-FRS-Builder-for-Excel™ (URS)
- P6-FRS-Engine-for-Excel™ (FRS)
- P7-ACM-Engine-for-Excel™ (ACM)
The P3- Operating Trends for Excel™ (OT) is reviewed in this section.
2 P3-OT-Operational-Trends (OT)
As it is shown above, the P3-OT-Operational-Trends (OT) tool is used to develop:
Develop OT for the Plant and its associated Units
Develop OT for a selected Unit and its Equipments (Pump, Reboiler), Controllers, and Digital Outputs (Agitator, Block Valves).
The SOP document is used to develop OT. Standard Operating Procedure SOP normally written in a sequential format to communicate the operator’s activities.
The SBC will automate the majority of these activities and it is CRITICAL to review the SOP with operation before the development of URS or FRS to make sure the proposed SOP is implemented using SBC.
In this document the following is presented:
- Guided Tour of a Plant Operational Trend
- Guided Tout of a Unit Operational Trend
- Step by Step How to develop OT
3 Guided Tour of a Plant Operational Trend
3.1 Purpose
The purpose of this section is to demonstrate a simple plant OT example
The design team provided us with a narrative fo the operation of this plant.
The objective of OT is to deliver the following:
Divide the plant to units
To review with operation
- Visualization of Plant operation in time (Trends)
- Visualization of Unit to Unit interaction in time (Dynamic)
- Mode of Operation for the Plant PM and each of its associated Units
- Steps for Plant PM
For URS engine
- Trends
- Dynamic
- Plant PM Mode of Operation
- Plant PM Steps
- Each Unit UM Mode of Operation
3.2 Inputs
For this example (P3-OT-01-PM-RX-DIST-CDL.xlsx) we had received narrative from the design team.
This example is strored in the
Folder: P3-OT-Operational-Trends
File OT-03-Examples\P3-OT-01-PM-RX-DIST-CDL.xlsx
- Start-up
- Open the Feed to RX 8000 Wait until RX level is 75%
- Run the RX until Temperature reaches 450 Deg C
- Open Feed to Distillation 8000
- Reduce feed to RX to 3000
- Open Distillate to RX 5000 Recycle to Reactor
- Open Bottom Product 3000
- Run
- Shut-Down
- Cut Feed and run distillation until the RX and Distillation levels are low 0 Prepare for shutdown
- Cut the Distillate and Bottom flow
- Cut Feed to Reactor
3.3 Tasks
3.3.1 Identify the Units
Based on the plant flow diagram and narrative the following units are identified.
- RX: Reactor
- DIST: Distillation
The plant flow diagram is shown below
3.3.2 Develop CDL Narrative
Based on the narrative provide above the following MV and CV are defined for the Reactor (RX) and Distillation (DIST)
| Index | Tag | Range |
|---|---|---|
| 1 | MV1-RX Feed | 10000 |
| 2 | MV2-Dist Feed | 10000 |
| 3 | MV3- Top Product | 10000 |
| 4 | MV4- BTM Product | 10000 |
| 5 | CV1 - RX Level | 100 |
The following CDL narrative is defined
| Index | Narrative |
|---|---|
| 1 | Ramp the Feed to RX Unit (MV1-RX Feed) to 8000 Wait until RX Unit level (CV1 - RX Level) is 75% |
| 3 | Ramp the Feed (MV2-Dist Feed) to Distillation 8000 |
| 4 | Reduce feed (MV1-RX Feed) to RX to 3000 |
| 5 | Ramp Distillate feed (MV3- Top Product) to RX 5000 Recycle to Reactor |
| 6 | Ramp Bottom Product (MV4- BTM Product) to 3000 |
| 7 | Run both RX and Dist Unit |
| 8 | Ramp Feed (MV1-RX Feed) to zero until the RX Level (CV1 - RX Level) reaches 10% |
| 9 | Ramp the (MV3- Top Product) and (MV4- BTM Product) to zero |
Based on CDL OT Rules the following User MCD matrix is developed
Entering the value for each MV and CV yields to:
The command is followed by | and its value. This is stored in {User-MCD-Tasks} sheet.
3.3.3 Review Trends
The trends are displayed below:
3.3.4 Review The Mode Of Operation
The MofO are displayed below:
3.3.5 Dynamic
The Dynamic are displayed below:
3.4 Example 2 : Plant - Distillation - Reactor - 2-Distillations
This example is strored in the
Folder: P3-OT-Operational-Trends
File OT-03-Examples\P3-OT-05-PmDRTT-CDL.xlsx
3.4.1 Dynamic
This example dynamic diagram is shown below
3.4.2 Trends
This example trends is shown below
3.4.3 Mode of Operation
The mode of operation for the Plant and its unitsare shown below
3.5 Example 3 : Plant - Distillation - Reactor - 2Distillations
3.5.1 Dynamic
This example dynamic diagram is shown below
3.5.2 Trends
This example trends is shown below
4 Guided Tour of a Unit Operational Trend
4.1 Example 1 : UmV340
This example is stored in the
Folder: P3-OT-Operational-Trends
File OT-03-Examples3-OT-02-UmV340-CDL.xlsx
4.1.1 Dynamic
This example dynamic diagram is shown below
4.1.2 Trends
This example trends is shown below
4.1.3 Mode of Operation
The mode of operation for the Plant and its units are shown above
4.2 Example 2 : UmR350
This example is stored in the
Folder: P3-OT-Operational-Trends
File OT-03-Examples3-OT-03-UmR350-CDL.xlsx
4.2.1 Dynamic
This example dynamic diagram is shown below
4.2.2 Trends
This example trends is shown below
4.2.3 Mode of Operation
The mode of operation for the Plant and its units are shown below
4.3 Example 3 : UmT360
Folder: P3-OT-Operational-Trends
File OT-03-Examples3-OT-04-UmT360.xlsx.xlsx
4.3.1 Dynamic
This example dynamic diagram is shown below
4.3.2 Trends
This example trends is shown below
4.3.3 Mode of Operation
The mode of operation for the Plant and its unitsare shown below
5 Welcome
5.1 Before You Begin
Welcome to the Operational Trend for Excel product from the Ctrl Designer LLC (CDL) company. Whether you are brand new to CDL products or are an experienced user getting your first taste of Operational Trend for Excel, we want your experience to be a good one. Please do the following:
Follow the directions in the Installation Procedure to install your new software; and Once your software is installed, turn to the Quick Tour chapter to learn more about the software.
At any time you can review the PowerPoint or the Video of this product.
5.2 Microsoft Excel Version
The Operational Trend for Excel version 100a is developed for Microsoft Excel 2016 or newer versions only for Windows.
5.3 Send Us Your Feedback
We welcome your feedback. Let us know how Operational Trend for Excel has helped you gain expertise in creating custom solutions. You can reach us in any of the following ways.
- Web site: www.CtrlDesigner.com
- E-Mail: info@CtrlDesigner.com
Note that we regularly receive suggestions and comments regarding CDL products and are unable to respond directly to each one. However, please be assured that your recommendations, ideas, and remarks will be recorded and will help shape future versions of our products.
Please ensure you send us a copy of the screen with the problem. Press the PRINT SCREEN PrtScn key to capture the current window onto the clipboard, then paste the captured screen in e-mail to send to us.