I saw an excell weight and balance spreadsheet for a chieftain some time back. It had a nice graph on a separate tab with lines joining MTOW - ZFW etc. Does anyone know if this would be programmed using VBA or just straight formulas and graphs in excell:8?

I did one for B747 Classic a few years ago entirely in formulae and graphs with drop down selects for each aircraft, crew and catering config.
Be quite a coupe for a 2yo :)

Probably just a graph. VBA doesn't really give you more functionality, it's more about automating functions that are already there.

I did a graph some time ago which only plotted the CG points for TO and LDG masses, and used a static set of data to draw the outline of the CG envelope.

However, using the same principle it should be possible to draw lines linking ZFW, MLW and MTOW using a set of data whose values are updated by calculations elsewhere.

To answer the question properly, no VBA was hurt in the making of my spreadsheet :)

Basil ...Basil

It is even more poignant when you consider a 2yo knows the difference between a two door car and a notable success!

Just kidding. :}...:)...:ok:

Does anyone want to share their spreadsheet?

Paul

Just testing, old boy :ok:

I did a W&B Excel sheet for the Arrow a few years ago.

Didn't work.

I stole a nifty HTML one instead. That lives on our Group website so everyone can do the sums online.