- Page 18 of 24 -

RC Element Analysis and Design Spreadsheet

The theory and techniques relative to the design and proportioning of concrete mixes, as well as the placing,
finishing, and curing of concrete, are outside the scope of this book and are adequately discussed in many other
publications . Field testing, quality control, and inspection are also adequately covered elsewhere. This is not to
imply that these are of less importance in overall concrete construction technology but only to reiterate that the objective of this book is to deal with the design and analysis of reinforced concrete members.

The design and construction of reinforced concrete buildings is controlled by the Building Code Requirements for
Structural Concrete (ACI 318-11) of the American Concrete Institute (ACI) [1]. The use of the term code in this text
refers to the ACI Code unless otherwise stipulated.

The code is revised, updated, and reissued on a 3-year cycle. The code itself has no legal status. It has been incorporated into the building codes of almost all states and municipalities throughout the United States, however. When so incorporated, it has official sanction, becomes a legal document, and is part of the law controlling reinforced concrete design and construction in a particular area.

Therefore, tensile reinforcement must be embedded in the concrete to overcome this deficiency. In the United States, this reinforcement is in the form of steel reinforcing bars or welded wire reinforcing composed of steel wire. In addition, reinforcing in the form of structural steel shapes, steel pipe, steel tubing, and high-strength steel tendons is
permitted by the ACI Code.

Download Link

Prestressed Post-Tensioned Concrete Section Spreadsheet

Prestress is defined as a method of applying pre-compression to control the stresses resulting due to external loads below the neutral axis of the beam tension developed due to external load which is more than the permissible limits of the plain concrete.

The pre-compression applied (may be axial or eccentric) will induce the compressive stress below the neutral axis or as a whole of the beam c/s. Resulting either no tension or compression.Prestressed concrete is basically concrete in which internal stresses of a suitable magnitude and distribution are introduced so that the stresses resulting from the external loads are counteracted to a desired degree.

Download Link

Development of Reinforcement Based on ACI 318-14 Spreadsheet

Development length is certain minimum length of the bar required on either side of a point of maximum steel stress, in order to transfer the bar force to surrounding concrete through bond, without slip,so as to prevent bar from pulling out under tension. This is “development length or anchorage length”. Hooks,bends, mechanical anchorages can be used to supplement.

End anchorage may be considered reliable if the bar is embedded into concrete a prescribed distance known as the “development length” of the bar. In a beam, if the actual extended length of the bar is equal or greater than this required development length, then no bond failure will occur.

If the actual available length is inadequate for full development, special anchorages ,such as hooks, must be provided to ensure adequate strength.

Methods for Determining the Development Length, ld
– The ACI allows the determination of the
development length by two methods:
• Tabular criteria (ACI Section 12.2.2).
• General equation (ACI Section 12.2.3).
– In either case, ld shall not be less than 12 in.
– The general equation of the ACI Code offers a simple approach that allows the user to see the effect of all variables controlling the development length.

A reduction in the development length ld is permitted where reinforcement is in excess of that required by analysis (except where anchorage or development for fy is specifically required or where the design includes provisions for seismic considerations).

The method for determining the development length in compression ld involves finding the the basic development length ldb and multiplying it by applicable modification factors.

Download Link

Steel Beam Design Excel Sheet with Gravity Loading

The Steel Beam module does not permit biaxial loading at the present time, so there are two potential approaches to this loading scheme:

One option is to do two separate Steel Beam runs. One run would apply the gravity loads to the beam with the beam oriented “web vertical”. The other run would apply the wind loads to the beam with the beam oriented “web horizontal”. This would require that the user manually combine the results of the two runs using engineering judgment to come up with a final result.

Download Link

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