Calculation Function Set-Up
Calculations can be set-up in LIMS for various needs. Users utilize this function to automatically calculate ratios, averages, %rsd values, percentages etc. This tutorial will explain how to set-up a calculation to use constants or values of other parameters within one SampleType. Another type of calculation is used to pull out values form other samples, this will be covered in a separate tutorial.
1.0 Access to Calculation Field on Methods
Locate the appropriate method.
- Expand "Parameters" section
- Scroll to the left until you see a column "CALCULATION"
- Click on symbol to open calculation text box
- This is an example of simple calculation where value of one parameter is multiplied by a constant
NOTE: A Calculation is connected to a method, which mean every time the method which has a calculation field defined for one of the parameters is used the calculation will be completed for that parameter.
NOTE: When the constant does not change it can be put right into the syntax of the calculation field text. If the constant changes and needs to be defined by laboratory technician each time for different sample, then you should create a parameter for the constant.
2.0 View Calculation Field Directly from Sample
Open the necessary sample
- Expand "Results" section
- Hover cursor over the "Parameter Name"
3.0 Calculation field Syntax
Symbol § also known as section sign is used to enclose Method Name and Parameter Name, when a value of a certain parameter is needed in the calculation.
Symbol ~ also known as tilde is used to separate MEthod name and Parameter Name, when a value of a certain parameter is needed in the calculation.
§MethodName~Parametername§
For the calculation shown in the snap shot above the value which is entered as a result for TMP will be multiplied by constant 7.04
for other mathematical functions use the following syntax:
" * " asterisk is used for multiplication
" / " backslash is used for devision
" + " plus is used for addition
" - " minus used for subtraction
4.0 Simple Example (Multiplication by constant)
Parameter name "SN-530 Additive" requires to take the result of parameter TMP and multiply it by a constant 7.04
For this operation the following formula is used: §Sn-530~TMP§ * 7.04
Parameter "TMP" is in the "SN-530" method.
This part of the formula §Sn-530~TMP§ pulls the value of TMP parameter which is shown to be 11.8 in this example
The formula become "11.8*7.04" which results in 83.072
5.0 Simple Example (Addition of the value of two parameters)
Parameter name "Antioxidants" requires to take the sum of results of parameter Catechol and Hydroquinone
For this operation the following formula is used: §Sn-530~Catechol§ + §Sn-530~Hydroquinone§
Parameter "Catechol" is in the "SN-530" method.
Parameter "Hydroquinone" is in the "SN-530" method.
This part of the formula §Sn-530~Catechol§ pulls the value of Catechol parameter which is shown to be 859.9 in this example
This part of the formula §Sn-530~Hydroquinone§ pulls the value of Hydroquinone parameter which is shown to be 872.1 in this example
The formula become "859.9 + 872.1" which results in 1732.0
0 Comments
Add your comment