Skip to main content

Assign reviewers and create scoring excel sheets.

Project description

test status publish pypi PyPI version License: MIT


Very simple script to randomly assign reviewers and create scoring sheets.


pip install assign-reviewers

How to use

  1. Start from an Excel or Google sheet. Each row corresponds to a submission. Columns are organized as per this example CSV file.

  2. Export the sheet into a CSV file. For this example, let's use this example CSV file.

  3. Run:

assign-reviewers -c form.csv -r Anna -r Elsa -r Christophe -r Sven -n 2

This will generate four CSV files, each containing an additional column with the name of the reviewer.

  1. Send individual CSV file to the corresponding reviewer.

  2. Each reviewer uploads the CSV on Google Sheet: File > Import, then click "Upload", drag & drop the CSV file, and click "Import data". The listed submissions can then be graded/ranked as shown below:

    Alt text

  3. Each reviewer shares their Google Sheet with you, and you can simply copy the reviewer column and append it to the main Google Sheet document. Then, a row-wise summation can easily be done.

More complex usage

The software can also ignore reviewers if their affiliation match that of a submitter. Below is an example:

assign-reviewers -c form.csv -r Anna -a "Chiang Mai" -r Elsa -a UBC "British Columbia"

In this example, the reviewer Elsa has the affiliations {'UBC', 'British Columbia'}, and if these are found in the affiliation of the submitter, then this reviewer will not be assigned.

Got any problem?

Please open an issue

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

assign-reviewers-0.2.1.tar.gz (4.0 kB view hashes)

Uploaded source

Built Distribution

assign_reviewers-0.2.1-py3-none-any.whl (5.4 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page