Purpose: The purpose of these exercises are to familiarize you with how to create comprehensive reports for Asset Design Information for the purpose of analysis.
Menu Path: IFS Business Analytics
Parameter Field | Value |
Parameter Type | DisplayItem |
Parameter Name | PlantName |
Description | Plant Name |
Prompt Text | Plant Name |
Display Item | Plant Name (selected using the LOV) |
Default Value | IFS Main Plant |
For Project
Parameter Field | Value |
Parameter Type | DisplayItem |
Parameter Name | ProjectID |
Description | Project ID |
Prompt Text | Project ID |
Display Item | Project ID (selected using the LOV) |
Default Value | PM41 |
For Design Object Class
Parameter Field Value Parameter Type DisplayItem Parameter Name DesignObjectClass Description Design Object Class Prompt Text Object Class Display Item Class (selected using the LOV) Default Value PIPE PART
Display Item | Start value | Stop value |
Object ID | 6 | 9 |
Design Part ID | 9 | 9 |
- Add Bill of Material List as the title for the report in C2.
- Select the area A1 to G4, fill color with Aqua and set the font color to White.
- Select the area A4 to G4, fill color with Orange, set the font color to White in A4 and Black in B4.
- Select the area A5 to G8, fill color with Dark Blue, set the font color to White and font size to 9.
- Select the area A9 to G9, fill color with Tan, set the font color to Black and font size to 8.
- Select D9 and add a left border.
- Select E9 and add a left border.
- Select F9 and add a left border.
- Select G9 and add a left and right border.
- Add the IFS logo to cell A4.
Cell Number | Operator | Condition |
B9 | = equals (selected using the LOV) | General Requirement |
C8 | = equals (selected using the LOV) | Valve Size |
C9 | = equals (selected using the LOV) | Pressure Rating |
D8 | = equals (selected using the LOV) | Body/Bonnet |
D9 | = equals (selected using the LOV) | Closure Member |
D10 | = equals (selected using the LOV) | Operator |
- Add Valve List as the title for the report in B4.
- Select the area A4 to D4, fill color with Aqua and set the font color to White.
- Select the area A5 to D7, fill color with Dark Blue and set the font color to White.
- Select the area A8 to D10, fill color with Tan and set the font color to Black.
- Select the area A8 to D10 and add outside border using Ctrl + Shift + &.
- Add the IFS logo to cell A4.
Parameter Field | Value |
Parameter Type | DisplayItem |
Parameter Name | PlantName |
Description | Plant Name |
Prompt Text | Plant Name |
Display Item | Plant (selected using the LOV) |
Default Value | IFS Main Plant |