Safety & Compliance · Excel template
Free Random Drug & Alcohol Selection Log
A log of the random selections themselves under 49 CFR 382.305 — pool size, selection date, method, who was drawn, and the rate against the minimum.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- One row per selection period with the pool count, the selection date, and the method used
- Separate counts for controlled substances and alcohol, because 382.305(b) sets a different minimum rate for each
- An average-driver-positions calculation following the 382.305(j)(1) method rather than a headcount snapshot
- A notified-date and tested-date pair, so you can see whether 382.305(i)(3) was actually met in the period
- A spread-of-dates view against 382.305(k)(2), which is where a carrier doing all its selections in December gets caught
- A C/TPA column for the pool and rate you are relying on a service agent to maintain
How to use it
- 1
Count the covered drivers eligible for testing in the period and record it — all covered drivers must be in the pool, and only covered drivers may be.
- 2
Record who performed the selection and by what method; 382.305(i)(1) requires a scientifically valid one, such as a random number table or a computer-based generator matched to payroll or other comparable identifying numbers.
- 3
Log the drivers drawn, split by controlled substances and alcohol, and the date each was notified.
- 4
Log the date each test was completed. 382.305(i)(3) requires every driver selected to be tested during the selection period, so a selection carried into the next period is a defect, not a backlog.
- 5
Work out the year's average number of driver positions by adding the covered drivers eligible in each period and dividing by the number of periods, then check your cumulative rate against the current published minimum.
- 6
Review the selection dates across the year before the year closes — 382.305(k)(2) requires them spread reasonably throughout the calendar year.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
Random Drug & Alcohol Selection Log
The minimum annual rates in 382.305(b) are 50% of average driver positions for controlled substances and 10% for alcohol, but 382.305(c) through (h) let the FMCSA Administrator change either — a new rate is published in the Federal Register and applies from 1 January of the following calendar year. Confirm the rate in force for the year you are testing rather than taking the figures below as current. Selection records are confidential: 382.401(a) requires a secure location with controlled access.
| Selection period | Covered drivers in pool | Selection date | Method / performed by | Selected — controlled substances | Selected — alcohol | Notified | Tested in period | Cumulative rate |
|---|---|---|---|---|---|---|---|---|
| 2026 Q1 | 48 | 2026-02-11 | RNG matched to payroll ID — S. Patel | 6 | 1 | 6 / 1 | 6 / 1 | 12.5% CS, 2.1% alc |
| 2026 Q2 | 52 | 2026-05-06 | RNG matched to payroll ID — S. Patel | 7 | 2 | 7 / 2 | 7 / 2 | 26.0% CS, 6.0% alc |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
A testing log records tests and their results, across all six 382 reasons. This records the selection event — the pool you drew from, the date, the method, and who came out. They are different evidence: a testing log shows that tests happened, and a selection log shows that the drivers tested were chosen the way 382.305(i) requires and at the rate 382.305(b) requires. An auditor asking how you reached your rate is asking for this one.
49 CFR 382.305(b) sets 50 percent of the average number of driver positions for controlled substances and 10 percent for alcohol. Both are floors that move: 382.305(c) through (h) let the FMCSA Administrator raise or lower either based on the industry-wide positive or violation rate drawn from the § 382.403 reports, and a changed rate is published in the Federal Register and takes effect on 1 January of the following calendar year. Check the rate in force for the year you are testing — do not carry a number forward from an old policy document.
382.305(j)(1) gives the method: add the total number of covered drivers eligible for testing during each random testing period in the year, then divide by the number of random testing periods. It is an average across periods, not a headcount on one date, which matters for any fleet whose driver count moves seasonally. If you test more often than monthly you do not need to compute it more than once a month.
No. 382.305(j)(2) permits a service agent to perform the selections and permits your drivers to sit in a larger combined pool, but it puts two duties on you regardless: ensuring the agent is testing at the percentage established for your industry, and ensuring only covered employees are in the pool. Both are things you have to be able to evidence, which means keeping your own record of what the agent did on your behalf.
382.305(i)(3) requires each driver selected to be tested during the selection period, so carrying a selection over is a compliance gap rather than a scheduling one. 382.305(l) is what makes that workable in practice: a driver notified of selection must proceed to the test site immediately, and if they are performing a safety-sensitive function other than driving a CMV, they must stop and go as soon as possible. A log that shows notification and completion dates side by side is what surfaces the ones that slipped.
§ 382.401(c)(1)(ii) lists documents relating to the random selection process among the records related to the collection process, and § 382.401(b)(2) sets a minimum of two years for those. § 382.401(b)(1)(vi) separately sets five years for records related to the administration of the testing programme, which is why many carriers keep selection documentation for five rather than two. Either way 382.401(a) requires it held in a secure location with controlled access.
Related guides & tools
- DOT Drug & Alcohol Testing Log
- FMCSA Clearinghouse Query Log
- Driver Investigation History File
- Driver File Audit Checklist
Looking for more? Browse all fleet templates or run a fleet calculator.