Tag Archives: Python

Python code updates – 3DFrame-py

Posted on 03/11/2023 by dougaj4

Recent changes to how Python treats comparing a Numpy array to an empty list have resulted in some of my functions returning errors and I am in the process of updating them. Specifically, when an optional argument to a function … Continue reading →

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

SectionProperties Release 3

Posted on 21/10/2023 by dougaj4

Robbie van Leeuwen’s SectionProperties program, (last featured here) has recently been updated to Release 3 with some major changes to the code, including: Full documentation can be found at: SectionProperties docs Changes to the code have required updates to my Excel … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Link to Python, Newton, PyXLL, UDFs | Tagged , , , | Leave a 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

Python in Excel – two views

Posted on 02/09/2023 by dougaj4

Microsoft recently announced that it is now possible to access Python from within Excel worksheets. This functionality is currently only available to Excel 365 users on the Insiders – Beta channel, who can access it at no cost. When it … Continue reading →

Posted in Excel, Link to Python, Python Pandas, PyXLL | Tagged , , , , | 2 Comments

3DFrame-py

Posted on 05/07/2023 by dougaj4

My 3DFrame spreadsheet has now been converted to Python code and can be downloaded from: 3DFrame-py.zip The frame analysis uses the Scipy linear algebra functions called from pyLinalgfuncs3, which must be available on the Python path: pyLinAlgfuncs3.zip The 3DFrame-py download … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, VBA | Tagged , , , , , , , | 3 Comments