Skip to main content
Waters

How to export 3D raw data from Empower to a Microsoft Excel spreadsheet - WKB77571

Article number: 77571

OBJECTIVE or GOAL

Export 3D raw data (such as PDA 3D data or MS full-scan data) from Empower to Excel.

ENVIRONMENT

  • Empower 3

PROCEDURE

  1. Open the project from which you want to export data.
  2. Click File > New method > Export method.
  3. Select the Raw Data tab.
  4. Type in a file name. This name (plus an incremental number) will be used as the file name for the export file.
  5. For File, select ASCII.
  6. Select a path to export the file.
  7. Select "Export Time Column" in the X-axis Data area to have an export of the full-scan data for the entire chromatogram.
  8. Select "Export Fields" in Sample Information area to create a legend in the export file.
  9. Click File > Save as, and name the export method.

        export 3D raw  data Empower.png

  1. Go to your sample set, select the injection, and then the PDA spectrum channel or MS full-scan channel in the project.
  2. Right-click on the channel containing the 3D data and choose "Export with specified export method". Select the created method (steps 1 through 9) and click OK.

export 3D raw  data Empower 2.png

  1. Open an Excel spreadsheet and click File > Open.
  2. In the drop-down menu to the right of the file name, select "All Files(*.*), and browse to the location to which the export file was written.
  3. Excel will ask you questions on the delimiters. Click twice on Next, and then click Finish.
  4. The requested sample information will appear on top as a legend.

3D export excel result.PNG

The first column is the time axis. The third row in this example is the wavelength axis of the PDA spectrum. The cells contain the intensity values for certain time points and wavelengths. Note that the first line shows intensity values of 0, corresponding to the autozero of the PDA.

ADDITIONAL INFORMATION

 

id77571, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.