Reinforcing Bar Development and Splice Length Spreadsheet

Reinforcing Bar Development and Splice Length Spreadsheet



Reinforcing Bar Development and Splice Length Spreadsheet is a spreadsheet program written in MS-Excel for the purpose of determining reinforcing bar development and splice lengths. Specifically, the development lengths and splice lengths for straight bars in tension as well as compression are determined. Also, the development length for standard hook bars is determined. The provisions for development and splice lengths are included for high seismic risk applications per ACI 318M-05, Chapter 21. There is also a worksheet which contains reinforcing bar data tables. This METRIC version is based on the ACI 318M-05 Code.


LINK

Column Shortening in Tall Structures Prediction and Compensation

Column Shortening in Tall Structures Prediction and Compensation


The effects of column shortening, both elastic and inelas-
tic, take on added significance and need special considera-
tion in design and construction with increased height of
structures, Differential column shortenings are magnified
by the quest for optimum economy through use of high-
strength materials and, in some instances, the use of com-
pnsite structural systems. These, in turn, change the initial
pnsitions nf the slabs. As a consequence the partitions,
mechanical equipment, cladding, architectural finishes,
and built-in furnishings are also affected.The strains in the columns nf low as well as ultra-high-
rise buildings are similar if the stress levels are similar;
however, the overall column shortening is cumulative and
depends upon the height nf the structure. For example, in
an 80-story steel structure, the total elastic shortening nf
the columns maybe as high as 7 to 10 in, (180 to 255 mm)
due to the high design stress levels of modern high-
strength steels. 


The shortening of columns within a single story affects the
partitions, cladding, finishes, piping, and so on, since
these nonstructural elements are not intended to carry
vertical loads and are therefore not subject to shortening,
On the contrary, partitions and cladding may elongate
from moisture absorption, pipes from high temperature
of liquid contents, cladding from solar radiation, and so
on, Details for attaching these elements to the structure
must be planned so that their movement relative to the
structure will not cause distress.
The cumulative differential shortening of columns
causes the slabs to tilt with resulting rotation of parti-
tions, as shown in Fig. 2. Modern dry-wall partitions can
be detailed with sufficient flexibility along their peripher-
ies and at the vertical butt joints to permit their distortion
without visible distress

LINK

Prestressed Concrete Circular Hollow Pole/Pile Design Based on ACI 318-14 & AASHTO 17th

Prestressed Concrete Circular Hollow Pole/Pile Design Based on ACI 318-14 & AASHTO 17th



prestressed concrete circular hollow poles offer several advantages,Compared with normally reinforced concrete poles, Prestressed
poles are lighter and stronger, and they require
less reinforcing steel. The concrete is generally in compression,
so cracking is unlikely except from rough handling,
and the concrete that is used is usually of higher
strength so it can withstand the prestressing operation.
Due to the special manufacturing process, in which the
poles are spun at high speeds, they have a smoother surface
that is denser and less permeable. This lower permeability
in combination with the absence of cracks
prevents corrosion of reinforcement or prestressing
wire.


LINK

The Civil Engineering Handbook, Second Edition

The Civil Engineering Handbook, Second Edition


The second edition of the Civil Engineering Handbook has been revised and updated to provide a comprehensive reference work and resource book covering the broad spectrum of civil engineering. This book has been written with the practicing civil engineer in mind. The ideal reader will be a BS- or MSclevel engineer with a need for a single reference source to use to keep abreast of new techniques and practices as well as to review standard practices. The Handbook stresses professional applications, placing great emphasis on ready-to-use materials. It contains many formulas and tables that give immediate solutions to common questions and problems arising from practical work. It also contains a brief description of the essential elements of each subject, thus enabling the reader to understand the fundamental background of these results and to think beyond them. Traditional as well as new and innovative practices are covered.


The subdivision of each section into several chapters is made by the associate editors and is somewhat arbitrary, as the many subjects of the individual chapters are cross-linked in many ways and cannot be arranged in a definite sequence. To this end, in addition to the complete table of contents presented at the front of the book, an individual table of contents precedes each of the eight sections and gives a general outline of the scope of the subject area covered. Finally, each chapter begins with its own table of contents. The reader should look over these tables of contents to become familiar with the structure, organization, and content of the book. In this way, the book can also be used as a survey of the field of civil engineering, by the student or civil engineer, to find the topics that he or she wants to examine in depth. It can be used as an introduction to or a survey of a particular subject in the field, and the references at the end of each chapter can be consulted for more detailed studies

