P6-F Review the pCode and Dictionary

Author

CTRL Designer LLC

Published

2024.10.04

1 Review the pCode and Dictionary

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 4 - Review Build CCM-Step-Interaction-Matrix Dynamically 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

N Task Sheet
5.01 Copy all pCode C7-Code
5.02 Consolidate pCode C7-Code
5.03 Build Dictionary C7-Code
5.04 Add the pCode to Code Dictionary C7-Code
5.05 Replace Dictionary Definition C7-Code
5.06 Replace Code to Transitions and CCMs sheet C7-Code
5.07 Backup the Code Sheet C7-Code
5.08 Review with operation

These commands can be access using CTRL + Shift + T

1.2 Copy all pCode

Purpose: The purpose of this task is to collect all pCode from selected sheets to this sheet.

To Do: Do the following tasks:

  1. Select the {C7-Code} worksheet
  2. This will erase {C7-Code} so take a backup if you need this data
  3. Click the [P1] Cleanup {C7-Code} and pCode from Sheets button

The following code is extracted:

Sheet {C4-Step-Transitions}

  • (Level < 5 OR Level > 95 OR PumpPower > 25) OR UmV340_RUN_SD__Oper
  • (Level > 50) OR (Level < 90) OR UmV340_FILL_SD__Oper
  • (Level > 75 OR UmV340_FILL_RCYL__Timer > 300)
  • [ALL_DO] and [ALL_DI = False] and [ALL_AO =“MAN”] And [ALL_CNTL =“MAN”] AND UmV340_MW_PW__Oper
  • [ALL_DO] and [ALL_DI = False] and [ALL_AO =“MAN”] And [ALL_CNTL =“MAN”] AND UmV340_SD_PW__Oper
  • Level > 95 OR UmV340_FILL_RCYL__Oper
  • Level > 95 OR UmV340_RCYL_SD__Oper
  • UmV340_PW_FILL__Oper
  • UmV340_PW_MW__Oper

Sheet {C5-CCM-Steps}

  • ( UmV340_FILL OR UmV340_RCYL OR UmV340_RUN OR UmV340_SD )
  • ( UmV340_FILL OR UmV340_RUN )
  • ( UmV340_RCYL OR UmV340_RUN )
  • ( UmV340_RUN )

Sheet {C5-CCM-Steps}

  • UmV340_MW OR UmV340_PW [LF] UmV340_FILL OR UmV340_RCYL OR UmV340_RUN OR UmV340_SD

  • UmV340_MW OR UmV340_PW OR UmV340_FILL OR UmV340_RCYL OR UmV340_SD [LF] UmV340_RUN

  • UmV340_MW OR UmV340_PW OR UmV340_FILL OR UmV340_SD [LF] UmV340_RCYL OR UmV340_RUN

  • UmV340_MW OR UmV340_PW OR UmV340_RCYL OR UmV340_SD [LF] UmV340_FILL OR UmV340_RUN

1.3 Consolidate pCode

Purpose: The purpose of this task is consolidate multiple-lines of code into single cell.

To Do: Do the following tasks:

  1. Select the {C7-Code} worksheet
  2. Click the [P2] Consolidate multiple-lines.. button

1.4 Build Dictionary

Purpose: The purpose of this task is to do the following

  1. Copy and paste all Tags in this UM and paste them with their corresponding description in columns 17 and 18
  2. Extract all words from pCode collected and list them in column 15
  3. This enable user to assign a tag name to a pCode word in column 15

To Do: Do the following tasks:

  • Select the {C7-Code} worksheet

  • Click the [P3] Build Dictionary.. button

    add

1.5 Add the pCode to Code Dictionary

Purpose: The purpose of this task is to copy objects created in the previous task to this page

To Do: Do the following tasks:

  • Select the {URL_Objects} worksheet (click on cell D1)

1.6 Replace Dictionary Definition

Purpose: The purpose of this task is to copy objects created in the previous task to this page

To Do: Do the following tasks:

  • Select the {URL_Objects} worksheet (click on cell D1)

1.7 Replace Code to Transitions and CCMs sheet

Purpose: The purpose of this task is to copy objects created in the previous task to this page

To Do: Do the following tasks:

  • Select the {URL_Objects} worksheet (click on cell D1)

1.8 Backup the Code Sheet

Purpose: The purpose of this task is to copy objects created in the previous task to this page

To Do: Do the following tasks:

  • Select the {URL_Objects} worksheet (click on cell D1)

Please contact us if you need more information.

© 2024 CTRL Designer LLC, Boston, MA USA. CTRLDesigner.Com - All rights reserved