Category Archives: Finite Element Analysis

Compiled Matrix Functions for Excel

Posted on 12/11/2012 by dougaj4

This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding.  The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading →

Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 4 Comments

Mohr’s Circle and Plate Stresses and Actions

Posted on 27/10/2012 by dougaj4

The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

Daily Download 6: Working with FEA programs

Posted on 22/09/2012 by dougaj4

Today’s downloads are three programs for working with Finite Element Analysis (FEA) programs.  The first use the Scripting Dictionary Object to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at … Continue reading →

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | Leave a comment

Daily Download 5: Frame Analysis

Posted on 21/09/2012 by dougaj4

Leading on from yesterday’s continuous beam functions, today’s download covers four frame analysis spreadsheets, with increasing levels of complexity.  For those interested in the workings of the program I recommend working through each spreadsheet, but for practical applications the final … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , | 12 Comments

Frame4 – with intermediate beam results

Posted on 11/09/2012 by dougaj4

Back in March 2010, in response to this post with an update of the Frame4 spreadsheet: https://newtonexcelbach.wordpress.com/2009/12/31/frame4-xls-update2/ jscott (and later mettrox) asked if I had thought about adding output of the member forces at intervals along the member length, to which the response … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 5 Comments