Category Archives: Frame Analysis

Column buckling under multiple loads

Posted on 20/01/2020 by dougaj4

Following another buckling discussion at Eng-tips I have modified my Frame4-buckle spreadsheet to allow input of multiple axial loads at any point along the column, along with any number of sections with different section properties.  Background on the method used … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , , | Leave a comment

64 bit Excel and the Strand7 API

Posted on 13/08/2019 by dougaj4

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment

3D Frame with zero stiffness hinges

Posted on 09/04/2019 by dougaj4

The previous version of 3DFrame allowed for spring releases at beam ends, but if the release stiffness was entered as zero it was treated as a rigid connection for that freedom.  Effectively zero stiffness releases could be modelled by entering … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton | Tagged , , , , , | 11 Comments

Transferring large arrays with Pyxll

Posted on 05/01/2019 by dougaj4

Pyxll is a commercial Excel add-in linking Excel and Python.  The latest version  offers greatly improved performance in transferring data between Excel and Python as Numpy arrays, amongst many other new features and improvements. To check what this means in practice, … Continue reading →

Posted in Arrays, Excel, Frame Analysis, Link to Python, PyXLL, UDFs, VBA | Tagged , , , , , , | Leave a comment

Using Redim and 3DFrame

Posted on 31/08/2018 by dougaj4

I recently received a query about the 3DFrame spreadsheet failing to run.  The problem was that the code was trying to Redim an array that had not been previously created with a Dim statement.  This does not cause a problem … Continue reading →

Posted in Excel, Frame Analysis, VBA | Tagged , , , | 1 Comment