### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Animations from VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
- Fitting high order polynomials

### Recent Comments

dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Tanh-Sinh Quadrature v. 5… metroxx on Tanh-Sinh Quadrature v. 5… dougaj4 on Numerical Integration With Tan… Tanh-Sinh Quadrature… on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… Charles Chika on Frame Analysis with Excel… dougaj4 on Weighted Least Squares Regress… NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… John Maddock on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan…

# Tag Archives: evaluation of text strings

## Evaluating text and Integration with Python and ALGLIB

Following the previous post on evaluating mathematical functions entered as text on the spreadsheet, I have now written a spreadsheet with similar functionality using Python functions, and the Excel-Python add-in. Also included are integration functions using the SciPy Python library, … Continue reading

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, evaluation of text strings, Excel, Integration, Python, SciPy, VBA
1 Comment

## 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
5 Comments

## EvalA update and examples

The EvalA User Defined Function (UDF) has been included in the Eval2 and Eval-Integration spreadsheets for some time, but was not documented. That has now been fixed, and both spreadsheets can be downloaded from Eval2.Zip (including full open-source code). The … Continue reading

Posted in Arrays, Charts, Excel, Maths, Newton, UDFs, VBA
Tagged EvalA function, evaluation of text strings, Excel, UDF, VBA
Leave a comment

## Daily Download 15: Evaluation of formulas in text

VBA has an Evaluate function that returns the numerical value of any text string representing a mathematical formula, but this is not directly available from the spreadsheet. Today’s download is a User Defined Function (UDF) to provide this functionality, together with examples … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Evaluate, evaluation of text strings, Excel, numerical integration, UDF, VBA
1 Comment