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: