tils

The function returns status of wellpads which are being monitored for Turn-In-Line (TIL) events. It includes wellpads identified as having a delayed TIL (DTIL) status, as well as those without delays.

This is a funtion without parameters that sends a get request to Hyperion V4 tils endpoint.

In the Formula Builder, select Hyperion 4.0, then choose the tils function from the Enter Function dropdown. Once selected, click Insert to automatically add the formula to Excel.

Syntax

=SMXH4.TILs()

---

Output Parameters

When executed, this function returns data to the Excel worksheet with all relevant fields and records.

The Excel output includes the following data columns:

Field	Type	Description	Example
date_frac_end	string	The date the frac job ended for the DTIL wells, if NULL then the wells have not completed fracking. Format MM/DD/YYYY	“1/1/2025”
date_til	string	The date the wells were TILd, if NULL then the wells are currently DTILs. Format MM/DD/YYYY	“1/29/2025”
operator	string	A well operator	“EXXON MOBIL”
prod_wet_gas_bcf_day	number	Daily wet gas production measured in billion cubic feet per day (BCF/day).	0.078
sub_region_natgas	string	Subregion divisions based on natural gas production profiles.	“West - TX”
wellpad_id	string	Identifier of the wellpad.	27248
wells	integer	The number of DTIL wells on the wellpad	2

---

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.