IBA ibaAnalyzer Owner's manual

ibaAnalyzer

Expression Builder

Manual Part 3

Issue 7.0

Measurement Systems

for Industry and Energy

2

Manufacturer

iba AG

Koenigswarterstr. 44

90762 Fuerth

Germany

Contacts

Main oce +49 911 97282-0

Fax +49 911 97282-33

Support +49 911 97282-14

Engineering +49 911 97282-13

E-mail [email protected]

Web www.iba-ag.com

Unless explicitly stated to the contrary, it is not permied to pass on or copy this document, nor

to make use of its contents or disclose its contents. Infringements are liable for compensaon.

The content of this publicaon has been checked for compliance with the described hardware

and soware. Nevertheless, discrepancies cannot be ruled out, and we do not provide guaran-

tee for complete conformity. However, the informaon furnished in this publicaon is updated

regularly. Required correcons are contained in the following regulaons or can be downloaded

on the Internet.

The current version is available for download on our web site www.iba-ag.com.

Version Date Revision - Chapter / Page Author Version SW

7.0 08/2019 Revision TS 7.1.0

Windows® is a brand and registered trademark of Microso Corporaon. Other product and

company names menoned in this manual can be labels or registered trademarks of the corre-

sponding owners.

3

Issue 7.0 3

ibaAnalyzer Content

Content

1 About this manual .............................................................................................................8

1.1 Target group.............................................................................................................. 8

1.2 Notaons .................................................................................................................. 8

1.3 Used symbols ............................................................................................. ...............9

1.4 Documentaon structure ....................................................................................... 10

2 Funconanduse ............................................................................................................. 11

2.1 Conguraon .......................................................................................................... 11

2.2 How the expression builder works ......................................................................... 12

2.3 Diagnoscs / syntax error detecon ....................................................................... 13

3 Logicalfuncons .............................................................................................................15

3.1 Comparave operaons ......................................................................................... 15

3.2 Boolean funcons ............................................................................................ .......15

3.3 Bitwise Boolean funcons ...................................................................................... 16

3.4 Branching ................................................................................................................ 17

3.4.1 If .............................................................................................................................. 17

3.4.2 Switch ..................................................................................................................... 18

3.5 Edge Detecon ....................................................................................................... 19

3.5.1 OneShot .................................................................................................................. 19

3.5.2 SetReset .................................................................................................................. 19

3.6 Timer funcons (IEC 61131-3) ................................................................................ 20

3.7 IsData / Coalesce .................................................................................................... 21

4 Mathemacalfuncons ..................................................................................................22

4.1 Fundamental arithmec operaons ....................................................................... 22

4.1.1 Fundamental arithmec operaons +, -, *, / .......................................................... 22

4.1.2 Abs .......................................................................................................................... 22

4.1.3 Mod ........................................................................................................................ 22

4.1.4 Ceiling / Floor / Round ............................................................................................ 23

4.2 Integral and dierenal calculaon ........................................................................ 23

4.2.1 Int ........................................................................................................................... 23

4.2.2 Di / Dif .................................................................................................................. 24

4.3 Powers and square roots ........................................................................................ 24

4.3.1 Pow ......................................................................................................................... 24

4 Issue 7.0

Content ibaAnalyzer

4.3.2 Sqrt ......................................................................................................................... 24

4.4 e funcons and logarithms ..................................................................................... 25

4.4.1 Exp .......................................................................................................................... 25

4.4.2 Log .......................................................................................................................... 25

4.4.3 Log10 ...................................................................................................................... 25

4.5 PI ............................................................................................ .................................26

4.6 Sum ............................................................................................ .............................26

4.7 Trigonometric funcons ......................................................................................... 27

5 Stascalfuncons ......................................................................................................... 28

5.1 Average (Avg) ............................................................................................ ..............28

5.2 Maxima (Max) ............................................................................................. ............ 30

5.3 Minima (Min) ............................................................................................ ..............32

5.4 Standard deviaon (StdDev) ................................................................................... 34

5.5 Percenle ............................................................................................ ....................35

5.6 Correlaon and covariance (Correl, CoVar) ............................................................ 37

5.7 Kurtosis ................................................................................................................... 38

5.8 Skewness ................................................................................................................ 40

6 Counngandsorng ....................................................................................................... 42

6.1 Count ...................................................................................................................... 42

6.2 CountSamples .........................................................................................................44

6.3 Sort ......................................................................................................................... 44

7 Time/lengthfuncons ...................................................................................................45

7.1 Convert and resample ............................................................................................ 45

7.1.1 ConvertBase ....................... ..................................................................................... 45

7.1.2 Resample ................................................................................................................45

7.1.3 SampleAndHold ...................................................................................................... 46

7.1.4 SampleOnce ............................................................................................. ............... 46

7.2 Time ........................................................................................................................ 47

7.2.1 Time ........................................................................................................................ 47

7.2.2 AbsoluteTime ............................................................................................. ............. 48

7.3 Conversion from me to length reference ............................................................. 48

8 X-axisoperaons ....................................................................................... ......................50

8.1 Shi along the X axis ............................................................................................. .. 50

Issue 7.0 5

ibaAnalyzer Content

8.2 XCutRange / XCutValid ............................................................................................ 51

8.3 XMarkRange / XMarkValid ...................................................................................... 52

8.4 XMirror / XStretch / XStretchScale ......................................................................... 53

8.5 XFirst / XLast / XNow .............................................................................................. 56

8.6 XSize / XSumValid ...................................................................................................56

8.7 XValues / YValues .................................................................................................... 57

8.8 VarDelay .................................................................................................................. 58

8.9 XY ............................................................................................................................ 58

8.10 XMarker1 / XMarker2 ............................................................................................. 59

8.11 XBase / XOset ....................................................................................................... 59

8.12 FillGaps ................................................................................................................... 59

8.13 XAlignF ................................................................................................................. 60

9 Vectoroperaons ............................................................................................................61

9.1 GetFirstIndex / GetLastIndex .................................................................................. 61

9.2 GetRows .................................................................................................................. 61

9.3 GetZoneCenters ...................................................................................................... 62

9.4 GetZoneOset ........................................................................................................ 62

9.5 GetZoneWidths ....................................................................................................... 62

9.6 MakeVector ............................................................................................................ 62

9.7 SetZoneWidths ....................................................................................................... 63

9.8 VectorAvg................................................................................................................ 63

9.9 VectorKurtosis......................................................................................................... 63

9.10 VectorMarkRange ................................................................................................... 64

9.11 VectorMin / VectorMax .......................................................................................... 64

9.12 VectorPercenle ..................................................................................................... 64

9.13 VectorSkewness ...................................................................................................... 65

9.14 VectorStdDev .......................................................................................................... 65

9.15 VectorSum .............................................................................................................. 65

9.16 VectorToSignal / SignalToVector ............................................................................. 65

9.17 Traverse / TraverseW .............................................................................................. 66

9.18 VectorPolynomial / VectorLSQPolyCoef.................................................................. 67

10 Textfuncons ..................................................................................................................69

6 Issue 7.0

Content ibaAnalyzer

10.1 InfoeldText / ChannelInfoFieldText / ModuleInfoFieldText ...................................69

10.2 TextCompare / CompareText .................................................................................. 70

10.3 ToText / FromText ................................................................................................... 72

10.4 TrimText .................................................................................................................. 74

10.5 ConcatText ..............................................................................................................74

11 Miscellaneousfuncons .................................................................................................. 75

11.1 Debounce ............................................................................................................... 75

11.2 Envelope ................................................................................................................. 76

11.3 False / True ............................................................................................................. 76

11.4 GetBit / GetBitMask................................................................................................76

11.5 HighPrecision .......................................................................................................... 78

11.6 InfoField / ChannelInfoField / ModuleInfoField ....................... ............................... 78

11.7 LimitAlarm .............................................................................................................. 80

11.8 ManY....................................................................................................................... 80

11.9 Rand ........................................................................................................................ 81

11.10 Sign ......................................................................................................................... 81

11.11 Technostring ........................................................................................................... 82

11.12 WindowAlarm ............................................................................................. ............ 82

11.13 YatX / SetYatX ..........................................................................................................83

11.14 PulseFreq ................................................................................................................84

12 Filterfuncons ................................................................................................................ 85

12.1 LP ............................................................................................................................ 85

12.2 PreWhiten ....................... ........................................................................................ 85

13 Technologicalfuncons ................................................................................................... 86

