(North America only; must be licensed for toll data)
=TollsWS calculates accurate, up-to-date toll charges in the U.S. and Canada. It works in the same way as the =MilesWS function, with an extra, optional argument to indicate if active toll discount programs should be used in calculations.
=TollsWS (origin, destination, tolldisc, routetype, dims, units, LCV, dataversion, traffic)
|origin||The origin of the trip.||yes||A geocodable location in the PC*MILER database. Learn more about how to input locations.|
new york, ny;118 broadway
|destination||The destination of the trip.||yes||A geocodable location in the PC*MILER database. Learn more about how to input locations.|
|tolldisc||A comma separated lists of the toll discount programs to be used in calculations.||no||Enter All for all programs or select a program or programs from this list. (Spelling must match.)|
|routetype||The PC*MILER route type to be used in mileage calculations. Learn more about PC*MILER route types.||no||Prac for Practical routing|
Short for Shortest routing
Natl for State + National Network routing
Toll for Toll Discouraged routing*
Air for the Air Distance
or, a combination:
Practical is the Default.
*Requires license for toll data.
|dims||The truck's dimensions.||no||Enter a number for each dimension in this order: height in inches; width in inches, length in feet, weight in pounds and number of axles.|
Each dimension must be separated by a comma. Leave a blank between two commas if you want to enter some values but not all.
|units||The units of measurement used in the dims argument.||no||English (Default)|
|LCV||Indicates whether the truck is a multi-trailer or longer combination vehicle.||no||True|
|dataversion||The data version to be used in mileage calculations. (For users licensed for multiple data versions.)||no||Enter PCM plus the version number:|
The range is PCM18 to PCM32
Current version is default
|traffic||Indicates whether or not use traffic data.|
(For users licensed for traffic data.)