Tag Archives: UDF

Cantilevers with shear deflections

Posted on 24/08/2012 by dougaj4

At the end of last year I updated the Macaulay spreadsheet to include shear deflections for continuous beams, but this facility was not added to the Cantilever function.  That has now been fixed in the latest version, that can be … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

ULS Analysis of Concrete Beams; now with added units

Posted on 09/08/2012 by dougaj4

The spreadsheet for Ultimate Limit State Analysis of reinforced or prestressed concrete beams, previously presented here, has been combined with the Units4Excel spreadsheet to allow the program to work with any selected units, SI or non-SI.  Provision for the American … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , | 10 Comments

Units for Excel 4: Scripting dictionaries

Posted on 08/08/2012 by dougaj4

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 , , , , , , | 6 Comments

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