X-Virus-Scanned: clean according to Sophos on Logan.com Return-Path: Received: from [216.211.128.10] (HELO mail-in02.adhost.com) by logan.com (CommuniGate Pro SMTP 5.1c.2) with ESMTP id 1320805 for flyrotary@lancaironline.net; Fri, 28 Jul 2006 16:19:48 -0400 Received-SPF: none receiver=logan.com; client-ip=216.211.128.10; envelope-from=joeh@pilgrimtech.com Received: from Pilgrim10 (tide509.microsoft.com [131.107.0.79]) by mail-in02.adhost.com (Postfix) with ESMTP id 7E2342BDD05 for ; Fri, 28 Jul 2006 13:18:47 -0700 (PDT) (envelope-from joeh@pilgrimtech.com) From: "Joe Hull" To: "'Rotary motors in aircraft'" Subject: RE: ***SPAM*** [FlyRotary] Any Excel wizards out there (datalogging) Date: Fri, 28 Jul 2006 13:18:42 -0700 Message-ID: <005101c6b283$0b3684a0$bc40379d@redmond.corp.microsoft.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0052_01C6B248.5ED7ACA0" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: Acayf2pCUlB0R/aRQ2q7kdKRMpG3fwAAqJAg In-Reply-To: This is a multi-part message in MIME format. ------=_NextPart_000_0052_01C6B248.5ED7ACA0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit If the data is ALWAYS in the same columns - you can use the DATA/IMPORT menu function. It is under "Data" then "Import External Data" then "Import Data" Select your file, then when the "Wizard Dialog box" appears check the "Fixed Width" box. Click "Next" and set where your columns start/stop by clicking in the numbered bar at the top. If it's not a fixed position file - send it to me and I'll parse it for you. Joe Hull Cozy Mk-IV N31CZ (65 hrs - Rotary 13B NA) Redmond (Seattle), Washington _____ From: Rotary motors in aircraft [mailto:flyrotary@lancaironline.net] On Behalf Of Russell Duffy Sent: Friday, July 28, 2006 12:52 PM To: Rotary motors in aircraft Subject: ***SPAM*** [FlyRotary] Any Excel wizards out there (datalogging) Greetings, This is only distantly related, since it might be a way to collect data from the EM2, but for now it's for my Dynon. I'm looking for someone who knows a lot more about excel than I do. I have managed to collect raw serial data from the Dynon, which is a string of about 120 ASCII characters per line. I need to be able to import this into Excel, but have it spread out across multiple columns. For example, I might want the first two characters of each line in the first column, then the next four characters in the 2nd column, etc, defining how many characters go in each column. If there were delimiters in the data, it would be easy, but there aren't any. If anyone can help me figure out how to do this, please email me offlist. I really don't want to clutter the list with this. Thanks, Rusty russell dot duffy at gmail dot com ------=_NextPart_000_0052_01C6B248.5ED7ACA0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Message

If the data is ALWAYS in the same = columns – you can use the DATA/IMPORT menu function.

 

It is under “Data” then = “Import External Data” then “Import = Data”

Select your file, then when the = “Wizard Dialog box” appears check the “Fixed Width” box. Click = “Next” and set where your columns start/stop by clicking in the numbered bar at = the top.

 

If it’s not a fixed position = file – send it to me and I’ll parse it for = you.

 

Joe = Hull

Cozy Mk-IV N31CZ (65 hrs - Rotary = 13B NA)

Redmond (Seattle), Washington

 

From: Rotary motors in = aircraft [mailto:flyrotary@lancaironline.net] On Behalf Of Russell Duffy
Sent: Friday, July 28, = 2006 12:52 PM
To: Rotary motors in aircraft
Subject: ***SPAM*** = [FlyRotary] Any Excel wizards out there (datalogging)

 

Greetings,<= /p>

 

This is only distantly related, since it might = be a way to collect data from the EM2, but for now it's for my = Dynon.  I'm looking for someone who knows a lot more about excel than I do.  I = have managed to collect raw serial data from the Dynon, which is a string of = about 120 ASCII characters per line.  I need to be able to import this = into Excel, but have it spread out across multiple columns.  = <= /p>

 

For example, I might want the first two = characters of each line in the first column, then the next four characters in the = 2nd column, etc, defining how many characters go in each = column.  If there were delimiters in the data, it would be easy, but there aren't any.  

 

If anyone can help me figure out how to do = this, please email me offlist.  I really don't want to clutter the list = with this.  <= /p>

 

Thanks,<= /p>

Rusty <= /p>

russell dot duffy at gmail dot com = <= /p>

------=_NextPart_000_0052_01C6B248.5ED7ACA0--