Tag Archives: Cubic Hermitic spline

Update to CHSplineA Function

Posted on July 7, 2010 by dougaj4

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

Posted on May 14, 2010 by dougaj4

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