Spreadsheet Solutions for Structural Engineering

This website offers a 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

Designs reinforced concrete members in compliance with U.S., Canadian, and Australian building and bridge codes. Generates bending moment-axial force interaction diagrams, evaluates shear and torsion resistance, and checks for crack control under service loads.

Shareware

ShortColEC2

Eurocode 2 edition of the popular ShortCol spreadsheet for calculating axial and flexural capacity and crack width of reinforced concrete members. Features a convenient wizard-style interface.

Shareware

BoltGroup

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

Shareware

WeldGroup

WeldGrpoup computes resistance of the welded connections subjected to in-plane and out-of-plane loads per AISC, using elastic and instantaneous center methods. Easily generates standard or irregular weld patterns.

Shareware

SectProp

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

Shareware

SmartComb

Generates load combinations and 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 2024 AASHTO LRFD Bridge Code.

Shareware

Influence Lines

Generates influence lines for shear, bending moment, and support reactions in continuous beams. It 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