LinkBack URL
About LinkBacks
karthikcoep 
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.
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.
can you provide a manual solution or tell your exact requirement..
Regards
CA Mahaveer Somani
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..
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.
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.
Ignore the date. If I stumble upon a good solution I like to save it and this is a good place to save it.
Last edited by Jacc; 02-12-2015 at 05:51 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks