Spectrasensors SS2000 - Viewing Diagnostic Data with Microsoft Excel; To Import the Data File into Excel

SS2000 Operator’s Manual
H
2
S in Natural Gas 3–17
2. To save the data from the serial port, use the Transfer/Capture
Text function and enter the Filename to where you would like to
store the captured data.
3. Once capturing is in place, enter Mode 6 by pressing # key followed
by the 6 key.
The index shown on the LCD display counts by 50’s from 0 to 511 in
a few seconds and the screen displays:
4. Press the # key followed by the 1 key to return to Mode 1.
5. Once normal operation resumes, stop the capture of the serial data.
To stop the capture of the serial data, click on Transfer/Capture
Text/Stop.
You can import the stored data file into a spreadsheet program such as
Microsoft Excel
®
to plot the data. See "Viewing Diagnostic Data with
Microsoft Excel" for more information.
Viewing Diagnostic Data with Microsoft Excel
A spreadsheet program such as Microsoft Excel can import the data collected
in the Mode 6 data dump for viewing and plotting.
To import the data file into Excel:
1. In Excel, click Open and choose the name of the spectrum file saved
while in Mode 6. Be sure to select All Files (*.*) under Files of
type: while searching, as shown in Figure 3–10.
2. The Text Import Wizard should open. Choose the Delimited
option and click Next, as shown in Figure 3–11.
+
#
6
<DUMP STATS MODE>
INDEX: 0
<MODE>