### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Contour plots with Excel and Matplotlib
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category

### Recent Comments

Benata on Ana Vidović mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd…

# 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