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