Tag Archives: UDFs

py_ConBeamU and Strand7 check updates-2

Posted on 30/12/2025 by dougaj4

Recent work with the py_ConBeamU spreadsheet found that it was returning incorrect results when the last support had a rotation spring restraint. In spite of the checks against Strand7 having 90 different support conditions, none of them included this one, … Continue reading →

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

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