Guided Tour: Zipcodes and other locations
The previous example used MPMileCharter to find distances between cities. MileCharter can find distances between any set of locations marked with pushpins. These locations can be cities, zipcodes / postcodes, street addresses, geographic coordinates, businesses, customers, etc. The only constraint is that they have to be within an area of the globe covered by Microsoft® MapPoint®'s road network.
Using MPMileCharter with Zipcodes
MPMileCharter is often used with zipcodes (or postcodes). Simply load a pushpin set with a pushpin for each zipcode that is required. This example map has a number of zipcode pushpins (blue dots) distributed across the contiguous US and Alaska. Some of the pushpins have their names exposed - illustrating that they are zipcodes.
In this example, each pushpin is located by zipcode and uses the same zipcode for the name. MPMileCharter uses the pushpin names to refer to the individual locations in the final table. The name does not have to be the same as the location, but it is convenient here because we are interested in the actual zipcodes. If you wished, you could use customer names or company names.
Here is the MPMileCharter panel, set as before. The pushpin set (zip_codes) is selected for both the start and end locations. We request a 'lower triangle' chart (without duplicates) of distances and travel times, using Excel for output.
Here are the distance results. These are similar to before, but note that the spreadsheet is much larger.
MPMileCharter can take advantage of the large spreadsheets supported by Excel 2007 (and later). MPMileCharter does work with earlier versions of Excel, but the output is limited to 250 columns.
Next, we look at a business application: finding distances from multiple offices to a new customer.