13.1 ChebyCoef ..............................................................................................................86

13.2 CubicSpline ............................................................................................................. 86

13.3 LSQPolyCoef ............................................................................................................ 88

13.4 Polynomial .............................................................................................................. 89

14 Spectrumanalysis(FToperaons) ................................................................................... 90

14.1 FInTimeAmpl / FInTimePower ........................................................................... 90

14.2 FOrderAnalysisAmpl / FOrderAnalysisPower ..................................................... 91

Issue 7.0 7

ibaAnalyzer Content

14.3 FPeaksInTimeAmpl / FPeaksInTimePower ......................................................... 93

14.4 FAmpl / FPower ................................................................................................. 94

14.5 FComplex ............................................................................................. ................. 95

14.6 FReal / FRealInverse ........................................................................................... 96

14.7 AWeighng / DbScale .............................................................................................96

14.8 IntSpectrum ............................................................................................................ 97

15 Electricalfuncons ..........................................................................................................98

15.1 E ....................... ..................................................................................................... 98

15.2 Delta funcons .......................................................................................................99

15.3 Star funcons ........................................................................................................102

15.4 Harmonic funcons ..............................................................................................105

15.4.1 TIF ......................................................................................................................... 107

16 Supportandcontact ...................................................................................................... 108

8

8 Issue 7.0

About this manual ibaAnalyzer

1 About this manual

This documentaon describes the funcon and applicaon of the soware

ibaAnalyzer.

1.1 Target group

This manual addresses in parcular the qualied professionals who are familiar with handling

electrical and electronic modules as well as communicaon and measurement technology. A

person is regarded as professional if he/she is capable of assessing safety and recognizing possi-

ble consequences and risks on the basis of his/her specialist training, knowledge and experience

and knowledge of the standard regulaons.

This documentaon addresses in parcular professionals who are in charge of analyzing mea-

sured data and process data. Because the data is supplied by other iba products the following

knowledge is required or at least helpful when working with ibaAnalyzer:

■ Operang system Windows

■ ibaPDA (creaon and structure of the measuring data les)

1.2 Notaons

In this manual, the following notaons are used:

Acon Notaon

Menu command Menu Logic diagram

Calling the menu command Step 1 – Step 2 – Step 3 – Step x

Example:

Select the menu Logic diagram - Add - New funcon

block.

Keys <Key name>

Example: <Alt>; <F1>

Press the keys simultaneously <Key name> + <Key name>

Example: <Alt> + <Ctrl>

Buons <Key name>

Example: <OK>; <Cancel>

File names, paths "Filename", "Path"

Example: "Test.doc"

Issue 7.0 9

ibaAnalyzer About this manual

1.3 Usedsymbols

If safety instrucons or other notes are used in this manual, they mean:

Danger!

Thenon-observanceofthissafetyinformaonmayresultinanimminentrisk

ofdeathorsevereinjury:

■ Observe the specied measures.

Warning!

Thenon-observanceofthissafetyinformaonmayresultinapotenalriskof

deathorsevereinjury!

■ Observe the specied measures.

Cauon!

Thenon-observanceofthissafetyinformaonmayresultinapotenalriskof

injuryormaterialdamage!

■ Observe the specied measures

Note

A note species special requirements or acons to be observed.

Tip

Tip or example as a helpful note or insider p to make the work a lile bit easier.

Otherdocumentaon

Reference to addional documentaon or further reading.

10 Issue 7.0

About this manual ibaAnalyzer

1.4 Documentaonstructure

This documentaon describes the funconality of the ibaAnalyzer soware in detail. It is creat-

ed as a guide for familiarizaon as well as a reference document.

In addion to this documentaon, you can also draw on the version history in the main menu

Version history (le versions.htm) for the latest informaon about the installed program version.

In addion to the list of corrected program errors, this le also refers to extensions and im-

provements to the soware by keyword.

In addion, each soware update, which includes the main new features, also includes special

documentaon “NewFeatures...”, oering an extensive descripon of the new features.

The state of the soware to which the respecve part of this documentaon refers is listed in

the revision table on page 2. The documentaon of ibaAnalyzer (PDF and printed edion) is

divided into four separate parts. Each part has its own chapter and page numbering, beginning

with 1, and is updated independently.

Part Title Content

