- Weatherford Knowledge Base
- P#
- Moving Window Functions
-
Getting Started
-
Customer Training
-
Customer Success
-
Updates
-
Production Optimization
-
Artificial Lift Optimization
-
Completion Optimization
-
Environmental, Social & Governance
-
Development, Acquisition & Divestitures
-
Enhanced Oil Recovery
-
Admin
-
P#
- Getting Started with P#
- Data Cleansing
- String Functions
- Scenario Functions
- Regression Functions
- Placeholder Functions
- Mathematical Functions
- Logic Functions
- Entities Function
- Moving Window Functions
- Time and Date Functions
- Statistical Functions
- Economic Functions
- Data Handling
- Additional Functions
- Directional Functions
- Machine Learning Functions
- DCA Functions
- Neighborhood Functions
-
Packages
MovingDiv
Moving Division of a freely definable range.
Syntax
MovingDiv(expression, # of data points)
- expression: signal expression
- # of data points before - integer number of points in the signal expression
- positive value: before the current date in the aggregation range
- negative value: after the current date in the aggregation range
The MovingDiv("x" in "unit", # data points) function calculates the ratio of the the actual data point value divided by the data point value at given steps. In case of entering zero data points before and after the output is 1. Positive and and negative sign define the direction. Positive values define the data points before the actual one, negative values define the number of data points after the actual one.
Example
MovingDiv("produced water per time increment" in "STB", 1)
Ratio of the water production rate at the given time step to the water production rate 1 time step before.
As you see in the following table the MovingDiv with 1 data point back in time produces following output based on the 'original signal' as input: