Author Archives: dougaj4

Beam geometric non-linear effects – Python version

Posted on 12/10/2024 by dougaj4

In 2018 I posted Beam geometric non-linear effects with a VBA based spreadsheet to calculate beam actions and deflections under combined transverse and axial load, allowing for geometric non-linear effects. I have now converted the code to Python, linking to Excel … Continue reading →

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

Two traditional songs …

Posted on 10/10/2024 by dougaj4

… with very different renditions. First from 1967, Martin Carthy and Dave Swarbrick join Julie Felix: Then a new version of Tam Lin from 2022, by Fiona Gillespie and Elliot Cole and performed by Makaris: For more om Makaris see … Continue reading →

Posted in Bach | Tagged , , , , , , | Leave a comment

Continuous beam analysis from first principles

Posted on 22/09/2024 by dougaj4

This post was prompted by an Eng-Tips question: Statically Indeterminant Beam Problem, asking for reactions due to a triangular distributed load on the middle span of a continuous beam with 3 equal simply supported spans. This could be simply solved … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA | Tagged , , , | 3 Comments

Scipy-statistics update

Posted on 08/09/2024 by dougaj4

Links to the Scipy statistics functions were last presented here. The functions have since had extensive updates: The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll … Continue reading →

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

py_Numpy update

Posted on 31/08/2024 by dougaj4

The py_Numpy spreadsheet, and the associated Python module have been updated. The new files are included in: py_SciPy.zip The download contains full open-source Python code and example spreadsheets for a wide range of Scipy functions, as well as the Numpy … Continue reading →

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