making a shiftcalender

This looks interesting but I can't work out the details satisfactorily from your query.
Do the teams generally stick together, how are holidays covered,
Can you please explain further, possibly showing a typical cycle?
By the way its thought full to let your people sleep once every 10 days

Originally Posted by kmh31872

Hello,

I'm searching for a way to make a shiftcalender in excel.
The whole year i'm having troubles with my planning to do it in a system of my boss and i want to change this for next year.
We need to have always a minimum of 2 people on duty and when someone calls in sick i want to see in for instance a collor that the planning is corrupt and that i have to call someone else to do the shift.

I've looked several up on the net and there are many types of shiftcalenders but not the one i have in mind.

What it needs to do is;

- There are 5 teams with 3 people in it, so 15 names,
- There are 3 shifts from 06:30 to 15:00(dayshift), 14:30 to 23:00(eveningshift) and 22:30 to 7:00(nightshift
It's a 2-2-2 type of shift, that means 2 day-, 2 evening- and 2 nightshift and after the cyclus 4 days free which the first day a day to sleep.

1) How many people on duty per shift?
2) Why does a team have 3 people on it and does that mean that one person sits out if there are only 2 people on shift?

Thnx for reply.
I've put in in an example of our schedule in the post, hope you see what i mean.
The team are filled with 3 people and we are always minimum with 2 people but normaly with 3 people.
Hope yoy know how to make it easier for me to make an automatic planning.

Now we do it by hand every shift in the system of my boss and it would be so nice if everything goes automatic.