### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Time in hours and minutes between two dates
- Drawing in Excel 7 - Creating drawings from coordinates
- Cubic Splines
- Biaxial bending update
- Taming Symbols in Excel

### Recent Comments

Sophea CE on Biaxial bending update Python optional argu… on Using Python optional argument… Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update dougaj4 on Units4Excel Update Bill Harvey on Units4Excel Update Units4Excel Update |… on Extracting text from an Intern… dougaj4 on Using LinEst() on data with… More on RC design of… on Reinforced Concrete Design for… AndyF83 on Using LinEst() on data with… dougaj4 on Extracting text from an Intern… Kirby on Extracting text from an Intern… Extracting text from… on Evaluating text with units and… dougaj4 on Deflections and Moments in Rec…

# Tag Archives: evaluate text strings

## Working with units in Excel – using VBA and Python

One of the most frequent reasons given for not using Excel for engineering and scientific applications is its very limited facilities for dealing with calculations involving units. It is possible to overcome this deficiency with VBA (see Daily Download 24: … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged evaluate text strings, Excel, Python, Sympy, UDFs, Unyt, VBA, xlwings
9 Comments

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