How Do I Calculate Brick, Sand And Cement In Brick Masonry using EXCEL? -lceted LCETED INSTITUTE FOR CIVIL ENGINEERS

## 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
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)

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.963m3

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

Depth 69m = G3

WE USE THIS FORMULA TO FIND
Volume of one brick (without mortar) = 228x107x69= (mm->m) = (0.228x0.107x0.069) = 0.00168m3
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 m3
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.963m3= 0.963m3/ (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 1m3 - Volume Of Bricks
Volume Occupied By Bricks = No Of Bricks X Volume Of One Brick
Volume of bricks = 437.7603037  x 0.00168 = 0.73543731021m3
So,
Volume Of  Mortar = 0.963 - 0.73543731021
0.226107574m3

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 m3
THEREFORE IN EXCEL
=SUM(J11*1.33)
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 m3
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 m3
THEREFORE IN EXCEL
Cement =SUM((J12*F13)/(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 = 9m3
3.   Class A brick (228mm × 107mm × 69m)
4.   Thickness of mortar = 10 mm

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”