Category Archives: Frame Analysis

Python for VBA users- 6; Using Pysparse with Excel

Posted on 29/10/2013 by dougaj4

Previous Python Post The analysis of structural frames requires the solution of large sparse matrix systems, which rapidly becomes very time consuming using a VBA based solver, especially for 3D analysis.  I have previously presented versions of my frame analysis … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, VBA | Tagged , , , , , | 1 Comment

3DFrame Ver 1.03 and Frame4 Ver 3.07

Posted on 17/03/2013 by dougaj4

Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , | 34 Comments

Using Frame4 for truss analysis

Posted on 21/02/2013 by dougaj4

The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading →

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

3DFrame v1.01

Posted on 03/02/2013 by dougaj4

The 3D frame analysis spreadsheet has been updated to v1.01, with a correction to the calculation of node reactions.  The previous version gave incorrect results for any restrained node at end 2 of any beam. Please download the new version … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

3DFrame – 3D Frame analysis for Excel

Posted on 22/01/2013 by dougaj4

I have now extended the Frame4 spreadsheet to deal with 3D frames.  As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 21 Comments