An example of results obtained with an automated pipettor (Pipettor#1) set to deliver 200 L is shown in Figure 13. In this particular example, two of the eight pipettor channels were slightly outside the acceptable range.
NOTE: If you wish, you can also flag pipettor channels which give a standard deviation above a certain limit. For example, the formula to indicate pass/fail with respect to a standard deviation limit of 2.0 could be: If(Std.Dev<2.0,Pass,Fail).
CREATING A CUSTOMIZED SUMMARY SECTION
You can create a customized report in a Notes section to report final results. An example of such a report is shown in Figure 14. The Nominal Dispense Volume was brought into the Notes section by creating a summary linked to Sum#1 in thePipettor#1 Group Table. The formula for the linked summary is Sum#1@Pipettor#1.
To obtain a Pass/Fail outcome for the pipettor, a column was created in the Pipettor#1 Group Table in which the results from the Outcome column were converted to numerical values ( Figure 15.) The column is named HiddenColumn, because it is normally hidden from view to simplify the Group Table. The formula for the hidden column is If(Outcome=,1,10).
The OVERALL PIPETTOR OUTCOME in the Notes section was created by adding another summary, linked to the Pipettor#1 Group Table with the formula: if (Max(HiddenColumn@Pipettor#1)>1,Fail,Pass). The formula refers to the numerical values in the hidden column if any one of the numerical values exceeds 1, the pipettor fails the performance check.
The time and date displaye