{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Driving Calculations","Data","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":17,"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":"Driving Calculations","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,1,5,4],[5,6,5,9]]}
[]
[]
[]
[]
[]
[null,"FIRST ADDRESS",null,null,null,null,"SECOND ADDRESS",null,null,null,null,"CALCULATION"]
[null,"STREET (OR FULL ADDRESS)","CITY","STATE","POSTAL CODE","COUNTRY","STREET (OR FULL ADDRESS)","CITY","STATE","POSTAL CODE","COUNTRY"]

{"sheet":"Data","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,1,null,null,1,null,null,null,1]
[]
[null,null,"QUICKEST",null,null,"DRIVING DISTANCE IN MILES",null,null,null,"NO COUNTRY SELECTED"]
[null,null,"SHORTEST",null,null,"DRIVING DISTANCE IN KM",null,null,null,"UNITED STATES"]
[null,null,"PREFERRED",null,null,"DRIVING TIME IN MINUTES",null,null,null,"CANADA"]
[null,null,null,null,null,"DRIVING TIME IN HOURS",null,null,null,"AUSTRIA"]
[null,null,null,null,null,"DRIVING TIME IN DAYS",null,null,null,"BELGIUM"]
[null,null,null,null,null,"DRIVING COST",null,null,null,"DENMARK"]
[null,null,null,null,null,"TRIP DURATION IN HOURS",null,null,null,"FINLAND"]
[null,null,null,null,null,null,null,null,null,"FRANCE"]
[null,null,null,null,null,null,null,null,null,"GERMANY"]
[null,null,null,null,null,null,null,null,null,"GREECE"]
[null,null,null,null,null,null,null,null,null,"ITALY"]
[null,null,null,null,null,null,null,null,null,"LUXEMBOURG"]
[null,null,null,null,null,null,null,null,null,"NETHERLANDS"]
[null,null,null,null,null,null,null,null,null,"NORWAY"]
[null,null,null,null,null,null,null,null,null,"PORTUGAL"]
[null,null,"QUICKEST",null,null,"DRIVING DISTANCE IN MILES",null,null,null,"SPAIN"]
[null,null,"SHORTEST",null,null,"DRIVING DISTANCE IN KM",null,null,null,"SWEDEN"]
[null,null,"QUICKEST WITH TRAFFIC",null,null,"DRIVING TIME IN MINUTES",null,null,null,"SWITZERLAND"]
[null,null,null,null,null,"DRIVING TIME IN HOURS",null,null,null,"UNITED KINGDOM"]
[null,null,null,null,null,"DRIVING TIME IN DAYS"]
[]
[]
[null,null,5]
[]
[null,null,"BING"]
[null,null,"MAPPOINT"]
[null,null,"MAPTITUDE"]
[null,null,"HERE"]
[null,null,"GOOGLE"]
[]
[]
[null,null,"SHORTEST"]
[null,null,"QUICKEST"]
[]
[null,null,"N/A"]

{"sheet":"Instructions","index":2,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[[15,1,15,15],[23,1,23,15],[32,2,32,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX Technologies Support     "]
[null,null,"Driving Calculations 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,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 calculates driving parameters, such as time and distance, between pairs of addresses."]
[]
[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 \"Driving Calculations\" worksheet.  "]
[null,null,"Enter the first address data on the \"Driving Calculations\" tab in Columns B through F, starting at row 8.  Enter the second "]
[null,null,"address data in Columns G through K.  Alternatively you may enter a complete address (street, city, postal code country) in "]
[null,null,"columns B and G. "]
[]
[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,"Select the desired route type.  When using Bing, selecting the \"Quickest with traffic\" option calculates the route with the shortest time"]
[null,null,"while considering current traffic conditions.  When using MapPoint, the \"Preferred\" option takes into account road type, speed,"]
[null,null,"and fuel cost settings when calculating the driving route.  To specify these settings, select  \"Settings\" on the CDXZipStream "]
[null,null,"toolbar."]
[]
[null,null,"You can also select the country of interest.  The selected country will be used if no country data is provided in columns F or K.  "]
[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,"columns B and G.  The option to select a country is disabled for Maptitude, since the template works exclusively with the U.S. version."]
[]
[null,null,"At the top of Column L, select the desired route calculation.  These selections will vary depending upon whether Bing or MapPoint"]
[null,null,"is being used."]
[]
[null,null,"Press \"CALCULATE\" to start the driving calculations.  Cancel by pressing CTRL-Break or ESC (for Windows) on your keyboard."]
[]
[null,null,"The results of the calculation will be shown in column L for each pair of addresses."]
[]
[null,null,"If a listed address cannot be found, it will indicate in column L that the address is ambiguous, invalid, or could not be found."]
[null,null,"Check for spelling errors or typos in the original address."]
[]
[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"]