Part 5 – Review the pCode and Dictionary
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:
- Select the {C7-Code} worksheet
- This will erase {C7-Code} so take a backup if you need this data
- 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:
- Select the {C7-Code} worksheet
- Click the [P2] Consolidate multiple-lines.. button
1.4 Build Dictionary
Purpose: The purpose of this task is to do the following
- Copy and paste all Tags in this UM and paste them with their corresponding description in columns 17 and 18
- Extract all words from pCode collected and list them in column 15
- 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)