Random Name Pull

Step 1:

• Your random selection plan should have been completed right before the beginning of the year, if not complete that so you can have your random plan mapped out. This will determine the number of drivers you will select each Quarter. (You can locate your submission in your Gmail)

Quarter 1: (January, February, March)

Quarter 2: (April, May, June)

Quarter 3: (July, August, September)

Quarter 4: (October, November, December)

Step 2: Consortium Spreadsheet

• Pull out your DOT group consortium spreadsheet in excel. (pull out correct year). You should be able to see how many consortium members you have.

Step 3: Random Name Pull Generator

• Have your random Name pull generator ready. Located on this page at the top. (a new tab will open for this)

Step 4: Random Name Pull Generator

• Every beginning of the quarter You will place the whole list of DOT names in the Random Name Pull Generator (List of names).

Locate the Random selection Plan for this year and place the number that was divided by twelve in the (Number of names to pick)

Drug: If your DOT spreadsheet has 200 names, 50% of that number needs to be pulled for the year for drugs which comes up to 100. You will divide 100 by 12 (number of months in a year) which is about 8.3 (round up or down). This number will be the number of names you pull each month.

Repeat for Breath Alcohol

Breath Alcohol: If your DOT spreadsheet has 200 names, 10% of that number needs to be pulled for the year for drugs which comes up to 20. You will divide 20 by 12 (number of months in a year) which is about 1.6 (round up or down). This number will be the number of names you pull each month.

Step 5: Random Selection Log

• Have your Random Selection Log ready. Located on this page at the top. (A new tab will open for this). Place the names you selected and place them in its appropriate section on the log. (repeat for Breath alcohol).

Step 6: Picking Day of the month

• You will place the numbers of days in that specific month (should be 1-31 depending on the month) in the Random Name Pull Generator (List of names). (Should be in a number list sequence)

place the number 1 in the (Number of names to pick)

This will be the day the first individual will be selected for. Repeat for all those individuals in that month. Proof check that the number does not fall on a weekend or holiday, otherwise you will need to select another number.

Step 7: Random Selection Log

• The names and Day selected will be the selection for that specific month. Continue to log it into the Random Selection Log in its appropriate section (include date next to the driver name). You will repeat these steps every month.

Step 8: Send out Notifications

• Begin to send out your random notification email. The signature email should already be pre-written. (Make changes to the email where it is necessary)

Step 9: Final Step     

• Update your excel spreadsheet with the log submitted.

Be Mindful:

Changes can occur periodically where drivers are not available or let go. The employers will need to communicate that with you, but it would have to be a valid reason (submit a Driver Consortium Action form) and so you can go ahead and select another driver.