annalenalamprecht/coffee-partner-lottery

small project from Covid-19 times, for generating random pairings of people who can have a virtual chat and coffee together

Coffee Partner Lottery

A small project from Covid-19 times, for generating random pairings of people who can have a virtual chat and coffee together. The Python script in this repo takes care of the generation, my whole process for the lottery is as follows:

1. Let interested people sign up. I use MS Forms for the Coffee Partner Lottery at UU's Department of Information and Computing Sciences (template available here), but Google Forms or another similar tool will also do. You can download the responses and save them as a CSV file (recommended name "Coffee Partner Lottery participants.csv"), which is the input for the Python script.
2. Run the Python script to generate a set of pairs. It will store all pairs ever generated in another CSV file ("Coffee Partner Lottery all pairs.csv"), to keep track of already generated pairs and thus making sure that new people meet each time. The new set of pairs is written to a separate CSV file ("Coffee Partner Lottery new pairs.csv").
3. Use Thunderbird's MailMerge plugin to automatically generate e-mails with the information from "Coffee Partner Lottery new pairs.csv", to inform people that they have been paired. I haven't tried, but probably MS Outlook and other e-mail clients have similar functionality. Alternatively, you can just copy the list of pairs from the program output or from the file "Coffee Partner Lottery new pairs.txt" and send them to a Teams chat, group mailing list, or similar.

Other Versions

Different people have implemented variations of the same idea. Some that I am aware of:

• Et9797's extension, written in Python and using Google services for participant signup and e-mail notifications
• Barbara Vreede's Mystery Coffee, written in R

coffee-partner-lottery's Issues

Support Mail Merge Wizard of MS Word / Outlook

It would be nice to also support the Mail Merge Wizard of MS Word / Outlook. In that case the CSV output file needs to be structured slightly different, though.

Word/Outlook does not support having multiple receiver addresses per pairing. This then requires that each of the receivers of each pair gets their own record/line in the CSV file, so essentially one would have to iterate through each pair and generate multiple lines based on the number of pairing participants (2 or 3).