Aluminium design capacity spreadsheet will help you design structural and architectural pipe on your building construction whether it is residential, commercial & plant projects. It optimizes the pipe design so that designer can attain the effective, efficient, safe and economical sizes of aluminum pipe.
Calculation Reference
Strength of Aluminium
Analysis and design of RC beam as per ACI318-08.
Calculation Reference
Reinforced Concrete
AASHTO 2004 LRFD SLAB DESIGN: This spreadsheet was created to aid in the rapid design and/or checking of Bridge Decks or Reinforced Concrete Boxes in accordance with AASHTO 2004 LRFD. The 2nd Bar layer is particularly handy for different bar sizes used in the same layer, such as in Bridge Deck Cantilevers.
Calculation Reference
AASHTO LRFD
Drilling is typically performed using rotary drilling techniques and an external water flush with special drill rods and bits. Upon completion of the advancement of the drill rods to the design depth, the jet grouting process commences. The grout is injected through radial nozzles at high pressure and velocity, destroying the soil matrix and forming structural elements.
Many structures and geometries can be achieved by altering the parameters of the jetting procedure. The illustrated procedure details the creation of a jet grout column by continuous rotation of the drill string and controlled pre-set lifting increments.
Calculation Reference
Jet Grouting
Read More : What is Jet Grouting? Common Uses and Advantages
Retaining walls must be reinforced in order to be effective. Too many forces are at work against a retaining wall that could cause it to tumble over if it is not reinforced correctly.
Calculation Reference
Reinforced Concrete
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
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”.)
