+ Reply to Thread
Results 1 to 2 of 2

24x7 Roster - 12h shifts - 8 staff

  1. #1
    Registered User
    Join Date
    10-27-2015
    Location
    Dublin, Ireland
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    Question 24x7 Roster - 12h shifts - 8 staff

    Hi guys, I am new to the forum. Did I say hi? Hi!

    I have looked through the forums and I understand that every case should be opened in a different thread, at least for roster spread sheets, as they vary greatly from one to another.

    Basically we are 8 guys who need to work in a 24x7 schedule, 12 h per shift, 2 guys per shift, a maximum of 4 consecutive shifts and, if possible, only having to work 1 out of every 4 weekends (Sat/Sun). The amount of day shifts (08:00 - 20:00) and night shifts (20:00 - 08:00) should be assigned equally among us 8, with around a 36% of shifts being night shifts. We have already a 12 weeks rota spread sheet working for 6 (see attached) and we would like to adapt it/modify it (it does not have to be a 12 weeks rota) so we can fit 8 guys in it and with a minimum of 2 guys per shift.

    Note that in the attached spreadsheet, NOC1 and NOC2 should be treated as one (Day shift), so for instance, in Week1, Monday and Tuesday have 1 guy only during the day, Wednesday and Thursday 3 guys, Friday 2, etc.

    Thank you so much in advance for your help, any help appreciated.

    All the best,

    Nico
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-27-2015
    Location
    Dublin, Ireland
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    Re: 24x7 Roster - 12h shifts - 8 staff

    Hi again!

    I guess this is a difficult one What about changing to only 4 guys (2 of us would always work together) and 1 night shift every 3 shifts?

    Thanks a million,

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to create a staff roster....how far can I go
    By Rogeo in forum Excel General
    Replies: 6
    Last Post: 01-11-2014, 04:36 PM
  2. [SOLVED] Some shifts wont add on my staff rota weekly total
    By bigtiger1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 09:53 AM
  3. creating a staff rota for 24 hour shifts
    By RONJONES in forum Excel General
    Replies: 4
    Last Post: 09-06-2013, 12:02 PM
  4. [SOLVED] Need a formula to check shifts in a roster
    By arifmasum in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-25-2012, 01:46 AM
  5. [SOLVED] Staff Roster
    By BlueHuman in forum Excel General
    Replies: 3
    Last Post: 03-28-2012, 05:09 AM
  6. Shift roster for 3 shifts
    By shivaraj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2011, 06:35 AM
  7. Roster / Staff Allocation
    By KingAaron in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 08-13-2006, 09:40 PM
  8. I need a simple staff roster
    By Delma McDonald in forum Excel General
    Replies: 3
    Last Post: 03-09-2006, 03:55 AM

Tags for this Thread

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