Ocean Optics DTS - Manual (Page 43)

Collecting Spectra and Manipulating Data
Polychromix DTS TM Near-Infrared Spectrometer 5-7
Operator’s Manual
Document Number 04-91-0201-00 Rev A
5.4 Saving and Retrieving Spectra
The active spectrum can be saved by selecting the Save File command on
the File menu and indicating the desired storage location. Data is saved as a
.csv file (comma separated values). If the spectrum was obtained by
averaging a number of scans, the averaged spectrum will be saved (but not
the individual scans).
The saved spectrum can be retrieved by selecting the Open File command
on the File menu and selecting the desired file. As an alternative, the file can
be opened in Microsoft Excel in a tabular format for customized data
processing and presentation as well as in many other applications.
If data is collected on a time scan basis using the SCMultiScan dialog box
(see Section 4.7), the Save options field can be used to store each spectrum
on an automated basis as it is being collected and the Excel spreadsheet will
display a column for each spectrum. As an alternative, if you select the
Multiple Files radio button, each set of scans will be given a separate file.
A part of an Excel spreadsheet for a single spectrum is shown in Figure 5-8
and a part of a spreadsheet for multiple spectra is presented in Figure 5-9
(see Section 4.7).
Wavelength (nm) Absorbance 5/26/2005 11:56:51 Abs Polystyrene
0
936.9 0.03506013
944.7 0.03423788
952.4 0.03391358
960.2 0.03462744
967.9 0.03427535
975.7 0.03541862
983.4 0.03574646
991.1
0.0360106
998.8 0.03682216
1006.6 0.03748415
1014.3 0.03631843
1022 0.03653189
1029.7 0.03704398
1037.5 0.03592357
1045.2 0.03496345
1052.9 0.03526047
1060.6 0.03398799
1068.3
0.0326819
1076 0.03347766
1083.7 0.0337929
1091.4 0.03389158
1099.1 0.03401419
1106.8 0.03735034
1114.5 0.04052372
1122.2 0.04250975
1129.9 0.04695749
1137.5 0.04944238
1145.2 0.04932098
Figure 5-8: Spectroscopic Data in Excel Spreadsheet - Single Spectrum