Easy 10-minute project. We're a nonprofit and have a retreat where people give presentations. There are 50-80 presenters every year, and each presentation is to be attended by exactly 12 different people, chosen randomly. So we need a quick program that we can run on our computer (a Dell, a Mac, whatever; our office has both) that permits us: (1) to input 50-80 four-digit numbers -- those are the participant numbers for each person, and then (2) spits out (preferably in Excel or something like that), for each participant number, 12 RANDOM participant numbers (i.e., people) who are going to listen to that participant. With the caveat that every person listens to exactly 12 other presenters and every person is listened to by 12 other people. To be clear, the draw process needs to be random; we can't just skip one number so that participant 1 gets listened to by 2-13, 2 gets listened to by 3-14, etc. It's got to be a random draw.
Hello. I can write the macros with suitable formulas (RANDBETWEEN and RAND with some constraints) in Excel which will give you the random output as you like.
Relevant Skills and Experience
Excel, VBA, Mathematics
Proposed Milestones
$100 USD - job done
There are presenters and listeners from a pool of N people. Each presenter needs 12 random listeners. Each person listens to exactly 12 random presenters. N has to be a multiple of 13.
Relevant Skills and Experience
I can develop a simple algorithm in R script for this. Very few lines of code - less than an hour of coding and testing.
Proposed Milestones
$30 USD - Will deliver code (R script within 2 hours as this is very easy to do)
What if there are 53 people (13*4+1)? The 53 rd presenter will have no listeners.