5 downloading test results, 1 import data – Hach-Lange BODTRAK II: Respirometric Biochemical Oxygen Demand (BOD) User Manual

Page 16

Advertising
background image

Operation

16

4.5 Downloading test results

To transfer test results to a PC:

1.

Choose

PROGRAMS

,

ACCESSORIES

,

COMMUNICATIONS

,

HYPERTERMINAL

.

2.

In the Connection Description window, type in a name for the connection and

choose an icon to represent it. Click

OK

.

3.

In the Connect To window, use the drop-down menu to choose the COM port

connected to the BODTrak II 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 connect indicator will be shown.

6.

Choose

TRANSFER

,

CAPTURE TEXT

.

7.

In the Capture Text window, click

BROWSE

to choose a specific save location.

Name the file and click

SAVE

.

8.

In the Capture Text window click

START

.

9.

Power on the BODTrak II. Push the applicable channel key for the data to be

downloaded.

10. Type GA in the HyperTerminal window, then push

ENTER

. The transfer is

complete when the screen stops adding new data.

11. Choose

TRANSFER

,

CAPTURE TEXT

,

STOP

.

12. Choose

CALL

,

DISCONNECT.

The disconnected indicator will be shown.

13. To end the HyperTerminal session, choose

FILE

,

EXIT

.

14. Click

YES

to save the session and all instrument/port configuration settings.

4.5.1 Import data

To import the data from the captured text file:

1.

Open a new or existing spreadsheet. Choose

DATA

,

IMPORT EXTERNAL DATA

,

IMPORT DATA

.

2.

Select the text file captured in HyperTerminal. Click

IMPORT

.

3.

In the Text Import Wizard, choose Delimited as the file type, the start row in

the spreadsheet, and Windows (ANSI) as the file origin. Click

NEXT

.

4.

Check the Space delimiter and Treat consecutive delimiters as one check

boxes. Click

NEXT

.

5.

Choose General as the Column data format then click

FINISH

.

6.

In the Import Data window, choose Existing worksheet. Choose the starting cell

then click

OK

. The data will appear in your spreadsheet.

7.

Choose File, Save As to save the spreadsheet.

The spreadsheet data cannot be edited or formatted in HyperTerminal or with the

BODTrak II.

Advertising