Introduction to calculations

Note: Following samples are using particular signals from the AlEzzel database.

Exports SOE records into CSV file.

Parameters:

• since - datetime with offset, inclusive
• till - datetime with offset (inclusive since v1.9)
• list of allowed event types

listSoe 2006-01-01T00:00:00+00:00 2006-06-29T00:15:00+00:00 A,C,D,E,EA,F,FD,FI,I,IS,O,OD,OE,OI,S,SD,T,W

Exports SOE records into CSV file.

Parameters:

• since - datetime with offset, inclusive
• range - timespan (0.00:00:00) (inclusive since v1.9)
• list of allowed event types

listSoeRange 2006-01-01T00:00:00+00:00 1.00:00:00 A,C,D,E,EA,F,FD,FI,I,IS,O,OD,OE,OI,S,SD,T,W

Analyze failures of particular signal (w.r.t. KG and KSIM signals).

Parameters:

• since
• till
• list of fault signals (usually KG or DML)
• list of simulation signals (usually KSIM signals)
• system check condition (to differentiate between working and non-working state, usually output power of the power plant, etc.)
• aggregation time range (failures will be joined if happened within the aggregation time range)

failure 2006-01-01T00:00:00+00:00 2015-01-01T00:00:00+00:00 (listSignals 10QUB13CQ002 KG) (listSignals 10QUB13CQ002 KSIM) (condition (listSignals 10ADA00CE005A XQ01) > 48) 1.00:00:00

Analyze failures of particular signals (w.r.t. KG and KSIM signals).

Parameters:

• since
• till
• list of fault signals (usually KG or DML)
• type of simulation signal, usually KSIM
• system check condition (to differentiate between working and non-working state, usually output power of the power plant, etc.)
• aggregation time range (failures will be joined if happened within the aggregation time range)

failureGroup 2006-01-01T00:00:00+00:00 2015-01-01T00:00:00+00:00 (listSignals 10QUB13CQ002 KG) KSIM (condition (listSignals 10ADA00CE005A XQ01) > 48) 1.00:00:00

Aggregate numbers of (typically fault) signals w.r.t. different signal groups.

Parameters:

• signal types
• time ranges

countSignalsByGroups KG,DML,SZ/AU (unionRanges (createRanges 2010-07-11T00:00:00+00:00 1 month) (createRanges 2011-07-11T00:00:00+00:00 1 month) (createRanges 2012-07-11T00:00:00+00:00 1 month) (createRanges 2013-07-11T00:00:00+00:00 1 month) (createRanges 2014-07-11T00:00:00+00:00 1 month))

Aggregate numbers of (typically fault) signals w.r.t. different signal groups and event types.

Parameters:

• event types
• time ranges

countEventsByGroups F,A,OE (unionRanges (createRanges 2011-07-11T00:00:00+00:00 1 month) (createRanges 2012-07-11T00:00:00+00:00 1 month) (createRanges 2013-07-11T00:00:00+00:00 1 month) (createRanges 2014-07-11T00:00:00+00:00 1 month))

Creates interactive chart with time series values

Parameters:

• timeseries
• pivot point (as a timespan in format 0.00:00:00 which marks the pivot point for the time axis)

Draw chart with generator values during 49 minutes before (and 1 minute after) every generator frequency drop bellow 49 Hz during the year 2010

plot (selectSeries (listSignals 10MKA01FE001 ZQ01) (fillRanges (modifyTime (extractTime start (findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2010-01-01T00:00:00+00:00 2011-01-01T00:00:00+00:00)) +1 minute) -50 minute)) 0.00:49:00

Find signals

Parameters:

• KKS filter (SQL-like syntax)
• signal type filter (SQL-like syntax)

listSignals 20ACB01CE101 XQ01

Create time range argument

Parameters:

• start - datetime offset
• number of ranges
• duration - millisecond, second, minute, hour, day, week, month, year

createRanges 2014-07-11T00:00:00+00:00 1 month

Find time ranges where signal values meet some condition in predefined time range

Parameters:

• list of signals
• value operator
• value to be compared
• time range start
• time range end

Find all intervals in year 2006 where the generator frequency has been below 49.

findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2006-01-01T00:00:00+00:00 2007-01-01T00:00:00+00:00

Aggregate multiple separate time ranges into one argument.

Parameters:

• rangeN - time range

unionRanges (createRanges 2011-07-11T00:00:00+00:00 1 month) (createRanges 2012-07-11T00:00:00+00:00 1 month) (createRanges 2013-07-11T00:00:00+00:00 1 month) (createRanges 2014-07-11T00:00:00+00:00 1 month)

Extract start or end time from a list of time ranges.

Parameters:

• start/end
• time ranges

Find starts of all intervals when frequency of the generator dropped below 49 Hz.

extractTime start (findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2006-01-01T00:00:00+00:00 2015-01-01T00:00:00+00:00)

Extract start or end time from a list of time ranges.

Parameters:

• list of times
• number of intervals to shift (plus/minus)
• type of intervals to shift (millisecond, second, minute, hour, day, week, month, year)

Find all ranges where generator frequency was bellow 49, pick just the start of the intervals and shift the starts by 1 minute.

modifyTime (extractTime start (findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2006-01-01T00:00:00+00:00 2008-01-01T00:00:00+00:00)) +1 minute

Create time ranges based on existing list of times.

Parameters:

• list of times
• number of interval units (plus/minus)
• type of interval units (millisecond, second, minute, hour, day, week, month, year)

Create time ranges which start 49 minutes before every generator failure (drop of frequency below 49)

fillRanges (modifyTime (extractTime start (findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2006-01-01T00:00:00+00:00 2008-01-01T00:00:00+00:00)) +1 minute) -50 minute

Find values of specified signals during given time ranges.

Parameters:

• list of signals
• time ranges

Show values of generator output during 49 minutes before (and 1 minute after) the generator frequency drop below 49 Hz.

selectSeries (listSignals 10MKA01FE001 ZQ01) (fillRanges (modifyTime (extractTime start (findRanges (listSignals 10MKA01CE005 XQ01) LowerThan 49 2006-01-01T00:00:00+00:00 2008-01-01T00:00:00+00:00)) +1 minute) -50 minute)

Evaluate condition

Parameters:

• signal - signals to be checked
• operator - comparison operator <, >, ==, !=, <=, >=
• value - number

condition (listSignals 20ACB01CE101 XQ01) > 50)

Evaluate multiple conditions and join the results using AND.

Parameters:

• conditionN - condition to be checked

(andCondition (condition (listSignals 20ACB01CE101 XQ01) > 50) (condition (listSignals 20ACB01CE101 XQ01) < 50))

Evaluate multiple conditions and join the results using OR.

Parameters:

• conditionN - condition to be checked

(orCondition (condition (listSignals 20ACB01CE101 XQ01) > 50) (condition (listSignals 20ACB01CE101 XQ01) < 50))