How to estimate the quantity of cement, sand and aggregate in Microsoft Excel

This construction tutorial will teach you the detailed method for computing quantity of Cement, Sand & Aggregate in concrete as well as cost of materials with Microsoft Excel.

The volume of executable PCC is taken as 6 cubic meter that should be performed with M15 grade of concrete whose ratio is 1:2:4. MS Excel program is very useful to instantly produce and manage your concrete cost estimates accurately. Get detailed takeoff and summarize the quantities automatically based on the scope or assembly item.

Benefits of excel based estimating:

• Most of the calculations are automated

• User-friendly to use

• Save huge time in calculation

• Easily customizable according to your requirements

~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~

The process for estimating Cement, Sand and Aggregate Quantity in Concrete

This construction video provides detailed methods for estimating the quantity of cement, sand and aggregate in cement concrete to figure out the cost of all the materials. In this video, the volume of PCC to be prepared is taken as 10 cubic meter that is to be completed with M15 grade of concrete in the ratio of 1:2:4.

In a simple term, concrete is defined as a blend of paste and aggregates. The paste is formed with portland cement and water and covers the surface of the fine and coarse aggregates. With a chemical reaction known as hydration, the paste is solidified and becomes stronger to develop the rock-like mass called concrete.

Due to its longevity, firmness and comparatively marginal cost, concrete is mostly recognized for the buildings & infrastructures like houses, schools and hospitals as well as airports, bridges, highways and rail systems all through the globe.

Cement is actually a vital component of concrete. This fine powder is amalgamated with water, sand, and gravel or crushed stone (fine and coarse aggregate) and develops the rock-like mass known as concrete.

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~

Some useful construction tips for becoming a successful rebar checker

While developing a big project, there should be a perfect technical engineering perception and cautious observation. Besides, other crucial examinations, Reinforced Cement Concrete should be verified for rebar toward the supplied construction drawings / shop drawings or technical specifications.

It should be remembered that the obstacle and cost associated with this activity may cause imperfection from the contractors end and it should be resolved / settled by a well-known consulting firm assigning on the inspection of execution.

One should have sound knowledge and well versed with the binding method of the steel rebar. Given below, some useful construction tips suggested by the top peers:-

a. Initially, one should have good knowledge on how to study a rebar drawing as well as communicate with it in the jobsite. In order to become a proficient rebar checker, you should have the capability to read drawing.

b. Carry a measuring tape with yourself so that you can verify the spacing and the splice length or development length.

c. Use a plastic glove, when checking the rebars as holding steel with bare hands may cause harm to the skin of of your body.

d. Should be familiar with the physical features of the construction component i.e. installing the drainage pipe or electrical conduit or replacing water stopper and any other pipes / embedded item.

e. Use vernier caliper to verify rebar diameter, rebar spacing, rebar development length, lap / splice length, alignment. Other important things range from no sag or buckling in the bars, perfectly fixed & tightened couplers, rust free bars, verifying clear cover, counting no of bars as per drawing specifications and must not be below or over 2 bars.

f. As a newbie in this field, try to keep in touch with contractor’s foreman or site engineer as they know well how to arrange these bars.

g. You should have good knowledge concerning the steel quality tests like tensile strength check or torsion failure strength or coupler tension strength check etc. Make sure that the steel are used after proper verification and poor quality steels are used.

h. Because of rough field conditions and difficultly in setting up / fixing of rebars, the proper design can’t be created. But you must be very careful about it as improper design may lead to collapse of a building.

i. One of the very crucial factors is to retain the exact orientation of bars like main rebars should be always arranged under the distribution or temperature rebars. It can be verified from the drawings submitted to you.

Ref.: www.iamcivilengineer.com

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~

Advantages Of Truss Mesh Reinforcement For Brick Wall

Truss mesh reinforcement is essential for developing masonry wall. Truss mesh reinforcements are implanted into the horizontal mortar joints of masonry walls and constant with the wall length.

