Dry matter
Dry matter plays an important role in the characterization of waste - Calculation of dry matter by determination of dry residue or water content OENORM EN 14346 / Determination of protein content in the dry matter of cereals and cereal products ICC standard / Manual of soil analysis DIN 12880, DIN ISO 11465 / Examination of animal feed VDLUFA MB III.

In this example, the dry matter (abbreviation = DM) is calculated as a percentage of the original substance using a stored formula.

To do this, the weighing-out weight is divided by the weighing-in weight and the result is multiplied by 100.
The measured values for weighing-in and weighing-out include the mass of the tray. In the stored formula, the mass of the tray is taken into account by subtracting it in each case.
In mathematical notation, the formula looks like this:

((Weighing-out - Tray ) / (Weighing-in - Tray)) * 100 = Result

((11.85 -11.20 ) / (21.90 - 11.20)) * 100 = 6.07

In the Labordatenbank notation, the abbreviation of the parameter whose value is used for the calculation and the number of the column in which the respective measured value is located is specified.

Result = ['DM']['0']
Tray = ['DM']['1']
Weighing-in = ['DM']['2']
Weighing-out = ['DM']['3']

These components of the Labordatenbank notation are combined with the mathematical formula notation.
This results in the following formula in the Labordatenbank notation:

((m['DM']['3'] - m['DM']['1']) / (m['DM']['2'] - m['DM']['1'])) * 100
The m stands for the matrix notation for using the parameter columns.

The formula is stored in the formula field of the column in which the result is to appear.
You can access the screen for entering formulas by clicking on the blue name of the parameter, e.g. “DM Dry matter”.

Für die Berechnung der Trockensubstanz wird die Auswaage durch die Einwaage dividiert und das Ergebnis mit 100 multipliziert. Die Messwerte für Einwaage und Auswaage inkludieren die Masse der Schale. In der hinterlegten Formel wird die Masse der Schale berücksichtigt, indem sie jeweils substrahiert wird.

((m['TS']['3'] - m['TS']['1']) / (m['TS']['2'] - m['TS']['1'])) * 100

Annealing loss
Annealing loss (in %) is defined as the proportion of organic matter in a sample. It is analyzed, for example, in the characterization of waste - Determination of loss on ignition in waste, sludge and sediments EN 15169 / Soil testing methods in agricultural hydraulic engineering - Chemical laboratory tests DIN 19684-3 / Plastics - Determination of ash DIN EN ISO 3451-1 / Manual of soil testing DIN 12879, DIN 19684 / Testing of animal feed VDLUFA Method Volume III.

Result A resp. result B are calculated analogously to each other. The Weighing-out weight is substracted from the Weighing-in weight and in parallel, the tray is substracted from the Weighing-in weight. The result of the 1st subtraction is divided by the result of the 2nd subtraction and multiplied by 100.

The percentage in relation to the original substance is calculated using the formula for the report. The result of the dry matter calculation is included for this purpose. The mean value of result A and result B is calculated, divided by 100 and multiplied by the result of the dry matter.

In mathematical notation, the formula for the calculation is as follows:

((Weighing-in - Weighing-out) / (Weighing-in - Tray)) * 100 = Result
Result A
((23.77 - 22.18 ) / (23.77 - 21.66)) * 100 = 75.36
Result B
((9.71 - 8.8 ) / (9.71 - 8.44)) * 100 = 71.65

Report
((Result A + Result B) / 2) / 100 * Result DM = Result

((75.36 + 71.65) / 2) / 100 * 6.07 = 4.47

In the Labordatenbank notation, the abbreviation of the parameter whose value is used for the calculation and the number of the column in which the respective measured value is located is specified.

Result A = ['AL']['0']
Result B = ['AL']['1']
Report = ['AL']['2']
Tray A= ['AL']['3']
Weighing-in A = ['AL']['4']
Weighing-out A = ['AL']['5']
Tray B = ['AL']['6']
Weighing-in B = ['AL']['7']
Weighing-out B = ['AL']['8']

The mean value is calculated with the function mittelwert( ) or avg ( ). The values on which a mean value is based are placed between the brackets and separated from each other by ,.

These components of the Labordatenbank notation are combined with the mathematical formula notation.
This results in the following formulas in the Labordatenbank notation:

Result A

(m['GV']['4']-m['GV']['5'])/(m['GV']['4']-m['GV']['3'])*100

Result B

(m['GV']['7']-m['GV']['8'])/(m['GV']['7']-m['GV']['6'])*100

Report

mittelwert(m['GV']['0'], m['GV']['1'])/100*m['TS']['0']

The m Stands for the matrix notation to use the parameter columns.
The formula is stored in the formula field of the column in which the result is to appear.
You can access the screen for entering formulas by clicking on the name of the parameter written in blue, e.g. AL-Annealing loss.

You can find more details under Deposit formulas with parameters.