Category Archives: Excel

ULS Design Functions 2.16

Posted on 25/02/2023 by dougaj4

The ULS Design Spreadsheet has now been updated to Version 2.16, which can be downloaded from: ULS Design Functions The main new feature is the option to design for prestress loads applied to circular tanks. Due to axi-symmetric effects, when … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Secondary moments in prestressed beams with FEA-2

Posted on 14/02/2023 by dougaj4

Following the first post in this series, this post compares friction losses in prestressing cables as defined in the Australian Concrete Structures Code (AS 3600), compared with a cable modelled with contact elements in Strand7. The example used is based … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , , | 1 Comment

Using ConbeamU

Posted on 20/01/2023 by dougaj4

This post was prompted by a thread at Eng-Tips: https://www.eng-tips.com/threads/deflection-equations.501339/#post-8860838 The beam analysis functions in the ConbeamU spreadsheet allow for the use of any SI units, or any non-SI units found in the long list included with the spreadsheet. I … Continue reading →

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

Secondary moments in prestressed beams with FEA

Posted on 09/01/2023 by dougaj4

Secondary (or hyperstatic) bending moments occur in prestressed beams that are continuous over internal supports, or have other redundant support conditions. Any eccentric prestress force will cause a beam to deflect, and if these deflections are restrained at internal supports, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7 | Tagged , , , , , , | 1 Comment

py_UMom spreadsheet and OptShearCap3600 function

Posted on 20/12/2022 by dougaj4

I have now transferred the Ultimate Limit State design functions from the VBA RC Design Functions spreadsheet to Python format. The new spreadsheet and Python code can be downloaded from: py_UMom.zip The code also includes the OptShearCap3600 function, described in … Continue reading →

Posted in Excel | 1 Comment