Hach HQ440d, User Manual

Open data files on a PC

Data that has been downloaded to a USB storage device can be transferred to a computer. The data
is sent in a text (.txt) file format.

1.

Plug the USB storage device into the computer.

2.

Find the data file. The file will have the following format: “Meter Serial Number-Data File Type-
Date Time”. Example: 9999NN000000-SENDDATA-0603131624.TXT

3.

Save the data file to a location on the computer.

4.

Open a spreadsheet program such as Microsoft

®

 Excel

®

 spreadsheet software.

5.

Open the data file from the spreadsheet program. Select the delimited option with comma as the
delimiter.
The data will be shown in the spreadsheet program.

Note: If an application is used that is not compatible with column headings, the headings can be omitted. Refer
to 

Remove column headers

 on page 17.

Data file description

Data that is saved to a USB storage device and then opened in a spreadsheet application will have
multiple columns of data. A description for each of the columns is shown in 

Table 1

.

Table 1  Spreadsheet column descriptions

Column header name

Data description and example values

Type

Type of data: RD = Reading; CL = Calibration; CK = Check Standard; CH =
Calibration History; IC = Current Calibration

Parameter

Type Parameter: LDO, pH, CD (conductivity), ORP, ISE

Date

Date of reading: stored in user-defined date format

Time

Time of reading: stored in user-defined format

Operator ID

Operator ID that was used when the data was recorded. Shows “- - -” if no
operator ID is used.

Probe Model

Model number of probe, for example pHC101, CDC401, LDO101 

Probe SN

Probe serial number
If two probes are connected to the HQ440d meter, the serial number shows
“<“ or “>” to identify the port (left or right) the probe was connected to during
the reading.

Method name

User-defined name of the probe settings that were used for the reading.

Sample ID

Sample ID that was used when the data was recorded. Shows "Sample ID" if
the default sample ID is used.

Primary Reading Value

Measured value. Shows “—" if the value was out of range.

Primary Reading Units

Measurement units, for example pH or µS/cm

Supp Reading 1 

First supplemental reading (example: temperature), if applicable

Supp Units 1 

Units for first supplemental reading, if applicable.

Supp Reading 2 

Second supplemental reading (example: “mV” for pH), if applicable

Supp Units 2 

Units for second supplemental reading, if applicable

Supp Reading 3 

Third supplemental reading, if applicable

Supp Units 3 

Units for third supplemental reading, if applicable.

Reading Setting 1–4 

Any settings that affect the reading, for example “NaCl/Non-Linear”

English

15