Work Rota:randomises the names

Hi

Can someone help.

I've searched the forum and google but can't seem to find what i'm looking for.

I need to do a work rota where it randomises the names in the columns and rows and in equal number.

Please see attached to understand what i mean.

I have 7 employees in total

Thanks in advance

Perhaps you might want to try this sample from my archives*:
http://savefile.com/files/5083813
Random_Scheduler_Melissa_wksht.xls
(it'll provide you some ideas to work with)

*archives link in sign-off below
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Belter" wrote:
>
> Hi
>
> Can someone help.
>
> I've searched the forum and google but can't seem to find what i'm
> looking for.
>
> I need to do a work rota where it randomises the names in the columns
> and rows and in equal number.
>
> Please see attached to understand what i mean.
>
> I have 7 employees in total
>
> Thanks in advance
>
>
> +-------------------------------------------------------------------+
> |Filename: Rota.JPG |
> |Download: http://www.excelforum.com/attachment.php?postid=5138 |
> +-------------------------------------------------------------------+
>
> --
> Belter
> ------------------------------------------------------------------------
> Belter's Profile: http://www.excelforum.com/member.php...o&userid=37039
> View this thread: http://www.excelforum.com/showthread...hreadid=567681
>
>

Thank you very much for your reply, really appreciate it

"Belter" wrote:
> Thank you very much for your reply, really appreciate it

You're welcome !
The feedback is appreciated ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

I have one more question.

Is there any way i can make the employees to equal amount of duties every week for example give them 2 slots for a particular duty.

"Belter" wrote:
> Is there any way i can make the employees to equal amount of duties
> every week for example give them 2 slots for a particular duty.

I'm not sure how/if this can be done.
You might want to take it up in a new posting.

If you want ordered schedules (not randomized),
then try this one from my archives:
http://savefile.com/files/7312953
Rotation schedule_30_names_15_weeks_paul_newusers
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---