Roster Management Spread Sheet. [Solved/Closed]

Report
Posts
10
Registration date
Thursday March 6, 2014
Status
Member
Last seen
August 18, 2020
-
Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
-
Hello,

Can anyone help with a spreadsheet to manage fatigue management.
I have a work project where I need 20 people and for both day and night shifts of 12 hours each shift over a period of 40 days.
Dayshift workers can only work 10 days in row and then have 1 day off
Nightshift can work 8 nights and have 2 nights off

I have a pool of 30 workers for day shift and 30 for night shift

Any help will be greatly appreciated

Cheers
ad1959

1 reply

Posts
2757
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 8, 2021
462
Hi ad1959,

So you want us to build a spreadsheet for you?! That is beyond the scope of this forum.

Try google: "Excel Roster Management examples", to find some inspiration.

Let us know when you get stuck, but you have to make the first steps yourself.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!