Design of Post-Tensioned Concrete Floor Excel Sheet

 Design of Post-Tensioned Concrete Floor 

Design of Post-Tensioned Concrete Floor methods

1- Breakdown two ways of floor into design strips in one direction and one-way slabs in other direction. Design strips work as continuous beams by banded all tendons at the column. 

The perpendicular direction like multi-span one-way slabs, using distributed tendons.

2- Specify total required effective post-tensioning forces at banded tendons, on structural drawings,

and uniform forces in distributed 

3- when tendon less than 140 ft, stress at one end. Otherwise stress at both ends.

4- the various live loading conditions should be considered by input ll zero at some spans.

Download Design of Post-Tensioned Concrete Floor Excel Sheet

LINK

 Design of Wing Wall Spreadsheet 

The proposed cast-in-situ reinforced concrete structure is a wing wall of the proposed Arch Culvert along road RD-21 ( Typical design for all wing walls). Dingwall shall be designed as a cantilever wall to safely withstand earth embankment on one side of the wall and comply with minimum factors of safety and 100 kPa recommended net allowable bearing capacity as per  RC manual.

Download Design of Wing Wall Free Spreadsheet

LINK

 Ordinary Reinforced Concrete Shear Wall Design Excel Sheet 

Shear walls in buildings must be symmetrically located in a plan to reduce ill-effects of twist in buildings They could be placed symmetrically along with one or both directions in the plan. -Shear walls are more effective when located along the exterior perimeter of the building – such a layout increases the resistance of the building to twisting.

Download Free Ordinary Reinforced Concrete Shear Wall Design Excel Sheet

LINK

 Cantilever Column & Footing Design Spreadsheet 

 The cantilever is basically a structural element that extends horizontally and has supported at only one end. The cantilever is the structures that are fixed at one end and free at another end.

Download Cantilever Column & Footing Design Free Spreadsheet

LINK

 Wind Pressure on High Rise Building Calculation Excel Sheet 

This excel sheet calculate wind Pressure on high rise building. The wind load calculation is evaluated based on elementary wind speed and other aspects as kind of topography, terrain, and the usage of the building and its risk aspect for that specific region

Download Wind Pressure on High Rise Building Calculation Free Excel Sheet

LINK

 Full Steel Building Design Calculation Free Spreadsheet 

Steel Building Design Calculation Spreadsheet contains: 

INDEX

PREAMBLE

CODES & REFERENCES

MATERIAL SPECIFICATIONS

PRIMARY LOADS

LOAD COMBINATIONS

LOAD CALCULATIONS

EQUIPMENT DATA

DESIGN OF ANCHOR BOLTS & BASE PLATE

SUPPORT REACTIONS

GEOMETRY OF STRUCTURES

Download Full Steel Building Design Calculation Free Spreadsheet

LINK

Design Of Intze Water Tank Free Excel Sheet

 DESIGN  OF INTZE WATER TANK 

A water tank is used to store water to tide over the daily requirement. In the construction of concrete structures for the storage of water and other liquids, the imperviousness of concrete is most essential.  Design of liquid retaining structure has to be based on the avoidance of cracking in the concrete having regard to its tensile strength.  Cracks can be prevented by avoiding the use of thick timber shuttering which prevents the easy escape of heat of hydration from the concrete mass the risk of cracking can also be minimized by reducing the restraints on free expansion or contraction of the structure.

Design  Of Intze Water Tank Free Excel Sheet Download

LINK

 Design of Plate Girder with I Shape according to ASCE 

Plate girder design according to LRFD is very similar to the ASD method presented in the 8th Edition Manual of Steel Construction.8 The basic approach is unchanged, with the major changes being the addition of an additional bearing strength formula to check and some new AASHTO criteria for stiffener design.

LINK

 Design of Circular Water Tank Excel Sheet 

The underground water tanks can be divided into rectangular or circular in shape. Properties Rectangular Underground Water Tank Circular Underground Water Tank When to construct? When the capacity of liquid to be stored is small Capacity of liquid to be comparatively large Maximum Principal Stress The rectangular and circular water tanks of the same capacities may have stress results less than circular tanks. e.g. for a capacity for both types, the maximum stress calculated for rectangular water tank was 5.32N/mm2 Greater than rectangular tanks e.g. For circular water tank, 7.1N/mm Resistance to pressure Less In case of resistance to all pressure exerted in the tank circular is better. Area of steel Area of reinforcement of circular tank is greater Less

Design of Circular Water Tank Excel Sheet Free Download

LINK

 Free Excel Sheet to Design Rectangular Drains 

This document contains design calculations for Surface stormwater drains ( Plant)

Total plant drains are divided into two types of drains based on the suitability /

requirements as given below. 

i) Rectangular concrete open drains  - Within the unit areas / Building areas

ii) Trapezoidal concrete open drains   - outside the building areas

The analysis is carried out based on the basic input parameters furnished in the Civil Structural

Design Basis  Document. However, furnished below for easy reference

Download Free Excel Sheet to Design Rectangular Drains

