Re: Medhurst Table
In a message dated 1/9/99 2:56:59 AM Mountain Standard Time, tesla-at-pupman-dot-com
> Original Poster: "Barton B. Anderson" <mopar-at-uswest-dot-net>
> Has anyone hacked at the Medhurst table to derive k via
> h/d? I'm simply looking for a quick way to calc k in a
> spreadsheet rather than using vlookups, etc... hoping
> someone has already done the hacking.
I wanted to know the same thing, so I used Ed Sonderman's awesome excel
spreadsheet(the VLOOKUP table) and did this. I found the K to vary linearly
if H/D was greater than or equal to 2. Since most coilers don't design coils
with a ratio lower than that, this equation works and is very convenient.
K = 0.100976*(H/D) + 0.309630
If you want K for the entire series including (H/D) less that two, it becomes
a forth order equation.
K = 0.0005x^4 - 0.0097x^3 + 0.0648x^2 - 0.0757x + 0.4723
I did both of these by plotting the table onto a chart and inserting a
trendline. Both equation had good correlation coefficients (0.999 or so). I
doubt it is worth the trouble to use the second one, but showed it anyway.
Hope this helps.