+ 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
    155

    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)

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