Part 1 Introducon and installaon General notes, licenses and add-ons

Installaon and program start

User interface

Part 2 Working with ibaAnalyzer Working with data le and analysis, representaon

features, macro conguraon, lter design, prefer-

ences, prinng, export, interfaces to ibaHD-Server,

ibaCapture and report generator

Part 3 Expression builder Directory of all calculaon funcons in the expres-

sion builder, including explanaon

Part 4 Applicaon examples Applicaon examples from the areas of expression

editor, report generator and adjustment of the pro-

gram interface as well as ps about the classica-

on for signal names

11

Issue 7.0 11

ibaAnalyzer Funcon and use

2 Funconanduse

The expression builder is a tool for entering (mathemacal) formulae or expressions which are

described in detail in the following secons. It is also possible in principle to manually enter

these expressions in the lines of the signal table on the Signal denions tab.

In order to facilitate these inputs and also to provide a detailed list of possible operaons and

their syntax, there is the expression builder, which is available in every line in which a signal can

be entered.

Fig. 1: Symbol for starng the expression builder.

Note

The buon in the toolbar does not open the expression builder, but rather

opens the dialog for the logical signal denions. See Logical signal denions in

part 2 of the manual.

2.1 Conguraon

Fig. 2: The Expression Builder

The expression builder consists of three areas.

12 Issue 7.0

Funcon and use ibaAnalyzer

The part on the le shows a signal tree which is very similar to the one in the signal tree win-

dow. However, in contrast to the signal tree window, this window here contains not just the

original signals, but also all the expressions which were already created using the expression

builder. From this signal tree, you can now select the desired signals or expressions to be used

in the calculaons.

The right part of the dialog window contains a funcon tree view with a collecon of the avail-

able mathemacal operaons and other funcons sorted by subject.

The command input in which you enter the desired expression in several lines is located below

these two panes. Above this in the gray area is a short note about the syntax of an operaon, if

it is marked in the funcon tree, or a toolp if the funcon is marked in the command input.

The <Reset expression> buon removes all entries from the command line.

You can enable the "Reference signals by name" check box if you want to use the signal names

in the expressions instead of the usual signal designaons consisng of [module number:signal

number].

Note

When using the signal names as signal reference, it must be guaranteed that the

signal names are unambiguous.

2.2 Howtheexpressionbuilderworks

The expression builder makes it possible to apply both the operaons as well as the operands,

i.e. the signals and expressions, by double clicking or dragging and dropping into the command

line. This process is recommended for avoiding write errors and being able to work faster.

The general rule is: The operaon or operand that you double-click in the funcon tree or signal

tree is inserted at the posion of the cursor in the input line.

So as not to lose the overview of complex expressions, the keyboard shortcut <Ctrl>+<B> can be

used to jump back and forth between associated pairs of parentheses.

Note

The funcon of applying signals and expressions in the command line is only

available in the expression builder and cannot be used in the normal signal tree

in the signal tree window.

Experienced users can use the input help Intellisense both in the signal table as well as in the

command line of the expression builder. For manual inputs, a window automacally opens with

possible compleons of your input. This includes funcons and their parameters as well as sig-

nals or virtual expressions which are available in the measuring data le.

Issue 7.0 13

ibaAnalyzer Funcon and use

By means of cursor control buons you can select an appropriate entry in the Intellisense win-

dow and take it over by pressing <Return>. If you go on typing the range of suggesons will be

adjusted accordingly unl the expression is nished. If this funcon is used in the expression

builder, all necessary parentheses are also automacally inserted.

2.3 Diagnoscs/syntaxerrordetecon

If you have closed the expression builder by clicking the <OK> buon, the expression just creat-

ed is displayed in the corresponding row of the signal denions.

Fig. 3: Expression builder diagnosis

Although the expression itself is automacally entered as the signal name, you can simply over-

strike it by manually entering a plain text. In the case of more complex, cascaded expressions,

we urgently recommend using names which should be as brief as possible and unambiguous in

order to ensure that the expression is readily understandable.

In the case of a faulty input with the expression builder, an alert will appear that makes it pos-

sible to correct the expression. If <Yes> is clicked, the cursor automacally jumps to the point

where the error is presumably located.

Fig. 4: Expression builder diagnosis, error idencaon

Tip

