Results 1 to 5 of 5

Distribute People across Teams to balance strength/points

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    Bangalore
    MS-Off Ver
    2013
    Posts
    2

    Distribute People across Teams to balance strength/points

    Hi All,
    I searched for my requirement a bit but could not find anything specific or something that i could work on. Hence, posting this query.

    I have a list of people(say 100) with different points per person.
    I need to divide them to different teams where in, the number of people and points and balanced to the best possible limit.
    I've a file with sample data for your reference.

    The number of people, points and the number of teams are variable.

    If there is a way where i can do initial padding ( strengthen a team beforehand) and then divide, that would be great. Eg: Adding more people and points to a team

    Please help me. I am tired of doing this manually!

    Regards,
    hrshv
    Attached Files Attached Files
    Last edited by hrshv; 03-15-2017 at 04:44 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 08-11-2017, 08:47 PM
  2. Replies: 2
    Last Post: 01-06-2017, 05:20 AM
  3. Replies: 6
    Last Post: 10-04-2014, 03:53 PM
  4. Ranking teams in order based on points
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-17-2014, 11:41 AM
  5. How can I distribute the balance data to the following date randomly.
    By sasgapatan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2012, 04:21 AM
  6. trying to distribute evenly between number of people
    By magleremm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2012, 09:41 PM
  7. Grouping people into teams and then identifying strategies
    By t0m in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2011, 03:25 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