Step 8 View the Plate section for a qualitative evaluation of the results. Figure 10 shows an example of results from an 8-channel pipettor in which channels C and G had slightly loose pipet tips. The wells in these channels clearly have slightly shorter pathlengths.
Step 9 Open the Group Table to view the quantitative data ( Figure 11). The Val ues column will contain the individual pathlength measurements in centimeters. The Result column will contain the volumes (in microliters) obtained by interpolation from the standard curve. Delete the R column because you do not need it. If desired, you may change the name of the MeanResult column to MeanVolume.
Step 10 Create a summary at the bottom of the Group Table, then type the nominal dispense volume into the formula field of the Calculation dialog box for the summary. Give the summary a short name to allow easy reference to it in subsequent formulas. Enter a description of what the summary contains in the Description field. The Calculation dialog box for a summary named Sum#1, specifying a nominal volume of 200 L is shown in Figure 12.
Step 11 Create an Outcome column in the Group Table to flag any pipet channel falling outside the acceptable range. To do so you must decide upon a pass/fail criterion. The formula for an Outcome column in which the pass/fail criterion is nominal volume +/- 1% is: If (Abs(MeanVolume-Sum#1)/Sum#1<0.01,,Out), where Abs is absolute value and Sum#1 is the nominal dispense volume that was entered in the summary formula in Step 10 , above. The logic of the fo