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:

 

Date/Time

 

Original Signal

MovingDiv
1 datapoint backwards in time

01.02.2007 00:00

8

#Null!

01.03.2007 00:00

0

0

01.04.2007 00:00

15

#Null!

01.05.2007 00:00

22

1.466666667

01.06.2007 00:00

24

1.090909091

01.07.2007 00:00

13

0.541666667

01.08.2007 00:00

27

2.076923077

01.09.2007 00:00

6

0.222222222