Log in
Site MapContact

13 Worksheets

A number of similar analyses - on different samples but logically belonging together, such as intended for the same lab workstation, instrument of specific analyst - can be grouped into a single unit of work on a Worksheet. Sometimes called a Job Card. Here, all their results can be captured and reviewed together, in context of peers and associated QC results on the same page

Worksheet Lists

Like all other lists in Bika, Worksheet lists maybe navigate by listing the objects by status, in this case All, Open, To be verified, Verified or Rejected

The first column lists worksheets by unique ID, followed by the user name for the user who created it - in big labs with many Worksheets in the system, this column helps users to find the sheets they are working on. Rejected worksheets will be hyperlinked to their valid copies and vice versa in the 'linked worksheet' column

Analyses are hyperlinked on Worksheets and their Sample views

Worksheet Titles

If you have bika.extras installed, you could enable Worksheet Titles in the Setup, at the bottom of the Analyses tab

Worksheets will then be listed and displayed with the Analysis Categories they contain as 'titles'

Worksheets manually

Try rather to follow the automation presented overleaf, this here is to describe Worksheet fundamentals:

Creating Worksheets

Sans templates or instruments. Creating them and adding Analyses and QC Controls

Add QC Controls

Adding CRMs, Blanks and Duplicates to a Worksheet

Results Capture

Typing results in, directly or from bar coded prints

Worksheet Correction Factors

Configure Bika's calculations to automatically apply dilution and correction factors

Results Verification. Retesting

Typing results in, directly or from barcoded prints

Worksheet Analyses

Be sure to have enough Analyses available in the system to fill a worksheet with. Analyses available for assignment to Worksheets, have to be in Received state and not assigned to other WSs already

The Easy way. Using WS Templates

Also see Create Worksheets from Sample lists

Creating Worksheet Templates

Templates for frequently used Worksheet layout

Creating Worksheets from Templates

The above in a few clicks using Worksheet Templates

Export Worksheets to Instruments

Worksheets can be exported in formats specified for instruments capable of uploading Sample lists before analysing them

Instrument results import

Result data produced by the instruments may also be uploaded directly if the system is configured to read it's export files

Import manually captured result spreadsheets

CSV results import, in a table of Sample IDs and their Analyses. It does introduce potential human error and slows down turnaround