LINK

 Steel Staircase Design 

Steel staircase design spreadsheet allows you to design stairs 

Download Steel Staircase Design

LINK

Soil Arching Effect for Braced Excavations Excel Sheet 

This spreadsheet will calculate the horizontal earth pressure exerted on a braced excavation using soil arching theory as proposed 

LINK

Reinforced Concrete Design To Eurocode 2

Reinforced Concrete Design To Eurocode 2 

John Bungey

Preference :

his text is developed from the established and well-known textbook Reinforced Concrete Design. It adopts the same format of presentation to cover the design and detailing of reinforced and prestressed concrete members and structures to the new Eurocode for the design of concrete structures (Eurocode 2: Design of Concrete Structures, Part1). The book aims to give a straightforward and practical introduction to the principles and methods used in the design of reinforced and prestressed concrete structures and presents numerous worked examples to illustrate the various aspects of design. Although the detailed methods considered are generally according to EC2 much of the theory presented is also of a fundamental nature. Appropriate design charts, tables and formulae are presented as design aids and for ease of reference, a summary of important design equations together with design tables and charts are presented in the Appendix.

Content :

• Properties of Reinforced Concrete
• Limit State Design
• Analysis of the Structure
• Analysis of the Section
• Shear, Bond and Torsion
• Serviceability, Durability and Stability Requirements
• Design of Reinforced Concrete Beams
• Column Design
• Foundations and Retaining Walls
• Prestressed Concrete

Download Reinforced Concrete Design To Eurocode 2 free PDF

LINK

 Two-Way Slab Design using Finite Element Method 

Two-way slab: If the proportion of long span to short span is under 2, then the slab is called a slab that stretches in two directions or a two-way slab.

TWO WAY SLAB DESIGN PROCESS :

1. Select layout and type of slab. The type of slab is greatly influenced by architectural and construction considerations.

2. Select slab thickness to manage deflection. Also, examine if thickness is sufficient for shear.

3. Opt for design method.

Equivalent frame method- Apply elastic frame analysis to calculate positive and negative moments.

Download Two-Way Slab Design using Finite Element Method

LINK

 Sizing of Foundations for Columns of Compound Wall - Spreadsheet  

Excel spreadsheet for Sizing of foundations for columns of the compound wall - calculation of maximum pressure on soil for foundations.

LINK

 Construction Cost Estimate Template in Excel 

Construction cost sheet in excel contains : Earth Works, Masonry Works, Plastering Works, Concreting Works, Form Works, Rebar Works, Roofing Works, Tile Works Doors, Jambs & Accessories, Windows Painting Works, Plumbing Works, Ceiling Works, Electrical Works, and  Others.

Download Construction Cost Estimate Template in Excel

LINK

 Solved Example on Design And Detailing Of Counterfort Retaining Wall

When the height of the retaining wall exceeds about 6 m, the thickness of the stem and

heel slab works out to be sufficiently large and the design becomes uneconomical. In

such a case counterforts having trapezoidal section fixed at the base slab are provided

at intervals of 1.5 m to 3 m. The counterforts support the heel slab and the vertical stem.

The design principles for different components of the wall are discussed below.

LINK

 Design of Biaxial Isolated RCC Footing Excel Sheet 

This spreadsheet is on the bi-axial design of isolated footing using IS method. This

bi-axial footing design can take care of both the cases of Positive and Negative pressure. This is a truly bi-axial design where both the moments and vertical force is taken care of at the same time to get their combined effect on footing design. The yellow cells are input cells. The user should not touch other cells at all. The first worksheet is to be used when positive pressure develops.

LINK

Rectangular and Circular Column Design 

RECTANGULAR COLUMN DESIGN WITH EXCEL

CIRCULAR COLUMN DESIGN

with Bar Dimensions spreadsheet with excel

Download Rectangular and Circular Column Design 

LINK

 Spreadsheet for plane frames, beams and trusses calculation 

Spreadsheet for plane frames, beams, and trusses calculation. Finite Element Method for beam elements is used. After calculation, the program creates (recreates) several sheets: “Results”, “Graph” and (optional) - “Matrix”.

The “Results” sheet contains:

– Nodal results (reactions and displacements at different base loads and load combinations)

– Element results (extremal moments, axial and shear forces overall load combinations).

LINK

 Structural Steel Takeoff Sheet 

The structural steel takeoff sheets are utilized to compute structural steel erection, miscellaneous-steel work activities, steel decking, and siding installation, rebar placement, pre-engineered building assembly, and pricing contract change orders as well as other steel associated construction work activities by applying some in-built formulas.

This spreadsheet is ideal to streamline the bidding process for structural steel.

Download Structural Steel Takeoff Sheet

LINK

Combined Strap Footing Design Excel Sheet

 Combined Strap Footing Design 

Footings are an important part of foundation construction. They are typically made of concrete with rebar reinforcement that has been poured into an excavated trench. The purpose of footings is to support the foundation and prevent settling.

Download Combined Strap Footing Design 

