MPG...Wow!

Thread Tools
 
Search this Thread
 
  #11  
Old 11-22-2006, 07:46 PM
VaBeachPrius's Avatar
Active Enthusiast
Join Date: Jul 2006
Location: Virginia Beach, VA
Posts: 74
Default Re: MPG...Wow!

Bob,

Will you do that spreadsheet jazz for a 2004-2006 generation prius and let me know what temp the car "likes"?

BTW, my car didn't like the 35 mph, gusting to over 50 mph winds in the last few days. I was only able to get 63 mpg at 45F instead of my normal 74ish mpg for the same commutes.
 
  #12  
Old 11-22-2006, 08:51 PM
bwilson4web's Avatar
Engineering first
Join Date: Oct 2005
Location: Huntsville, AL
Posts: 5,613
Wink Re: MPG...Wow!

Hi,
Originally Posted by VaBeachPrius
Will you do that spreadsheet jazz for a 2004-2006 generation prius and let me know what temp the car "likes"?

BTW, my car didn't like the 35 mph, gusting to over 50 mph winds in the last few days. I was only able to get 63 mpg at 45F instead of my normal 74ish mpg for the same commutes.
I'll walk you through it but I've got some other tasks taking my time:

1) Click into the list of all Prius II vehicles.
2) Select all text from the headers starting with "Car Name" to the end of the list
3) Copy to 'paste buffer'
4) Open a blank spreadsheet
5) Paste in the data
6) Sort by "Tanks" (you want vehicle with a lot of tanks)

Survey the top "n" vehicles to see that they went through several cold and hot spells. These are the vehicles that have the data samples you want.

7) Cut and paste the vehicle records into one spreadsheet (more samples are better)
8) Sort by temperature (you may choose to limit the miles per sample)
9) Using spreadsheet, calculate the MPG for all car records in each range
10) Use a scatter plot with the first column the temperature range and second column the MPG
11) the graph has your answer

This method works for any model of hybrid.

Bob Wilson
 

Last edited by bwilson4web; 11-22-2006 at 08:55 PM.
Related Topics
Thread
Topic Starter
Forum
Replies
Last Post
laurie
Fuel Economy & Emissions
21
12-27-2005 12:10 AM
Jason
Off Topic
2
04-04-2004 08:35 AM



Quick Reply: MPG...Wow!


Contact Us -

  • Manage Preferences
  • Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Your Privacy Choices -

    When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.

    © 2024 MH Sub I, LLC dba Internet Brands


    All times are GMT -7. The time now is 12:18 PM.