Category Archives: Uncategorized

Frame Analysis with Excel – 4, 2D frame analysis

Posted on February 15, 2009 by

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 , , , | 19 Comments

Putting things in perspective

Posted on February 4, 2009 by

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

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

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

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

Problem with file downloads

Posted on July 26, 2008 by

There has been a problem with the web site where I host my files for downloading, with the result that any links for file download will not have been working. I have copied all the linked files to: New file … Continue reading →

Posted in Uncategorized | Leave a comment

Reinforced Concrete Section Analysis – 4

Posted on June 21, 2008 by

Previous post The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis: For a cross section with any applied axial load at eccentricity e, measured from … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, Uncategorized | Tagged , , , , | 1 Comment