MPMileage supports route cost calculations using rate tables or road types. Rate tables allow costs or rates to be 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 dialog box:
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 is that of a Constant Rate:
The other types of rate table consist of actual tables that specify different rates for different distances. These are defined using a rate table file.
Select the rate table type (these are explained below), and then press the "..." button to the right of the file name, to select the file that stores your rate table.
There are three types of 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.