derivatives of a cubic spline

[johnboy12]

Dear all,

I'm a newbee to VBA. I'm essentially after a function to calculate the interpolated cubic spline points and their associated derivatives at each point. Does anyone have a function that can do this?

Many thanks in advance for your help.

Regards,
John

[Mikeopolo]

Try this code:
Taken from http://user.services.openoffice.org/...hp?f=45&t=4574
Hoping you will know how to use it

Please Login or Register  to view this content.

[johnboy12]

Thanks for the code. Not sure how to get the derivative out of the natural cubic
spline though.... being a newbee.

Hoping someone can assist.

Regards,
John

[shg]

If you solve for the coefficients, you can calculate the derivatives.

What is this for?

[Leith Ross]

Hello johnboy12,

I don't know how far down you the rabbit hole you want to go with this, but here is an article that may help or at least point you in the right direction.

Cubic Splines

Sincerely,
Leith Ross