Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Calling Add-in functions from VBA
- About Newton Excel Bach
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
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