Entering Results into Workbook Cells

• Entering Results into Workbook Cells
  • Overview
    • Working with Laboratory Batch Jobs in Workbook
  • Process
    • Entering Data
      • Data Mode
      • Workbook Scripts
      • Lower Panel
      • Using Formulas to Calculate Results
      • Capturing Data from an Instrument
      • QC History Update
      • Result Audit Trail
    • Entering Preparation Weights and Volumes
      • Restrictions on Entering a Preparation Weight
      • Restrictions on entering a Preparation Volume
    • Entering Dilutions
    • Entering Raw Results
      • Raw-to-Final Result Calculation
    • Entering Final Results
    • Readings
    • Applying LNR, IS, NA and NR Workflow Statuses
    • Deleting Results
    • Updating Analytical Details for a Sample Scheme Analyte
    • Updating Sample Scheme and Sample Scheme Analyte Result Notes
    • Updating Reporting Details for a Sample Scheme Analyte
    • Understanding the System Processes that Follow Result Entry

Overview

Workbook consists of a grid of sample scheme analytes, and customised menus with commands and options to enable you to work quickly and accurately with the data entered for those tests.

Use the grids to enter, edit and delete data into unlocked cells. You can cut, copy, paste and clear data and formulae into the cells.

You can select multiple cells (contiguous or non-contiguous) and enter data to be applied to all selected cells or execute a command (right click) or script on all the selected cells.

Workbook result entry allows for:

• The upload of documents and images to cells.
• The updating of analyte details.
• The viewing of individual readings associated with a cell.
• The aggregation of readings for a result.
• The automatic assessment of results against detection limits, scheme limits, product specifications, QC standard limits and precision limits, and highlight warnings and failures on the grid, which updates and displays specification, QC and workflow statuses.
• The entry of user QC statuses and user workflow statuses.
• The release of results to indicate that the operator has finished working upon them, and that they are ready for validation.
• The validation of results to indicate that the results are now complete and ready for sample and job validation, and subsequent reporting.
• The auditing of result entry. When a result is captured in a workbook, the current user and laboratory date-time is recorded and displayed in the sample scheme analyte reading, and in the audit trail. Changes made to a laboratory batch sample or QC sample in workbook are audited in both the laboratory batch job and the original production job.

When invalid data type entries are made, then an error message displays in the Formula Error Bar. This includes:

• A string entry where a numeric value is expected
• Where a date format does not match the expected format
• Entries do not match the expected boolean format
• Entries that do not exist for a presented drop-down selection list.

Working with Laboratory Batch Jobs in Workbook

Data is entered into a laboratory batch job in the same way as for any other type of job.

When a laboratory batch job is opened in workbook, the sample scheme analytes associated with the laboratory batch job are displayed in the workbook.

A parent job is the original job from where a laboratory batch samples came from.

• Any unknown or QC sample that was selected for inclusion in the laboratory batch job have their parent job as the production job.
• Any QC sample created when the batch was created or added by QC sample maintenance on the laboratory batch job have their parent job as the laboratory batch job.

When a result is entered for a sample scheme analyte in context of a laboratory batch job being opened in the CCWKOP—Workbook Open application, then the cascade engine:

• Cascades both up the laboratory batch job tree and the associated production job tree.
• Respects that, until the laboratory batch job is validated, the production sample scheme's Workflow Status cannot progress past Released, that is, it can only move to Completed once the laboratory batch job is validated. This ensures that all QC assessments are passed and the laboratory batch job is validated as being a true and correct analysis before that result is considered complete.

If a sample scheme analyte is de-linked from the laboratory batch job, or does not exist for that combination of sample scheme analyte within the laboratory batch job, then the cell background is highlighted dark grey indicating that the cell is not associated with the laboratory batch job, so therefore cannot be updated.

Process

Opening a Workbook Session in normal mode displays the CCWKOP—Workbook Open Detail screen, and in transposed mode displays the CCWKOP—Workbook Open Transposed Detail screen.

Refer to Using the Workbook Grid.

Entering Data

Data Mode

For any cell, the workbook session's selected Data Mode and the sample scheme analyte's Data Type denotes which data is displayed in the grid and which sample scheme analyte property is updated when content is entered.

Some analytical processes require that a portion of sample is weighed and digested in a solution so that it can be analysed. Where this occurs, the sample weight and volume of solution is important. If a method specifies the exact weight of sample that should be taken, within a practical tolerance, and the exact volume of solution that should be used, within a practical tolerance, that should be used to derive a result, then any deviation from these amounts need to effect the calculation used to determine the final result.

When a raw result is determined, it means that the weight of sample and volume of solution has not yet been considered, therefore, the final result is an adjustment of the raw result using the actual weight and volume and expected weight and volume.

The process to work with raw results involves configuring the expected weights and volumes of unknown and standard samples, entering or capturing sample weights and volumes in a weight-volume workbook session, then entering or capturing raw results for those samples in a raw results workbook session, upon which, the final results are calculated.

Workbook Scripts

When a workbook is opened, a cell's content is changed and after any update is persisted, then the related event script, first from the generic workbook script (defined by the WORKBOOK_SCRIPT application preference), and then from the scheme workbook script for each scheme opened in the workbook, in the order in which the schemes are displayed in the workbook, are run to perform custom logic.

