Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Beam Bending
RC Design Functions update
Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading
Posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged EStress function, Excel, Goal Seek, Reinforced Concrete, UDF, UMom function, VBA
1 Comment
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