The funcon to search for possible errors can also be started manually by press-

ing the keyboard shortcut <Ctrl>+<E> in the expression builder.

If the error message is ignored or the error is made during input in the signal denion line,

ibaAnalyzer indicates this with a red color.

Fig. 5: Expression builder diagnosis, error idencaon

In this way, formal or syntax errors can be detected here that would make a calculaon impos-

sible. In order to obtain more detailed informaon about the cause of the error, the diagnoscs

14 Issue 7.0

Funcon and use ibaAnalyzer

can be opened with a mouse click on the yellow queson mark symbol in the respecve signal

denion line.

Fig. 6: Expression builder diagnosis, diagnosis window, error

15

Issue 7.0 15

ibaAnalyzer Logical funcons

3 Logicalfuncons

3.1 Comparaveoperaons

e.g. ('Expression1') < ('Expression2')

> Greater

>= Greater or equal

< Smaller

<= Smaller or equal

<> Unequal

= Equal

Table 1: Comparave operaons

Descripon

The comparave operaons >, >=, <, <=, <> and = can be used to compare the values of two ex-

pressions (operands) with each other. The result of such an operaon is the Boolean value TRUE

or FALSE. Original signals, calculated expressions or constant values can be entered as operands.

The result can be presented and evaluated as a new expression, such as a signal. This way, bina-

ry signals can easily be generated and can then be used as condions for other funcons.

Note

If the crossing point of two curves is located between two measuring points, the

result of the comparave operaon of the last two measured values is retained

unl the next measuring point. This means that any change from TRUE to FALSE

(or vice versa) is always located at a measuring point. The line which connects

two measuring points in the presentaon of analog values is just an approxima-

on.

3.2 Booleanfuncons

e.g. ('Expression1') AND ('Expression2')

AND Logical AND

OR Logical OR

XOR Logical exclusive OR

NOT Logical NOT, negaon

Table 2: Boolean funcons

16 Issue 7.0

Logical funcons ibaAnalyzer

Descripon

Binary expressions, such as digital signals, can be linked with each other using the Boolean func-

ons AND, OR, NOT and XOR. According to the rules of Boolean logic, the funcons return the

value TRUE or FALSE. Digital signals, calculated (binary) expressions or the numerical values 0 or

1 can be entered as parameters.

The result can be presented and evaluated as a new expression, such as a signal. This way, bina-

ry signals can easily be generated and can then be used as condions for other funcons.

A B A AND B A OR B A XOR B NOT A

0 0 0 0 0 1

1 0 0 1 1 0

0 1 0 1 1

1 1 1 1 0

Table 3: Logical funcons, truth table

3.3 BitwiseBooleanfuncons

e.g. ('Expression1') bw_NOT ('Expression2')

bw_AND Bitwise AND

bw_OR Bitwise OR

bw_XOR Bitwise exclusive OR

bw_NOT Bitwise NOT

Table 4: Boolean funcons (bitwise)

Descripon

These funcons are used for the bitwise linking of two analog values based on Boolean algebra.

The funcons return a 32Bit integer. 32Bit integers are expected as arguments.

If the arguments are not integers, the decimal part will be dropped before the operaon is ex-

ecuted. If the arguments are too big so that their absolute value does not t in a 32Bit integer,

the operaon is executed only on the 32 low-order bits.

When linking two analog values with a bw funcon, the individual bits of both values are logi-

cally linked. The result then is an analog value of the same type with a bit paern in accordance

with the logical link.

Issue 7.0 17

ibaAnalyzer Logical funcons

Example

For 2 analog values V1 = 15 and V2 = 2, the results are as follows:

Dec. value Bits Hex Result value

Output value V1 15 ...1111 0x0000000F

Output value V2 2 ...0010 0x00000002

V1 bw_AND V2 ...0010 0x00000002 2

V1 bw_OR V2 ...1111 0x0000000F 15

V1 bw_XOR V2 ...1101 0x0000000D 13

bw_NOT (V1) ...0000 0xFFFFFFF0 -16

Table 5: Truth table for bitwise linking

3.4 Branching

3.4.1 If

If('Condition’,'IF-True’,'IF-False')

Arguments

'Condion' Condion as an operaon with the Boolean results TRUE or FALSE

'IF-True' Operaon is performed if 'Condion' is TRUE

