CDX Technologies

November 2023 Newsletter

Account Log-in

In this newsletter we discuss a creating a quick "Radius" function with CDXDistance to filter mailing lists and customer data.


Our latest Blog posting discusses the CDXZipStream Bulk Radius Analysis Template

Check Our Blog

Quick Radius Report with CDXDistance

We've covered in past articles how to use the CDXRadius function to analyze the closest locations in mailing lists and other data applications. The basic technique is to create a CDXRadius formula report and then evaluate the distance of every item in the list using an Excel VLookup command. For more detail on this please see the support article we've previously published Advanced Zip Code Radius Calculator and Finder with Microsoft.


The technique with CDXRadius works best with large lists and if you will be using the same radius report repeatedly. For shorter lists and quick reports you can use the CDXDistance functions by adding a simple formula.


The spreadsheet below shows an example customer list where we want to evaluate all customers within 100 miles of the zip code 07869.

To do this simply enter the following formula beginning in the first row of your data which in this case is cell H3 referencing the first customer zip in G3.


=IF(@CDXDistance(G3,"07869")<=100,"YES","NO")


and then copy this down your list.


The formula returns "YES" or "NO" depending if the customer is within the specified radius. Should you wish you can also include fixed cell references (i.e. $A$1) for the central zip code and radius distance to make updating easier. This technique is also more forgiving than using VLookup when your customer data includes zip codes without leading zeroes or with Zip+4. It also works well with our Canadian database as well as with US data.

Latest Data Updates


U.S. and Canadian data feeds of CDXZipStream were updated as of November 29. If you would like to update your database to reflect these changes, select the "Account" option on the CDXZipStream menu in Excel 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.

 

As always, we hope you find the information here helpful for you and your organization. Prior issues of the newsletter can be found at the following link. You can contact us with your feedback and suggestions by replying to this email.

Hughes Financial Services Inc.
2 West Hanover Avenue,
Suite 212, Randolph, NJ 07869
Support: (973) 895-5542
E-mail CDX
Facebook  Twitter  Linkedin  Youtube  
<