Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
Recent Comments
Tag Archives: soil-structure interaction
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
Update to Publications
I have (at long last) updated my list of publications (all downloadable). Click on the link below to visit the site, or download direct from the list here. My Publications Here is the current list: Predicting the Deflection … Continue reading