P6-D Build CCM Step Interaction Matrix
1 Build CCM-Step-Interaction-Matrix
The following file is used in this documentation:
- folder: Projects>>CDL-VRT-2023>>P6-FRS-Functional-Requirement-Specification
- file: P6-CDL-FRS-01-UmV340-YN-v01a.xlsm
FRS work process is divided into six parts:
| Index | Description |
|---|---|
| Part 1 | Assign IO to CCM and CM |
| Part 2 | Mode of Operation, Steps and Transitions |
| Part 3 | Build CCM-Step-Interaction-Matrix |
| Part 4 | Review Build CCM-Step-Interaction-Matrix Dynamically |
| Part 5 | Review the pCode and Dictionary |
| Part 6 | Build and Modify DSS and SOP |
In this section the Part 3 - Build CCM-Step-Interaction-Matrix is documented.
1.1 Tasks Summary
The following worksheets in the FRS workbook are reviewed and explained:
- {B1-IO}
- {C5-CCM-Steps}
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 | Manually |
| 3.5 | Color Code the CCM-Steps Matrix | C5-CCM-Steps | [C5] Color Code |
1.2 Generate the DDS (D-Sheets) for all Root-Tags and Additional IO
Purpose: The purpose of this task is to generate the DDS sheets for this UM.
To Do: Do the following tasks:
- Select the {B1-IO} worksheet
- Press CTRL + T keys then click option B7 to delete all D sheets
- Click the Yes button
- Press CTRL + T keys then click option B4 to generate all D sheets
- Select the {ToDo} worksheet
- Review the list of D Sheets at row 50
These sheet are organized per CCM or CM models. For example CCmBlockDo is used 5 times.
- Click on D1 link
- In {D_CCmBlockDo} worksheet
- Turn filter on
- In column 12 - remove blanks
- Review the data
1.3 Add Alarm to CCM-Steps Matrix
Purpose: The purpose of this task is to add alarms to the CCM-Steps Matrix for this UM. In SBC the alarms are enable and disabled per active step.
To Do: Do the following tasks:
Select the {C5-CCM-Steps} worksheet
If there is data in the worksheet please do the following
- Press CTRL + T keys then click option C8 >> 1 [B] Backup ..
- This will copy the {C5-CCM-Steps} worksheet to {C5-CCM-Steps-BCK} worksheet
- Then in future with C8 >> [R] Restore .. we can restore the data
- Then select Row 2 to the end and clear it
Press CTRL + T keys then click option [C3] Add Alm Enable Logic
Review the {C5-CCM-Steps} worksheet
Columns 1 to 9 provide the alarm information for each defined alarms
Column 10 to 15 shows the list of steps
The definition of the columns are shown below
| N | Column | Description |
|---|---|---|
| 1 | Status | Status Used to copy to and from C5-CCM-Steps-BCK |
| 2 | [A1] Category | Type of CCM Alarm or CCM |
| 3 | [A2] CCM-Gen-Name | Generic Name from {B1-IO} |
| 4 | [A3] CCM-Element-Name | CCM Element Name Copied from {B1-IO} |
| 5 | [A4] Tag-Name | Tag Name for IO from TagName or for Cntl from Cntl Name |
| 6 | [A5] Tag-Description | Description |
| 7 | [A6] Cross-Reference | Cross-reference |
| 8 | [A7] CCm-Address | Cross-Reference to D-Sheets |
| 9 | [A8] Type | Type For alarm - Type of alarm or For CCM - CCM |
1.4 Add CCM to CCM-Steps Matrix
Purpose: The purpose of this task is to add CCM to the CCM-Steps Matrix for this UM.
To Do: Do the following tasks:
Select the {C5-CCM-Steps} worksheet
Press CTRL + T keys then click option [C4] Add CCM Enable Logic
Review {C5-CCM-Steps} worksheet
- Note that all CCM are added and the alarms and CCM are sorted together.
1.5 Add E (Enable) or N (Not Enable) for Alarms and CCMs
Purpose: The purpose of this task is to add E or N to the CCM-Steps Matrix for this UM.
In the Operating Trend for this unit, we defined Enable and Not Enable (or Disable) for each AO or DO.
So, that information needs to be transformed to this sheet.
To Do: Do the following tasks:
- Select the {C5-CCM-Steps} worksheet
- In columns 10 to 15 add the following
E: Enabled
N: Not Enabled
Or
C: Closed (Not Enabled)
O: Open (Enabled)
M: Manual (Not Enabled)
A: Automatic (Enabled)
S: Stop (Not Enabled)
R: Run (Enabled)
1.6 Color Code the CCM-Steps Matrix
Purpose: The purpose of this task is to color code the CCM-Steps Matrix for this UM.
To Do: Do the following tasks:
- Select the {C5-CCM-Steps} worksheet
- Press CTRL + T keys then click option B7 to delete all D sheets
To Do: Do the following tasks:
- Select the {C5-CCM-Steps} worksheet
- Press CTRL + T keys then click option B7 to delete all D sheets
- The color coding enable the pattern of E for the SBC.
Please contact us if you need more information.