4.3. Worksheets

Next: Monitoring Analysis Requests Previous: Request Analyses  

The lab clerk may choose to group all these tests onto a single worksheet, so that all the tests may be run at the same time. A single workstation may perform a number of tests simultaneously, as is the case with the Foss WineScan

These would be grouped into a single worksheet for easy bulk validation and verification. All the worksheet results can then be reviewed and verified together by the lab manager and authorised reviewers. For ISO 17025 compliance

It is also possible to create worksheets per client

For manual data capturing, the lab technician prints the worksheet and uses it in the lab to record results. The completed worksheet is eventually returned to the lab clerk for capturing the  results into the system. Alternatively the lab technician types the data directly into the system

Results Data may also be uploaded from lab instruments such as the WineScan directly, see Analysis Request Result Capturing

The |worksheet|  tab provides the functionality associated with worksheet

List of current worksheets

The lab technician clicks on the [add new worksheet]  button to create a new worksheet. A unique worksheet number is generated with a blank worksheet, to which analysis requests are to be added, by clicking on the [add analysis]  button

Add analysis to new worksheet

The user selects the analysis type and/or client for which the worksheet is to be created

Select analysis requests for worksheet

The search result presents all the analysis requests in the lab which meet the specified criteria. The user then selects analysis requests for inclusion on the worksheet

Worksheet with analysis requests in columns

These three analysis requests have now been added to the worksheet. They now have the status assigned to worksheet

Analyses may be added to or deleted from the worksheet. Deleting an analysis removes it from the worksheet, it does not delete the request from the system. Once an analysis has been added to a worksheet, the worksheet is shown as a link in the analysis request

The lab member who performed the analysis is captured in the Analysed by selection box

For analysis services which require titration values, the additional input columns are shown and the result is calculated as titration volume x titration factor. These columns do not appear for analyses which do not require titration

To minimise keystrokes and possible human error, a Copy titration factors checkbox is provided to apply the same titration factor for all the analyses on the same row by entering a value in the first column only

Results may be added as they become available, either manually or uploaded directly from instrument exports

Worksheet with analysis requests in rows

Next: Monitoring Analysis Requests Previous: Request Analyses