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()
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.