Tool for visualizing aero vs rolling resistance

[MetroMPG]

you're right krousdb. if you remove aero drag from the picture (by setting column M values to zero), you can see HP Tires continues to increase with speed. my bad.

when i compared the two different formulas for rolling drag, you get these figures:

MPH - HP TIRES (orig. formula) - HP TIRES (diff. formula)

05 - 0.261422561 - 0.398304667
10 - 0.522845122 - 0.796609333
15 - 0.784267683 - 1.194914
20 - 1.045690244 - 1.593218667
25 - 1.307112805 - 1.991523333
30 - 1.568535366 - 2.389828
35 - 1.829957927 - 2.788132667
40 - 2.091380489 - 3.186437333
45 - 2.352803050 - 3.584742
50 - 2.614225611 - 3.983046667
55 - 2.875648172 - 4.381351333
60 - 3.137070733 - 4.779656
65 - 3.398493294 - 5.177960667

the difference is consistent: 52% more drag in the 2nd formula at all speeds. maybe it reflects the difference between LRR tires and non-LRR tires.

if you want, you can enter a column with the new formula in Row 2: =A2/375*(0.01184*B2 + 0.000353*B2)

(it applies only up to 65 mph. for some reason, rolling resistance as calculated in the second formula is set to increase above 66 mph. i'll see if i can find out more about it.)