ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How to build a rotating schedule (https://www.excelbanter.com/new-users-excel/450927-how-build-rotating-schedule.html)

Jeffatb June 9th 15 01:43 AM

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

wickedchew February 27th 16 05:04 AM

Perhaps:

http://www.excelbanter.com/showthread.php?t=265419


All times are GMT +1. The time now is 02:50 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com