Author Archives: dougaj4

More Acoustic Routes

Posted on 27/06/2009 by dougaj4

Parts 2-8 of Acoustic Routes have now been uploaded to Youtube. Part 2: Double click on the link above to go to Youtube and find the remaining 6 parts.

Posted in Bach | Leave a comment

A catenary function

Posted on 25/06/2009 by dougaj4

Following on from the previous post, here is an Excel User Defined Function (UDF) to calculate the coordinates of any specified catenary, with the option of also finding the tension force at any point. Download from: Catenary.zip The download file … Continue reading →

Posted in Arch structures, Excel, Maths, Newton, UDFs, VBA | 3 Comments

Elegant proofs 4 – The optimum shape of an arch

Posted on 16/06/2009 by dougaj4

Large span arch structures have been constructed for well over two thousand years, but the first recorded analytical treatment was given by Robert Hooke in 1675 who at the end of his treatise on helioscopes added the following statement “to … Continue reading →

Posted in Arch structures, Newton | 10 Comments

Applied Mechanics of Solids

Posted on 23/05/2009 by dougaj4

Applied Mechanics of Solids is a free text on finite element analysis by Allan F Bower, who seems to have a gift for clear explanation of the topic combined with a wry sense of humour; not a combination you see every … Continue reading →

Posted in Finite Element Analysis, Newton | Tagged | Leave a comment

Adding Function Categories and Descriptions

Posted on 21/05/2009 by dougaj4

User defined functions (UDF’s) are by default added to the “User Defined” category in the function list, and when a UDF is selected the words “no help available” appear, rather than a description of the function and it’s parameters.  A rather … Continue reading →

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