If you want to pull random participants from an incentive drawing that we have set up in Baseline, here are two ways to select your winners:

To pull random winners in a drawing using a website:

1.)    Go to the Results page by clicking ‘View Results’ under the ‘Results’ section on your project dashboard.

2.)    Export your data into Excel by clicking the Excel button next to ‘Detail’. Be sure that “Include All Open Ended” is checked.

3.)    Select your columns with the respondents’ drawing information in them, select “Data” in your Excel window, and click “Remove Duplicates”.

4.)    Look at the number of rows that you have, and exclude the first row because the first row includes the header row. (So if you have 90 rows, you have a total of 89 people entered into the drawing)

5.)    Go to www.random.org

6.)    Enter the number range into the generator found in to top right corner of the site. (E.g., min=2, max=89)

7.)    Click ‘Generate’

8.)    Whatever number appears is the row in your Excel file that contains the winner.

9.)    If you need to pull more than one winner, click ‘Generate’ for as many winners as you need.

 

To pull random winners in a drawing using Excel:

1.)    Go to the Results page by clicking ‘View Results’ under the ‘Results’ section on your project dashboard.

2.)    Export your data into Excel by clicking the Excel button next to ‘Detail’. Be sure that “Include All Open Ended” is checked.

3.)    In the empty column to the left of your data, assign a random number to each student by using the Random Number formula: “=RAND()”

4.)    Drag the formula down the column to create random numbers for each participant.

5.)    Select all of the columns that hold your data, including the column that you have designated for your random numbers, then select the “Sort & Filter” button on the left side of the Home Ribbon

6.)    Select “Custom Sort” from the list of options.

7.)    Sort by the column that you put your randomly assigned numbers in, sort on Values, and have the order be smallest to largest, then click Okay

8.)    This will randomly shuffle the respondents list. Select however number of winners you need from the top of the list!

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

Need More Help?

Additional Support

Powered by Zendesk