Steps to use excel for gas mileage?

[ero3]

I found a template in my PPC for gas mileage, I can enter all of the info but how do I get it to calculate?

I mean, I guess this is my interpretation of what to put in each cell, please correct me if I am wrong

DATE means date entering the info
FROM date I started on that tank
TO date I am ending or filling up that tank
PURPOSE commuting
START miLeage that tank started at
FINISH mileage the tank finished at

[allgire]

I suppose something like this can be used however you want to interpret it.

My take on it is this:

Date - the date of the trip in question
From - Location that you started from
TO - Location you are ending at
Purpose - Reason for this trip
Start - beginning mileage (your odometer reading at the FROM location.
Finish - ending mileade (you odometer reading at the TO location.

This is how I've always used it - especially helpful for me when filling out my expense report for work. I may have to travel to a half dozen locations - this keeps track of the mileage.

OT - My best (or is that worse case) - had to drive from Chicago area to the Madison office to work on a computer - left extra early from home - got to the other office by 8am - had to wait until 10 for Airborne Express only to receive nothing. After making a few calls - found out that computer was never shipped by "former" boss. Drove from Madison to different chicago area office to get missing computer - stopped by another neighboring office - then headed back to Madison - completed work - and then drove back home. - that was over 500 miles driving for a highly paid tech to do a 2 hour job. oh yeah - plus tolls, expenses for breakfast, lunch and dinner.

Now - if you want to do something for tracking your gas mileage - then a formula or two could certainly be put in. something like the ending mileage subtracting the beginning mileage and divided by the number of gallons for that fillup - just add a column that has the number of gallons per fillup.

Hope this helps.

[beantown53]

Originally posted by allgire
.

Now - if you want to do something for tracking your gas mileage - then a formula or two could certainly be put in. something like the ending mileage subtracting the beginning mileage and divided by the number of gallons for that fillup - just add a column that has the number of gallons per fillup.

Hope this helps.

Assuming the following:

Cell A1 = beginning mileage
Cell B1 = ending milage
Cell C1 = gallons of gas

the forumla for miles per gallon will be "=sum( (b1-a1)/c1)" - (without the quotes).