Workbook event scripts can be used to display various details of the selected sample scheme analyte/s in the application status bar or lower panel (if it is displayed), or used to execute post-change functionality on other cells. Refer to the Workbook API.

Lower Panel

When a cell is selected, then the sample, sample scheme and sample scheme analyte details associated with the cell are used to populate the lower panel, if the lower panel is displayed. Refer to Managing a Workbook Session to toggle showing or hiding the analysis detail lower panel.

• Conditions for Executing Workbook Scripts on Result Entry

Using Formulas to Calculate Results

Calculations and QC are assessed for related samples when data is entered for a sample ensuring that those calculations and statuses are correct regardless of the order in which the results are entered. For example, when a result is entered for a sample, related samples are assessed for QC and have their percent difference, relative percent difference and recovery re-calculated and statuses evaluated.

Refer to Using Formulas to Calculate Results.

Capturing Data from an Instrument

While it is possible to enter data manually into the workbook cells, typically these would come in from instruments (for example a balance or an atomic absorption machine). This is controlled by custom scripts.

QC History Update

Any update to a QC sample scheme analyte's Workflow Status is persisted to the associated QC history observation.

Result Audit Trail

When a result is captured in a workbook, the result and logged in user is recorded in the sample scheme analyte reading record. The sample scheme analyte reading is affectively the audit trail for the sample scheme analyte.

Entering Preparation Weights and Volumes

When the workbook session is opened with a Data Mode of Weight/Volume, then only analytes with a Code of WEIGHT or VOLUME, or where the scheme version analyte's Analyte Type is PREPARATION OTHER can be opened in the workbook.

Note: Even though a weight-type analyte has an Analyte Type of PREPARATION WEIGHT, workbook determines it is a weight-type analyte by the analyte's Code being WEIGHT.

The following table shows the sample scheme analyte property that is updated upon result entry followed by submit.

Type of Result	Data Type	Sample Scheme Analyte Property
Weight	Numeric Only	numericFinalValue
Volume	Numeric Only	numericFinalValue
Preparation other	Numeric Only	numericFinalValue
	Numeric	numericFinalValue
	Text	textValue
	Boolean	booleanValue
	Date	dateTimeValue
	Datetime	dateTimeValue
	Image	imageFieldId
	Document	documentFileId

Enter a value in weight/volume mode

Refer to:

• Conditions for Weight and Volume Propagation

• Using Linked Schemes to Share Weights and Volumes

A weight and volume result must be able to be interpreted as a numeric value, otherwise it is rejected.

Restrictions on Entering a Preparation Weight

These are specific limits that are applied to the sample weight and volumes, as part of the analytical preparation stage. When weighting and digesting samples for analysis, weight and volume limits that are defined on the scheme version are used to control the entry of results. These limits can be different limits for unknown samples and QC samples (blank, standard, spike QC samples).

Refer to the Effect of Scheme Scope upon Entering Weights and Volumes in Workbook.

Given that a sample with a Primary Analytical Type of Unknown, Duplicate, Replicate or Spike is analysed for an analyte that has an Analyte Type of Preparation Weight, when a result is received:

• If the scheme version's Sample Minimum Weight is defined and the result is below the Sample Minimum Weight and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Above and Below Weights Allowed or Below Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the low weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Above Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too low and you do not have the permission to accept a low weight.
• If the scheme version's Sample Maximum Weight is defined and the result is above the Standard Maximum Weight and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Above and Below Weights Allowed or Above Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the high weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Below Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too high and you do not have the permission to accept a high weight.
• If the scheme version's Sample Minimum Weight nor the Sample Maximum Weight are defined, but the Sample Target Weight and Sample Weight Tolerance are defined, and the result is below the Sample Target Weight—Sample Target Weight x Sample Weight Tolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Above and Below Weights Allowed or Below Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the low weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and scheme version's Sample Weight Allowance is set to Above Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too low and you do not have the permission to accept a low weight.
• If the Scheme Version's Sample Maximum Weight nor the Sample Maximum Weight are defined, but the Sample Target Weight and Sample Weight Tolerance are defined, and the result is above the Sample Target Weight + Sample Target Weight x Sample Weight Tolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Above and Below Weights Allowed or Above Weights Only Allowed, then a dialog box displaying the acceptable limits prompts for a confirmation to accept the high weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Sample Weight Allowance is set to Below Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too high and you do not have the permission to accept a high weight.

Given that a sample with a Primary Analytical Type of Blank or Standard is analysed for an analyte that has an Analyte Type of Preparation Weight, when a result is received:

