Tool for visualizing aero vs rolling resistance

[krousdb]

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