Premium Feature - Available upon request with all Premium Editions of LabKey Server. Learn more or contact LabKey.

During upload of Luminex files, we perform substitutions for certain flagged values. Other types of flagged values are imported without alteration.

Substitutions During Import for *[number] and OOR

We perform substitutions when Obs. Conc. is reported as OOR or *[number], where [number] is a numeric value. *[number] indicates that the measurement was barely out of range. OOR< and OOR> indicate that measurements were far out of range.

To determine the appropriate substitution, we first determine the lowest and highest "valid standards" for this analyte using the following steps:

  1. Look at all potentially valid standards for this run. These are the initial data lines in the data table on the Excel page for this Analyte. These lines have either “S” or “ES” listings as their types instead of “X”. These are standards (Ss) instead of experimental results (Xs). Experimental results (Xs) are called Wells in the following table.
  2. Determine validity guidelines. Valid standards have values in the (Obs/Exp) * 100 column that fall “within range.” The typical valid range is 70-130%, but can vary. The definition of “within range” is usually included at the end of each Excel page on a line that looks like: “Conc in Range = Unknown sample concentrations within range where standards recovery is 70-130%.” If this line does not appear, we use 70-130% as the range.
  3. Now identify the lowest and highest valid standards by checking the (Obs/Exp) * 100 column for each standard against the "within range" guideline.

N.B. The Conc in Range field will be *** for values flagged with * or OOR.

In the following table, the Well Dilution Factor and the Well FI refer to the Analyte Well (the particular experiment) where the Obs. Conc. was reported as OOR or as *[number].

When Excel Obs. Conc. is...
We report Obs. Conc. as... Where [value] is...
OOR < << [value] the Well Dilution Factor X the Obs. Conc. of the lowest valid standard
OOR > >> [value] the Well Dilution Factor X the Obs. Conc of the highest valid standard.
*[number] and Well FI is less than the lowest valid standard FI < [value] the Well Dilution Factor X the Obs. Conc. of the lowest valid standard.
*[number] and Well FI is greater than the highest valid standard FI > [value] the Well Dilution Factor X the Obs. Conc of the highest valid standard.

If a valid standard is not available (i.e., standard values are out of range), [value] is left blank because we do not have a reasonable guess as to the min or max value.

Flagged Values Imported Without Change

 

Flag Meaning Column
--- Indicates that the investigator marked the well(s) as outliers Appears in FI, FI Bkgd and/or Obs. Conc.
*** Indicates a Machine malfunction Appears in FI, FI Bkgd, Std. Dev, %CV, Obs. Conc., and/or Conc.in Range
[blank] No data Appears in any column except Analyte, Type and Well, Outlier and Dilution.

 

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand allcollapse all