Standard operation, Download test results, Import data – Hach-Lange BODTRACK II User Manual User Manual

Page 12: Data format, Download test results import data data format

Advertising
background image

Standard operation

Download test results

To transfer test results to a PC:

1. Select

PROGRAMS>ACCESSORIES>COMMUNICATIONS>HYPERTERM
INAL.

2. In the Connection Description window, type in a name for the

connection and select an icon to represent the connection. Click OK.

3. In the Connect To window, use the drop-down menu to select the

COM port connected to the instrument. Click OK.

4. Configure the COM port properties: BPS = 9600, Data Bits = 8,

Parity = None, Stop Bits = 1, Flow Control = None.

5. Click OK. The connector indicator shows.
6. Select TRANSFER>CAPTURE TEXT.
7. In the Capture Text window, click START.
8. Power the instrument on. Push the key for the channel that has data

to be downloaded.

9. Type GA in the HyperTerminal window and push ENTER. The

transfer is complete when the screen stops adding new data.

10. Select TRANSFER>CAPTURE TEXT>STOP.
11. Select CALL>DISCONNECT. The disconnected indicator shows.
12. To end the HyperTerminal session, select FILE>EXIT.

Import data

To import the data from the captured text file:

1. Open a new or existing spreadsheet. Select DATA>IMPORT

EXTERNAL DATA>IMPORT DATA.

2. Select the text file captured in HyperTerminal. Click IMPORT.
3. In the Text Import Wizard, select Delimited as the file type, the start

row in the spreadsheet and Windows (ANSI) as the file origin. Click
NEXT.

4. Click the check boxes for Space delimiter and Treat consecutive

delimiters as one. Click NEXT.

5. Select General as the column data format, then click FINISH.
6. In the Import Data window, select Existing worksheet. Select the

starting cell, then click OK. The data will appear in the spreadsheet.
The spreadsheet data cannot be edited or formatted in
HyperTerminal or with the BODTrak II.

Data format

When a result array is downloaded to HyperTerminal, all of the data from
a test is sent without pause. The data flow cannot be stopped or paused.
The example shows the channel number, start date, start time and the
format of the downloaded data. BOD values in mg/L follow. Only the first
data points of a maximum of 360 equal distance points are shown. Each
line ends with a carriage return and a line feed. The end of the data
stream is shown by a message such as "Test Run to Completion" and a
dollar symbol ($).
If small negative BOD values are seen at the start of a test, refer to

Troubleshooting

on page 20.

Example of the data format

BOD Log for Ch 1
Status: END
Full Scale: 700 mg/L
Tst length: 7 days
Start Date: 3/3/08
Time: 13:04

Days, Reading (mg/L)

0.00, 0
0.05, 10
0.11, 12
0.16, 12
0.22, 14
0.27, 14

10 English

Advertising