AASHTO Steel Tunnel Liner Plate spreadsheet

Smooth-back tunnel liner plate in soft ground

Purpose:

To design an initial liner for a tunnel using steel liner plate.

Hoop thrust capacity of the liner is checked for a specified overburden pressure, hydrostatic pressure, and live load pressure, which consists of either AASHTO H-20 Truck Loading or Cooper E-80 Train Loading (Per AREMA).

Download Link

Assumptions/Limitations:

• Surrounding ground consists of granular or cohesive soil (Not rock)
• Tunnel support is 2-flange or 4-flange, smooth-back liner plate.
• Liner plate joints (flanges) are non-compact (not slender)

Boring Logs spreadsheet

Boring Logs spreadsheet is a sample spreadsheet for boring log which is very helpful for Geotechnical Engineers. Borehole logs are used to display the results of oil and gas, mining, geotechnical and environmental drilling and sampling. Logs can be used to display soil and rock samples.

Calculation Reference
Geotechnics

Download Link

Immediate Pad Footing Settlement spreadsheet

Download Link

Immediate Pad Footing Settlement spreadsheet calculates the immediate settlement of a pad footing given size and soil modulus. Based on equations in “Bowles : Foundation Analysis and Design Fifth addition international,Foundation Settlements pg303 Immediate Settlement Computations”

Calculation Reference
Bowles : Foundation Analysis and Design

Bridge Design Assessment Spreadsheet

Bridge Design Assessment spreadsheet will guide you through to calculate various MEXE Analysis and bridge related calculations.

This spreadsheet has been specially organized in accordance with calculate the capacity of a masonry arch using the modified MEXE process.

INSTRUCTIONS FOR USE:

• Put data in the yellow cells only. Factors may also be selected from the factor description.
• Symbols and factors are as described in the DMRB Standard BA16/97 Chapter 3.

Download Link

Beams on Elastic Foundation spreadsheet

Analysis for Flat roof systems in structural steel spreadsheet

“PONDING9” is a spreadsheet program written in MS-Excel for the purpose of analysis for ponding for low slope or flat roof systems in structural steel per the AISC 9th Edition (ASD) Code, pages 5-83 to 5-84 and 5-175 to 5-179.

Specifically, simplified checks are performed for the steel members as well as the steel deck. A rigorous analysis, whether actually required or not, is also performed for the steel members.

This program is a workbook consisting of two (2) worksheets, described as follows:

• Doc – Documentation sheet
• Ponding – Ponding analysis per AISC 9th Edition (ASD) Manual

All the worksheets are independent and self contained, so that you can move them from one workbook to another. All the worksheets are protected, but not with a password.

Program Assumptions and Limitations:

1.  This program utilizes the equations in AISC Code Sect. K2 to perform a simplified check on the primary and secondary members, as well as the steel roof deck.

2.  This program also performs a rigorous analysis on the primary and secondary members utilizing the equations in AISC Code Commentary Sect. C-K2.

3.  This program contains numerous “comment boxes” which contain a wide variety of information including explanations of input or output items, equations used, data tables, etc.  (Note:  presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell.  Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)

Calculation Reference
AISC

Download Link

Surcharge point loads spreadsheet

Retaining walls are built in order to hold back earth which would otherwise move downwards. A surcharge load results from forces that are applied along the surface of the backfill behind the wall. These forces apply additional lateral forces along the back of the wall. This spreadsheet calculates the resulting pressure field acting on the retaining wall due to a point load at a given position behind the wall.

Calculation Reference
Surcharge Loads

Download Link