Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Category Archives: Beam Bending
If it keeps on straining …
… concrete’s goin’ to break: To find out what this has to do with predicting concrete deflections, book into the Concrete Institute seminar on “Finite Element Analysis of Concrete Structures”: Finite Element Analysis of Concrete Structures – Software and Practice … Continue reading
Posted in Bach, Beam Bending, Concrete, Newton
Tagged Concrete beam test, concrete cracking, Led Zeppelin, Levee Breaks
Leave a comment
ConBeamU 4.08
The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point. The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, moving load, Strand7, UDF, VBA
1 Comment
Solving non-linear equations with two or more unknowns – 5
This will be the last of the series on solving non-linear equations (for now). Up until now all the examples have had two unknown values, and two target values. This can be extended by making three changes to the code: … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, moment curvature, Newton's Method, Python, SciPy, SciPy optimize function, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
3 Comments
Solving non-linear equations with two or more unknowns – 4
As promised in the previous post, the spreadsheet including the new functions to calculate reinforced (or prestressed) concrete moment-curvature with a revised concrete tension stress-block is now available for download from: RC design functions7.zip The spreadsheet includes full open source … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, moment curvature, Newton's Method, solving non-linear equations, tension stiffening, two or more objectives, two or more unknowns, UDF, VBA
1 Comment
Solving non-linear equations with two or more unknowns – 3
For the next stage of the non-linear solver saga I am looking at the same problem as in the previous post (finding the curvature or a reinforced concrete section under specified bending moment and axial load), but with more realistic … Continue reading
Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, moment curvature, Newton's Method, solving non-linear equations, tension stiffening, two or more unknowns, UDF, VBA
1 Comment