GasBuddy Blog

Message Forum - Read Message

Category: Fuel Economy > Topics	Add to favorite topics Post New Topic

Author	Topic: Have you downloaded my gas mileage spreadsheet?	Post a Reply Back to Topics

jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Nov 17, 2012 10:07:25 AM Ignore jrferrari Report Abuse In another post I ask if you record your gas mileage in some type of log, online, spreadsheet, or a paper log book. A Gas Buddy member asked me for a copy of the spreadsheet that I use and I provided a link where it can be downloaded: https://skydrive.live.com/redir?resid=34DBB50E3FAFCE63!509 I am just curious if anybody has downloaded it and found it useful. Or if anybody has any questions. I'm kinda geeky this way and my wife makes fun of me all the time because of it. ;)

jrferrari

All-Star Author
Orlando

Posts:652
Points:172,590
Joined:Jan 2011

Message Posted: Nov 17, 2012 10:07:25 AM

Ignore jrferrari Report Abuse

In another post I ask if you record your gas mileage in some type of log, online, spreadsheet, or a paper log book. A Gas Buddy member asked me for a copy of the spreadsheet that I use and I provided a link where it can be downloaded:

https://skydrive.live.com/redir?resid=34DBB50E3FAFCE63!509

I am just curious if anybody has downloaded it and found it useful. Or if anybody has any questions.

I'm kinda geeky this way and my wife makes fun of me all the time because of it. ;)

REPLIES (newest first)Ignore Short Messages

