This example demonstrates how to use Ultra MileCharter to report the route distances and estimated costs from a group of depots to a customer. Unlike the other examples, is based in the UK and uses the british-isles-fastest road pack. The input data can be found in the yorkshire_depots.xls spreadsheet and the ratetable1.csv text file in the Ultra Mileage examples file:
The customer is found on the Customer worksheet:
The depots are found on the Depots worksheet:
Although both worksheets have street address data, we will be using the coordinates. At this time, Ultra Mileage does not provide geocoding.
Start Ultra MileCharter to display the main MileCharter panel:
We have set the Output to create Distances, Times, and Costs, The road data has been set to use the standard british_isles-fastest.umg road pack. This can be downloaded with the Ultra Download Manager. In the Output Options we have also checked the Reverse Axes check box to make the resulting table more readable. The Customer will appear on the top axis, and each destination depot will have its own row.
Set the input location data by setting the Location Source to Excel and pressing the Change button to display the Input Locations dialog box:
Set the source worksheet to be the Customer worksheet, and the destination worksheet to be Depots. Set the columns as above. We use each location's Name column to identify each location. Press OK to return to the main panel.
Next we shall set the rate table to use when estimating the costs. This table is stored in ratetable1.csv. Press the Costs button to set this information:
This is set to use the ratetable1.csv file, and to apply the rate tables over each interval. The file is a comma-separated value file, so we have set the separator to be a comma (','). You can also select a semicolon (';') or tab character. We do not have a line of header names, so we clear the Ignore First Line check box.
This is what the ratetable1.csv file looks like:
The first column of values are distances (miles in this case), and the second column stores the cost values. As we have selected this as a rate, and we are in the UK, this would be interpreted as "£ per mile". You can also select fixed rates where the cost is a fixed amount for each distance range. Similarly, the rates can be applied over the entire distance, or each interval. See Types of Rate Table for a more complete explanation.
Press OK to return to the main panel. Everything has been set, so press Compute to start the calculations.
Here is the resulting distance table:
And here are the calculated costs (£/mile):
Note that the North Leeds Office is the closest, and as expected the cheapest route. Marsden Office is the only office in the outer (most expensive) rate tier, and hence has a significantly more expensive final cost.