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

345 Solved Seismic Design Problems preference

345 Solved Seismic Design Problems preference


This book introduces you to the seismic exam and tells you how to use 345 Solved Seismic Design Problem. It also explains how to relate this book to reference materials, such as the California Building Code, Seismic Design of Building Structure, and others. Using this book as a study guide, you will be surprised to discover how effectively you can learn seismic principles and fundamental earthquake engineering of structure to successfully pass the special seismic exam.
This book gives you the opportunity to work problems of the same format and difficulty as those on the seismic portion of the California Special Civil Engineer exam. Every problem is fully solved.


Content:
Seismology principles, Earthquake Characteristics, and basiic structural dynamics.
Codes and regulatory provisions 
Diaphragm theory 
Details of structure 
Design problems 
A. useful conversion factors
B. reference and suggested reading

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

Reinforced concrete design with FRP composites

Reinforced concrete design with FRP composites


Fiber reinforced polymer (FRP) composites (the combination of two or more mate-
rials) have emerged as an evolutionary link in the development of new materials

from conventional materials. Used more often in the defense and aerospace indus-
tries, advanced composites are beginning to play the role of conventional materials

(commodities) used for load-bearing structural components for infrastructure appli-
cations. These unique materials are now being used worldwide for building new

structures as well as for rehabilitating in-service structures. Application of compos-
ites in infrastructural systems on a high-volume basis has come about as a result of

the many desirable characteristics of composites that are superior to those of con-
ventional materials such as steel, concrete, and wood.

The increased use of composites in thousands of applications — domestic,
industrial, commercial, medical, defense, and construction — has created a need for
knowledgeable professionals as well as specific literature dedicated to advancing
the theory and design of composites to provide a compendium of engineering
principles for structural applications in general and concrete structures in particular.



This book, Reinforced Concrete Design with FRP Composites, presents readers

with specific information needed for designing concrete structures with FRP rein-
forcement as a substitute for steel reinforcement and for using FRP fabrics to

strengthen concrete members. Separate chapters have been provided that discuss both

of these topics exhaustively, supplemented with many practical examples and fun-
damental theories of concrete member behavior under different loading conditions.

This book is self-contained in that it presents information needed for using FRP
composites along with concrete as a building material. It has been written as a
design-oriented text and presents in a simple manner the analysis, design, durability,

and serviceability of concrete members reinforced with FRP. Mechanics of compos-
ites and associated analysis involving differential equations have been intentionally

omitted from this book to keep it simple and easy to follow.

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

Steel Construction Manual

Steel Construction Manual


This Manual is the 14th major update of the AISC Steel Construction Manual, which was first published in 1927. The 14th edition, released in 2011, contains several updates and revisions from the 13th edtion, including the new HP18 and HP16 series, updated connection tables based on increased bolt shear strength values, revised single-plate and extended single-plate connection design procedures, enhanced prying action procedure, and a revised bracket plate design procedure. The most current printing of this publication is the fourth printing.

The following specifications, codes and standards are printed in Part 16 of this Manual:

2010 Specification for Structural Steel Buildings, including the new Chapter N on QC and QA, expanded composite design provisions, and improved slip-critical connection provisions
2009 RCSC Specification for Structural Joints Using High-Strength Bolts
2010 Code of Standard Practice for Steel Buildings and Bridges


Section 1.1 Introduction Last Revised: 11/04/2014 Structural steel is one of the basic materials used by structural engineers. Steel, as a structural material has exceptional strength, stiffness, and ductility properties. As a result of these properties, steel is readily produced in a extensive variety of structural shapes to satisfy a wide range of application needs. The wide spread use of structural steel makes it necessary for structural engineers to be well versed in its properties and uses. The structural steel industry in the United States is represented principally by the American Society of Steel Construction (AISC). AISC works tirelessly to advance the science and art associated with producing, designing, fabricating, and erecting structural steel. One of their many available resources is the AISC Steel Construction Manual (SCM). This course focuses on training the engineering student to apply the basic design specifications contained in the SCM. In addition, the student will become familiar with many of the design aids contained in the SCM. In order for a student to progress through the material presented in this course, it is essential that they are well versed in engineering statics, mechanics, properties of materials, and structural analysis.

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

Highway Bridge Superstructure Engineering LRFD Approaches to Design and Analysis

Highway Bridge Superstructure Engineering LRFD Approaches to Design and Analysis

This book is intended to serve as a source of the state-of-the-art knowledge pertaining to design
and analysis of highway bridge superstructures conforming to AASHTO-LRFD Specifications for
Design of Highway Bridges. The discussion presented herein focuses on the load and resistance
design philosophy conforming to AASHTO LRFD Bridge Design Specifications. A fairly detailed
account of the historical development and design of highway bridges conforming to AASHTO
Standard Specifications for Highway Bridges, now archived, can be found in the author’s 1998
book, Design of Modern Highway Bridges (McGraw-Hill, 1998); that topic is not discussed herein.
This book has been designed to serve both as a stand-alone text for a first course in design of
highway bridge superstructures and a handy reference for educators and practicing engineers. This

is essentially a how to do book and has code-connected design focus. A fair amount of undergradu-
ate-level knowledge of structural loads and analyses and exposure to first courses in design of steel

and concrete structures are essential for a quick grasp of the material presented herein. Because of
the simplicity in style and format, this book can be used as a tool for teaching highway bridge design
courses for both undergraduate- and graduate-level classes.


An important reason for the simple formatting of the book is to fill the need of the times. In
many civil engineering curricula, highway bridge design course is offered to a class that comprises
both graduate- and senior-level students (the author has taught such classes); the latter quite often
possess neither the same level of prerequisite knowledge nor the depth of engineering maturity as
the former. As such, the format and style of this book, along with many fully solved examples, have
been designed to fill that need. Both students as well as design engineers will find this book as an
excellent learning resource and a practical guide for engineering practice.

Presented in this book is a detailed discussion, with design examples, of concrete (both rein-
forced and prestressed) and steel bridge superstructures commonly used for bridges in the short

span range. Wood superstructures are not covered in this book as they are built rather infrequently
and have limited practical applications.

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