Results 1 to 8 of 8

Grouping People On Preference

Threaded View

  1. #7
    Registered User
    Join Date
    09-14-2018
    Location
    China
    MS-Off Ver
    Office 2010
    Posts
    41

    Re: Grouping People On Preference

    Dear,

    I'd like to provide a linear programming idea here by using 30 students & 5 groups.

    It is recommended to use an open source solver named "Open Solver".
    The decision variables are : Xij, assign student i in group j.
    The typical constraints are:
    1) each student is assigned in only one group.
    2) each group containts 6 students(30 students in 5 groups).

    To apply the preference constraints, typically there are two methods:
    1) multiply the assignment choice for the two students, sum up and then maximize it. For example, if the 2 students are in the same group, that the two students will have a score of 2, if not in the same group, the score will be 0. This will force Solver to put the two students in the same group. This is a nonlinear programming - Because the two variables are multiplying with each other.
    2) use minMax method, introduce a set of binary variables, Ytj
    Ytj >= Xnj - Xkj, and then minimize Sum of Wj*Ytj, Wj is the weight we set, which is constant.
    This is a linear programming.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help grouping 12 people into 4-somes.
    By greyfoxx12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2012, 11:27 PM
  2. [SOLVED] Grouping people and images.
    By HakanF in forum Excel General
    Replies: 4
    Last Post: 04-16-2012, 04:54 AM
  3. 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
  4. Grouping and Subtotaling by List of People
    By carl83 in forum Excel General
    Replies: 1
    Last Post: 05-20-2011, 01:37 PM
  5. Preference Sorting
    By jamesvenning in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2010, 03:51 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