Ultra Mileage logo

Mapping-Tools logo Ultra Mileage

Ultra Fast Batch Route Calculations

Ultra MileCharter Walkthrough

This walkthrough shows you how to create your first mileage table using Ultra MileCharter. It is aimed at people who are new to the Ultra Mileage system. We also have a walkthrough for Ultra One2OneMileage.

There is a screenshot of Ultra Download Manager or Ultra MileCharter for each step of the walkthrough. Click on the small thumbnail to open a new window with a full size version of the screenshot.

The following example uses the USA Contiguous; Fastest road pack and the TXLA.xlsx spreadsheet from Ultra Mileage Examples File. Other road packs will work in the same manner, but you will need to substitute different input data. The TXLA.xlsx input data will produce a mileage chart between locations (Texas cities and Louisiana) that are listed in the input data.

Main panel of the Ultra Download Manager

Download the Road Pack

If you have not downloaded the USA Contiguous; Fastest road pack, you should start by running the Ultra Download Manager. If this is the first time the Download Manager has been run, you will be presented with the Folders for Ultra Road Data dialog box.

The Folders for Ultra Road Data dialog box

The Folders for Ultra Road Data dialog box is used to set the folders (file directories) that will store the downloaded OpenStreetMap PBF files and the road packs. You can also display this dialog box by pressing the System Paths button on the main Download Manager panel.

Return to the main Download Manager panel. Press the Update Catalog button to refresh the data catalog. This catalog lists all of the files that are available for download. An online list of available road packs can also be found here.

After the catalog has updated, open up the USA-contig folder and select USA-contig-Fastest (as above). This may also select the root USA-contig to also download the matching OpenStreetMap PBF file.

Download progress

After selecting the file(s), press the Start button to start downloading. The download manager will display the Progress dialog box. We have selected over 5GB of data, so this will take some time to download. The Ultra Download Manager will automatically uncompress the road pack(s) after downloading.

After a successful download, you are ready to move on to Ultra MileCharter.

The input Texas cities

Computing the Mileage Chart

We will create a mileage chart between a group of Texas cities and a group of Louisiana cities. Both groups of cities are stored in their own worksheets in the TXLA.xlsx Excel workbook. Each worksheet requires a coordinate (longitude and latitude as two columns) and a name or other identifier. The example here is of the Texas worksheet. The Louisiana worksheet is formatted in the same manner.

Ultra MileCharter's Main Panel

Start Ultra MileCharter to create the mileage chart. Press the '...' button in the Road Data box to select the usa-fastest roadpack that you downloaded. This is the usa-fastest.umg file in the download directory's root.

Set the Distances and Times checkboxes, and the respective units to Miles and Hours:Minutes. Set the output to Excel and set the Sort Names check box. Make sure the Only report the shortest/quickest route checkbox is clear.

Ultra MileCharter's Input Locations Panel

Set the Location Source (in the Locations box) to Excel and press the Change button to display the Input Locations: Excel Workbook dialog box.

In the Input Locations dialog box, select the TXLA.xlsx input workbook. Then set the Source Worksheet to Texas Cities, and Destination Worksheet to Louisiana Cities. This input data uses human-readable column headers on the first row, so set both First Row Contains Column Headers checkboxes. Select the three required columns for each worksheet. These specify the columns that store the longitude, latitude, and name (or identifier) data.

Press OK to return back to the main panel.

The distance results in miles

Everything has now been set, so press the Compute button on the main panel to start computation. There will be a pause as the road data is loaded, if you have not set it to pre-load.

Here is the resulting distance table. Units are in miles. Note that the units and optimization type (fastest or shortest routes) are written in the top left column (A1).

The travel time results in hours:minutes:seconds

And here is the travel time worksheet in the same workbook. Time units have been reported as hours:minutes:seconds.

The Quality Control (QC) view of one of the routes

Unlike previous versions of MileCharter, Ultra MileCharter does not have a host application that can be used to visualize and check the routes are going where you expect them to go. Because of this, Ultra MileCharter has the new QC feature. This lets you draw a route on a Maptitude map image, on OpenStreetMap imagery, or in a KML file. The KML file option can store multiple routes which can then be viewed in an application such as Google Earth.

Here, we will use the OpenStreetMap option. This requires an Internet connection. Select OSM MapControl in the QC box, and press the QC button. This will display the Route QC dialog box. Select the required source and destination locations for the route and press the Show >>> button. This will then draw the route as a purple line on a map created using OpenStreetMap tile imagery. Green and red markers are used for the source and destination locations, respectively.

The OSM MapControl can be zoomed and panned by using the mouse. Use the mouse wheel to adjust the zoom, and drag with the right mouse button to pan.

Congratulations! You have created your first mileage chart with Ultra MileCharter! We also have a walkthrough for Ultra One2OneMileage.

Buy Ultra Mileage Now!