Step 2: Create the report

For simplicity, we will create a report only for the following variables for all the Pipes in a Flare simulation:

• Inlet pressure (P1)

• Outlet pressure (P2)

• Inlet temperature (T1)

• Outlet temperature (T2)

• Length (L)

• Diameter (D)

• Schedule (Sch)

We use the list of model instances that we built in Step 1 to create a dynamic report that will update with the appropriate data when we change the default simulation.

Create the report

1. On Sheet 2, in A1 through B5, set up the default information for your Excel report.

   The following table shows these cell values:

   	A	B
   1	Simulation	=SCDefSim()
   2	Snapshot	=SCDefSnap()
   3	UOM Slate	=SCDefUOMSlate()
   4	Mode	=SCMode("",B2)
   5	Solution Status	=SCSolState("",B2)

2. Select Rows 7 through 9 and change the formatting to distinguish the heading row.

3. In A7, enter Pipe.

4. In B7 to H7, enter the variable name for each variable of interest.

5. In B8 to H8, enter descriptions for each variable.

6. In B9 to H9, enter the UOMs that you want to use for each variable.

   

7. In A10, enter =IF(CELL("type", 'Flare Models'!E4) = "l", 'Flare Models'!E4, "").

8. Select A10 and drag the lower right corner of the cell down to A29.

   The names of the Pipes in the current default simulation (F1 - Flare Relief) should appear in cells A10 through A21.

9. In B10, enter =IF($A10<>"",SCValue($A10,B$7,B$9),"").

10. Select B10 and drag the lower right corner of the cell across to H10. Cells B4 to P4 should still be selected. Drag the lower right corner of the selection down to H29.

    The values for each variable for all of the pipes should appear.

    

11. Change the default simulation to the F3 - Flare Relief with Mixed Fluids simulation to verify that your report template is working properly.

    The report now shows values for all the pipes in the F3 - Flare Relief with Mixed Fluids simulation.