Seimic response of liquid storage tank Spreadsheet
Tag: Spreadsheet
Liquefaction Analysis Excel Sheet
Liquefaction Analysis Excel Sheet
This spreadsheet identifies possible zones of liquefaction in soil profile. It compares the anticipated cyclic shear stresses induced by an earthquake to the estimated cyclic strength of the soil. Zones where the induced stress is greater than the cyclic strength are deemed zones of liquefaction.
US Steel Sheet Pile Design – Cantilevered Wall Spreadsheet
US Steel Sheet Pile Design – Cantilevered Wall Spreadsheet
US Steel Sheet Pile Design – Cantilevered Wall (Granular Soil) with Cooper E80 Surcharge
Spreadsheet Description:
Computes the depth required, maximum moment, and section modulus required for Sheet Pile Design based on US Steel’s Sheet Piling Design Manual. There is a sheet to analyze the effects of Cooper E80 loading per AREMA Specifications. However, normal traffic or equipment surcharge loads can be used as well. Graphs are provided for Log Spiral Active and Passive coefficients.
Table of Contents:
1) Background and Instructions
2) Calculations for Pile Depth
3) Equation Solver and Graphical Check of Results
4) Maximum Moment and Section Modulus
5) Calculations and Graph of E80 AREMA Loading
6) Tables and Graphs of Log Spiral Curves Used for Active and Passive Coefficients
Instructions For Users:
1) Go to Pile Depth. Fill in white boxes with the appropriate data using drop lists
Assumptions:
1) For use cohesionless soils
2) Ground water is lowered to the bottom of excavation
Calculation Reference
Soil Mechanics in Engineering Practice, K Terzaghi and R Peck
Earthwork Calculation Spreadsheet
Reinforced Concrete Design Excel Sheet
Reinforced Concrete Design Excel Sheet
This spreadsheet is based on the ultimate limit design method.
Content:
- Calculation of coefficients
- Design of slabs
- Design of flat slabs
- Design of beams
- Design of sections under M,N
- Check shear in beams
- Design for torsion
- Design for rectangular columns
- Design of circular columns
- Design of isolated footings
- Design of isolated footings under moment
- Design of combined footings
- Design of strap foootings
- Design of retaining walls
- Deflection of cantilivers
- Deflection of simples
Design of Stair Case with Central Stringer Beam Spreadsheet
Design of Dog-Legged Stair Excel Sheet
Bar Bending Schedule Excel Sheet
Bar Bending Schedule Excel Sheet
Bar Bending Schedule is a lite version spreadsheet and is a freeware that can be distributed freely but only in its original form.
