Send Back Planner - User Guide
This guide explains how the planner calculates each output, what every major column means,
and how to update inputs correctly during live dispatch operations.
What This Tool Does
The planner combines ADP clock-in times, travel assumptions, and live route updates to generate:
- Base send-back target per driver
- Updated send-back targets after redistribution
- Updated target clock-out and adjusted used hours
Recommended Workflow
- Upload ADP and verify driver rows loaded correctly.
- Set planning counts: Confirmed Routes, Rostered DAs, Extra DAs.
- Enter row updates: Last Stop Address, Actual Send Back, Clock Out ADP.
- Click Calculate to refresh summary and computed table.
- Repeat updates through the shift. Use Clear Data only for a full reset.
Planner state is shared across browsers/PCs and persists until manually cleared.
Core Rules
Total Route Hours
(Rostered DAs * 10) + (Extra DAs * 2)
(Rostered DAs * 10) + (Extra DAs * 2)
Planned Shift Hours
(Total Route Hours / (Rostered DAs + Extra DAs)) + 0.5
(Total Route Hours / (Rostered DAs + Extra DAs)) + 0.5
Active Driver
Driver with no Actual Send Back and no Clock Out ADP yet.
Driver with no Actual Send Back and no Clock Out ADP yet.
How The Main Columns Are Calculated
| Column | Meaning | Formula / Logic |
|---|---|---|
| F | Last -> Gas (min) | Distance-based estimate from Last Stop Lat/Lon using Avg Speed + Road Factor. |
| G | Gas -> Station (min) | Fixed configured value. |
| H | Total Travel (min) | H = F + G |
| I | Worked Hours | Current DSP local time minus ADP Clock In. |
| K | "10th Hr" target | K = Clock In + (Planned Shift Hrs * 60) |
| J | Send Back By | J = K - H - Checkout Min |
| O | Effective Clock Out | If Actual Send Back exists: Send Back + Travel + Checkout. Else use Clock Out ADP. |
| Q | Remaining Hours | Available hours remaining against target (minimum 0). |
| R | Active | TRUE only when both Actual Send Back and Clock Out ADP are blank. |
| S | Distributed Extra | Total Remaining Hours / Active Driver Count (active rows only) |
| T | Updated Send Back | T = J + (S * 60) |
| U | Updated Target Clock Out | Adjusted final target after redistribution. |
| V | Adjusted Hours Used (Updated) | Recomputed from Clock In to Updated Target Clock Out. |
Redistribution Logic
When some drivers finish early, their remaining hours (Q) are pooled and evenly distributed to active drivers:
Share per active driver = Sum(Q for completed drivers not marked Hold Remaining) / Number of active drivers
If a driver is marked Hold Remaining, their Q value is tracked but excluded from redistribution.
This share updates send-back and target clock-out for active rows.
Quick Example
Rostered = 40, Extra = 8 -> Total Route Hours = 416
Planned Shift Hrs = (416 / 48) + 0.5 = 9.17
If Clock In = 09:00 AM, Total Travel = 55 min, Checkout = 10 min:
K = 06:10 PM
J = 06:10 PM - 55 - 10 = 05:05 PM
Important Notes
- If you do not want counts auto-overwritten by ADP row count, keep auto-fill unchecked.
- Without a Google key, fallback geocoders may be slower for large batches.
- Use complete addresses (street + city + state) for better geocoding accuracy.