HERE Api Settings
Previous  Top  Next

The HERE Api Settings dialog allows you to edit settings for HERE driving and routing calculations available through the functions CDXRouteHere and CDXLocateHere. Also use this dialog to set the HERE Api key required to use these functions, and to track the number of HERE data requests made for the current session of Excel.

Start by clicking on the "Settings" icon on the main CDXZipStream™ commandbar, then "HERE Api Settings":


HERE Api Settings are also available through the CDXRouteHere and CDXLocateHere dialogs.

Next you'll see the main HERE Api Settings dialog:


Data Request Tracking: This states the number of data requests made for the current Excel session. This number resets to zero when Excel is closed.

Avoid Options: Select the appropriate options (avoiding or minimizing highways and tolls) to control how HERE selects routes. The default is no selections.

Direction and Waypoint Output: Select "Single String" or "Array Formula" for the output of directions and waypoints from CDXRouteHere. "Single String" output will provide output data as a text string within a single worksheet cell, and "Array Formula" will provide output data as an array over multiple cells. In general, Select "Single String" when obtaining data for multiple routes, and "Array Formula" for a single route.

Map Style: Select the desired location map or route map style from HERE. Not all map styles are available for all locations; HERE will default to a road style map if the selected style is unavailable.

Trip Summary: Select whether the Trip Summary provided by CDXRouteHere includes a map and waypoint list.

Optimize: Select whether the order of the waypoints will be automatically optimized.

Fixed End Point: For optimizing routes, you can select whether the end point is fixed. With a fixed end point, the optimized route will both begin and end with the same locations as the original waypoint list. With a non-fixed end point only the beginning of the route is fixed, and optimization will select an end point that facilitiates return to the beginning location.

Validate Waypoints before Routing in HERE: The input locations will be checked for validity (i.e. if they can be found in HERE) before calculating routes with CDXRouteHere.

Set HERE Api Key: The functions CDXRouteHere and CDXLocateHere require entering a HERE Api license key into CDXZipStream.

Transit Start Time - Set the start time of the current day for Transit calculations. This does not impact Driving or Walking calculations.