(North America only; must be licensed for toll data)
=DiscountedTollsWS returns the portion of the tolls for the trip attributable to the specified discount program. If tollplan is set to Cash, it returns the cash portion; if set to EZPass it returns the EZPass portion, etc.
Syntax
=DiscountedTollsWS (origin, destination, tollplan, routetype, dims, units, LCV, dataversion, traffic, hazmats, highwayonly, tollcurrency, countries, region)
Arguments
| Argument | Description | Required? | Values |
| origin | The origin of the trip. | yes | A geocodable location in the PC*MILER database. Learn more about how to input locations. |
| destination | The destination of the trip. | yes | A geocodable location in the PC*MILER database. Learn more about how to input locations. |
| tollplan | (North America Only) The toll discount program to be used in calculations. | no | Enter Cash for the cash portion of tolls or select a program 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: Prac|Natl Short|Toll 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. You can submit all dimensions or only some of them. If you want to skip a particular dimension, enter two commas with no space between them. Examples: 162,96,53,80000,8 162,,53,,8 |
| units | The units of measurement used in the dims argument. Also sets whether distances are returned in miles or kilometers. | no | English (Default) Metric |
| LCV | Indicates whether the truck is a multi-trailer or longer combination vehicle. Used for toll calculations in North America. | no | True False (Default) |
| 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 PCMXX (Current Version) Current version is default. Make sure the version is in quotes (e.g. "PCM38") to avoid an accidental cell reference in Excel. |
| traffic | Indicates whether or not use traffic data. (For users licensed for traffic data.) | no | True False (Default) |
| hazmats | A list of the hazmat categories that should be applied to the routes created for mileage calculations. | no | 0 = None (Default) 1 = General 2 = Caustic 3 = Explosives 4 = Flammable 5 = Inhalants 6 = Radioactive 7 = HarmfulToWater 8 = Tunnel (Separate by commas to pass more than one category in this argument.) |
| highwayonly | (North America Only) Calculates routes using an air distance from the midpoint of the truck-usable highway segment that is nearest to the destination postal code or city/state. | no | True False (Default) |
| tollcurrency | The currency in which to return toll costs. | no | US (U.S. Dollars) is default in North America and EUR (Euro) is default in Europe. See other values. |
| countries | The country or countries where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | A two-letter country code |
| region | The region of the world where the origin and destination are located. | Not required but recommended for the most accurate geocoding and best performance. | Region Codes are NA (North America), EU (Europe), AS (Asia), AF (Africa), SA (South America), OC (Oceania), MX (Mexico), ME (Middle East), and WW (Worldwide). |