Tag Archives: UDFs

Continuous beam animations with VBA and Python

Posted on 20/12/2025 by dougaj4

Following a lengthy discussion at Eng-Tips I have developed several functions to generate animations of the effects of applied moving loads. The Python code and examples have been added to the py_ConBeamU.zip file which can be downloaded from: py_ConBeamU.zip Starting … Continue reading →

Posted in Animation, Beam Bending, Charts, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , , , , , , , , | 1 Comment

py_ConBeamU and Strand7 check updates

Posted on 11/12/2025 by dougaj4

Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading →

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

ConBeamU and Strand7 check update

Posted on 05/12/2025 by dougaj4

Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading →

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

py_Numpy update 2: Polynomial functions

Posted on 04/10/2025 by dougaj4

Continuing from the previous post, this post looks at the polynomial functions in the revised py_Numpy spreadsheet. The updated code and spreadsheet can be downloaded from:  py_SciPy.zip The available functions call the Numpy functions for solution and evaluation of polynomials, … Continue reading →

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

py_RC Elastic 1.05 with elastic biaxial bending

Posted on 24/09/2025 by dougaj4

The py_RC Elastic spreadsheet (last discussed here) has been updated with a new function py_Biax, providing elastic analysis of reinforced concrete sections under combined axial load and biaxial bending. The new spreadsheet and associated Python code can be downloaded from: py_RC … Continue reading →

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