User Manual

41
Transferring History Files into Spreadsheets
The AirChek 2000/3000 history les (.hst) can be transferred into a spreadsheet or
other application. A typical AirChek 2000/3000 history le is shown below:
AC2000/3000 HISTORY FILE
3280
SN 627
35898.637581
Min Temp 75.2F
Max Temp 75.2F
TWA Temp 75.2F
Flow Correction Approximately -20 ml/min
9
8
257 0 35898.637245 35898.637581
1314 0 35898.637211 35898.637245
1282 0 35898.637176 35898.637211
258 2000 35898.637164 35898.637176
1 0 35898.637153 35898.637164
1025 0 35898.637106 35898.637153
261 0 35898.635359 35898.637106
262 0 35898.634907 35898.635359
1 0 35898.630255 35898.634907
An explanation of each line of the history le:
Line 1: HISTORY FILE ( le type identi er)
Line 2: 3280 (DataTrac 2000 So ware revision number x 1000)
Line 3: SN 627 (serial number of the pump)
Line 4: 35898.637581 (time and date that the le was stored. See Decoding Time Fields
on page 43.)
Lines 5, 6, 7: The minimum, maximum, and time-weighted average (TWA) 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-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 (See Decoding Pump Mode Fields, page 42)
Column 2: Flow Rate of Pump
Column 3: Start Date/Time (See Decoding Time Fields, page 43)
Column 4: Stop Date/Time (See Decoding Time Fields, page 43)
Transferring History Files