Category Archives: Beam Bending

Frame4; now with added Alglib

Edit 29 Nov 2012: I have now added an xls version to the download zip file.  This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Mohr’s Circle and Plate Stresses and Actions

The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

Daily Download 28: The Hole Through the Middle of the Earth, using ODE solvers, and Three Blokes

Today’s download is based on a series of posts on the “hole through the middle of the Earth”, which by devious means has been tied in with the solution of differential equations, buckling of columns, and a story by Bill … Continue reading

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a 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 , , , , , , , , | 7 Comments

Daily Download 21: Assorted Solvers

Today’s download starts with some simple linear interpolation methods used to solve polynomial equations, leading on to more sophisticated methods using quadratic or inverse quadratic interpolation. Also included is a solver for differential equations using the Cash-Karp Method, which is … Continue reading

Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | Leave a comment