### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Time in hours and minutes between two dates
- Taming Symbols in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Writing Arrays to the worksheet - VBA function
- Downloads

### Recent Comments

Sophea CE on Biaxial bending update Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and…

# 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