### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Fine as a Bee's wing
- Cubic Splines
- Installing Adobe Reader non-DC version.
- Frame Analysis with Excel - 4, 2D frame analysis
- Downloads by category

### Recent Comments

dougaj4 on The answer to Life the Univers… Paul Halsema on The answer to Life the Univers… More powers of 3 | N… on The answer to Life the Univers… Onyia Leonard on Daily Download 4: Continuous B… The age of snakeoil… on They all laughed at Christophe… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… dougaj4 on Buckling of columns with varyi… Manoj Deo on Buckling of columns with varyi… Indexing pdf files,… on Indexing pdf content dougaj4 on The answer to Life the Univers… Matija Bandić on The answer to Life the Univers… Afazio on Plotting Mandelbrot dougaj4 on Plotting Mandelbrot Afazio on Plotting Mandelbrot

# Tag Archives: Cubic spline

## Update to AL-Spline-Matrix

Has the free software at this site saved you time and/or money? If so, please contribute to the Raw Impact charity group providing practical help to poor communities in Cambodia: Everydayhero – Cambodia 2018 All contributions gratefully accepted. Contributions are … Continue reading

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Cubic spline, Excel, spline curve fitting, UDF, VBA, weights and constraints
1 Comment

## Daily Download 22: Splines and Curves

Since it was first published in 2009 my CSpline function has been the most popular download from this site. CSpline (and various associated functions) is used to fit a series of cubic curves through specified points, allowing interpolation along a smooth … Continue reading

Posted in AlgLib, Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Newton, Numerical integration, UDFs, VBA
Tagged Cardinal spline, catenary curve, Cubic spline, curve fitting, Excel, Hermite Spline, Interpolation, UDF, VBA
7 Comments

## Alglib Spline Functions 1.32

Following a comment to AlgLib Spline Functions, the AL-Spline-Matrix spreadsheets have been updated, and may be downloaded from AL-Spline-Matrix03 for Excel 2003 and earlier and AL-Spline-Matrix07 for Excel 2007 and 2010.

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged Akima Spline, AlgLib, Catmull-Rom Spline, Cubic spline, Excel, Hermite Spline, Least Squares fit, Spline, Spline Integration, UDF, VBA
Leave a comment

## Revision to CSpline2.xls

It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003. It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading

Posted in Drawing, Excel, Maths, UDFs, VBA
Tagged bug fix, ChartSpline function, Cubic spline
6 Comments

## SplineBeam update

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths. This … Continue reading

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
1 Comment

## AlgLib Spline Functions

Following earlier posts on cubic splines I have collected the Alglib interpolation routines, and the necessary supporting routines, and written interface functions to allow most of the 1Dspline routines to be called from the spreadsheet. Since there is a large measure … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Akima Spline, AlgLib, Catmull-Rom Spline, Cubic spline, Excel, Hermite Spline, Least Squares fit, Spline, Spline Integration, UDF, VBA
6 Comments

## 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