Previous Next

*   Importing Spectra from an Excel Spreadsheet
You can import mass spectra or spectral trees stored in an Excel spreadsheet to the Database Manager window (see Copying and Pasting a Spectral Tree). You can organize spectral tables horizontally or vertically.
Note  The Mass Frontier application supports standard tables with separated numbers, so you can also import spectra from other applications.
v
To import spectra from an Excel spreadsheet
1.
2.
3.
4.
Choose Edit > Paste > Spectrum in the Mass Frontier main menu.
v
To correctly interpret m/z values and abundance
Follow one of these conventions:
When the spectra are vertically oriented, the first column is abundance, and the second column is the m/z value, then label the first row of the first column “Abundance” and the first row of the second column “m/z”.
When the spectra are oriented horizontally, the first row is abundance, and the second row is the m/z value, then label the first column of the first row “Abundance” and the first column of the second row “m/z”.
When you import more than one spectrum at a time, then the first column or row (depending on the orientation) must be the m/z values and all the other columns (or rows) must be abundance.
 


Previous Next
Related Topics:
  Exchanging Data
  Exporting Data to an Excel Spreadsheet
Copyright 1998 - 2013 HighChem Ltd., Slovakia