QUERY FOR STATIC HEADER SOURCE

SELECT a.[API]
	,a.[WELLNAME] AS [WELL NAME]
	,a.[WELLBOREPROFILE] AS [WELL PROFILE]
	,b.[FORMATIONNAME] AS [FORMATION]
  FROM [WDBC_QEP_DEMO].[dbo].[view_Header_Strings] a INNER JOIN 	[WDBC_QEP_DEMO].[dbo].[FORMATION] b
  ON a.api = b.api
  WHERE b.FORMATIONNAME LIKE 'HAYNESVILLE%'

QUERY TO ADD ENTITY NAME AND ALIAS TO STATIC HEADER SOURCE

SELECT a.[API] AS 'entity name'
	,a.[WELLNAME] AS 'alias'
  FROM [WDBC_QEP_DEMO].[dbo].[view_Header_Strings] a INNER JOIN 	[WDBC_QEP_DEMO].[dbo].[FORMATION] b
  ON a.api = b.api
  WHERE b.FORMATIONNAME LIKE 'HAYNESVILLE%'

QUERY FOR LOCATIONS SOURCE

SELECT a.[API]
	,a.[SURFLATITUDE] AS [SURFACE LATITUDE]
  	,a.[SURFLONGITUDE] AS [SURFACE LONGITUDE]
  FROM [WDBC_QEP_DEMO].[dbo].[view_Header_Numerical] a INNER JOIN 	[WDBC_QEP_DEMO].[dbo].[FORMATION] b
  ON a.api = b.api
  WHERE b.FORMATIONNAME LIKE 'HAYNESVILLE%'

QUERY FOR PRODUCTION SOURCE

SELECT a.[API]
      ,a.[P_Date]
      ,a.[GAS] AS [GAS (MSCF)]
  FROM [WDBC_QEP_DEMO].[dbo].[view_Production] a INNER JOIN 	[WDBC_QEP_DEMO].[dbo].[FORMATION] b
  ON a.api = b.api
  WHERE b.FORMATIONNAME LIKE 'HAYNESVILLE%'
  ORDER BY a.api, a.p_date

SCRIPT FOR HISTORICAL AND FORECAST MERGE

Table "Hist And Fcst Gas"

	Column "Historical Gas Rate" in "MSCF/d"
		"gas production rate" in "MSCF/d"
	End Column

	Column "Forecast Gas Rate" in "MSCF/d"
		If 
			CurrentStep() <= EndOfTag("Gas", TagEntryStates.Any) 
		Then 
			Null()
		Else 
			"gas production rate forecast" in "MSCF/d"
		End If
	End Column

	Column "Merged H+F Gas Rate" in "MSCF/d"
		If
			// This checks if the number of active entities at this time step
			// is less than than the total number of entities. If yes, then
			// some entities have stopped producing and we are in the overlap window.
			(Entity Count(IIF(CurrentStep() < EndOfTag("Gas", CurrentEntity(), 
			TagEntryPrecedences.Last, TagEntryStates.Any), 1, null()))) < (Entity Count(1))
		Then
			If 
				IsNotNull("gas production rate" in "MSCF/d")
			Then
				"gas production rate" in "MSCF/d"
			Else
				"gas production rate forecast" in "MSCF/d"
			End If
		Else
			Null()
		End If
	End Column

End Table

SCRIPT FOR VALUE SUMMARY

/// Value Summary
///
/// Description:
///  Calculate the remaining gas, and value of the remaining gas
///  from forecast signals
///
/// Input:
///  produced gas per time increment forecast [Bscf]
///
/// Output:
///  Rem Gas [BCF]
///  Value of Rem Gas [MMUSD]
///  Percent of Total Value [%]
///
/// Author: Tarek Ghazi, 2022-08-12
 
Context "For Dashboard"
	Entity Set "Entities To Forecast"
	Scope "2018 to 2032"
End Context

Table "Value Summary"

	Column "Rem Gas" in "BSCF"
		Sum("produced gas per time increment forecast" in "BSCF")
	End Column

	Column "Value of Rem Gas" in "MMUSD"
		Column "Rem Gas" in "BSCF" * 6
	End Column

	Column "Percent of Total Value" in "%"
		Column "Value of Rem Gas" in "MMUSD" / 6455.7 * 100
	End Column

End Table