×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Anyone knows a swift way to do double interpolation?6

Anyone knows a swift way to do double interpolation?

(OP)
I usually have to find a value between two curves(if we think graphically)

so I have 3 columns: one for x-axis, one for y1 and one for y2

Havent reserched yet and forgive me if this one is not worth your attention.

Anyone wants to share his/her ideas

Respects

IJR

RE: Anyone knows a swift way to do double interpolation?

Are the two curves in 3-Space and are you looking for a third surface at some proportional distance from the two original surfaces, ie. on the normal line between the two curves?

Each curve will have it's own normal line to the other (I think), so you'll have to start by assuming one curve is 'master'.

Will have to sit down and 'scratch' some sketches (and head) to determine the equation for a normal to a surface...

RE: Anyone knows a swift way to do double interpolation?

(OP)
Thanks dik for the fast response and comments

But I am not into 3D surfaces. The two curves are plane curves as I described above

I mean y1=f1(x) and y2=f2(x) as is usual in most engineering applications, stuff like you have some pipe diameters along x-axis and one curve for larger storage tank discharge, the other for lesser capacity storage tank discharge both of which are functions of pipe diameter but differ in their discharges only as related to material friction coefficients, to cite a simple example and you are looking for discharge given a pipe diameter and a given size of storage tank in between the two curves.

Thanks
IJR

RE: Anyone knows a swift way to do double interpolation?

To me it looks like finding the root of a function:

Z(x) = 0,

where Z(x) = f1(x) - f2(x)

My approach in a spreadsheet would be:

Select an interval [x1 , x2] where you have a positive and a negative value of Z(x)

Z(x1) * Z(x2) < 0

Narrow your interval until Z(x) = 0 or sufficient small.

There are some other methods but I never used them in spreadsheets, just plain programming in pascal or fortran, but it must be possible. Check out a good book about numerical methods.

Regards

Steven van Els

RE: Anyone knows a swift way to do double interpolation?

(OP)
Thanks Svanels

I am sure that your method will work and I am sure I can do Lagrange interpolation, but I was looking out for something "swift" and was expecting some combination of built in functions in Excel

Respects
IJR

RE: Anyone knows a swift way to do double interpolation?

Your problem is perhaps not very well posed.
I'll try an interpretation hoping it is the correct one.
You have in fact not 2 functions of the same variable, but a single function of 2 variables, x (the diameter in your example) and y (the tank capacity).
Now say you have two values for x (x0 and x1) and two values for y (y0 and y1), and you know 4 values of your function (the discharge rate in your example):
f00=f(x0,y0)
f01=f(x0,y1)
f10=f(x1,y0)
f11=f(x1,y1)
Your problem should be how to interpolate a value of f for any given values of x between x0 and x1 and of y between y0 and y1.
The interpolation cannot be fully linear in this case (unlike for a single variable) and different interpolation formulae may be used.
The 'flattest' one is as follows:
f=f00+(x-x0)(f10-f00)/(x1-x0)+(y-y0)(f01-f00)/(y1-y0)+(x-x0)(y-y0)(f11+f00-f10-f01)/((x1-x0)(y1-y0))

prex
motori@xcalcs.com
http://www.xcalcs.com
Online tools for structural design

RE: Anyone knows a swift way to do double interpolation?

(OP)
Yes prex you got me right.

And thanks for the formula. That flatness is good enough for now.

Respects

RE: Anyone knows a swift way to do double interpolation?

On a few occasions I needed to do double interpolation and it could be done by using LOOKUP functions or by creating your own function in VBA. The attached file contains the function INTERPOLATE performing double interpolation and INTERPOLATE1 for single interpolation. Explanations and examples inside the file. Oops! I cannot attach the file, so I will place it at http://yakpol.net/downloads/ The file name is doubleinterpol.xls.

Hope it helps!

Yakov

RE: Anyone knows a swift way to do double interpolation?

(OP)
You done it Yakov 4928 49(100+28/49). Good interpolation man. I have downloaded the stuff. Do you put other stuff  there. If yes, let us know.

Respects
IJR

RE: Anyone knows a swift way to do double interpolation?

Thanks for compliments, IJR. The site where I place the spreadsheets http://yakpol.net I might place some utilities spreadsheets like 'interpolation' some time soon.

Yakov

RE: Anyone knows a swift way to do double interpolation?

(OP)
By the way 4928 I am  very serious in my every single compliments. If I were rich I would have invited all of you guys to my house for some high status party man.

Keep the touch.
IJR

RE: Anyone knows a swift way to do double interpolation?

I have a need to perform quite a bit of table lookup/interpolation, and struggled alot with the single interpolation functions in EXCEL.  I finally found a shareware EXCEL add-in at the following link.  It's cheap, and it works well for double interpolation:

Rob

RE: Anyone knows a swift way to do double interpolation?

(OP)
staudro

I have downloaded the file. There seems to be a small problem. The function wizard shows me correct interpolated value, but the target cell is always filled with a zero. In other words, I can not get the result displayed in a cell
Do you know why?

By the way,yakov's spreadsheet also works pretty well though not as flexible as yours

Thanks all of you guys

regards
IJR

RE: Anyone knows a swift way to do double interpolation?

there is a program called MathModeler at www.momentumware.com that lets you reduce all the curves on the graph to one equation, which then eliminates need to interpolate, just calculate directly.  Just enter several points from all the curves (the more points entered, the more accurate the equation).  For instance, you have x versus y with several curves, say each repesents the data at a different temperature. You would enter into a spreadsheet y (as the dependent variable), x as an independent variable, and the temperature as an independent variable.  Then it will give you an equation for y as a function of x and temp.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a partâ€™s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!