Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Writing Arrays to the worksheet - VBA function
- Downloads
- Converting from global to local coordinates (and vice versa)
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- When is an XY chart not an XY chart ...?
Recent Comments
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
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 Cardinal spline, Cubic Hermitic spline, Cubic spline, Excel, monotonic hermitic spline, UDF, VBA
8 Comments