Home > how to calculate cement and sand in excel

## how to calculate cement and sand in excel Introduction

• Step 4 :- Calculation for Quantity of SAND. Sand = (dry volume of mortar x Sand ratio)/ sum of the ratio,s(proportion) or. sand = cement volume x 6 ( since 1:6 grade of mortar) therefore, sand = 0.043795 = 0.26277 m^3 or. sand = 0.26277 x 1920 = 504.5184 kg /1000 = 0.5045 tonnes or. sand = 0.26277 x 35.3147 = 9.279 cft or. sand = 0.26277 x 0

• ### How to Calculate Cement and Sand Quantity for Plastering?

Adding Bulking of Sand & Wastage. So to get 1.2 m 3 of wet cement mortar, we have to multiply the dry volume by 1.55. What is 1.55 constant in the calculation? 1. Bulking of Sand – If the moisture is present in the sand, then it makes the sand look bulkier, which could result in inadequate sand

• ### How to calculate cement, sand and coarse aggregate for

Cement Volume – 0.282 m 3 or 8.14 Bags Sand Volume – 0.423 m 3. Coarse Aggregate – 0.845 m 3. Water Cement Ratio Calculation. From the IS Code standard, Assuming the water-cement ratio for M20 is 0.55. Therefore required water quantity = Cement Volume X WC Ratio = 0.282 X 0.55 = 0.1551 m 3 Unit weight of water = 1000 Litres / m 3

• ### Plaster Calculator | Calculate Cement and Sand for Plastering

Excel ; Theorems ; Plaster Calculator . Plaster is a material used in building for the purposes such as protection, decoration, coating of walls, ceilings, moulding etc. Here is the useful Plaster calculator to calculate cement and sand for plastering. In this online Cement sand quantity for plastering calculator enter the area of plastering to

• ### Plaster Calculator | Calculate Cement and Sand for Plastering

V = A x T X = V x 1.54 C = X x (M / G) S = X x (N / G) Where, T = Plastering Thickness V = Volume of Cement Mortar A = Area of Plastering M = Ratio of Plastering Cement N = Ratio of Plastering Sand C = Cement Required (1 Part) S = Sand Required (5 Part) X = 35% Sand Bulkage G = Total ratio (M+N )

• ### Concrete Calculator | EXCEL CRIB

This will estimate the volume of concrete needed, number of bags of cement, volume of sand and volume of gravel for different types of concrete elements. It covers concrete calculator for column footing, wall footing, floor slab, rectangular column, circular column and stair.

• ### How To Calculate Number Of Bricks, Cement And Sand For

3/27/2018· In order to find the dry volume, we need to multiply 33 % as bulkage of sand. Dry volume of a mortar = 0.2305 cum X 1.33 = 0.306565 cum. We know the mortar ratio is 1:6 (1 part Cement & 6 Part Sand = 7 Part) Required amount Cement quantity in brickwork = 0.306565 X 1/7 X 1440 kg. Density of cement = 1440 kg.

4
• ### How To Calculate Cement, Sand & Aggregates Quantity in

8/3/2018· We Know in one bag of cement = 1.226 CFT For Calculate in CFT (Cubic Feet) = 8 x 1.225 = 9.8 Cubic Feet CALCULATION FOR SAND QUANTITY; Consider volume of concrete = 1m 3 . Dry Volume of Concrete = 1 x 1.54 = 1.54 m 3 Sand= (1.5/5.5) x 1.54 = 0.42 m 3 ∴ 1.5 is a part of Sand, 5.5 is sum of ratio . Density of Sand is 1450/m 3

• ### How to Calculate Cement, Sand and Coarse Aggregate

Density of Cement = 1440 kg/ m 3 = 0.3636 X 1440 = 523 kg = 10.5 Approx. Bags . Sand Quantity = ( Sand Part / Concrete Parts ) * Concrete Volume = (1.5/5.5) * 2 = 0.5454 m 3. Coarse Aggregate = (Coarse Aggregate Part / Concrete Parts ) * Concrete Volume = (3/5.5) * 2 = 1.09 m 3

• ### Excel Sheet to calculate Concrete Quantities | Civil4M

3/13/2020· Excel Sheet to calculate Concrete Quantities This excel sheet will make you able to calculate quantities for different concrete and steel structure members with this excel sheet you will calculate quantities for sand, cement and steel for beams, footings columns, beamed slabs, flat slab, and all other structural members.

