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
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Automating chart scale limits - update
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Concrete
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 – 2
The previous post presented a simple but slow procedure for solving non-linear equations with two unknowns. In this post I will describe a much faster method, that also has the advantage that it can simply be extended to work with … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged Exce, moment curvature, Newton's Method, solving non-linear equations, two or more unknowns, UDF, VBA
5 Comments
Reinforced Concrete Moment Curvature – Development over time
I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working. The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged creep, development over time, Excel, moment curvature, RC Design Functions, Reinforced Concrete, shrinkage, TimeCurve function, UDF, VBA
Leave a comment
There is No Planet B
My latest (and final) President’s column from the Concrete in Australia Magazine: Some responsibilities of engineers are universally recognised. Everyone accepts that we have a duty to carry out design and construction so that structures will be serviceable, strong and … Continue reading
Posted in Concrete, Newton
Tagged Concrete, Concrete in Australia, No Planet B, sustainability
Leave a comment