My office has baseball season tickets for Business Development purposes. Every so often, we have games that aren’t reserved for BD, so we raffle them off for the employees. Before I got here, the raffle coordinator would actually conduct a raffle… printing out each person’s name on a strip of paper, folding it up, putting it in a hat and drawing a winner. What a waste of time! This is so much faster. And since most of our employees aren’t in the main office any way, it doesn’t matter how a winner is selected (just as long as it’s random).
Here’s how we do raffles in Excel now:
1. Set up the list of names in Excel. All the names should be in one column.
2. Go to Random.org and use the sequence generator to generate a squence of numbers in one column:
