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

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

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

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

Concrete Mix Design Excel Sheet

Concrete Mix Design Excel Sheet

Concrete mix design excel sheet calculate mix ratio of concrete component to get the required strength. The sheet calculate the percent of water, cement, fine aggregate ( mainly sand), and coarse aggregate . So by the consequences of the mix design, ratio of these things are obtain to get expected concrete strength. And then present those amount as a ratio. This mix design excel sheet is according to ACI design code.

LINK

Combined Tension and Shear in a Slip Critical Connection Excel

Combined Tension and Shear in a Slip Critical Connection

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 paper 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. This paper is formulated
in terms of Load and Resistance Factor Design (LRFD), but
the principles are similar for Allowable Strength Design
(ASD).

LINK

Concrete Pool Design Based on ACI 318-14

Concrete Pool Design 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.

LINK

Check of Torsion Spreadsheet

Check of Torsion Spreadsheet

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. The current torsion design approach assumes no interaction between flexure, shear and torsion. Reinforcement for each of these forces is designed separately and then combined.

LINK

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet

Seismic Earth Pressure of Deep Stiff Wall Spreadsheet is very important sheet. Building codes are guiding documents for design and construction specifications to meet a prescribed acceptable amount of risk. Generally, provisions are adopted in response to poor performance; this is especially true for seismic provisions. Changes to U.S. building codes in response to poor performance during earthquakes were published in the SEAOC Blue Book (2009). However, despite no observation of damage to basements due directly to seismic earth pressure, provisions have been introduced into building codes that impact design and costs.

LINK

Reinforce RC Beam and Slab with FRP Plates Spreadsheet

Reinforce RC Beam and Slab with FRP Plates Spreadsheet 

Reinforce RC Beam and Slab with FRP Plates Spreadsheet provides the design of RC beams and slabs which is strengthened with FRB plate and calculate the required steel bars for them.
The sheet also calculate the required shear reinforcement for the beam. 

LINK