Guided Tour: 'Atlas' Charts
Easy to create "Road Atlas" style tables.
'Road atlas' tables use a list of places (locations) for the start and end points. The result is a table that is very similar to the driving tables seen in road atlases.
MPMileCharter created the above table of distances between a selection of major European cities. The following screenshots show the process.
Pushpins were inserted into a Microsoft® MapPoint® map for the required cities. These could also be imported from an Excel® spreadsheet, Access® database, or a text file.
MPMileCharter is started. The same pushpin set was selected for both the start and finish locations to produce the 'atlas' table. Options for a lower-right table with kilometers are selected. Compute is pressed and the table is created in about two minutes.
The above example produces a 'lower triangle' mileage chart, where each city pair is only represented with one calculated distance. usually this is sufficient, but MPMileCharter can also produce a full rectangular mileage chart (see right) which records distances for every city pair in both directions. One-way streets and frontage roads are the usual causes for route distances that vary according to direction.
These examples use Microsoft Excel for the output. MPMileCharter can also write to a series of text files, one for each attribute (distance, travel time, route cost, rate table cost). Text file separator characters can be commas (ie. CSV), semi-colons, or tab characters.
Similar "road atlas" style charts can be created for any locations in North America or Europe. As well as cities, you could find distances between towns, offices, depots, or customers.
Next, we look at zipcodes and other locations.