ULS Design Functions – Python version

I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from:

py_ULS Design Functions

The spreadsheet has the same functionality as the VBA version, providing ULS analysis of any reinforced concrete section divided into trapezoidal layers, to Australian codes, Eurocode 2, and ACI 318. It also has the added functionality of design for shear (currently to Australian codes only), and a function allowing simplified input for rectangular sections.

Input is in the same format as the VBA version, with the optional addition of shear data input where required (click any image for full-size view):

Note that for shear design:

  • The design shear force and torsion, and the associated bending moment must be entered in the range D5:F5.
  • For any hollow or non-rectangular section, or a section with prestressing ducts, the effective web width must be entered in cell F8.
  • For box sections the additional data in range T44:T47 is required.

The tendon angle entered in cell F9 is currently only used for shear design.

Output is also in similar format, with the addition of shear related results:

The py_UmomR function has simplified input for rectangular sections with two layers of reinforcement:

This entry was posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs and tagged , , , , , , , , , , , , . Bookmark the permalink.

2 Responses to ULS Design Functions – Python version

  1. Shan Kumar says:

    Thanks heaps for your tireless contribution to the world of structural engineering


  2. I love it. Excellent work!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.