Reinforces various types of masonry walls

Considerably lowers the cracking that may happen due to thermal stresses

Improves resistance capacity against penetration of water, because cracks are well organized

Improves lateral flexural strength

Enhances elasticity

Enhances performance of masonry walls under different stresses

Specifications

Existing Materials: hot dipped galvanized, electro galvanized or stainless steel.

Wire diameter:1.8mm - 2.0mm.

Weight: 2kg - 10kg.

Length: 3 meters long, the space distance is 40cm

Width 5cm, 10cm, 15cm, 20cm ,25cm, 30cm.

Ref.: www.concrete-mesh.com

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~

Standard Designs of Gabion Retaining Wall

A gabion is a cage, cylinder, or box full with rocks, concrete, or sometimes sand and soil for use in civil engineering, road building, and military applications and landscaping.

Here are some different designs based on different heights:

1m high wall

A 1m high wall is very easy to build and it requires 1m x 1m x 1m or 2m x 1m x1m baskets. The smaller size is recommended if the length user have to cover is small as it will lessen transport costs. User can also use 1/2m deep baskets this will save on the cost of fill but will decrease the strength of the wall and is recommended only in situations where the bank is fairly secure.

2m high wall

Gabion baskets are a mass retaining system accordingly, to construct a wall for the higher area which requires retaining; for that reason the wall must be heavier enough. For a gabion wall’s standard design the structure is like a pyramid. As a matter of fact, for every 1m expansion in wall height, the bottom row basket depth should be expanded by half a meter.

3m high wall

In this example the top 2 rows are the same as a 2m wall but with a .5m increase in the depth of the bottom row.

The bottom row is 2 meters deep middle row 1.5m deep and top row 1m deep. In general usage of 2m x 1m x 1m baskets bottom row 1.5m x 1m x 1m baskets in the middle row and 1m x 1m x 1m or if possible 2m x 1m x 1m baskets going sideways on the top row.

The image below is the example of gabion retaining wall design of different heights.

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~

How to use Etabs 2016 for slab design

This construction video provides useful information on how to use Etabs 2016 for creating effective slab design.

This newest software can be used to make integrated structural analysis, design and drafting of building systems. ETABS 2016 contains supreme 3D object based modeling and visualization tools as well as rapid linear and nonlinear analytical capacity, superior and wide-ranging design capacities for a wide array of materials, and intuitive graphic displays, reports, and schematic drawings which facilitate the users to smoothly & instantly read and understand analysis and design results.

ETABS combines each phase of the engineering design process from initial design perception to the formation of schematic drawings. Formation of models becomes so simple. With superior drawing commands, one can instantly generate floor and elevation framing. CAD drawings are directly transformed into ETABS models or applied as templates onto which ETABS objects are overlaid. The advanced SAPFire 64-bit solver facilitates the users to instantly evaluate exceptionally big and complicated models. It also supports nonlinear modeling methods like construction sequencing and time effects (e.g., creep and shrinkage).

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~

How to use Tekla Structure 2016 for bridge pier reinforcement

This construction video briefly shows how to use Tekla Structure 2016 to perform bridge pier reinforcement.

Concrete piers stand for vertical structural elements that support the weight of a building or structure. The role of the concrete piers is similar to the table legs. If they are designed properly, and arranged on solid ground or to a depth that the friction on the sides of the pier is exceeding the load placed on the pier, the piers and the structure will be immovable.

Most concrete piers applied over the average home for a deck or other structures are generally lower than 24 or so inches in diameter at the base of the pier. As the pier increases and out of the ground, it can be minimized in size to as small as 10 inches in diameter. The bottom of the pier should always remain under the frost line in the area.

The bottom of the pier should be broader as compared to the top. The wider base facilitates allocating the weight of the structure over more soil. Thus the design becomes stable enough.

~~~~~~~~~~~~~~~~~~~~~

Published By

Rajib Dey

www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~