The latest version of PC*Miler Web Services Spreadsheets includes two new functions that allow you to set a worldwide region and a country to narrow and improve location search results. (Contact us to download the latest version.)
- =SetDefaultRegionWS( ): Sets the worldwide region (NA, EU, WW, SA, AS, OC, AF, ME) used for location searches. This setting helps prevent erroneous location matches in other regions, and it also may improve performance by reducing the search's scope.
- =SetDefaultCountryWS( ): Sets the country (e.g. US, CA, UK, MX) used for location searches. This setting helps prevent erroneous location matches in other countries, and it also may improve performance by reducing the search's scope.
=SetDefaultRegionWS( )
Syntax
=SetDefaultRegionWS (Region)
Example
=SetDefaultRegionWS (EU)
Arguments
| Argument | Description | Required? | Values |
| Region | The default worldwide region you want to use for location searches. | yes | NA - North America EU - Europe WW - Worldwide data SA - South America AS - Asia OC - Oceania AF - Africa ME - Middle East |
=SetDefaultCountryWS( )
Syntax
=SetDefaultCountryWS (Country)
Example
=SetDefaultCountryWS (IT)
Arguments
| Argument | Description | Required? | Values |
| Country | The default country you want to use for location searches. | yes | A two-letter country code. |