Recent Comments
44steps on For Bert Jansch – Around… Compiled AlgLib Matr… on Compiled AlgLib Matrix Functio… 
guddu on Automatic download of csv… 
dougaj4 on Return of Excel – Evalua… 
phix345 on Return of Excel – Evalua… New sort functions a… on A Sort Function 
smartcarrion on 64 bit Excel and PtrSafe dougaj4 on 3DFrame – 3D Frame analy… 
Mark Firkins on 3DFrame – 3D Frame analy… Lennox Bridge | Newt… on Trinity Bridge and Bridge of t… Trunc Function In Ex… on More Numpy with Excel and… dougaj4 on Using LinEst() on data with… 
Charlene on Using LinEst() on data with… dougaj4 on Jaqui Mcshee 
raduga fenerbahce on Jaqui Mcshee
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
Units for Excel 3 – Editing the units table
I have made several changes to the Units4Excel spreadsheet: Litres added as the base SI unit of fluid volume. Units added for specific heat Units added for fuel consumption in both km/litre and litres/100 km form As before, the revisions … Continue reading
Units for Excel 2 – Unit aware evaluation of functions
The Units4Excel spreadsheet described in the first post of this series provides functions to convert values from one set of units to another, but does not allow for automatic evaluation of functions, taking account of the specified units, as performed by programs … Continue reading
Posted in Excel, Newton, UDFs, VBA
Tagged Conversion, Excel, UDF, Units, Units aware, VBA
Leave a comment
