Menu | <<<< | >>>> | [Load/Modify Indicators] – click to load and modify indicators

Clicking the [Load/Modify Indicators] button on the Solution Manager control screen brings up the indicator workbook when you want to add/change indicators. Here indicator and aggregate formulas have been added. To create an indicator formula you add an indicator name (a variable and category code), a format for the indicator, the formula using model variable names (except ! is used instead of Sheet names), and an explanatory description.

To create aggregate variables you enter the aggregate (sheet) code, mark 1’s in a row for each sheet code to be included in the aggregate code, and a description. Then you enter the name of the aggregate variable, the format code, the variable or weight*variable to be aggregated, and a description.

When you are done, click the 1, 2, and 3 buttons in order to create the formulas. In some case formulas might be created in cells on the {Template} sheet where you don’t want them; you can remove these formulas manually before proceeding to button 3. As with VORSIM equations, if your formulas do not follow Excel syntax, you can see errors on the {Formulas} sheet and correct the indicator formulas and then repeat steps 1-3.