Hi Wendell,

Yes, we need to get one of the Excel users to test it (if I didn't make
them all mad with my smart a** comment :).  I also found a 502 error in
the weight depending on the data input.  For example, If length is one
foot, any current from 301A to 379A gives a 502 error.  380A and above
gives a zero weight.  The zero makes sense because that's where the AWG
answer becomes 'See Chart'.

How about it Excel users.  Will one of you run the same data in the
spreadsheet I modified and compare it to Al's original?  Does it
calculate to the same AWG for reasonable data?  Do you see an error in
weight for current of 350A and length of 1 foot?  (Spreadsheet attached
to earlier post.)

Thanks,
Bob W.

On Sun, 29 Oct 2006 22:49:14 -0600
"Wendell Voto" <jwvoto@itlnet.net> wrote:

> Bob,
> Thanks a bunch.  I loaded it up in OO and it seems to work OK.  Maybe the awg is on the small side.  Calcs 20awg for 10A @ 16 feet.
> Wendell
> > 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/