LongTermForecast

This function returns long-term production forecasts for gas production of the lower 48 for the next 12 months. Average rate of gas production is expressed in BCF/day.

Syntax

=SMX.LongtermForecast(Region, Subregion, Start Date, End Date)

Arguments

Parameter	Description	Example
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"
Start Date	Limit search to a start date [“YYYY-MM-DD”].	"2022-12-01"
End Date	Limit search to an end date [“YYYY-MM-DD”].	"2022-12-01"

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.

---

Example

1. To retrieve long-term forecast data for a specific region:

=@SMX.LongtermForecast("northeast", "","","")

2. To retrieve long-term forecast data between a specific start date and an end date:

=@SMX.LongtermForecast("", "","2021-1-15","2021-12-15")

3. To retrieve long-term forecast data with a start date and an end date for a particular subregion:

=@SMX.LongtermForecast("", "Haynesville - TX","2021-1-15","2021-12-15")

---

Output Parameters

Field	Type	Description	Example
date	string [“YYYY-MM-DD”]	Forecasted month (unsynced).	“2022-11-01”
sub_region	string	Aggregation of several counties, typically representing a major producing basin.	“S LA”
gas_daily	float	Average rate of gas production expressed per day (in BCF/day).	23.842

---

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.