Find us on
Facebook and Twitter
Welcome to the ZipStream December 2012 Newsletter
In this month's newsletter we preview our soon-to-be
released update of CDXStreamer, an on-line subscription service for
very large data sets, including ZIP+4 and Canadian postal
codes. CDXStreamer works in Microsoft Excel just like
CDXZipStream, and will also feature a very accurate address
verification function that can be used with address lists in Excel.
It can be used to verify the accuracy of addresses, and can even look
up ZIP and ZIP+4 codes for specific addresses.
We now also offer a powerful new custom template
that performs "bulk" radius analysis for multiple
locations. For example, do you have a long list of stores supplied by
many distribution centers, or any similar analysis involving X by Y
locations? The template will calculate distances between all X
and Y address pairs, and also create a report identifying the closest
distribution centers (within a radius distance you specify) for all
And finally, as a result of customer requests, we have
a free downloadable Excel workbook that finds zip codes in a radius
and returns the results in a single string, without distance data.
Look for the New CDXStreamer with Address Verification
Next month we
will be introducing the latest version of CDXStreamer. We're
discussing it here in our CDXZipStream newsletter because many of our
CDXZipStream clients will be interested in its new features,
particularly its ability to perform address verification and zip code
lookup for specific addresses.
CDXZipStream does include some address verification capability (in
the CDXLocateMP function), its reliance on the relatively small
desktop database of Microsoft MapPoint does limit its accuracy.
As an on-line subscription service where the databases reside
on CDX Technology servers, CDXStreamer can provide true address
verification for long lists of addresses in Excel. Need to
verify or lookup ZIP or ZIP+4 codes for specific street addresses?
Just right-click on any cell and select the address verification
function, and the data you need are automatically returned to your
worksheet. In fact, CDXStreamer is unique in that it is
the only true address verification software that works in Microsoft
will also include data feeds for ZIP+4 and Canadian postal codes.
For instance, for a list of ZIP+4 codes (which you can obtain
from the address verification function described above), you can
request data such as carrier route, latitude, and
hearing more about CDXStreamer in our next newsletter.
New Custom Template for Bulk Radius Analysis
More than a
few of our customers need to do radius analysis for a matrix of X by
Y locations - we call it bulk radius analysis - and now we have a
powerful new tool, in the form of an Excel template, that can do it
quickly and easily. This is a common type of analysis that
involves many repetitive distance calculations. Here are some
- With X
stores and Y distributions centers, which distribution centers are
closest to each store?
- With X
hospitals and Y patients, which patients are closest to each
- With X
stores and Y customers, which customers are closest to each
Just enter the
addresses of all X and Y locations, and the template calculates
straight-line distance between all combinations of address pairs.
Locations can then be sorted based on distance, and best of
all, you can also specify a radius distance and create a complete
report, listing all Y locations located within the radius of each X
information please contact us at support@CDXTech.com or call
Exclude Distance Data from CDXRadius
right-click function CDXRadius is a handy little tool that identifies
zip codes within a specified radius of a target zip. Data can
be returned as an Excel array or as a single text string. The
text string includes both zip code and distance from the target zip,
and looks something like this:
where each zip
code and distance pair is separated by a vertical bar delimiter.
where distance data is not required, you can now download an Excel
workbook that removes the distance data so the returned string only
contains the list of zip codes, separate by commas:
link for the Excel workbook is here. Please remember to
enable macros before use.
In the past we
have also published a method for parsing the string so each zip code
is separated into its own worksheet cell. Please see our blog
post Get Radius Information for a List of Zip Codes
to see how this can be done using just worksheet functions.
U.S. data feeds were updated as of December 10. There
were 34 changes made to the U.S. data feed. If you would
like to update your database to reflect these changes, click on the
"License Information and Software Updates" icon on the
CDXZipStream toolbar, and select "Data Updates" to login to
We hope you
find the information here helpful for you and your organization.
Please contact us with your feedback and suggestions by
replying to this email.
Team at CDX Technologies
In This Issue
for the New CDXStreamer with Address Verification
Custom Template for Bulk Radius Analysis
to Exclude Distance Data from CDXRadius