Guide for Calculation of Plane Trusses with Excel Sheets

Must read

Steel Structure Warehouse

3D House Modeling on Revit

2D Plans of Commercial Area

CivilMat
CivilMathttps://civilmat.com
I’m Haseeb, a civil engineer and silver medalist graduate from BZU with a focus on structural engineering. Passionate about designing safe, efficient, and sustainable structures, I share insights, research, and practical knowledge to help engineers and students strengthen their technical foundation and professional growth.

Structural engineering includes designing and analysing plane trusses, which is one of the most basic but effective skills. Working on a bridge, roof trusses, or industrial frame, knowing the calculations of the forces in the truss members is essential in providing safety, stability and economical concerns in a design.

We are going to take you through the entire plane truss analysis process in this article, which will involve methods, assumptions, formulas, and tips for doing it. At the end, you will have no problems computing the member forces both analytically and through Excel-based means.

What Is a Plane Truss?

A plane truss is a structure that consists of two-dimensional straight members fitted at their ends using pinned joints. The primary role of a truss is to assist in the transfer of loads by compression and tension, but not bending.

Typical examples include:

  • Roof trusses
  • Bridge trusses
  • Transmission towers
  • Crane structures

The trusses within a plane are positioned in a single plane and are connected at triangular-shaped joints, which increase geometric stability.

Simple Truss Analysis Assumptions

The main assumptions that should be kept in mind before doing any calculation are:

  • Frictionless pins connect all the members.
  • The loads and reactions are realised only at the joints.
  • The members are two-force members (only tension or compression is applied).
  • The weight of the members is not significant (unless stated otherwise).

These assumptions make the analysis simple since you can use the equilibrium equations of a static analysis to ascertain the forces of the members.

RETICULADO (11020)01-2https://docs.google.com/spreadsheets/d/15vadjd9Ruc6aH2WilWQmgH-1khLBgsWJ/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
RETICULADO DE 3 BARRAShttps://docs.google.com/spreadsheets/d/19WmZRw-_1CYMnsuOWwrj4–Z6JlNm3Sr/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
RETICULADO APPENDIX Chttps://docs.google.com/spreadsheets/d/1Czi1pULX4UNxc8GG3EWOJH2XoF5to3Oa/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
lab9_s_07 (APOYOS CORREGIDOS)https://docs.google.com/spreadsheets/d/1SRAFL59O7VJ6ZHP9dI22eVDyWrTssKkw/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
RETICULADO maple_handout_4 – sample problemhttps://docs.google.com/spreadsheets/d/1vLJnEhQ00QT-iljCewtxUmsJidD_7y8R/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
RETICULADO pr_01https://docs.google.com/spreadsheets/d/14wT0famYi5jSXjzX3nCGlHNXO5pfdY-E/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
res_main (APOYOS CORREGIDOS)https://docs.google.com/spreadsheets/d/1kuVn6l-otBGG0OBEIdLxkR5SbtZoMKVd/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
RETICULADO SAMPLE PROBLEM – 2https://docs.google.com/spreadsheets/d/1SzsUgRJ_za1BqVHfx31OgNOkyrfHfCE9/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true
TRUSS EJEMPLO 1(APOYOS CORREGIDOS)https://docs.google.com/spreadsheets/d/1PM8eZPF-Zat68hTBVnrHd3jgmPay8ZAy/edit?usp=sharing&ouid=117026315595257427957&rtpof=true&sd=true

11/12/2025 New sheets will be added soon!

See also  Wind Analysis for Low-rise Building, Based on ASCE 7-98

Have Feedback?

Feel free to drop your comments below. I usually reply within 8 to 24 hours.

- Advertisement -

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here
Captcha verification failed!
CAPTCHA user score failed. Please contact us!
- Advertisement -

Latest article