roster spreadsheet

Hi, Welcome to the board.

When I tackled this problem (for an out-of-hours standby rota), I used VBA.

To take this further, would need more details, i.e. min / max no of people, Do you want a 'Swaps' system to be in place, how far ahead do you want to show, any other infoneeds to be included. etc.

I'm going off work soon, so wont be able to come back to this until tomorrow AM.

Alan

There are 15 members for the dept. To ease work situation, min 4 must be on each of the 3 shifts as each individual has a specific task to do. Allowance must be made for meal breaks, sick leave and training sessions for each person. Swap system will help but it has shown to be impossible, e.g. who to swap with when the one available has his/her day off, coming on night-duty and claim-time-off hours. Tough - the roster! Grateful for assistance! I don't know any VBA - only the regular Excel formulae with more date/time kind thrown in - hopefully it suffices? Sometimes, can hardly find people to work when people take medical leaves - the dept is stranded with just 2.

Hi,

I've struggled long & hard on this one, and have come to the conclusion that the way forward is to firstly create a rota cycle. My struggle was with setting this up with what I understand to be your constraints.

As I understand it, each shift is 8 hours, and each person will work a cycle of 6 mornings, have a day free then work 6 afternoons, have 2 days free, then work 6 nights & then have 2 days free.

Below is an example of a cycle (which isnt quite right) which could then be used as a basis for the roster.

Top Left of sheet:

Top right of sheet:

I can send you the complete sheet if you PM me your email address.

HTH

Alan

PS,

Having agreed the cycle, we could then develop the roster something like, e.g.

Alan