Constrained Splined Interpolator in VBA
no vote
Cubic splines traditionally suffer from overshooting (particularly under constraints), which results in less than desirable accuracy. By sacrificing some smoothness in the spline, we can prevent overshooting. This can be achieved by eliminating the requirement for equal 2nd order derivatives at each point and replacing it with specific 1st order derivatives. Package includes research conducted by author as well as an Excel file containing an example and code.