Author Archives: dougaj4

Comparing floating point numbers

Posted on 07/01/2012 by dougaj4

Some of the issues raised in this post: https://newtonexcelbach.wordpress.com/2011/12/20/when-does-35-not-equal-35/ arose when writing the functions for the previous post on combining arrays.  In particular, when values from the two arrays are “equal” the function should create one entry in the combined … Continue reading →

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

Two dystopian futures, in short

Posted on 06/01/2012 by dougaj4

Two of my daughter’s short films are now available on the Web: Precious In a dystopian future, two men meet in an underground tunnel for an exchange of stolen goods. Liam lives in the stacks, making small black market deals … Continue reading →

Posted in Bach, Films | Tagged , , | 1 Comment

Combining arrays

Posted on 05/01/2012 by dougaj4

Part of the Macaulay spreasheet presented in recent posts required the formation of a list of points along a beam where the functions needed to be evaluated.  These are: The support points, the changes of cross section, and the output … Continue reading →

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

Continuous Beams with Shear Deflections

Posted on 31/12/2011 by dougaj4

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading →

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

The Ship Song Project

Posted on 27/12/2011 by dougaj4

The Ship Song Project: Artists pay tribute to the Sydney Opera House: “It is a song, and a story, of a nation that dreams. Indigenous singer-songwriter Kev Carmody, who performed with the Australian Ballet Company, said it’s also about, “The … Continue reading →

Posted in Bach | Tagged , , , | 1 Comment