P6-A - FRS Development Work Process
1 Introduction
CTRL Designer LLC (CDL) is a leading provider of SBC state-based control (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:
| Phase | Software | Product |
|---|---|---|
| P1 | Industrial Plant Assessment™ (IPA) | 01-CDL-IPA-for-Quarto |
| P2 | Level of Automation (LoA) | [Service] |
| P3 | Operating Trends for Excel™ (OT) | 02-CDL-Tools-for-Excel |
| P5 | URS-to-FRS-Builder-for-Excel™ (URS) | 02-CDL-Tools-for-Excel |
| P6 | FRS-Engine-for-Excel™ (FRS) | 02-CDL-Tools-for-Excel |
| P7 | ACM-Engine-for-Excel™ (ACM) | 03-CDL-ACM-for-Excel |
| P4 | Standard Operating Procedure Analyzer™ (SOP) | 04-CDL-SOP-to-DCS-for-Excel |
1.1 CDL Folders
The CDL Package is constructed from the following Folders:
The top folder is called CDL-Product which contains
- Project
- Tools
1.1.1 Project Folder
The CDL Project folder contains:
- CDL-PmName-Project-YYYY
- PmName is the plant name such as VRT
- Project is Optional
- YYYY is the start year is is optional
- Example is CDL-VRT-2023
The Project folder contains:
- P1-IPA-Industrial-Plant-Assessment
- P2-LofA-Level-Of-Automation
- P3-OT-Operational-Trends
- P4-SOP-Standard-Operating-Procedure
- P5-URS-User-Requirement-Specification
- P6-FRS-Functional-Requirement-Specification
- P7-ACM-Automatic-Code-Maker
Each represent a PHASE of the project.
1.1.2 Tools Folder
The CDL Tools folder contains:
- A-Documentation
- B-Templates
- C-CM-CCM-Libraries
- D-Engines
- E-Issues
2 FRS Work Process
In this section the following items are reviewed:
- Select and Open an FRS file
- Opening the FRS Engine and CCM Database
- FRS File Worksheets
- FRS Commands
- FRS Work Process Tasks
2.1 Select and Open an FRS file
The following FRS files are available in
- Folder: CDL-VRT-20236-FRS-Functional-Requirement-Specification
- FRS files
- P6-CDL-FRS-03-UmT360-YN-v01a.xlsm
- P6-CDL-FRS-01-UmV340-YN-v01a.xlsm
- P6-CDL-FRS-02a-UmR350-YN-v01a.xlsm
- P6-CDL-FRS-02b-UmR350-2EM-YN-v01a.xlsm
- P6-CDL-FRS-02c-UmR350-EM-2EM-YN-v01a.xlsm
In this section, we will use P6-CDL-FRS-03-UmT360-YN-v01a.xlsm
Please do the following
- Select CDL-VRT-20236-FRS-Functional-Requirement-Specification folder
- Open P6-CDL-FRS-03-UmT360-YN-v01a.xlsm file
The above workbook is open:
2.2 Opening the FRS Engine and CCM Database
The program automatically wants to open the FRS Engine and CCM database files
The following information dialog opens
Click the OK button
Click the OK button
After the both files open you get the following dialog
Click the Yes button
2.3 FRS Commands
There are five commands set in the FRS Engine
2.3.1 A: Applies to sheets that start with A
| Sheet Name | Description |
|---|---|
| A1-Um-Desc | Um Process Description |
| A2-UM-Diagram | Process Diagram With Steps Color Coding |
| A4-Issues | Collection Of All Issues |
2.3.2 B: Applies to sheets that start with B
| Sheet Name | Description |
|---|---|
| B1-IO | Input-Output Instrumentation Database |
| B2-RootTags | Root-Tags To Ccm Allocation |
| B3-Calculation | Calculation |
| B4-Alarms | Calculation |
| B5-Code | Calculation |
2.3.3 C: Applies to sheets that start with C
| Sheet Name | Description |
|---|---|
| C1-ModeOfOperation | Mode Of Operation Definition |
| C2-Steps | Step Definitions |
| C3-Step-Diagram | Step Transition Matrix And Step Diagram |
| C4-Step-Transitions | Step Transition Definition |
| C5-CCM-Steps | Ccm To MofO And Steps |
| C6-Drawing | Ccm Drawing |
2.3.4 P: Applies to sheet C5-Code
| Sheet Name | Description |
|---|---|
| C7-Code | Code Development |
2.3.5 S: Applies to sheet {A3-SOP}
| Sheet Name | Description |
|---|---|
| A3-SOP | SOP Builder |
2.4 FRS Work Process Tasks
In this document the following Work Process is reviewed:
| Index | Description |
|---|---|
| Part 1 | Assign IO to CCM and CM |
| Part 2 | Mode of Operation, Steps and Transitions |
| Part 3 | Build CCM-Step Matrix |
| Part 4 | Review CCM-Step Matrix Dynamically |
| Part 5 | Review the pCode and Dictionary |
| Part 6 | Build and Modify DSS and SOP |
2.5 Part 1 – Assign IO to CCM and CM
Do the following Tasks where
- Index: Index of the task
- Description: brief summary of the task
- Sheet: the main worksheet the task is being executed
- Command: using CTRL + T keys this command should be selected
| Index | Description | Sheet | Command |
|---|---|---|---|
| 1.1 | Review IO and add Alarm limits and other information | B1-IO | |
| 1.2 | Review CM, CCM Lib and develop strategy for Root-Tag AO | Work | |
| 1.3 | Add calculation Tags in {B3-Calculation} or {5-Code} | B3-Calculation | |
| 1.4 | Review CM, CCM Lib and develop strategy for Root-Tag DO | Work | |
| 1.5 | Assign Root-Tag AO and Root-Tag DO to CCM Objects | B1-IO | [B1] List All Root-Tags |
| 1.6 | Assign Root-Tag associate Child-Tags to CCM or CM object | B2-RootTags | [B2] Add All CCM Child-Tags |
| 1.7 | Assign Additional IO to CCM or CM | B2-RootTags | [B3] Add Additional Tags |
2.6 Part 2 – Mode of Operation, Steps and Transitions
Do the following Tasks where
| Index | Description | Sheet | Command |
|---|---|---|---|
| 2.1 | Define the Mode of Operation (MofO) for Unit | C1-ModeOfOPeration | |
| 2.2 | Define Unit Steps | C2-Steps | |
| 2.3 | Build Step Interaction Matrix | C2-Steps | [C1] Build Step Matrix and Transitions |
| 2.4 | Fill M,A or A/M in Step Interaction Matrix | C3-Step-Diagram | |
| 2.5 | Generate Step Diagram, simulate and review with operation | C3-Step-Diagram | [C2] Generate Step Diagram |
| 2.6 | Add Transition pCode | C4-Step-Transitions |
2.7 Part 3 – Build CCM-Step Matrix
Do the following Tasks where
| Index | Description | Sheet | Command |
|---|---|---|---|
| 3.1 | Generate the DDS (D-Sheets) for all Root-Tags and Additional IO | B1-IO | [B4] Add CCM from Lib and Add Data |
| 3.2 | Add Alarm to CCM-Steps Matrix | C5-CCM-Steps | [C3] Add Alm Enable Logic | |
| 3.3 | Add Root-Tag CCM to CCM-Steps Matrix | C5-CCM-Steps | [C4] Add CCM Enable Logic | |
| 3.4 | Add E (Enable) or N (Not Enable) for Alarms and CCMs | C5-CCM-Steps | |
| 3.5 | Color Code the CCM-Steps Matrix | C5-CCM-Steps | [C5] Color Code |
2.8 Part 4 – Review CCM-Step Matrix Dynamically
Do the following Tasks
| Index | Description | Sheet | Command |
|---|---|---|---|
| 4.1 | Generate URL Objects | A2-UM-Diagram | [B9] Generate URL Objects |
| 4.2 | Develop the background graphic | A2-UM-Diagram | |
| 4.3 | Copy the Object from {URL_Objects} | A2-UM-Diagram | |
| 4.4 | Paste them and place them in the right position | A2-UM-Diagram | |
| 4.5 | Link the Objects to CCM-Step Matrix {C5-CCM-Steps} | A2-UM-Diagram | [A2] Build URL Link Sheet |
| 4.6 | Turn Objects Name ON or OFF | A2-UM-Diagram | [A1] Add Remove CM Name |
| 4.7 | Test the Objects in all Steps for their performance | A2-UM-Diagram | [N] Next or [L] Last |
| 4.8 | Correct E and N and Repeat Tasks 4.5 to 4.7 | C5-CCM-Steps | |
| 4.9 | Build Presentation PDF and review with operation | A2-UM-Diagram | [A3] Build Presentation |
2.9 Part 5 – Review the pCode and Dictionary
Do the following Tasks
| Index | Description | Sheet | Command |
|---|---|---|---|
| 5.1 | Copy all pCode | C7-Code | [P1] Cleanup {C7-Code} and pCode from Sheets |
| 5.2 | Consolidate pCode | C7-Code | [P2] Consolidate multiple lines into one line {C7-Code} |
| 5.3 | Build Dictionary | C7-Code | [P3] Build Dictionary of unique pCode and Code {C7-Code} |
| 5.4 | Add the pCode to Code Dictionary | C7-Code | |
| 5.5 | Replace Dictionary Definition | C7-Code | [P4] Replace pCode with Code from Dictionary >> Code {C7-Code} |
| 5.6 | Replace Code to Transitions and CCMs sheet | C7-Code | [P5] Copy {C7-Code} pCode and Code to {TR |
| 5.7 | Backup the Code Sheet | C7-Code | [P6] Copy {C7-Code} to {C7-Code-BCK} |
2.10 Part 6 – Build and Modify DSS and SOP
Do the following Tasks
| Index | Description | Sheet | Command |
|---|---|---|---|
| 6.01 | Initialize the Standard Operating Procedure (SOP) sheet | A3-SOP | [S1] Initialize {A2-Sop} sheet from {B1-IO} |
| 6.02 | Review and Adjust SOP | A3-SOP | |
| 6.03 | Copy SOP actions and parameters to CCM-Step Matrix | A3-SOP | [S2] Convert {A3-SOP} to {C5-CCM-Steps} Matrix |
| 6.04 | Review and Modify CCM-Step Matrix | C5-CCM-Steps | |
| 6.05 | Compare CCM-Step Matrix with SOP | A3-SOP | [S3] Compare {C5-CCM-Steps} Matrix to {A3-SOP} IN {Temp} |
| 6.06 | Add Enable Logic To All D-Sheets | C5-CCM-Steps | [C6] Add Enable Logic to All D-Sheets |
| 6.07 | Generate CCM and CM Drawing | C5-CCM-Steps | [C7] Draw all CCM in [C7-Drawing] |
| 6.08 | Save the Report and all CMM and CM sheets | B1-IO | |
| 6.09 | Generate FRS Report | B1-IO | [BR] Generate FRS Word Report |
| 6.1 | Export SOP to Word | A3-SOP | [S4] Export SOP to Word |
| 6.11 | Import and Compare SOP from Excel | A3-SOP | [S5] Import SOP from Excel |
Please contact us if you need more information.