Home‎ > ‎D) Software‎ > ‎D.A) VBA‎ > ‎

D.8.2) Tank Modelling

A large fuel tank consisted of seven bays, each bounded by bays sealed to form a weir. Holes between the bays allowed fuel to move between them and a number of smaller holes allowed fuel to transfer between bays under a rubber liner.

Using Excel and VBA I modelled all of the different flows (using ESDU data to model pumps and jet-pumps) to show the fuel quantities and flow rates between bays at different attitudes and control strategies.

Using Excel charts allowed puddle-plots to be produced.

The volume of fuel in each bay varied over time.