Hach-Lange HQD Portable Meter User Manual - Manual (Page 18)

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 18.
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.
Table 1 Spreadsheet column descriptions (continued)
Column header name Data description and example values
Probe Model Model number of probe, for example pHC101,
CDC401, LDO101
Probe SN Probe serial number
If two probes are connected to the HQ40d 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”
Any settings that affect
the reading, for example
“NaCl/Non-Linear” Reading Message 1–4 Any message that was shown
during the measurement, for example “Out of limits”.
16 English