Like us on FacebookFollow us on Twitter  Find us on Facebook and Twitter





Welcome to the CDX Technologies December 2018 Newsletter


This month we cover a new, free Excel template for finding ZIP Codes associated with city/state lists.  Also, to ring in the new year, we are offering our Geographic Access Analysis template for $99.95 (regularly $149.95) until 

January 31.


Here are some of our latest blog postings:


- Faster CDXStreamer Version 3

- An Excel Expense Report Template that Automatically Calculates Mileage

CDXZipStream Bulk FindZip Report Template


We've added a new template to our suite of CDXZipStream tools for FindZip Analysis.  This template can take a long list of city and state combinations and produce a report of all matching ZIP Codes.  The template can be downloaded for free from the templates page of our website.  It is compatible with both the trial and registered versions of CDXZipStream.


While you can always copy the original FindZip formula to analyze a list, this template streamlines the application.  Rather than returning all ZIP Codes in a single string (as the formula does), each ZIP Code is output to a separate cell in the template.  This makes it simple to copy the lists to another application.  The template can handle up to 250 ZIP Codes per city/state entry.  As with our other templates, you will see a status indicator showing the progress of the FindZip calculations in the lower left status bar. 


Here is an example of the report output:



With the release of this application we now have templates that automate each CDXZipStream function.  You can download this new FindZip tool and all of the other templates here.  We recommend the use of these templates rather than copying formulas when analyzing long lists. We also provide video tutorials demonstrating how to use many of the available templates.


Special Offer - Geographic Access Analysis Template


To ring in the new year, we are offering our Geographic Access Analysis template for $99.95 (regularly $149.95) until January 31.    


This Microsoft Excel template can take a matrix of X and Y locations (these could be stores, customers, warehouses, delivery points, etc.) and create a comprehensive report showing which X locations are closest to all Y location targets, or vice versa.  It works with the CDXZipStream Bing version or higher.   


The template first automatically determines if each address can be matched to a location in either Bing Maps or Microsoft MapPoint; you can select which mapping source to use.  If a match is found, CDXZipStream geocodes the location to determine its latitude and longitude.   These points of latitude and longitude are used to calculate straight-line distances between all combinations of locations.   


Here is a quick look at how it works: 



Geographic Access Analysis using Microsoft Excel

Geographic Access Analysis using Microsoft Excel



To purchase the template, login to your account on, and from the CDXZipStream menu select "Buy Data Update", then under "Data Product" select "Geographic Access Analysis Template".  You must have already purchased the CDXZipStream Bing version or higher to see the template listed.  If you would like to upgrade your license to the Bing version, select "Upgrade Licenses" from the CDXZipStream menu and follow the purchasing process.   


Latest Data Updates


Canadian and U.S. data feeds of CDXZipStream were updated as of December 26.  If you would like to update your database to reflect these changes, select the "Account" option on the CDXZipStream commandbar and click on "Check for Available Database Updates".  You can then update each database as required.


CDXZipStream updates are a part of the one-year software maintenance subscription included with your purchase.  If you would like to extend your subscription, please sign in to the CDX Technologies website and from the account area for CDXZipStream, select "Buy Data Update".  The maintenance agreement also includes access to the latest version of CDXZipStream. If you are using our discontinued "Classic" version you can upgrade to the current software by purchasing this subscription at a fraction of the list price.


As always, we hope you find the information here helpful for you and your organization.  You can contact us with your feedback and suggestions by replying to this email.


The Team at CDX Technologies 

December 2018



Map of the World


In This Issue 


CDXZipStream Bulk FindZip Report Template


Special Offer - Geographic Access Analysis Template


Latest Data Updates










YouTube Video: Geographic Access Analysis using Microsoft Excel