How to set up Analyses Services that are calculated?

Functional How-to
1

Eg Calculated LDL Cholesterol (LDL-C) using the Friedwald equation:

LDL Cholesterol = Total Cholesterol - HDL - (Triglycerides / 5)

Step-by-step instructions:

Prerequisites: You have an Analysis Service “LDL Cholesterol calculated” (LDLC-C) already in place.

1.- Login with labman privileges
2.- Click to the top right gear-icon
3.- Click to “Calculations”
4.- Click to “Add” button
5.- Set the name “LDL Cholesterol Friedwald”

Calculation can be set in three different ways, depending on your needs and your instance configuration:

5a) Use the results of other analyses as the input for the calculation

You have three Analysis Services already in place:

  • “Total cholesterol” (TC)
  • “High Density Lipoproteins” (HDL)
  • “Tryglicerides” (TG)

so in results entry view, four rows (one per analysis) will be displayed.

  1. In the “Calculation Formula” field, at the bottom, type the following:

     [TC] - [HDL] - [TG]/5

    Where:

    • TC: Keyword for “Total cholesterol” Analysis Service
    • HDL: Keyword for “High Density Lipoproteins” Analysis Service
    • TG: Keyword for “Tryglicerides” Analysis Service

  2. Click to “Save”

5b) Use custom/interim fields values as the input for the calculation

You don’t (or don’t want to) have those three Analysis Services in place.
In results entry view, only the row for “LDL cholesterol” will be displayed, but with three additional columns: one for TC, another for HDL and another for TG.

  1. In the “Calculation Interim Fields” section, add three interims as follows:

     Keyword: TC   Field Title: TC    Default value: <empty>  Unit: mg/dL
 Keyword: HDL  Field Title: HDL   Default value: <empty>  Unit: mg/dL
 Keyword: TG   Field Title: TG    Default value: <empty>  Unit: mg/dL

  2. In the “Calculation Formula” field, at the bottom, type the following:

     [TC] - [HDL] - [TG]/5

    Where:

    • TC: Keyword for “Total cholesterol” Interim field
    • HDL: Keyword for “High Density Lipoproteins” Interim field
    • TG: Keyword for “Tryglicerides” Interim field

  3. Click to “Save”

5c) Use both interims and results of other analyses as the input for the calculation

You want a mix of the two options explained above.
E.g. you already have the Analyses Services HDL and TG set up in the system, but not TC.

  1. In the “Calculation Interim Fields” section, add one interim as follows:

     Keyword: TC   Field Title: TC    Default value: <empty>  Unit: mg/dL

  2. In the “Calculation Formula” field, at the bottom, type the following:

     [TC] - [HDL] - [TG]/5

    Where:

    • TC: Keyword for “Total cholesterol” Interim field
    • HDL: Keyword for “High Density Lipoproteins” Analysis Service
    • TG: Keyword for “Tryglicerides” Analysis Service

  3. Click to “Save”

6.- Go to Analysis Services and click to “LDL Cholesterol calculated” (LDLC-C) Analysis Service
7.- Click to “Method” tab (top-right)
8.- Unselect field “Use the Default Calculation of Method”
9.- Choose the calculation “LDL Cholesterol Friedwald” from the selection list.
10.- Click “Save”
11.- Create a new Analysis Request and select the analysis “LDL Cholesterol calculated”
12.- Receive the Analysis Request
13.- The result for “LDL Cholesterol calculated” will be calculated automatically as soon as the values for TC, HDL and TG are entered.

3 Likes
2

Save time, use the manual!-) https://www.bikalims.org/manual/setup-and-configuration/calculations

only saw this now, apologies

3

Also, a lot of work has gone in here now to get the display order of the Interim fields right, and also make it possible to include Interims on COAs, e.g. for results in converted units or Dry and As Is results.

The critical latter’s heinous removal from the system by the Senaite Foundation despite our protestations still has the original sponsor of that work fuming, and asked me to pass their disgust on (done now). It caused them months of delays. New LIMS prospects getting wind of the degradation of the ‘free upgrade path principle’ might think twice before committing. For the health of the project, this must absolutely never be repeated.