Formulas for cost models

FACTON allows you to use user-defined formulas for the Technology calculation mode .

WARNING

If you make changes to the formulas or variables of a cost model in Data Administration, you'll have to close and restart the project you are working on before the changes will take effect in the Technology calculation mode.

The formulas are written in C# programming language. Keep the following limitations in mind:

  • no access to files
  • no access to Windows registry
  • no access to security-related system functions

This description is only a small excerpt of the functionalities of C#. For more in-depth information about C#, please refer to the documentation for this programming language.

Further Information

Activate formula protection

  1. In the ribbon, click on View ► Data Administration.

    The "Data Administration" dialog opens.

  2. Switch to the "Calculation" tab.
  3. Activate the "Protected" checkbox.

    The Change Password dialog is shown.

    Change Password dialog

    Figure: Change Password dialog

  4. Enter the password you want to use to protect the formula in the two entry fields.
  5. Confirm your entries with OK.

    The formula is protected.

Display, edit and test a protected formula

  1. In the ribbon, click on View ► Data Administration.

    The "Data Administration" dialog opens.

  2. Switch to the "Calculation" tab.
  3. Click on Check Computation.

    The "Password Request" dialog appears.

    Password request dialog

    Figure: Password request

    dialog
  4. Enter the password in the entry field.
  5. Confirm your selection with OK.

    The "Password Request" dialog closes. The formula is shown and can be edited.

  6. Click again on Check Computation.

    The formula is checked.

Deactivate formula protection

  1. In the ribbon, click on View ► Data Administration.

    The "Data Administration" dialog opens.

  2. Switch to the "Calculation" tab.
  3. Click on Check Computation.

    The "Password Request" dialog appears.

  4. Enter the password in the entry field.
  5. Confirm your selection with OK.

    The "Password Request" dialog closes. The formula is shown and can be edited.

  6. Deactivate the "Protected" checkbox.
  7. Confirm your selection with OK.

    The "Data Administration" dialog closes.