Category Archives: VBA

Daily Download 4: Continuous Beam Analysis

Posted on 20/09/2012 by dougaj4

Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 15 Comments

Daily Download 3: ULS design of reinforced concrete sections

Posted on 19/09/2012 by dougaj4

Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section. The ULS analysis spreadsheet is described at: … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 23 Comments

Daily Download 1: Buckling of columns, rings and arches

Posted on 17/09/2012 by dougaj4

One of the disadvantages of the blog format is that valuable resources tend to get lost somewhere in the archives.  To help make them a bit more visible, for the next month or so I plan to post links to … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Tanh-Sinh Quadrature V3.0

Posted on 13/09/2012 by dougaj4

I have received from Graeme Dennes  another update to his Tanh-Sinh Quadrature spreadsheet, offering fast and convenient numerical integration functions.  The spreadsheet can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: Tanh-Sinh Quadrature … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 5 Comments

Frame4 – with intermediate beam results

Posted on 11/09/2012 by dougaj4

Back in March 2010, in response to this post with an update of the Frame4 spreadsheet: https://newtonexcelbach.wordpress.com/2009/12/31/frame4-xls-update2/ jscott (and later mettrox) asked if I had thought about adding output of the member forces at intervals along the member length, to which the response … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 5 Comments