+ Reply to Thread
Results 1 to 6 of 6

Help in creating staff rota

  1. #1
    Registered User
    Join Date
    05-19-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    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. #2
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    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
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.

  3. #3
    Registered User
    Join Date
    05-19-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help in creating staff rota

    Quote Originally Posted by Russell Dawson View Post
    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. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,135

    Re: Help in creating staff rota

    Googling for "staff rota template free" brought up about 1.5 mio answers
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  5. #5
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    604

    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.
    Last edited by Russell Dawson; 05-20-2012 at 08:00 AM. Reason: Clarity

  6. #6
    Registered User
    Join Date
    05-19-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Help in creating staff rota

    Quote Originally Posted by Russell Dawson View Post
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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