Spread sheet for gas mileage logs
#21
Registered User
Join Date: Mar 2003
Location: Denver, CO
Posts: 186
Likes: 0
Received 0 Likes
on
0 Posts
It cant calculate the average MPG because the MPG column is divided by zero until you input the number of gallons purchased. I think its possible to right a custom function that would average it correctly using an if statement bu I am not sure how to do this
#22
Contributing Member
Originally Posted by Juppers
I ran across this thread and thought it was a cool idea. I took Corey's spreadsheet and made some changes. You enter Date, Odo, Total gallons bought, total cost, and it calculates the trip, $ per gallon, and MPG for you, including average MPG. It is good for 2000 entries, which I figure should be enough for a little while and avoids #DIV/0 stuff.
You can get it at http://www.dahanga.com/MPG_Report.xls
You can get it at http://www.dahanga.com/MPG_Report.xls
#23
Registered User
Join Date: Sep 2002
Location: Lexington, KY
Posts: 84
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Yoda
You could add columns to track brand and type (prem, regular). You have to remember the gas type affects your NEXT MPG reading.
Any other good ideas?
Updated again to not be so wide. Moved totals to top of the sheet instead of off to the side.
Last edited by Juppers; 08-06-2006 at 09:51 AM.
#25
Contributing Member
Join Date: Jun 2005
Location: San Jose, CA
Posts: 1,725
Likes: 0
Received 0 Likes
on
0 Posts
I use www.sanjosegasprices.com 's Fuel Logbook function. They have sites for other states/cities as well. It's all hosted by www.gasbuddy.com
I always wanted to make my own site similar to that, but I still haven't gotten around to it...maybe one day
I always wanted to make my own site similar to that, but I still haven't gotten around to it...maybe one day
#26
Contributing Member
I don't remember how to do it, but how about keeping the totals and the column titles always at the top of the view.
So you could be enntering data on line 200, but it still shows the titles locked on top.
So you could be enntering data on line 200, but it still shows the titles locked on top.
#27
Registered User
Join Date: Sep 2002
Location: Lexington, KY
Posts: 84
Likes: 0
Received 0 Likes
on
0 Posts
Really good ideas. Now I have frozen the total and header section as Yoda suggested, and added a chart to track MPG over time, like on the gasbuddy site marko3xl3 posted. Still at http://www.dahanga.com/MPG_Report.xls
#28
This one is different than my current one.
Can you fix it?
Or is it the same?
http://www.pnw4runners.com/index.php...jc_mpg_new.xls
Can you fix it?
Or is it the same?
http://www.pnw4runners.com/index.php...jc_mpg_new.xls
#29
Registered User
Join Date: Sep 2002
Location: Lexington, KY
Posts: 84
Likes: 0
Received 0 Likes
on
0 Posts
Oops! I had some test data in there. It is updated with your stuff now Corey. Plus I fixed a problem with the graph scaling properly into the future. It will look funny until the data spans a bit more time. New version at http://www.dahanga.com/MPG_Report.xls
#32
Registered User
Join Date: Sep 2002
Location: Lexington, KY
Posts: 84
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Corey
Thanks, got the new one.
I get an error message though when I try to enter super premium and Safeway for my gas.
It says:
A user has restricted user cells or something like that.
I get an error message though when I try to enter super premium and Safeway for my gas.
It says:
A user has restricted user cells or something like that.
#33
My bad, I did not see the drop downs
I did not know you could do that.
Told ya I was a noob to the world of spread sheets.
I am behind the times on them.
It worked perfect.
Choose the rating, then typed in the store, and it worked.
Thannks again.
I did not know you could do that.
Told ya I was a noob to the world of spread sheets.
I am behind the times on them.
It worked perfect.
Choose the rating, then typed in the store, and it worked.
Thannks again.
#35
Sponsor
wow some how i missed this thread for a week... ya i see what i did wrong wiht my sheet that got the div/0 error. but Juppers is way nicer then mine so i'd use his glad your seeing 20 mpg on your FJ... i wish i could get my 4unner to see 20s.. lol.
#37
Sponsor
jupper, i hope you dont mind but i added a sheet to your work. i added a my maintaince record there.. i keep tabs of all the maintaince on my truck so when work was last done to it..,. http://www.eakland.net/MPG_Report.xls
#39
A request please.
Here is my current one.
http://www.pnw4runners.com/index.php..._mpg_maint.xls
It has the Maintenance tab on it, but not much info.
Can it be erased all of that info and a new setup with all this info be added via drop down list, and then just input the date, mileage and money involved in the maintenance item like I do for the gas on the MPG tab?
This would be very cool, and a great way to track all maintenance on our rigs.
Oil change
Coolent flush
Transmission flush
Wiper blades
Differential oil
Front end 4x4 bearing repack/grease
Brake service
Tires
Battery
Tune-up
Air filter
(Add anything else that gets done often)
And a misc. box where you can type in a service that is not included in the above list, or a blank spot in the drop down list that lets us type in manually the item.
That would be good for if you are paying to have a mod installed.
Here is my current one.
http://www.pnw4runners.com/index.php..._mpg_maint.xls
It has the Maintenance tab on it, but not much info.
Can it be erased all of that info and a new setup with all this info be added via drop down list, and then just input the date, mileage and money involved in the maintenance item like I do for the gas on the MPG tab?
This would be very cool, and a great way to track all maintenance on our rigs.
Oil change
Coolent flush
Transmission flush
Wiper blades
Differential oil
Front end 4x4 bearing repack/grease
Brake service
Tires
Battery
Tune-up
Air filter
(Add anything else that gets done often)
And a misc. box where you can type in a service that is not included in the above list, or a blank spot in the drop down list that lets us type in manually the item.
That would be good for if you are paying to have a mod installed.
#40
Update on MPG spreadsheet
My apologies if this discussion has been relocated, but can anyone provide me with a current copy of the MPG spreadsheet?
...none of the links above are still alive.
Cheers!
...none of the links above are still alive.
Cheers!