+ Reply to Thread
Results 1 to 5 of 5

Randomly assigning multiple people to tasks an equal number of times

  1. #1
    Registered User
    Join Date
    02-04-2016
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    3

    Question Randomly assigning multiple people to tasks an equal number of times

    I'm working on assigning people to review student applications, and have a list of 16 people who are reviewing, and about 250 applications. Each student should be reviewed by 3 separate people, and everyone reviewing should have approximately the same number of reviews to complete:

    250 applications x 3 reviews / 16 reviewers = approximately 47 reviews each.

    This is kind of how I'm thinking of setting it up: column A has the list of students by name, and B:D will be the names of the three reviewers. I also have the names of each of the reviewers in F1:J1.

    Untitled picture.png

    And I'm hoping to have it come out kinda like this:

    Untitled picture1.png

    I've tried everything I can think of and I can't seem to figure out how to have it be random assignment, equal number of assignments for each reviewer, and also avoiding duplicate reviewers for one student. Also, that second table on the right side is just wishful thinking. I think I can figure that out using a VLOOKUP or something.

    Thank you all for any help. Sorry if this is asking for a lot.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Randomly assigning multiple people to tasks an equal number of times

    wsf INDEX is yours
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-04-2016
    Location
    Seattle, WA
    MS-Off Ver
    2016
    Posts
    3

    Re: Randomly assigning multiple people to tasks an equal number of times

    Thank you for the help! Though I'm running into an issue. I basically copied the reviewers names into column B, and the student names into column C, but when I calculate the number of reviews for each person, rn16 doesn't receive any reviews.

    Is there a way to assign them more evenly? I've tried refreshing the table to recalculate a few times, but it always ends up that some reviewers have significantly more to do than others. If not, I'm still very grateful for the help!

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Randomly assigning multiple people to tasks an equal number of times

    wrong_____________
    Attached Files Attached Files
    Last edited by tim201110; 02-05-2016 at 03:21 PM. Reason: wrong

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Randomly assigning multiple people to tasks an equal number of times

    made changes
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-20-2015, 03:10 PM
  2. Counting number of people that appear at a particular times
    By Lan Tran in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-25-2015, 07:42 AM
  3. [SOLVED] Outputting number of times if a number is equal to or greater than
    By mnarvaez99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2014, 10:51 AM
  4. Macro that generates new work sheet with people and tasks they perform
    By afniz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2013, 08:48 AM
  5. [SOLVED] Calculating the number of people in building based on arrival and departure times
    By dvs in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-01-2012, 09:45 AM
  6. [SOLVED] VBA Repeats tasks multiple times
    By djfatboyfats in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-20-2012, 06:11 AM
  7. sending outlook tasks to multiple people
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2006, 04:40 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