MileCharter supports route cost calculations using rate tables. 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. Costs are determined using rate tables which 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:
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 MileCharter distance units are set to 'miles', then 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 should 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.