Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- The history of the theory of beam bending - Part 1
- Buckling of columns with varying cross section
- Downloads
- Reinforced concrete elastic analysis; Circular section
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Reinforced Concrete Section Analysis - 5; Ultimate Limit State
- Reinforced Concrete Section Analysis - 1
- Monte Carlo simulation with Excel and Python
Recent Comments
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 C# matrix functions, column buckling, Excel, Frame Analysis, link to dll, VBA
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 Excel, Gauss Points, Mohr's Circle, Plate stresses, Strand7, UDF, VBA
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 air density, Bill Bailey, column buckling, hole trough the middle of the Earth, Newton, Three blokes
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 Cardinal spline, catenary curve, Cubic spline, curve fitting, Excel, Hermite Spline, Interpolation, UDF, VBA
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