MS Excel wizards check in please

[TurboDave]

I need a formula to add to a spread sheet that I have tracks fuel and maint. costs. (primarilly fuel).

Here's how it's laid out now, column by column.

For data entry I have:
Date------$/gallon-----gallons purchased-----miles driven. continuing on, I have several columns for calculating the following:
MPG-----gallons/100 mi-----litres/100 km-----cost/fillup-----days between fillups. continuing on, I have more datat entry columns?
Odometer-----Comments.


Here's my dilemma, I would like to add a column to figure Cost per mile, but cant for the life of me put together a formula to do that. I know I have enough info in the above colums to do that, but which ones. and what functions to use.

My srpead sheet also tracks costs of maintenance, but I don't need to add those into the equation yet, because with my new car there won't be any maintenance costs for at least 4 years. (paid for by Lincoln)


Any help is appreciated!

 

[gnX405]

I'm not sure I fully understand the question, but perhaps the following info will help:

Let's assume that column A is where the Cost ($) is listed, and column B is where the total mileage between fill-up is listed. To calculate cost per mile you can add the following equation in another column that is simply =A#/B##
That equation will calculate the money spent to travel that distance or in other words cost per mile.

Replace the # sign with the row number for your calculation, for example if you are on row number six the equation for that row will be =A6/B6
The equal sign needs to be in the equation.

If you'd like to sum all of the money spent, scroll down to the bottom of column A and put the following in the cell =sum(A#:A##)

Where the # is the first row in the column, and ## is the last row in the column you'd like to sum.

Sum both the columns and divide them and you'll have total cost per mile.

If this doesn't get you what you want, feel free to email me your spreadsheet with a note and I'll help you out.

-john
P.S. Qualifying for Sonoma is this afternoon, the track is slick and the championship points battle is in full swing with only three races left, should be a good one to tune into.

 

[aminga]

Check your PM's

 

[TurboDave]

Check your PM's

On it's way.

 

[TurboDave]

I'm not sure I fully understand the question, but perhaps the following info will help:

Let's assume that column A is where the Cost ($) is listed, and column B is where the total mileage between fill-up is listed. To calculate cost per mile you can add the following equation in another column that is simply =A#/B##
That equation will calculate the money spent to travel that distance or in other words cost per mile.

Replace the # sign with the row number for your calculation, for example if you are on row number six the equation for that row will be =A6/B6
The equal sign needs to be in the equation.

If you'd like to sum all of the money spent, scroll down to the bottom of column A and put the following in the cell =sum(A#:A##)

Where the # is the first row in the column, and ## is the last row in the column you'd like to sum.

Sum both the columns and divide them and you'll have total cost per mile.

If this doesn't get you what you want, feel free to email me your spreadsheet with a note and I'll help you out.

-john
P.S. Qualifying for Sonoma is this afternoon, the track is slick and the championship points battle is in full swing with only three races left, should be a good one to tune into.

I didn't think it would be that simple(A#/B#), but apperently it is. For some reason I was thinking my MPG column would have to come into play somehow.

 

[TurboDave]

I replaced the L/100KM column formulas with a $/mile formula. Seems to do the trick., and at the bottom I have a running average based on the totals for those columns.

 

[TurboDave]

If you'd like to sum all of the money spent, scroll down to the bottom of column A and put the following in the cell =sum(A#:A##)

Where the # is the first row in the column, and ## is the last row in the column you'd like to sum.

Sum both the columns and divide them and you'll have total cost per mile.

.

I've got all the columns taken care of. I've been running this spread sheet for over 5 years. First 5 years on the Honda, and now on it's replacement the Lincoln.
Plus, I enter the data on Fuelly.com