Why is a total made

Identifier W

Identifier

Identifiers for controlling the amount of this line.

empty

Normal formula line. The formula result appears in the Result column; the value is added to the item total if necessary.

H

Auxiliary formula line. The formula result appears in the Auxiliary value column; the value is not added to the item total. In the case of multi-line formulas, the identifier must be in the result line.

* (Asterisk)

Explanatory text only. No formula specifications are possible in this line.

s

Start of subtotal auxiliary value column. Auxiliary values ​​are to be added from this line onwards.

S.

End of subtotal auxiliary value column. Sum of all values ​​in the auxiliary value column from the beginning or from the last previous line with the identifier 's'.

z

Start of subtotal result column. From this line onwards, the result column should be totaled.

Z

End subtotal result column. Sum of all values ​​in the result column from the beginning or from the last previous line with the identifier 'z'.

p

Start of subtotal result column. From this line onwards, the result column should be totaled.

P

End subtotal result column. Sum of all values ​​in the results column from the beginning or from the last previous line with the identifier 'p'.

B.

Retrieval of reference sums from the room and building book.
If this ID is selected, all fields except ID and address will be gray. In the formula field, the RGB tree can be displayed with a double click, and you can determine a number of reference elements, the sums of which are to be collected, analogous to the surcharge element. These sums are entered in the formula column with '+' and result in a reference total. If, for example, 'Sum' has now been entered as the address, decisions can be made in the following If lines depending on the total. Typically these are things like 'construction site equipment' or similar, which can depend on the amount of accounts 300 + 400, for example. If the reference values ​​in the RGB are changed, these reference elements are of course always re-evaluated and readjusted if necessary.

W.

Retrieval of an RGB characteristic value sum from component levels of hierarchically lower-lying elements / rooms. See below for details. See also RGB_Kennwerte in the master data.

X

Summation of the hierarchy level below. See below for details.

Y

Summation of lower-lying address values ​​of the current module. See below for details.

Identifiers for process control

L.

Cost center definition for the current section.

A stop position line is inserted with the (changeable) comment Determination of cost center. If a project provides for documentation according to cost centers, this identifier enables an automatic query to be made as to which cost center all lines in the paragraph should be assigned to. In order for this identifier to take effect, appropriate documentation (system type Dok or DokGr) must be available when this component is activated. If there is no further paragraph marking, the cost center entry is made until the end.

G

Determination of cost unit for current section.

A stop point line is inserted with the (changeable) comment Determination of cost unit. If a project provides for documentation according to cost units, this identifier enables an automatic query to be made as to which cost unit all the following lines in the paragraph should be assigned to. In order for this identifier to take effect, appropriate documentation (system type DokGr) must be available when this component is activated. If there is no further paragraph marking, the cost unit entry is made until the end.

J

Determination of cost units from the current line to the end or the next 'Y' identifier with the same division entry.

A stop point line is inserted with the (changeable) comment Determination of cost unit. If a project provides for documentation by cost unit, this identifier enables an automatic query to be made as to which cost unit should be assigned all the following lines with the same division entry. In order for this identifier to take effect, appropriate documentation (system type DokGr) must be available when this component is activated. If there is no other J identifier with the same division entry, the cost unit entry is made until the end.

K

Determination of cost unit key from the current line to the end or the next 'K' identifier with the same division entry.

A stop line is inserted with the (changeable) comment Determination of cost unit key. If a project provides for documentation according to cost units, this identifier enables an automatic query as to which cost unit key should be assigned to all following lines with the same division entry. In order for this identifier to take effect, appropriate documentation (system type DokGr) must be available when this component is activated. If there is no other K identifier with the same branch entry, the key entry is made until the end.

V.

'On Demand' variant.
Like a normal component variant, which is only called up in the current component if the introductory if condition applies. For this purpose, components are created in the variant list, which have a paragraph with the identifier 'V' at the top hierarchy level and an if condition is specified in their formula line. If this variant is used in a component and the if condition applies, the variant is automatically copied to this point and processed at runtime. If the if-condition does not apply, all variant lines below the paragraph are deleted when saving. With larger variants, this functionality saves a lot of rows in the database.

A or I

Selection of a component from variants. A 'parameter list for formula column' is required for use, which contains entries in the form 'Group = '. When the component is called up, the window 'Selection Variation' is opened with this identification and selection of a desired parameter, with the cursor on the first component found in the associated group. After selecting a variation, it is imported into the RGB component, but without the 'Variation' property being copied. It simply appears as a sequence of component lines with any level of hierarchy. If a component line with the identifier 'A' or 'I' is in a variant or at the end of a variant (yellow coloring) then the sequence is evaluated as an expanding component of the variant. The difference between 'A' and 'I'-ID is that with' A 'the request line remains, with' I 'the request line is deleted. If the variant group from the parameter list does not exist, the entire variant tree is shown for selection. These functions become particularly strong when the line is a stop position line. In addition, variants can themselves have any number of 'A' and 'I' lines, which de facto enables recursive component calls.

annotation

The identifiers G, J and K enable automatic insurance provider assignment, whereby G and J assign 100% of the specified line to an individual insurance provider, K distributes the line value according to the specified key. If the areas of validity of the information overlap, the information under G takes priority over J and J over K.

In preparation for use, you need one or more RGB parameters. These are recorded under Master Data-> RGB Characteristic Values. In the example below, the 'FFL' is the window area.

Within a room (here 'Room 100') there are several windows with the formulas for determining the window area of ​​each individual window.

The address 'FFL' is assigned to each window, whereby 'FFL' must be the RGB characteristic value that has already been recorded.

In the room and building book itself, this room is part of a hierarchy, here e.g. the 'ground floor'

In the component level of the first floor, the sum of the window area can then be determined by entering the identifier 'W' and specifying 'FFL' in the formula column.

The RGB characteristic value in the formula column can only be selected by double-clicking. The result itself can be used further via any (global) address.

Serves to form the sum of all hierarchically lower results. In the following example the total area of ​​a room is determined.

The identifier 'X' automatically enters all partial results of the measurement lines below in the formula column. Changes to these measurement lines are automatically updated in the formula line. The totals line can itself have an address, the value of which can be used in other places.

Serves to form the total of all hierarchically subordinate addresses. In the following example, the total area is determined across all windows.

After entering the identifier 'Y', a globally set address of the lower hierarchy can be selected in the formula column by double-clicking. The 'Result' column then bears the total for all lines with the selected address. Changes to the measurement lines are updated automatically. The totals line can itself have an address, the value of which can be used in other places.

Note: This identifier works in a similar way to the above identifier 'W', but in contrast to this only within an element or room.