Category Archives: Uncategorized

Frame Analysis with Excel – 4, 2D frame analysis

Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download – the download file includes complete open source code. The continuous beam spreadsheet presented in the previous post has been modified to deal with 2D frames where any … Continue reading

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

Putting things in perspective

Life, The Universe and everything plotted on a spiral scale:

Posted in Newton, Uncategorized | Leave a comment

Frame Analysis with Excel 1 – Single beam

Download This is the first of a series of posts in which I will develop a structural frame analysis program operating within Excel.  The first few stages will be mostly spreadsheet based, with later stages using VBA routines to … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, Uncategorized | Tagged , , , | 14 Comments

A Tribute to Davy Graham

The English musician Davy Graham died from Lung Cancer on 15th December 2008, an event that received no attention from the mainstream media, at least here in Australia, but he was probably the single greatest influence on the British musicians … Continue reading

Posted in Bach, Uncategorized | Tagged , | 1 Comment

Linking Excel to Fortran – 2

In this post the procedures described for C++ here will be replicated for Fortran: The spreadsheet, fortran source code, and compiled dll described in this code may be downloaded from As always, it is better to use the downloaded code, … Continue reading

Posted in Excel, Fortran, Link to dll, Maths, UDFs, Uncategorized, VBA | Tagged , , , , , | 23 Comments