Previous Topic Next Topic

Roster Management Spread Sheet.

Solved/Closed
ad1959 Posts 10 Registration date Thursday March 6, 2014 Status Member Last seen August 18, 2020 - Jun 21, 2016 at 07:09 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 21, 2016 at 11:57 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 21, 2016 at 11:57 AM
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
0