Cessna 182 Weight & Balance Spreadsheet
 

Thanks to some guidance from helpful work colleagues and useful input from Brooklands (also MikeCross), I have managed to get my C182 Weight & Balance Spreadsheet doing what I wanted it to do, which was to indicate visually when the W&B data was outside POH limits. This was a bit complex, due to a non-linear envelope.

This is obviously aircraft specific (and is also fairly inelegant Visual Basic code) but if someone is interested in taking this idea and developing it for their own aircraft, I've posted the spreadsheet on my MSN Group site. It may well be that the guts of the code are re-usable. For those with security settings on their MS Office that warn about macros in the code, it was virus free when it left me!! :) I have tested the thing empirically and it has given me the correct results for the data I've entered - it's not guaranteed bomb proof!

the link doesnt work

Andyb79 - just checked and the link works for me. Just wondering whether it's part of your Internet Explorer security settings as the sheet contains macros; it may be that your browser is rejecting the spreadsheet as a result.

If you want a copy, I can email it if you wish.

CB,

Link is asking me to sign in. I guess your pc is set to automatically log in :)

dp

checked again it seems that it is a members area?
if you could email it i would be grateful

For those who need a copy of the spreadsheet, I'll email it if you send your address in a PM (I've already sent 7 copies, 5 of whom are lurkers!!).

Not too sure why it's asking for a log-in, as this is an open area - I'll update the link and see what happens.