Category Archives: Uncategorized

Frame Analysis with Excel – 4, 2D frame analysis

Posted on February 15, 2009 by dougaj4

Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download Frame1.zip – 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

Posted on February 4, 2009 by dougaj4

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

Posted in Newton, Uncategorized | Leave a comment

Frame Analysis with Excel 1 – Single beam

Posted on January 31, 2009 by dougaj4

Download Beam1.zip 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

Posted on January 12, 2009 by dougaj4

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

Posted on December 4, 2008 by dougaj4

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 Cubic.zip 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