Fill of data gaps in the data set.
The function interpolates the missing values of time dependent data and returns linearly interpolated values. Gapfilling algorithm does not touch the raw data in the database. In case of using the gap filling function on any data keep in mind that the raw data stays the same with no gaps filled.
Syntax
FillGaps(expression)
expression: signal expression
Example
FillGaps("produced water per time increment" in "STB")
As you see in the following table the GapFilling function applied on the 'original signal' as input:
|
Date/Time |
Original Signal1 |
FillGaps(Signal1)
|
|
01.02.2007 00:00 |
333.5553554 |
333.5553554 |
|
01.03.2007 00:00 |
352.951806 |
352.951806 |
|
01.04.2007 00:00 |
220.992347 |
220.992347 |
|
01.05.2007 00:00 |
#NULL! |
177.4695736 |
|
01.06.2007 00:00 |
#NULL! |
133.9468003 |
|
01.07.2007 00:00 |
#NULL! |
90.42402688 |
|
01.08.2007 00:00 |
46.9012535 |
46.9012535 |
|
01.09.2007 00:00 |
375.8459772 |
375.8459772 |
Fill gaps by using a linear interpolation or by carrying forward the last value found in the current time range.
Syntax
FillGaps(numeric, string interpolation Type)
Examples
FillGaps ("oil production rate" in "m3/h", "Linear")
FillGaps("oil production rate" in "m3/h", "Last")
Fill gaps by carrying forward the last value found in the scope time range with reset condition.
Syntax
FillGaps(numeric, boolean conditionExpression)
Examples
FillGaps("oil production rate" in "m3/h", "gas production rate" in "m3/h" >0)
Fill gaps by using a linear interpolation or by carrying forward the last value found in the time range started with specified start date.
Syntax
FillGaps(numeric, string interpolationType, date/time startDate)
Example
FillGaps ("oil production rate" in "m3/h", "Linear", #02/24/2015 08:00#)
FillGaps("oil production rate" in "m3/h", "Last", StartOf())
Fills gaps by using a linear interpolation or by carrying forward the last value found in the current time range.
Example
FillGaps("oil production rate" in "m3/h", "Linear")
FillGaps("oil production rate" in "m3/h", "Last")
FillGaps("oil production rate" in "m3/h", "Next")
Fill gaps by carrying forward the last value found in the current time range.
Example
FillGaps("oil production phase" in "")
Fills gaps by using a linear interpolation or by carrying forward the last value found in the depth range started with specified start depth.
Example
FillGaps("oil production rate" in "m3/h", "Linear", StartOfDepth())
FillGaps("oil production rate" in "m3/h", "Last", 100)
FillGaps("oil production rate" in "m3/h", "Next", 50)