Spheresoft Zip Code Tools for Microsoft Excel

Spheresoft Zip Code Tools for Microsoft Excel - Calculate distances between address zip codes in MS Excel
Spheresoft Zip Code Tools for Microsoft Excel is a tool designed to help youcalculate the distance between addresses stored in Microsoft Excel. Distances are calculated "as the crow flies" and are provided in miles. You can also get a list of zip codes that lie within a given distance of a target zip code.

Spheresoft Zip Code Tools for Microsoft Excel is ideal for direct marketers and salespeople who keep lists of customers and potential customers in Excel and who want to segment this list geographically.

For instance, you can quickly sort your list by distance from your office, prepare a mailing to everyone within a 10 mile radius, or get a rough idea of how long it will take to travel to a particular customer.

Spheresoft Zip Code Tools is also ideal for traveling salespeople and in-house accounting departments who need to calculate or double-check driving mileages on time and expense (T&E) reports.

Main features of Spheresoft Zip Code Tools for Microsoft Excel:

Spheresoft Zip Code Tools contains a complete database of zip code location information and two functions:

ZipCodeDistance(zip1, zip2) returns the distance in miles between two zipcodes in the United States. The format of the zipcodes can be 5 digit, zip+4, or you can drop a leading zero.

ZipCodesWithinDistance(zipcode, distance) returns a list of zipcodes that lie within the specified distance of the target zipcode and the distances to each of those zipcodes. The zipcodes returned are sorted by distance from the target zipcode, with the closest zipcodes listed first.

When you install Spheresoft ZipCode Tools, you will find two sample Excel files installed in C:Program FilesSpheresoftZipCodeToolssamples that illustrates the use of these functions.


Requirements of Spheresoft Zip Code Tools for Microsoft Excel:

Excel

Free Download ( Evaluation | 1.8 MB )

Buy Now ( Full version | $65 )