Spreadsheet Solutions for Structural Engineering

This website offers a comprehensive suite of engineering spreadsheets tailored for structural analysis and design. Developed by experienced professional engineers, these tools emphasize productivity, reliability, and clarity. To ensure their accuracy, each spreadsheet has been rigorously validated against leading commercial software.


GoBeam

The most intuitive and user-friendly continuous beam analysis software available. It supports both static and moving loads, accounts for support settlements, and offers non-linear analysis of beams on elastic foundations, plastic moment redistribution, and influence line analysis. The program also models elastic springs, column supports, in-span hinges, and variable beam stiffness.

Shareware

PSLoss

Computes elongation and and prestress losses in 3D post-tensioned tendons, accounting for frictional effects and anchor set."

Shareware

ShortCol

Performs comprehensive design of reinforced concrete members in compliance with U.S., Canadian, and Australian building and bridge codes. Generates bending moment–axial force interaction diagrams, evaluates combined shear and torsion effects, and conducts service stress analysis for crack control.

Shareware

ShortColEC2

Eurocode 2 edition of the popular ShortCol spreadsheet for calculating axial and flexural capacity, as well as crack control, of reinforced concrete columns. Features a convenient wizard-style interface for streamlined input and analysis.

Shareware

BoltGroup

Calculates the shear capacity of eccentrically loaded bolt groups using AISC LRFD methods, including both the instantaneous center of rotation and elastic analysis approaches. Supports irregular bolt layouts.

Shareware

WeldGroup

Implements the AISC LRFD methodology to determine the capacity of weld groups subjected to combined eccentric in-plane and normal loading. Includes automatic generation of standard weld patterns, enhanced result reporting, and detailed basis of design

Shareware

SectProp

Calculates structural properties of general cross-sections, including area, centroid, and moments of inertia. Also determines torsional characteristics of thin-walled sections, such as shear center location and warping moment of inertia. Sections can be defined using either discrete nodes or layered geometry descriptions.

Shareware

SmartComb

Generates load combinations and efficiently identifies extreme force envelopes for structural members, accounting for dual load factor alternatives that can produce a large number of combinations.

Shareware

ShearLRFD

Calculates reinforced/prestressed concrete member shear and torsion capacity according to 2006 AASHTO LRFD Bridge Code.

Shareware

Influence Lines

Generates influence lines for shear, bending moment, and support reactions in continuous beams. It also calculates force envelopes produced by custom moving loads. A highly educational application, it provides clear insight into structural behavior under varying load conditions.

Freeware

Surcharge Earth Pressure

This spreadsheet calculates lateral earth pressure on retaining walls resulting from multiple surcharge area loads. It is particularly useful for evaluating earth pressures induced by nearby vehicles and other stationary loads.

Freeware

XLSudoku

Excel based popular Sudoku puzzle. It creates puzzles, provides helpful notations and hints when you stuck. Lots of fun for the trap-like minds, enjoy.

Freeware

Travelling Salesman

This spreadsheet solves the famous travelling salesman problem of finding the shortest cyclical itinerary for a travelling salesman.

Freeware

Monty Hall Problem

The Monty Hall problem, named after the TV show Let’s Make a Deal, asks: You choose one of three doors—behind one is a car, behind the others, goats. The host, knowing what’s behind the doors, opens one with a goat and offers you the chance to switch. Should you? This simple puzzle has a surprising answer that even stumped many experts.

Freeware