Category Archives: Finite Element Analysis

Making non-linear FEA with Excel go (much) faster

Posted on 30/06/2016 by dougaj4

The spreadsheet presented in the previous post takes about 90 seconds to complete (with the iteration limit set at 500) on my computer, and is much slower on some other systems.  The VBA code that does all the hard work is based … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, VBA | Tagged , , , , , , , | 3 Comments

2D non-linear FEA with Excel

Posted on 23/06/2016 by dougaj4

This blog has many posts on analysis of 2D and 3D frame structures in Excel (see Frame Analysis Downloads), but this is the first on performing finite element analysis of a 2D continuum.  The file PlateMC.xlsb contains a simple example using … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, VBA | Tagged , , , , , | 4 Comments

What-when-how …

Posted on 19/05/2016 by dougaj4

… is a web site offering free tutorials on a wide range of subjects, including finite element analysis and VBA. The basics of finite element analysis are covered by links from: Computational Modelling (Finite Element Method) with more advanced material covered … Continue reading →

Posted in Finite Element Analysis, Newton, UDFs, VBA | Tagged , | Leave a comment

ConBeamU 4.08

Posted on 29/11/2015 by dougaj4

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

ConBeamU 4.05 and ConBeampy 1.02

Posted on 15/07/2015 by dougaj4

The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment