{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Radius Calculations","Backup","Instructions","Data"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Radius Calculations","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,1,7,4],[7,5,7,8]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CITY","STATE","ZIP"]
[null,"OPTIONAL DATA",null,null,null,"ADDRESS DATA",null,null,null,"DISTANCE FROM TARGET"]
[null,"FIELD 1","FIELD 2","FIELD 3","FIELD 4","STREET","CITY","STATE","ZIP OR POSTAL CODE",{"$f":"IF(Option_Sel=\"km\",\"(KILOMETERS)\",\"(MILES)\")","v":"(MILES)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"04011"]
[null,null,null,null,null,null,null,null,null,null,"48911"]
[null,null,null,null,null,null,null,null,null,null,"15001"]
[null,null,null,null,null,null,null,null,null,null,"61820"]
[null,null,null,null,null,null,null,null,null,null,"48908"]
[null,null,null,null,null,null,null,null,null,null,"15237"]
[null,null,null,null,null,null,null,null,null,null,"15274"]
[null,null,null,null,null,null,null,null,null,null,"12308"]
[null,null,null,null,null,null,null,null,null,null,"48922"]
[null,null,null,null,null,null,null,null,null,null,"46845"]
[null,null,null,null,null,null,null,null,null,null,"29576"]
[null,null,null,null,null,null,null,null,null,null,"97213"]
[null,null,null,null,null,null,null,null,null,null,"15281"]

{"sheet":"Backup","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[[7,1,7,4],[7,5,7,8]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"CITY","STATE","ZIP"]
[null,"OPTIONAL DATA",null,null,null,"ADDRESS DATA",null,null,null,"DISTANCE FROM TARGET"]
[null,"FIELD 1","FIELD 2","FIELD 3","FIELD 4","STREET","CITY","STATE","ZIP CODE",{"$f":"IF(Option_Sel=\"km\",\"(KILOMETERS)\",\"(MILES)\")","v":"(MILES)"}]

{"sheet":"Instructions","index":2,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,2,50,14],[17,4,17,8],[18,2,18,14],[26,2,26,14]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX Technologies Support     "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(973) 895-5542     "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"support@CDXTech.com      "]
[null,null,"ZIP Code Radius Analysis Template"]
[]
[null,null,"Note:  This template works with Microsoft Excel 2010 and higher, and is designed to be used for up to 1,000,000 rows of data.  If you "]
[null,null,"need to analyze more data or require additional customization, please email customsolutions@cdxtech.com or call (877) 239-8321."]
[]
[null,null,"This template determines which addresses are within a radius distance of a target ZIP or postal code.  Distance calculations are "]
[null,null,"performed based on the centroid location of each zip code.  If you have purchased the supplemental Canadian database with"]
[null,null,"CDXZipStream, the template works with both U.S. ZIP codes and Canadian postal codes."]
[]
[null,null,"If you haven't already done so, please enable macros for this Excel file.  Please refer to our website at the following link for"]
[null,null,"instructions:"]
[null,null,"Enabling Macros in our CDXZipStream Templates"]
[]
[null,null,"You will have to close the file prior to following these instructions."]
[]
[null,null,"Use the \"Save As\" option to save this template under a new name.  This ensures the original template will remain unchanged."]
[]
[null,null,"You must have CDXZipStream installed for this template to work.  A free trial is available here:"]
[]
[null,null,"Download a free trial of CDXZipStream"]
[]
[null,null,"Press the tab at the bottom of the screen or press the \"GET STARTED\" button above to go the \"Radius Calculations\" worksheet.  "]
[null,null,"Enter address data on the \"Radius Calculations\" sheet in Columns F through I, starting at row 10.  You can also enter optional data"]
[null,null,"associated with each address in Columns B through E, such as name, telephone number, etc. The only required field is ZIP or postal "]
[null,null,"code; for U.S. ZIP Codes, use the 5-digit format."]
[]
[null,null,"Specify the target ZIP Code or Canadian postal code (if you have purchased the supplemental Canadian database) and radius  "]
[null,null,"distance in either miles or kilometers.  Also, if you have purchase the Canadian postal code database, you can select the database  "]
[null,null,"option:  United States, Canada, or both U.S. and Canada."]
[]
[null,null,"Press \"CALCULATE\" to start the radius calculations.  Cancel by pressing CTRL-Break or ESC (for Windows) on your keyboard."]
[]
[null,null,"Note:  As part of the calculations, CDXZipStream automatically adds leading zeroes to the ZIP Code as necessary."]
[]
[null,null,"Once calculations are complete, only those addresses that fall within the radius distance of the target ZIP Code will be visible"]
[null,null,"in the worksheet.  The calculated distance from the target is displayed in Column J."]
[]
[null,null,"To make all address data visible again, press \"RESET\"."]
[]
[null,null,"Before entering a new set of data, press \"CLEAR DATA\" to remove all old data."]
[]
[]
[null,null,"Copyright © 2022 Hughes Financial Services, Inc."]
[null,null,"Version 4.01"]

{"sheet":"Data","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[1,null,1]
["UNITED STATES"]
["CANDA",null,"MILES"]
["U.S. AND CANADA",null,"KM"]