Export Data

In the next two sections it is explains how to create a single and quick data export into a text file or to excel either from the microplate or from the table view page. If you want to define a complete excel report for a single test run, read the last section (3.17.3) in this chapter.

3.17.1 Export Microplate or Table View Data Export to Excel

Data can be exported into Excel from the microplate and table view pages by clicking on the Excel button shown on the upper left side of the page.

Note: If Microsoft Excel is not installed on the PC, the excel export is not available and the appropriate controls and buttons are disabled.

Each export sheet created shows at the top of the page the detailed information of the test run as in the upper section of the evaluation software. If you don't want to export the information or if you want to have this information at the end of the data, open the Excel Settings dialog box:

1. Click Excel Export in the Settings group on the Formats and Settings tab.

2. Select the desired behavior in the Common Excel Export Settings section:

If more than one end node or calculation in the navigation tree is selected in the microplate view, each item will be displayed in a separate table within the Excel sheet.

If well scanning data are displayed in the microplate view, a scan matrix with the measured values of each well will be exported to excel.

If the exported test run has more than one cycle/interval, you will be asked whether you want to export only the current cycle/interval or all cycles/intervals. If you decided to export all cycles/intervals, there are two ways the data for each cycle/interval will appear in Excel:

1. For each cycle/interval an Excel sheet will be created. The sheet name is a combination of the cycle/interval number and time value of the appropriate cycle/interval.

2. All cycles/intervals are shown in the same Excel sheet. The data group for each cycle is exported one below the other. A data group consists of one or more tables in the microplate format (a table for each selected data node). Each cycle/interval data group has a header containing the cycle/interval number and the appropriate cycle/interval time value.

To define, which export way should be used, open the Excel Settings dialog box:

1. Click Excel Export in the Settings group on the Formats and Settings tab.

2. Select the desired export way on the Microplate View Excel Export Settings group:

If the test run generates more than 250 columns in the table view page, the data will be distributed on different sheets if the used Excel version limits the number of columns. Alternatively you can transpose the table before exporting it (rows and columns will be swapped), if you select the option Transpose Table.

BMG LABTECH OPTIMA Software Manual - Part IIIa: MARS Data Analysis

Export to a Text File

Data displayed in the table view can also be exported to a text file by clicking the button on the table view page. The generated file is stored in the comma separated value format. That means, each row of the table represents a row in the text file and the column values of each row are separated by a separator character. The destination directory, the file name, the preferred file extension (CSV, TXT or user defined) and the separator can be defined with the File Export Settings window.

The file can be created including the test run information header and available fit result tables or without this information.

The filename can be generated automatically (TRno+[Unique Test Run Number]+.+[Selected Extension]) or defined by the user.

The generated files can be opened with any text editor or with excel. If the file extension is CSV and the separator is ',' for English systems or ';' for e.g. German system, Excel recognizes the file as data file and separates the columns into excel columns.

See an example of a CSV file including the header below:

3.17.2 Exporting Fit Results

If the data exported from the microplate or table view contain the result of a standard fit calculation or an enzyme kinetic calculation, an additional sheet in Excel will be created with the result parameter of the standard fit calculation.

To export the result parameters of all performed standard fit calculations or enzyme kinetic calculations, open the fit result window on the corresponding chart and press the Excel button.

3.17.3 Define an Excel Report

If you want to export not only a single data sheet, you can combine up to all available data pages in one excel report. Press the Excel Report button in the Test Runs group on the Home tab of the Ribbon to define the report:

Define the data to export and the special settings for each exported page. The entered report configuration is valid for the opened test run and will be saved together with the test run settings.

The available settings are the same as for the single page export described in the two sections above. In addition, the option Export all data in one workbook allows to define, if all exported data should be copied in one excel workbook, or if a new excel workbook should be created for each exported data page.

BMG LABTECH OPTIMA Software Manual - Part IIIa: MARS Data Analysis