### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

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

### Recent Comments

dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… dougaj4 on Solving Quadratic, Cubic, Quar… dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… Paridhi Agarwal on Solving Quadratic, Cubic, Quar… dougaj4 on Raw Impact in Cambodia –… dougaj4 on Composite Beam Spreadsheet… Composite Beam Sprea… on Stress increments in prestress… Composite Beam Sprea… on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Composite Beam Spreadsheet… Stephen on Composite Beam Spreadsheet… dougaj4 on Tables and VBA

# Tag Archives: Evaluate text

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

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