Random Drug and Alcohol Testing
Program Set-Up Tutorial
Random Drug and Alcohol Testing Program Really Basic Set-Up
Don't forget to check out our video that shows how The Randomizer works (view full screen) here!

Okay, you need to set up a random drug test program quickly and you have no idea where to start. It's okay, relax and follow this tutorial; we'll walk you through the steps you need to take to get your random drug screening program up and running quickly. Before you start, there are a few things you'll need:

First, open up a blank spreadsheet and populate it with employee information, if you were sent a list of employees via email or were provided a list in document form, you can simply cut and paste it into a spreadsheet. It should look something like this:

After you're done, save the spreadsheet - this will be your master employee list.

Next, open up your randomization or random selection software program and click on the "Open/Import" button; point to your spreadsheet in the open file dialog box.

Your data will now be in the program - the interface should look something like the graphic below.

Next, simply type a number in the random controls box - for example, for 50% select the "Limit by Percent" button and type "50" into the box - then click on "Randomize".

Fifty percent of the names from your spreadsheet will be selected at random and placed in the bottom list.

Finally, click on "Save List for Reporting" and save your list as a new spreadsheet. We recommend you save it with a name such as "ABC Company Randoms QTR1 2015", that way you'll have a record of who was drawn in March of 2015. After you send the personnel on the randomized list to your local clinic for testing, simply open up your random list in Excel and note next to each name their test date and test results. This gives you a record of who was tested and when. Make sure to save your lists throughout the year so you will have a record of who was tested and when. These records will help you fill out your required MIS form and keep you prepared for an audit.