Part 3 – Build CCM Step Interaction Matrix

P6 - Part 3 Build CCM Step Interaction Matrix
Author

CTRL Designer LLC

Published

2024.02.01

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:

  1. Select the {B1-IO} worksheet
  2. Press CTRL + T keys then click option B7 to delete all D sheets

  • Click the Yes button
  1. Press CTRL + T keys then click option B4 to generate all D sheets
  2. Select the {ToDo} worksheet
  3. 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.

  1. Click on D1 link
  2. In {D_CCmBlockDo} worksheet
  3. Turn filter on
  4. In column 12 - remove blanks
  5. 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:

  1. Select the {C5-CCM-Steps} worksheet

  2. 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

  3. Press CTRL + T keys then click option [C3] Add Alm Enable Logic

  4. 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:

  1. Select the {C5-CCM-Steps} worksheet

  2. Press CTRL + T keys then click option [C4] Add CCM Enable Logic

  3. 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:

  1. Select the {C5-CCM-Steps} worksheet
  2. 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:

  1. Select the {C5-CCM-Steps} worksheet
  2. Press CTRL + T keys then click option B7 to delete all D sheets

To Do: Do the following tasks:

  1. Select the {C5-CCM-Steps} worksheet
  2. Press CTRL + T keys then click option B7 to delete all D sheets

  1. The color coding enable the pattern of E for the SBC.