|
|
On Fri, 27 Oct 2006 17:08:48 -0700
"Al Gietzen" <ALVentures@cox.net> wrote:
> I tried using it but with my spread sheet program it gives err.504 in the
> calculation.
>
> Guess I need to buy a good program.
>
>
>
> You don't need a good one - just one from MS called Excel:-).
>
>
>
> Al
>
>
The error was caused by the LOOKUP functions which all had an 18 cell
search vector and a 17 cell results vector. Apparently Microsoft knows
their users lack programming skills and ignore such errors. ;)
Anyway a modified version is attached. The only change I think I've
made was to make the search and result vectors the same length. Could
one of you Excel users compare the results to the original to see
if the calculations are the same.
Thanks,
Bob W.
--
N93BD - Rotary Powered BD-4 - http://www.bob-white.com
First engine start 1/7/06 - Special Airworthiness Certificate 10/1/06
Cables for your rotary installation - http://www.roblinphoto.com/shop/
|
|