Open data files on a PCData that has been downloaded to a USB storage device can betransferred 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 SerialNumber-Data File Type-Date Time”. Example: 9999NN000000-SENDDATA-0603131624.TXT3. 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 thedelimited 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, theheadings can be omitted. Refer to Remove column headers on page 18.Data file descriptionData that is saved to a USB storage device and then opened in aspreadsheet application will have multiple columns of data. A descriptionfor each of the columns is shown in Table 1.Table 1 Spreadsheet column descriptionsColumn header name Data description and example valuesType Type of data: RD = Reading; CL = Calibration; CK =Check Standard; CH = Calibration History; IC =Current CalibrationParameter Type Parameter: LDO, pH, CD (conductivity), ORP,ISEDate Date of reading: stored in user-defined date formatTime Time of reading: stored in user-defined formatOperator ID Operator ID that was used when the data wasrecorded. Shows “- - -” if no operator ID is used.Table 1 Spreadsheet column descriptions (continued)Column header name Data description and example valuesProbe Model Model number of probe, for example pHC101,CDC401, LDO101Probe SN Probe serial numberIf two probes are connected to the HQ40d meter, theserial number shows “<“ or “>” to identify the port (leftor right) the probe was connected to during thereading.Method name User-defined name of the probe settings that wereused for the reading.Sample ID Sample ID that was used when the data wasrecorded. Shows "Sample ID" if the default sample IDis used.Primary Reading Value Measured value. Shows “—" if the value was out ofrange.Primary Reading Units Measurement units, for example pH or μS/cmSupp Reading 1 First supplemental reading (example: temperature), ifapplicableSupp Units 1 Units for first supplemental reading, if applicable.Supp Reading 2 Second supplemental reading (example: “mV” for pH),if applicableSupp Units 2 Units for second supplemental reading, if applicableSupp Reading 3 Third supplemental reading, if applicableSupp 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 affectthe reading, for example“NaCl/Non-Linear”Reading Message 1–4 Any message that was shownduring the measurement, for example “Out of limits”.16 English