Recent Comments
Brad Clarke on Section properties for groups… 
dougaj4 on Section properties for groups… Brad Clarke on Section properties for groups… Brad Clarke on Section properties for groups… dougaj4 on Dots and Crosses 
Stephen Cooke on Dots and Crosses dougaj4 on Two songs = 2/3 Wikipedia 
Tom Barsh on Two songs = 2/3 Wikipedia 
Jon Peltier on Two songs = 2/3 Wikipedia Returning Arrays Fro… on More Numpy with Excel and… More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB…
Tag Archives: evaluate text strings
Evaluating text with units and finding the neutral axis
A few weeks ago a comment asked for guidance on finding the moment capacity of a reinforced concrete section. This post will look at finding the depth of the neutral axis (NA) in a rectangular section, with a single layer of … Continue reading
Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged depth of neutral axis, elastic analysis, EvalU, evaluate text strings, evaluate units, Excel, Reinforced Concrete, UDF, ULS analyis, unit aware, VBA
2 Comments
Evaluating text and calling Python functions from Excel with xlwings
The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions. I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading
Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, call Python functions, evaluate text strings, Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment
