Regions#

This function returns information on each state and its corresponding region, followed by each county and its corresponding region and subregion.

This function takes no parameters.

Syntax#

=SMX.Regions()

Example#

Retrieve region data:

=SMX.Regions()
An example of the Regions function

Output Parameters#

Field

Type

Description

Example

county

string

County in the state where the well is located.

“BEAUREGARD”

region

string

Aggregation of multiple major producing basins.

“GULF”

state_ab

string

Abbreviation of the state.

“LA”

sub_region

string

Aggregation of several counties, typically representing a major producing basin.

“S LA”


Errors#

Functions may return the following error messages:

Error

Description

#VALUE!

Input parameters are invalid or cannot be parsed.

#REF!

The function cannot retrieve data from the SynMaxax API due to a network or connectivity issue.

!!! EXCEPTION

Invalid input parameters. Make sure dates are enclosed in quotes. Check if the API key is valid. To know more about how to use an API key, please check the section on authentication.

#No Data

Input data is invalid or does not exist.

Note

You can also check the logs for more information on errors. You can access the logs by clicking on SynMax Energy on the Excel ribbon and then clicking on Logs.