• Required amount Cement quantity = 63 Kg = 1.26 bags (50 Kg bag) Required amount of Sand = 0.306565 X 6/7 = 0.26277 Cubic metre (m 3) Therefore, For 1 cum of brickwork, we need. 500 Numbers of bricks; 63 kg of cement; 0.263 m 3 of sand. You can also calculate Through given excel sheet (Calculation of Bricks Excel Sheet )

• ### Quantity of Cement and Sand Calculation in Mortar

Allow the sand in the container to settle for 10 minutes, now measure the distance above the sand and upto the top of the container say Y. Now we can get the percentage of voids with this simple formula (100/X)*Y. Once we get the voids percentage we can calculate the cement and sand required for various cement mortars.

• 5/11/2016· To make concrete there are four basic materials you need: portland cement, sand, aggregate (stone), and water. The ratio of aggregate to sand to cement is an important factor in determining the compressive strength of the concrete mixture. The mixing process is the fact that the better you mix the concrete, the stronger it will be.

• ### calculate quantity of cement mortar in brickwork & plaster

so here I provide an excel sheet by which you can easily find out the quantity of cement, sand, and numbers of brick required in the brick wall If you don't know how to calculate the number of brick or find out the quantity of cement and sand required in brick wall mortar

• ### How to Calculate The Quantity of Cement And Sand in Mortar

So, when we calculate the quantity of cement and sand in the mortar, we need to consider the reduced volume of the sand. Considering all these things lets calculate the quantity of cement and sand in the mortar. Get The Required Quantity of Mortar. Getting the quantity of mortar for plaster work is easy. You just need to get the plastering area

• ### How to Calculate The Quantity of Cement And Sand in Mortar

So, when we calculate the quantity of cement and sand in the mortar, we need to consider the reduced volume of the sand. Considering all these things lets calculate the quantity of cement and sand in the mortar. Get The Required Quantity of Mortar. Getting the quantity of mortar for plaster work is easy. You just need to get the plastering area

• ### Make Excel sheet for Cement, Sand and Crushed Stone

How to create your own excel sheet for cement, sand and aggregates Mr. S.L. Khan, the renowned engineer, comes with another useful tutorial for civil engineering students. In this video, you will how to create your own spreadsheet to determine the volume of cement (in cft & bags), sand and aggregates.

• ### calculate quantity of cement mortar in brickwork & plaster

so here I provide an excel sheet by which you can easily find out the quantity of cement, sand, and numbers of brick required in the brick wall If you don't know how to calculate the number of brick or find out the quantity of cement and sand required in brick wall mortar

• ### Excel sheet to Calculate Cement and Sand for Plastering

In this excel sheet, you will calculate the quantities of sand and cement for plastering. Plaster means a lean mortar that is formed for certain applications of arranging a supportive covering. Finishing coats shall be of such minimum thickness as just to provide a sufficient body of material to harden satisfactorily under the site conditions

• ### Calculation of Cement and Sand Quantity for Plastering

Method-2: Empirical method to Calculate Cement, Sand and Water required for Plaster (1:4): The empirical method is easiest way to calculate the quantities of materials required. Again considering the same parameters (i.e., Area – 100 sqft or 10 Sq meter and thickness 12mm. Step-1:Calculate the dry volume of cement and sand mixture required

• ### Concrete Calculator | EXCEL CRIB

This will estimate the volume of concrete needed, number of bags of cement, volume of sand and volume of gravel for different types of concrete elements. It covers concrete calculator for column footing, wall footing, floor slab, rectangular column, circular column and stair.

• ### Excel sheet to Calculate Cement and Sand for Plastering

In this excel sheet, you will calculate the quantities of sand and cement for plastering. Plaster means a lean mortar that is formed for certain applications of arranging a supportive covering. Finishing coats shall be of such minimum thickness as just to provide a sufficient body of material to harden satisfactorily under the site conditions

• ### How to calculate cement aggregate and sand in cft by

Considering M-15 mix as you have mentioned ratio of 1:2:4 As we know that during concreting when we place wet concrete, it gets harden after certain standard time( 30 mins IST ), considering same it had be decided upon by Civil design Engineers t

4
• ### HOW TO CALCULATE CEMENT, SAND AND COARSE

We find out the volume of concrete in wet condition 1m3 (After the consolidation of Cement + sand + water). So in dry conditions, we have to add 30 to 35% sand bulkage and add 20% for wastage.