How do I use formulas in the project calculation?

Topic Overview

• What are formulas in the project calculation?
• Calculating values and entering formulas
• Using assumptions and line items as variables
• Tracing the calculation logic via the formula bar

What are formulas in the project calculation?

The project calculation allows you to automatically calculate dependent values using formulas. When central project assumptions like area or price per square meter change, dependent cost values are automatically updated without manual adjustment.

Calculating values and entering formulas

You can manually enter values or calculate them directly using formulas.

1. Open Plan in the sidebar and select Project calculation.
2. Add a new cost group or edit an existing line item.
3. Enter your desired formula in the respective field.

Using assumptions and line items as variables

For more complex calculations, you can use other line items and assumptions as variables.

1. Navigate to the Assumptions tab to define central project assumptions (e.g., areas).
2. Use these assumptions as variables within your formulas in the calculation.
3. As soon as variables such as area or price per square meter are modified, the dependent values update automatically.

Tracing the calculation logic via the formula bar

To ensure transparency, you can view the exact calculation logic (e.g., Area × Cost per sqm = calculated costs) directly.

• Click on a calculated line item in the calculation.
• In the displayed formula bar, you can easily trace the underlying logic and the variables used.

LEGAL