interpolation

[#1]

Hi all,

any one help on this, I was not able to solve this.

please find the attached document for reference.

Interpolation formula:

Y=Y1+(X-X1)*(YE-Y1)/(X2-X1).

find out the Y value from given points(X1,Y1) AND (X2,Y2) for particular Value X.

X is like 1000,500,200 like this.

I clearly mention the manual calculations and sample data in the attachment. and mentioned expected output.

THANKS.

[swuehl]

Maybe like attached?

[#3]

Yes Swuehl,

The attachment have data , formula and manual calculations.

Thanks

[swuehl]

No, I am talking about the QVW I've attached to my previous post.

Open the full thread in browser (not viewing from within the forum inbox) to see attachments.

[#5]

Not getting correct result by using given expression.

[#6]

Plz implent using given document. I put expected result in the document..

Thanks in advance.

I implent according to your post but i didn't achieve my goal.

[swuehl]

Can you give an example for a given x ?

edit: And also elaborate the context in which you need to get the interpolated values.

[swuehl]

Still missing a more detailed description of the context (script? chart? Based on input table? user input?) you want to use the interpolation.

Attached another version with a script based interval match.

[#9]

Hi swuehl,

Thanks for your reply.

I have one table in given attachment. I need to implement interpolate value for year like 1000, 500, 250, 100, 50.

Not posible to share the script.

My requirement is in a given doc i have a year and corresponding sales. For particular 1000 need interpolate sales value. This value falls between 100.3346 and 994.767670.