How to ...  setup an array of compound specific parameters

Version 1

    In cases where you require several compound specific parameters to be used in a result calculation you can take advantage the parameter file import function available in OpenLAB CDS 2.

     

    Users of OpenLAB CDS rev. A can achieve the same by defining a set of report parameters (strings) and extraction of the compound specific  parameters.

    E.g. you  like to use the parameters Expected amount (ExpAmt) and standard deviation (STDV) for compound specific result validation. The following values are given:

    Compound number
    1
    23
    Compound nameMethanolEthanolPropanol
    Expected amount34.7120.43.01
    STDV1.31.72.2

     

    To slice these numbers into your template:

    - Define 3 Report parameters in string format:

    Compounds:      |01|Methanol|02|Ethanol|03|Propanol|

    ExpAmt:               34.7|120.4|3.01

    STDV:                  1.3|1.7|2.2

     

    - Generate a group repeated on "compound_name"

    - Within the group use the following command to extract the compound number from the "compounds"variable:

    =val(mid(Compounds,InStr(Compounds,Compound_Name)-3,2))

    The result can be stored in a variable (e.g. CmpNbr) to be used to extract the compound specific values from the parameters ExpAmt and STDV:

    =Trim(Choose(CmpNbr(Compound_Name),Split(ExpAmt,"|")))

    and

    =Trim(Choose(CmpNbr(Compound_Name),Split(STDV,"|")))

     

    For larger parameter sets it can be tedious write up the parameter strings, but this could be simplified by setting up a table with the pipe signs and numbers in the spreadsheet application of your choice and simply copy/paste it line by line to the report parameter input dialog.