math problem
 

I am looking for a formula to define the number of tiles I need (full
equivalent) to put in a room with an L-shape.
I have tiles size 45 by 45 or 60 by 60 cm.
I can calculate the net size of the floor of the room, but also would like
to know how many tiles I need to order.
Any idea how excel can help me with such formula?

Rob

math problem
 

I would divide the L into two rectangles.
For each compute rows and "columns" or tiles needed
You could use ROUNDUP to find how may rows and columns
Length of rectangle = 500; tile = 45; number of rows needed R =
ROUNDUP(500/45, 0)
Width = 400; tile = 45, number of columns C = ROUNDUP(400/45,0)
Number of tiles = R * C

But this will be approximate: suppose you need tile 45 by 10 at a wall; you
need not discard the remainder since it will give a second 45 by 10 unit.

Time to consult a DIY book? Or overpuchase at a store which will take back
unused items (my approach to carpentry every time!)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rob" wrote in message
...
I am looking for a formula to define the number of tiles I need (full
equivalent) to put in a room with an L-shape.
I have tiles size 45 by 45 or 60 by 60 cm.
I can calculate the net size of the floor of the room, but also would like
to know how many tiles I need to order.
Any idea how excel can help me with such formula?

Rob

math problem
 

That depends entirely on how you lay the tiles. Different patterns have
different amounts of waste associated with them. It also depend show fussy
you are in terms of having full tiles. The long and the short of it is that
there is a coverage number on the side of the box telling you how many square
feet (or meters) the box will cover. Plan on at least 10% waste and then
purchase accordingly. Finally alwasy keep a couple of extra kicking around
for when drop something and break a tile...

But if you want to know a 60 x 60 tile covers 360 square cm (or .36 square
meters)
--
HTH...

Jim Thomlinson


"rob" wrote:

I am looking for a formula to define the number of tiles I need (full
equivalent) to put in a room with an L-shape.
I have tiles size 45 by 45 or 60 by 60 cm.
I can calculate the net size of the floor of the room, but also would like
to know how many tiles I need to order.
Any idea how excel can help me with such formula?

Rob

math problem
 

Bernard wrote on Mon, 17 Sep 2007 18:07:32 -0300:

BL But this will be approximate: suppose you need tile 45 by
10 at a
BL wall; you need not discard the remainder since it will give
BL a second 45 by 10 unit.

BL Time to consult a DIY book? Or overpuchase at a store which
BL will take back unused items (my approach to carpentry every
BL time!) best wishes
BL --
BL Bernard V Liengme
BL Microsoft Excel MVP
BL www.stfx.ca/people/bliengme
BL remove caps from email

BL "rob" wrote in message
BL ...
?? I am looking for a formula to define the number of tiles I
?? need (full equivalent) to put in a room with an L-shape. I
?? have tiles size 45 by 45 or 60 by 60 cm. I can calculate
?? the net size of the floor of the room, but also would like
?? to know how many tiles I need to order.
?? Any idea how excel can help me with such formula?

As Bernard suggests, you hardly need Excel. If an integral
number of tiles will overlap the space, so be it! It's much
better to have a few too many than a few too little. I don't
think I would try desperate measures to fit whole tiles.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not