Actual Odometer Reading Vs. Excel Total - Fuelly Forums

Android Users - Coming Soon! - Migrating from aCar 4.8 to 5.0

Reply
 
Thread Tools Display Modes
 
Old 08-06-2013, 08:03 AM   #1
Junior Member
 
Join Date: Jan 2012
Posts: 13
Country: Canada
Actual Odometer Reading Vs. Excel Total

Does anyone know why I would see a difference between the actual odometer reading in my car and the running total in the Excel spreadsheet I use to track my fuel consumption?

The more entries I add the larger the difference is getting, right now my spreadsheet shows 7km less than the reading displayed on my car's odometer. Which is more accurate?
__________________

Doogals is offline   Reply With Quote
Old 08-06-2013, 08:06 AM   #2
Site Team / Moderator
 
Jay2TheRescue's Avatar
 
Join Date: Sep 2008
Location: Northern Virginia
Posts: 4,657
Country: United States
Location: Northern Virginia
Its the fractions that aren't displayed that's throwing you off.
__________________

__________________






Jay2TheRescue is offline   Reply With Quote
Old 08-06-2013, 08:15 AM   #3
Junior Member
 
Join Date: Jan 2012
Posts: 13
Country: Canada
Quote:
Originally Posted by Jay2TheRescue View Post
Its the fractions that aren't displayed that's throwing you off.
Not sure I understand, could you expand on this pls?
Doogals is offline   Reply With Quote
Old 08-06-2013, 08:33 AM   #4
Site Team / Moderator
 
Jay2TheRescue's Avatar
 
Join Date: Sep 2008
Location: Northern Virginia
Posts: 4,657
Country: United States
Location: Northern Virginia
Well, say for instance you pulled up to the pump to fill up with gas, and your odometer read 300.0 miles. However, in reality you traveled 300.08999 miles. In reality, you have traveled 469.92 feet farther than you're recording. Over the course of a couple of tanks, this is not noticeable. However, over many fill ups these odd amounts add up.
__________________






Jay2TheRescue is offline   Reply With Quote
Old 08-06-2013, 08:46 AM   #5
Junior Member
 
Join Date: Jan 2012
Posts: 13
Country: Canada
So using the trip meter instead of the odometer will get me another decimal place of accuracy, BUT the total km on my spreadsheet will never match the odometer reading in my car.

So my odometer reading is more accurate to real life because will include these small fractions of km.
Doogals is offline   Reply With Quote
Old 08-06-2013, 08:50 AM   #6
Site Team / Moderator
 
Jay2TheRescue's Avatar
 
Join Date: Sep 2008
Location: Northern Virginia
Posts: 4,657
Country: United States
Location: Northern Virginia
Quote:
Originally Posted by Doogals View Post
So using the trip meter instead of the odometer will get me another decimal place of accuracy, BUT the total km on my spreadsheet will never match the odometer reading in my car.

So my odometer reading is more accurate to real life because will include these small fractions of km.
Yes. total odometer reading is more accurate, but in reality even though your distance traveled is slightly off, its only by a small fraction of a percent.
__________________






Jay2TheRescue is offline   Reply With Quote
Old 08-06-2013, 11:08 AM   #7
Junior Member
 
Join Date: Jan 2012
Posts: 13
Country: Canada
Is there any formula I can use to account for this in my spreadsheet? So that it matches my actual odometer, I'm wondering? Looks like I'm about 2% off after 93 fill-ups.
Doogals is offline   Reply With Quote
Old 08-06-2013, 02:40 PM   #8
Site Team / Moderator
 
Jay2TheRescue's Avatar
 
Join Date: Sep 2008
Location: Northern Virginia
Posts: 4,657
Country: United States
Location: Northern Virginia
The only way to account for it is to use actual odometer readings instead of using the trip odometer. This way if you skip recording 500 feet on one fillup, they're picked up on the next tank. This variance can vary each time you fillup, so there's no set formula to account for it.
__________________






Jay2TheRescue is offline   Reply With Quote
Old 08-07-2013, 07:44 AM   #9
Registered Member
 
theholycow's Avatar
 
Join Date: Apr 2008
Posts: 6,624
Country: United States
Send a message via ICQ to theholycow Send a message via AIM to theholycow Send a message via MSN to theholycow Send a message via Yahoo to theholycow
There is a funny movie based on the same premise...except with fractions of a cent instead of fractions of a mile.
https://en.wikipedia.org/wiki/Office_Space
__________________
This sig may return, some day.
theholycow is offline   Reply With Quote
Old 08-07-2013, 08:44 AM   #10
Registered Member
 
GasSavers_BEEF's Avatar
 
Join Date: Apr 2008
Posts: 1,831
... did you steal my stapler?
__________________

__________________
Be the change you wish to see in the world
--Mahatma Gandhi



GasSavers_BEEF is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unburned Fuel rh77 General Maintenance and Repair 11 11-30-2005 09:01 PM

Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 08:43 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.