PC*MILER Web Services Spreadsheets

A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.

Getting Started With Web Services Spreadsheets
PC*MILER Web Services Spreadsheets is an Add-in for Microsoft Excel that allows you to easily generate PC*MILER mileage and location information from within...
Wed, 23 Jan, 2019 at 5:22 PM
Using Web Services Spreadsheets
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 option.  All formulas w...
Wed, 21 Nov, 2018 at 4:27 PM
Entering Locations in Web Services Spreadsheets
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 f...
Wed, 21 Nov, 2018 at 4:21 PM
Getting the Miles Between Two Points (=MilesWS)
=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 (...
Fri, 2 Nov, 2018 at 12:41 PM
Getting the Drive Time Between Two Points (=DriveTimeWS)
=DriveTimeWS returns the driving time (in hours and minutes) from the origin to the destination calculated using the PC*MILER database. The origin and desti...
Fri, 2 Nov, 2018 at 1:06 PM
Getting Toll Data (=TollsWS)
(North America only; must be licensed for toll data)  =TollsWS calculates accurate, up-to-date toll charges in the U.S. and Canada.  It works in the sam...
Fri, 2 Nov, 2018 at 1:08 PM
Getting Discounted Tolls Data (=DiscountedTollsWS)
(North America only; must be licensed for toll data)  =DiscountedTollsWS returns the portion of the tolls for the trip attributable to the specified dis...
Fri, 2 Nov, 2018 at 1:09 PM
Getting the ZIP/Postal Code from a City Name (=ZipCodeWS)
(U.S. only) =ZIPCodeWS returns the ZIP code corresponding to any U.S. place name. The place name is a city with a state abbreviation (e.g. Austin, TX). ...
Fri, 2 Nov, 2018 at 1:09 PM
Getting a City Name from a ZIP/Postal Code (=CityNameWS)
=CityNameWS returns the city name and state or country abbreviation corresponding to the given postal code. Canadian Postal Codes, SPLC, and 3-digit U.S. ZI...
Fri, 2 Nov, 2018 at 1:09 PM
Getting the Full ZIP/Postal Code and City Name (=FullNameWS)
=FullNameWS returns the ZIP/Postal code or SPLC code, city/state abbreviation, and county name corresponding to the given location. Any PC*MILER location (c...
Fri, 2 Nov, 2018 at 1:13 PM