Tag Archives: plane strain

Retaining wall analysis – FEA and hand calculations

Posted on August 17, 2016 by

I have used the PlateMC spreadsheet described in the previous post to compare the results of a finite element analysis of a retaining wall with a similar analysis using the commercial package Strand7, and a simple hand calculation using Coulomb … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Frame Analysis, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA | Tagged , , , , , , , , , , , , , | Leave a comment

Plane Strain FEA – Non linear staged analysis

Posted on August 13, 2016 by

Continuing the recent series of posts featuring Fortran based FEA routines, the spreadsheet from the previous post has been revised: The spreadsheet allows for a staged analysis, with additional elements placed in layers for any number of construction stages. Temporary loads … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , , , | 1 Comment

FEA slope analysis; effect of mesh size

Posted on July 31, 2016 by

The last version of the FEA slope analysis spreadsheet (presented here) allows the slope shape and element density to be easily varied.  This post looks at the effect of varying the density from very coarse to fine, with constant soil … Continue reading →

Posted in Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Link to dll, Link to Python, Newton, VBA | Tagged , , , , , , , , , , | Leave a comment

Linking Excel to Fortran with ctypes; update

Posted on July 27, 2016 by

In the previous post arrays were created in Python and passed to a Fortran dll as ctype pointers.  The data written to these arrays in the Fortran routines was then converted back to Python arrays with statements such as: nodedisp = npc.as_array(nodedisp).  … Continue reading →

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

Linking Excel to Fortran, via xlwings, Python and ctypes

Posted on July 17, 2016 by

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 July 4, 2016 by

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 June 30, 2016 by

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