### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Taming Symbols in Excel
- Fitting high order polynomials
- Cubic Splines
- Combining arrays
- Downloads by category

### Recent Comments

guddu on Automatic download of csv… dougaj4 on Return of Excel – Evalua… phix345 on Return of Excel – Evalua… New sort functions a… on A Sort Function smartcarrion on 64 bit Excel and PtrSafe dougaj4 on 3DFrame – 3D Frame analy… Mark Firkins on 3DFrame – 3D Frame analy… Lennox Bridge | Newt… on Trinity Bridge and Bridge of t… Trunc Function In Ex… on More Numpy with Excel and… dougaj4 on Using LinEst() on data with… Charlene on Using LinEst() on data with… dougaj4 on Jaqui Mcshee raduga fenerbahce on Jaqui Mcshee John on Installing Adobe Reader non-DC… dougaj4 on Jaqui Mcshee

# Tag Archives: moment curvature

## Non-linear frame analysis; moment curvature and self-weight

The Python/Fortran/Excel frame analysis program (previous version here) now has several new features added to the 2D-solver routines: The beam bending behaviour may now be specified with moment-curvature tables, rather than the linear-plastic behaviour required in the previous version. Beam … Continue reading

Posted in Arch structures, Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, NumPy and SciPy, Strand7, VBA
Tagged Excel, FEA, Fortran, Frame Analysis, link to dll, moment curvature, Non-linear concrete, Non-linear geometry, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
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
Leave a 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

## 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

## Solving non-linear equations with two or more unknowns – 1

Newton’s Method is a well known iterative solution for non-linear equations with one unknown. That is, if some value Y depends on a variable X, then we can use Newton’s Method to find X for any given value of Y. … Continue reading

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, moment curvature, Newton's Method, non-linear equations, two or more unknowns, UDF, VBA
2 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