Author Archives: dougaj4

Section Properties for Rotated Shapes

I have just posted an update to my section properties spreadsheet, last discussed at: Using Section Properties- Group The new version can be downloaded from: Section Properties07-Group.zip The main sheet provides section properties for a wide variety of defined shapes: This … Continue reading

Posted in Beam Bending, Coordinate Geometry, Excel, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment

More from Danny Thompson

… with two of his regular musical partners over the years. Danny Thompson with Richard Thompson, The Ghost of You Walks: and with John Martyn on The Old Grey Whistle Test in 1977; I Couldn’t Love You More:

Posted in Bach | Tagged , , , , , | Leave a comment

Reinforced Concrete Design for Circular Sections to Eurocode 2

As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular  or a parabolic-linear stress block.  A new CircuPF function has now been added, for codes … Continue reading

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

ULS Design Functions and EurocodeApplied

The ULS Design Functions spreadsheet (last updated here) has had another update (2.09) to fix a problem when bars in different layers had different E values.  The new version assigns the correct E and strain at yield to each layer. … Continue reading

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

Numerical integration with on-sheet calculations

Following a comment here I have prepared a spreadsheet that works through the Tanh-Sinh Quadrature process with on-sheet calculations.  For that purpose Graeme Dennes has provided a simplified version of the code: QUAD_RODRIGUEZ_TANH_SINH for finite intervals. Translated from HP RPN … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , | Leave a comment