Design of Cantilever Slab Spreadsheet

Design of Cantilever Slab Spreadsheet

Cantilever slabs are a typical one way slabs. They are projections from wall face of lintel beams or floor slabs. Even while designing they are considered as one-slabs with cantilever fixed or continuous at supports. The trial depth is selected based on span/depth ratio of 7, as in IS:456. The reinforcement provided at the tension face should be checked for anchorage length near supports. The thickness of such slabs is varied from max. at the fixed end to the min. of 100 to 150 mm at the free end. Distribution steel should be provided at the transverse direction. Proper selection of depth and detailing of reinforcements will safeguard against excessive deflections and cracking of the cantilever slabs. Also, cantilever structural elements should be checked for safety against overturning.

LINK

Pile Group Analysis Spreadsheet

Pile Group Analysis Spreadsheet

Pile group analysis spreadsheet program written in MS-Excel for the purpose of analysis of pile groups with rigid caps using the "elastic method". Specifically, the properties of the pile group are calculated, and then based upon the applied vertical and horizontal loadings, the vertical and horizontal pile reactions are calculated. There is also a worksheet to check beam and punching shear in the pile cap for a single corner pile, for the purpose of estimating the required pile cap thickness and subsequent pile cap weight.

LINK

Composite Beam Design with Verco Floor Deck Spreadsheet

Composite Beam Design with Verco Floor Deck Spreadsheet

Composite Beam Design with Verco Floor Deck Spreadsheet provides the analysis and design of composite beams. The input studs spacing must be based on actual deck ribs spacing for perpendicular to beam.

LINK

BOUNDARY ELEMENTS Theory and Applications

BOUNDARY ELEMENTS Theory and Applications

The last three decades have been marked by the evolution of electronic computers
and an enormous and wide-spread availability of computational power. This has

boosted the development of computational methods and their application in engi-
neering and in the analysis and design of structures, which extend from bridges to

aircrafts and from machine elements to tunnels and the human body. New scientific

subfields were generated in all engineering disciplines being described as "Compu-
tational", e.g. Computational Mechanics, Computational Fluid Mechanics, Com-
putational Structural Analysis, Computational Structural Dynamics etc. The Finite

Element Method (FEM) and the Boundary Element Method (BEM) are the most
popular of the computational methods. While the FEM has been long established
and is most well known in the engineering community, the BEM appeared later
offering new computational capabilities with its effectiveness, accuracy and low
computational cost.

Although the BEM is taught as a regular course at an ever increasing number of
universities, there is a noticeable lack of a textbook which could help students as
well as professional engineers to understand the method, the underlying theory and
its application to engineering problems. An essential reason is that BEM courses

are taught mainly as advanced graduate courses, and therefore much of the under-
lying fundamental knowledge of mathematics and mechanics is not covered in the

respective undergraduate courses. Thus, the existing books on BEM are addressed
rather to academia and researchers who, somehow, have already been exposed to
the BEM than to students following a BEM course for the first time and engineers
who are using boundary element software in industry.

LINK

Project Analysis for Business Consulting Firms Company Confidential Template

Project Analysis for Business Consulting Firms Company Confidential Template

Project Analysis for Business Consulting Firms Company Confidential Leads efforts for developers or testing professionals to enhance and create products Full lifecycle project management- including all core aspects required to successfully plan, forecast, manage and execute, reporting to key stakeholders as needed Lead enhancement projects of various levels of complexity in a project manager role, including creation of project schedule and risk management tasks

LINK

Design of Precast Prestressed Composite Beams Excel Sheet

Design of Precast Prestressed Composite Beams Excel Sheet

The precast prestressed concrete units are erected first and can be used to support the formwork needed for the cast in situ slab without additional scaffolding (or shoring). In addition to its contribution to the strength and stiffness of the composite member, the cast in situ slab provides an effective means to distribute loads in the lateral direction. The cast in situ slab can be poured continuously over the supports of precast units placed in series, thus providing continuity to a simple span system.Pre-tensioning in plant is more cost-effective than post-tensioning on site. Because the precast 4 prestressed concrete element is factory-produced and contains the bulk of reinforcement, rigorous quality control and higher mechanical properties can be achieved at relatively low cost. The cast in situ concrete slab does not need to have high mechanical properties and thus is suitable to field conditions.

LINK

