A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How to build a rotating schedule

Thread Tools Display Modes
Old June 9th 15, 01:43 AM
Jeffatb Jeffatb is offline
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!

Old February 27th 16, 05:04 AM
wickedchew wickedchew is offline
Senior Member
First recorded activity by ExcelBanter: Aug 2010
Location: Philippines
Posts: 161


Asobi Wa Owari Da

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 01:11 PM.

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