LINK

 Design of Isolated Footing Spreadsheet

The isolated footing is used to support the load on a single column. It is usually either square or rectangular in plan. It represents the simplest, most economical type, and most widely used footing. Whenever possible, square footings are provided so as to lessen the bending moments and shearing forces at their critical sections.

Isolated footings are used in case of light column loads, when columns are not closely spaced, and in case of good homogeneous soil. Under the effect of upward soil pressure, the footing bends in a dish-shaped figure. An isolated footing must, for that reason, be provided by two sets of reinforcement bars situated on top of the other near the bottom of the footing. In the case of property line restrictions, footings may be designed for eccentric loading or combined footing is used as a substitute to the isolated footing.

LINK

 Calculate Quantities of Materials for Concrete Excel Sheet

Quantities of materials for the production of the required quantity of concrete of given mix proportions can be calculated by the absolute volume method. This method is based on the principle that the volume of fully compacted concrete is equal to the absolute volume of all the materials of concrete, i.e. cement, sand, coarse aggregates, and water. A Concrete structure may consist of beams, slabs, columns, and foundations, etc. based on the type of structure. The volume of concrete required for concrete structure can be calculated by summing up the volumes of each structural member or each part of members.

Calculate Quantities of Materials for Concrete

LINK

 Design of staircase with central stringer beam

 Reinforced concrete stairs are perhaps the most suitable of all the said materials for the construction of stairs. The various advantages of reinforced concrete stairs are given below. They have requisite fire-resisting qualities to a great extent. They are durable strong pleasing in appearance and can be They are durable, strong, pleasing in appearance, and can be easily rendered non-slippery. They can be designed for greater widths, longer spans, and any height height.– They can be molded in any desired form to suit the requirements of the architect.

LINK

 Design of Pile Cap Excel Sheet

It usually forms part of the foundation of a building, typically a multi-story building, structure or support base for heavy equipment. The cast concrete pile cap distributes the load of the building into the piles. A similar structure to a pile cap is a “raft”, which is a concrete foundation floor resting directly onto soft soil which may be liable to subsidence.

Download Design of Pile Cap Excel Sheet

LINK

 Excel Template for Daily Work Report

This is an exclusive excel template that is based on the daily work report of the employees. Any person who is self-employed or performing as an employee in a company is required to maintain day-to-day work reports as well as generate them on daily basis to organize records concerning all the works executed by you throughout working hours.

To prove your worth and ensure that you are a responsible employee to your employer, it is necessary to send a report about your work on a day-to-day basis as you are completing the works entrusted to you as well as sending reporting on it devoid of any delay on a regular basis.

Daily work report means a document of details of work accomplished by you in a day. Either your supervisor, manager, or employer inquire you to provide information on what you carry out every day or not, creating a daily work report is a perfect way to keep tracing the work done by you.

LINK

 Detailed Estimate for The Proposed New Construction of Residential Building

Detailed estimating, sometimes referred to as “Prime Cost”, “Bottoms Up” or “Grass Roots” estimating requires a thorough and detailed analysis of all the tasks required to deliver a project or product. A “good” estimate maximizes the return on this investment by obtaining the highest value at the lowest cost. The estimate can be developed using a combination of estimating methods. An estimate is a calculation of the quantities of various items of work, and the expenses likely to be incurred thereon. The total of these probable expenses to be incurred on the work is known as the estimated cost of the work.

LINK

 Estimate of Requirement of Material Excel Sheet

Material requirements planning (MRP) is a production planning, scheduling, and inventory control system used to manage manufacturing processes. Most MRP systems are software-based, while it is possible to conduct MRP by hand as well. Material requirements planning (MRP) is a production planning and inventory control system. … Lastly, an MRP system helps plan manufacturing functions, delivery schedules, and purchasing. … Data integrity, however, is a major issue for successful material requirements planning.

Download Estimate of Requirement of Material Free Excel Sheet

LINK

 Project Portfolio Dashboard Excel Template

This dashboard display follows box layout with simple colors, easy charts, picture links & lots of conditional formatting goodness.

Fetching a relevant project plan from all plans:

This was one of the trickiest things. Since each plan has its own table, getting selected project’s table is necessary to drive all calculations. This is how it's done.

Define lstPlans as a list of all tables =plan1,plan2…,plan10

Use INDEX to fetch one of the tables from this array like this =INDEX(lstPlans, activity-row-number, column-number, plan-number)

LINK

 Excel Sheet to Calculate Quantities for One and Two Way Slab 

One way slab is supported by beams in only 2 sides. 2) The ratio of longer span panel (L) to shorter span panel (B) is equal. or greater than 2. Thus, L/B >= 2. 3) Main reinforcement is provided in only one direction for one way slab

Two way slabs are the slabs that are supported on four sides and the ratio of longer span (l) to shorter span (b) is less than 2. In two way slabs, load will be carried in both the directions. So, main reinforcement is provided in both direction for two way slabs.

Download Free Excel Sheet to Calculate Quantities for One and Two Way Slab 

LINK