DucsByOperator

Drilled but uncompleted wells (DUCs) are oil and natural gas wells that have been drilled but have not yet undergone various well completion activities. We define a well as a DUC from the date on which drilling begins, upto the date a frac crew finishes completing the well and moves off the wellpad.

This endpoint returns drilled but uncompleted wells by operator (the company that runs the well).

Syntax

=SMX.DucsByOperator(Aggregate By, Operator, Region, Subregion, County)

Arguments

Parameter	Description	Example
Aggregate By	Specifies a parameter by which to aggregate data.	"date"
Operator	Limit search by the name of the operator whose wells to retrieve.	"A WILLIAMS OIL"
Region	Limit search by the name of the region where the wells are located.	"west"
Subregion	Limit search by the name of the subregion where the wells are located.	"Haynesville - TX"
County	Limit search by county where the well is located.	"Winkler"

Data can be aggregated by: county, date, region, state_code, sub_region.

Note

Performance considerations: This function may take some time to retrieve and organize large amounts of data. For best performance, it is recommended to limit the number of input parameters and retrieve only the data needed for analysis.

Note

No Data: Output data will return “#No Data” when input data is invalid or does not exist.

---

Examples

1. To retrieve DUCs for a specific operator and region:

=SMX.DucsByOperator(,"EXXON MOBIL","WEST")

2. To retrieve DUCs with a specific subregion:

=SMX.DucsByOperator(,,,"S LA")

3. To retrieve DUCs for a specific operator:

=SMX.DucsByOperator(,"EXXON MOBIL")

4. To retrieve DUCs aggregated by date:

=SMX.DucsByOperator("date")

---

Output Parameters

Field	Type	Description	Example
count	integer	Number of drilled but uncompleted wells (DUCs) on a specific date within the input date range.	2
county	string	County in the state where the well is located.	“BEAUREGARD”
date	string	Date on which the DUC count is being compiled. Date formatting - [“YYYY-MM-DD”]	“2022-06-01”
operator_name	string	Operator of the well.	“PIE OPERATING, LLC”
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”

---

Note

When the aggregate_by parameter is used, ducs_count is returned instead of count.

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.