The Performance Table

The Performance table is based on information provided in the Target Table. In fact, the Performance Table is actually a reformatting of Target Table values in a format that is more convenient for observing patterns over multiple time horizons.

The Target Table can be indexed by planning period. The performance table has a column for each planning period, allowing values for all planning periods to be displayed simultaneously. However, the Performance Table is indexed by indicator, and can only show one indicator at a time (for example, current account value). The indicator being displayed is selected by choosing from the indicator menu.

The first three columns of the planning period are

Table 17. Performance Table Attributes

AttributeDescription
TARGETThe unique name of the target that is represented in this row. This field is static and will not change during the simulation.
ACTIVEA boolean value that indicates if the target is being used in the objective function. This value does not vary between planning periods.
MINACTIVEA boolean value that indicates if the minimum target value is active in the objective function. This value does not vary between planning periods.
MAXACTIVEA boolean value that indicates if the maximum target value is active in the objective function. This value does not vary between planning periods.


Subsequent columns of the Performance Table are labeled by planning period, from 'P_0' up to the highest planning period number. These columns hod the value of the chosen indicator for each respective planning period.

[Note]Note

The cells of the Performance Table are colour coded to indicate the relative value of the cell with respect to all other values in the table. The lowest valued cells are shaded blue, and the highest valued cells are shaded pink.

[Tip]Tip

You can use the Performance Table to quickly see which targets are active in the solution, and how much each is contributing to the overall objective function value. Click on the 'ACTIVE' column heading, and then sort the rows into ascending order. This will raise all targets that are active in the objective function to the top of the table. Next, set the selected indicator to 'OBJECTIVE'. The cells of the table will show how much each target and planning period are contributing to the overall objective function value. Through a trial and error process you can use these values to determine the level of weights that provide an equitable balance between targets.