Average

Arithmetic mean of all entities for the same time step.

Syntax

 Prefix Average(expression)
  • expression: signal expression
  • Prefix:
    • TIME for calculation of the average for all tine steps for one entity (default setting, can also be neglected)
      • Time Average("x" in "unit") function returns the average i.e.  of all the elements within the given time range.  
    • ENTITY calculation of the average for all entities at one time step (has to be placed in front of function if needed)
      • Entity Average("x" in "unit") function returns the average i.e.  of all the entities for a given time step.

Examples

Time Average("produced water per time increment" in "STB")

alternatively:

Average("produced water per time increment" in "STB")

As you see in the following table the Average function which produces following output based on the 'original signal' as input:

Date/Time

Original Signal

Time Average

01.02.2007 00:00

8

14.375

01.03.2007 00:00

0

14.375

01.04.2007 00:00

15

14.375

01.05.2007 00:00

22

14.375

01.06.2007 00:00

24

14.375

01.07.2007 00:00

13

14.375

01.08.2007 00:00

27

14.375

01.09.2007 00:00

6

14.375

Entity Average("produced water per time increment" in "STB")

As seen in the following table the Entity Average function  produces following output based on the 'original signal1' and 'original signal2' as input:

Date/Time

Entity1: Signal1

Entity2: Signal1

Entity1: Entity Average

Entity2: Entity Average

01.02.2007 00:00

8

#NULL!

8

8

01.03.2007 00:00

0

#NULL!

0

0

01.04.2007 00:00

15

19

17

17

01.05.2007 00:00

22

12

17

17

01.06.2007 00:00

24

34

29

29

01.07.2007 00:00

13

19

16

16

01.08.2007 00:00

27

15

21

21

01.09.2007 00:00

6

19

12.5

12.5