**Related Resources: Design Engineering**

### 2D Finite Element Analysis Spreadsheet Calculator

**Engineering Excel Spreadsheet Downloads
**

**Civil Engineering Resources**

**Structural Design Engineering Resources**

2D Finite Element Analysis Spreadsheet Calculator

Note: Accessing this resource requires an active * Premium Membership* with Engineers Edge

Download:

2D Finite Element Analysis Spreadsheet Calculator

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.

Column T - Cross sectional area of member

Column U - member modulus of elasticity

Column V - moment of inertia

Column W - member material density to consider the member self weight (optional)

5) Input node/joint loads into columns AJ, AK, & AL on the "FEA.Input" tab.

Column AJ - joint load in the x direction (negative from right to left, positive from left to right)

Column AK - joint load in the y direction (negative if force acts downward, positive if forces acts upward)

Column AL - moment acting on joint (positive if moment acts CCW, negative if moment acts CW)

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

Column AO - distributed member load at beginning node

Column AP - distributed member load at ending node

Column AQ - define how the member load is applied to member see "About" Tab

uniform load beginning and ending values are equal

trapezoidal load beginning and ending values are not equal

triangular load beginning or ending values equal to zero

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

a - distance from start node that load acts

b - distance from stop node that load acts

8) run analysis by pressing the "FEA" control button on the "FEA.Input" tab.

9) see results and deflection plot on the "Results" tab

Note:

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

Preview

**© Copyright 2000 - 2018, by Engineers Edge, LLC www.engineersedge.com All rights reserved
Disclaimer
| Feedback | Advertising
| Contact **