VCOM Term 2.0 editor

Overview of defined abbreviations

 

Name

Abbreviation

Unit

Chart

Energery production (total)

E_Z_EVU

kWh

Energy production

Meter of Subsystem

E_Z_PV[1..x]

kWh

Meter comparsion

Energy export

M_AC_E_EXP

kWh

Own consumption

Energy import

M_AC_E_IMP

kWh

Own consumption

Energy own consumption

M_AC_E_OWN

kWh

Own consumption

Irradiance

G_M0

W/m²

Energy production

Temperature module

T_M[0..x]

°C


Temperature Ambient

T_U[0..x]

°C


Windspeed

W_V[0..x]

m/s


Winddirection

W_D[0..x]

°



Data source



Device selection

Any configured device can be selected seperately. If no device is selected the sum of all will be taken


Edit term

Designation: can be chosen freely
Abbreviation: if possible use defined abbreviation, at the top of this page
Type: define data aggregation for period week, moth, year total. example:
  1. temperature values should be shown as average
  2. energy values should be shown as sum

In the following the datapoint M_E_INT_EXP of the Meter ID171843 is defined as the energy sum.


Functions

If or NULL

requires exactly two arguments

Formula

Result

if(100 > 1; 200)

200

if(0 > 1; 200)

NULL

If or Else

requires exactly three arguments

Formula

Result

if(100 > 1; 200; 300)

200

if(0 > 1; 200; 300)

300

Sum

requires at least two arguments

Formula

Result

sum(100; 200; 300; NULL)

600

sum(NULL; NULL)

NULL

sum(0; 0)

0

Average

requires at least two arguments

Formula

Result

average(200; NULL; 400)

300

average(NULL; NULL)

NULL

average(0; 0)

0

Median

requires at least two arguments

Formula

Result

median(200; NULL; 400)

300

median(300; 700; 100)

300

median(NULL; NULL)

NULL

Min

requires at least two arguments

Formula

Result

min(-50; NULL; 3)

-50

min(800; 7; 42)

7

min(NULL; NULL)

NULL

Max

requires at least two arguments

Formula

Result

max(-50; NULL; 3)

3

max(800; 7; 42)

800

max(NULL; NULL)

NULL


Tilted irradiance

Calculates the tilted irradiance for the given arguments:

  1. horizontal irradiation
  2. tilt angle (0 = horizontal, 90 = horizontal)
  3. orientation angle (0 = north, 90 = east, 180 = south, 270 = west)

Formula

Result

tilted_irradiance(NULL;20;180)

NULL

tilted_irradiance(500;NULL;180)

NULL

tilted_irradiance(500;20;NULL)

NULL

tilted_irradiance(500;20;180)

(Result will vary based on date, time and the location of the system)