G Guest Jul 29, 2006 #1 i am trying to come up with a eight man rotating schedule without working long stretches without a day off. Thx Brad
i am trying to come up with a eight man rotating schedule without working long stretches without a day off. Thx Brad
V VBA Noob Jul 29, 2006 #2 Need to post more info than that e.g What's the length of day ?? Whats a long stretch in your view ?? How many on per day ?? What cells VBA Noob
Need to post more info than that e.g What's the length of day ?? Whats a long stretch in your view ?? How many on per day ?? What cells VBA Noob
G Gord Dibben Jul 29, 2006 #3 Would this be a 24/7 operation? 8 hour shift? 12 hour shift? How many hours a week per person? What is the averaging period? 28 days? 8 weeks? Have a look at this site to get an idea of how to work with some of the above and other parameters. http://www.shift-work.com/shift-schedules/ See some sample schedules when you scroll down to bottom of page. Gord Dibben MS Excel MVP
Would this be a 24/7 operation? 8 hour shift? 12 hour shift? How many hours a week per person? What is the averaging period? 28 days? 8 weeks? Have a look at this site to get an idea of how to work with some of the above and other parameters. http://www.shift-work.com/shift-schedules/ See some sample schedules when you scroll down to bottom of page. Gord Dibben MS Excel MVP
