Not Logged In Log In   Sign Up   Points Leaders
Follow Us    3:26 AM

Message Forum - Read Message

Category: Fuel Economy > Topics Add to favorite topics   Post new topicPost New Topic
Author Topic: Have you downloaded my gas mileage spreadsheet? 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

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) Post a Reply
Profile Pic
10261970
All-Star Author Sacramento

Posts:977
Points:265,145
Joined:Oct 2011
Message Posted: Dec 28, 2012 9:42:24 AM

No.
Profile Pic
Jeff1226
Sophomore Author Flint

Posts:127
Points:8,100
Joined:Feb 2012
Message Posted: Dec 28, 2012 7:58:41 AM

no
Profile Pic
dgsteven
Champion Author Los Angeles

Posts:3,215
Points:750,000
Joined:Oct 2012
Message Posted: Dec 28, 2012 3:12:12 AM

no
Profile Pic
roxanebay
All-Star Author Nova Scotia

Posts:857
Points:421,830
Joined:Jun 2008
Message Posted: Dec 26, 2012 11:53:27 PM

Thanks will check it out!
Profile Pic
jonjon57
Champion Author Raleigh

Posts:2,597
Points:727,515
Joined:May 2011
Message Posted: Dec 26, 2012 10:39:04 PM

No
Profile Pic
rjro
Champion Author Albany

Posts:1,579
Points:650,070
Joined:Jan 2011
Message Posted: Dec 21, 2012 8:15:28 AM

no.
Profile Pic
DanFMA
Champion Author Massachusetts

Posts:3,525
Points:1,613,090
Joined:Apr 2008
Message Posted: Dec 21, 2012 8:02:09 AM

No.
Profile Pic
jonjon57
Champion Author Raleigh

Posts:2,597
Points:727,515
Joined:May 2011
Message Posted: Dec 21, 2012 7:37:45 AM

No
Profile Pic
Houckster
Champion Author Atlanta

Posts:11,094
Points:767,675
Joined:Sep 2003
Message Posted: Dec 20, 2012 1:26:37 PM

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]
Profile Pic
steffy628
Champion Author Pennsylvania

Posts:3,815
Points:978,125
Joined:Apr 2011
Message Posted: Dec 20, 2012 10:42:50 AM

I use fuelly
Profile Pic
dontuknowOH
Champion Author Ohio

Posts:3,411
Points:59,085
Joined:Aug 2009
Message Posted: Dec 17, 2012 11:01:43 AM

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....
Profile Pic
CptSteve
Champion Author Illinois

Posts:14,711
Points:3,100,485
Joined:Jul 2005
Message Posted: Dec 17, 2012 10:22:49 AM

I have always found it easier to just keep a vehicle history book in the glovebox.
Profile Pic
13Octane
Champion Author Tucson

Posts:2,147
Points:332,165
Joined:Aug 2005
Message Posted: Dec 16, 2012 9:30:05 PM

save yourself time. fuel log book right here on gas buddy
Profile Pic
jrferrari
All-Star Author Orlando

Posts:652
Points:172,590
Joined:Jan 2011
Message Posted: Dec 16, 2012 8:51:52 AM

@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.
Profile Pic
davisadm
Champion Author Los Angeles

Posts:2,883
Points:938,575
Joined:Dec 2011
Message Posted: Dec 15, 2012 9:48:08 PM

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!?!?!?!?!?!?!?!?!?!?!
Profile Pic
jonjon57
Champion Author Raleigh

Posts:2,597
Points:727,515
Joined:May 2011
Message Posted: Dec 15, 2012 9:27:54 PM

No
Profile Pic
kxy4fw
Champion Author Denver

Posts:1,252
Points:283,330
Joined:Nov 2011
Message Posted: Dec 14, 2012 2:54:22 PM

no
Profile Pic
jrferrari
All-Star Author Orlando

Posts:652
Points:172,590
Joined:Jan 2011
Message Posted: Dec 14, 2012 10:15:34 AM

Download is still available if you need a spreadsheet template to record you mileage.
Profile Pic
Titanic1985
Champion Author South Carolina

Posts:9,632
Points:775,320
Joined:Dec 2010
Message Posted: Dec 2, 2012 4:42:05 PM

You're very welcome, jrferrari. Take care :-) MGY (RMS Titanic's radio call sign).
Profile Pic
jrferrari
All-Star Author Orlando

Posts:652
Points:172,590
Joined:Jan 2011
Message Posted: Dec 2, 2012 12:16:51 PM

Thanks Titanic1985!
Profile Pic
DanFMA
Champion Author Massachusetts

Posts:3,525
Points:1,613,090
Joined:Apr 2008
Message Posted: Dec 2, 2012 7:22:52 AM

No.
Profile Pic
Titanic1985
Champion Author South Carolina

Posts:9,632
Points:775,320
Joined:Dec 2010
Message Posted: Dec 1, 2012 8:04:18 AM

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
Profile Pic
Hemond
Champion Author Providence

