PPRuNe Forums - View Single Post - Excel: Average formula question
View Single Post
Old 14th Nov 2007, 22:18
  #5 (permalink)  
Keef

Official PPRuNe Chaplain
 
Join Date: Apr 2001
Location: Witnesham, Suffolk
Age: 80
Posts: 3,498
Likes: 0
Received 0 Likes on 0 Posts
If you're looking to enter fuel purchases and mileage each time, then you can easily have a "rolling cumulative" average fuel consumption.

Just add up all the fuel added (use the SUM function) in gallons, and divide into the difference between latest mileage and "start" mileage.

I have a simple spreadsheet on my iPaq that does this very thing (in Excel).

There are blank lines for future entries, with an "IF" clause that leaves the average consumption column blank if there is no entry in the "fuel loaded" column for that line.
Keef is offline