1.0.5
Fixed
Calculate route and Optimize route stopped with "Could not read your data: The property 'text' is not available" when the Stops column held only text.
Fixed
data that Excel did not report as a new selection (typed into the selected cell, for example) now gets its Stops column picked before the route is calculated.
1.0.4
Improvement
the Stops column is picked by what the cells hold, so the column with the addresses is found whatever its header is called, and every block of data gets its own pick. If two columns hold addresses, the one you click wins.
Improvement
the line under the Stops column list shows the column, an example from it and why it was chosen.
Improvement
a column you pick in the Stops column list is remembered by its header.
Improvement
before anything is sent to Google, a Stops column without addresses (dates or numbers, for example) is refused, and if another column looks clearly more like addresses, the add-in asks which one to use.
1.0.3
Improvement
the Write to lists no longer offer the Stops column, and a short hint explains how to add a column of your own.
1.0.2
New
Write distance and time straight into columns of your own data (Settings > Route > Return > Write to). Only the rows with a stop are filled, and the add-in remembers the column by its header.
New
Visit order is optional now.
New
Time format Excel time (h:mm), so a SUM adds the drive times up.
New
Sort rows into this order: after Optimize route, move your rows into the visit order with one click.
Fixed
a run that is refused no longer leaves the previous route on screen.
1.0.1
New
Keep my order: get the distance and travel time for each leg in the order of your rows, without reordering the stops. The button then reads Calculate route; untick it to optimize the same stops afterwards. Works with Round trip.
1.0
New
Initial release with core functionality.
