Results 1 to 9 of 9

Optimal task time scheduling and assigment problem - Excel Solver

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2011
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2019
    Posts
    90

    Optimal task time scheduling and assigment problem - Excel Solver

    I'm trying to resolve an assigment problem using Excel solver.

    I have a number of task that each takes a number of days to complete.
    I have a number of person to do the tasks. Each takes the same amount of time to resolve the tasks.

    There are the following constraints:
    - each task has to have 2 persons assignet to it
    - each person has to be assigned a total time of 40 days

    In theory the solution is something like this:
    - Persons 1 and 2 to work on Tasks 1 and 3
    - Persons 3 and 4 to work on Tasks 2 and 4
    - Persons 5 and 6 to work on Task 5

    I want to add an extra constraint regarding the Persons and how to assign them together. There are 3 types of Persons: Leader, member and newbie. The constraints would be:
    - two Leaders cannot work on the same task
    - two newbies cannot work on the same task.
    All other combinations are possible: Leader and member, Leader and newbie, member and member, member and newbie.

    Extra: for the Time Assigned range is there a better way to write the sum function?

    This part is already solved, please take a look at post #6. I'm looking for a solution to optimal schedule the tasks as the first step before the people assigment.
    Attached Files Attached Files
    Last edited by ciprian; 12-29-2020 at 10:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 12-31-2016, 12:29 PM
  2. Problem Using Solver with an optimization stock problem
    By Jagrubski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2013, 03:41 AM
  3. Rotation Assigment to New Clients
    By basketballrats in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-28-2012, 08:40 AM
  4. OnAction macro assigment through a macro in network environment behaves strange
    By kbx17 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2012, 02:22 PM
  5. Assigment assistance (need ideas)
    By jermaindefoe in forum Excel General
    Replies: 7
    Last Post: 02-18-2008, 12:50 PM
  6. Interesting Solver problem (Solver encounters an error)
    By MrShorty in forum Excel General
    Replies: 3
    Last Post: 12-22-2005, 06:55 PM

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