LINK

Wind Loads Calculations Spreadsheet According to ASCE

Wind Loads Calculations Spreadsheet According to ASCE 



A mean wind force acts on a building. This mean wind force is derived from the mean wind speed
and the fluctuating wind force produced by the fluctuating flow field. The effect of the fluctuating
wind force on the building or part thereof depends not only on the characteristics of the fluctuating
wind force but also on the size and vibration characteristics of the building or part thereof. Therefore,
in order to estimate the design wind load, it is necessary to evaluate the characteristics of fluctuating
wind forces and the dynamic characteristics of the building.
The following factors are generally considered in determining the fluctuating wind force.
1) wind turbulence (temporal and spatial fluctuation of wind)
2) vortex generation in wake of building
3) interaction between building vibration and surrounding air flow


LINK

Design of Cantilever Beam Spreadsheet

Design of Cantilever Beam Spreadsheet



This spreadsheet gives an overview of micro cantilever beam of various shapes and materials for vapour detection. The design of micro cantilever beam, analysis and simulation is done for each shape. The simulation is done using COMSOL Multiphysics software using structural mechanics and chemical module. The simulation results of applied force and resulting Eigen frequencies will be analyzed for different beam structures. The vapour analysis is done using flow cell that consists of chemical pillars in surface reactions and deposition process which consists of active layer for adsorbing the reacting species in the laminar flow through the flow cell.


LINK

Abutment and Retaining Wall Design Spreadsheet

Abutment and Retaining Wall Design Spreadsheet




Abutment and Retaining Wall Design Spreadsheet provides the analysis and design of abutment and retaining wall and get the design forces of them. you can calculate also the forces of the piles  below the abutment. the spreadsheet is very  simple and important.



LINK

Load Analysis of Building Spreadsheet

Load Analysis of Building Spreadsheet



The sheet provides load analysis of building 



LINK

Plane and Geodetic Surveying

Plane and Geodetic Surveying


More than almost any other engineering discipline, surveying is a practical, hands-on
skill. It is impossible to become an expert surveyor, or even a competent one, without
using real surveying instruments and processing real data. On the other hand, it is
undoubtedly possible to become a very useful surveyor without ever reading anything
more theoretical than the instrument manufacturers’ operating instructions.
What, then, is the purpose of this book?
A second characteristic of surveying is that it involves much higher orders of accuracy
than most other engineering disciplines. Points must often be set out to an accuracy of 5
mm with respect to other points, which may be more than 1 km away. Achieving this
level of accuracy requires not only high-quality instruments, but also a meticulous
approach to gathering and processing the necessary data. Errors and mistakes which are
minute by normal engineering standards can lead to results which are catastrophic in the
context of surveying.


Engineering works such as buildings, bridges, roads, pipelines and tunnels require very
precise dimensional control during their construction. Buildings must be vertical, long
tunnels must end at the correct place and foundations must often be constructed in
advance to accommodate prefabricated structural sections. To achieve this, surveyors are
required to determine the relative positions of fixed points to high accuracy and also to
establish physical markers at (or very close to) predetermined locations. These tasks are
achieved using networks of so-called control points; this book aims to give the civil
engineering surveyor all the necessary theoretical knowledge to set up, manage and use
such networks, for the construction and monitoring of large or small engineering works.
The tools of the engineering surveyor have changed significantly in recent years. Most
notably, GPS is now the simplest and most accurate way of finding the position of any
point on the surface of the earth or (more importantly) the relative positions of two or

more points.

LINK

Concrete Box Culvert Design Spreadsheet Based on AASHTO 17th & ACI 318-14

Concrete Box Culvert Design Spreadsheet Based on AASHTO 17th & ACI 318-14



concrete box culverts are available with spans varying from 6 to 16 feet and rises varying from 4 to 14 feet. Standard precast concrete box culverts are typically fabricated in 6 foot sections; however larger boxes are fabricated in 4 foot sections to reduce section weight. The designs utilize concrete strengths between 5 and 6 ksi and are suitable for fill heights ranging from less than 2 feet to a maximum of 25 feet. Box culverts outside of the standard size ranges must be custom designed.Each culvert size has three or four classes. Each class has specified wall and slab thicknesses, reinforcement areas, concrete strength, and fill.



LINK

Structural Mechanics Modelling and Analysis of Frames and Trusses

Structural Mechanics Modelling and Analysis of Frames and Trusses


Structural mechanics is the branch of physics that describes how different materials, which
have been shaped and joined together to structures, carry their loads. Knowledge on the modes
of action of these structures can be used in different contexts and for different purposes. The
Roman architect and engineer Vitruvius, who lived during the first century BC summarises
in the work De architectura libri decem (‘Ten books on architecture’) the art of building
with the three classical notions of firmitas, utilitas and venustas (strength, functionality and

beauty). Engineering of our time has basically the same goal. It is about utilising the knowl-
edge and practices of our time in a creative process where sustainable and efficient, functional

and expressive buildings are designed.
At an early design stage a structural engineer needs to be trained to see how to efficiently
use material and shape to provide the construction with stability, stiffness and strength. Using
simple models, structural behaviour can be evaluated and cross-section sizes estimated.


structures are presented, and tools for analysis and simulation are provided. The book has
been limited to treating trusses and frames in two and three dimensions. To demonstrate
the generality of the methodology the book also has a chapter, ‘Flows in Networks’, that
addresses other areas of applied mechanics, including thermal conduction and electrical flow.
The method used in this textbook to formulate computational models is characterised by the
use of matrices. The different quantities – load, section force, stiffness and displacement – are
separated and gathered into groups of numbers. All load values are gathered in a load matrix
and all stiffnesses in a stiffness matrix. This is one of the primary strengths of the method. With
a matrix formulation, the formulae describing the relations between quantities are compact and
easy to view. Physical mechanisms and underlying principles become clear. We begin with a

short summary of the matrix algebra and the notations that are used.

LINK

Circular Column Analysis and Design

Circular Column Analysis and Design 



Circular Column is an Excel Spreadsheet template for the design of Circular columns using BS8110. Because of its shape, all columns are considered as subjected to uniaxial bending. When it is required to consider a column with bi-axial bending, the two eccentricities can be combined to make it a column having one eccentricity moment. RoundCol can hold design information for up to 200 columns. Using a pull down combo box, the design information for any column can be retrieved, amended and re-saved for design use as and when necessary. Each Column in RoundCol can have up to 6 Loading Cases. Although the design results are displayed for one load case at a time, Circular Column checks the design for all 6 loading cases in one step. If a column fails the design checks for any of its load cases, the Fail-Code is shown indicating the failure. Detailed results for any load case can be displayed by the click of its radio button and also printed as and when required.


LINK

Reinforced Concrete Analysis and Design for Torsion Spreadsheet

Reinforced Concrete Analysis and Design for Torsion



Many structural components in bridges and buildings are subjected to significant torsional moments that are critical in design. Box girder bridges, beams in eccentrically loaded frames of multi-deck bridges, edge members in shells, and spandrel beams in buildings are typical examples of such elements. If external loads act far away from the vertical plane of bending, the beam is subjected to
twisting about its longitudinal axis, known as torsion, in addition to the shearing force and
bending moment.
Torsion on structural elements may be classified into two types; statically determinate, and
statically indeterminate.Since shear and moment usually develop simultaneously with torsion, a reasonable design
should logically account for the interaction of these forces. However, variable cracking, the
inelastic behavior of concrete, and the intricate state of stress created by the interaction of
shear, moment, and torsion make an exact analysis unfeasible.



LINK

Excel Sheet For Sieve Analysis Of Aggregate And To Calculate Fineness Modulus

Excel Sheet For Sieve Analysis Of Aggregate And To Calculate Fineness Modulus



The sieve analysis, commonly known as the gradation test, is a basic essential test for all
aggregate technicians. The sieve analysis determines the gradation (the distribution of aggregate
particles, by size, within a given sample) in order to determine compliance with design,
production control requirements, and verification specifications. The gradation data may be used
to calculate relationships between various aggregate or aggregate blends, to check compliance
with such blends, and to predict trends during production by plotting gradation curves
graphically, to name just a few uses. Used in conjunction with other tests, the sieve analysis is a
very good quality control and quality acceptance tool.


LINK

Seismic Loads for Liquid Containing Rectangular RC Tank According ACI

Seismic Loads for Liquid Containing Rectangular RC Tank According ACI



This sheet provides Seismic Loads for Liquid Containing Rectangular RC Tank According ACI.
 Liquid storage tanks generally possess lower energy-dissipating capacity
than conventional buildings. During lateral seismic excitation, tanks are
subjected to hydrodynamic forces. These two aspects are recognized by most
seismic codes on liquid storage tanks and, accordingly, provisions specify
higher seismic forces than buildings and require modeling of hydrodynamic
forces in analysis. In this paper, provisions of ten seismic codes on tanks are
reviewed and compared. This review has revealed that there are significant
differences among these codes on design seismic forces for various types of
tanks. Reasons for these differences are critically examined and the need for a
unified approach for seismic design of tanks is highlighted.


LINK

Timber Construction Manual

Timber Construction Manual


The American Institute of Timber Construction (AITC) has developed this Timber

Construction Manual for convenient reference by architects, engineers, contrac-
tors, teachers, the laminating and fabricating industry, and all others having a

need for reliable, up-to-date technical data and recommendations on engineered
timber construction. The information and the recommendations herein are based

on the most reliable technical data available and reflect the commercial prac-
tices found to be most practical. Their application results in structurally sound

construction.

The American Institute of Timber Construction, established in 1952, is a non-
profit industry association for the structural glued laminated timber industry. Its

members design, manufacture, fabricate, assemble, and erect structural timber
systems utilizing both sawn and structural glued laminated timber components.
These systems are used in homes; schools; churches; commercial and industrial

buildings; and for other structures such as bridges, towers, and marine installa-
tions. Institute membership also includes engineers, architects, building officials,

and associates from other industries related to timber construction.


This manual applies primarily to two types of wood materials—sawn lumber
and structural glued laminated timber (glulam). Sawn lumber is the product of
lumber mills and is produced from many species. Glued laminated timbers are
produced in laminating plants by adhesively bonding dry lumber, normally of
2-in. or 1-in. nominal thickness, under controlled conditions of temperature and
pressure. Members with a wide variety of sizes, shapes, and lengths can be
produced having superior strength, stiffness, and appearance. In addition, heavy
timber decking, structural panels, and round timbers are also discussed.

LINK

Stair Flight and Landing Design Spreadsheet

Stair Flight and Landing Design Spreadsheet



Stair Flight and Landing Design Spreadsheet with easy and simple method 
STAIRCASE is the structural members which provide vertical movement (circulation) between floors of the building at different vertical levels.
The stairs of RC buildings may be designed by using various materials (wood, steel, RC, etc.).
The idealization of support conditions of the stairs may not be straightforward as in other parts of the building.Therefore, a careful assumption should be made. Different assumptions may lead to different design solutions for the same staircase.
Basic Definitions: flight of step,landing, step width, step height,stair width.


LINK

Eccentric Footing Design Spreadsheet Based on ACI 318-14

Eccentric Footing Design Spreadsheet Based on ACI 318-14



Eccentric footing consists of two isolated footings connected with a structural strap or a lever. The strap connects the footing such that they behave as one unit. The strap simply acts as a connecting beam. An eccentric footing is more economical than a combined footing when the allowable soil pressure is relatively high and distance between the columns is large. A spread or wall footing that also must resist a moment in addition to the axial column load. Normally, the footing are so designed and proportioned thatthe C.G. of the superimposed load coincides with the C.G. of the base area, so that the footing is subjected to concentric loading, resulting in uniform bearing pressure. However, in some cases, it may not be possible to do so, for example, if the wall (or column) under construction is near some other property, it will not be possible to spread the footing to both the sides of the wall or column.



LINK

Manual for the design of concrete building structures to Eurocode 2

Manual for the design of concrete building structures to Eurocode 2


This Manual provides guidance on the design of reinforced and prestressed concrete building
structures. Structures designed in accordance with this Manual will normally comply with
BS EN 1992-1-1: 20041 and BS EN 1992-1-2: 20042.
It is primarily related to those carrying out hand calculations and not necessarily relevant
to computer analysis. However it is good practice that such hand analysis methods are used to
verify the output of more sophisticated methods.
The structural Eurocodes were initiated by the European Commission but are now produced by
the Comité Européen de Normalisation (CEN) which is the European standards organisation, its

members being the national standards bodies of the EU and EFTA countries, e.g. BSI.


All Eurocodes follow a common editorial style. The codes contain ‘Principles’ and
‘Application rules’. Principles are identified by the letter P following the paragraph number.
Principles are general statements and definitions for which there is no alternative, as well as,
requirements and analytical models for which no alternative is permitted unless specifically stated.
Application rules are generally recognised rules which comply with the Principles and
satisfy their requirements. Alternative rules may be used provided that compliance with the
Principles can be demonstrated, however the resulting design cannot be claimed to be wholly in
accordance with the Eurocode although it will remain in accordance with Principles.
Each Eurocode gives values with notes indicating where national choice may have to be
made. These are recorded in the National Annex for each Member State as Nationally Determined
Parameters (NDPs).

LINK

Prestressed Concrete Girder Design for Bridge Structure spreadsheet

Prestressed Concrete Girder Design for Bridge Structure spreadsheet



post tensioned simply supported prestressed concrete (PC) I-girder bridges are
widely used bridge system for short to medium span (20m to 50m) highway bridges due to its moderate self
weight, structural efficiency, ease of fabrication, low maintenance etc. In order to compete with steel bridge
systems, the design of PC I-girder Bridge system must lead to the most economical use of materials. In this
paper, cost optimization approach of a post-tensioned PC I-girder bridge system is presented. The objective is
to minimize the total cost in the design process of the bridge system considering the cost of materials, fabrication
and installation. For a particular girder span and bridge width, the design variables considered for the
cost minimization of the bridge system, are girder spacing, various cross sectional dimensions of the girder,
number of strands per tendon, number of tendons, tendons configuration, slab thickness and ordinary reinforcement
for deck slab and girder.


LINK

Construction Schedule Excel Sheet Template

Construction Schedule Excel Sheet Template



Projects in construction field always have a lot of shapes and different targets which have a specific order must be respected. Critical targets must be accomplished on its time or it will cause a delay to all targets depends on them. If you use this construction project template you will able to track all of the project targets and its progress. With this template you can list different tasks on your project and track the start and end time for activities.


LINK

Core Wall Design Spreadsheet

Core Wall Design Spreadsheet



Core wall is The central of arterial part of a multistory building that integrates functions and service needs for established occupants. Such areas are normally composed of toilet facilities, elevator banks, janitors’ closet, utilities, mechanical facilities, smoke shafts and stair. Core also known as facade envelope is a spatial element for load-bearing high-rise building system.
This spreadsheet provides the analysis and design of core wall


LINK

Excel Sheet to calculate Concrete Quantities

Excel Sheet to calculate Concrete Quantities



This excel sheet will make you able to calculate quantities for different concrete and steel structure members
with this excel sheet you will calculate quantities for sand, cement and steel for beams, footings columns, beamed slabs, flat slab, and all other structural members.

The sheet also provide tables to calculate quantities for steel structure


LINK

DESIGN AND DETAILING OF RETAINING WALLS

DESIGN AND DETAILING OF RETAINING WALLS


Design and detailing of retaining walls lecture will make student after this class be able to do the
complete design and detailing of different types of
retaining walls.
Retaining walls are usually built to hold back soil mass. However, retaining
walls can also be constructed for aesthetic landscaping purposes.
Classification of Retaining walls :
• Gravity wall-Masonry or Plain concrete
• Cantilever retaining wall-RCC
(Inverted T and L)
• Counterfort retaining wall-RCC

• Buttress wall-RCC


Behaviour or structural action and design of stem, heel and toe slabs are same as that

Design of Heel and Toe :
1. Heel slab and toe slab should also be designed as cantilever. For this
stability analysis should be performed as explained and determine
the maximum bending moments at the junction.
2. Determine the reinforcement.
3. Also check for shear at the junction.
4. Provide enough development length.
5. Provide the distribution steelof any cantilever slab.
Design of Stem :
The stem acts as a continuous slab
• Soil pressure acts as the load on the slab.
• Earth pressure varies linearly over the height
• The slab deflects away from the earth face
between the counterforts
• The bending moment in the stem is
maximum at the base and reduces towards
top.
• But the thickness of the wall is kept constant

and only the area of steel is reduced.

LINK

Slab Punching Design Excel Sheet According ACI318-08

Slab Punching Design Excel Sheet According ACI 318-08



Flat slabs that are supported directly on columns, without beams between the columns, generally transfer a significant concentrated load that affects a relatively small area. The critical element of this system is the slab to column connection because of the concentration of shear stress that is generated in the connection zone, and due to the slab punching risk. The term punching shear denotes slab failure in the zone where the concentrated load is applied, or in the support zone (column) due to shear stress.The punching shear strength is an extremely significant parameter for the design of flat slabs, i.e. the slabs supported directly on columns, without beams between columns. Slab punching design models are presented according to ACI Code


LINK