Use Excel template in cost models

  1. Select a cost model of the Cost model category in Data Administration.

    The properties for the cost model are displayed.

  2. Switch to the "Calculation" tab.

  3. Click on to open the Excel template.

    The Excel template is shown in the combobox.

  4. Click on to open the Excel template.

  5. In the "Parameter type" column, select the entry "Input, Reference".

  6. In the "Excel cell reference" column, enter a cell reference in the Excel template for each parameter.

  7. Enter the name of the worksheet followed by a "!" along with the column and row of the Excel spreadsheet.

    Example

    Table!A3

  8. Close the Excel file.

  9. Click Check cell references.

    A dialog opens displaying the parameters that were found.

  10. Click Apply.

    The cost model is saved with the Excel template in Data Administration.