Average price per gallon - Fuelly Forums

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

Reply
 
Thread Tools Display Modes
 
Old 07-18-2011, 05:29 AM   #1
Junior Member
 
Join Date: Feb 2009
Posts: 14
Country: United States
Location: Athens, GA
Average price per gallon

Shouldn't the average price per gallon be given by (All-time amount spent) divided by (All-time gallons consumed)? This is how I calculate average PPG in my spreadsheet, but it is off by a penny from Fuelly. What's up?
__________________

NBtarheel33 is offline   Reply With Quote
Old 07-18-2011, 05:35 AM   #2
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
Which stat are you talking about? On vehicle profile pages or on your dashboard?

If vehicle profile pages, do you have your Cost Analysis Period set to "All Time"? If you're talking about the dashboard, keep in mind we use a Running Average there.
__________________

pb is offline   Reply With Quote
Old 07-18-2011, 10:26 AM   #3
Junior Member
 
Join Date: Feb 2009
Posts: 14
Country: United States
Location: Athens, GA
This would be on the vehicle profile pages themselves.
NBtarheel33 is offline   Reply With Quote
Old 07-18-2011, 10:26 AM   #4
Junior Member
 
Join Date: Feb 2009
Posts: 14
Country: United States
Location: Athens, GA
And yes, I do have the profile pages set to "All-time".
NBtarheel33 is offline   Reply With Quote
Old 07-18-2011, 02:01 PM   #5
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
And it's off by .01 compared with your calculations? Could it be a rounding issue? Are you rounding to two decimal places in your spreadsheet?
pb is offline   Reply With Quote
Old 07-19-2011, 06:36 AM   #6
Junior Member
 
Join Date: Feb 2009
Posts: 14
Country: United States
Location: Athens, GA
Look at Little Bertha's page (the Saturn SL2). All-time gallons consumed is 3208.23, and all-time total spent is $8,530.78. So shouldn't the all-time average price per gallon be given by $8,530.78/3208.23 = $2.6590 = $2.66 to the nearest penny? And if so, why is the all-time average price per gallon under "Cost Analysis" showing $2.67?
NBtarheel33 is offline   Reply With Quote
Old 07-19-2011, 07:13 AM   #7
pb
Senior Member
 
Join Date: Jul 2008
Posts: 1,588
Country: United States
Location: Corvallis, OR
oh ok, just took a look and we're doing a straight average of all the prices you have entered. We're not doing anything with the total distance driven.

So the average of all 339 prices you have entered so far is 2.672920, and because you enter the price/gallon that's your average price per gallon.
pb is offline   Reply With Quote
Old 07-19-2011, 02:04 PM   #8
Junior Member
 
Join Date: Feb 2009
Posts: 14
Country: United States
Location: Athens, GA
IOW, a straight average price per gallon rather than a weighted average price per gallon. Gotcha. Interesting that the two are so close together, though I suppose that might be different if I had more partial fuel-ups.
__________________

NBtarheel33 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


Powered by vBadvanced CMPS v3.2.3


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


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