Recent Comments
Tag Archives: VBA
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
RC Design Functions update
Following a comment here I have updated my RC Design Functions spreadsheet, which is available for free download (including full open-source code) from: RC Design Functions7.zip The main new features in the latest version are: The existing optional “depth” argument has … Continue reading
Posted in Arrays, Beam Bending, Concrete, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged EStress function, Excel, Goal Seek, Reinforced Concrete, UDF, UMom function, VBA
1 Comment
What-when-how …
… is a web site offering free tutorials on a wide range of subjects, including finite element analysis and VBA. The basics of finite element analysis are covered by links from: Computational Modelling (Finite Element Method) with more advanced material covered … Continue reading
Posted in Finite Element Analysis, Newton, UDFs, VBA
Tagged Finite Element Analysis, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 