1. Upload the ops workbook (.xlsx). The tool finds the open-shipments sheet ('DHL SND Daily', or any sheet with Tracking Number and Carrier Comments columns) and matches columns by header name.
2. Your file never leaves the browser. Only the tracking numbers are sent to DHL's tracking service; the workbook is edited and downloaded on this device.
3. One dated line per update. When DHL has a scan newer than the comment log, a line is added in the team's style, e.g. 10/2 - Departed CVG on flight 3S 0397A to LEJ 10/1, ETA FRA 10/4 (per DHL tracking).
4. When nothing is added: if an ops note from the same day or later already covers the latest scan, if the same update is already in the log (safe to rerun), or if DHL has nothing new. ETAs are shown only when they are still in the future, so stale schedules never reach the customer.
5. Delivered shipments get the POD Date filled, a "Delivered … (POD per DHL tracking)" line, and move to the end of the Delivered sheet. A matching line is added to the POD sheet.
6. Status and pivot: Status formulas are kept and recalculate, and Pivot_revB refreshes, when the file is opened in Excel. All other sheets, formatting, and columns stay as they were.
7. Left for ops to fill: MAWB, DHL File#, handover date, and signature name on the POD sheet (DHL tracking does not provide them). Numbers DHL cannot find are flagged and their rows are left untouched.

DGF air-shipment report (the 'Page1' export with Tracking Number (HAWB, BOL), Possession and Delivery Date columns) is recognised automatically from its headers. Open rows are the ones with no Delivery Date. Only open rows with a Possession date in the last 30 days (adjustable) are looked up, oldest first, up to the max lookups per run (DHL allows a limited number of lookups per day, and the count resets at 8 PM ET). Only blank Out for Delivery, Delivery Date and Air POD Equivalent cells are filled, in the column's own date format, and only when a DHL scan clearly supports it. Existing values are never changed. A dated DHL status (YYYY-MM-DD) column is added at the end, plus an Open shipments sheet that lists every open row with possession date, days open, latest DHL status and a STALE flag (open more than 14 days). Older rows are listed as 'outside 30-day window', and rows over the cap as 'not checked this run'. When DHL says delivered but only has an out-for-delivery scan, nothing is filled and the row is flagged confirm POD.

Always confirm the POD before sending the report to the customer. DHL can mark a shipment delivered based on an out-for-delivery scan.