World logo

Mapping-Tools logo MileCharter

Create Mileage Charts with Microsoft MapPoint®

Guided Tour: Business Applications

As well as finding distances between a group of locations, MPMileCharter can find the distances from a group of locations to a new location. For example, it can calculate the distances, times, and costs for routes from a group of offices to a new customer.

Map of offices in UK+Ireland, and a new customer in Stratford

Finding Multiple Distances to a Customer

This example has a number of company offices spread across the UK and Ireland. There is a new customer in Stratford-upon-Avon. Which is the closest office?

This map of office locations was created from an Excel® spreadsheet that listed the office addresses. This was imported by using Microsoft® MapPoint®'s Data Import wizard. The office locations are all in the same pushpin set, and the new customer pushpin is in a separate pushpin set. The roads are not displayed for clarity.

MileCharter screenshot

The customer pushpin is selected, and MPMileCharter is started. In the MPMileCharter panel, the offices pushpin set are selected as the starting locations. The customer is selected as the destination. Output in the form of distances, travel times, and route costs are selected. Compute is pressed to start the computation process.

Calculated distances from each office to the customer

These are the distance results in miles. Distances have been calculated from every office to the new customer. The Peterborough office is the closest.

The Professional license of MPMileCharter can also be set to report only the closest locations.

Calculated travel times from each office to the customer

These are the travel time results. Note that the Reading office has a shorter travel time than the Peterborough office. This is because the route from Peterborough is cross-country and uses slower roads.

Also notice that the travel time from the Dublin office is much longer than any of the other times. This is because the route from Dublin includes a ferry crossing.

Calculated route costs from each office to the customer

These are the route costs. They are calculated using Microsoft MapPoint's own cost estimates. These estimates are based on a simple "per mile" calculation, so the short Peterborough route is the cheapest. MileCharter can also use rate tables that assign different cost rates according to the distance.

Next, we look at a business application with multiple depots and customers.

Buy MPMileCharter for MapPoint Now!