A driver profile can be set up to customize driving time and cost calculations with the CDXRouteMaptitude function. Options can be tailored to specify driving speeds, fuel and other program options. Driving cost calculation can be made on the basis of fuel cost or a fixed rate per mile. To access these function press the "Route Settings" button on the CDXRouteMaptitude right-click interface, or press "Maptitude Settings" from the "Settings" icon on the main CDXZipStream menu in Excel. The following interface will be displayed:
Changing these parameters will affect all future calculations of the CDXRouteMaptitude function. They are not specified as part of the formula itself but are set globally, Unless prior CDXRouteMaptitude formulas are recalculated they may still contain older option settings. Route options are not set until you press "OK" on the interface; pressing Cancel will leave options as before. Changes will be saved for future CDXZipStream use.
You can choose to optimize routes of 3 or more stops, specify the types of reports in the Trip Summary and determine the format of the direction and waypoint output. These can be output as a single string or in a formula array that covers multiple cells. Note that route optimization using Maptitude assumes a fixed start point where the optimized route both begins with the same location as the original waypoint list.
Driving speeds can be specified from slow to fast in 8 discrete steps. The driving speed reset function will clear any changes you have made to the original values. To access the fuel and driving cost options click on the matching tab of the dialog.
Here are examples of the Fuel and Driving Cost options tabs with default values:
A driver schedule option is available which allows you to set start and stop times and other parameters which will be reflected in the Trip Duration calculation and the times listed in driving directions.