help with formula  
Author Message
Injam





PostPosted: Sun Aug 13 06:01:01 CDT 2006 Top

worksheet functions >> help with formula

Based on area.

B15 = width
C15 =length
D15 =Total sq meters
E15 = tile size (currently sq cms)
F15 = tiles required

this is the formula I am using =D15/(E15/10000)

What I want to do is in E15 just put in the tile size (say a 30cm tile)
rather than sq cms and have the formula convert this to sq cms, so somehow
need to sq the number in E15. At least that is how my brain is telling me.

thanks

Excel298  
 
 
paul





PostPosted: Sun Aug 13 06:01:01 CDT 2006 Top

worksheet functions >> help with formula yes you need to square your tile size in cm and then divide by 10000(ie
100X100)
so your formula would be
=a3/(power(a4,2)/10000),where a3 is the sq metres of you r room and a4 s
your tile size in cm
--
paul

remove nospam for email addy!





> Based on area.
>
> B15 = width
> C15 =length
> D15 =Total sq meters
> E15 = tile size (currently sq cms)
> F15 = tiles required
>
> this is the formula I am using =D15/(E15/10000)
>
> What I want to do is in E15 just put in the tile size (say a 30cm tile)
> rather than sq cms and have the formula convert this to sq cms, so somehow
> need to sq the number in E15. At least that is how my brain is telling me.
>
> thanks
>
>
>
 
 
Ragdyer





PostPosted: Sun Aug 13 06:08:15 CDT 2006 Top

worksheet functions >> help with formula Try this:

=D15/(E15^2/10000)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


> Based on area.
>
> B15 = width
> C15 =length
> D15 =Total sq meters
> E15 = tile size (currently sq cms)
> F15 = tiles required
>
> this is the formula I am using =D15/(E15/10000)
>
> What I want to do is in E15 just put in the tile size (say a 30cm tile)
> rather than sq cms and have the formula convert this to sq cms, so somehow
> need to sq the number in E15. At least that is how my brain is telling
me.
>
> thanks
>
>

 
 
S





PostPosted: Sun Aug 13 06:14:48 CDT 2006 Top

worksheet functions >> help with formula That worked perfectly...thanks



> yes you need to square your tile size in cm and then divide by 10000(ie
> 100X100)
> so your formula would be
> =a3/(power(a4,2)/10000),where a3 is the sq metres of you r room and a4 s
> your tile size in cm
> --
> paul

> remove nospam for email addy!
>
>
>

>
>> Based on area.
>>
>> B15 = width
>> C15 =length
>> D15 =Total sq meters
>> E15 = tile size (currently sq cms)
>> F15 = tiles required
>>
>> this is the formula I am using =D15/(E15/10000)
>>
>> What I want to do is in E15 just put in the tile size (say a 30cm tile)
>> rather than sq cms and have the formula convert this to sq cms, so
>> somehow
>> need to sq the number in E15. At least that is how my brain is telling
>> me.
>>
>> thanks
>>
>>
>>


 
 
oldchippy





PostPosted: Sun Aug 13 06:19:55 CDT 2006 Top

worksheet functions >> help with formula
S S Wrote:
> Based on area.
>
> B15 = width
> C15 =length
> D15 =Total sq meters
> E15 = tile size (currently sq cms)
> F15 = tiles required
>
> this is the formula I am using =D15/(E15/10000)
>
> What I want to do is in E15 just put in the tile size (say a 30cm
> tile)
> rather than sq cms and have the formula convert this to sq cms, so
> somehow
> need to sq the number in E15. At least that is how my brain is telling
> me.
>
> thanks
Hi S S,

Always a problem working out how many tiles you need to do a job,
depends on shape being tiled, pattern or plain tile, size of tile

As tiles don't always come in squares, how about this?
B15 enter width ie. 20
C15 enter length ie. 30
D15 enter sq. metres ie. 10
E15 enter, =B15*C15
F15 enter, =ROUNDUP(D15/E15*10000,0.5)
This should take account of waste and cutting in

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19907
View this thread: http://www.excelforum.com/showthread.php?threadid=571138

 
 
S





PostPosted: Sun Aug 13 13:41:10 CDT 2006 Top

worksheet functions >> help with formula


>
> S S Wrote:
>> Based on area.
>>
>> B15 = width
>> C15 =length
>> D15 =Total sq meters
>> E15 = tile size (currently sq cms)
>> F15 = tiles required
>>
>> this is the formula I am using =D15/(E15/10000)
>>
>> What I want to do is in E15 just put in the tile size (say a 30cm
>> tile)
>> rather than sq cms and have the formula convert this to sq cms, so
>> somehow
>> need to sq the number in E15. At least that is how my brain is telling
>> me.
>>
>> thanks
> Hi S S,
>
> Always a problem working out how many tiles you need to do a job,
> depends on shape being tiled, pattern or plain tile, size of tile
>
> As tiles don't always come in squares, how about this?
> B15 enter width ie. 20
> C15 enter length ie. 30
> D15 enter sq. metres ie. 10
> E15 enter, =B15*C15
> F15 enter, =ROUNDUP(D15/E15*10000,0.5)
> This should take account of waste and cutting in
>
Old chippy I appreciate your help but its actually for tiling work in Turkey
(part of a forum of Turkish owners) and in Turkey they have square tiles or
square tiles. And I need to keep this as simple as possible for other
members to be able to use it, I will get questions like `how do I measure a
tile` I know it sounds stupid but.............