Thanks to Bob, Steve, Jack and all you guys that have offered some
EXCEL help. Here is the basic protocol of the data files it needs to
use. The crude spreadsheet I have already written is too large to
post, not because it is complicated but only because of the large
number of cells.
The basic idea is to display the data in a horizontal line graph with the horizontal axis being time and the vertical axis being the value of the data. My first attempt just has all parameters on a single graph but it would be better to have separate graphs for related groups but still be able to relate them in time.
I'll attach a sample data file if you want to play
around with it. This one is a short one so that it will go on the list
server. A full one hour log was too big.
Tracy Crook
DATA
BLOCK FORMAT SENT TO USB STORAGE DEVICE
Block
sent to file on USB storage device at one second intervals.
The
file will be a plain text file with the file name extension of .TXT
Each
block consists of 32 comma separated plain ascii text values (five digits w/leading zeros if needed).
Each
data block is terminated with a line feed character.
There
are a maximum of 3600 data blocks (1 hour)
in a record.
The
parameters in the data block are in the following order:
- Coolant Temperature
-
Oil Pressure
- Oil temperature
- Coolant Pressure
- Altitude
- Fuel Pressure
- Left Tank fuel level
- Outside air Temp
- Right tank fuel level
- Air / Fuel ratio (Mixture)
- True Air Speed
- Air / Fuel mixture 2 (not used on
most installations)
- Battery/Alternator voltage
-
Fuel Flow (GPH)
- MPG (miles per gallon)
- Engine RPM
- CHT 1
- CHT 2
- CHT 3
- CHT 4
- CHT 5
- CHT 6
- CHT 7
- CHT 8
- EGT 1
- EGT 2
- EGT 3
- EGT 4
- EGT 5
- EGT 6
- EGT 7
- EGT 8
|