• If the scheme version's Standard Minimum Weight is defined and the result is below the Standard Minimum Weight and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above and Below Weights Allowed or Below Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the low weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too low and you do not have the permission to accept a low weight.
• If the scheme version's Standard Maximum Weight is defined and the result is above the Standard Maximum Weight and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above and Below Weights Allowed or Above Weights Only Allowed then a dialog box displays the acceptable limits and prompts for a confirmation to accept the high weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Below Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too high and you do not have the permission to accept a high weight.
• If the scheme version's Standard Minimum Weight nor the Standard Maximum Weight are defined, but the Standard Target Weight and Standard Weight Tolerance are defined, and the result is below the Standard Target Weight—Standard Target Weight x Standard Weight Tolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above and Below Weights Allowed or Below Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the low weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too low and you do not have the permission to accept a low weight.
• If the scheme version's Standard Maximum Weight nor the Standard Maximum Weight are defined, but the Standard Target Weight and Standard Weight Tolerance are defined, and the result is above the Standard Target Weight + Standard Target Weight x Standard Weight Tolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Above and Below Weights Allowed or Above Weights Only Allowed, then a dialog box displays the acceptable limits and prompts for a confirmation to accept the high weight
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected and the scheme version's Standard Weight Allowance is set to Below Weights Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the weight result is rejected as is too high and you do not have the permission to accept a high weight.

Restrictions on entering a Preparation Volume

Given that a sample with a Primary Analytical Type of Unknown, Duplicate, Replicate or Spike is analysed for an analyte that has an Analyte Type of Preparation Volume, when a result is received:

• If the scheme version's Sample Minimum Volume is defined and the result is below the Sample Minimum Volume and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above and Below Volumes Allowed or Below Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the low volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too low and you do not have the permission to accept a low volume.
• If the scheme version's Sample Maximum Volume is defined and the result is above the Sample Maximum Volume and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above and Below Volumes Allowed or Above Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the high volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Below Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too high and you do not have the permission to accept a high volume.
• If the scheme version's Sample Minimum Volume nor the Sample Maximum Volume are defined, but the Sample Target Volume and Sample VolumeTolerance are defined, and the result is below the Sample Target Volume- Sample Target Volumex Sample VolumeTolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above and Below Volumes Allowed or Below Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the low volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too low and you do not have the permission to accept a low volume.
• If the scheme version's Sample Maximum Volume nor the Sample Maximum Volume are defined, but the Sample Target Volume and Sample VolumeTolerance are defined, and the result is above the Sample Target Volume+ Sample Target Volumex Sample VolumeTolerance and::
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Above and Below Volumes Allowed or Above Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the high volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Sample VolumeAllowance is set to Below Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too high and you do not have the permission to accept a high volume.

Given that a sample with a Primary Analytical Type of Standard or Blank is analysed for an Analyte that has an Analyte Type of Preparation Volume, when a result is received:

• If the scheme version's Standard Minimum Volume is defined and the result is below the Standard Minimum Volume and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above and Below Volumes Allowed or Below Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the low volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too low and you do not have the permission to accept a low volume.
• If the scheme version's Standard Maximum Volume is defined and the result is above the Standard Maximum Volume and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above and Below Volumes Allowed or Above Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the high volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Below Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too high and you do not have the permission to accept a high volume.
• If the scheme version's Standard Minimum Volume nor the Standard Maximum Volume are defined, but the Standard Target Volume and Standard VolumeTolerance are defined, and the result is below the Standard Target Volume- Standard Target Volumex Standard VolumeTolerance and:
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above and Below Volumes Allowed or Below Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the low volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too low and you do not have the permission to accept a low volume.
• If the scheme version's Standard Maximum Volume nor the Standard Maximum Volume are defined, but the Standard Target Volume and Standard VolumeTolerance are defined, and the result is above the Standard Target Volume+ Standard Target Volumex Standard VolumeTolerance and::
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Above and Below Volumes Allowed or Above Volumes Only Allowed, then a dialog box prompts for a confirmation to accept the high volume
  • the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is defined and selected, and the scheme version's Standard VolumeAllowance is set to Below Volumes Only Allowed or Not Allowed, or the ALLOW_ACCEPT_OUT_OF_RANGE_WEIGHTS_AND_VOLUMES application preference is not defined, or is defined and is not checked, then the volume result is rejected as is too high and you do not have the permission to accept a high volume.

Entering Dilutions

When the workbook session is opened with a Data Mode of Dilution, then only analytes where the scheme version analyte's Analyte Type is PREPARATION OTHER or ANALYTICAL can be opened in the workbook.

When the workbook grid is displayed, any cell where the scheme version analyte's Analyte Data Type is Text, Boolean, Date, Datetime, Image or Document is read-only and cannot be unlocked using any unlock cell option.

The following table shows the sample scheme analyte property that is updated upon result entry followed by submit.

Type of Result	Data Type	Sample Scheme Analyte Property
Dilution	Numeric Only	dilutionFactor

Enter a value in dilution mode

A dilution result must be able to be interpreted as a numeric value, otherwise it is rejected.

The sample scheme analyte's Numeric Final Result, Weight, Volume, Dilution and Instrument Factor are used to determine the sample scheme analyte's Numeric Raw Result. Refer to entering a value in raw results mode to view the raw-to-final calculations.

If the sample scheme analyte's Dilution Factor already exists for a sample scheme analyte, then it is overwritten with the new value (and if the dilution factor is cleared on the workbook then the sample scheme analyte's Dilution Factor is cleared), although the sample scheme analyte's Numeric Final Value is not recalculated until a new Numeric Raw Value is entered in a raw result mode workbook session.

