{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Geocode and Sort","Backup","Instructions","Data"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":32,"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":"Geocode and Sort","index":0,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,4,7,7],[7,8,7,10],[7,12,7,25]]}
[]
[]
[]
[]
[null,null,null,null,"STREET (OR FULL ADDRESS)","CITY","STATE","ZIP CODE","LATITUDE","LONGITUDE","CONFIDENCE"]
[]
[]
[null,"OPTIONAL DATA",null,null,"ADDRESS LIST",null,null,null,"RESULTS",null,null,"DISTANCE","OPTIONAL DATA"]
[null,null,null,null,"STREET (OR FULL ADDRESS)","CITY","STATE","ZIP CODE","LATITUDE","LONGITUDE","CONFIDENCE","(MILES)"]

{"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":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[[18,1,18,15],[97,2,97,14],[22,1,22,15],[30,1,30,15],[35,2,35,14],[44,2,44,14],[40,2,40,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,"Geocode and Sort by Distance Template"]
[]
[null,null,"Note:  This template works with Microsoft Excel 2010 and higher, and is designed for up to 1 million rows of data.  If you need"]
[null,null,"require additional customization, please email customsolutions@cdxtech.com or call (877) 239-8321."]
[]
[null,null,"For long lists we recommend using the CDXZipCode \"Map Data Source\" option.   This geocodes based on the zip code and is the "]
[null,null,"fastest option.  After sorting your list you can use the Bing or other address geocoders on the top results."]
[]
[null,null,"This template determines the latitude and longitude of each address provided, and then calculates and sorts all addresses based on"]
[null,null,"their straight-line distance from a target address.  This can be useful for determining which customers are closest to a store location,"]
[null,null,"for example.  We also have available for purchase an expanded version of this template, which can create customized reports showing"]
[null,null,"the closest locations for multiple targets.  Please see our website and video tutorial at the link below for more information:"]
[]
[null,"Geographic Access Analysis in Excel"]
[]
[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,"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 to work.  Click below to try a free trial:"]
[]
[null,"Download a free trial of CDXZipStream"]
[]
[null,null,"If using Bing you must enter a Bing Maps license key (by selecting \"Settings\" on the CDXZipStream toolbar, then "]
[null,null,"\"Bing Maps Settings\", and \"Set Bing Maps Key\".)  You will have to close all sessions of Excel and then reopen this template for the "]
[null,null,"entered key to be in effect."]
[null,null,"Get a free Bing Maps Key"]
[]
[null,null,"If using HERE you must enter a API key (by selecting \"Settings\" on the CDXZipStream toolbar, then \"HERE API Settings\")"]
[null,null,"You will have to close all sessions of Excel and then reopen this template for the entered key to be in effect."]
[]
[null,null,"Get a free HERE API Key"]
[]
[null,null,"If using Maptitude, you can request a free trial through the following link:"]
[]
[null,null,"Get a free Maptitude Trial"]
[]
[null,null,"Registered CDXZipStream users will need to enable the demo.  To enable, press the \"Account\" icon from the CDXZipStream toolbar "]
[null,null,"press \"Register/Upgrade Product\", then press\"Enable Maptitude Demo\".  From here you can enter your Maptitude user name and code"]
[null,null,"obtained from support@cdxtech.com."]
[]
[null,null,"If using Microsoft MapPoint, this must also be installed."]
[]
[null,null,"If you have address data (with no latitude and longitude data):"]
[]
[null,null,"Press the tab at the bottom of the screen or press the \"Get Started\" button above to go the \"Geocode and Sort\" worksheet.  "]
[null,null,"Enter the target address and all other address data in Columns E through H.  Enter the target in row 6, and all other"]
[null,null,"addresses starting at row 10.  You can also enter data associated with each address in Columns B through D and M through Z, "]
[null,null,"such as name, telephone number, etc. You must enter street data or the full one-line address in column E.  Either 5-digit "]
[null,null,"or 9-digit (ZIP + 4) formats are acceptable."]
[]
[null,null,"It is also possible to do this analysis solely using ZIP Codes, with no additional address information.  "]
[]
[null,null,"Select  the map data source.  If using MapPoint, select \"Settings\" on the CDXZipStream toolbar to choose the appropriate "]
[null,null,"(North American or European) version of MapPoint if both are available on your PC.  You may have to close and then reopen this"]
[null,null,"template to confirm changes to the MapPoint version."]
[]
[null,null,"After all data is entered, press \"GEOCODE TARGET\" and \"GEOCODE ADDRESSES\" to obtain latitude and longitude data."]
[]
[null,null,"If using Bing, data returned to the \"Confidence\" column indicates the level of confidence that the correct location was identified."]
[]
[null,null,"If using MapPoint, data returned to the \"Match\" column indicates the quality of the result found."]
[]
[null,null,"1. Exact - A unique entry was found in MapPoint for this address."]
[null,null,"2. Allow Ambiguous-  The first of at least two matching entries was found in MapPoint."]
[null,null,"3. ZIP Code - MapPoint could not find any good matches, so the centroid of the ZIP Code (if available) is returned from CDXZipStream."]
[]
[null,null,"For match type of \"ZIP Code\" you should check the address information for typographical errors or misspellings. As an alternative, "]
[null,null,"you can also manually input the latitude and longitude.  (If you right-click on any location in Google Maps and select \"What's Here\","]
[null,null,"latitude and longitude will display in the Google search box.)"]
[]
[null,null,"For Maptitude, the \"Confidence\" column will show the layer where the location was found (Street, City/State, or ZIP Code). The latter"]
[null,null,"two layers will also display a score, with lower scores indicating higher confidence."]
[]
[]
[null,null,"If you already have latitude and longitude data:"]
[]
[null,null,"Press the tab at the bottom of the screen or press the \"Get Started\" button above to go the \"Geocode and Sort\" worksheet.  Enter latitude "]
[null,null,"and longitude data on this worksheet in Columns I and J, in row 6 for the target location and starting at row 10 for all other locations.  "]
[null,null,"You can also enter optional data associated with each location in Columns B through H, such as name, telephone number, etc.  Latitude "]
[null,null,"and longitude must be in decimal format.   Do NOT press \"GEOCODE ADDRESSES\" if you have entered latitude and longitude yourself."]
[]
[null,null,"Press \"SORT\" to sort the locations based on their straight-line distance from the target.  Distance data returned in column L will be"]
[null,null,"sorted based on closest first."]
[]
[null,null,"Press \"CLEAR DATA\" to remove all its address and other other calculated data."]
[]
[null,null,"Copyright © 2022 Hughes Financial Services, Inc."]
[null,null,"Version 6.11"]

{"sheet":"Data","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,1,"miles"]
[]
[null,"BING","miles"]
[null,"MAPPOINT","km"]
[null,"MAPTITUDE"]
[null,"CDXZIPCODE"]
[null,"HERE"]