Recent Comments
Category Archives: Maths
Two new functions for IP.xls
Edit 8 Feb 2012: The functions described below have been superseded by new versions which are described at https://newtonexcelbach.wordpress.com/2009/08/18/finding-circle-centres-in-3d/. That link also gives a description (with diagrams!) of how the functions work. The download file for the new versions is … Continue reading
More on cubic splines
Link to Cubic Spline Update The previous two posts used cubic splines with the “natural” end condition, that is with an end curvature of zero. To apply the cubic spline to analysis of continuous beams with different end conditions we … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged continuous beam analysis, Cubic spline, Excel, UDF, VBA
10 Comments
Continuous beam analysis with cubic splines
The last example in the previous post illustrated the use of cubic splines to find the bending moments in a continuous beam subject to prescribed lateral displacements. A similar technique can be used to find bending moments, shear forces, reactions, … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
9 Comments
A catenary function
Following on from the previous post, here is an Excel User Defined Function (UDF) to calculate the coordinates of any specified catenary, with the option of also finding the tension force at any point. Download from: Catenary.zip The download file … Continue reading
Posted in Arch structures, Excel, Maths, Newton, UDFs, VBA
3 Comments
Finding square roots …
… to 100 decimal places. Why would anyone want to do that? To solve Project Euler Problem 80: “It is well known that if the square root of a natural number is not an integer, then it is irrational. The … Continue reading
Newton Excel Bach, not (just) an Excel Blog 