Entering Raw Results

When the workbook session is opened with a Data Mode of Raw Results Mode, then only analytes where the scheme version analyte's Analyte Type is PREPARATION OTHER or ANALYTICAL can be opened in the workbook.

When the workbook grid is displayed, any cell where the scheme version analyte's Analyte Type is PREPARATION OTHER or the scheme version analyte's Analyte Data Type is Text, Boolean, Date, Datetime, Image or Document is read-only and cannot be unlocked using any unlock cell option.

The following table shows the sample scheme analyte property that is updated upon result entry followed by submit.

Type of Result	Data Type	Sample Scheme Analyte Property
Analytical result	Numeric Only	numericRawValue
	Numeric	numericRawValue
	Text	textValue
	Boolean	booleanValue
	Date	dateTimeValue
	Datetime	dateTimeValue
	Image	imageFileID
	Document	documentFileID

Enter a value in raw results mode

The raw-to-final result calculation is done to determine the sample scheme analyte's Numeric Final Value.

When a sample scheme analyte is analysed and there are no critical detection limit failures, the sample scheme analyte's Workflow Status is set to Analysed, and the Analysed Date and Analysed By is set to the laboratory's current date-time and the current user, respectively.

When a sample scheme analyte is analysed and there are critical detection limit failures then the sample scheme analyte's Workflow Status is set to Check. Refer to Assessing Results against Detection Limits.

When a sample scheme analyte's Composite Specification Status, Composite QC Status or Workflow Status is updated, then the cascade engine re-evaluates these statuses up the respective production and/or laboratory batch job trees. Refer to Appendix—Cascade Engine.

Refer to :

• Conditions for Auto-calculation of Ready Dates

• Conditions for Calculating Expiry and Warning Dates

• Conditions for Auto-Validation when the Product Passes Specification
• Conditions for Auto-addition of Samples and Tests to a Job Invoice

Raw-to-Final Result Calculation

A raw-to-final correction is not applied where any of the following are true:

• The scheme's Correction Applied flag is cleared.
• The scheme version analyte's Apply Correction Factor flag is cleared.
• The scheme version analyte's Analyte Type is something other than Analytical.
• The scheme version analyte's Analyte Data Type is something other than Numeric or Numeric Only.
• The sample scheme analyte's Numeric Final Value is not defined, that is, the result is not numeric but some other data type.

Where a correction is not applied, then a sample scheme analyte's Numeric Raw Value becomes the sample scheme analyte's Numeric Final Value:

If a correction is applied, then the following correction factors are determined:

• Weight correction factor:

  If the sample' Primary Analytical Type is Unknown, Duplicate or Replicate, then the expected weight is the scheme version's Sample Target Weight.

  If the sample' Primary Analytical Type is Blank or Spike, then the expected weight is the scheme version's Standard Target Weight.

  The weight correction factor is 1 if any of the following are true:

  • The expected weight is 0 or undefined.
  • The sample scheme analyte's Weight is empty, not numeric, or is 0.

  Otherwise the weight correction factor is determined as follows:

  weight correction factor = expected weight / sample scheme analyte's Weight

• Volume correction factor:

  If the sample' Primary Analytical Type is Unknown, Duplicate or Replicate, then the expected volume is the scheme version's Sample Target Volume.

  If the sample' Primary Analytical Type is Blank or Spike, then the expected volume is the scheme version's Standard Target Volume.

  The volume correction factor is 1 if any of the following are true:

  • The expected volume is 0 or undefined.
  • The sample scheme analyte's Volume is empty, not numeric, or is 0.

  Otherwise the volume correction factor is determined as follows:

  volume correction factor = sample scheme analyte's Volume / expected volume

• Dilution factor:

  The dilution factor is the sample scheme analyte's Dilution Factor.

  If the sample scheme analyte's Dilution Factor is empty, then the dilution factor is 1.

• Instrument correction factor:

  The instrument factor is the sample scheme analyte reading's Instrument Factor (for the current reading).

  If the sample scheme analyte reading's Instrument Factor is empty, then the instrument factor is 1.

Where a correction is applied, then a sample scheme analyte's Numeric Raw Value and correction factors are used to produce the sample scheme analyte's Numeric Final Value:

numeric final value = numeric raw value x weight correction factor x volume correction factor x dilution factor x instrument factor

Entering Final Results

When the workbook session is opened with a Data Mode of Final Results Mode, then only analytes where the scheme version analyte's Analyte Type is PREPARATION OTHER or ANALYTICAL can be opened in the workbook.

When the workbook grid is displayed, any cell where the scheme version analyte's Analyte Type is PREPARATION OTHER is read-only and cannot be unlocked using any unlock cell option.

The following table shows the sample scheme analyte property that is updated upon result entry followed by submit.

Type of Result	Data Type	Sample Scheme Analyte Property
Analytical result	Numeric Only	numericFinalValue
	Numeric	numericFinalValue
	Text	textValue
	Boolean	booleanValue
	Date	dateTimeValue
	Datetime	dateTimeValue
	Image	imageFileID
	Document	documentFileID

Enter a value in final results mode

