Fast Distance Calculations with CDXDistance2WP

CDXDistance2WP is the fastest distance calculation available in CDXZipStream. It calculates the straight-line ("as the crow flies") distance between two locations as defined by their latitude and longitude coordinates. This function is available in the Bing and higher versions of CDXZipStream. 

CDXDistance2WP is an order of magnitude faster than the standard CDXDistance calculation and several order of magnitude faster than the Bing and Mappoint driving distance formulas.   There are no database calls as in CDXDistance to determine coordinates as they are already predefined.   And there are no delays waiting for Bing Maps or Mappoint to respond.

A question we often get asked is how to calculate determine the closest business or source locations to a long list of customer locations.   Attacking this type of problem with just the driving distance calculations can take many hours to run in a grid of 100K location pairs or more.  Once you geocode all the locations involved you can use the use the CDXDistance2WP function to determine straight line distance.  CDXDistance2WP is very fast and the analysis for a 100K grid should only take a few minutes. You can then determine the closest few locations for each client and then run a driving distance calculation for these top locations.  This dramatically cuts down on the calculation times.

We’ve developed an example template which shows how set up CDXDistance2WP on a simple five by five grid.  Just copy the formulas to new cells to expand it.  You can geocode locations using Bing or Mappoint or if only using zip code use the CDXZipCode formula to determine latitude and longitude.  Once calculated, set all the formulas to values and then sort the various columns/rows to determine the closest locations.  Setting the formulas to values avoids recalculation delays when sorting the lists.

 We’ve also developed a “Geographic Analysis Template" that automates the calculation and sorting process described above and produces a custom output report that can be tailored by a specified radius.  Here is a video on how it works. 

 https://www.youtube.com/watch?v=qcMVMRqvsMg&t=24s

We have a variety of other articles on this blog describing the distance calculations available with CDXZipStream.  Here are some of the most popular ones.

 https://blog.cdxtech.com/post/straight-line-distance-as-an-estimate-for-driving-routes

 https://blog.cdxtech.com/post/Choosing-the-Right-Function-to-Calculate-Distance-in-CDXZipStream

 https://blog.cdxtech.com/post/How-to-Very-Accurately-Filter-Addresses-Based-on-Distance

 https://blog.cdxtech.com/post/Geocode-and-Sort-Locations-by-Distance-from-a-Target-Free-Excel-Template1

https://blog.cdxtech.com/post/cdxzipstream-zip-code-distance-matrix-template

How to Create Fixed Keycodes for CDXZipStream

Creating fixed keycodes for CDXZipStream is useful in situations where a proxy network is blocking the regular registration process, or if you would like to activate another user’s software without sharing credentials.

A fixed keycode is based on the name of the computer. To find the computer’s name, follow these steps:

- From the CDXZipStream command bar in Excel, click on the CDXZipStream “Account” icon.
- Click the “Register/Upgrade” button in the upper right-hand corner.
- In the “Fixed Licensed Registration” section, click the “Manual Registration” checkbox.
- Click on the “Computer Name” button that appears:

You can highlight the computer name and from the right-click menu, select “Copy”.

To use this name to generate a keycode:

- Login to your account on CDXTech.com
- From the CDXZipStream dropdown menu, select “Account Status”.
- Click on the “Options” button and select “Add Fixed Keycode”.
- Enter the computer name, and click on “Generate Keycode”
- A new registration code will be shown.

You can double-click on the listed code and from the right-click menu, select “Copy”.

Go back to the Fixed License area, then enter the computer name and new registration code. After registration the latest ZIP Code data can be downloaded.

If you prefer, we can generate the registration codes if you send us the additional computer names as described above.

ACS Data Feeds Updated with Latest Census Data

The CDXZipStream ACS data feeds for state, county, ZIP code (ZCTA), place, and CBSA (Core-Based Statistical Area) have been updated with the latest data releases from the U.S. Census Bureau. These data are from the American Community Survey, which surveys about 1 out of every 38 households every year. These feeds are available in the CDXZipStream Premium ACS version. Data for all geographies are aggregated over the years 2013 through 2017

The demographic areas covered in all ACS feeds are: age, population, household size, household income, individual earnings, race and ethnicity, educational attainment, school enrollment, housing value and rent, mortgage status, and marital status. For a full listing of all data fields included in the feeds, please download the CDXZipStream Data Feeds and Definitions file here.  

If you already own CDXZipStream ACS Premium and have an active data maintenance contract select the "Account" option on the CDXZipStream Excel menu and click on "Check for Available Database Updates".  The select the option to update your premium database.

For users without an active account you can update your data feeds by logging into your on-line account on CDXTech.com and under My Account and Product Management, selecting "Buy Data Update" and then purchase the Premium Maintenance contract.  If you don’t have the correct CDXZipStream version select "Upgrade License" in the account area and select the option to upgrade to the ACS version. The latest data will automatically be included with your purchase. 

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.

Free 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 download for free at this link.  It is compatible with both the demo registered versions of CDXZipStream.

While you can always copy the original FindZip formula to analyze a list this template streamlines the application.  Rather than using delimiters as the formula does each zip code is output to a separate cell.  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’ve also included videos demonstrating how to use many of the available templates.