LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 15, 01:43 AM
Junior Member
First recorded activity by ExcelBanter: Jun 2015
Posts: 1
Default How to build a rotating schedule


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!


  #2   Report Post  
Old February 27th 16, 05:04 AM
Senior Member
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161

Asobi Wa Owari Da

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
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
Creating a rotating schedule Michael Slater New Users to Excel 5 July 24th 07 05:48 AM
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 12:50 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017