PC*MILER Web Services Spreadsheets
A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.
(An updated version of PC*Miler Web Services Spreadsheets was released in March 2025. Contact us to get the latest version.) PC*Miler Web Services Sprea...
Thu, 27 Mar, 2025 at 5:24 PM
There are two ways to use PC*Miler Web Services Spreadsheets in Excel—type a formula directly into a cell or use the Insert Function (fx) option. All formu...
Wed, 26 Mar, 2025 at 12:18 PM
Depending on the types of data you are licensed to use with your PC*Miler Web Services Spreadsheets API key, you can enter origins and destinations in the w...
Wed, 26 Mar, 2025 at 12:24 PM
PC*Miler Web Services Spreadsheets includes two functions that allow you to set a worldwide region and a country to narrow and improve location search resul...
Wed, 26 Mar, 2025 at 12:27 PM
(For PC*Miler Web Services Spreadsheets) =DistanceWS returns the distance between two points (origin to the destination). Distances are returned in mile...
Wed, 26 Mar, 2025 at 12:08 PM
(For PC*Miler Web Services Spreadsheets) =MilesWS returns the mileage between two points (origin to the destination). Syntax =MilesWS (origin, des...
Wed, 26 Mar, 2025 at 12:08 PM
=DriveTimeWS returns the driving time (in hours:minutes format) from the origin to the destination. Syntax =DriveTimeWS (origin, destination, routetype...
Wed, 26 Mar, 2025 at 12:08 PM
(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 =MilesW...
Wed, 26 Mar, 2025 at 12:08 PM
(North America only; must be licensed for toll data) =DiscountedTollsWS returns the portion of the tolls for the trip attributable to the specified dis...
Wed, 26 Mar, 2025 at 12:08 PM
All of the geocoding functions include a ConfidenceLevel arugment, which is optional and not necessary in most cases. ConfidenceLevel limits geocoding r...
Fri, 28 Feb, 2025 at 1:10 PM