Work Rota
 

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

Work Rota
 

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

Work Rota
 

Thank you very much for your reply, really appreciate it


--
Belter
------------------------------------------------------------------------
Belter's Profile: http://www.excelforum.com/member.php...o&userid=37039
View this thread: http://www.excelforum.com/showthread...hreadid=567681

Work Rota
 

"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
---

Work Rota
 

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
------------------------------------------------------------------------
Belter's Profile: http://www.excelforum.com/member.php...o&userid=37039
View this thread: http://www.excelforum.com/showthread...hreadid=567681

Work Rota
 

"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
---