Bulk Radius Analysis with Formula Arrays

A common question we receive concerns creating bulk radius reports with just formulas. Many users also want to only retrieve zip codes alone and not include the radius distance in a separate column.  We’ve previously written blogs describing similar operations including "Dynamic Formulas Radius Analysis" and “Getting Radius Information for a List of Zip Codes”. The technique described below combines these methods to produce single columns of zip code radius reports for one or more central zip codes.

 

We’ve created an example spreadsheet to demonstrate this concept which can be downloaded here. This spreadsheet will work with the “Lite” version of CDXZipStream or better versions which include the radius function. The picture below shows the report included on the first tab of the spreadsheet.

Columns B, C, and D contain CDXRadius formulas which were entered manually as formula arrays.  To find out more about entering formula arrays please see the following blog article. Rather than 2 columns, only one column was selected as an input range so that only zip codes are returned. The length of each column is 2500 rows which should accommodate most radius reports.  The formulas are dynamic so that when the central zip codes are changed in row 1 or the radius miles is updated in A4 the reports will update correspondingly. If you need to add additional radius reports to the bulk report simply copy the columns B,C or D to adjacent columns. 

 

This is just one of the very flexible methods of creating radius reports with CDXZipStream.  All you need to do is choose the one which best meets your analysis needs.

 

Add comment

Loading