Tool for visualizing aero vs rolling resistance - Page 4 - Fuelly Forums

Click here to see important news regarding the aCar App

Go Back   Fuelly Forums > Fuel Talk > General Fuel Topics
Today's Posts Search Click Here to Login
 
 
Thread Tools Display Modes
 
Prev Previous Post   Next Post Next
Old 03-18-2006, 06:33 AM   #1
Registered Member
 
krousdb's Avatar
 
Join Date: Feb 2006
Posts: 1,480
Tool for visualizing aero vs rolling resistance

I have developed a spreadsheet that shows the contribution of aero drag and tire rolling resistance versus speed. I used the formula in the last post to this thread:

http://www.gassavers.org/forum_topic...reduction.html

Just enter your values (numbers in blue) and it will calculate aero and RR and also will calculate a theoretical MPG. Of course there may be an error in the calcs, but the MPG numbers seem to make sense. One caveat is the ICE efficiency. I set it up to show the same efficiency at all speeds which is not an accurate representation of reality. you can enter a separate efficiency for each speed to be more accurate, although it is really just a guess.

Anyway the point is not to calculate MPG, but rather to see how your CD and tire RR contribute to total drag at a given speed. You can simulate weight reduction, change in frontal area, CD and tire RR. Maybe it can help figure out the best place to spend your time/money.

Now if only I could figure out how to host a spreadsheet. Here is a jpg anyway...
http://img99.imageshack.us/img99/398...adsheet3ls.jpg
http://img206.imageshack.us/img206/4598/aerovsrr6yp.jpg
__________________


krousdb is offline   Reply With Quote
 


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
Graphs itsastationwagon Fuelly Web Support and Community News 2 08-13-2008 02:04 PM
Both odometer and trip mileage? tiffehr Fuelly Web Support and Community News 1 08-08-2008 04:55 AM
195* Tstat SVOboy Experiments, Modifications and DIY 12 04-17-2007 07:27 AM
What's the point of living anymore??? (personal stuff- If you don't like reading personal stuff then don't open the thread) Compaq888 General Discussion (Off-Topic) 38 04-03-2006 10:30 PM

» Fuelly iOS Apps
No Threads to Display.
» Fuelly Android Apps
No Threads to Display.
Powered by vBadvanced CMPS v3.2.3


All times are GMT -8. The time now is 07:28 AM.


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