Kellogg Board Fellows Matching Tool

This is a tool for the Kellogg Board Fellows program to optimally match students to board fellowships based on their ranked preferences (using the Hungarian algorithm). Fully client-side in the browser, using web workers API to perform computation asynchronously.

Using:

• Vue.js + Vue Router + Vuex
• Vuetify for UI
• Web Workers API
• munkres-js - Munkres (Hungarian) algorithm implementation for Javascript

Currently (Januaary 16, 2023) hosted here: https://kbfoptimizer.apps.kellogg.northwestern.edu/

How To Use It

It is a bit wonky in terms of the process, but it’s essentially:

1. Export the results from Qualtrics as a CSV.
2. Open the CSV on Excel.
3. Select all cells and copy.
4. Open this Qualtrics Converter page (http://kbfmatcher.kellogg.work/qualtrics) and paste into the “Qualtrics Input (CSV)” text area.
5. Scroll down to the “Rankings Matrix Output (CSV)”, select everything in that text area, and copy.
6. Open the main Optimizer page (https://kbfoptimizer.apps.kellogg.northwestern.edu/)](https://kbfoptimizer.apps.kellogg.northwestern.edu/) and paste into the “CSV/TSV of Student Rankings of Companies”.
7. Press the “FIND ASSIGNMENTS” button.
8. The assignments will show below in a table, along with a download link to a new CSV with the assignments there. The name of the CSV file indicates the average ranking of the matches, with the closer to 1 meaning more people got their first choice or very close to it.

I separated out the Qualtrics parsing function from the optimizer function in case the Qualtrics format ever changes in a way that would break the whole process. If Qualtrics changes, then worst case scenario you could still manually extract the results and make a new CSV spreadsheet following the form indicated in the Optimizer help:

If you copy the fake data it generates out of this text area, you can paste it into an Excel spreadsheet, do the Data > Text to Columns function with commas selected as the delimiter, and you’ll get an idea of the matrix form. Modify with the real company names, students, and rankings, and you’d be able to paste this back into the optimizer for calculation.

Project setup

npm install

Compiles and hot-reloads for development

npm run serve

Compiles and minifies for production

npm run build

Lints and fixes files

npm run lint

Customize configuration

See Configuration Reference.

Docker Commands

Until the docker image is avaiabile on dockerhub, the image is created locally.

Clone the repo and cd into the root directory. Run

docker build --tag kbfoptimizer .

To run / deploy run

docker compose up