We cover a new video on Geographic Access Radius Analysis and an update on Census 2020 data.

Geographic Access Radius Analysis with CDXClosestZip
We've created a new video demonstrating how to use the CDXClosest Zip Function as an alternative to radius analysis.  The CDXClosest Zip function is a formula included with our CDXZipStream Excel add-in  The formula quickly calculates which zip code in a list is closest to a target zip code.

The business use case we analyze is the coverage of a set of business locations for a specific customer list. The most common example of this is a health care network consisting of many individual doctors and/or medical facilities.  A typical report requirement is to examine the coverage that this network has to its customer base. This is determined by calculating the % of customers that are within an easily drivable distance.  Health care is one example but there are many other businesses that need to solve this type of problem.
The video covers the details of the formulas to be added along with an example spreadsheet with the final report.
Census 2020 Status Update
The U.S. Census has delayed the release several times of the raw data we need to update the decennial 2020 Census in our databases. This is due to COVID-19 and other factors.

While they have begun releasing state population totals, the complete data set including race, ethnicity, sex and age is not expected to be available until some time in Q3 2021. We would expect to be able to publish an update one month after the complete Census 2020 data release.

If you are in immediate need of recent demographics our American Community Survey (ACS) tables contain data current as of 2019.
Latest Data Updates

Canadian and U.S. data feeds of CDXZipStream were updated as of April 26. 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