VBA + OCR pipeline that turns the morning paperwork crunch into seconds.
Client: Last-mile delivery operation
Every morning, dispatch staff spent 30+ minutes hand-merging route data from their partner shipping operation against image-based attachments. The work was tedious, error-prone, and ran right up against the start-of-day window — a single keying mistake could send a driver the wrong route information and cause cascading effects.
Excel workbook driven end-to-end by a VBA macro: pulls in the partner-supplied route spreadsheets, OCRs the supporting images via Tesseract, reconciles the two against the operation's map, and emits clean per-driver route sheets ready to print or hand off.
Hours of every dispatcher's week reclaimed. Hand-keyed errors essentially eliminated. Drivers get their route sheets in seconds instead of waiting on the morning crunch — the start-of-day window is no longer a bottleneck.
- Download the spreadsheets from Slack
- Manually key in each route sheet's staging area and driver name
- Cross-check against route images
- Catch typos · re-key
- Print, hand off
- Download the spreadsheets from the Slack channel
- VBA macro reconciles & OCRs
- Route sheets are filled in with accurate data
- Per-driver sheets emit from the printer, ready to be sent via SMS