Category Archives: Uncategorized

Frame Analysis with Excel – 4, 2D frame analysis

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

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 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

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 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

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

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