Show/Hide Toolbars

Ultra Mileage

Navigation: Ultra MileCharter

Output Options

Scroll Prev Top Next More

The Output Options are grouped in the top right corner of the main MileCharter panel.


The first option (Output to) sets the destination format. This can be Excel or Text File. The Excel option will cause MileCharter to start Excel and to use it to create a workbook. It will also enable the Load/Run Excel Addins and macros check box. Use this check-box if you have add-ins and/or macros enabled in Excel. These will often cause problems with COM automation (i.e. MileCharter), so you may wish to disable them during MileCharter operation. The Text File option is described on the Writing to a Text File page.


If you select output to Excel, MileCharter will typically display Excel at the end so that you can check the results before saving them. If you wish, you can tell MileCharter to save the resulting workbook to a file by setting the Close and Save to check box, and then selecting an output workbook file. Any existing workbook file with the same name will be over-written. Excel will also be closed at the end. This functionality is very useful if you are running Ultra MileCharter in batch mode from the command line. You can also tell MileCharter to hide Excel during processing by setting the Hide Excel during processing check box. Hiding Excel during processing is also useful in batch mode, but it can also result in a small speed-up.


The Decimal Places setting is used to set the number of decimal places for floating point results. I.e. these are used for distances, and travel times when they are reported as minutes or hours (but not hours:minutes:seconds). This setting can range from 0 to 6 decimal places. For text files, this sets the actual number of decimal places written to the file. For Excel worksheets, this sets the display format only. All values are written to Excel with all available precision.


Usually, the start points are listed on the left side of the chart and the end points are listed along the top of the chart. These may be swapped by checking the Reverse Axes check-box.


By default, the start and end points are written to the output in the order that they are found in the input datasets. They can be sorted by checking the Sort Names check box. The sort is a 'natural' sort - i.e. an alphabetic sort that can also sort numeric strings (e.g. numeric identifiers) correctly.


MileCharter can also write the longitude,latitude coordinates of the source and destination locations. Check the Output Coordinates check box if you wish to have these coordinates saved to the table axes.