Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The history of the theory of beam bending - Part 1
- P-Y Curve function
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
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