Category Archives: Excel

3DFrame-py rel. 0.40

Posted on 01/01/2025 by dougaj4

A new version of 3DFrame-py has been released and can be downloaded from: 3DFrame-py.zip See Installing 3DFrame-py for installation details, and details of other Python modules required. Also see Python and pyxll for details of the required pyxll package, including a coupon code for … Continue reading →

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

Scipy update and Linalgfuncs speed check

Posted on 16/12/2024 by dougaj4

I have updated the Scipy code to remove repeated loading of the Numpy code, and to fix a number of other warnings from the pyxll log file. I have also updated the speed check of the various linear algebra solvers, … Continue reading →

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

Biaxial bending update 2

Posted on 13/12/2024 by dougaj4

It was recently reported that the VBA version of the biaxial bending spreadsheet was returning incorrect results when the neutral axis was exactly parallel to the Y axis. This problem has now been fixed, and the revised spreadsheet can be … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 5 Comments

3D-Frame-py with Numba

Posted on 10/12/2024 by dougaj4

I recently upgraded to Python 3.12, and installed the latest version of the Numba just-in-time compiler (0.60.0) which also required upgrading Matplotlib (3.9.3), and downgrading Numpy (2.0.2). I have also edited calls to Numba in the py_3DFrame1_1.py module, and added … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , , , , | Leave a comment

3DFrame-py; non-linear with end releases

Posted on 06/12/2024 by dougaj4

The non-linear analysis routines in 3DFrame-py have now been updated to work with beams with end-releases at one or both ends.  Updated files are at: 3DFrame-py.zip See the previous two posts for details of other software required for installation. To … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , , , , , | Leave a comment