RE: [OT] Tiling

["Mick Furlong" <dorsai@xxxxxxx>]

wow a question I can answer ;)

stick the folowing formula in an excel spreadsheet and copy it to the
number
of rows/ columns you need it will give you numbers 0-3 which you can map to
each tile...might be possible to set it to show the colours let me try it
;)

yup it works!

formuala is =INT(RAND()*4) paste/drag it into each cell you want to be a
tile

then use conditional formating to set the tile colours depending on the
number...if you do a recalculate you get a  new random pattern ;)

if anyone wants the spreadsheet I will post it.

Mick




> -----Original Message-----
> From: Steve Cooper [mailto:steve.cooper@xxxxxxx]
> Sent: 02 August 2001 17:41
> To: ukha_d@xxxxxxx
> Subject: [ukha_d] [OT] Tiling
>
>
>
> Folks
>
> Not HA but the kitchen needs tiling following rewiring so slightly
linked.
>
> Situation: SWMBO wants a combination of four 2" tiles (cream,
> yellow, green
> and terracotta) in a random pattern in the wall.
>
> Problem: How to get a random looking pattern, I'm sure you can get a
grid
> or program to generate this sort of thing for you but can't find any
> details.  Anyone know or know where to look?
>
> Cheers
>
> Steve
>
>
>
>
> ____________________________________
> Automated Home UK
> http://www.automatedhome.co.uk
> ____________________________________
>
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>



____________________________________
Automated Home UK
http://www.automatedhome.co.uk
____________________________________

Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/