Help required on shift roster

[think say]

Hi All,

I am trying to prepare shift roster for 24/7 support (weekly rotational shift). But I am not able to create roster as per below requirement. Can you please help to add 8 resources for 24/7 support in the attached xls file. Thanks in advance.

Number of Resources: 8
working hours: 9 hours for one resource
Number of shifts : 3 (morning, afternoon & Night)
Number of resources in each shift: 2
During weekend (Sat & Sun): one resource in each shift instead of 2

 

[earthworm]

Try this

Click here to download sample

 

[think say]

Try this

Click here to download sample

Thank You @earthworm . Still I am not able to create 24/7 shift roster for entire month for 8 resources due to my limited knowledge on xls. Could you please share sample 24/7 roster for all 8 resources for one month support (Nov 1 - Nov 30, 2021).

Re-sharing inputs:
Total resources: 8
Mon to Fri - 2 resources in each shift (2 in M, 2 in A, 2 in N)
On Sat & Sun, one resource in each shift (1 in M, 1 in A, 1 in N)
Weekly rotational 24/7 support

Thanks in advance.

 

[earthworm]

simply extend the ranges to suit your requirement.

 

[think say]

Thanks again for your quick reply. Tried to extend ranges, still i am not able to cover resources in attached file as per my requirement. Can you plesae review the file and help with updated file.

Copy of Roaster.xlsx | Powered by Box

app.box.com

 

[think say]

Can someone help please ?