Author Archives: dougaj4

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

Bach for Christmas

Posted on 26/12/2011 by dougaj4

Al Vachris sent me a link to this visualisation of the opening Prelude from Bach’s 1st Suite for Solo Cello: “Baroque.me (2011) by Alexander Chen. Video capture. baroque.me visualizes the first Prelude from Bach’s Cello Suites. Using the math behind … Continue reading →

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

When does 35 not equal 35?

Posted on 20/12/2011 by dougaj4

… and when does 35 – 35 not equal zero? In the first case the answer is when one “35” is on an Excel spreadsheet and the other 35 is in VBA.  The question arose from the ongoing continuous beam … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 12 Comments