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
To Next Page
Loading...
Need help?
General
