Recent Comments
Author Archives: dougaj4
Solving polynomials – update
The polynomial spreadsheet (details here) provides functions to solve polynomial equations of any order; using an “exact” method for up to quartic, and an iterative procedure for higher orders. The input for the functions requires the equation coefficients to be … Continue reading
Posted in Arrays, Excel, Maths, UDFs, VBA
Tagged Excel, high order simultaneous equations, Polynomial equations, solve simultaneous equations, UDF, VBA
15 Comments
Faster Biaxial Bending
The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment
Alglib/Python spline functions update
The Excel Spline-Matrix spreadsheet has now been updated with several new spline interpolation functions. See Alglib/Python linear and non-linear fitting functions for links to download and install the necessary Excel-Python and Alglib files. Also required is Python version 2.7 or 2.6. The … Continue reading
Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged 3D Spline function, AlgLib, Excel, Excel-Python, Parametric Splines, Python, Radial Basis Functions, Rational Interpolation, Spline functions, UDF, VBA
2 Comments
The Deserter
The Deserter is a traditional song featured on Fairport Convention’s 1968 album Liege and Lief; it is said to be the favourite track on the album of Sandy Denny, and the producer, Joe Boyd. The song has a long history, and … Continue reading
Posted in Bach
Tagged Bach, Fairport Convention, Ratcliff Highway, The Deserter, The Dublinetrs
Leave a comment
Alglib/Python spline functions
Continuing from the previous post, the new xl_Spline-Matrix.zip spreadsheet includes functions for 1D and 2D linear and cubic splines. The basic 1D spline allows for output of linear splines, or 5 different types of cubic spline, as listed above. Output may … Continue reading
Posted in AlgLib, Excel, Link to Python, Maths, Newton, Numerical integration, UDFs, VBA
Tagged 1D splines, 2D splines, AlgLib, Cubic splines, Excel, Excel-Python, Python, spline curve fitting, spline differentiation, Spline Integration, UDF, VBA
1 Comment
