W&B spreadsheet... with a twist
I'm looking for a W&B spreadsheet, but with a twist.
I want to be able to input the empty weight/balance data, the pilots weight, the maximum fuel capacity and moment, the moment arm of the front/aft seats and the max W&B graph points, and then get a textual plus graphical output of the max variable weight (passengers, mostly), assuming half full and full tanks, plus the allowed weight distribution of those pax front/aft.
Assuming a standard 4-seat club aircraft (PA28, C172, DR400 or similar) with just one fuel tank (or two with the same moment arm) and no complicated W&B restrictions.
This is so that I can rapidly set up a few of these calculations in advance, without having to recalculate the W&B every time. But it needs to be done for multiple aircraft so I want to automate things as far as possible.
Now I appreciate that this may not be readily available, but if somebody has done an Excel or OpenOffice spreadsheet that does a graphical display of a normal W&B calculation, that would be a major step in the right direction already. Anyone?
Last edited by BackPacker; 13th November 2010 at 18:04.