Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Frame Analysis with Excel - 4, 2D frame analysis
- Contour plots with Excel and Matplotlib
- Function roots with the Inverse Quadratic Method
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
Recent Comments
Tag Archives: Mohr-Coulomb
Compiling Fortran code for Windows
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 Excel, FEA, Fortran, Mohr-Coulomb, plane strain, Programming the Finite Element Method, soil-structure interaction, VBA
2 Comments
Running exe files from Excel
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
Making non-linear FEA with Excel go (much) faster
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
2D non-linear FEA with Excel
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 Excel, FEA, Mohr-Coulomb, plane strain, soil-structure interaction, VBA
4 Comments