### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- The angle between two vectors, Python version
- Combining arrays
- Fitting high order polynomials
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Time in hours and minutes between two dates
- Cubic Splines

### Recent Comments

dougaj4 on ULS Design Functions and … dougaj4 on ULS Design Functions and … dougaj4 on Using LinEst() on data with… Eduardo Torres on Using LinEst() on data with… DonB on ULS Design Functions and … DonB on ULS Design Functions and … James D on ULS Design Functions and … dougaj4 on ULS Design Functions and … James D on ULS Design Functions and … ULS Design Functions… on ULS Design Functions – u… dougaj4 on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Numerical integratio… on Numerical Integration; Tanh-Si… Dave on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si…

# Tag Archives: Units aware

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

## Evaluating text – update

One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check. For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Eval function, evaluation of text strings, Excel, UDF, Unit conversion, Units, Units aware, VBA
4 Comments

## Units for Excel 5:

Previous post on Units for Excel Download spreadsheet: Units4Excel.zip I have posted a new update of the Units4Excel spreadsheet for download (link above). The main changes are: The ConvertA and ConvertA2 functions have been combined. The ToSI and FromSI functions have been deleted, … Continue reading

Posted in Excel, Newton, UDFs, VBA
Tagged Excel, UDF, Unit conversion, Units, Units aware, VBA
3 Comments

## Units for Excel 4: Scripting dictionaries

As mentioned in the previous post I have now updated the Units4Excel spreadsheet with the use of scripting dictionaries to speed up the process of finding units in the lists, and also to simplify the process of adding or deleting units. … Continue reading

Posted in Excel, Newton, UDFs, VBA
Tagged Conversion, Excel, scripting dictionaries, UDF, Units, Units aware, VBA
6 Comments