Category Archives: Beam Bending

Beam Fixed End Actions by Macaulay’s Method

Posted on 13/11/2011 by dougaj4

Following the previous post examples have been added to the Macaulay Spreadsheet illustrating the use of the method to find fixed end moments and reactions for a beam fixed at one or both ends, and subject to any number of … Continue reading →

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

Beam actions and deflections by Macaulay’s Method

Posted on 12/11/2011 by dougaj4

Macaulay’s Method is a convenient method of applying beam slope-deflection equations to find the shear forces, bending moments, slopes and deflections of a structural beam subject to complex load conditions, including partial varying distributed loads and point loads and moments.  It … Continue reading →

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

Equivalent Stress Blocks

Posted on 19/10/2011 by dougaj4

Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading →

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

Spreadsheet Solutions For Structural Engineering

Posted on 07/10/2011 by dougaj4

Another site where the tasks considered suitable for programming in Excel and VBA are anything but “boring and repetitive” is Yakpol’s Spreadsheet Solutions For Structural Engineering: “This web site contains a collection of engineering spreadsheets for structural analysis and design of concrete and … Continue reading →

Posted in Beam Bending, Excel, Newton, VBA | Tagged , , , | 2 Comments

Using Beam Design Functions

Posted on 07/09/2011 by dougaj4

“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading →

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