Beam Analysis with FEM Excel Sheet

Beam Analysis with FEM Excel Sheet

 

 

Beam Analysis with FEM Excel Sheet is an application of MS-Excel “Solver” to Non-linear Beam Analysis written by Toshimi Taki Prepared on March 4, 2007

There are some types of beam structures as shown in figure 1.

Figure 1 : Types of Beam Structures

If beam elements of “simple beam” structures are subject to lateral load only, this type of beam structure shows linear behaviour. “Simple beam” structures can be analysed easily. When beam elements in a beam structure are subject to lateral load and axial load, the structure shows non-linear behaviour.

The examples of the non-linear beam problems are beam columns, Elastica and arch structures. Analytical method is applicable only to idealized structures such as uniform cross section beam column.

You need to use non-linear finite element analysis to solve non-linear beam structures in real world. I have developed a new method to solve non-linear beam structures.

This is a direct application of energy principle using MS-Excel “Solver”. Application of MS-Excel “Solver” to Non-linear Beam Analysis “Elastica” is used as an example to show the method. Following figures show the results.

Figure 2 :  Model for Elastica

 

Figure 3 :  Result — Deflection

 

Figure 4 : Result — Load-Deflection Curve

 

Download Link

 

Base Isolated Building Design Excel Sheet

Base Isolated Building Design Excel Sheet

 

DESIGN CRITERIA

1. Base isolator system can reduce seismic loads by increasing the period/reducing the stiffness of structure. But the building wind loads are the same without change. So not all structures are adequate for base isolator system, with both seismic and wind limits.

2. The period of fixed-base structure and building wind load can be calculated by 3D finite element method (FEM) and spreadsheets.

But it is very difficult to use finite elements modeling isolators, since damping and isolator stiffness matrix. This design method, using building effective stiffness concept for entire structure and isolated system, to check if the structure is adequate for base isolator system. If adequate, users can select and test isolated system by wind loads to drift limits (ASCE 7-16/10 17.2.4.2 & 17.5.6).

Download Link

Beam Analysis Spreadsheet

Beam Analysis Spreadsheet

 

Beam Analysis is a spreadsheet template for calculatin Shear, Bending Moment ans Deflection along member lengths acting as beams and subjected to vertical loads and moments. Information for up to 500 beams can be stored, retrieved, amended and used for manual or auto analysis as and when required

 

Download Link

error: Content is protected !!
Exit mobile version