Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default How to build a rotating schedule

Hi!

I'm looking for some help. I have 10 employees who share 40 job duties. Currently each employee does 4 per week and rotate to the next duties. So by the time the person doing job duty #1 gets back to #1 it's 10 weeks later and they often forget that duty or new employees severely struggle.

As a result I am trying to redesign how they do their work. I want to pair them and make "buddy groups" and so that would make 5 job rotations with 8 job duties each. I don't want the duties to rotate (they will stay as fixed job duty groups, #1, #2, #3, #4 and #5). However after every complete cycle, I want the "buddies" to rotate.

And I want to build it all in Excel. I have never built a schedule like this in Excel so don't really know how to start even. Ideally I'd like to see it come out as an annual spreadsheet so people can see in advance what they will be assigned and with who.

Any ideas? Can anyone help me get this created?

Many thanks!

Jeff
  #2   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Perhaps:

http://www.excelbanter.com/showthread.php?t=265419
__________________
Asobi Wa Owari Da
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a rotating schedule Michael Slater New Users to Excel 6 April 23rd 23 09:03 PM
3 hour rotating schedule icutey2 Excel Discussion (Misc queries) 0 April 25th 10 05:15 AM
Rotating on-call schedule M-F for 13 people? SUZAG Excel Discussion (Misc queries) 0 July 22nd 08 02:34 PM
Creating a Rotating Schedule lohende Excel Discussion (Misc queries) 0 July 24th 07 09:56 PM
Macro for a Rotating Shift Schedule smck Excel Programming 0 October 25th 05 04:12 AM


All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"