Category Archives: UDFs

Units for Excel 3 – Editing the units table

Posted on 04/08/2012 by dougaj4

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 →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Units for Excel 2 – Unit aware evaluation of functions

Posted on 31/07/2012 by dougaj4

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 , , , , , | Leave a comment

Alglib Spline Functions 1.32

Posted on 23/07/2012 by dougaj4

Following a comment to AlgLib Spline Functions, the AL-Spline-Matrix spreadsheets have been updated, and may be downloaded from AL-Spline-Matrix03 for Excel 2003 and earlier and AL-Spline-Matrix07 for Excel 2007 and 2010.

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | Leave a comment

Units for Excel

Posted on 11/07/2012 by dougaj4

One of the reasons that programs like MathCad tend to be preferred to Excel for engineering and scientific applications is that they have much better facilities for dealing with different units of measurement.  This isn’t difficult, since the only built-in function provided … Continue reading →

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments

LatPilePY 1.04

Posted on 04/07/2012 by dougaj4

Following comments from Stephen on LatPile 1.03 I have modified the code so that if the specified Soil Properties range includes lines 8 and 9 (for specified effective depths at the top of each layer), but these lines are blank, the effective … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 15 Comments