Skip to main content
3-Newcomer
February 21, 2010
Question

Interpolation out of table

  • February 21, 2010
  • 6 replies
  • 3512 views
Hello
I'm trying to figure out how to interpolate my table cfT from attached mcd-file.
I have there variables b,d and h, which gives me ratio d/b and programmed value depending of h/b- value => lambda.

In given array there is #1 colum for lambda and the #1 row is for d/b-ratio and from this table the value for Cf should be found.

I'm gatefull if someone gives me guidance.

BR Matti

6 replies

1-Visitor
February 21, 2010

__________________
� � � � Tom Gutman
mpitkanen3-NewcomerAuthor
3-Newcomer
February 25, 2010
Hello and I thank you all who have put your efforts to solve my question.
I must however apologize, not being clear enough first.
The given table is constructed so, that the first uppermost row is value for ratio d/b, and the leftmost column is for value lambda.
These values are not part of data. They are and must be used as parameters to function.

The result must be found from table 1,1 .. 9,4.(Origin 0)
For example when d/b = 7 and lambda is 3, result is 1.38, and if d/b = 1 and lambda = 2, result is interpolated to be 1.33.
So when d/b = 1.5 and lambda=7, I get something like 1.28 by hand calculation.
I interpolated total 8 values, two in 1.5 on rows 3 and 10 and two in 7 on columns 1 and 2.
Then interpolated horizontal, vertical and diagonals values in the middle and finally took mean out of these four.

This programming is what I am going to do. I can easily do it using "basic" and "VB"; "lisp" and "fortran", but this Mathcad is a bit strange still, however I have been reading this forum for quite a long time since joining.
Not even remember any more, when I first wrote here complaining about vlookup-function ;>)

Cheers Matti
1-Visitor
March 3, 2010
After considerable effort I have found the reliable regress and cspline methods fail at points between the support points on data like this, and I resorted to a knot cspline prepared on either side of a turning point. I obtained results in agreement with Matti's example.

While the worksheet is user-friendly it would take a lot of preparation if other data was presented. Knot csplines are not common in MsthCad.

This has been a very interesting and challenging post.

Cheers, Theodore
24-Ruby IV
February 21, 2010