TILs#
This 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.
Syntax#
- =SMX.TILs()
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#
There are no parameters to be passed to this fucntion. To retrieve number of DTIL wells on a wellpad, operator name, frac job date, and Til date:
=SMX.TILs()
Output Parameters#
Field |
Type |
Description |
Example |
|---|---|---|---|
bcfd |
float |
The total expected production from the DTIL wells on the wellpad |
0.087 |
frac_end |
string |
The date the frac job ended for the DTIL wells, if NULL then the wells have not completed fracking - Date formatting - [“YYYY-MM-DD”] |
“2023-08-26” |
operator_name |
string |
Operator of the well. |
“PIE OPERATING, LLC” |
sub_region |
string |
Aggregation of several counties, typically representing a major producing basin. |
“S LA” |
til_date |
string |
The date the wells were TILd, if NULL then the wells are currently DTILs - Date formatting - [“YYYY-MM-DD”] |
“2023-10-06” |
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 Energy on the Excel ribbon and then clicking on Logs.