Staff Rota Template?

Discussion in 'Microsoft Excel Programming' started by Steve Davies, May 19, 2006.

  1. Steve Davies

    Steve Davies Guest

    Hi

    I am trying to design a staff duty rota template for a shop open 7 days per
    week. We have between 4 ­ 6 staff (depending on seasonal fluctuations) and
    each member of staff has two days off per week.

    I have searched the Microsoft database of templates and found nothing that
    will allow me to input staff names and then automatically assign staff to
    the rota in a fair and even way. Is this beyond the capabilities of Excel?
    It¹s certainly beyond the capability of my tiny pea brain to programme it!

    If anyone can help I¹d be really grateful. I¹d like to be able to create a
    spreadsheet that lets me input shop opening and closing hours (these change
    seasonally, too), input names of the staff on the books, and then give me a
    rota that stretches 3-months ahead...

    Any tips or advice gratefully received!

    Cheers

    Steve
     
    Steve Davies, May 19, 2006
    #1
    1. Advertisements

  2. Steve Davies

    Guest Guest

    There is no built in functionality to support this.

    I would suggest you search Google for Rota or Scheduling shifts.

    http://www.google.com

    I am sure there are some free ware or inexpensive applications that will
    give you much more than you could come up with using Excel.

    --
    Regards,
    Tom Ogilvy


    "Steve Davies" wrote:

    > Hi
    >
    > I am trying to design a staff duty rota template for a shop open 7 days per
    > week. We have between 4 ­ 6 staff (depending on seasonal fluctuations) and
    > each member of staff has two days off per week.
    >
    > I have searched the Microsoft database of templates and found nothing that
    > will allow me to input staff names and then automatically assign staff to
    > the rota in a fair and even way. Is this beyond the capabilities of Excel?
    > It¹s certainly beyond the capability of my tiny pea brain to programme it!
    >
    > If anyone can help I¹d be really grateful. I¹d like to be able to create a
    > spreadsheet that lets me input shop opening and closing hours (these change
    > seasonally, too), input names of the staff on the books, and then give me a
    > rota that stretches 3-months ahead...
    >
    > Any tips or advice gratefully received!
    >
    > Cheers
    >
    > Steve
    >
    >
     
    Guest, May 19, 2006
    #2
    1. Advertisements

  3. Steve Davies

    Steve Davies Guest

    OK, thanks Tom.

    On 19/5/06 17:27, in article
    , "Tom Ogilvy"
    <> wrote:

    > There is no built in functionality to support this.
    >
    > I would suggest you search Google for Rota or Scheduling shifts.
    >
    > http://www.google.com
    >
    > I am sure there are some free ware or inexpensive applications that will
    > give you much more than you could come up with using Excel.
     
    Steve Davies, May 19, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    make a staff rota in excel

    Guest, Jun 6, 2005, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    607
    Guest
    Jun 6, 2005
  2. Guest

    Shift Rota in Excel or Access

    Guest, May 30, 2006, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    324
    Guest
    May 30, 2006
  3. DB

    Problems with my Work rota set-up

    DB, Nov 23, 2006, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    190
  4. Steve

    Rota cycle

    Steve, Mar 11, 2007, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    256
    Steve
    Mar 12, 2007
  5. Guest

    Staff Capacity Plan Template

    Guest, Mar 13, 2007, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    6,868
    Guest
    Mar 13, 2007
Loading...

Share This Page