Spreadsheets: Change Route Options

The functions =Miles, =MilesEX, =Tolls, =TollsEx, =DiscountedTolls, and =DiscountedTollsEx can be used with eight optional parameters for custom vehicle dimensions. If these fields are left blank, the default settings will be used.

To enter custom vehicle dimensions or see default values, you need to open the Function Arguments window (click fx on the tool bar), select one of the functions mentioned above, and then scroll down to see all the dimension fields.

When a custom vehicle weight or height is entered, PC*Miler route calculations will take into account restrictions on roads and bridges. Additionally, PC*Miler supports calculation of routes and toll costs for smaller vehicles (vans, pickup trucks, SUVs, automobiles, etc.) that are classed less than 9,000 lbs./4,082 kgs.

When entering formulas in PC*Miler Spreadsheets, the only required arguments are Origin and Destination. There are optional arguments for vehicle dimensions and routing preferences you can add to customize the routes used in time, distance, and cost calculations. They include: