(For PC*MILER Web Services Spreadsheets)
=MilesWS returns the mileage between two points (origin to the destination). The origin and destination may be entered as a city with a state abbreviation (e.g. Paris, TX), a city/state and address, a ZIP/Postal code, SPLC, latitude/longitude point, or a custom place created in ContentTools. (Applicable licensing applies for certain types of data.)
=MilesWS (origin, destination, routetype, dims, units, LCV, dataversion, traffic)
If you want to use some of the non-required arguments, but not all of them, include commas as placeholders for the arguments you are leaving out.
For example, if you want a practical route between 13090 and 17815 in PC*MILER 32, the syntax would be:
|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.|
|routetype||The PC*MILER route type to be used in mileage calculations. Learn more about PC*MILER route types.||no||Prac (Practical)|
Natl (State + National Network)
Toll (Toll Discouraged)*
Air (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, trailer 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 PCMXX (Current Version)
Current version is default
|traffic||Indicates whether or not use traffic data.|
(For users licensed for traffic data.)