Recent Comments
Category Archives: Maths
Solving cubic and quartic equations with Excel
Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs) for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading
The hole through the middle of the Earth – moved to the Equator
Previous posts in this series assumed that the hole went from pole to pole, and ignored such complications as tidal effects and wobbles of the axis of rotation. In this post we will examine the effect of moving the hole … Continue reading
Posted in Differential Equations, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, hole trough the middle of the Earth, ODE Function, ODE solver, UDF, VBA
2 Comments
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
AlgLib Spline function update
Following a question at the AlgLib Forum I have added the Hermite spline fit function to the AL-Spline-Matrix collection. The revised spreadsheet, with full open source code is available for download in 2007/20010 version and pre-2007 version. Typical output of the … Continue reading
More on buckling columns
Coincidentally, at about the same time as I wrote about column buckling for a column with a point load on the end, Autar Kaw at The Numerical Methods Guy was writing about buckling of columns under self weight, using the theory of … Continue reading
Posted in AlgLib, Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, column buckling, Excel, Runge-Kutta, Timoshenko, UDF, VBA
1 Comment
Newton Excel Bach, not (just) an Excel Blog 