### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Downloads by category
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings

### Recent Comments

tim on Strand7 API GetNode funct… dougaj4 on Converting from global to loca… Nour on Converting from global to loca… rajith on Running exe files from Ex… dougaj4 on What is VBA good for? … Kazahk SON on What is VBA good for? … #Excel Super Links #… on Solving non-linear equations w… Using Matplotlib fro… on Use Matplotlib from Excel with… #Excel Super Links #… on More on trend line equations o… dougaj4 on Strand7 API GetNode funct… Pietro on Strand7 API GetNode funct… dougaj4 on Non-linear Frame Analysis Arend van Wijngaarde… on Non-linear Frame Analysis dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi…

# Tag Archives: two or more unknowns

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