Home

The goal of DesignSpreadsheets.com is to develop analysis and design spreadsheets for structural engineering and to provide useful information about developing and maintaining high quality technical spreadsheets for developers of all levels of experience. This website offers tips gained from the experience of developing reusable technical spreadsheets by practicing bridge engineers. Sample Visual Basic code is provided for frequently used VBA functions. Currently available spreadsheets are listed in the table below.

Spreadsheets

Download Details Summary
Excel icon Abutment Abutment design spreadsheet can be used to obtain design forces for abutment or retaining wall.
Excel icon Load Combinations Assemble load combinations from individual load cases in a flexible and efficient manner.
Excel icon Pipe Group Analysis Obtain pile forces for regular and irregular pile groups for multiple load combinations in a single spreadsheet. Quickly check governing forces corner piles or review forces on all piles in a two dimensional layout.
Excel icon Plate Girder Section Calculates noncomposite and composite (for modular ratios n and 3n) section properties for steel I-girders with concrete deck. Calculates cumulative stresses at critical locations for loads applied to noncomposite and composite sections. Detailed calculations for determination of flexural and shear capacity according to AASHTO LRFD, 3rd Edition, 2004. Calculates plastic and yield moments. English units.
Excel icon Plate Girder Splice Design of boltes splice for steel plate girders following AASHTO LRFD, 3rd Edition (2004). English units.
Excel icon Shear Studs Design of shear studs for continuous and simple spans according to AASHTO LRFD, 3rd Edition (2004). English units.