# Real-Time Curve Interpolation Excel 2007

1. ## Real-Time Curve Interpolation Excel 2007

Hi,

I am using Excel 2007 and I would like to interpolate values.

The Xs and Ys will be changing real-time in excel. So the interpolated values need to be updated in real-time as well.

Attached is an example of my data. The values in Column A and B will be changing real-time. Column E values are static and do not change, they will only change if I decide to enter in different values of X to interpolate. The interpolated values in column F will be dynamic and change since columns A and B are changing.

Thanks

example.xlsx

2. ## Re: Real-Time Curve Interpolation Excel 2007

Hi,
You will see attached the result of the interpolation
The interpolation from the actual data points is difficult due to the fact that the interpolated extreme points are outside of the range
First extract the trend curve from the F(x) Actual data chart, apply the formula to interpolate
Very bad result for value outside of the negative axis on the F(x) Trend chart
The result on F(x) XlXtrfun chart looks better
I am sure than a guru will find a better solution without add-ins
Hope this will helps
Best regards

3. ## Re: Real-Time Curve Interpolation Excel 2007

Try this.... let me know how it works for you/.

Here is the formula I used, it can be adjusted to meet your needs:
``Please Login or Register  to view this content.``
Good luck,

Mark

4. ## Re: Real-Time Curve Interpolation Excel 2007

Originally Posted by jpr73
Hi,
You will see attached the result of the interpolation
The interpolation from the actual data points is difficult due to the fact that the interpolated extreme points are outside of the range
First extract the trend curve from the F(x) Actual data chart, apply the formula to interpolate
Very bad result for value outside of the negative axis on the F(x) Trend chart
The result on F(x) XlXtrfun chart looks better
I am sure than a guru will find a better solution without add-ins
Hope this will helps
Best regards

5. ## Re: Real-Time Curve Interpolation Excel 2007

thanks, formula is a bit long but still works

6. ## Re: Real-Time Curve Interpolation Excel 2007

Originally Posted by mgaworecki
Try this.... let me know how it works for you/.

Here is the formula I used, it can be adjusted to meet your needs:
``Please Login or Register  to view this content.``
Good luck,

Mark
thanks, formula is a bit long but still works

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1