Author Archives: dougaj4

VBA code generation on the spreadsheet

Posted on 07/02/2012 by dougaj4

A previous post looked at using VBA to generate more VBA code.  This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

ShowReel …

Posted on 05/02/2012 by dougaj4

… from my daughter Kerinne Jenkins ShowReel from Kerinne Jenkins on Vimeo. Including shots from: Precious (Short film) Culling (AFTRS Short film) Sweetness Follows (Short film) Music Videos from Sweet Teeth, The Perishers and The Former Love.

Posted in Bach, Films | Tagged , , , , , | Leave a comment

Retrieving unique values from a range or array …

Posted on 31/01/2012 by dougaj4

… using the Scripting Dictionary object. in a previous post I looked at using the dictionary object to count connected elements in a finite element model.  This post looks at a more general (and simpler) usage to return unique values from … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 20 Comments

The Switch Function (VBA and UDF)

Posted on 27/01/2012 by dougaj4

Switch is a VBA function that operates in a similar way to the Select Case statement.  The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading →

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

LatPilePY 1.03

Posted on 27/01/2012 by dougaj4

The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves.  The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.

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