Category Archives: PyXLL

py_ConBeam – 2

Posted on 27/07/2024 by dougaj4

Continuing from the previous post, today I will be looking at the Macaulay function, that performs the underlying analysis, and the application of this function to cantilevers and single span beams. There have been some significant changes to the Python … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 2 Comments

py_ConBeamU

Posted on 21/07/2024 by dougaj4

I have now converted the VBA code in the ConBeamU spreadsheet to Python, connected to Excel via pyxll. The new spreadsheet and associated Python code can be downloaded from: py_ConBeamU.zip In addition to the provided files, the pyxll application is … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , | 4 Comments

New Australian Bridge Code and py-RC Elastic update 3

Posted on 30/06/2024 by dougaj4

The Australian Bridge Design Code for concrete (AS 5100.5) was recently updated with Amendment 2 to the 2017 version. There are significant changes in many areas, including design for fatigue loading, where the allowable stress range for concrete under repeated … Continue reading →

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

py_RC Elastic update 2

Posted on 12/06/2024 by dougaj4

Following the previous post, I have added a further new function, and in the process discovered that the py_Estress function was not handling tensile axial loads correctly. That has now been fixed, and the updated spreadsheet and Python files can … Continue reading →

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

py_RC Elastic update

Posted on 08/06/2024 by dougaj4

Following the previous post I have updated the py_RC Elastic spreadsheet and code to work with the new solver function, and also add new functionality. The updated files can be downloaded from: py_RC Elastic.zip For details of the pyxll app … Continue reading →

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