PC*MILER Web Services Spreadsheets
A guide to using PC*MILER Web Services Spreadsheets, an add-in for Microsoft Excel.
=CityNameWithCountyWS takes a PC*MILER location and returns the city name with state and county. Any PC*MILER location (city-state, postal code, six-digit C...
Wed, 2 Jun, 2021 at 7:32 PM
=CityToLatLongWS takes a PC*MILER location (city/state, postal code, SPLC, truck stop, PC*MILER custom name) and returns the latitude/longitude of a point c...
Tue, 3 Mar, 2020 at 6:21 PM
=LatLongtoCityWS returns the name of the closest city to the latitude/longitude entered. Returns a -1 if the lat/long format is invalid. Syntax =L...
Tue, 3 Mar, 2020 at 6:21 PM
(North America only; must be licensed for streets data) =AddressToLatLongWS takes an address and returns the latitude/longitude. Returns -1 if the plac...
Tue, 3 Mar, 2020 at 6:22 PM
=LatLongToAddressWS takes a latitude/longitude and returns the address. Returns a -1 if the lat/long format is invalid. Syntax =LatLongtoAddressWS(...
Tue, 3 Mar, 2020 at 6:23 PM