### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

### Recent Comments

dougaj4 on Solving non-linear equations w… dougaj4 on Solving non-linear equations w… Georg on Solving non-linear equations w… Achille on Solving non-linear equations w… dougaj4 on 3DFrame Ver 1.03 and Frame4 Ve… Chandrakant on 3DFrame Ver 1.03 and Frame4 Ve… dougaj4 on 3DFrame Ver 1.03 and Frame4 Ve… Chandrakant on 3DFrame Ver 1.03 and Frame4 Ve… Solving non-linear e… on Using RC Design Functions… Solving non-linear e… on Faster Biaxial Bending Solving non-linear e… on The Inverse Quadratic Method 3… dougaj4 on Section Properties – Lun… metroxx on Section Properties – Lun… dougaj4 on Editing Charts with the m… dougaj4 on Linestgap with data in ro…

# Category Archives: UDFs

## 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
4 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
Leave a comment

## IP2 and IP2_py

The IP2 spreadsheet provides functions to calculate: Intersection points of 2D lines or polylines Intersection points of 2 circles, or a line and a circle Intersection circle of two spheres and intersection points of 3 spheres 3D centre point of … Continue reading

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

## ConBeamU 4.05 and ConBeampy 1.02

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, Python. Excel-Python, UDF, VBA
Leave a comment