Menu | <<<< | >>>> | Add-on formulas on the {Formulas}
sheet in workbook
Clicking the [3. Finalize formulas] button in the indicator workbook creates this set of add-on formulas (in cell notation) that can be added to solution pages as extra variables (indicators in rows) or sheets (aggregation formulas in columns). Once created, this sheet is added to workbooks whenever you click the [Add Indicators to Solution] button in the <Solution.xls> workbook. If you have syntax errors in your indicator and aggregate variable formulas, you will spot them on this sheet. Here all of the formulas generate 0’s meaning that they follow the correct syntax. Notice that the indicators are added to the outside of the solution area. |