Where a list of values is configured for a scheme version analyte, then the value can be selected from the list. If the first value in the list was selected to be the default, but it is inactive, then the first active value is taken as the default result for the analyte in workbook. Only active list items are available for selection. If there are no active items in the list, then no drop-down list is available in workbook.

An image can be uploaded into a workbook cell, such that:

• When the scheme version analyte's Data Type is Image, then the result is in the format of an image, and it is only when an image is uploaded that the sample scheme analyte's Workflow Status is set to Analysed.

• When the scheme version analyte's Data Type is Numeric Only, Numeric, Text, Boolean, Date, Datetime or Document, then there is no impact upon the sample scheme analyte's Workflow Status, but the image is purely associated with the sample scheme analyte.

Maintain an image on a non-image cell

A document can be uploaded into a workbook cell, such that:

• When the scheme version analyte's Data Type is Document, then the result is in the format of a document, and it is only when a document is uploaded that the sample scheme analyte's Workflow Status is set to Analysed.

• When the scheme version analyte's Data Type is Numeric Only, Numeric, Text, Boolean, Date, Datetime or Image, then there is no impact upon the sample scheme analyte's Workflow Status, but the document is purely associated with the sample scheme analyte.

Maintain a document on a non-document cell

When a result is entered for an analyte where the scheme version analyte's Analyte Data Type is:

• Numeric Only or Numeric, then the sample scheme analyte's Weight, Volume, Dilution and Instrument Factor remain, however the sample scheme analyte's Numeric Raw Result is cleared. Refer to entering a value in raw results mode to view the raw-to-final calculations.

  To only allow a numeric result to be entered into a cell where the sample scheme analyte's Analyte Data Type is Numeric, then alpha-numeric entry can be toggled off.

  Set alphanumeric entry on/off

• Text, then leading and trailing spaces are not removed upon cell exit but are removed upon submit. Therefore, if a list of expected results in an applied specification contains "DEF" and not "DEF " for a text analyte, and "DEF " is entered into the cell, then upon cell exit, the cell is flagged red to show a failed specification assessment. However, upon submit, leading and trailing spaces are removed, so "DEF" is persisted, such that, upon workbook reload, if the cell undergoes Force Reassessment, then the cell shows a passed specification assessment.

  A text value can also be updated via the lower panel.

  Update a string value via the lower panel

  Refer to toggling the showing and hiding of the analysis detail lower panel when Using the Workbook Grid.

• Boolean, where the sample scheme analyte's Boolean Value is set to true or false, then the Numeric Final Value is set to 1 or 0, respectively. It is the Numeric Final Value that is seen in the Formula/Value Bar when this cell is selected.

• Date, then the result must also be able to be interpreted as a date, otherwise it is rejected.

• Datetime, then the result must also be able to be interpreted as a date and time, otherwise it is rejected.

• Image, then the image is uploaded into EFS and sample scheme analyte Image Value is set to the link to the document in EFS.

• Document, then the document is uploaded into EFS and sample scheme analyte Document Value is set to the link to the document in EFS.

When a sample scheme analyte is analysed and there are no critical detection limit failures, the sample scheme analyte's Workflow Status is set to Analysed, and the Analysed Date and Analysed By is set to the laboratory's current date-time and the current user, respectively.

When a sample scheme analyte is analysed and there are critical detection limit failures then the sample scheme analyte's Workflow Status is set to Check. Refer to Assessing Results against Detection Limits.

When a sample scheme analyte's Composite Specification Status, Composite QC Status or Workflow Status is updated, then the cascade engine re-evaluates these statuses up the respective production and/or laboratory batch job trees. Refer to Appendix—Cascade Engine.

Refer to :

• Conditions for Auto-calculation of Ready Dates

• Conditions for Calculating Expiry and Warning Dates

• Conditions for Auto-Validation when the Product Passes Specification
• Conditions for Auto-addition of Samples and Tests to a Job Invoice

Readings

Where required, the readings, that is, the individual result entries for a sample scheme analyte, can be viewed.

When a reading is created in a workbook session, for any Data Mode (Final results mode, Weight/Volume mode, Dilution mode or Raw results mode), and the current cell's sample scheme analyte has an Analyte Type of Analytical, PrepWt, PrepVol or PrepOther, then:

• The sample scheme analyte reading is linked to the sample scheme analyte.
• The Reading Sequence is set to the next sequence number.
• Is Active is set to checked, but is updatable via an aggregation script.
• Instrument Lab Code, Instrument Code and Instrument Factor are set via the instrument capture process.

Note: When results are captured from instruments, the system preserves the value of the instrument code found in the lower panel of Workbook under the Instrument Code column even if those results are later re-entered or recalculated. This value is also stored in CCQCHS - Update QC History Summary under the Instrument Code column. The instrument code retention can be disabled via Workbook Script. If disabled, then any new results will not be linked to the original Instrument Code.

