Entering Raw Results in a Workbook

Forms	See also
MDE—Jobs Form MDE—OpenJobs Form	Finding Jobs using a Workbook Search Entering Weights and Volumes in a Workbook Entering Final Results in a Workbook List of data entry commands Capturing Data using On-line Data Capture Sessions Managing SPC Sessions Validating Results Analysing QC Performance Appendix - Program Settings Configuring the Data Entry Application

Overview

A CUID scheme analyte's Raw value requires correction for the CUID scheme's weight and/or volume, and used to determine the CUID scheme analyte's Final value.

Raw results are entered into workbook by the user or captured from an instrument where weight and volume corrections are not done.

This process is pertinent to laboratory operators who enter raw results captured from instrument or entered via the keyboard.

Process

Opening a Data Entry Session for Raw Results Entry

After Finding Jobs using a Workbook Search and Opening Jobs for a Workbook Session to present the schemes from those jobs, then select one or more schemes for the raw results data entry session.

Select the pages of samples to load for the data entry session. These pages include any quality control (QC) samples that were created for the job/s when concentration records and rack structure were created for the job. Note that, where more than one scheme is selected, then QC samples any cannot be loaded in the spreadsheet, and all samples are loaded because the inclusion of quality control samples and page size is an attribute of an individual scheme, and do not apply across schemes.

Open the data entry session in read-write mode to display the spreadsheet, and select to either display the data in default style with samples down the page and results across the page, or with analytes each row for each sample. This usually depends upon the number of analytes in the schemes.

Where the LIMS is configured to allow the simultaneous display of raw and final values in the spreadsheet, select whether or not to do this.

Scope a workbook session for raw results

When the workbook is opened in Raw results mode, three tabs are presented:

Results - Raw—A spreadsheet to enter raw values.
Dilutions—A spreadsheet to enter dilution factors.
Report—The reported values generated by the File Report option.

Interacting with a Spreadsheet

The spreadsheet is presented and interacted with similarly to Entering Final Results in a Workbook.

Raw to Final Calculations

Where the instrument produces results without using the default weights and volumes (for example, an instrument that measures mg/L in the test tube but not mg/g in the sample), then the LIMS is configured to determine a CUID scheme analyte's Final value as:

Final = Raw * (ExpWt/ActWt) * (ActVol / ExpVol) * ExpVol / ExpWt * AnalyteDil
Example: Final = 1730 * (0.25 / 0.26) * (250 / 250) * 250 / 0.25 * 1 = 1730 * 0.962 * 1 * 1000 * 1 = 1664200

Where the instrument produces results using the default weights and volumes (for example, the instrument measures mg/g in the sample, not mg/L in the test tube), then the LIMS is configured to determine a CUID scheme analyte's Final value as:

Final = Raw * (ExpWt/ActWt) * (ActVol / ExpVol) * AnalyteDil
Example: Final = 1730 * (0.25 / 0.26) * (250 / 250) * 1 = 1730 * 0.962 * 1 * 1 = 1664.201