Posts:11,781
Points:172,085
Joined:Oct 2006
Message Posted: Dec 1, 2012 6:11:02 AM

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.
Profile Pic
PaylessKY
Champion Author Kentucky

Posts:11,150
Points:2,121,950
Joined:Oct 2008
Message Posted: Nov 30, 2012 8:54:07 AM

I use the GasBuddy log book.
Profile Pic
GLM4205
Champion Author Toledo

Posts:6,179
Points:1,276,815
Joined:Dec 2010
Message Posted: Nov 30, 2012 7:54:03 AM

No what for???
Profile Pic
MOREDLEG
Champion Author Missouri

Posts:4,973
Points:1,120,195
Joined:May 2011
Message Posted: Nov 29, 2012 10:08:12 PM

Gas Buddy Fuel Logbook, Keeps me p1553D off enough to see my annual expenditure, that is really depressing.
Profile Pic
Z12
Champion Author Toledo

Posts:3,755
Points:982,845
Joined:Mar 2011
Message Posted: Nov 29, 2012 9:47:55 PM

Have not
Profile Pic
hrspwr77
Champion Author Georgia

Posts:1,478
Points:120,585
Joined:Oct 2012
Message Posted: Nov 29, 2012 5:42:02 PM

No. Keeping records won't help me save any more than I already save. It would only slow me down.
Profile Pic
WEPSMAN
Champion Author South Dakota

Posts:11,276
Points:2,501,025
Joined:Mar 2005
Message Posted: Nov 27, 2012 9:33:44 AM

nope
Profile Pic
wshokie12
Champion Author Winston-Salem

Posts:2,970
Points:700,815
Joined:Aug 2012
Message Posted: Nov 27, 2012 12:27:59 AM

no
Profile Pic
traffic cop
Champion Author Boston

Posts:2,891
Points:1,025,440
Joined:Oct 2004
Message Posted: Nov 22, 2012 2:20:22 PM

No.
Profile Pic
2amy
Champion Author Fresno

Posts:1,857
Points:707,415
Joined:Feb 2011
Message Posted: Nov 22, 2012 12:37:33 PM

no.
Profile Pic
KansasGunman
Champion Author Kansas

Posts:22,048
Points:2,116,980
Joined:Oct 2005
Message Posted: Nov 22, 2012 7:48:59 AM

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]
Profile Pic
jonjon57
Champion Author Raleigh

Posts:2,597
Points:727,515
Joined:May 2011
Message Posted: Nov 22, 2012 7:13:26 AM

No
Profile Pic
jrferrari
All-Star Author Orlando

Posts:652
Points:172,590
Joined:Jan 2011
Message Posted: Nov 21, 2012 5:57:56 PM

@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 :)
Profile Pic
2amy
Champion Author Fresno

Posts:1,857
Points:707,415
Joined:Feb 2011
Message Posted: Nov 21, 2012 5:23:58 PM

No.
Profile Pic
KansasGunman
Champion Author Kansas

Posts:22,048
Points:2,116,980
Joined:Oct 2005
Message Posted: Nov 21, 2012 1:31:33 PM

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!
Profile Pic
jrferrari
All-Star Author Orlando

Posts:652
Points:172,590
Joined:Jan 2011
Message Posted: Nov 21, 2012 11:10:22 AM

@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.
Profile Pic
OilerFan
Champion Author Tulsa

Posts:16,233
Points:2,869,165
Joined:Aug 2005
Message Posted: Nov 20, 2012 7:10:52 AM

I also have a spreadsheet. It calculates mpg, but also cost per mile.
Profile Pic
DoctorOH
Champion Author Cleveland

Posts:7,250
Points:1,613,885
Joined:Mar 2010
Message Posted: Nov 20, 2012 12:52:43 AM

No
Profile Pic
gvan
Champion Author Chicago

Posts:25,012
Points:3,376,065
Joined:Dec 2004
Message Posted: Nov 19, 2012 1:03:13 PM

I use the GasBuddy Fuel Logbook.
Profile Pic
PatAZ
Champion Author Tucson

Posts:10,066
Points:142,570
Joined:May 2008
Message Posted: Nov 19, 2012 11:29:16 AM

Sorry no interest in it.

[Edited by: PatAZ at 11/19/2012 11:30:25 AM EST]
Profile Pic
OceanArcher
Champion Author Mississippi

Posts:7,966
Points:1,839,150
Joined:May 2004
Message Posted: Nov 18, 2012 8:12:45 PM

Thank you for the offer, but I keep my records with a pencil and paper ...
Profile Pic
Maintroll
Champion Author Lexington

Posts:11,041
Points:2,244,710
Joined:Aug 2008
Message Posted: Nov 18, 2012 8:23:22 AM

I don't need it as I check mine on each fill up by using the trip meter on my car.
Profile Pic
carinthuist
Champion Author San Francisco

Posts:4,799
Points:806,175
Joined:Mar 2012
Message Posted: Nov 17, 2012 5:33:03 PM

nom I haven't downloaded gas spreed sheet
Post a reply Back to Topics