10261970 All-Star Author Sacramento Posts:977 Points:265,145 Joined:Oct 2011	Message Posted: Dec 28, 2012 9:42:24 AM Ignore 10261970 Report Abuse No.
Jeff1226 Sophomore Author Flint Posts:127 Points:8,075 Joined:Feb 2012	Message Posted: Dec 28, 2012 7:58:41 AM Ignore Jeff1226 Report Abuse no
dgsteven All-Star Author Los Angeles Posts:777 Points:202,900 Joined:Oct 2012	Message Posted: Dec 28, 2012 3:12:12 AM Ignore dgsteven Report Abuse no
roxanebay Veteran Author Nova Scotia Posts:482 Points:148,860 Joined:Jun 2008	Message Posted: Dec 26, 2012 11:53:27 PM Ignore roxanebay Report Abuse Thanks will check it out!
jonjon57 Champion Author Raleigh Posts:2,430 Points:631,260 Joined:May 2011	Message Posted: Dec 26, 2012 10:39:04 PM Ignore jonjon57 Report Abuse No
rjro Champion Author Albany Posts:1,237 Points:498,275 Joined:Jan 2011	Message Posted: Dec 21, 2012 8:15:28 AM Ignore rjro Report Abuse no.
DanFMA Champion Author Massachusetts Posts:1,091 Points:1,068,485 Joined:Apr 2008	Message Posted: Dec 21, 2012 8:02:09 AM Ignore DanFMA Report Abuse No.
jonjon57 Champion Author Raleigh Posts:2,430 Points:631,260 Joined:May 2011	Message Posted: Dec 21, 2012 7:37:45 AM Ignore jonjon57 Report Abuse No
Houckster Champion Author Atlanta Posts:9,337 Points:693,275 Joined:Sep 2003	Message Posted: Dec 20, 2012 1:26:37 PM Ignore Houckster Report Abuse DAVISADM writes: No offense, BUT This spreadsheet makes no sense. You should be entering the odometer reading, which then calculates trip mileage. The way it is set up you have to enter miles traveled, and it calculates odometer reading!?!?!?!?!?!?!?!?!?!?! ______ I agree somewhat. My assumptions are that the odometer only registers whole miles. I hate that! If your odometer shows tenths of a mile than DAVISADM is correct. If it doesn't, read on. If you enter odometer readings, then you'll know within a mile how many miles you have driven since the last refuel but if you want to know to the tenth of a mile, then you use the trip odometer that you set to 0 during the refuel where you begin recording the miles driven for each tankful. After that you DON'T reset the trip odometer, you just subtract reading at the refuel from the reading of the last refuel. The Excel formula you can use is: =a2-a1+if(a2<a1,1000,0). A2 is the current reful reading and A1 is the previous reading. The 1000 is based on the assumption that the odometer has a 1000 mile capacity. Many cars have two trip odometers so the second one is used for actual trips. [Edited by: Houckster at 12/20/2012 1:29:45 PM EST]
steffy628 Champion Author Pennsylvania Posts:1,751 Points:446,275 Joined:Apr 2011	Message Posted: Dec 20, 2012 10:42:50 AM Ignore steffy628 Report Abuse I use fuelly
dontuknowOH Champion Author Ohio Posts:2,097 Points:36,545 Joined:Aug 2009	Message Posted: Dec 17, 2012 11:01:43 AM Ignore dontuknowOH Report Abuse If your vehicle is older and a rwd type,and you frequently apply the park brake when exiting the car,possibly the rear brake cable has become extremely dry,deteriated,croded and not releasing properly at the rear drumsbut not noticable at the drivers location. Road salt/brine repeadly takes a toll on under chassie gear,heat builds up in rotation areas then possibly brake fluid heat expandsion also adds a growing closer clearances to cause B..shoe drag. One other is drive shaft U-joints can go dry after long usage,but ofter soon reveals itself. I don't believe a CEL will monitor these defects,the other > a brake fluid proportioning valve might be going faulty.A battery slowly going bad causing heavier alt.loads is possible...(usually a maintenence free type) I had one totally short out,killing a good chargers protection circuit breaker. Hints to keep going saving fuel....
CptSteve Champion Author Illinois Posts:13,171 Points:2,641,215 Joined:Jul 2005	Message Posted: Dec 17, 2012 10:22:49 AM Ignore CptSteve Report Abuse I have always found it easier to just keep a vehicle history book in the glovebox.
13Octane Champion Author Tucson Posts:2,147 Points:332,165 Joined:Aug 2005	Message Posted: Dec 16, 2012 9:30:05 PM Ignore 13Octane Report Abuse save yourself time. fuel log book right here on gas buddy
jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Dec 16, 2012 8:51:52 AM Ignore jrferrari Report Abuse @davisadm, That is easily changed. For me my trip odometer had a decimal place but my odometer didn't so I was able to get a little more accuracy this way. They was deviation over time between the spreadsheet odometer mileage and the actual odometer in the vehicle.
davisadm All-Star Author Los Angeles Posts:547 Points:405,625 Joined:Dec 2011	Message Posted: Dec 15, 2012 9:48:08 PM Ignore davisadm Report Abuse No offense, BUT This spreadsheet makes no sense. You should be entering the odometer reading, which then calculates trip mileage. The way it is set up you have to enter miles traveled, and it calculates odometer reading!?!?!?!?!?!?!?!?!?!?!
jonjon57 Champion Author Raleigh Posts:2,430 Points:631,260 Joined:May 2011	Message Posted: Dec 15, 2012 9:27:54 PM Ignore jonjon57 Report Abuse No
kxy4fw Champion Author Denver Posts:1,226 Points:275,255 Joined:Nov 2011	Message Posted: Dec 14, 2012 2:54:22 PM Ignore kxy4fw Report Abuse no
jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Dec 14, 2012 10:15:34 AM Ignore jrferrari Report Abuse Download is still available if you need a spreadsheet template to record you mileage.
Titanic1985 Champion Author South Carolina Posts:6,218 Points:355,070 Joined:Dec 2010	Message Posted: Dec 2, 2012 4:42:05 PM Ignore Titanic1985 Report Abuse You're very welcome, jrferrari. Take care :-) MGY (RMS Titanic's radio call sign).
jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Dec 2, 2012 12:16:51 PM Ignore jrferrari Report Abuse Thanks Titanic1985!
DanFMA Champion Author Massachusetts Posts:1,091 Points:1,068,485 Joined:Apr 2008	Message Posted: Dec 2, 2012 7:22:52 AM Ignore DanFMA Report Abuse No.
Titanic1985 Champion Author South Carolina Posts:6,218 Points:355,070 Joined:Dec 2010	Message Posted: Dec 1, 2012 8:04:18 AM Ignore Titanic1985 Report Abuse Good Morning jferrari. No, I don't keep "logs" of my gas mileage. I do monitor gas mileage on an ongoing basis while driving, but clear the results at fill-up time. Here is a link to the site you are referencing. It makes it easier for other GBs to know what you are talking about. Gas Mileage Spreadsheet Take care :-). MGY
Hemond Champion Author Providence Posts:8,147 Points:133,145 Joined:Oct 2006	Message Posted: Dec 1, 2012 6:11:02 AM Ignore Hemond Report Abuse I originally found the gasbuddy web on a google search strictly to use the fuel log. Since then I've kept 99.9 accuracy in recording fuel usage. I don't use your nice spreadsheet as I wanted the cloud storage of data that GB supplies. Data logging has proven invaluable. For example, my car has serious problems right now. Mileage has dropped 2mpg. (from 30 to 28mpg) The only reason I know there is a big problem is due to the fuel logging. No check engine light, yet clearly there is a serious failure to track down.
PaylessKY Champion Author Kentucky Posts:8,700 Points:1,577,450 Joined:Oct 2008	Message Posted: Nov 30, 2012 8:54:07 AM Ignore PaylessKY Report Abuse I use the GasBuddy log book.
GLM4205 Champion Author Toledo Posts:4,037 Points:796,295 Joined:Dec 2010	Message Posted: Nov 30, 2012 7:54:03 AM Ignore GLM4205 Report Abuse No what for???
MOREDLEG Champion Author Missouri Posts:2,635 Points:607,510 Joined:May 2011	Message Posted: Nov 29, 2012 10:08:12 PM Ignore MOREDLEG Report Abuse Gas Buddy Fuel Logbook, Keeps me p1553D off enough to see my annual expenditure, that is really depressing.
Z12 Champion Author Toledo Posts:3,637 Points:754,810 Joined:Mar 2011	Message Posted: Nov 29, 2012 9:47:55 PM Ignore Z12 Report Abuse Have not
hrspwr77 Champion Author Georgia Posts:1,478 Points:120,585 Joined:Oct 2012	Message Posted: Nov 29, 2012 5:42:02 PM Ignore hrspwr77 Report Abuse No. Keeping records won't help me save any more than I already save. It would only slow me down.
WEPSMAN Champion Author South Dakota Posts:10,503 Points:2,021,750 Joined:Mar 2005	Message Posted: Nov 27, 2012 9:33:44 AM Ignore WEPSMAN Report Abuse nope
wshokie12 Champion Author Winston-Salem Posts:1,300 Points:212,560 Joined:Aug 2012	Message Posted: Nov 27, 2012 12:27:59 AM Ignore wshokie12 Report Abuse no
traffic cop Champion Author Boston Posts:1,237 Points:532,840 Joined:Oct 2004	Message Posted: Nov 22, 2012 2:20:22 PM Ignore traffic cop Report Abuse No.
2amy Champion Author Fresno Posts:1,704 Points:602,355 Joined:Feb 2011	Message Posted: Nov 22, 2012 12:37:33 PM Ignore 2amy Report Abuse no.
KansasGunman Champion Author Kansas City Posts:21,433 Points:2,104,380 Joined:Oct 2005	Message Posted: Nov 22, 2012 7:48:59 AM Ignore KansasGunman Report Abuse I guess I just do it for fun :) ..... That makes sense, especially when data collecting is an every day event for you...have fun. Four of the five vehicles we own have on-board computers giving reasonably accurate feedback on current, average and accumulative MPG and our 45 ft RV has a rather sophisticated on-board computer providing more information than I care to know about. Interesting data but aside from that, its simply just more information overload...it is what it is. Have a nice Thanksgiving all! [Edited by: KansasGunman at 11/22/2012 7:49:45 AM EST]
jonjon57 Champion Author Raleigh Posts:2,430 Points:631,260 Joined:May 2011	Message Posted: Nov 22, 2012 7:13:26 AM Ignore jonjon57 Report Abuse No
jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Nov 21, 2012 5:57:56 PM Ignore jrferrari Report Abuse @KansasGunnman, As my profession I analyze business data to either gain a competative advangtage or for monetary gain. But for the life of me I can think of a measureable benefit you can gain from gas mileage data. I guess I just do it for fun :)
2amy Champion Author Fresno Posts:1,704 Points:602,355 Joined:Feb 2011	Message Posted: Nov 21, 2012 5:23:58 PM Ignore 2amy Report Abuse No.
KansasGunman Champion Author Kansas City Posts:21,433 Points:2,104,380 Joined:Oct 2005	Message Posted: Nov 21, 2012 1:31:33 PM Ignore KansasGunman Report Abuse And the good that comes from collecting all this data? Will it save your way to early retirement? Does it make the difference between going hungry? Just curious...obviously if there is a meaningful and beneficial result to this mental gymnastic, well then hecks fire man have at it!
jrferrari All-Star Author Orlando Posts:652 Points:172,590 Joined:Jan 2011	Message Posted: Nov 21, 2012 11:10:22 AM Ignore jrferrari Report Abuse @OilerFan The spreadsheet that I put together has several graphs that are generated off of the data that you enter. It will graph the price of gas over time, mpg over time, cost per mile, and also cost per day. If there is data to support it other calculation can be performed too. I record the brand of gas too, so if I wanted to I could calculate mpg by brand of gas to see if there is a difference.
OilerFan Champion Author Tulsa Posts:14,027 Points:2,445,115 Joined:Aug 2005	Message Posted: Nov 20, 2012 7:10:52 AM Ignore OilerFan Report Abuse I also have a spreadsheet. It calculates mpg, but also cost per mile.
DoctorOH Champion Author Cleveland Posts:4,848 Points:1,073,400 Joined:Mar 2010	Message Posted: Nov 20, 2012 12:52:43 AM Ignore DoctorOH Report Abuse No
gvan Champion Author Chicago Posts:21,502 Points:2,832,290 Joined:Dec 2004	Message Posted: Nov 19, 2012 1:03:13 PM Ignore gvan Report Abuse I use the GasBuddy Fuel Logbook.
PatAZ Champion Author Tucson Posts:9,227 Points:122,020 Joined:May 2008	Message Posted: Nov 19, 2012 11:29:16 AM Ignore PatAZ Report Abuse Sorry no interest in it. [Edited by: PatAZ at 11/19/2012 11:30:25 AM EST]
OceanArcher Champion Author Mississippi Posts:5,688 Points:1,324,375 Joined:May 2004	Message Posted: Nov 18, 2012 8:12:45 PM Ignore OceanArcher Report Abuse Thank you for the offer, but I keep my records with a pencil and paper ...
Maintroll Champion Author Lexington Posts:8,614 Points:1,699,135 Joined:Aug 2008	Message Posted: Nov 18, 2012 8:23:22 AM Ignore Maintroll Report Abuse I don't need it as I check mine on each fill up by using the trip meter on my car.
carinthuist Champion Author San Francisco Posts:2,221 Points:326,010 Joined:Mar 2012	Message Posted: Nov 17, 2012 5:33:03 PM Ignore carinthuist Report Abuse nom I haven't downloaded gas spreed sheet