You are here: PriusChat Forums


Go Back   PriusChat Forums > Gen II (2004-2009) Toyota Prius Forums > The File Library
Connect with Facebook

This is a discussion on Spreadsheet for tracking differences between MFD and calculated fuel mileages within the The File Library forums, part of the Gen II (2004-2009) Toyota Prius Forums category; I have built a simple spreadsheet designed to track the difference between what the MFD displays for fuel mileage and ...


Spreadsheet for tracking differences between MFD and calculated fuel mileages

Reply
 
LinkBack Thread Tools
Old 01-26-2008, 08:48 AM   #1
JimboK
One owner, low mileage
 
JimboK's Avatar
 
Join Date: May 2006
Location: Chesterfield, VA
Posts: 2,548
My Car: 2005 Prius
Model:
Package: #2
Thanks: 4
Thanked 88 Times in 69 Posts
Friends: 6
Default Spreadsheet for tracking differences between MFD and calculated fuel mileages

I have built a simple spreadsheet designed to track the difference between what the MFD displays for fuel mileage and what actual calculated fuel mileage is, on a tank-by-tank and cumulative basis. It has several of my own entries so you can see it "in action." It might be especially helpful for the newbies who are confused by substantial one-tank differences between the display and calculated figures.

You will see a column labeled "weighted difference." This is to adjust for tank-to-differences in total miles driven before figuring the cumulative difference.

Columns F & G contain formulas, so with a new row you'll need to drag the formula down from the previous row to update the results in those columns and the cumulative difference.

Spreadsheet gurus, if you see any flaws in my formulas, please let me know.

Enjoy!
Attached Files
File Type: zip MFD-Calc Fuel Diff.zip (4.5 KB, 366 views)
__________________
Jim

Click the image to open in full size.
Click here for car details.
JimboK is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-26-2008, 10:39 AM   #2
john1701a
Senior Member
 
john1701a's Avatar
 
Join Date: Jan 2004
Location: Minnesota
Posts: 3,375
My Car: 2010 Prius
Model: IV
Package: Solar Roof
Thanks: 9
Thanked 145 Times in 70 Posts
Friends: 12
Default Re: Spreadsheet for tracking differences between MFD and calculated fuel mileages

I suggest adding a graph.

Here's a sample from my spreadsheet:

Click the image to open in full size.
.
john1701a is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-26-2008, 11:09 AM   #3
TonyPSchaefer
Your Friendly Moderator
 
TonyPSchaefer's Avatar
 
Join Date: May 2004
Location: Far-North Chicagoland
Posts: 10,498
My Car: 2004 Prius
Model:
Package: #9
Thanks: 39
Thanked 165 Times in 106 Posts
Friends: 23
Default Re: Spreadsheet for tracking differences between MFD and calculated fuel mileages

Quote:
Originally Posted by john1701a View Post
I suggest adding a graph.
Yes, I agree. In fact, here's a chart using the numbers form the spreadsheet you provided. Because I love plotting correlations, I charted the amount of gasoline used to refuel against the difference between the two readings. There's something strong going on here:
Attached Thumbnails
Spreadsheet for tracking differences between MFD and calculated fuel mileages-chart.jpg  
TonyPSchaefer is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools

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 On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 12:45 AM.


Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1