Structural Analysis of Plane Truss using Excel VBA

 

Input data

Input data cont'd

Output data

Truss diagram

Deflected truss diagram

Program Verification Problem: Structural Analysis of Three Span Beam using Excel VBA

 Sample Three Span Beam Analysis with Excel VBA using Finite Element    Analysis

Excel input interface: Joint information

Excel input interface-Support_load information

Excel output interface-Joint displacements

Excel output interface-End forces_Reactions

Program Verification Problem: Structural Analysis of Three Span Beam using Mathcad Prime

 Sample Three Span Beam Analysis with Mathcad Prime using Finite Element Analysis

Sample problem

Input data

Stiffness matrices for spans

Global stiffness matrix

Joint load vector

Joint deflection vector

Member end forces

Member end reactions

Program Verification Problem: Structural Analysis of Three Span Beam using Scilab with Visualization

 Sample Three Span Beam Analysis with Scilab using Finite Element Analysis

Sample input file

Stiffness matrix span 1

Stiffness matrix span 2

Stiffness matrix span 3

Global stiffness matrix for the whole beam

Joint load vector

Joint displacements

Member end forces

Support reactions

Bending moment diagram

Shear force diagram

Beam deflection diagram

Beam rotation diagram

Open Rectangular Storm Drain Rate Analysis Breakdown Using Scilab

 

Empty Userform Before Data Input

Userform With Input Data

Userform With  Output and Graphics 

Userform With  Output and Graphics

Program Verification Problem: Structural Analysis of Three Span Beam using Scilab

The three span beam below is to be analysed using Scilab

 

Sample Scilab Input

 

Stiffness Matrix Span 1

 

Stiffness Matrix Span 2

 

Stiffness Matrix Span 3

 

Global Stiffness Matrix for the Whole Beam

 

Joint Load Vector

 

Joint Displacements

 

Member End Forces

 

 Support Reactions

Bending Moment Diagram

 

Shear Force Diagram

 

Textbook Solution

 

Textbook Analysis Result

 

 

 

 

 

Excel VBA to Automate the Rate Analysis of Blockwork

 

Graphical User Interface

 

Output Excel Interface