Use multiple worksheets, Exclude standard curves, Exclude column headers/footers – Bio-Rad Bio-Plex Software® Upgrades and Conversions User Manual

Page 179: Exclude table error codes

Advertising
background image

Report Table

167

Use Multiple Worksheets

If you selected Excel Workbook and are generating multiple tables of data,
select this checkbox to export each table to a different worksheet within the
workbook. Otherwise, all tables appear on the same worksheet.

Choose from the following settings, based upon how you want your data
presented:

Single Analyte—This choice generates a workbook with one worksheet for
each analyte.

Multiple Analyte—If you check the Use Multiple Worksheets checkbox in the
Advanced Export options dialog, you will generate a workbook with one
worksheet for each column (FI, FI-Bkgd, etc.), with data for all analytes. If you
leave the Use Multiple Worksheets checkbox unchecked, all of the data
appears on one large worksheet, which can be viewed by scrolling with the
elevator bar.

96-well —If you check the Use Multiple Worksheets checkbox in the
Advanced Export options dialog, you will generate a workbook with one
worksheet for each analyte. If you leave the Use Multiple Worksheets
checkbox unchecked, all of the data appears on a single worksheet.

Exclude Standard Curves

Standard curve images are automatically exported to Excel, by default. You
can exclude them from the export by checking the box next to Exclude
Standard Curve.

Exclude Column Headers/Footers

Select the Exclude Column Headers/Footers and Page Headers/Footers
checkbox to exclude this information from the exported file.

Exclude Table Error Codes

See page 234 for a table of possible Report Table Error Codes.

The error code symbols (OOR< >, ***, ----, *) before concentration values in
the Report Table can interfere with macros in some types of spreadsheets,
including Excel. Select this checkbox to exclude these symbols from the
exported file. If this option is selected, table cells with error codes are
exported as empty cells.

BioPlex_6.book Page 167 Friday, September 23, 2011 11:55 AM

Advertising