+ Reply to Thread
Results 1 to 13 of 13

Employee shift roster template

  1. #1
    Registered User
    Join Date
    03-09-2006
    Location
    Australia
    Posts
    80

    Employee shift roster template

    Does anyone know of a non-commercial roster template that would suit 7 day/24 hour/4 person shifts?

    Currently we use a totally manual spreadsheet which looks like a Rubik's Cube and does not offer any form of automation in order to speed up entry adn ensure no doubling-up or missing shifts.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    39,554
    Maybe http://office.microsoft.com/en-us/te...CT101172751033. You might search that site for other relevant templates.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,159
    I don't know about doubling up or missing shifts but here's one i created a while back!

    In the grid enter the number of the person/shift that is working for days and nights (you choose either 1,2,3 or 4), fill your grid in for the year, then click on "Number Convert" at the top left of your toolbar, all the numbers will be changed to colours and the number of shifts per day per colour will be counted and displayed.

    If you want to rotate the pattern click "Pattern Change", each click will rotate the pattern around, finally to delete all of occurrences of a colour click "Delete Colour" and then choose one of the numbers supplied.

    Thats it, have fun!
    Attached Files Attached Files
    Not all forums are the same - seek and you shall find

  4. #4
    Registered User
    Join Date
    03-09-2006
    Location
    Australia
    Posts
    80
    Thanks for the responses so far; I had found the MS Office template but it is simply a "prettier" version of what we already have, so no real beneift there.

    We are going to muck around with Simon's sheet to see if that can be adapted to what we are after and leads me to perhaps claraify a bit better as to what we are trying to achieve:

    We have one shift (12 hour Day, 7 days per week shift), 4 people in the resource pool and the requirement to staff the shift with 3 people.

    Ideally the spreadsheet will have the funcionality of Simon's plus the ability to run some shift scenarios or at least some error checking to ensure that the work is spread evenly and the same shift break is applied to all.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    13,817

    Re: Employee shift roster template

    There are some great features in Outlook to do scheduling with multiple calendars.
    I know this is an Excel forum but Outlook was built for Email and Contacts and Scheduling!
    See this link for the features.

  6. #6
    Registered User
    Join Date
    05-17-2011
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Employee shift roster template

    I was looking for one.. we are 24*7 and have roaster which changes 2 months once. every day three shifts with 3 members ( total of 15 ). our leave patterns are on weekdays.
    We have 12 hrs weekend shifts...

    could you share the one that you are using..

  7. #7
    Registered User
    Join Date
    08-28-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Employee shift roster template

    Hi
    Iím a complete novice when it comes to spread sheets!

    I've moved dept. at my company, so would like to modify a 5 person (existing) to a 4 person roster.

    The roster is macro enabled; the only moving parts are (every 7 days) the days of the week and the staff names.

    If you viewed the existing roster my request would be (hopefully) self-explanatory.

    Can anyone help please?

    Rgds

    Jon

  8. #8
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,142

    Re: Employee shift roster template

    nocopj,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  9. #9
    Registered User
    Join Date
    09-12-2013
    Location
    Kenya
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Employee shift roster template

    Hi,
    Was wanting to find out if there is a roaster where in you can manage about 50 people. The operations are 24*7 and has 3 shifts namely morning afternoon and night.
    Please let me know something that can be suitable for the following scenario. Help will be appreciated!!!!

  10. #10
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,142

    Re: Employee shift roster template

    svadhera,

    Welcome to the forum.

    Please check post 8.

  11. #11
    Registered User
    Join Date
    04-06-2009
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Employee shift roster template

    Hi
    If you email (email deleted) me a copy of what you have, then I may be able to help you.... Don't forget to specify exactly what your requirements are...
    Sew
    Last edited by FDibbins; 09-07-2014 at 12:29 AM.

  12. #12
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO200;Win10/MSO2016
    Posts
    10,050

    Re: Employee shift roster template

    Sewram, It has come to our attention you have violated Rule 4 of our Forum RULES. Don't Private Message, Visitor message or email Excel questions to moderators or other members. (Or Access, Word, etc.)

    All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.

    Breaking this rule is considered harassment by most of our contributors and thus cannot be tolerated. Repeat offense could lead to permanent ban, so do take this caution to heart.

    Post your question in a public thread and our many contributors will come to you to assist, especially if the title is accurate (see Rule #1) and you include a sample desensitized workbook that makes it easy for others to try and help.

    Sewram this post is six years old!
    Ben Van Johnson

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,703

    Re: Employee shift roster template

    Sewram welcome to the forum.

    Hoe gaan dit daar in SA?

    Just wanted to point out to you that on this forum, we dont deal in emails, workbooks get posted here and the replies get posted here. The purpose of the forum is for everyone to help, and for everyone to learn - that can hardly happen if correspondence is being done through email
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

+ 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