Pages

Tuesday, September 26, 2017

Tile Flooring - Estimating Number of Tiles for a Room, Cement & Sand in Excel

In this lesson, we will learn the process of estimating the quantity of number of tiles needed for a room, cement and sand needed for the tile flooring job.

Let us suppose a room of width 6 meters and length 10 meters. The size of one tile is considered as 0.3 meters by 0.3 meters.

Let us assume the thickness of flooring equal to 50 millimeters. For the area of calculation of area of room to be floored, multiply the width of room and length of room.

That is, 6 meters x 10 meters = 60 m2
The proportion of mortar is 1:4, where 1 is cement and 4 is sand.
First, let’s compute the wet volume of mortar which will be needed for the bed of flooring. As a result, the formula will be thickness of flooring x area of flooring.

Wet volume of mortar = 60 X 50/1000 = 3 m3
Dry volume of mortar = 25% more of volume of wet volume = 3 x 1.25 = 3.75 m3

Quantity of cement required = Dry Volume / Sum of proportion X Proportion of Cement
Quantity of cement required = 3.75/1+4 x 1 = 0.75 m3
Number of bags of cement required = (0.75/0.035) = 22

Quantity of sand required = Dry volume/ Sum of proportion x proportion of sand 
Quantity of sand required = 3.75/1+4 x 4 = 3 m3
We know that 1 m3 = 0.354 brass

Therefore, quantity of cement in brass = 3 x 0.354 = 1.062 brass
Number of mosaic tiles = Area of flooring/size of one tile = 60/0.3x0.3 = 667

Tile Flooring - Estimating Number of Tiles for a Room, Cement & Sand in Excel
Watch the following online demonstration.

Video Source: Unite Constructions and Unite Coaching

7 comments:

  1. Couldn't be written any better. Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!
    marble pavers

    ReplyDelete


  2. Very well done. Absolutely brilliant information. I'm in love with this blog. they always provide such a great information. plaster sand bags

    ReplyDelete
  3. This article gives the light in which we can observe the reality. I like this kind of blog. Thanks for sharing informative information with us
    https://www.boyntonpavers.com/

    ReplyDelete
  4. Thnaks fi=or the blog...
    ceramic tiles and different type of tiles like Full body glazed vitrified tiles,Large format tiles, Glazed vitrified tiles with high elegance full body design tiles for both indoor and outdoor.

    ReplyDelete
  5. Thanks for sharing this info!
    As, Ceramic Tile Estimating Service by Takeoff Pro will give you the right estimates prepared by the team of experts. Contact us for the estimates and reduce the expenses for precise estimates.

    ReplyDelete
  6. I truly like to read your post. Thank you so much for taking the time to share such nice information.

    tile installers near me

    ReplyDelete
  7. Thanks for sharing the blog. This is soo amazing and useful Information.please keep it up.

    Tile Flooring
    Glass Tile
    Marble slab
    Wall Tiles
    Porcelain Tile Flooring

    ReplyDelete