40
19:03:04 147 104 (115) 080 101.8 95 080
19:03:28 93 081
19:03:38 95 080
19:03:53 149 100 (115) 081 101.8 94 080
19:04:45 152 099 (114) 080 101.8 94 080
19:05:09 93 080 ...
Importing text file into Excel
The text data file can be archived and printed directly from a PC/MAC without any changes. However, if
graphics are desired, the text data file can be imported into an Excel worksheet easily by following the
steps below. The steps in this example are for Excel 2007. If you have a different version of Excel, the
data can also be imported, but the steps may differ a bit.
1. Insert SD card into designated slot on computer.
2. Open a blank Excel worksheet.
3. Select the Data tab in the tool bar of the Excel worksheet. In the Get External Data section of the tool
bar (right most section) select From Text.
4. A window will pop up for you to select the text file you are importing. Once you have selected the
file, click Open.
5. The next window that pops up will ask you to select the original data type and in what row to begin
the import. Select Fixed width for the original data type, and row 1 to start the import. Click Next.
6. The following window will allow you to adjust the widths of the columns if you feel necessary. Click
Next.
7. The last window allows you to select the data format for each column. As a default, all columns are
set to General. It is recommended that you select the (MAP) column by clicking on it, and at the top
right of that window selecting Text. This adjustment is made so the MAP values will show up in a
parenthesis and not as negative numbers. Click Finish.
8. A small Import data window will pop up. Select okay.
Your data is now imported, should appear on the worksheet and can be graphed using normal Excel
graphing commands.
To Next Page
Loading...