### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- ULS Design Functions and EurocodeApplied
- Using Goal Seek on Multiple Cells
- Downloads by category
- Using LINEST for non-linear curve fitting
- Frame Analysis with Excel 1 - Single beam
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Combining arrays
- Beam Fixed End Actions by Macaulay's Method

### Recent Comments

# Tag Archives: Eval function

## Converting a formula to values

Excel has a built-in function (FormulaText) to display a formula as cell references, rather than the result value. It would be useful to be able to display the value of each cell reference as well, but there is no built-in … Continue reading

## Evaluating text – update

One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check. For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Eval function, evaluation of text strings, Excel, UDF, Unit conversion, Units, Units aware, VBA
4 Comments

## Daily Download 17: Numerical Integration

Some simple numerical integration functions (using the trapezoidal rule and Simpson’s Rule) were included in the Eval2 spreadsheet, presented on Daily Download Day 15, but for purposes were better accuracy and/or higher speed are required more sophisticated methods will do a … Continue reading

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, Eval function, Excel, Gauss-Kronrod, numerical integration, Tanh-Sinh method, UDF, VBA
Leave a comment