Workplace Drug Testing BLOG

In order to have a truly fair and random drug testing program, you have to be able to maintain the indiscriminate and unbiased qualities of random selection. One of the best and easiest ways to do this is to use the program Microsoft Excel to record and shuffle your list of employees for drug screening.

How Can Excel Be Used to Maintain Randomized Data?

If you are familiar with Excel you know that it can help you with creating spreadsheets for use in accounting and recording statistics. These same aspects of the program can be used to randomly select people out of a list of employees you intend to test. With the aid of a separate randomization program, Excel will help you maintain the unbiased testing pattern you are looking for.

Here’s How:

1. Open a fresh spreadsheet in Excel.

2. Enter the list of employee information either by typing it in or copy and pasting it from a separate list.

3. Save the Spreadsheet. This will be the list you’ll base the random screens on.

4. Open the randomization software (there are several available on the internet).

5. Click on the open/import tab and select your spreadsheet file. Wait for it to load. It should have imported your information into the program.

6. Now you’ll need to select a number to enter in the random controls box. If you wanted to use 50% you’d need to enter 50 and hit the limit by percent tab.

7. Click Randomize. 50% of the names on your employee list will be selected and will be put on the bottom list.

8. Click on the save list for reporting tab and save the list in a new spreadsheet. It’s best if you label it with your company name and the month and year in which you’ll be testing those employees which were selected by the randomization program. This way you know who was selected at that time and can avoid testing the same group every time

9. When you send the selected employees to the testing site and their tests results are given to you the spreadsheet you made for this month’s testing group can be opened back up. The date of testing and the results can be recorded right next to their name in the list. Not only does this help you keep a record of the results and who needs to be evaluated but it also helps you remember how long it’s been between tests for each individual. This aids in the randomization process and allows you verify if an employee has had more than one positive drug test result.

You may have more specifications you will need to make for your own randomized drug testing policy and other factors that need to be considered in the decision and randomization process. If this is the case most companies who market randomization programs are also willing to help you plan out an individual plan that works for you. Maintaining an unbiased drug screening process is an important part of sustaining a drug-free environment.