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 opens.

  4. Enter the password you want to use to protect the formula in the two input 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.

  4. Enter the password in the input 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 input 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.