### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- The angle between two vectors, Python version
- Using Goal Seek on Multiple Cells
- Downloads by category
- Cubic Splines
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Passing variable argument lists from Excel to Python via xlwings
- Drawing in Excel 7 - Creating drawings from coordinates
- Automating chart scale limits

### Recent Comments

Brian Dolan on LatPilePY 1.04 dougaj4 on LatPilePY 1.04 Brian Dolan on LatPilePY 1.04 Asymmetric Catenary… on Using Excel Solver from V… Asymmetric Catenary… on A catenary function OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho…

# 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