Sign in to follow this  
Followers 0
spinner

Spreadsheet template for tracking mileage

13 posts in this topic

It can be done all sorts of different ways, and here's but one of them. It's a starting point for building up to something you're comfortable using. At the very least, you get some handy conversions:

A4: "Date"

B4: "Odometer"

C4: "Litres"

D4: "Net Price"



F4: "Price/l"

G4: "Price/km"

H4: "Distance"

I4: "l/100 km"

J4: "MPG (Imp.)"

K4: "MPG (USA)"





B5: {enter the odometer reading upon delivery}





A6: {enter a date}

B6: {enter odometer reading at fill-up}

C6: {enter litres purchased}

D6: {enter net price}



F6: =D6/C6

G6: =D6/H6

H6: =B6-B5

I6: =C6/H6*100

J6: =(H6*0.621371)/(C6*0.219969)

K6: =(H6*0.621371)/(C6*0.264172)

So, row 4 are the titles, row 5 is a start point with one entry (cell B5), and row 6 is the one with all the calculations. This row you can copy and paste "downwards" to the rows below it. Don't worry about the division-by-zero errors; They'll disappear as you fill in the rows. And, format the number cells for currency, floating-point decimal places, etc.

Every time you fill up, get a receipt and write on it your odometer reading.

Share this post


Link to post
Share on other sites

I tried it but I can't seem to get the formulas to give actual numbers...then again, me and Excel don't see eye to eye very often...

Any suggestions? I followed the instructions exactly.

Share this post


Link to post
Share on other sites

With the file/image upload system, you can now upload Excel spreadsheets if that helps.

Cheers.

Share this post


Link to post
Share on other sites

I got back an error that says .xls attachments are not allowed.

Try it now. Sorry about that. I didn't realize there was another area for permissions. Let me know if it doesn't work.

Cheers.

Share this post


Link to post
Share on other sites

Thanks Matt + Xan!!

Share this post


Link to post
Share on other sites

I tried it but I can't seem to get the formulas to give actual numbers...then again, me and Excel don't see eye to eye very often...

Any suggestions? I followed the instructions exactly.

:scratch: Hmm, I wonder if I left something out. Seems to me that in Excel when you enter a formula (with the equals sign in front), it will automatically calculate that cell once you hit enter. The A..D columns are user imput -- not actually filled with descriptions in curly braces. Or Excel has calculations turned off. :dunno:

Share this post


Link to post
Share on other sites

I'll try modifying Matt's and see if that hits the mark....

Share this post


Link to post
Share on other sites

I've got all the regular bells and whistles on my fuel economy spreadsheet..... but one of my favourite is the "Tank Rank" statistic. It returns the rank of the latest tank as compared to all previous tanks....

so a car that experiences better and better tanks will have a series of 1's.

=RANK(H28,$H$2:H28,1) ; where column H is L/100km column.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

    Chatbox
    You don't have permission to chat.
    Load More