### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Fitting high order polynomials
- Using LINEST for non-linear curve fitting
- Numerical Integration With Tanh-Sinh Quadrature v 5.0
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Time in hours and minutes between two dates

### Recent Comments

Numerical Integratio… on Numerical integration with on-… josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw…

# Tag Archives: tension stiffening

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

## Using RC Design Functions – 3

In the previous post in this series I looked at the results available from the EStress function in the RC Design Functions spreadsheet. Three associated functions are: EstressCap PLCurve TStiff EStressCap finds the maximum bending moment for a specified axial load, … Continue reading

## Daily Download 2: SLS design of reinforced concrete sections …

… and prestressed concrete sections. Today’s download installment covers spreadsheets for design of reinforced and prestressed concrete beams and columns at the Serviceability Limit State (SLS). The spreadsheets cover design of rectangular and circular sections, sections made up of any … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged Composite section analysis, crack width, creep, Excel, flexural stiffness, Prestressed concrete, Reinforced Concrete, shrinkage, tension stiffening, UDF, VBA
15 Comments