# Create Quick Program to Draw Random Numbers

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.

( 0个评论 ) United States

## 6 威客就此工作平均出价 \$41

\$25USD 在1天里
(5条评论)
2.7
someka

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 Pro 更多

\$100 USD 在3天内
(0条评论)
0.0
Arjun5332

A proposal has not yet been provided

\$30 USD 在3天内
(0条评论)
0.0
\$25USD 在1天里
(0条评论)
0.0
AMDigitalS

A proposal has not yet been provided

\$35 USD 在3天内
(0条评论)
0.0
karpakazi

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 更多

\$30USD 在1天里
(0条评论)
0.0