In transit
4
Overdue or exception
5
On-time rate
71%
Shipment & Delivery Tracker
Inbound and outbound shipments with tracking numbers, transit times, late and exception flags, and on-time rate and cost per shipment by carrier.
SpreadsheetLogistics & ShippingFree
Plan a multi-stop route with miles, drive time, service time and a cumulative ETA for every stop, checked against delivery windows.
Shown with sample data
Plan a multi-stop route with miles, drive time, service time and a cumulative ETA for every stop, checked against delivery windows.
A dispatcher’s route sheet that does the arithmetic. Enter stops in delivery order with the miles from the previous stop, expected average speed and time on site; the planner works out drive time, a running ETA for each stop from the departure time, and checks it against each customer’s latest arrival time. It also shows total miles, total route time, the time the driver gets back and the cost of the route.
ETA = departure time + all drive time up to this stop + time spent at every earlier stop. Drive time = miles ÷ average speed × 60.
No. It calculates the times for the order you choose, so you can try different orders and compare. For dozens of stops, use routing software and paste the result here.
Plain numbers work in every spreadsheet without time-format problems. 1030 means 10:30, 1545 means 3:45 pm.
Download a copy
Downloads need a free account.