Find Jobs
Hire Freelancers

Create Quick Program to Draw Random Numbers

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 15377901

About the project

6 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $41 USD for this job
User Avatar
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
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 11, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.