Tag Archives: Cubic Hermitic spline

Update to CHSplineA Function

I have recently corrected the CHSplineA function included in the CSpline2 spreadsheet.  The earlier version was returning incorrect values for the slope and curvature of the spline (with output option 2), if the spacing of the points defining the spline … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Cubic Hermitic and Cardinal Splines

In my previous post on splines I described a quick and dirty approach to adjusting a cubic spline to fit monotonic data, which did not meet with universal approval, so I have followed up Mike Woodhouse’s link: (http://en.wikipedia.org/wiki/Monotone_cubic_interpolation) which gives a … Continue reading

Posted in Charts, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 8 Comments