Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Beam Bending
Beam geometric non-linear effects
A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Euler buckling, Excel, Frame Analysis, Non-linear geometry, Second order effects, UDF, VBA
5 Comments
Cubic splines with jagged data
A cubic spline provides a good approximation to a smooth curve, and alternative versions are available for free download (see Daily Download 22: Splines and Curves, Update to AL-Spline-Matrix, and xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1), but if … Continue reading
Posted in Arrays, Beam Bending, Concrete, Curve fitting, Excel, Newton, UDFs, VBA
Tagged CSplineA, Cubic splines, Excel, fitting jagged data, MSplineA, UDF, VBA
2 Comments
Evaluating text with units and finding the neutral axis
A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section. This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged depth of neutral axis, elastic analysis, EvalU, evaluate text strings, evaluate units, Excel, Reinforced Concrete, UDF, ULS analyis, unit aware, VBA
7 Comments
Section Properties with MeshPY, including torsion and warping
I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants. The program uses the MeshPY Library for generating the finite element meshes required … Continue reading
Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings
Tagged Excel, MatPlotlib, MeshPY, Python, section properties, Torsion, UDF, VBA, Warping
11 Comments
Composite Beam Spreadsheet Update 1.01
Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top. The output has also been … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Composite beam design, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments