Author Archives: dougaj4

Working with implied units

Posted on 19/09/2017 by dougaj4

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

Stepping through 3DFrame

Posted on 16/09/2017 by dougaj4

Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Setting up UDF Applications

Posted on 09/09/2017 by dougaj4

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , | 2 Comments

UDF to replace cell references with values

Posted on 30/08/2017 by dougaj4

I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | Leave a comment

Jansch and Renbourn live

Posted on 28/08/2017 by dougaj4

Three recently uploaded You Tube recordings of live performances by guitarists Bert Jansch and John Renbourn.  As further evidence that the quality of a You Tube video is inversely proportional to the number of views, none of the three have … Continue reading →

Posted in Bach | Tagged , , | 1 Comment