# 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  Register To Reply

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  Register To Reply

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  Register To Reply

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  Register To Reply

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

thanks, formula is a bit long but still works  Register To Reply

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  Register To Reply

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