Like us on FacebookFollow us on Twitter  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 target stores.


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 MailboxVerification


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.


Although 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 Excel.  


CDXStreamer 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 longitude.


You'll be 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 typical applications:


- 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 hospital?

- With X stores and Y customers, which customers are closest to each store? 


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 target location.  


For more information please contact us at or call  1-877-CDX-TEC1 (239-8321).


How to Exclude Distance Data from CDXRadius


The 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.


For cases 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:



The download 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.


Latest Data Updates


Canadian and 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 your account.


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.


The Team at CDX Technologies 


December 2012



Map of the World


In This Issue

Look for the New CDXStreamer with Address Verification


New Custom Template for Bulk Radius Analysis


How to Exclude Distance Data from CDXRadius


 Latest Data Updates







Join Our Mailing List