author:
check:
release:

Formulas and sums are just like the Object manager, a universal tool. The results can be, for example, cost calculations (area x variable costs per m2 = result in EUR) or evaluations (area x variable evaluation in points = total number of points).

Generated formulas are saved across all programs and are therefore immediately available in all other drawings. The application, selection and administration of the formulas is done in one and the same window, which is via Add> Formula is opened.

1. click on Add> Formulas in the tab Features.
   
   
   
   
2. A formula can now be selected from the individual libraries, which can then be entered with [Take over] in the Mass tree is taken over. If there are still variables stored in the formula, they will be queried when inserting.
   
   
   
   
3. The same applies to references to lists in which an entry is selected and with [OK] can be confirmed.
   
   
   
   

In the actual formula dialog, formula libraries and lists are shown in the tree on the left. Under the folder DATAflor Predefined formulas are already stored that cannot be changed. Formulas from older program versions are automatically saved in the folder Old formula collection filed. over [Add] You can create your own libraries, formulas and lists.

1. click on Add> Formulas in the tab Features.
2. Select the group under which a new formula is to be created (not for group DATAflor).
   
   
   
   
3. Enter a name (e.g. area with solid excavation) and a unit (e.g. t).
4. Now the definition of the formula follows. In this case an object property {area} is required, since the excavation depends on the area size. With the button [>] and selection Object Property> Area the value is inserted into the formula.
5. Further inputs can now be +, -, *, / and numbers as arithmetic parameters, e.g. 2.5. It is more suitable to work with variableswho are also with [>] inserted. The variable can be referred to as [layer thickness]. This has the advantage that each time the formula is used, a layer thickness that is individually applicable to the object can be determined.
6. The last thing you can do is to use a List can be accessed, e.g. [! conversion weights m3 / t!]. A list is a collection of predefined values ​​that can serve as a knowledge base.
7. When the formula is then used, the variable and a value from the list are queried.

Go to the Change formulas that have already been defined, the corresponding entry is marked in the tree on the left. The right side shows the details, which can be easily edited.

Editing is ended by selecting another formula in the tree or using the formula with [Take over]. Changes only affect newly assigned formulas. Already in Object manager The formulas used are not overwritten by the new property.

Lists are used in the formula library as a knowledge database and for storing frequently required values.

Created lists can simply be entered with [To edit] can be edited. The system already contains two standard lists that deal with the conversion of areas and distances into weight.

To edit variables later, if the formula has already been inserted, mark the corresponding attribute in the tab and click on on the right [Variables]. To edit the selection of a list entry later, if the formula has already been inserted, mark the corresponding attribute in the tab and click on on the right [Lists>].

The use of sums can be useful at group level, for example to calculate an average. Sums always relate to the attributes of all subordinate levels.

1. Highlight in Mass tree a group and click Add> Sum.
   
   
   
   
2. Select the desired attribute from the upper area by double-clicking and then select the desired calculation in the lower area.
3. With [OK] the total is assigned to the group as a new attribute.

For groups there is the possibility of using the property Percentage distribution assign. In this way you can, for example, document the proportion of the individual areas in the total area.

To assign this property to a group, select in the tab Features the function Add> Percentage Distribution and then for which object type this attribute should be created. Now the percentage of each object is calculated and immediately listed as an attribute in the properties.

Example for the representation for an area:

You can also use the attribute for the Label use. To do this, first mark the Mass tree a group or an object that has this property. Then select in the tab Label the button and there the entry Percentage distribution. Further information can be found in the chapter Label.