1 Dispatch Report (HOS) — Excel
Dispatch Report (HOS)
.xlsx / .xls · DriverActivity or dispatch export
✓ Loaded
3 Dispatching Analysis — Excel (optional — enables 150-mile check)
Dispatching Analysis
.xlsx · Export tab · destination addresses
✓ Loaded
Default: 1015 S Bethany St, Kansas City, KS 66105 (All City Tow). Enter a different ZIP to override.
2 QuikTrip Fuel Report — PDF
QuikTrip Fuel Report
.pdf · WEX Purchase Activity Report
✓ Loaded
📋 Column Mapping — Match your Excel columns to HOS fields
Your Excel columns were detected below. Map each required field to the correct column.
Required: Driver Name, Reason/Call Type, Enroute/Start Time, Arrival Time.
Detected columns:
⚙ Driver Name Matching — Review Before Running
The fuel PDF uses First Initial + Last Name (e.g. "J Brown").
Your dispatch report uses the names shown in the dropdowns.
Auto-matched by last name + first initial.
Green = confident auto-match.
Amber = manual override.
Red = unmatched — please select.
Ready.
Cross-referencing fuel timestamps against on-duty windows.
⛽ Fuel Events Outside Logged Hours — 0 Found
—
Drivers
—
Driver-Days
—
Total Hours
—
Avg Hours/Day
—
70-Hr Violations
—
16-Hr Exemptions
—
Fuel Flags
—
Time Adjusted
Report Title:
Filter Driver:
FMCSA Rules Applied:
(1) Police calls at shift start/end excluded per towing exemption.
(2) 10-hour gaps split the shift.
(3) Red duration = over 14 hours.
(4) 70-hour/8-day rolling limit — violations flagged.
(5) ⛽ Fuel outside on-duty hours extends shift start or end. Amber times adjusted — hover for original.
(6) ⏱ 16-Hr Exempt = within-150-mi day of 14–16h, legal once per 34-hr cycle under 49 CFR 395.1(o) — log still required for that day.
🗺 150 Air-Mile Radius — 0 Flagged Calls 172.6 statute miles · straight-line from home terminal · FMCSA short-haul exemption boundary
| Driver Name | Date | Start Time | End Time | Total Hours | Calls | Police | Non-Police | Rolling 8-Day | 70-Hr Rule |
|---|
Green = Start · Orange = End ·
Amber ⛽ = Fuel-adjusted ·
Red = 14+ hrs · 🚨 = 70-hr violation ·
⏱ 16-Hr Exempt = legal 14–16h day (log required)
🚛
Upload both files to begin
Step 1: Upload your Dispatch Excel file — columns are auto-detected
Step 2: Upload the QuikTrip Purchase Activity Report PDF
Step 3: Confirm driver name matches, then click Run Analysis
Fuel before first call → shift start moves earlier.
Fuel after last call → shift end moves later.
Step 2: Upload the QuikTrip Purchase Activity Report PDF
Step 3: Confirm driver name matches, then click Run Analysis
Fuel before first call → shift start moves earlier.
Fuel after last call → shift end moves later.