Entering Final Results in a Workbook
Related Topics
Overview
A CUID scheme analyte's Final value is corrected for weight and/or volume, and used to determine the CUID scheme analyte's Formatted value.
Final results are entered into workbook by the user or captured from an instrument where all weight and volume corrections are done, or are not required.
Because the workbook is a spreadsheet where the cells are associated with CUID scheme analytes, the data string transmitted from an instrument does not necessarily have to contain sample information to tie the result to the CUID scheme analyte as it can place the data in the current cell, however, if the data string does contain sample details, then VBScript can be used to locate the correct cell for the data.
Defining from where the data is to come, the protocol (if any) to be used, and how the data is to be decoded, is managed by an Instrument Format File (IFF), located in the IFFScripts folder. The instrument format files contain VBScript language.
This process is pertinent to laboratory managers, supervisors and operators who enter final results and view final results.
Process
Opening a Data Entry Session for Final 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 final 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.
Scope a workbook session for final results
When the workbook is opened in Final results mode, three tabs are presented:
- Results - Final—A spreadsheet to enter final values.
- Dilutions—A spreadsheet to view dilution factors.
- Report—The reported values generated by the File Report option.
Interacting with a Spreadsheet
The spreadsheets presented in the data entry workbook are based on the F1Book grid. The interaction with the spreadsheet is similar to other spreadsheet applications. Where the LIMS is configured with barcode readers, a sample with a label is scanned to quickly position the cursor at the related cell in the spreadsheet.
Hide and show rows and columns to make it easier to see other content in the spreadsheet.
Hide and show rows and columns in the spreadsheet
Select the default font for the entire sheet, to suit your preference.
Select the default spreadsheet font
Where the spreadsheet is not opened in read-only mode, the format of the spreadsheet is adjustable. You can hide the current row or column, show a hidden row or column, change row height or column width, change cell alignment, change cell font, cell borders or background patterns. Formatting changes are not saved across workbook sessions.
By default, the sample details columns (CUID, sample type, sample ident, external ident, etc.) are locked in place so that the sample details are kept on view while analyte columns are scrolled. Where the spreadsheet is not opened in read-only mode, these columns can be toggled as locked/unlocked.
Marking Sample Schemes as Listed but Not Received for Analysis, Insufficient for Analysis, or Not Analysed
Mark a CUID scheme as listed but not received (LNR) where the sample is listed in the job scheme but no physical sample arrived for scheme analysis.
Mark a sample as listed for a scheme but not received
Mark a CUID scheme analyte as insufficient for analysis (IS) for the scheme analyte where there is not enough sample material to perform the analysis for the scheme.
Mark a sample as insufficient for analysis for a scheme analyte
Mark a CUID scheme analyte as not analysed (NA) for a scheme analyte where no result is determinable for the scheme.
Mark a sample as not analysed for a scheme analyte
Putting Samples on Hold for Analysis by a Scheme
Put samples on hold for analysis by a scheme where other processes must be completed prior to analysis, for example, a culture has to grow, a material has to cure, a certain temperature must be met.
Put samples on hold for analysis by a scheme
Unlocking Locked Cells
A cell is locked where:
- The CUID scheme analyte has a worklist status of quality failure high (QFH), quality failure low (QFL), quality warning high (QWH), quality warning low (QWL), listed but not received (LNR), insufficient sample (IS), or not analysed (NR).
- The LIMS is configured to lock cells for given analyte statuses and the CUID scheme analyte has one of those worklist statuses.
- The CUID scheme analyte has a formula.
Where a cell is locked due to it having a formula, the CUID scheme analyte's result can still have a QC failure ignored, or the result can still be validated.
Where a cell is locked due to a worklist status, then the cell worklist status cannot be changed.
Also, non-level 3 users cannot overwrite locked cells.
If you are a level 3 user and the LIMS is configured to allow cell unlocking, then unlock a cell to change its content. Depending on how the LIMS is configured, when a range of cells is selected for unlocking, then it may be that only cells that contain a LNR, IS or NA worklist status are unlocked, or call locked cells are unlocked.
Unlock one or more selected cells
Entering Data into the Spreadsheet
Final results are presented in spreadsheet as either:
- A constant value—A number, date-time, Boolean, error values, or text.
- A formula—Comprising constant values, cell references, names, functions, and operators that result in a new value when the formula is evaluated.
Note that a cell may be locked due to containing a formula or a restricted workflow status. The colour of a spreadsheet cell indicates the state of the underlying data.
Show the colour key for spreadsheet cells
If required, change a cell from a formula to a constant value.
Change a cell from a formula to a constant value
Where the LIMS is configured to show cell tips, turn cell tips on to display the expected value for a standard, blank or spike sample analyte, and the product limits display for a repeat, duplicate, reread or unknown sample in a cell's tip.
The data entered into a cell must match the analyte's Data type of NUM (Number), STR (String), DAT (Date), or OLE (Object linking and embedding).
Enter a sample result via the keyboard for a workbook session
Since the data entered into a cell must match the analyte's Data type (Number, String, Date or OLE), where a cell contains an analyte with a Data type of Numeric and the LIMS is configured to allow alphanumeric mode, then turn alphanumeric mode on to allow for the entry of alphanumeric data instead of numeric data. ( Otherwise only cells where the analyte's Data type is Date, OLE or String accept alphanumeric data).
Mark a cell dirty to force quality control re-assessments, required in situations where limits are changed.
Mark a cell dirty to force quality control re-assessments, required in situations where limits are changed.
Where CUID scheme analyte user note entry is configured, enter notes, as required, regardless of whether a cell is locked or unlocked.
Enter sample analyte user notes
Collecting Data from Instruments
The Data Entry application allows for the collection of data from instruments or files on the network.
The mode of the data from the instrument is presumed to be the same as that selected for the workbook session: final values.
Once an instrument is selected, the instrument format file (IFF) associated with the instrument is used to decode instrument transmission. The IFF name is displayed as the title of the child window within the Data Entry window. The red square on the status line indicates the initial state that no data is currently being collected.
Select the instrument for a workbook session
Once the instrument is selected, and the instrument is ready for transmission, start data capture.
Start data capture from a workbook session
After the instrument is started, it is interacted with to transmit results to CCLAS. The IFF is configured to manage:
- One-result-at-a-time manual transmission—Required where the instrument string contains no sample information. After a result is stored in a cell, the IFF may be configured to automatically advance the cursor to the next cell, and may be configured to jump over cells that already have a locked status (for example, NA, IS, LNR).
- Automatic transmission—Only possible where the instrument string contains enough information for CCLAS to determine the cell containing the CUID scheme analyte.
Capture a result from an instrument into the workbook
Once data transmissions are finalised, the instrument must be stopped to release the communication channel.
Stop data capture from a workbook session
Edit the IFF from an instrument data capture session
Formula Evaluations
Where formulas are set up on CUID scheme analytes, the cell's value is evaluated if all dependencies are available.
Microsoft Excel™-compatible formula can also be entered into cells during a workbook session. The formula is entered directly into the cell using a leading equals sign (=).
Spreadsheet functions can be used alone or included in a formula, and return data to the cell in which they are entered.
Formula cells are calculated automatically as data is entered.
Logical and error values are usually the result of a formula, although entering these values can be useful for testing formulas. The logical values that can be entered are TRUE and FALSE. The error values that can be entered are #N/A, #VALUE!, #REF!, #NULL!, #DIV/0!, #NUM!, and #NAME?.
Determining Results from Reread Samples
The best result, or a minimum, maximum or average of selected rereads can be used to determine the result of the unknown sample.
| Formula | Description |
|---|---|
|
Average |
Calculates the average value for the selected cells. |
|
Count |
Calculates the average value for the selected cells. |
|
CountIf |
calculates the number of rereads in the selected cells, but only if a cell contains a value >= 0. |
|
Min |
Calculates the non-zero minimum value for the selected cells. |
|
Max |
Calculates the non-zero maximum value for the selected cells. |
|
Sum |
Calculates the sum of values in the selected cells. |
|
SumIf |
Calculates the sum of values in the following cells, only if all values are non-zero. |
Calculate a workbook cell result from rereads
System Assessment of Detection Limits
A CUID scheme analyte's status indicates the quality and state of the result. Initially, when a sample is registered into CCLAS, a blank status is given to each profiled analyte.
Detection limit and upper scheme limits are assessed for unknown samples.
- Where a result is more than the upper limit for the scheme-analyte. then the result is given a CHK status indicating a check is required.
- Where the LIMS is configured to assess results against the lower detection limit and a result is less than the detection limit for the scheme-analyte, then the result is given a CHK status indicating a check is required.
- Where a cell contains a CHK status, then the cell is highlighted accordingly.
Regardless of the detection limit assessment, there are occasions where you consider a check of a CUID scheme analyte's result is required. This check of analysis can be by the same or by another scheme.
Mark a sample as requiring a check
System Assessment of Quality Control Limits
Quality control samples are checked against their expected limits. If an analytical result for a quality control sample falls outside of the quality control limits, warning flags are displayed. If the results are out of specification, the analyte status for the sample is set to either QC Failure - Too low (QFL), QC Warning - Low (QWL), QC Warning - High (QWH), or QC Failure - Too high (QFH).
System Assessment of Product Limits
Display the minimum and maximum product limits each analyte specified in the product to see the expected range of result.
Display product limits for a workbook cell
Check results against product limits to see how the sample performs for the scheme and analyte. Where the LIMS is configured with a product rule script for the scheme, then product limit checking includes running the script to perform custom logic.
Check sample results against product limits
Product rules are applied to schemes or scheme-analytes, such that, as data is entered, the data is only accepted where the rule passes.
Note: The scheme and analyte referred to in the rule does not have to be the same scheme and analyte of the current column.Column.Row. $Column$Row can be used to refer to a particular cell. If the Column.Row format is used in a validation rule, this is added as an item in the list of defined names.
Examples:
Rule: BAL1.WEIGHT1 < 20
Text: Initial weight should be less than 20.
Rule: WEIGHT2 > WEIGHT1
Text: Weight should be greater than the initial weight.
Rule: G.1 < 20
Text: Initial weight should be less than 20.
Rule: $G$1 < 20
Text: Initial weight should be less than 20.
Change product rules for a cell
Using Commands to Interact with the Data
Data in a workbook session can be manipulated by using the built-in data entry commands. This process attempts to refer to core commands where appropriate.
Data entry commands all have the syntax:
Command COMMAND [/qualifier] [argument]
where:
- Command is a single word or code to indicate the type of control action required. Commands are sometimes only applicable in certain data entry modes (for example, when entering sample weights). In most cases, the command can be abbreviated to a single letter, providing there is no ambiguity.
- /qualifier is used to activate special options available to the particular command.
- argument is a list of arguments passed to the command. In instances where no option is supplied, the default argument setting is used.
Execute a command for a workbook session
Result Validation
Once results are entered and are within the range of the scheme, that is, there are no detection limit failures, then the next step is result validation.
Result validation may be undertaken by the analyst, but more often by the supervisor, section head, or sometimes in a small laboratory, by the laboratory head.
Initially, when a sample is registered into CCLAS, a blank status is given to each profiled analyte.
For each analyte, with a numeric data type, that had data entered into it during the sample analysis session, if the analyte's result does not require a check due to exceeded detection limits, and analyte's Status Active flag is:
-
Enabled, then the analyte's Status for the sample is set to NVL (Not Validated), If the result is subsequently validated, then the analyte's Status is set to VAL (Validated), and upon saving of the validated result, the analyte's Status is set to CPL (Completed).
-
Disabled, then the analyte's Status for the sample is set to CPL (Completed) immediately.
Note that results are not reportable until the analyte's Status is CPL (Completed).
Refer to the Validating Results process.
Saving Results
If a result is manually entered, then the sample's cell background is highlighted until it is saved.
When the result entry is completed for the workbook session, save the data.
Each result entered or captured in final results mode is stored as the CUID scheme analyte's Final value and where the system is configured to do so, the CUID scheme analyte's Formatted value is calculated.
All changes to status flags, user notes, limit status, or any other field in the PROFJOB_CUID_SCHEME_ANALYTE table are audited.
Where the system is configured to do so, then the job status is updated after results are saved.
Save data for a workbook session
Printing a Spreadsheet
If required, an internal report or a Microsoft ExcelTM can be generated from spreadsheet contents to help monitor data, analysis and processing, for example:
- Sample test results, including interim results.
- Jobs in progress or of a particular status.
- Search results for a particular entity (such as a client, sample type, sample scheme analyte, report requests and so on).
- Financial results, including invoices and associated status.
The spreadsheet data can comprise validated and non-validated results. These actions do not update any status within the job. The output is placed in the Coll folder.
Generate an internal report of spreadsheet contents
Export spreadsheet contents to Excel
Access a Custom Form from Data Entry
Data entry registration often requires custom forms which are tailored to a laboratory's requirements. Where configured, these custom forms are run from the Command main menu.
Access a custom form from data entry
Ending a Data Entry Session
You can log out of a data entry session but keep the Pool Control and Security Manager running. This allows you to log back in to the data entry session without having to re-establish the connection. This method of logging in to CCLAS EL is used when the CCLAS EL Menu is not used to run CCLAS applications, and another user has logged out of the current session, but left the Data Entry application running.
Log out from a data entry session
Log back in to a data entry session
Multiple Data Entry Sessions
Multiple data entry session can be opened so that data can be entered for multiple jobs, or for a different set of schemes for the same job, simultaneously.
