+ Reply to Thread
Results 1 to 2 of 2

designing a shift rota

  1. #1
    Forum Contributor
    Join Date
    12-18-2015
    Location
    scotland
    MS-Off Ver
    MS office 365 business
    Posts
    186

    Question designing a shift rota

    Hi

    Could someone advice on any excel functions I could use that would help in designing a shift rota, any help with this would be greatly appreciated.

    Thanks
    Toddp2

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: designing a shift rota

    In Excel 2003 to 2010 there is a folder named "Samples"(a subfolder in the Office folder). In this folder there is a file "SOLVSAMP.XLS". Open this file and click tab "Staff Scheduling". There you will find an example on how to use the excel add-in Solver for staff scheduling.

    Be warned that the solver included in excel is not that powerful (by design) so the number of persons and the number of weeks will be limited.

    Alf
    Last edited by Alf; 02-20-2018 at 09:42 AM.

+ 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. Rotating Shift Rota
    By Callump01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-29-2017, 04:38 PM
  2. [SOLVED] Shift Rota - CF between two times, 24hr Shift Plan.
    By evansmike881 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-21-2016, 06:42 AM
  3. Shift Rota for work
    By crematesjay81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2015, 09:20 AM
  4. Shift rota help,
    By l3ights in forum Excel General
    Replies: 3
    Last Post: 05-23-2014, 08:31 AM
  5. Shift Rota/Calendar 5 crews Rotating Shift
    By Flynn Rider in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-07-2013, 08:03 AM
  6. problems designing a shift pattern
    By leedb1978 in forum Excel General
    Replies: 1
    Last Post: 06-21-2013, 07:21 AM
  7. Shift Rota in Excel or Access
    By John in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2006, 08:35 AM

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