MPG in Excel

  theearlofsabden 18:00 12 Aug 2008

I want to record all my fuel into an Excel spreadsheet.

Has anyone got a template they could email with regarding effectively working out litres to gallons and returning a MPG result.

Many thanks


  bremner 18:08 12 Aug 2008

Column A - Miles travelled

Column B - Litres of fuel purchased.

Column C - Divide Column B by 4.55 to get gallons

Column D - Divide colmun A by Column C for MPG

  theearlofsabden 18:13 12 Aug 2008

Do I need to replicate any of the formula(s) if I want to use it week after week, record after record?

How does row 2, the second entry of miles travelled get the result of row 1, the first entry



  VoG II 18:23 12 Aug 2008

In column D use the formula


assuming that you want to calculate cumulative MPG.

  theearlofsabden 18:31 12 Aug 2008

Yea..... each week (entry) I want the spreadsheet to automatically make the conversion from litres to gallons and calculate the MPG.

So I just need to add =SUM(A:A)/SUM(C:C) and that'll do the trick?


  VoG II 18:36 12 Aug 2008

I'm not clear what you want to do.

If you just want to calculate MPG for each time you refill use bremner's formulas and fill them down as far as needed.

If you want the overall average MPG to be calculated then use my formula in column D, also filled-down as far as needed.

To fill-down a formula, enter the formula in a cell, click on that cell, hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as needed.

  theearlofsabden 18:41 12 Aug 2008

I'm aware that I can fill down as needed, but could I not format the spreadsheet to do that automactically at each entry by e.g

by using a $ relative formula, say for the first 100 records, so then I would have no need to fill down.... if so where would I insert $


  I am Spartacus 18:41 12 Aug 2008

I've got a template I used to use when I had a car. I can clear it out but leave some sample data in if you want.

Click on the yellow envelope next to my name if you want me to send it.

  VoG II 18:44 12 Aug 2008

As an example


You can fill this down as far as needed. It won't display anything unless there is an entry in column B.

  theearlofsabden 18:45 12 Aug 2008

Thanks VoG, bremner and I am Spartacus


  I am Spartacus 18:54 12 Aug 2008

On its way. I've stripped out all but a sample of the data. There's also a chart attached.

It won't be as elegant as one that VoG would put together but I used it from 1992 to last year.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017