+ Reply to Thread
Results 1 to 3 of 3

Randomly assigning pairs of reviewers to a list of files

  1. #1
    Registered User
    Join Date
    05-21-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Randomly assigning pairs of reviewers to a list of files

    Hi,

    I have a list of about 600 files and each file needs to be assigned to two reviewers. There are 20 reviewers total, so each reviewer needs to be assigned about 60 files to review. The reviewers cannot be in permanent pairs. In other words, I cannot have Reviewer A always reviewing the same files as Reviewer B. The goal is to have different pairs randomly assigned reviewing the different files.

    Does anyone know of a formula or other Excel solution that could help me assign the reviewers so that each file is assigned a random pair of reviewers and all the reviewers receive an equal number of files to review?

    Thanks,

    Alyssa

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Randomly assigning pairs of reviewers to a list of files

    For 20 reviewers there are 190 unique combinations. I have them listed in the attached file. The second file has the combinations randomized.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Registered User
    Join Date
    05-21-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Randomly assigning pairs of reviewers to a list of files

    Thanks for making these files. They are very helpful!

+ 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