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:
RouteType
Acceptable Values: Prac (for Practical); Short (for Shortest); Natl (for State+National Network); Toll (for Toll Discouraged); Air (for Air Distance)
Default Setting: Prac
Region
If PC*MILER Worldwide is installed and you are entering a location outside North America, the correct region must be set first.
Acceptable Value: NA (for North America); AF (for Africa); AS (for Asia); EU (for Europe); ME (for Middle East); OC (for Oceania); and SA (for South America).
Default Setting: NA
Units (English)
Acceptable Values:
- Units = 0 (English) or 1 (Metric)
- OverPerm = 0 (False) or 1 (True) Should be set to True if the vehicle weight exceeds 80,000 lbs./36,287 kgs. (Assumes that an oversize permit has been obtained.)
- Height = 0-162
- Width = 96 or 102
- Length = >0
- Weight = 1000-132000
- Axles = 2-14
- LCV = 0 (False) or 1 (True)
Default Settings: Units = 0; OverPerm = 0; Height = 162; Width = 96; Length = 48; Weight = 80000; Axles = 5; LCV = 0
Units (Metric)
Acceptable Values:
- Units = 0 (English) or 1 (Metric)
- OverPerm = 0 (False) or 1 (True) Should be set to True if the vehicle weight exceeds 80,000 lbs./36,287 kgs. (Assumes that an oversize permit has been obtained.)
- Height = 0-4.11
- Width = 2.44 or 2.59
- Length = >0
- Weight = 454-60000
- Axles = 2-14
- LCV = 0 (False) or 1 (True)
Default Settings: Units = 1, OverPerm = 0, Height = 4.1148, Width = 2.44, Length = 14.6304, Weight = 36287.3906, Axles = 5, LCV = 0