Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Rotating Hypercubes
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- 3DFrame - 3D Frame analysis for Excel
- Downloads
- Spherical Geometry and Vincenty's Formulae
Recent Comments
Tag Archives: UDA
Eval.xls and the ALGLIB integration functions.
In a comment on a previous post on numerical integration I mentioned that I might implement the ALGLIB integration functions using the same technique, that is using the VBA Evaluate function to evaluate functions entered as text in the spreadsheet. Well … Continue reading
Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged ALGLIB. Gauss-Kronrod, Eval.xls, Excel, UDA, VBA
4 Comments
Approximate Solutions of Polynomial Equations
Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel. Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Excel, Newton-Raphson Method, Polynomial, Quartic, UDA, VBA
3 Comments