Tag Archives: Eval

Python callable arguments from Excel

Posted on 29/01/2021 by dougaj4

Many Scipy functions have “callable” arguments, i.e. functions that can be called, with the returned data used as input by the calling function. Types of callable arguments include: Functions in the active Python module Functions in any active loaded library … Continue reading →

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

Working with implied units – update

Posted on 30/09/2017 by dougaj4

Following comments at Eng-Tips I have added two examples with different procedures for evaluating ACI equations for the flexural tensile strength of concrete here.

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , , | Leave a comment

Working with implied units

Posted on 19/09/2017 by dougaj4

The Units4Excel spreadsheet provides a number of functions to convert between different units and evaluate functions entered as text on the spreadsheet, taking account of the units of both the inputs and the results.  The latest version can be downloaded from: … Continue reading →

Posted in Concrete, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , , | 2 Comments

Return of Excel – Evaluating commas

Posted on 14/06/2012 by dougaj4

The Newton/Galileo posts here will continue with their Italian theme for some time yet, but since I am now back in Australia it’s time to give Excel a look in again. I recently (well a couple of months ago) had … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 6 Comments

More on the Excel Evaluate function

Posted on 14/12/2010 by dougaj4

Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update).  It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 4 Comments