I'm not familiar with the term "rota". Is it a Britishism? From the
context it seems to mean "work schedule" and yet it seems to be randomly
generated (or that's how I read your message). That seems a bit odd to me
in that it doesn't take into account people's availability. So is that
really what you want - 15 unique combinations of the numbers 1 to 15? Excel
can produce random numbers (pseodo-random anyway).
--
Jim
"dataheadache"
wrote in message
news:dataheadache.1wagqc_1128279902.2949@excelforu m-nospam.com...
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