Tag Archives: Excel

Daily Download 2: SLS design of reinforced concrete sections …

Posted on 18/09/2012 by dougaj4

… and prestressed concrete sections. Today’s download installment covers spreadsheets for design of reinforced and prestressed concrete beams and columns at the Serviceability Limit State (SLS).  The spreadsheets cover design of rectangular and circular sections, sections made up of any … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs | Tagged , , , , , , , , , , | 15 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

Continuous Beam Spreadsheet – with Units

Posted on 06/09/2012 by dougaj4

The spreadsheet previously known as Macaulay has been updated to include “unit aware” versions of all the included functions, and has been renamed “ConBeamU”, to make it more obvious what it does.  The new spreadsheet (including full opens source code) can be … Continue reading →

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