Calculating Number of Staff for Makinf a roster

[mazher]

Hi Excel Gurus,
I am stucked on this, hope someone can help

Office is open 365 days a year

Shifts run each day
Mon - Thursday
02:00 to 10:00 (3 persons in shift)
10:00 to 18:00 (3 persons in shift)
18:00 to 02:00 (3 persons in shift)

Except for Friday & saturday
02:00 to 10:00 (3 persons in shift)
10:00 to 18:00 (3 persons in shift)
18:00 to 02:00 (5 persons in shift)

No of staff duties = 67 for a week

Each person is allowed 1 day off in a week and is entitled to 14 days leave in a year.

I need to calculate the total number of staff required to cover day off in a week and the 14 days leave.

Thanks in advance.

Maz

 

[mazher]

Extremely thankful J.Ty

But I am unable to download the file.

 

[J.Ty.]

Address again:
http://www.mimuw.edu.pl/~jty/MrExcel/Mazher.xlsx

J.Ty.