Author Archives: dougaj4

Three blokes go into a pub …

Posted on 13/08/2010 by dougaj4

“…  Well, I say three; could have been four or five.  Could have been nine or ten, doesn’t matter. Could have been fifteen, twenty – fifty. Round it up. Hundred. Let’s go mad, eh – two-fifty. Tell you what, double … Continue reading →

Posted in Bach | Tagged , , , | 1 Comment

AlgLib Complex Number Functions

Posted on 11/08/2010 by dougaj4

The AlgLib module ap.bas includes complex number functions which can be called from other VBA routines, but they cannot be used as User Defined Functions (UDFs)  because they use the user defined data type “Complex”: To  call these functions from the … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 2 Comments

Buckling of columns with varying cross section

Posted on 09/08/2010 by dougaj4

Following a post in the Eng-Tips Forum about finding the buckling load of a stepped strut I have modified the Frame4 spreadsheet to carry out a buckling analysis of any straight member subject to axial load, including stepped or tapered cross … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, VBA | Tagged , , , , , , , | 27 Comments

A musical interlude …

Posted on 07/08/2010 by dougaj4

… provided by my daughter’s latest music video with the excellent English band The Perishers:

Posted in Bach | Tagged , , | Leave a comment

Solving cubic and quartic equations with Excel

Posted on 04/08/2010 by dougaj4

Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs)  for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments