The Scenario
Your company runs eight distribution centers and the ops team is redesigning last-mile delivery zones. The question on the table: which geographic area can each depot realistically serve within 30 minutes of drive time? You're the logistics manager. You have the depot coordinates in an Excel workbook. You need TomTom's reachable-range calculation run for each one — but there's no straightforward way to do that from a workbook without writing API calls.
The bad version:
- Open TomTom's developer documentation, find the reachable-range endpoint, set up an API call for the first depot, parse the polygon response, manually extract the bounding box coordinates, type them into columns C through F
- Repeat for all eight depots
- Realize you're not sure whether the bounding box you extracted is in the right coordinate order, so the coverage maps your GIS team draws end up covering the wrong areas
The zone redesign presentation is next week. The GIS team needs the bounding boxes now to start drawing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the depot coordinates, calls TomTom's reachable-range API for each one, and writes the coverage results back into the workbook.
For each vehicle starting point in column A of my Excel sheet and the fuel budget in column B, calculate the TomTom reachable range and write the polygon area in km squared and maximum reachable distance in km into columns C and D
What You Get
- Column C: approximate reachable area in km squared for each depot
- Column D: maximum reachable distance in km
- Bounding box coordinates available if you include them in the prompt
What If the Data Is Not Quite Ready
Time budget varies by depot
For each depot in this workbook, use the lat/lng in columns A and B and the time budget in minutes in column C. Calculate the TomTom reachable range and write the bounding box coordinates into columns D through G.
You need the bounding box, not just the area estimate
For each depot lat/lng in columns A and B of this sheet, calculate the TomTom reachable range within 30 minutes of driving time and write the bounding box coordinates of the reachable area into columns C through F
Only calculate for depots flagged as active
For all rows in this workbook where column C says "active", use the lat/lng in columns A and B to calculate the TomTom 30-minute reachable range. Write bounding box coordinates into columns D through G and skip inactive rows.
Full coverage analysis in one shot
For each depot in columns A and B, calculate the TomTom reachable range within 30 minutes. Write the bounding box into columns C through F. Calculate the approximate coverage area in km squared and write it into column G. Sort the workbook by column G descending so the largest coverage depots appear first.
One prompt calculates all eight ranges, extracts the bounding boxes, estimates the area, and sorts the output.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your depot coordinates, then ask it to calculate reachable ranges using TomTom. For full driving route calculations between specific origin-destination pairs, see the driving distance and time spoke.