+ Reply to Thread
Results 1 to 2 of 2

Help with random schedule creation

  1. #1
    Registered User
    Join Date
    11-26-2019
    Location
    Orlando, USA
    MS-Off Ver
    2016
    Posts
    1

    Help with random schedule creation

    Hello everyone, I'm very new to Excel, to be honest only recently started to learn how powerful it can be, I was wondering if I could use it for something I do constantly. Here is the scenario

    On the weekends we have 4 engineers working on Sat and Sun, two on the east coast and two on the west. The team is about 49 people, that need to be divided through the year evenly as possible, considering their physical location. We have 28 people on the east and and 21 on the west.

    1. On Sat we have one permanent eng(West coast), so I have to fill 3 spots, two east one west.
    2. On Sun we have two permanent eng (One East and one West) so I have to fill 2 spots, one for each coast.

    Is that something that can be accomplished, take the list and evenly distribute people throughout the year? I'm attaching an example of how it looks like.

    Thanks in advance for any help!
    Rafael
    Attached Files Attached Files

  2. #2
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    177

    Re: Help with random schedule creation

    Hi,

    I couldn't think of a way of not repeating when randomizing,

    This is the best I've got
    Attached Files Attached Files
    John.

    "I excel at jumping to conclusions"

+ 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. [SOLVED] Creation of production schedule (staggered distribution)
    By ISMI in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2017, 02:14 PM
  2. Crew Schedule Creation
    By BADebbie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2015, 02:13 PM
  3. [SOLVED] Logical Formulas for Schedule Creation
    By statica in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-01-2013, 11:43 AM
  4. Creation of a function for random numbers with some conditions
    By dmojica2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2013, 10:46 PM
  5. Rota creation, Job Type vs. 2 shift work schedule
    By Ponderatul in forum Excel General
    Replies: 0
    Last Post: 08-20-2012, 07:02 AM
  6. Replies: 13
    Last Post: 01-15-2006, 01:15 PM
  7. [SOLVED] More work schedule creation trouble
    By Paul in forum Excel General
    Replies: 4
    Last Post: 12-11-2005, 01:10 PM

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