Bio-Rad iQ™5 Optical System Software, Version 2.1 - Manual (Page 74)

Section 6 Data Analysis Module
- 65 -
Fig. 6.21. Exporting PCR Quant Data Tables to Microsoft Excel.
The Export to Excel command is useful for exporting exact values from the spreadsheet. When
the Export to Excel command is selected from the menu, an Export to Excel file save box is
displayed. Choose a location where the Excel file is to be saved and click Save. The iQ5 software
automatically exports the selected data into a protected workbook.
•
The protected workbook generated by the iQ5 software contains the text values of what
is represented on the spreadsheet. For example, checkboxes from the software
application are replaced by “True” or “False” text in Excel.
•
The numeric values contained in the protected workbook are exact values from the
software application that include several non-significant figures beyond the decimal point.
This is important to note when considering whether to transfer iQ5 data spreadsheets by
a copy and paste command or the Export to Excel command. With the copy and paste
command only the significant digits displayed in the iQ5 software interface are
transferred to Excel.
6.5.5 Printing Results
The Print command on the Results table menu will print the displayed spreadsheet (Amplification
Data or Standard Curve/C
T
Results). When selected, a Print Preview box is opened which
contains an illustration of the spreadsheet as it will appear once printed. Clicking the printer icon
opens the Windows print dialog box. Click OK to complete the printing task.
6.6 Melt Curve and Melt Peak Charts
The RFU data collected during the melt curve part of the experiment are plotted as a function of
temperature, as shown in Figure 6.22.
The vertical temperature bar may be dragged to any position on the plot. The temperature bar
on the melt peak plot moves in sync to the same relative position on the melt curve plot and
vice
versa . If you place the cursor over a trace, so that the pointer turns into a hand, the trace will be
identified in the small box placed in the top right corner of the plot. The chart can be expanded
to fill the window by clicking the + box in the top left corner of the plot. Once expanded, it can
be returned to its original size by clicking the – box in the top left corner.