<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=US-ASCII" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.18838"></HEAD>
<BODY id=role_body style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; COLOR: #000000"
bottomMargin=7 leftMargin=7 rightMargin=7 topMargin=7><FONT id=role_document
color=#000000 size=2 face=Arial>
<DIV>Hi Ron & List,</DIV>
<DIV> </DIV>
<DIV>I worked backwards using exact power values to get the speed values.
I suppose it doesn't matter that the speeds are round up or down rather than the
power. The chart still doesn't look exactly the way I wanted to but will
do for now. For example I can't get the legend reversed so it matches the
data.</DIV>
<DIV> </DIV>
<DIV>The spread sheeting/data challenge is to get this data overlaid to rpm for
various gears. The objective is to show that more power doesn't always
generate more speed. This is because if the car is over-geared
the additional power required to raise the speed is demanded at a
higher rate than the power increase of the engine for the same rpm. Put
another way the car is said to be drag limited rather than power or rev
limited.</DIV>
<DIV> </DIV>
<DIV>Looking at the data the difference in speed, for cars with identical power,
is 9 mph (actually 8 but never mind!). However, the car with the best
CD achieve max speed at 6,218 rpm. While the car with the worst CD achieves
max speed (which is lower by 8/9 mph) at 5,810 rpm. Except the car with
the worst CD doesn't actually reach 114 mph because the engine is not making 100
bhp at 5810 (it's making at say 6000 - 6300rpm)</DIV>
<DIV> </DIV>
<DIV>Here are the charts if it doesn't make sense now it will when I've had more
time to work on the charts. The examples are for a car with a 5 speed on a
3.9 diff etc and for the higher drag car using 4th instead of 5th won't help it
because that would need 6785 rpm at which engine still doesn't make 100 bhp -
being the other side of peak power.</DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Danel</DIV>
<DIV> </DIV>
<DIV>
<DIV>In a message dated 19/11/2017 16:18:12 GMT Standard Time, soavero@yahoo.com
writes:</DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: blue 2px solid"><FONT
style="BACKGROUND-COLOR: transparent" color=#000000 size=2 face=Arial>
<DIV>Daniel,</DIV>
<DIV>I honestly cannot remember, but the equation with the 146,000 in the
denominator is the equation I am "familiar" with, meaning I remember it ;).
It's too clean to be a conversion factor. I vaguely remember it being in
Stokes' equation. I will look when I'm not tapping into a phone. </DIV>
<DIV><BR></DIV>
<DIV>By the way, the full radius stacks I mentioned were the ones you gave me
years ago when I'd sent those aviation books for your brother. They were for a
45 DCOE. The stock ones were better at midrange but yours sung at high RPM.
I'm pulling 8500 RPM in this video. </DIV>
<DIV><BR></DIV>
<DIV><A title=https://youtu.be/Iwsf5jr1kpE
href="https://youtu.be/Iwsf5jr1kpE">https://youtu.be/Iwsf5jr1kpE</A></DIV>
<DIV><BR>
<DIV>Ron Soave</DIV></DIV>
<DIV><BR>On Nov 19, 2017, at 7:42 AM, <A title=mailto:WeslakeMonza1330@aol.com
href="mailto:WeslakeMonza1330@aol.com">WeslakeMonza1330@aol.com</A>
wrote:<BR><BR></DIV>
<BLOCKQUOTE type="cite">
<DIV>
<META name=GENERATOR content="MSHTML 11.00.9600.18838"><FONT color=#000000
size=2 face=Arial>
<DIV><FONT style="BACKGROUND-COLOR: transparent" color=#000000 size=2
face=Arial>Hi Ron and list,</FONT></DIV>
<DIV> </DIV>
<DIV>I want to create a graph in Excel that shows how much power required
for a given CDa to reach a specific speed.</DIV>
<DIV> </DIV>
<DIV>To this I need a formulae that I can use in Excel. I have a
library of technical motoring books that puts to shame virtually any public
lending library in the UK and maybe some colleges. However, I can't
find the exact details of what I need.</DIV>
<DIV> </DIV>
<DIV>The Forbes Aird Aerodynamics book includes a formulae along with a
value that I don't see referenced in the text.</DIV>
<DIV> </DIV>
<DIV>The Colin Campbell Sports car book is about the same but with a
different value I don't see referenced in the text, which is:</DIV>
<DIV> </DIV>
<DIV>Drag Horsepower (I'm ignoring non-drag horsepower for now) =
Coefficient of drag x frontal area x mph cubed DIVIDED by
146,000. So what is the value of 146,000?</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Daniel</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: transparent" color=#000000 size=2
face=Arial></FONT> </DIV>
<DIV><FONT style="BACKGROUND-COLOR: transparent" color=#000000 size=2
face=Arial></FONT> </DIV><FONT style="BACKGROUND-COLOR: transparent"
color=#000000 size=2 face=Arial>
<DIV><BR></DIV></FONT></FONT></DIV></BLOCKQUOTE>=</FONT></BLOCKQUOTE></DIV></FONT></BODY></HTML>