When you notice a green box while hovering over a field, it means you can edit it. You can click on any of the lowest lines to edit a figure. It will open a pop-up to edit the figure. You can enter an amount and a method. This will calculate the outcome of the third field. There are two ways of working with this pop-up, which are both described below.
- When you edit the ‘Amount’ field, it will calculate the outcome based on the selected method. For instance, you can enter an amount of 100 with the method ‘Per net m²’. If the object has 75 net m², the outcome will be 100 x 75 = 750 per unit.
- It also works the other way around. For instance, if you would enter 1.500 in the outcome per unit, the amount will be recalculated to an amount of (1.500 / 75 =) 200.
The following methods are supported:
- Total amount
- Per unit
- Per gross m²
- Per net m²
- Amount per volume³
- % of acquisition land and/or premisses
- % of construction costs
- % of revenues
For each lowest line, it is possible to apply an indexation. When you check the box ‘Indexation’, additional fields are shown. These fields are set by default, but you always overrule these fields manually.
To apply an indexation, first select an index percentage. You can either fill in a custom percentage or choose a pre-defined index series (managed in Scenario settings > Indexation). Followed by entering a start and end date. These can be custom dates as well but it's also possible to select activities or milestones that are connected to the planning.
The system will calculate the indexed amount based on your data. Increase amount cannot be adjusted. When saved, the indexed amount is the amount that will be shown on the table.
Figure 1: Pop-up to edit a single cell
Figure 2: Indexation applied