SKC DataTrac for the Pocket Pump - Manual (Page 29)

27
Transferring History Files into Spreadsheets
The history fi les (.hst) may be transferred into a spreadsheet or other application. A typical history fi le is shown below.
HISTORY FILE
1000
SN 1788
34975.431632
Min Temp 75.2F
Max Temp 100.4F
TWA Temp 84.4F
9
8
0 141
34992.625694 34992.648611 -1
0 0 34992.588194 34992.625694 -1
8 5 34992.552778 34992.588194 -1
0 0 34992.517361 34992.552778 -1
0 75 34992.501389 34992.517361 -1
0 0 34992.473611 34992.501389 -1
0 180 34992.447917 34992.473611 -1
0 0 34992.379167 34992.447917 -1
Following is an explanation of each line of the history fi le.
Line 1: HISTORY FILE (fi le type identifi er)
Line 2: 1000 (Soft ware revision number)
Line 3: SN 1788 (Serial number of the pump)
Line 4: 34975.431632 (Time and date that the fi le was stored. See Decoding Time Fields on page 28)
Line 5, 6, 7: The Minimum, Maximum, and time-weighted average of the data while the pump was running (Min,
Max, and TWA temp are not updated when the pump is in HOLD)
Line 8: 9 (The ASCII value of the character used as the column separator, the default is TAB)
Line 9: 8 (The number of periods in history)
Lines 10 to 17: A breakdown of each history period ordered from most recent to oldest. Each line of the history is
decoded as follows:
Column 1: Mode of Pump including the following values
0
Constant Flow mode
8 Constant Pressure mode
16 Flow Fault while in Constant Flow
24 Flow Fault while in Constant Pressure
32 Hibernate (see explanation of hibernate, page 25)
64 Low batt ery fault
Column 2: Rate of Constant Flow or Constant Pressure value. Whether the value represents Constant Flow or
Constant Pressure depends on the value in column 1
Column 3: Start Date/Time. Description of decoding method explained in decoding time fi elds below
Column 4: Stop Date/Time. Description of decoding method explained in decoding time fi elds below
Column 5: Valid (-1) or Invalid (0) Time Period. Under certain conditions (such as Hibernate or low batt ery fault)
the pump will lose its ability to accurately tell time. When this happens, Column 5 will be fl agged with a zero.
Even though the Start Time and Stop Time cannot be relied upon, the amount of time the pump spent running in
Constant Flow can still be determined by subtracting the Start Time from the Stop Time.
Power User Hints