Reverse engineering of truss load tables

Not all truss datasheets hold information on design forces, such as bending moments and shear forces needed to perform static calculations.

This post will take a quick look at a spreadsheet, which can aid you in solving this (Direct download link at the end of the post).

Keep it simple

Using the partial safety factors of unfavorable loading conditions, beam design formulas, and a bit of spreadsheet logic, the workflow illustrated below was drafted. Output considered as a rough estimate.

Does it work?

Inputting the load table values of the Prolyte H30V truss, an estimated bending moment M = 23,96 kNm and a shear force V = 14,72 kN was calculated.

Quite close to the values (M = 24,00 kNm and V = 14,73 kN) supplied in the TüV certificate. (Screenshot of data and comparison below).

Download, use and share it

The spreadsheet is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Download it directly from (No registration needed.)