Hi everyone.

I'm new around here, so forgive me if this or something similar has
been asked before (I would have done a search, but wasn't sure what to
search on!)

Please have a read of what I am trying to accomplish, and if you can
help - please do, if I'm in totally the worng area to ask this, please
point me in the correct direction.

This is what I am trying to do:

I have been asked by the powers that be to create a new work rota - the
work rota is made up from 15 people (numbered 1 - 15 for simplicity) and
the rota has to be made up a specific way, as there are 15 people, there
are 15 different work patterns (we call them cycles 1 - 15 with 15 days
in each cycle) - now this work rota has to be laid out in such a
fashion so that there employee numbers don't follow on i.e. (1, 2, 3
etc.) and also so that there is no patterm to the work rota (so a cycle
would be 1 followed by 4 then 7 and 14 then 2 etc) and no two work rotas
are the same - for example:

(emp = employee number)

Code:
--------------------

Cycle 1 Cycle 2

Day 1 emp 1 emp 4
Day 2 emp 9 emp 12
Day 3 emp 5 emp 3
--------------------



I know this sounds very complicated and I think it can be - but
what I want to know and I have little experience with Excel is can I do
this in excel and is there some sort of formula to be able to work it
out or can this sort of thing only be done manually?

If there is a formula or if anybody has a solution on how to do this, I
would be extremely grateful to them to help me solve this little
problem.

I hope I have explained what I am trying to do well enough for anybody
else to understand, if not, let me know and I'll try and explain it a
little better.

Thanks to anybody in advance who can help!


--
dataheadache
------------------------------------------------------------------------
dataheadache's Profile: http://www.excelforum.com/member.php...o&userid=27734
View this thread: http://www.excelforum.com/showthread...hreadid=472444