Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Using Goal Seek on Multiple Cells
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- Beam actions and deflections by Macaulay's Method
Recent Comments
Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…
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