You can run a random draw in a spreadsheet, and plenty of small carriers do. The draw is the easy part. Proving it afterward is where spreadsheets get shaky.
49 CFR 382.305(i) requires a scientifically valid selection method, such as a computer-based random number generator, with an equal chance for every driver in the pool each time selections are made. It does not say what tool to use. A random function in a spreadsheet can satisfy it, as long as it is applied to the right list.
| Spreadsheet | DTSMS Online | TPA or consortium | |
|---|---|---|---|
| Cost | Free, plus your time | $5 / $4 / $3 per driver per month, first selection free | Coordination fees, set by the provider |
| The draw | Random function you build and check yourself | Computer-generated, sized to your rate | Run for you |
| Pool on the day | You save a copy, or you don't | Captured and locked at the draw | Provider keeps it; you ask for it |
| Edits after the fact | Anyone with the file can change it | Selection record cannot be edited | Depends on the provider |
| Notification times | Typed in by hand | Timestamped | Depends on the provider |
| You still own | Everything | The roster and the follow-through | Checking the percentage and the pool list |
If you have a handful of drivers and a careful person who saves a dated copy of the pool and the result every time, a spreadsheet is workable. The trouble starts when the person leaves, the file gets reused, or an audit asks you to show the pool exactly as it stood on the draw date. At that point you are rebuilding the past from memory.
Software moves the record-keeping off your plate. A TPA moves the whole job off it, and you pay for that. Most small carriers sit between the two and want the draw and the record without the coordination fee. See how a recorded selection works, or compare it with your current process in how it works.
Whatever you use, the timing rules still apply once a driver is picked. Read about random test time limits and what happens when a driver does not show.
49 CFR 382.305(i) requires a scientifically valid method, such as a random number generator, where every driver in the pool has an equal chance each time. The rule does not name software. A spreadsheet can meet it if the draw is truly random and you keep a record of the pool and the result.
Usually the records. Files get edited after the fact, the pool list is overwritten before anyone saves it, or the draw is rerun until the names look right. An auditor asking who was eligible on the day of the draw may get an answer you cannot prove.
When you want someone else to run the selections and carry the coordination. The rule lets you use a service agent, but you still have to confirm it tests at the right percentage and that only covered employees are in the pool (49 CFR 382.305(j)(2)). It usually costs more than doing it yourself.
A spreadsheet costs nothing but your time. DTSMS Online is $5 per driver per month for the first 25 drivers, $4 for drivers 26 through 100, and $3 beyond that. Your first selection is free at any pool size, so you can compare before you pay.
Yes. Load your current roster, run the next selection in the software, and keep your earlier spreadsheet records with the rest of the year's documentation.
Your first selection is free, any pool size. No card, no sales call.