# Help in creating staff rota

1. ## Help in creating staff rota

Hi - am a beginner in Excel and need to create a rota that covers three members of staff working 5 days a week with 2 consecutive days off trying to give them a fri and sat or a sun and mon off, so that every other week they get off a week end (being fri/sat or sun/mon)

Can anyone help me with this please?

2. ## Re: Help in creating staff rota

Hi and welcome to the forum. With the resource that you have it will be difficult but please answer these questions.

1. What is the minimum staff attendance requirement. i.e. Is one sufficient?

2. How many consecutive days can a member of staff be required to work?

3. How do you propose to cover holidays?

Thanks

Russell

3. ## Re: Help in creating staff rota

Originally Posted by Russell Dawson
Hi and welcome to the forum. With the resource that you have it will be difficult but please answer these questions.

1. What is the minimum staff attendance requirement. i.e. Is one sufficient?

2. How many consecutive days can a member of staff be required to work?

3. How do you propose to cover holidays?

Thanks

Russell
Hi

1. Minimum staff attendance requirement is two.
2. Staff are required to work 5 consecutive days i.e. if one staff member has Fri/Sat off then they will start work again on the Sunday.
3. Only staff member at a time can take holidays.
4. The place of work is a stables which runs 7 days a week.

Hope you can help as I am at a loss of how to do this!

4. ## Re: Help in creating staff rota

Googling for "staff rota template free" brought up about 1.5 mio answers

5. ## Re: Help in creating staff rota

Doubt whether it's mathematically possible given your requirements. You'd possibly have to consider a working week of five, six or seven consecutive days with time off at three or four days at a time. Perhaps you will be able to find a template as Pepe Le Mokko is suggesting.

Whilst Excel is great for graphically showing rotas like this it's not an Excel question that has been posed really. I obviously stand to be corrected. There are members who have a wide range of knowledge and it's probably best to see if there is anyone who can help during the week. It's quiet at weekends and the big guns usually trawl the forum during the working week.

Looks like you'll be mucking out more than you had planned for! Good luck.

6. ## Re: Help in creating staff rota

Originally Posted by Russell Dawson
Doubt whether it's mathematically possible given your requirements. You'd possibly have to consider a working week of five, six or seven consecutive days with time off at three or four days at a time. Perhaps you will be able to find a template as Pepe Le Mokko is suggesting.

Whilst Excel is great for graphically showing rotas like this it's not an Excel question that has been posed really. I obviously stand to be corrected. There are members who have a wide range of knowledge and it's probably best to see if there is anyone who can help during the week. It's quiet at weekends and the big guns usually trawl the forum during the working week.

Looks like you'll be mucking out more than you had planned for! Good luck.
Thanks anyway

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1