Step 1: Build a list of model instances

In this example, we focus only on the Flare library and we create a list of models instances for each Model Type in the Flare library. However, you can create additional lists of model instances for any Model Type in any Model Library based on your needs.

Tip: Due to the large number of Model Types in each Model Library, you may want to create separate worksheets for each Model Library that you work with. You can reuse these worksheets in your various AVEVA Process Simulation Excel reports.

For simplicity and quicker data loading, the list of models that we build in this example only includes up to 20 model instances of each Model Type in the Flare library. The more AVEVA Process Simulation Excel functions that you include in your report, the longer the data takes to update when you switch the default simulation. If the simulations that you plan to use with a particular report template include more than 20 instances of a Model Type, you can expand the list as needed. However, you may want to be selective about the lists that you expand so that the time the software takes to update your data does not become unmanageable.

Build a list of model instances

1. Open a new AVEVA Process Simulation Excel report (that is, open a new Excel workbook with the AVEVA Process Simulation Excel Add-in enabled).

2. Rename Sheet 1 to Flare Models.

3. On the AVEVA Process Simulation tab, in the Simulation group, select Set Default. The Set Default Simulation dialog appears.

4. In the list of simulations, select F1 -Flare Relief, and then select Set Default.

5. In A1 and B1, enter Simulation and =SCDefSim(), respectively, to show the default simulation you are currently working with. Format A1 and B1 as desired.

6. Create a list of index values by doing the following:

   1. In A3, enter Index.

   2. Select Row 3 and change the formatting to distinguish the heading row.

   3. In A4, enter 1.

   4. In A5, enter 2.

   5. Select A4 to A5 and drag the lower right corner of the selection to A23 to create a list of 1 through 20.

      

7. In B3 to P3, enter the names of the main Model Types in the Flare library.

   

   Tip: Model Types in different Model Libraries can have the same name but a different set of variables and parameters. To ensure that your list of model instances only include model instances that have the same set of variables and parameters, use the library-specific model name when you specify the ModelType argument for the SCModelList function.

8. In B4, enter =SCModelList(B$3,$A4).

9. Select B4 and drag the lower right corner of the cell across to P4. Cells B4 to P4 should still be selected. Drag the lower right corner of the selection down to P23.

   The list populates with the model instances in the default simulation. If the specified model instance does not exist, the cell value appears as #N/A. You can set up conditional formatting to more easily see the cells that contain model names instead of

Set up conditional formatting for cells that contain model names

10. Select B4 to P23.

11. On the Home tab, in the Styles group, select Conditional Formatting, and then select New Rule. The New Formatting Rule dialog appears.

12. In the Select a Rule Type list, select Format only cells that contain.

13. In the Edit the Rule Description area:

    1. In the first list, select Cell Value.

    2. In the second list, select not equal to.

    3. In the last box, enter ="#N/A".

    4. Select Format and select a formatting that will highlight the cells with model names.

14. Select OK.

    The model names now appear more clearly.