PC*MILER Web Services Spreadsheets
A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.
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...
Mon, 15 Jun, 2020 at 2:00 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 option. All formulas w...
Wed, 21 Nov, 2018 at 4:27 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 f...
Wed, 19 Jul, 2023 at 2:58 PM
(For PC*MILER Web Services Spreadsheets) =MilesWS returns the mileage between two points (origin to the destination). The origin and destination may be ...
Tue, 19 Nov, 2024 at 8:21 PM
=DriveTimeWS returns the driving time (in hours:minutes format) from the origin to the destination calculated using the PC*MILER database. The origin and de...
Tue, 19 Nov, 2024 at 7:41 PM
(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...
Tue, 19 Nov, 2024 at 7:42 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...
Tue, 19 Nov, 2024 at 7:43 PM
(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). ...
Tue, 3 Mar, 2020 at 6:16 PM
=CityNameWS returns the city name and state or country abbreviation corresponding to the given postal code. U.S. ZIP codes, Canadian Postal Codes, and SPLCs...
Wed, 2 Jun, 2021 at 7:10 PM
=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...
Tue, 3 Mar, 2020 at 6:18 PM