RC Shear Wall Analysis and Design Excel sheet

RC Shear Wall Analysis and Design Excel sheet 

RC shear wall analysis and design excel sheet easy to use yet innovative construction spreadsheet is used to make the design of shear walls subject to wind and dead load combination. This shear wall design spreadsheet is very useful verifying constancy toward reinforced concrete structure.

 It takes huge time while measuring & then remeasuring wall stiffnesses, direct and torsional rotation component of force to then estimate reinforcement and concrete stresses for a single wall successively. This shear wall design spreadsheet can significantly decrease your design time.

 Presently, the sheet does not support the earlier version of excel like Excel 2003 and so on as these do not make out iferror function.

 This estimating spreadsheet contains the following exclusive characteristics :-

 An apparent and simplified output (all on a single page);
Design Reinforced Concrete walls subject to dead and wind load combination;
Enter highest and least safety factors for Dead Load toward most troublesome load combination;
Identify superstructure and substructure height. Wind load can be assigned to above ground part of structure;
 Identify length of wall ends obstructing tension;
Designs horizontal and vertical reinforcement;
Verify least/highest acceptable reinforcement areas;
'Live' wall diagram;
Design is created on the basis of British Standard

LINK

Planning and Schedule Free Templates

Planning and Schedule Free Templates

Planning and schedule free templates.Download more than 150 free planning and schedule template. The templates contain Project planner Controls & Planning Management Plan Short Form v4 Controls & Planning Start Up Meeting Excel Time Schedule Template Project team communication plan Project time performance tracking Product or service cost tracker automatic time Schedule and cash flow Small business cash flow projection 12 month cash flow statement Statement of cash flows 12 month profit and loss projection 30 Chart Templates - Excel 2010 Procurement analysis worksheet Project performance tracking and reporting 2005 calendar on multiple worksheets Supplier analysis scorecard Weekly time sheet by client and project Weekly time sheet with tasks and overtime Weekly time sheet with breaks and more templates 

LINK

Analysis of Concrete Slabs on Grade Spreadsheet

Analysis of Concrete Slabs on Grade Spreadsheet

Analysis of concrete slabs on grade is a spreadsheet program written in MS-Excel for the purpose of analysis of concrete slabs on grade. Specifically, a concrete slab on grade may be subjected to concentrated post or wheel loading. Then for the given parameters, the slab flexural, bearing, and shear stresses are checked, the estimated crack width is determined, the minimum required distribution reinforcing is determined, and the bearing stress on the dowels at construction joints is checked. Also, design charts from the Portland Cement Association (PCA) are included to provide an additional method for determining/checking required slab thickness for flexure. The ability to analyze the capacity of a slab on grade subjected to continuous wall (line-type) load as well as stationary, uniformly distributed live loads is also provided. Loading data for fork trucks and AASHTO trucks is included.

LINK

Pre-Dimensioning of Beams and Columns Excel Sheet

Pre-Dimensioning of Beams and Columns Excel Sheet

