Category Archives: Frame Analysis

Column buckling under multiple loads

Posted on January 20, 2020 by

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 August 13, 2019 by

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 April 9, 2019 by

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 , , , , , | 3 Comments

Transferring large arrays with Pyxll

Posted on January 5, 2019 by

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 August 31, 2018 by

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

Beam geometric non-linear effects

Posted on April 21, 2018 by

A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 2 Comments

Frame Analysis Resources

Posted on April 17, 2018 by

I recently discovered: Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, and Ziemian. which is available for free download: Description The aims of the first edition of Matrix Structural Analysis were to place proper emphasis on the methods of matrix … Continue reading →

Posted in Finite Element Analysis, Frame Analysis, Newton | Tagged , , | 1 Comment