Mailing List flyrotary@lancaironline.net Message #32913
From: Russell Duffy <russell.duffy@gmail.com>
Subject: Any Excel wizards out there (datalogging)
Date: Fri, 28 Jul 2006 14:51:52 -0500
To: 'Rotary motors in aircraft' <flyrotary@lancaironline.net>
Message
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
Subscribe (FEED) Subscribe (DIGEST) Subscribe (INDEX) Unsubscribe Mail to Listmaster