How to export results


Introduction

This section describes how to export curves in different formats and how to copy data and curves to the clipboard.


Data formats

You can export data in the following formats:

  • AIA (.cdf)

  • ASCII (.asc)

  • Lotus 1-2-3 (.wks)

  • Excel (.xls)

  • XML (.xml)


Export options

Select File:Export in the Evaluation module to export data from an open result file. The following export options are available:

  • Curves

  • Export curve to AIA

  • Peak table

  • Method

  • Documentation

  • Evaluation log


How to export curves

The table below describes how to export curves in the Evaluation module.

Step

Action

1

Choose File:Export:Curves.

Result: The Export Curves dialog box opens.

2

  • Select the curve(s) you want to export.

  • Enter parameters to limit the curve(s) if necessary.

  • Click the Select button.

  • Repeat Step 2 to select more curves.

3

Click the Export button.

Result: The Export Curves to File dialog box opens.

4

Select the export file format from the Save as type droplist.

  • ASCII files (*.asc)

  • Lotus 1-2-3 files (*.wks)

  • Excel files (*.xls)

  • AIA files (*.cdf)

5

  • Select a destination folder.

  • Type a file name and click OK.

Note: Curves are exported as series of numerical coordinates that refers to the time/volume and signal respectively.


How to limit the exported curves

You can optimize the exported curves to only the parts that you want to focus on, in the Export Curves dialog box. The table below describes how to use these editing options.

Dialog box option

Instruction

Cut curves

Enter retention values in the text boxes to limit the curve to only a portion of the original curve.

Cut graphically

This button opens the Export Cut dialog box. Move the vertical markers to the correct cutoff points.

Reduce number of samples

Adjust the factor value or the maximum number of samples. To reduce the number of samples by a factor of five means that only every fifth point will be sampled for export.

Normalise retention

Select the Normalise retention checkbox to have all exported curves normalized to a common X-axis.


How to export curves in AIA format

The table below describes how to export curves in AIA format.

Step

Action

1

Select File:Export:Export curve to AIA.

Result: The Export curve in AIA format dialog box opens.

2

  • Select the source chromatogram and the curve you want to export.

  • Click the Export button.

Result: The Export Curves to File dialog box opens.

3

  • Select a destination folder.

  • Type a file name.

  • Click OK.


How to export peak tables

The table below describes how to export peak tables.

Step

Action

1

Choose File:Export:Peak Table.

Result: The Export Peak Table dialog box opens.

2

  • Select the source chromatogram and the peak table you want to export.

  • Click the Export button.

Result: The Export Peak Table to File dialog box opens.

3

Select the export file format from the Save as type drop-list.

  • ASCII files (*.asc)

  • Lotus 1-2-3 files (*.wks)

  • Excel files (*.xls)

  • XML files (*.xml)

4

  • Select a destination folder.

  • Type a file name.

  • Click OK.

Note: Peak tables are exported as text strings in ASCII format and numerical values in the Lotus 1-2-3 formats. All possible columns in the peak table are exported.


How to export methods, documentation and evaluation logs

The table below shows how to export methods, documentation and evaluation logs:

Step

Action

1

Select the data you want to export.

2

  • Select options in the dialog box.

  • Click the Export button.

3

  • Select a destination folder and type a file name.

  • Click OK.


Copy to the clipboard

You can also use the Windows clipboard to copy the contents of the active window and paste it into other programs, e.g. Microsoft Word. Curves and documentation are copied as Windows enhanced metafiles (.emf) and peak tables are copied as text. Only the peak table columns that are selected in the spreadsheet will be copied.


2005-06-15