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. In each case, the weighed-out weight is subtracted from the weighed-in weight and, in parallel, the tray is subtracted from the weighed-in weight. The result of the 1st subtraction is divided by the result of the 2nd subtraction and multiplied by 100. The report formula is used to check the validity criteria of the analysis. To do this, the mean value of result A and result B is calculated and the 5% deviation from the mean value is determined. The upper limit of the 5% deviation is calculated by multiplying the mean value by 1.05, the lower limit is calculated by multiplying the mean value by 0.95. In order to fulfill the validation conditions, the 5% deviation is combined with result A and result B using an if-then query. If the condition is met that the mean value is outside the 5% limits (greater or less), then the message “Deviation” appears in the Report field. Else, the mean value of result A and result B is entered as the value in the Report column.

In mathematical notation, the formula for calculating result A, result B and report (mean value and 5% deviation limits) 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 * 1.05 = Upper limit
(75.36 + 71.65) / 2 * 1.05 = 77.18

(Result A + Result B) / 2 * 0.95 = Lower limit
(75.36 + 71.65) / 2 * 0.95 = 69.83

The if-then query follows the principle if(condition, then, else).
The content of a query is indicated by if( ) and the consequences of a condition are separated by ,.
Use < and > to combine result A and result B with the upper and lower limits.

if ((Result A + Result B) / 2 * 1.05) < Result A, "Deviation", (Result A + Result B) / 2 )
if (77.18 < 75.36, "Deviation", 73.51)

if ((Result A + Result B) / 2 * 1.05) < Result B, "Deviation", (Result A + Result B) / 2 )
if (77.18 < 71.65, "Deviation", 73.51)

if ((Result A + Result B) / 2 * 0.95) > Result A, "Deviation", (Result A + Result B) / 2 )
if (69.83 > 75.36, "Deviation", 73.51)

if ((Result A + Result B) / 2 * 0.95) > Result A, "Deviation", (Result A + Result B) / 2 )
if (69.83 > 71.65, "Deviation", 73.51)

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_Val']['0']
Result B = ['AL_Val']['1']
Report = ['AL_Val']['2']
Tray A= ['AL_Val']['3']
Weighing-in A = ['AL_Val']['4']
Weighing-out A = ['AL_Val']['5']
Tray B = ['AL_Val']['6']
Weighing-in B = ['AL_Val']['7']
Weighing-out B = ['AL_Val']['8']

The mean value is calculated using the mittelwert( ) or avg( ) function.
The values on which a mean value is based are placed between the brackets and separated from each other by ,.
Several conditions of an if function are linked together, e.g. by || (= or).

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

Ergebnis A

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

Ergebnis B

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

Bericht mit Validitätsprüfung

wenn(
mittelwert(m['GV']['0'], m['GV']['1'])*1.05 < m['GV']['0'] ||
mittelwert(m['GV']['0'], m['GV']['1'])*1.05 < m['GV']['1'] ||
mittelwert(m['GV']['0'], m['GV']['1'])*0.95 > m['GV']['0'] ||
mittelwert(m['GV']['0'], m['GV']['1'])*0.95 > m['GV']['1']
, "Abweichung", mittelwert(m['GV']['0'], m['GV']['1']))

The m stand 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 blue name of the parameter,
e.g. AL- annealing loss.

You can find more details under Deposit formulas with parameters.