-

Combined Tension and Shear in a Slip Critical Connection Spreadsheet

Combined tension and shear in a slip critical connection must be considered when bolted connections subjected to both shear and tension must be checked for prying action, the interaction between tension and shear must be considered.

The AISC Specification for Structural Steel Buildings (AISC, 2010) presents interaction equations for bearing connections and for slip-critical connections. However, little guidance for applying these equations to prying action analysis has been available.

This spreadsheet will demonstrate how these interaction equations may be used in the prying action analysis presented in the 14th edition Steel Construction Manual (AISC, 2011) by comparing two methods. The Excel sheet is formulated in terms of Load and Resistance Factor Design (LRFD), but the principles are similar for Allowable Strength Design (ASD).

Download Link

Concrete Pool Design Spreadsheet Based on ACI 318-14

Concrete pool design for rebar at middle or equal of each face, is pool wall at inward soil pressure before restrained at top and pool filled. since the wall axial load small and sections under tension-controlled (aci 318-14 21.2.2), only check wall flexural capacities are adequate. since the slab at flexural & axial loads, the combined capacity of flexural & axial must be checked.

Download Link

Wind Analysis for Shade Open Structure Spreadsheet Based on ASCE 7-16

In order for a structure to be sound and secure, the foundation, roof, and walls must be strong and wind-resistant. When building a structure it is important to calculate wind load to ensure that the structure can withstand high winds, especially if the building is located in an area known for inclement weather.

The main wind force resisting system of a building is a vital component. While wind load calculations can be difficult to figure out because the wind is unpredictable, some standard calculations can give you a good idea of what a building can withstand. Wind loading analysis is an essential part of the building process.

If wind loading analysis is not done correctly the resulting effects could include collapsed windows and doors, ripped off roofing, and more. Contact Buildings Guide for quotes on safe and durable prefabricated steel buildings.

Download Link

Concrete Pier (Isolated Deep Foundation) Design Spreadsheet Based on ACI 318-14

Foundation elements are most commonly constructed of reinforced concrete. As compared to the design of concrete elements that form the superstructure of a building, additional consideration must be given to concrete foundation elements due to permanent exposure to potentially deleterious materials, less precise construction tolerances and even the possibility of unintentional mixing with soil.

Download Link

Reinforced Flat Slab Design Spreadsheet

Flat slab system is an important division of concrete floor system. A civil engineer must know all the aspects regarding the flat floor system. Here, we have tried to gather various reading materials available in the web about flat slab floor system in one place. These materials are originally located at different websites. A civil engineer should study these lectures and materials for structural engineering acumen.

A flat slab is a reinforced concrete slab supported directly by concrete columns without the

use of beams. The benefits of using flat slab construction are becoming increasingly recognized. Flat slabs without drops (thickened areas of slab around the columns to resist punching shear) can be built faster because formwork is simplified and minimized, and rapid turn-around can be achieved using a combination of early striking2 and flying systems. The overall speed of construction will then be limited by the rate at which vertical elements can be cast. Flat slab construction places no restrictions on the positioning of horizontal services and partitions and can minimize floor-to-floor heights when there is no requirement for a deep false ceiling. This can have knock-on benefits in terms of lower building height, reduced cladding costs and prefabricated services.

Download link

Water Retaining Structures Analysis and Design Spreadsheet

stimating labour requirements is one of the most important parts of estimating and costing the cost of labour. It is often more than half the cost of a job. An error in this area can be very costly to the workplace.

Labour costs depend on the time it will take to manufacture an item. To work this out, it helps to break the job down into the different steps required and then estimate the time it would take someone to complete each step.

Download Link

Steel Stair Design Based on AISC 360-10 Spreadsheet

Download Link

ClipConnTable – Beam And Connections Using Clip Angles Spreadsheet

“ClipConnTable” is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beam end connections using double clip angles either welded or bolted to the beam web, and bolted to either the column flange, column web, or girder web. The connections may be subjected to end shear reaction and/or axial load. Specifically, all applicable “limit states” for the end connection analysis pertaining to the clip angles, bolts, beam web, column flange or web, and girder web are checked. The program is presented in a “tabular” format.

This program is a workbook consisting of four (4) worksheets, described as follows:

Doc – documentation sheet
Conn Table (Welded Clips) – Clip angles welded to beam web and bolted to support
Conn Table (Bolted Clips) – Clip angles bolted to beam web and bolted to support
Conn Table (Welded or Bolted) – Clip angles either welded or bolted to beam web and bolted to support

Program Assumptions and Limitations:

1. The most critical assumption used in this program is that all beam end connections are basically “full-depth”, utilzing as many vertical rows of bolts as permitted. See first page of each worksheet for outline of other assumptions used.
2.   This program is basically a “tabular” format version of the “CLIPCONN.xls” program, and is best suited to analyze a large number of beam end connections in a very quick, efficient, and concise manner. (Note: The individual case worksheets in the “CLIPCONN.xls” program were used as “masters calculations” in the development of this program, and may be referred to for individual detailed calculations.)
3.   Once the user has inserted the required input data in cells starting at A408 through F408 and down for each of the connections to be analyzed, then the user should copy the row of cells from G62 through the end cell of the particular spreadsheet (either CI408, CV408, or EG408) and “Paste Special” the formulas on down the worksheet to match the total number of connections to be analyzed.
4.   This program follows the procedures and guidelines of the AISC 9th Edition Allowable Stress (ASD) Manual (1989) and the AISC 9th Edition Manual Vol. II – Connections (1992).
5.   This program uses the database of member dimensions and section properties from the “AISC Shapes Database”, Version 3.0 (2001) as well as the AISC 9th Edition (ASD) Manual (1989).
6.   This program assumes that the tension capacity for any “limit state” is reduced by the presence of shear. For allowable bolt tension in the presence of shear, the “interaction” (combined stresses) is handled directly by the AISC Code equations. For other “limit states” in combined stresses such as bolt bearing, gross and net shear and tension, and block shear and tension tearout, the effect of “interaction” is handled by use of the formula, P/Ra+(R/Rv)^2=1, as suggested from the following reference:
“Combined Shear and Tension Stress” – by Subhash C. Goel, AISC Journal, 3rd Qtr.-1986.
Thus, the reduction factor applied to the tension “limit state” capacity is = (1-R/Rv)^2.
where:R = actual shear end reaction; Rv = allowable shear capacity for the particular “limit state” considered
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”.)

Calculation Reference
AISC

Download Link