Direct Shear Test On Sand Void Ratio Calculation Spreadsheet
Category: Excel Sheets Templates
Professional tools for calculations and dimensioning of mechanical engineering problems using Excel spreadsheets.
Rectangular Column Design and Calculation Spreadsheet
Design Of Doubly Reinforced Beam According to ACI 318-99 Spreadsheet
Simply Supported I Section Composite Beam Design Spreadsheet
Liquefaction Evaluation Spreadsheet
Liquefaction Evaluation Spreadsheet
This spreadsheet identifies possible zones of liquefaction in a soil profile. It compares the anticipated cyclic shear stresses induced by an earthquake to the esitmated cyclic strength of the soil. Zones where the induced stress is greater than the cyclic strength are deemed zones of liquefaction.
The methodology involves two distinct processes:
1. Compute the equivalent cyclic shear stress induced by an earthquake vs. depth
2. Compute the cyclic shear strength of the soil profile
Step (1) can be accomplished in many ways, however the simplest is the method developed by Seed and Idriss (1971) where induced stresses are determined by earthquake magnitudes and depth of the soil deposit. Other methods include field correlations by authors on site-specific earthquakes, or 1-D wave propagation analysis by computer (Shake, MocEQ1).
Step (2) is most-easily done by correlating cyclic strength to corrected SPT blow count. Alternatively, CPT data, laboratory data, and other measures of soil cyclic strength can be used.
Geogrid Bridge Calculation Spreadsheet
Ponding Analysis For Low Slope Or Flat Roof Systems Spreadsheet
Ponding Analysis For Low Slope Or Flat Roof Systems Spreadsheet
“Ponding Analysis For Low Slope Or Flat Roof Systems” 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
