fraccrews

This function returns frac crew location by wellpad and date. It sends a post request to the Hyperion V4 fraccrews endpoint.

In the Formula Builder, select Hyperion 4.0, then choose the fraccrews function from the Enter Function dropdown. Next, select the required fields and click Insert to automatically add the formula to Excel.

Syntax

=SMXH4.fraccrews(aggregate_by,county,date_frac_max,date_frac_min,frac_class,operator,region_natgas,service_company,state_code,sub_region_natgas)

---

Arguments

Parameter	Description	Example
aggregate_by	Specifies a parameter by which to aggregate data.	"date"
county	Limit search by county where the well is located.	"Winkler"
date_frac_max	A date in MM/DD/YYYY format	"12/31/2022"
date_frac_min	A date in MM/DD/YYYY format	"1/3/2022"
frac_class	Oil/Gas classification based on EIA-defined gas/oil production ratios	"oil"
operator	Limit search by the name of the operator whose wells to retrieve.	"A WILLIAMS OIL"
region_natgas	Region divisions based on natural gas production profiles.	"gulf"
service_company	Limit search by a list of companies contracted by the operator to perform the frac job.	"BJ Services"
state_code	Limit search by the state code where the wells are located.	"CO"
sub_region_natgas	Subregion divisions based on natural gas production profiles.	"S LA"

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 monthly dry gas factors for a specific region_natgas:

=SMXH4.fraccrews("","","northeast","","","","","","","")

---

Input:

Output:

2. To retrieve frac crew data for a specific operator and sub_region_natgas:

=SMXH4.fraccrews("","EXXON MOBIL","","West - TX","","","","","","")

---

Input:

Output:

3. To retrieve frac crews aggregated by operator:

=SMXH4.fraccrews("operator","","","","","","","","","")

---

Input:

Output:

---

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_frac	string	A date in MM/DD/YYYY format	“11/24/2023”
frac_class	string	Classifies wells as either oil or gas wells based on the GOR definition from the EIA.	“oil”
lat	string	The latitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	“32.2483475”
long	string	The longitude of the location, in decimal degrees; follows the WGS 84/EPSG:4326 coordinate system.	“-93.39548666666667”
operator	string	A well operator	“EXXON MOBIL”
region_natgas	string	Region divisions based on natural gas production profiles.	“gulf”
service_company	string	Name of the service company associated with the DUCs.	“Liberty”
state_code	string	Abbreviation of the state.	“TX”
sub_region_natgas	string	Subregion divisions based on natural gas production profiles.	“West - TX”
wellpad_id	string	Identifier of the wellpad.	27248

---

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 Commodities on the Excel ribbon and then clicking on Logs.