You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

2D FEA (1.5)
This location is for Registered Users Only.
Perhaps you need to login or register.

Calculation Preview

2D finite element analysis (stiffness method) with more than 51 degrees of freedom.
How to use this spreadsheet:

1) Input total number of nodes for the structure in cell E3 on the "FEA.Input" tab.
2) Define the xy coordinates for each node. Columns F & G on the "FEA.Input" tab.
3) Identify the "free" and "fixed" degress of freedom for each node. Columns H, I, & J on the "FEA.Input" tab.
4) Input the material properties for each member. Columns T, U, V, & W on the "FEA.Input" tab.
5) Input node/joint loads into columns AJ, AK, & AL on the "FEA.Input" tab.
6) Input member distributed loads in Columns AO & AP on the "FEA.Input" tab. (uniform, trapezoidal or triangular) sign convention is same as in step 5
7) Input option for an intermediate point load columns AS, AT, & AU on the "FEA.Input" tab. sign convention is same as in step 5
8) run analysis by pressing the "FEA" control button on the "FEA.Input" tab.
9) see results and deflection plot on the "Results" tab

The Gauss-Jordan method is used to over come the 51x51 "MINVERSE" limitation of excel .

Calculation Reference
Beam Analysis
Structural Assessment
Finite Element Method

Submitted By:
Jason (jason.only)
Submitted On:
02 Oct 2014
File Size:
8,610.37 Kb
File Version:
File Author:
Total Votes:2
Comments: 1
JohnDoyle[Admin] 5 years ago
I particularly liked seeing the validation of the calculation method. I have awarded a free XLC Pro subscription for a year. Thank you Jason.

We have 287 guests and 3 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. News RSS.