Changing the Model Measures

The following examples explain how to change Model Measures in several ways:

  • Change an existing measure.
  • Import an additional standard measure from the model.
  • Export an additional custom measure to the model.

Change an existing measure

  1. Open the template and select the Configuration worksheet.
  2. Edit any Name or Description by highlighting and typing over them.

    Note that if you want to change a measure--for example, to prompt the user for Probability instead of Frequency--you only need to change the name and description in Metrics From Model – this is then displayed in the model and the user can choose the appropriate measure to map.

Import an additional standard measure from the model

  1. Open the template and select the Configuration worksheet.
  2. From the menus choose:

    Tools > Protection > Unprotect Sheet

  3. Select cell A5, which is shaded yellow and contains the word End.
  4. From the menus choose:

    Insert > Rows

  5. Type in the Name and Description of the new measure. For example, Error and Error associated with segment.
  6. In cell C5, enter the formula =COLUMN('Model Measures'!N3).
  7. In cell D5, enter the formula =ROW('Model Measures'!N3)+1.

    These formulae will cause the new measure to be displayed in column N of the Model Measures worksheet, which is currently empty.

  8. From the menus choose:

    Tools > Protection > Protect Sheet

  9. Click OK.
  10. On the Model Measures worksheet, ensure that cell N3 has Error as a title for the new column.
  11. Select all of column N.
  12. From the menus choose:

    Format > Cells

  13. By default, all of the cells have a General number category. Click Percentage to change how the figures are displayed. This helps you check your figures in Excel; in addition, it enables you to utilize the data in other ways, for example, as an output to a graph.
  14. Click OK.
  15. Save the spreadsheet as an Excel 2003 template, with a unique name and the file extension .xlt. For ease of locating the new template, we recommend you save it in the preconfigured template location on your local or network file system.

Export an additional custom measure to the model

  1. Open the template to which you added the Error column in the previous example; select the Configuration worksheet.
  2. From the menus choose:

    Tools > Protection > Unprotect Sheet

  3. Select cell A14, which is shaded yellow and contains the word End.
  4. From the menus choose:

    Insert > Rows

  5. Type in the Name and Description of the new measure. For example, Scaled Error and Scaling applied to error from Excel.
  6. In cell C14, enter the formula =COLUMN('Model Measures'!O3).
  7. In cell D14, enter the formula =ROW('Model Measures'!O3)+1.

    These formulae specify that the column O will supply the new measure to the model.

  8. Select the Settings worksheet.
  9. In cell A17, enter the description '- Scaled Error.
  10. In cell B17, enter the scaling factor of 10.
  11. On the Model Measures worksheet, enter the description Scaled Error in cell O3 as a title for the new column.
  12. In cell O4, enter the formula =N4*Settings!$B$17.
  13. Select the corner of cell O4 and drag it down to cell O22 to copy the formula into each cell.
  14. From the menus choose:

    Tools > Protection > Protect Sheet

  15. Click OK.
  16. Save the spreadsheet as an Excel 2003 template, with a unique name and the file extension .xlt. For ease of locating the new template, we recommend you save it in the preconfigured template location on your local or network file system.

When you connect to Excel using this template, the Error value is available as a new custom measure.