### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- The angle between two vectors, Python version
- Downloads by category
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
- Using LINEST for non-linear curve fitting
- Fitting high order polynomials

### Recent Comments

dougaj4 on 3DFrame Ver 1.03 and Frame4 Ve… Tonny on 3DFrame Ver 1.03 and Frame4 Ve… Tonny on 3DFrame Ver 1.03 and Frame4 Ve… 64 bit Excel and the… on Strand7 API GetNode funct… wang on Daily Download 5: Frame A… dougaj4 on Daily Download 5: Frame A… wang on Daily Download 5: Frame A… Concrete 2019 — Newt… on Concrete 2019 Concrete 2019 — Newt… on Concrete 2019 excel1star on Dots and Crosses dougaj4 on Dots and Crosses dougaj4 on Using Alglib least-squares… excel1star on Dots and Crosses Qu Yong on Using Alglib least-squares… dougaj4 on Solving the Lagrangian Point e…

# Tag Archives: Evaluate text

## Units and solvers with Pint and Sympy

Following the previous post I have adapted the units code to use the Pint package, and added a function using the Sympy equation solver, with Pint units. I have applied the functions to finding the depth of neutral axis of a … Continue reading

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, UDFs, VBA, xlwings
Tagged Evaluate text, evaluate units, Excel, Pint, Python, Solve text, Sympy, UDF, unit aware, Units, VBA, xlwings
Leave a comment

## Working with implied units – update

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 ACI 318, Customary US Units, Eval, EvalU, Evaluate text, Excel, Implied units, shear capacity, SI Units, UDF, Units aware, Units4Excel, VBA
Leave a comment

## Working with implied units

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 ACI 318, Customary US Units, Eval, EvalU, Evaluate text, Excel, Implied units, shear capacity, SI Units, UDF, Units aware, Units4Excel, VBA
2 Comments

## UDF to replace cell references with values

I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading

Posted in Excel, UDFs, VBA
Tagged display formula reference values, Evaluate text, Excel, UDF, VBA
Leave a comment