PC*MILER|Spreadsheets includes a number of functions that allow you to retrieve location information from the PC*MILER database.

Getting a Latitude/Longitude from a Location

=CityToLatLong (CityStateOrZipcode)

CityToLatLong takes a PC*MILER location (city-state, postal code, SPLC, truck stop, PC*MILER custom name) and returns the latitude/longitude of a point central to the location in degrees, minutes, seconds format (dddmmssN,dddmmssW). CityToLatLong returns -1 if the PC*MILER place name you entered is invalid.

Getting a Place Name from a Latitude/Longitude

=LatLongToCity (LatLong)

LatLongToCity takes a latitude/longitude (degrees, minutes, seconds or decimal degrees format) and returns the miles from the PC*MILER place name at the closest end of the closest road segment. This may be either a city-state or a road intersection.  

This function connects latitude/longitudes to the highway network as if you were routing to or from the latitude/longitude. LatLongToCity returns a -1 if the lat/long format is invalid or is more than 200 miles from a road in the PC*MILER highway network.

The CityToLatLong and LatLongToCity functions may be, but are not necessarily, reversible because not all PC*MILER place names are located at the end points of road segments.

Getting a Latitude/Longitude from an Address

=AddressToLatLong (Address)

(In North America with PC*MILER|Streets only) AddressToLatLong takes a PC*MILER|Streets address and returns the latitude/longitude in degrees, minutes, seconds format (dddmmssN,dddmmssW). AddressToLatLong returns -1 if the place name you entered is invalid. 

The function may be, but is not necessarily reversible. For a decimal format return, see the PCMSERVE.INI.

Getting an Address from a Latitude/Longitude

=LatLongToAddress (LatLong)

(In North America with PC*MILER|Streets only)  LatLongToAddress takes a latitude/longitude (degrees, minutes, seconds or decimal degrees format) and returns the address. This function connects latitude/longitudes to the highway network as if you were routing to or from the latitude/longitude.  

LatLongToAddress returns a -1 if the lat/long format is invalid or is more than 200 miles from a road in the PC*MILER|Streets highway network. The function may be, but is not necessarily reversible.

For roads that have both a street name and a route number, the route number will be returned in parentheses after the street name. For example: 

=latlongtoaddress(addresstolatlong("Princeton, NJ; 245 Nassau Street")) returns

08540 Princeton, NJ, Mercer; 245 Nassau Street (NJ-27).