Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
- The history of the theory of beam bending - Part 1
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
Tag Archives: iteration
Calling a function as a variable – another example
The recent posts on the Inverse Quadratic Method and Brent’s Method, and on calling a function as a variable, are leading towards a user defined function (UDF) to analyse circular reinforced concrete sections under combined bending and axial load, but since … Continue reading
Posted in Concrete, Excel, Maths, UDFs, VBA
Tagged Brents method, equation solver, Excel, iteration, UDF, VBA
3 Comments
Calling a function as a variable
The functions described in recent posts provide iterative solutions to polynomial equations, but the same method can be used for any equations that can be evaluated numerically and have a single variable. The question then is, how can we call a … Continue reading
Posted in Arrays, Excel, Maths, UDFs, VBA
Tagged application.run, calling a function, equation solver, Excel, iteration, UDF, VBA
6 Comments