'IF-False' Operaon is performed if 'Condion' is FALSE

Descripon

The If funcon can be used for a condioned execuon of further calculaons. Depending on

the Boolean result of a 'condion’, which can itself be an operaon, the operaon ‘IF-True’ will

be executed if the result is TRUE and the operaon ‘IF-False’ if the result is FALSE.

Hence, dierent calculaons can be executed in a process-controlled manner. Of course, you

can use this funcon in a nested maer and thus realize further branches.

Tip

If an analog signal is entered for 'Condion', as a condion it will be checked

whether the value is greater than (TRUE) or less than (FALSE) 0.5.

18 Issue 7.0

Logical funcons ibaAnalyzer

3.4.2 Switch

Switch ('Selector_Expression,' 'Case_1_Expression’,'Value_1_Expression,'

'Case_2_Expression’,'Value_2_Expression,'

...

'Case_n_Expression’,'Value_n_Expression,'

'Default_Value_Expr')

Arguments

'Selector_Expression' Expression that is checked for dierent condions

'Case_n_Expression' Expression that is compared with ‘Selector_Expression’

'Value_n_Expression' Result if ‘Select_Expression’ and ‘Case_n_Expression’ match

'Default_Value _Expr' Result if none of the ‘Case_n_Expressions’ match with

‘Selector_Expression’

Descripon

These instrucons compare an incoming ‘Selector_Expression’ with any number of ‘Case_n_Ex-

pressions’ resembling the SQL statement CASE. At least 3 arguments are needed. With an even

number of arguments, the last argument is automacally interpreted as ‘Default_Value_Expr,’

which is used if none of the ‘Case_n_Expressions’ matches with the ‘Selector_Expression’.

If ‘Selector_Expression’ and ‘Case_n_Expression’ match, the corresponding ‘Value_n_Expres-

sion’ is returned. If several ‘Case_n_Expressions’ match the input signal, the rst is automacal-

ly selected.

The following signals are allowed as ‘Selector_Expressions’:

A numeric constant

A text constant

An equidistant and not equidistant sampled channel

A text channel

In general, the types of comparison values must match, otherwise the corresponding case is not

selected.

Issue 7.0 19

ibaAnalyzer Logical funcons

3.5 EdgeDetecon

3.5.1 OneShot

OneShot('Expression')

Descripon

This funcon returns the result TRUE, if the current measured value of 'Expression' is not equal

to the previous one. It returns the result FALSE, if the current measured value does equal the

previous one.

Tip

The funcon also works with non-equidistant measuring values.

3.5.2 SetReset

SetReset('Set’,'Reset’,'SetDominant=1')

Arguments

'Set' Posive edge sets funcon to TRUE

'Reset' Posive edge sets funcon to FALSE

'SetDominant' Oponal parameter (default = 1), which controls which input argument is

dominant if both arguments simultaneously receive a posive edge.

'SetDominant' = 1 Set takes precedence over Reset

'SetDominant' = 0 Reset takes precedence over Set

Descripon

This funcon can be used to control a digital result (TRUE/FALSE) with the help of posive edges

(transion from 0 to 1) of the arguments ‘Set’ and ‘Reset’.

A rising edge of the ‘Set’ operand returns a stac TRUE. A rising edge of the ‘Reset’ operand re-

sets the result to FALSE. The argument 'SetDominant' is oponal and determines the dominance

of ‘Set’ or ‘Reset.’

Tip

For an analog signal, exceeding the value 0.5 corresponds to a posive edge.

20 Issue 7.0

Logical funcons ibaAnalyzer

3.6 Timerfuncons(IEC61131-3)

TOF

TOF('in','pt')

Descripon

O Delay Timer. The output is switched o 'pt' seconds aer switching o the 'in' input.

TON

TON('in','pt')

Descripon

On Delay Timer. The output is switched on 'pt' seconds aer switching on the 'in' input.

TP

TP('in','pt')

Descripon

Pulse Timer. The output is switched on for 'pt' seconds aer rising edge at the 'in' input.

Tip

A further rising edge during the output pulse does not extend the output pulse

and does not restart the pulse.

Page is loading ...

IBA ibaAnalyzer Owner's manual

IBA ibaAnalyzer Owner's manual

Related papers

Other documents