Results 1 to 2 of 2

24x7 Roster - 12h shifts - 8 staff

Threaded View

  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

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. [SOLVED] 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