### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Commenting a block of code in VBA
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Fitting high order polynomials

### Recent Comments

Two forks in the Cel… on Tam Lin dougaj4 on Tables and VBA Cameron Wallace on Tables and VBA Evaluating text with… on Reinforced Concrete Section An… Freek van Gilst on On not using Hungarian Notatio… dougaj4 on Reinforced Concrete Section An… dougaj4 on Section Properties with MeshPY… metroxx on Section Properties with MeshPY… dougaj4 on Section Properties with MeshPY… metroxx on Section Properties with MeshPY… metrox on Excel Uservoice and Python for… sado on Reinforced Concrete Section An… dougaj4 on Drawing in Excel 7 – Cre… Section Properties w… on Downloads Charalampos Dala on Drawing in Excel 7 – Cre…

# 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
Leave a comment

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