• Creation Date, Creation Time and Creation User are set to the laboratory's current date, time and user, respectively.
• Last Mod Date, Last Mod Time and Last Mod User are set to the laboratory's current date, time and user, respectively.
• The following attributes are inherited from the sample scheme analyte:
  • Organisation Code, Laboratory Code
  • Job Code, Sample Code
  • Laboratory Batch Job Code, Laboratory Batch Sample Code
  • Scheme Laboratory Code, Scheme Code, Scheme Version Number, Analyte Code
  • Spreadsheet Formula
  • Dilution Factor, Weight, Volume, Composite Correction Factor
  • Current Data Type
  • Unit
  • Numeric Raw Value, Numeric Final Value, Date Time Value, Text Value (including i18n)

    Note: Boolean values are stored in the Numeric Final Value.

  • Analysed By User
  • Internal Detection Limit Status
  • Limit Status
  • Standard Status
  • Precision Status
  • Specification Status
  • Composite Spec Status, Composite QC Status, Workflow Status
  • User QC Status, User Workflow Status
  • QC Ignored Date, QC Ignored User
  • Param 1-5 Name, Param 1-5 Value

View readings

In final results mode, the sample scheme analyte related to the first selected cell, where the cell is numeric-only or numeric, can have its readings aggregated and saved as another reading.

Aggregate readings

Refer to:

• Conditions for Calculating Results from Multiple Readings
• Conditions for Executing Workbook Scripts on Result Entry

When a workbook session is opened in any mode (Final, Wt/Vol, Dilution or Raw), and the current cell's sample scheme analyte has an Analyte Type of Analytical, PrepWt, PrepVol or PrepOther, and a change is made to the cell's result in which a sample scheme analyte reading is created, then the sample scheme analyte reading's values are set as follows:

• SSAR.AnalysedByUserCode = SSA.AnalysedByUserCode
• SSAR.AnalysedByUserId = SSA.AnalysedByUserId
• SSAR.AnalysedDate = SSA.AnalysedDate
• SSAR.AnalyteCode = SSA.AnalyteCode
• SSAR.BooleanValue = SSA.BooleanValue
• SSAR.CompositeCorrectionFactor = SSA.CompositeCorrectionFactor
• SSAR.CompositeQcStatus = SSA.CompositeQcStatus
• SSAR.CompositeSpecStatus = SSA.CompositeSpecStatus
• SSAR.CreationDate = <Logged in Lab's current date>
• SSAR.CreationTime = <Logged in Lab's current time>
• SSAR.CreationUser = <Current logged in user>
• SSAR.CurrentDataType = SSA.CurrentDataType
• SSAR.DateTimeValue = SSA.DateTimeValue
• SSAR.DilutionFactor = SSA.DilutionFactor
• SSAR.InstrumentCode = <via Instrument Capture process>
• SSAR.InstrumentFactor = <via Instrument Capture process>
• SSAR.InstrumentLabCode = <via Instrument Capture process>
• SSAR.IntDetLimitStatus = SSA.IntDetLimitStatus
• SSAR.IsActive = <defaulted to 'Yes' but update-able via script for the aggregation feature>
• SSAR.JobCode = SSA.JobCode
• SSAR.LaboratoryCode = SSA.LaboratoryCode
• SSAR.LabBatchJobCode = SSA.LabBatchJobCode
• SSAR.LabBatchSampleCode = SSA.LabBatchSampleCode
• SSAR.LastModDate = <Logged in Lab's current date>
• SSAR.LastModTime = <Logged in Lab's current time>
• SSAR.LastModUser = <Current logged in user>
• SSAR.LimitStatus = SSA.LimitStatus
• SSAR.NumericFinalValue = SSA.NumericFinalValue
• SSAR.NumericRawValue = SSA.NumericRawValue
• SSAR.OrganisationCode = SSA.OrganisationCode
• SSAR.Param1Name = SSA.Param1Name
• SSAR.Param1Value = SSA.Param1Value
• SSAR.Param2Name = SSA.Param2Name
• SSAR.Param2Value = SSA.Param2Value
• SSAR.Param3Name = SSA.Param3Name
• SSAR.Param3Value = SSA.Param3Value
• SSAR.Param4Name = SSA.Param4Name
• SSAR.Param4Value = SSA.Param4Value
• SSAR.Param5Name = SSA.Param5Name
• SSAR.Param5Value = SSA.Param5Value
• SSAR.PrecisionStatus = SSA.PrecisionStatus
• SSAR.QcIgnoredDate = SSA.QcIgnoredDate
• SSAR.QcIgnoredUserCode = SSA.QcIgnoredUserCode
• SSAR.QcIgnoredUserId = SSA.QcIgnoredUserId
• SSAR.ReadingSequence = <not applicable to SSA, see B-01963>
• SSAR.SampleCode = SSA.SampleCode
• SSAR.SampleId = sample.Id
• SSAR.SampleSchemeAnalyteId = sample scheme analyte.Id
• SSAR.SchemeCode = SSA.SchemeCode
• SSAR.SchemeLabCode = SSA.SchemeLaboratoryCode
• SSAR.SchemeVersionNumber = SSA.SchemeVersionNumber
• SSAR.SpecificationStatus = SSA.SpecificationStatus
• SSAR.SpreadsheetFormula = SSA.SpreadsheetFormula
• SSAR.StandardStatus = SSA.StandardStatus
• SSAR.TextValue = SSA.TextValue (includes i18n)
• SSAR.UnitId = SSA.UnitId
• SSAR.UserQcStatus = SSA.UserQcStatus
• SSAR.UserWorkflowStatus = SSA.UserWorkflowStatus
• SSAR.Volume = SSA.Volume
• SSAR.Weight = SSA.Weight
• SSAR.WorkflowStatus = SSA.WorkflowStatus

Applying LNR, IS, NA and NR Workflow Statuses

Where required, a sample scheme analyte's Workflow Status can be changed to Listed Not Received, Insufficient Sample, Not Analysed or No Result, or reset to Not Started.

Set workbook cells to LNR, IS, NA, NR or not started

Refer to:

• Restrictions on Setting Samples to LNR, IS, NA or NR
• Conditions for Calculating Expiry and Warning Dates
• Conditions for Auto-calculation of Ready Dates

Although workbook cells are highlighted according to the selected status and may be locked, new statuses are not persisted until submit. When a workbook cell is locked, then new results cannot be entered into the cell, and specification or QC evaluation does not occur.

Note: If a sample, sample scheme or sample scheme analyte has a Workflow Status of Listed Not Received, Insufficient Sample, Not Analysed or No Result and it is copied as part of a sample copy, or QC sample creation, then the new sample, sample scheme or sample scheme analyte's Workflow Status defaults to the source sample, sample scheme and sample scheme analyte's Workflow Status, respectively.

Note: When Creating Production Jobs from Template Jobs or Registering Jobs from other Registered Jobs, then the gridded sample schemes or sample scheme analytes are inherited into the new job.

When setting to LNR:

• For each selected cell, given that the cell is not empty and has registered sample scheme analyte in it, and that sample scheme analyte's Workflow Status is Not Started, Insufficient Sample, Not Analysed or No Result for that sample scheme analyte or for any sample scheme analyte affected by the LNR, then the sample scheme analyte is set to LNR.

• When a sample scheme analyte is 'set to LNR', the sample scheme analyte's Workflow Status is set to Listed Not Received, its Completed Date is stamped and Completed By is set to the current user, and Internal DL Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Required.

• When a sample, sample scheme or sample scheme analyte is set to LNR, then it is not invoiceable.

• When a sample scheme analyte associated with an unknown sample is set to LNR, then its own sample tree is set to LNR, and any children tree, that is, for related duplicate, replicate and spike QC samples, is set to LNR.

• When a sample scheme analyte associated with a duplicate QC sample is set to LNR, then its own sample tree is set to LNR, and any children tree, that is, for related replicate and spike QC samples, is set to LNR, however, the related parent unknown sample tree is NOT set to LNR.

• When a sample scheme analyte associated with a replicate or spike QC sample is set to LNR, then its own sample tree is set to LNR, however, the related parent unknown or duplicate sample tree is NOT set to LNR.

• Conditions for Setting Sample Schemes and Analytes to Listed Not Received

When setting to IS, NA or NR:

• For each selected cell, given that the cell is not empty and has a registered sample scheme analyte in it, and that the sample scheme analyte's Workflow Status is something other than Listed Not Received, then the sample scheme analyte is set to IS, NA or NR.

• When a sample scheme analyte is 'set to IS', the sample scheme analyte's Workflow Status is set to Insufficient Sample, its Completed Date is stamped and Completed By is set to the current user, and Internal DL Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Required.

• When a sample scheme analyte is 'set to NA', the sample scheme analyte's Workflow Status is set to Not Analysed, its Completed Date is stamped and Completed By is set to the current user, and Internal DL Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Required.

• When a sample scheme analyte is 'set to NR', the sample scheme analyte's Workflow Status is set to No Result, its Completed Date is stamped and Completed By is set to the current user, and Internal DL Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Required.

• When a sample, sample scheme or sample scheme analyte is set to IS or NA then it is not invoiceable.

• When a sample, sample scheme or sample scheme analyte is set to NR then it is still invoiceable.

• When a QC sample is set to IS, NA or NR then the QC history's Is Active check box is cleared automatically for the associated discrete observation in the CCQCHS—QC History application.

When resetting to Not Started:

• For each selected cell, given that the cell is not empty and has a registered entity in it, and that each sample scheme analyte associated with the cell has a Workflow Status of Listed Not Received, Insufficient Sample, Not Analysed or No Result, then each sample scheme analyte is reset to have a Workflow Status of Not Started.

• When a sample scheme analyte's Workflow Status is set to Not Started, and it originally had a Workflow Status of Listed Not Received, Insufficient Sample, Not Analysed or No Result but the Numeric Final Value was empty, then the sample scheme analyte's Detection Limit Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Tested, and its Analysed Date, QC Ignored Date, Released Date, Started Date, Completed Date, First Reported Date, Last Reported Date and Last Invoiced Date are unstamped and Analysed By User, QC Ignored By User, Released By User and Completed By User are cleared.

• Note that although the original setting a Workflow Status of Listed Not Received on an unknown sample also set Listed Not Received on related QC samples, this is not the case when an unknown sample is reset, as in this case, only the unknown sample is reset.

