(North America Only) If the Tolls add-on module is installed with PC*MILER, Spreadsheets will include two functions that calculate accurate, up-to-date toll charges in the U.S. and Canada.
1. The =Tolls function works in the same way as the Miles function, with an extra parameter to indicate if active discount programs should be used.
=Tolls (origin,destination,discount [,routeType])
2. The =DiscountedTolls function returns the portion of the tolls for the trip attributable to the specified discount program.
=DiscountedTolls (origin,destination,discountProgram [,state][,routeType])
The =Tolls function returns the total toll amount (in dollars) from the origin to the destination. If discount is set to FALSE, all cash tolls will be used. If set to TRUE, discount programs that are activated in PC*MILER (Application Settings > Tolls) will be used where they apply in computing tolls. RouteType is an optional parameter that defaults to “Practical”.
The =DiscountedTolls function returns the portion of the tolls for the trip attributable to the specified discount program. If discountProgram is set to “Cash”, it returns the cash portion; if set to “EZPass” it returns the EZPass portion, etc.
The discountProgram values must be spelled as shown in the list of programs. Spaces and dashes must be entered exactly as they appear there, but case does not matter (e.g. “E-Pass” or “e-pass” are both acceptable).
If a state is specified, only the tolls in that state are returned. If the state is missing or an empty string, all states are included.
Getting Toll Data from Latitude/Longitudes
If the Tolls add-on was purchased and installed, toll data can be calculated in Spreadsheets using latitude/longitude points.
In the example below, the Discount parameter is set to TRUE so that discount programs that are activated in PC*MILER (Application Settings > Tolls) will be used where they apply in toll calculations. The RouteType optional parameter is missing and therefore defaults to Practical routing.