Author Archives: dougaj4

Bert Jansch – Acoustic Routes

Posted on 19/05/2009 by dougaj4

Just appeared on YouTube; the first part of a documentary about the music, life and times of Bert Jansch, made in 1992, including a rare appearance from Anne Briggs and commentary from a very youthful looking Billy Connolly. Great Stuff!

Posted in Bach | 1 Comment

Is light a wave or a particle?

Posted on 15/05/2009 by dougaj4

This clever ambigram from Douglas Hofstadfter provides the answer:

Posted in Newton | 4 Comments

Some string functions

Posted on 15/05/2009 by dougaj4

It was pointed out in a comment to this post at Daily Dose of Excel that VBA has a StrReverse function that will (logically enough) reverse a string.  That’s not awfully useful to me (except maybe for Project Euler), but it … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 5 Comments

Frame Analysis with Excel – 7; Shear deflections and support displacements

Posted on 11/05/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 31 Comments

Finding square roots …

Posted on 06/05/2009 by dougaj4

… to 100 decimal places. Why would anyone want to do that? To solve Project Euler Problem 80: “It is well known that if the square root of a natural number is not an integer, then it is irrational. The … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | 2 Comments