Return-Path: Received: from out001.verizon.net ([206.46.170.140] verified) by logan.com (CommuniGate Pro SMTP 4.2.8) with ESMTP id 621096 for flyrotary@lancaironline.net; Tue, 25 Jan 2005 11:03:49 -0500 Received-SPF: pass receiver=logan.com; client-ip=206.46.170.140; envelope-from=finn.lassen@verizon.net Received: from verizon.net ([4.12.145.173]) by out001.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050125160319.PFLJ28025.out001.verizon.net@verizon.net> for ; Tue, 25 Jan 2005 10:03:19 -0600 Message-ID: <41F66DC4.9030207@verizon.net> Date: Tue, 25 Jan 2005 11:03:16 -0500 From: Finn Lassen User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax; PROMO) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rotary motors in aircraft Subject: Datalogging format References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------090201040404010906070506" X-Authentication-Info: Submitted using SMTP AUTH at out001.verizon.net from [4.12.145.173] at Tue, 25 Jan 2005 10:03:19 -0600 This is a multi-part message in MIME format. --------------090201040404010906070506 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Just as a datapoint for Tracy. The way I do it is almost too simple. I just output each "channel" in sequence, each channel separated by the Tab character (9), and each line (or data set) separated by CrLf (13+10). No labels, just the raw numbers. Requires a very simple program to capture serial input on the PDA or laptop and write to a text (.txt) file. The resulting text file can be opened directly with Excel and you just need to add the headings row. The graphing features in Excel are very easy to use. As for publishing the data format, all that would be needed is a description of what is in each channel and units used. I forgot, the first "channel" is time. Example of one log line: 12:49:24 PM 5115 6.0 7.2 96 106 13 62 88 2.3 910 894 0.0 21.6 26 00 00 17 74 13.8 Speadsheet heading row: Time RPM GPH GalsUsed WT: Water Temp (C) LRT: Air temp after left radiator (C) RRT: Air temp after right radiator (C) OT: Oil temp (C) after oil cooler OPT: Oil pan temp (C) WP: Water pressure (psi) OP: Oil pressure (psi) OFP: Fuel pressue two outer carbs (psi) CFP: Fuel pressure center carb (psi) EGT1 (C) Rotor 1: nearest water pump EGT2 (C) nearest flywheel MAP (inHg) Mix: Mixture: O2 sensor (mV) OAT: Outside Air Temp (C) - defect Volts (system voltage) Finn --------------090201040404010906070506 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Just as a datapoint for Tracy.

The way I do it is almost too simple. I just output each "channel" in sequence, each channel separated by the Tab character (9), and each line (or data set) separated by CrLf (13+10). No labels, just the raw numbers.
Requires a very simple program to capture serial input on the PDA or laptop and write to a text (.txt) file.
The resulting text file can be opened directly with Excel and you just need to add the headings row. The graphing features in Excel are very easy to use.

As for publishing the data format, all that would be needed is a description of what is in each channel and units used.

I forgot, the first "channel" is time. Example of one log line:
12:49:24 PM    5115     6.0     7.2     96    106     13     62     88     2.3    910    894     0.0    21.6     26    00    00    17    74    13.8               

Speadsheet heading row:
Time    RPM    GPH    GalsUsed    WT: Water Temp (C)    LRT: Air temp after left radiator (C)    RRT: Air temp after right radiator (C)    OT: Oil temp (C) after oil cooler    OPT: Oil pan temp (C)    WP: Water pressure (psi)    OP: Oil pressure (psi)    OFP: Fuel pressue two outer carbs (psi)    CFP: Fuel pressure center carb (psi)    EGT1 (C) Rotor 1: nearest water pump    EGT2 (C) nearest flywheel    MAP (inHg)    Mix: Mixture: O2 sensor (mV)    OAT: Outside Air Temp (C) - defect    Volts (system voltage)

Finn
 --------------090201040404010906070506--