Tag Archives: FEA

Linking Excel to Fortran, via xlwings, Python and ctypes

Posted on 17/07/2016 by dougaj4

Continuing the recent series on using Fortran code published in Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)), this post looks at linking Excel to Fortran code compiled as … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, VBA | Tagged , , , , , , , , , , | 2 Comments

Compiling Fortran code for Windows

Posted on 04/07/2016 by dougaj4

This post is a continuation of a recent series, using Fortran code published in  Programming the Finite Element Method (5th ed. John Wiley & Sons, I.M. Smith, D.V. Griffiths and L. Margetts (2014)). The compiled file provided in the download should … Continue reading →

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

Running exe files from Excel

Posted on 30/06/2016 by dougaj4

Following on from the previous post (running a compiled Fortran finite element analysis program from Excel), this post looks at the details of calling any command line routine from Excel, through VBA.  The important points that need to be addressed are: Writing … Continue reading →

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

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