+ Reply to Thread
Results 1 to 5 of 5

Distribute Tasks Evenly

  1. #1
    Registered User
    Join Date
    12-20-2008
    Location
    Mumbai
    MS-Off Ver
    Microsoft Office 2003 and 2007
    Posts
    36

    Distribute Tasks Evenly

    I have 8 people. They have to do certain tasks contained in a folder. There are 62 folders in all each containing different number of tasks. I have to distribute the folders so that each of them gets nearly the same number of tasks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: Distribute Tasks Evenly

    can you provide a manual solution or tell your exact requirement..

    Regards
    CA Mahaveer Somani

  3. #3
    Registered User
    Join Date
    12-20-2008
    Location
    Mumbai
    MS-Off Ver
    Microsoft Office 2003 and 2007
    Posts
    36

    Re: Distribute Tasks Evenly

    Manual solution would be to find average number of tasks and them play around with the number of tasks in each folder till I get folders set with numbers close to average..

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Distribute Tasks Evenly

    Old post, yes. I found this task rather difficult but somehow intriguing. Played around with numbers and data and waiting for an idea to pop up. Suddenly it did! A simple but very efficient formula. Concept is simple, the one with the least points gets the next task down the list, the list being sorted big to small.
    I certainly hope you are still around, karthikcoep, because I think the result turned out really well.

    Just to test the algorithm I added a scramble function on a new sheet. Even with scrambled data the results are usually acceptable but not as good as the sorted solution.
    Attached Files Attached Files
    Last edited by Jacc; 03-09-2013 at 03:33 PM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  5. #5
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Distribute Tasks Evenly

    Ignore the date. If I stumble upon a good solution I like to save it and this is a good place to save it.
    Attached Files Attached Files
    Last edited by Jacc; 02-12-2015 at 05:51 AM.

+ 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