(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.)
Syntax
=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:
=MilesWS(13090,17815,Prac,,,,PCM32)
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. Examples: Princeton, NJ 08540 M4C 4Y740.420833N,74.561111W new york, ny;118 broadway 191690000 |
| 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) Short (Shortest) Natl (State + National Network) Toll (Toll Discouraged)* Air (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, 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. Examples: 162,96,53,80000,8 162,,53,,8 |
| units | The units of measurement used in the dims argument. | no | English (Default) Metric |
| LCV | Indicates whether the truck is a multi-trailer or longer combination vehicle. | 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 |
| traffic | Indicates whether or not use traffic data. (For users licensed for traffic data.) | no | True False (Default) |