Tag Archives: py_UMom

Monte Carlo simulation with Excel and Python

Posted on 31/05/2026 by dougaj4

The pyxll blog has a post from last year on Monte Carlo Simulations in Excel with Python, with examples and full code going from the simplest implementation to more refined code allowing all the calculations to be set up on … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs | Tagged , , , , , , , | Leave a comment

py_UMom 1-05

Posted on 26/10/2025 by dougaj4

Following the previous post the OptShearCap3600 function has been modified to give correct results with negative bending moments. The revised spreadsheet and Python code can be downloaded from: py_UMom.zip Typical output with negative moment input:

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

py_UMom 1.04

Posted on 19/10/2025 by dougaj4

The py_UMom spreadsheet has been updated with further revisions to the py_OptShearCap3600 function. The new version can be downloaded from: py_UMom.zip For more information on the other functions in the spreadsheet see: py_UMom spreadsheet and OptShearCap3600 function. The changes to the … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs | Tagged , , , , , , , | 1 Comment

Python Code Updates – py_UMom

Posted on 18/11/2023 by dougaj4

Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading →

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 1 Comment

Longitudinal force due to shear – update

Posted on 09/10/2023 by dougaj4

In the post RC Design Functions 9.03; compression strut angle adjustment I recommended that when finding the longitudinal force due to shear according to AS 5100.5 (Amendment 1), the effect of increased vertical shear reinforcement should be limited in accordance … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , | 1 Comment