MileCharter supports route cost calculations using rate tables or road types. Rate tables allow costs or rates to be individually specified for different distance ranges.
Driving costs are set using the Costs and Rate Tables dialog box. This is displayed by pressing the Costs button on the main panel:
To set different costs according to the road type, set Type of rate table to Costs by Road Type. Then press the Set Road Costs button to edit the road costs. Costs by Road Type is not available for straight line distance calculations because these distances do not use roads.
The remaining options refer to different types of rate table. Rate tables set the cost according to the total road distance. These might be useful to calculate delivery charges according to the destination's distance from your location.
The simplest rate table that of a Constant Rate:
Selecting this option makes the Fixed Rate box appear. Use this to set the cost per distance unit (i.e. 0.5 in the above example). If the Maptitude distance units are set to 'miles', this will calculate all route costs at 0.50 per mile.
The other rate table options all require a rate table file to be specified:
Press the "..." button to the right of the file name, to select the file that stores your rate table.
There are three types of rate table. These are Fixed Rate Table, Apply Rate for Full Distance, and Apply Rates over Intervals. These type settings determine how the values in the table are interpreted and used. For example, the Fixed Rate Table will record a fixed cost for all distances within each range. The other two types specify a cost rate on a per distance unit basis. See the Types of Rate Table page for a full discussion of these different types.
Individual values in the rate table file can be separated using a comma (i.e. a standard 'CSV' file); a semi-colon; or with a tab character. Use the Field Separator option to specify the separator used in your rate table file.
Some rate table files may have column headers that must be ignored. Set the Ignore First Line check box, if the first line is a header that must be ignored.
The rate table file is a basic text file, and can be written using a text editor (e.g. Notepad) or output from Excel. Here is a simple example that uses a comma separator:
This example has a header. To use it, the Ignore First Line box must be checked. Each line holds one entry for the table. The first value is a distance. The second value is the corresponding rate. This rate is applied to all distances between the preceding distance and this one. In the above example, a rate of 2 is applied for all distances less than 10, and a rate of 3.5 is applied for all distances between 10 and 25.