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.
|