Subject: Excell
From: Rotary Engine
Date: 10/27/2005, 6:08 PM
To: AA-me



Anybody up to speed on Excell

How do I subtract a couple of times formated
as 3:33:53:454?

hours:minutes:seconds:hundreads of seconds

Paul Lamar ...No rotor no motor.


Hi Paul,

I can't say for sure if Excell is the same, but in the OpenOffice
spreadsheet I can format the cell as HH:MM:SS.00  When I subtract one
cell from another, it just does it.  I notice you have 3 digits in the
last group.  Did you mean thousands of a second?

You might consider donwloading OpenOffice.  Version 2.0 is out.  I'm
just now trying it.  I have opened some fairly complicated spreadsheets
from Excell with OpenOffice 1.1 and 2.0 is supposed to have even
better comptatbility.  The price is righ, and it runs on Linux as well
as everything else.

I've attached the spreadsheet in Excell format.  You might load it up
and see how it responds in Excell.

Bob W.


-- 
http://www.bob-white.com
N93BD - Rotary Powered BD-4 (projected engine start in November)
Custom Cables for your rotary installation -
http://www.roblinphoto.com/shop/

Funny you should mention it. I am using Open Office :)
I thought I was the only person on here using it.
I figured they did things pretty much the same way as Excell.

Yes the time data is to the nearest 1/1000 of a second.

Here is the coast down data in zipped form.
The idea here is to subtract the the time increments.
Convert the MPH to feet per second 88/60 times MPH = FPS
Subtract the MPH increment.
Then calculate the instant decelleration (more or less)
in FPS per Second by dividing by the time increment.

Convert to G's by dividing by 32
Multiply the G's by 3300 pounds and that gives the drag
at that MPH number.

Plot the drag as a function of MPH.

There are two coast down data sets. One in each direction.

The zip file has the coast down data and some constant
speed data. I will get more constant speed data tonight
on my way home from the hangar.

Paul Lamar ...No rotor no motor.

The Rotary Engine NewsLetter. Powered by Linux.
ACRE NL web site. http://www.rotaryeng.net
Copyright 1998-2005 All world wide rights reserved.