Pre-Dimensioning of beams and columns excel sheet conduct a preliminary calculation for centric loaded columns. For columns with bending components and other geometric boundary conditions, please contact our Technical Department.In the case of reinforced concrete, structural elements preliminary design stage has a high importance due to the contribution to the dead loads (the weight of the sectional elements) and to the total mass of the construction. Pre-dimensioning depends on various conditions such as stiffness (admissible deflection), ductility (proper sizing of structural elements so as to create areas with sufficient seismic energy dissipation capacity of deformation in post-elastic domain.

LINK

Capacity Calculations of Structural Members Excel Sheet

Capacity Calculations of Structural Members Excel Sheet

Capacity Calculations of Structural Members Excel Sheet calculate the capacity of different structural members such as beams modules , Columns, Foundations and Slabs.The excel sheet also allow you to design the required reinforcement area and a spacing of reinforcing bars within the cross-section of a concrete structure element. The RC Member Design module allows you to obtain a theoretical (required) area of reinforcement for selected concrete members.

LINK

THE ANALYSIS OF STRESS AND DEFORMATION

THE ANALYSIS OF STRESS AND DEFORMATION

This book was prepared for a course in the mechanics of deformable
bodies at the authors' institution, and is at a level suitable for advanced
undergraduate or first-year graduate students. It differs from the traditional
treatment by going more deeply into the fundamentals and giving less emphasis
to the design aspects of the subject. In the first two chapters the principles
of stress and strain are presented and a sufficient introduction is given to the
theory of elasticity so that the student can see how exact solutions of problems
can be derived, and can appreciate the nature of the approximations embodied
in some commonly used simplified solutions. The third chapter is devoted to
the bending of beams, and the fourth chapter treats the instability of elastic
systems.

Applications to axially symmetric problems, curved beams, and stress
concentrations are discussed in Chapter 5; applications to torsion problems
are discussed in Chapter 6; applications to problems of plates and shells are
discussed in Chapter 7. Applications to problems involving viscous and plastic
behavior are treated in Chapter 8, and problems of wave propagation are
treated in Chapter 9. An introduction to numerical methods of solving
problems is given in Chapter 10. An introduction to tensor notation by means
of the equations of elasticity is given in Appendix I. Experimental methods of
determining stresses by means of strain gages, brittle coatings, and photoelasticity
are described in Appendices I1 and 111. A brief introduction to
variational methods is presented in Appendix IV.

LINK

Computational Methods for Reinforced Concrete Structures

Computational Methods for Reinforced Concrete Structures

“There are no exact answers. Just bad ones, good ones and better ones. Engineering is the
art of approximation.” Approximation is performed with models. We consider a reality of
interest, e.g., a concrete beam. In a first view, it has properties such as dimensions, color,
surface texture. From a view of structural analysis the latter ones are irrelevant. A more
detailed inspection reveals a lot of more properties: composition, weight, strength, stiffness,
temperatures, conductivities, capacities, and so on. From a structural point of view some
of them are essential. We combine those essential properties to form a conceptual model.
Whether a property is essential is obvious for some, but the valuation of others might be
doubtful. We have to choose. By choosing properties our model becomes approximate
compared to reality. Approximations are more or less accurate.
On one hand, we should reduce the number of properties of a model. Any reduction of
properties will make a model less accurate. Nevertheless, it might remain a good model. On
the other hand, an over-reduction of properties will make a model inaccurate and therefore
useless. Maybe also properties are introduced which have no counterparts in the reality of
interest. Conceptual modeling is the art of choosing properties. As all other arts it cannot
be performed guided by strict rules.

A numerical model needs some completion as it has to be described by means of programming
to form a computational model. Finally, programs yield solutions through processing
by computers. The whole cycle is shown in Fig. 1.1. Sometimes it is appropriate to merge
the sophisticated sequence of models into the model.
A final solution provided after computer processing is approximate compared to the
exact solution of the underlying mathematical model. This is caused by discretization and
round-off errors. Let us assume that we can minimize this mathematical approximation
error in some sense and consider the final solution as a model solution. Nevertheless, the
relation between the model solution and the underlying reality of interest is basically an
issue. Both – model and reality of interest – share the same properties by definition or
conceptual modeling, respectively. Let us also assume that the real data of properties can
be objectively determined, e.g., by measurements.

LINK

Excel Sheet to Design RC Column for Axial load According ACI

Excel Sheet to Design RC Column for Axial load According ACI

Design of columns are carried over a group of columns having a low variation of design values. In this group, design is carried for the highest values of axial force, moments about Y and Z directions, shear about Y and Z directions as well as torsion. However, it is a common practice among designers to ignore shear and torsion in columns. This practice will reduce safety factor in columns which are critical structural members responsible for the safety of the structure.

LINK

Combined Rectangular Pilecap Design Excel Sheet

Combined Rectangular Pilecap Design Excel Sheet

PILE CAP:- A reinforced concrete slab or block which interconnects a group of piles and acts as a medium to transmit the load from wall or column to the Piles is called a Pile Cap. The Pile cap should normally be rigid so as to distribute the forces equally on the piles of a group. In general it is designed like a footing on soil but with the difference that instead of uniform reaction from the soil, the reactions in this case are concentrated either point loads or distributed.
ASSUMPTIONS INVOLVED IN THE DESIGN OF PILE CAPS:-
 (i) Pile cap is perfectly rigid.
 (ii) Pile heads are hinged to the pile cap and hence no bending moment is transmitted to piles from pile caps. 
(iii) Since the piles are short and elastic columns, the deformations and stress distribution are planer

LINK

Reinforced Concrete Element Design Spreadsheet

Reinforced Concrete Element Design Spreadsheet

A structure refers to a system of connected parts used to support forces (loads). Buildings,
bridges and towers are examples for structures in civil engineering. In buildings, structure
consists of walls floors, roofs and foundation. In bridges, the structure consists of deck,
supporting systems and foundations. In towers the structure consists of vertical, horizontal and
diagonal members along with foundation.
A structure can be broadly classified as (i) sub structure and (ii) super structure. The portion of
building below ground level is known as sub-structure and portion above the ground is called as
super structure. Foundation is sub structure and plinth, walls, columns, floor slabs with or
without beams, stairs, roof slabs with or without beams etc are super structure.

LINK

Prestressed Post-Tensioned Concrete Section

Prestressed Post-Tensioned Concrete Section

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.

LINK

Concrete Creep, Shrinkage Factors and Tensile Strength Calculation

Concrete Creep, Shrinkage Factors and Tensile Strength Calculation

This spreadsheet provides values of creep factors, concrete tensile strengths and free shrinkage strains for use with finite element slab design programs that take account of concrete cracking (non-linear analysis). The methods used are those recommended in Concrete Society Technical Report No TR58. With programs that do not account for cracking, substantially higher creep factors should be employed, to allow for the increased displacements caused by cracking and shrinkage.If each stage is analysed with its' own φ factor and fctm, then ζ and fctm for the critical load case should be used at subsequent stages. If the calculation method employed does not do this, say NO at cell J14. For slabs with nominal or low restraint use fctmfl, and for severe restraint use fctm. An intermediate value may be used.

LINK

The Art of Construction Projects and Principles for Beginning Engineers Architects

The Art of Construction Projects and Principles for Beginning Engineers Architects

THE LAWS GOVERNING the construction of structures do not change with the passing
of years or centuries; they are basic laws of nature. Yet I find it necessary to add a preface
to this third edition of my book because of the experience I have acquired over the last
fifteen years in the schools of New York City and other parts of the United States.
After teaching architectural structures at Princeton and Columbia Universities for many
years, I introduced in 1975 a special school program to excite greater interest in
mathematics and science in young students. Many thousands of youngsters in junior high
and high schools have been exposed to the program since then, and the study of
architecture and structure has attracted them to subjects they previously considered
obnoxious. Our program has stimulated them to stay in school and to perform well in a
wide range of subjects. The Art of Construction is one of the tools we use to present our
program to grade school students. I feel it is worthwhile for parents and teachers to realize
that a simple book on architecture may help solve one of the problems that concerns
educators all over the country.

The Art of Construction was written for youngsters, it
seems to be of great interest to older “youngsters” as well, among them some of the
architects I serve as a professional structural engineer. The third edition of this book has
been brought up to date on the few data that have changed with time and may be read as
an original work.

LINK

Daily and Weekly Inspection Report Template

Excel Construction Project Management Template

Daily and weekly inspection report is important to regularly check in the progress of your construction project. Scheduling a weekly project status meeting is helpful, but visiting the job site on a daily or weekly basis is key to visually inspect progress, keep a documented history of the work and identify risk. When making site visits, use this inspection report template to record the amount of hours worked, materials and equipment used and progress made.

LINK

Wind Analysis for Trussed Tower Based on ASCE 7-16

Wind Analysis for Trussed Tower Based on ASCE 7-16

Wind analysis for trussed tower sheet examines structural forces present in a four-sided truss tower modeled as a support system for a wind turbine. Case I examined only forces due to the weight of the nacelle and rotor, while Case II also incorporated lateral wind force. All forces were idealized as concentrated forces and theoretic analysis was completed using static equilibrium concepts and truss/frame analysis techniques. A PASCO Structure kit was used to construct a model and validate theoretical findings. Weights were applied to the model and the resulting axial forces were measured using load cells. Experimental data concurred with the theoretical analysis within the measured uncertainty, indicating the tower was accurately analyzed as a frame/truss structure.
Main Wind Force Resisting System
• Elements of the structure which are essential to keeping
the entire structure from collapsing due to wind.
Components and Cladding
• Elements (Structural or Non-Structural) which transmit
wind forces to the Main Wind Force Resisting System.

• Not essential for overall structural stability

LINK

Euro Steel Beam Load and Rest on Bottom Flange

Euro Steel Beam Load and Rest on Bottom Flange

When a beam is subjected to major axis bending, i.e. bending about the y-axis, it will
deflect in the z-direction. This type of bending is sometimes referred to as bending
about the strong axis. Analogous, minor axis bending is when a beam is bent about
the z-axis, deflecting in the y-direction. This is sometimes called lateral bending or
bending about the weak axis.A beam element can be considered to have seven degrees of freedom in each node.
These are translation in x-, y-, and z-direction, rotation about x-, y-, and z-axis and
warping.

LINK

Flexural Design of Singly Reinforced Section According to ACI 318-02

Flexural Design of Singly Reinforced Section According to ACI 318-02

Flexural Design of Singly Reinforced Section is slender members that deform primarily by bending moments caused by concentrated couples or transverse forces. In modern construction, these members may be joists, beams, girders, spandrels, lintels, and other specially named elements. But their behavior in every case is essentially the same. Unless otherwise specified in a problem, flexural members will be referred to as beams here. In the following sections, the ACI 318 provisions for the strength, ductility, serviceability, and constructability of beams are summarized and illustrated.

LINK

Design of Composite Beam Column Excel Sheet

Design of Composite Beam Column Excel Sheet

The presence of floor systems rigidly connected to the beams
of unbraced steel frames has long been known to increase the stiffness
of such frames. A recent investigation into the behavior of an actual
unbraced steel frame with composite precast concrete floor panels did show
that such was the case. It was therefore expected that the floor systems
would have the same effect on the maximum strength of unbraced steel frames.
When an unbraced frame is subjected to lateral loads the
columns apply end moments to the beams at the beam-to-column connections.

LINK

Complete Water Supply Treatment Plant Design Excel Sheet

Complete Water Supply Treatment Plant Design Excel Sheet

Three basic purpose of Water Treatment Plant are as follows:
 To produce water that is safe for human consumption.
 To produce water that is appealing to the consumer.
 To produce water using facilities which can be constructed and
operated at a reasonable cost.
Production of biologically and chemically safe water is the primary goal
in the design of water treatment plants; anything less is unacceptable.
The second basic objective of water treatment is the production of water
that is appealing to the consumer. Ideally, appealing water is one that is clear
and colorless, pleasant to the taste, odorless, and cool. It is none staining,
neither corrosive nor scale forming, and reasonably soft.

Complete Water Supply Treatment Plant Design Excel Sheet :
Calculation of Water Demand
Physical & Chemical Standards Of Water
Comparison of Given Data & Standard Data and Treatment Proposed
Design of Intake Well
Design of Pen Stock & Bell Mouth Strainer
Design of Gravity Main
Design of Jack Well
Design Of Pumping System
Design of Rising Main
Treatment Units - Design Of Aeration Unit
Design Of Chemical House & Calculation Of Chemical Dose
Lime - Soda Process
Design Criteria for Mechanical Rapid Mix Unit
Design Of Clariflocculator
Design Of Rapid Gravity Filter

LINK

Worked Example to Eurocode 2

Worked Example to Eurocode 2

Eurocodes are one of the most advanced suite of structural codes in the world. They
embody the collective experience and knowledge of whole of Europe. They are born
out of an ambitious programme initiated by the European Union. With a wealth of
code writing experience in Europe, it was possible to approach the task in a rational
and logical manner. Eurocodes reflect the results of research in material technology
and structural behaviour in the last fifty years and they incorporate all modern trends
in structural design.

For writing a Eurocode, like EC-2, another important condition applies. International
consensus had to be reached, but not on the cost of significant concessions with regard to
quality. A lot of effort was invested to achieve all those goals.
It is a rule for every project, that it should not be considered as finalized if
implementation has not been taken care of. This book may, further to courses and
trainings on a national and international level, serve as an essential and valuable
contribution to this implementation. It contains extensive background information on the
recommendations and rules found in EC2. It is important that this background
information is well documented and practically available, as such increasing the
transparency. I would like to thank my colleagues of the Project Team, especially Robin
Whittle, Bo Westerberg, Hugo Corres and Konrad Zilch, for helping in getting together
all background information. Also my colleague Giuseppe Mancini and his Italian team
are gratefully acknowledged for providing a set of very illustrative and practical working
examples. Finally I would like to thank CEMBURAU, BIBM, EFCA and ERMCO for
their initiative, support and advice to bring out this publication.

LINK