Excel fuel cost formula?
I’m looking for the excel formula to calculate the cost of fuel for a trip.
I know it exists but I can’t find it. It needs to calculate the cost of fuel used for a particular leg or flight when the trip used a combination of fuel from multiple uploads at different prices.
Example: We just completed a trip that used 500 gallons of fuel. Prior to the trip we uploaded 300 gallons at $5/gal. on top of 400 gallons that were still in the plane from the fueling before that one at $6/gal. Therefore, the 500 gallon trip we just made used 300 gallons of fuel at $5/gal. and 200 gallons that were still in the plane prior to the most recent fueling at $6/gal. The formula will also have to account for the cost of any fuel that may have still been in the plane from maybe up to 3 previous fueling. An average isn’t good enough, it needs to calculate the exact cost of fuel used.
Anyone know where to find the formula?