How Do I Calculate Brick, Sand And Cement In Brick Masonry using EXCEL?

How Do I Calculate Brick, Sand And Cement In Brick Masonry using EXCEL?

Before Going To Know About Calculation Of Brickwork

Here is our LCETED trivia about brickwork

1 we use 1:5 mix ratio for river sand

2. we use 1:6 mix ratio for M-sand

3. thickness of mortar is should be 10mm

To know more information about brickwork click here. brickwork information

Assuming

1.   Class A brick (228mm × 107mm × 69m)

2.   Size of wall for brickwork = 3m x3m

3.   Grade of mortar = 1:6 (cement : sand)

STEP 1: FIND TOTAL AREA OF WALL USING WALL

Wall dimensions

You want enter wall dimensions in these columns

Wall length = 3m (A3)

Wall depth = 3m (B3)

Wall breadth = 0.0107 (C3)

Total area of wall

To find this we will calculate

The total volume of the wall for brickwork = 3m x 3m x 0.107m (brick wall thickness 107mm) = 0.963m³

Therefore,

we used this formula in excel by =SUM(A3*B3*C3)

QUANTITY SURVEY USING EXCEL?

STEP 2: ENTER YOUR CORRECT BLOCK OR BRICK SIZE

Block OR Brick Size

You want enter your Block OR Brick Size in this column

Brick size

228mm × 107mm × 69m

Block size

400mm block

400*200*200 - 8″ block

400*150*200 - 6″ block

400*100*200 - 4″ block

600mm block

600*200*200 - 8″ block

600*150*200 - 6″ block

600*100*200 - 4″ block

STEP 3: FIND THE AREA OF YOUR BLOCK OR BRICK

We are using Class A brick

Length 228mm = E3

Breadth 107mm = F3

Depth 69m = G3

WE USE THIS FORMULA TO FIND

Volume of one brick (without mortar) = 228x107x69= (mm->m) = (0.228x0.107x0.069) = 0.00168m³

THEREFORE IN EXCEL

We should use = SUM(E3*F3*G3)

Since Thickness Of Mortar = 10 mm (0.01 m)

228x107x69mm = 238x117x79

Volume of brick with mortar = (0.228+0.01) x (0.107+0.1) x (0.069+0.1) = 0.238x0.117x0.079 = 0.002199833 m³

THEREFORE IN EXCEL

We should use =SUM((E3+0.01)*(F3+0.01)*(G3+0.01))

STEP 4: TO FIND TOTAL NO OF BRICKS

Total no of bricks = Total area of wall/total area of blocks or bricks

No. of bricks of 0.963m³= 0.963m³/ (0.002199833) 

= 437.7603037 nos of bricks

THEREFORE IN EXCEL

=SUM(D3/I3)

STEP 5 : CALCULATION FOR QUANTITY OF MORTAR

Volume Of Mortar = Volume Of Brick Work for 1m³ - Volume Of Bricks

Volume Occupied By Bricks = No Of Bricks X Volume Of One Brick

Volume of bricks = 437.7603037  x 0.00168 = 0.73543731021m³

So,

Volume Of  Mortar = 0.963 - 0.73543731021

= 0.226107574m³

THEREFORE IN EXCEL

=SUM(D3-(H3*J3))

33% Increment Due To Volume Shrink After Water

Dry volume of Mortar = 0.2263107574 x 1.33 = 0.30 m³

THEREFORE IN EXCEL

=SUM(J11*1.33)

STEP 6: CALCULATION FOR QUANTITY OF CEMENT & SAND MORTAR

LCETED TRIVIA FOR CIVIL ENGINEERS

1 : 5

While working with first-class bricks, it should be noted that for the walls with the thickness of 9” the cement-sand ratio for brick masonry should be 1:6 and when it comes to a wall of 4.5” thickness the ratio can be made 1:5.

Cement= (Dry Volume Of Mortar X Cement Ratio)/ Sum Of The Ratios (Proportion)

Cement = (0.30099330734 x 1) / (1+5) = 0.2128/7=0.050 m³

Sand = (Dry Volume Of Mortar X Sand Ratio)/ Sum Of The Ratios (Proportion)

Sand = (0.30099330734 x 5) / (1+5) = 0.2128/7= 0.250 m³

THEREFORE IN EXCEL

Cement =SUM((J12*F13)/(F13+G13))

Sand =SUM((J12*G13)/(F13+G13))

STEP 7: CALCULATION FOR QUANTITY OF MATERIAL

LCETED TRIVIA FOR CIVIL ENGINEERS

We believe the standard density of 1 cement bag is equal to 1440 kg/m3

Cement  (kg) = 0.050x 1440 = 72.17353728 kg

No. of bags = 72.17353728 / 50 = 1.4434707456 bags

Sand = 0.250602562x 35.3147 = 8.84 cft 

THEREFORE IN EXCEL 

CEMENT =SUM((J14*1440)/50) &" bags"
SAND =SUM(J15*35.3147) &" cft"

So, the result for

1.   Grade of mortar = 1:6 (cement : sand)

2.   Volume of 3m x 3m brick wall = 9m³

3.   Class A brick (228mm × 107mm × 69m)

4.   Thickness of mortar = 10 mm

CLICK HERE TO FOR EXCEL SHEET DOWNLOAD

LCETED INSTITUTE FOR CIVIL ENGINEERS

“Our Mission To Educate And Keep People Informed By Creating A Trusted Source Of Knowledge Everything Related To Civil Engineering”

Share