Simple Geotechnics Calculations spreadsheet

 

Purpose of calculation: In its natural condition a soil sample has a mass of 2290g and a volume of 1.15 x 10ˉ³m³. After being completely dried in an oven the mass of the sample is 2035g. Determine the bulk density,  unit weight, water content, void ratio, porosity, degree of saturation and air content.

Calculation Reference: Craig Soil Mechanics. R.F. Craig

Calculation Validation: Check against a worked example in the reference above.

Calculation Reference
Geotechnics

 

Download Link

Soil Arching Effect for Braced Excavations Spreadsheet

 

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

 

Download Link

Column Shear Capacity spreadsheet

 

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.

 

Download Link

Steel Roof Deck spreadsheet

 

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:

• a. “Steel Roof and Floor Deck” Catalog – by Vulcraft Corporation, 2008
• b. ASTM E936 (2004) – Standard Practice for Roof System Assemblies Employing Steel Deck, Preformed Roof Insulation, and Bituminous Built-Up Roofing
• c. “Design Manual and Catalog of Steel Deck Products” – by CMC (United Steel Deck), 2008

2. This program handles Vulcraft steel roof deck of the following types/styles:

• a. 1.5A – Type A 1-1/2″ deep narrow rib
• b. 1.5B – Type B 1-1/2″ deep wide rib
• c. 1.5F – Type F 1-1/2″ deep intermediate rib
• d. 3N – Type N 3″ deep acoustical

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”.)

 

Download Link

 

Slab on metal deck analysis spreadsheet

 

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:

• “Composite Deck Design Handbook” – by R.B. Heagler, L.D. Luttrell, and W.S. Easterling and published by Steel Deck Institute (SDI), March 1997
• “Designing with Steel Form Deck” – by Steel Deck Institute (SDI), 2003
• “Steel Deck and Floor Deck” Catalog – by Vulcraft Corporation, 2001
• ACI 318-99 Building Code and Commentary – by American Concrete Institute, June 1999

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”.)

Download Link

Corbel Analysis per ACI and IBC code spreadsheet

 

“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

 

Download Link