I'm creating an aircraft fuel loading sheet that will tell me how to distribute the fuel weight in pounds (lb.) across the five fuel tanks of the airplane. Each tank has a maximum capacity as indicated in cells D5, F5, H5, J5, and L5. The fuel load entered in cell A2 must be distributed evenly across each tank pair for proper weight and balance. The tanks must be filled in the following sequence Inner Tanks (left and right), then the Outer Tanks (left and right), and last the Center Tank. When the maximum capacity is reached for the inner tank pair the remaining fuel load should be distributed evenly among the outer tank pair, and lastly if necessary to the center tank. I'm looking for a formula that will do this automatically based on the value entered in cell A2. Any help you can provide would be greatly appreciated.
A320neo Weight Calculations.xlsx
A B C D E F G H I J K L M 1 BLOCK FUEL (LB) 2 17,449 USEABLE FUEL 3 Left Outer Tank (2) Left Inner Tank (1) Center Tank (3) Right Inner Tank (1) Right Outer Tank (2) 4 Fuel Load Max Cap Fuel Load Max Cap Fuel Load Max Cap Fuel Load Max Cap Fuel Load Max Cap Total 5 1,520 11,982 14,281 11,982 1,520 0 Fuel
Cell Formulas Range Formula M5 M5 =SUM(C5,E5,G5,I5,K5)
| A320neo Weight Calculations.xlsx | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | BLOCK FUEL (LB) | ||||||||||||||
| 2 | 17,449 | USEABLE FUEL | |||||||||||||
| 3 | Left Outer Tank (2) | Left Inner Tank (1) | Center Tank (3) | Right Inner Tank (1) | Right Outer Tank (2) | ||||||||||
| 4 | Fuel Load | Max Cap | Fuel Load | Max Cap | Fuel Load | Max Cap | Fuel Load | Max Cap | Fuel Load | Max Cap | Total | ||||
| 5 | 1,520 | 11,982 | 14,281 | 11,982 | 1,520 | 0 | |||||||||
Fuel | |||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| M5 | M5 | =SUM(C5,E5,G5,I5,K5) |
