Soil Arching Effect for Braced Excavations Spreadsheet will calculate the horizontal earth pressure exerted on a braced excavation using Soil Arching Theory as proposed by Richard L. Handy (1985).
Calculation Reference
Soil Mechanics
Column shear capacity spreadsheet calculates shear capacity and confinement reinforcement of circular and oblong shape reinforced concrete columns in compliance with seismic provisions of AASHTO 17th edition and and AASHTO LRFD.
The spreadsheet design is based on interpretation of design methodology. As much as the authors have tried to achieve an accurate product, the codes rely upon interpretation as well as decisions drawn from engineering judgment. There are no guarantees or express warranties implied in the use or output of these programs that assures accuracy other than the efforts of the programmers’ intent to achieve perfection.
Steel Roof Deck is a spreadsheet program written in MS-Excel for the purpose of analysis and design of roofs with steel deck. Specifically, roof decks subjected to gravity loading (dead + live or snow) and wind uplift loading can be analyzed using either ASD or LRFD methods. Bending stresses as well as deflections are checked. Roof decks can be analyzed for either 1-span, 2-span, or 3-span configurations.
Program Assumptions and Limitations:
1. This program is based on the following references:
2. This program handles Vulcraft steel roof deck of the following types/styles:
3. While the user can quickly and easily make a roof deck selection based on gravity loads directly from the Vulcraft catalog, the “Roof Deck DL+LL (ASD)” and “Roof Deck DL+LL (LRFD)” worksheets provide the user with the ability to demonstrate the selection and analysis with actual calculations if desired or required.
4. In most deck vendor catalogs, only the deck moment of inertia for positive bending, “Ip”, is used for deflection calculations. However, in the “Roof Deck DL+LL (ASD)” and “Roof Deck DL+LL (LRFD)” worksheets, the value of “Ip” is used only for a single-span conditions. For multispan conditions, these two worksheets use the average value, I(avg) = (Ip+In)/2, for deflection calculations as noted on page 4 of Reference 1c above.
5. In the “Roof Deck Wind Uplift (ASD)” and “Roof Deck Wind Uplift (LRFD)” worksheets, roof uplift wind pressures for roof zones 1, 2, and 3 can be derived from the applicable ASCE 7 Standard when meeting the provisions of Factory Mutual Global is not required. When meeting the provisions of Factory Mutual Global is required, roof uplift wind ratings for roof zones 1, 2, and 3 can be derived from FMG Data Sheet 1-28: “Wind Design” (Reference 1c above).
6. For components and cladding (roof deck, fasteners, and above deck components), FMG 1-28 requires that the effective area be set = 10 ft.^2 along with an Importance Factor = 1.15. For secondary supporting members (purlins or joists) per FMG 1-28 Section 2.2.3, refer to applicable ASCE 7 Standard and apply the appropriate effective tributary area along with an Importance Factor = 1.15.
7. 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”.)
Slab on metal deck analysis is a spreadsheet program written in MS-Excel for the purpose of analysis and design of slabs on metal deck. Both composite deck slabs and form deck slabs can be analyzed and designed for 3 different loading conditions.
Specifically, the flexural moment capacity for both positive and negative strong axis moments, one-way beam shear, punching shear, and deflection are all evaluated and checked. Also, for concentrated loads, the effective slab strip widths for both moment and beam shear are determined. There is information on the metal deck properties, as well as reinforcing bar and welded wire fabric data tables.
Program Assumptions and Limitations:
1. This program is based on the following references:
2. In the “Composite Deck” worksheet, since the composite deck is interlocked or engaged with the concrete, the deck is assumed to function as the positive moment, bottom face slab reinforcing. The shear capacity of the composite deck alone is added to the beam shear capacity of the concrete to arrive at the total beam shear capacity of the slab.
3. In the two form deck worksheets, the form deck is assumed to be “inverted” and not to contribute to the flexural moment capacity of the slab. The user has the option to include or not include the form deck shear capacity in the total beam shear capacity of the slab.
4. In the “Composite Deck” worksheet, the user may select anyone of 5 available sizes (profiles), 1.5″x6″, 1.5″x6″(Inv), 1.5″x12″, 2″x12″, and 3″x12″.
5. In the two form deck worksheets, the user may select anyone of 3 available sizes (profiles), 1.5″x6″, 2″x12″, and 3″x12″.
6. In the “Composite Deck” and the two form deck worksheets, the user may select either a 1-span, 2-span, or 3-span condition for analysis.
7. In the “Form Deck (1-layer Reinf.)” worksheet, the reinforcing parallel to the slab span length functions as both the positive moment (between slab supports) reinforcing and the negative moment (at slab supports) reinforcing. When welded-wire fabric (WWF) reinforcing is used, this program does not allow the user to consider “draping” the reinforcing to maximize the positive and negative moment capacities.
8. In the “Form Deck (2-layers Reinf.)” worksheet, the bottom layer of reinforcing parallel to the slab span length functions as the positive moment (between slab supports) reinforcing, while the top layer of reinforcing parallel to the slab span length functions as the negative moment (at slab supports) reinforcing for the 2-span and 3-span conditions. Both positive and negative moment capacities are based on assuming a “singly-reinforced” slab section.
9. 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”.)
“CORBEL” is a spreadsheet program written in MS-Excel for the purpose of analysis of a concrete corbel or bracket supporting a loading plate per ACI 318-05. The spreadsheet is protected but with no password required. Revision 1.1 – Added development length and fixed minor errors.
Calculation Reference
ACI 318-05
Calculation Reference
Concrete Beam Design CSA A23
This excel sheet enables composite column calculations of circular section according to Eurocode.
Calculation Reference
Eurocode
A simple calculator for assessing structural components of timber structures to Australian timber structures code AS1720.
Contiguous piling is a highly effective method of creating a retaining wall before excavations even begin. An ideal solution for earth retention where existing structures are close to site boundaries and excavations where ground water is present, piled walls create a temporary or permanent retaining structure enabling safe excavation to take place after installation of the piles. This download will help you design them.
For evaluating net allowable bearing capacity of shallow foundations on granular soils based on 2006 International Building Code:
Calculation Reference
2006 International Building Code
