{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Address Geocoding","Data","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Address Geocoding","index":0,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"STREET (OR FULL ADDRESS)","CITY","STATE","POSTAL CODE","COUNTRY","LATITUDE","LONGITUDE","CONFIDENCE"]

{"sheet":"Data","index":1,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[1,null,null,6]
[]
["NO COUNTRY SELECTED",null,null,"BING"]
["UNITED STATES",null,null,"MAPPOINT"]
["CANADA",null,null,"MAPTITUDE"]
["AUSTRIA",null,null,"CDXZIPCODE"]
["BELGIUM",null,null,"HERE"]
["DENMARK",null,null,"GOOGLE"]
["FINLAND"]
["FRANCE"]
["GERMANY"]
["GREECE"]
["ITALY"]
["LUXEMBOURG"]
["NETHERLANDS"]
["NORWAY"]
["PORTUGAL"]
["SPAIN"]
["SWEDEN"]
["SWITZERLAND"]
["UNITED KINGDOM"]

{"sheet":"Instructions","index":2,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[[77,2,77,14],[17,1,17,15],[25,1,25,15],[33,2,33,14]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX Technologies Support     "]
[null,null," Geocoding Template",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,"If you receive a VBA Macro Warning message when opening thnis template please click",null,null,null,null,null,null,null," the following article"]
[]
[null,null,"Note:  This template works with Microsoft Excel 2010 and higher, and is designed to be used for up to 65,536 rows of data.  If you need"]
[null,null,"to analyze more data or require additional customization, please email customsolutions@cdxtech.com or call (877) 239-8321."]
[]
[null,null,"This template determines the latitude and longitude of each listed address that can be matched to a location in HERE Technologies,"]
[null,null,"Maptitude. Bing Maps or Microsoft Mappoint."]
[]
[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 Google or HERE map data, your must have an API key entered in CDXZipStream. HERE API keys can be set up at "]
[null,null,"platform.here.com",null,"Goolge API keys can be established at",null,null,null,"console.cloud.google.com"]
[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,"If using Maptitude, no setup is required.  Youu can request a free trial through the following link:"]
[]
[null,null,"Get a free Maptitude Trial"]
[]
[null,null,"The program also supports currently established Bing developer and enterprise keys.   Please note that Microsoft is no longer"]
[null,null,"allowing new developer keys to be created.  Enterprise keys are still available for sale"]
[]
[null,null,"If using Microsoft MapPoint, this must also be installed."]
[]
[null,null,"Press the tab at the bottom of the screen or press the \"GET STARTED\" button above to go the \"Address Geocoding\" worksheet.  "]
[null,null,"enter your address list by street, city, state, postal code and country in columns B through F of the \"Address Geocoding\"   "]
[null,null,"worksheet.  Alternatively you may enter a complete address (street, city, state, postal code country) in column B. "]
[]
[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 "]
[null,null,"this template to confirm changes to the MapPoint version."]
[]
[null,null,"You also have the option to select the country of interest.  The selected country will be used if no country data is provided in column F."]
[null,null,"It will also override the default country setting in MapPoint, and will automatically be added to any complete address provided in"]
[null,null,"column B.  The option to select a country is disabled for Maptitude, since the template works exclusively with the U.S. version."]
[]
[null,null,"The CDXZipCode data source will use the US Postal Code database included with CDXZipStream or the optional Canadian database."]
[null,null,"No additional software is required.  Only the postal code column is used as an input."]
[]
[]
[null,null,"Press the \"GET COORDINATES\" button to start the geocoding process.  Cancel by pressing CTRL-Break or ESC (for Windows)"]
[null,null,"on your keyboard."]
[]
[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. Best Match - MapPoint did not find a good match, but here is the best of possible alternatives."]
[]
[null,null,"If all the returned data is a \"Best Match\" make sure you are using the appropriate version of MapPoint by selecting the \"Settings\""]
[null,null,"icon on the main CDXZipStream toolbar."]
[]
[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,"Before entering a new set of data, press \"CLEAR DATA\" to remove all old data."]
[]
[]
[null,null,"Copyright © 2024 Hughes Financial Services, Inc."]
[null,null,"Version 6.01"]