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.
Feel free to contact us with any questions related to the spreadsheets or tips listed on this site.
|Abutment||Abutment design spreadsheet can be used to obtain design forces for abutment or retaining wall.|
|Load Combinations||Assemble load combinations from individual load cases in a flexible and efficient manner.|
|Pile 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.|
|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.|
|Plate Girder Splice||Design of boltes splice for steel plate girders following AASHTO LRFD, 3rd Edition (2004). English units.|
|Shear Studs||Design of shear studs for continuous and simple spans according to AASHTO LRFD, 3rd Edition (2004). English units.|
Free Spreadsheets and Templates
|Database Spreadsheet||Example of spreadsheet with database capabilities. Enables to save input values and results for multiple repeated calculations in the same spreadsheet file.|