• When a sample scheme analyte's Workflow Status is set to Not Started, and it originally had a Workflow Status of Insufficient Sample, Not Analysed or No Result but the Numeric Final Value was NOT empty, then the sample scheme analyte's Detection Limit Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set by the outcome of QC re-assessment.

• Any analytes with an Analyte Code of WEIGHT or VOLUME in linked sample schemes has its Numeric Final Value cleared and Workflow Status set to Not Started (regardless of whether it was No Result, Insufficient Sample or Not Analysed since linked sample scheme analytes are typically in sync with each other), and any analyte in the current and linked sample schemes where its Numeric Final Value is empty has its Weight or Volume property cleared also.

• When the cascade engine cascades the Not Started up to sample level, the sample's Workflow Status is reset to Not Started even if it was originally Registered prior to the initial action of setting Listed Not Received, Insufficient Sample, Not Analysed or No Result.

Deleting Results

A sample scheme analyte's result can be deleted. This actually writes another sample scheme analyte reading containing a not started result.

Delete values in workbook cells

Refer to:

• Conditions for Calculating Expiry and Warning Dates
• Conditions for Auto-calculation of Ready Dates
• Conditions for Executing Workbook Scripts on Result Entry

When a result is deleted:

• Each sample scheme analyte has its result cleared, that is Numeric Raw Value, Numeric Final Value, Boolean Value, Date Time Value, Text Value and Formatted Final Value are cleared.

• Where the cell contained a result but the sample scheme analyte's Workflow Status was Insufficient Sample, Not Analysed or No Result, then the result is cleared but the Workflow Status remains unchanged. Note that results cannot be entered where a sample scheme analyte's Workflow Status is Listed Not Received.

• Where the cell contained a result but the sample scheme analyte's Workflow Status was Repeat, Check, Analysed, Released or Completed, then the result is cleared and the Workflow Status is set to Not Started.

• When a sample scheme analyte's result is cleared, then the outcomes of previous QC assessments are cleared, that is, the sample scheme analyte's Detection Limit Status, Scheme Limit Status, Standard Status, Precision Status, Specification Status, Composite Specification Status and Composite QC Status are set to Not Tested, and the sample scheme analyte's Analysed Date, Analysed By User, QC Ignored Date, QC Ignored By User, Released Date, Released By User, Started Date, Completed Date, Completed By User, First Reported Date, Last Reported Date and Last Invoiced Date are cleared.

• Any analytes with a Code of WEIGHT or VOLUME in linked sample schemes has its Numeric Final Value cleared and Workflow Status set to Not Started (regardless of whether it was Insufficient Sample, Not Analysed or No Result, since linked sample scheme analytes are typically synchronised with each other), and any analyte in the current and linked sample schemes where its Numeric Final Value is empty has its Weight or Volume property cleared as well.

Updating Analytical Details for a Sample Scheme Analyte

Where required, for an analyte that is configured to hold a numeric result, various analytical details can be updated during final or raw result entry mode.

Update analytical details for a sample scheme analyte in workbook

Updates to the Dilution Factor, Unit Code, Internal Lower DL and/or the Internal Upper DL does not change the sample scheme analyte's Numeric Raw Value, Numeric Final Value or Detection Limit Status, however, updating the Dilution Factor does set the dilution to be used for the next reading.

Updating Sample Scheme and Sample Scheme Analyte Result Notes

SSA Report Notes, SS Analysis Notes, SS Report Notes, SS Report Header Notes, SS Results Header Notes or SS Report Footer Notes can be added to a sample scheme or sample scheme analyte for informational or reporting purposes.

Update notes for a sample scheme analyte in workbook

Refer to Maintaining Canned Comments.

Canned comments are available to quickly entered pre-canned text. When canned comments are accessed for a given note field, the canned comments are filtered by Canned Comment Type and Canned Comment Subtype.

• The Canned Comment Type of GLOBAL, JOB, SAMPLE or SCHEME, and the Canned Comment Subtype of GLOBAL, REGISTRATION, RECEIPT, ANALYSIS, RELEASE, VALIDATION, REPORT or INVOICE.

or:

• The list of category codes entered in the Category Code. The category codes are initially populated from the categories whose code appears in the related preference, where the preference changes according to the particular notes field being updated:

  • NOTES_SAMPLESCHEME_ANALYSIS_CATEGORIES
  • NOTES_SAMPLESCHEME_REPORT_CATEGORIES
  • NOTES_SAMPLESCHEME_RESULT_CATEGORIES
  • NOTES_SAMPLESCHEMEANALYTE_REPORT_CATEGORIES.

Updating Reporting Details for a Sample Scheme Analyte

Update reporting details for a sample scheme analyte in workbook

Updates to the Report Unit Code, Rounding Table Code, Report Lower DL and Report Upper DL affect the rounding in internal reports and the default values of these fields in report requests created for the job.

Understanding the System Processes that Follow Result Entry

When a result is entered for a sample, the result undergoes detection limit, specification and various QC assessments, and the percentage difference, RPD and recovery are calculated, dependent upon the sample's Primary Analytical Type and Secondary Analytical Type.

Entering and changing data has an impact on the sample scheme analyte's Workflow Status.