Flow Control

OPERAND 1

OPERATOR

OPERAND 2

RESULT

LABEL

LABEL

 

 

This operator only indicates the row in which the brand or label used by the operators is SI_MAYOR, SI_MENOR, SI_DIFERENTE, SI_IGUAL e SALTA.

N, F, C, L

SI_IGUAL

N, F, C, L

LABEL

N, F

SI_MAYOR

N, F

LABEL

N, F

SI_MENOR

N, F

LABEL

N, F, C, L

SI_DIFERENTE

N, F, C, L

LABEL

These four operators are used to compare two values. If the result is positive, so it skips to the formula row in which the label indicated in the Result is. It can skip above or below.

Generally, when conditionals (IF or SI for Excel, for example), the following actions are placed after the condition. In GPE MODELO II, place the actions, in positive case and the the condition. Below the condition, the contrary actions.

For example: If the employee has the seniority date, take this information into account in order to determine the seniority. Otherwise, check whether there is a readmission date and take this date to determine the seniority; otherwise, take the hiring date.

Operand 1

Operator

Operand 2

Result

 

MUEVE

FCHARECON

DAUX_01

FCHARECON

SI_DIFERENTE

VACIO

CONTINUA_1

 

MUEVE

FCHAREING

DAUX_01

FCHAREING

SI_DIFERENTE

VACIO

CONTINUA_1

 

MUEVE

FECHAING

DAUX_01

CONTINUA_1

ETIQUETA

 

 

FCHFINPER

RESTA

DAUX_01

NAUX_02

NAUX_02

DIVIDE

365

ANTIGÜEDAD

 

SALTA

 

Label

This operator is an unconditional skip. That is, it automatically pass to the formula row in which the label indicated in Results is.

For example, if the raise type is equal to 1, and the daily salary is smaller than the minimum and different than zero, the minimum salary must be moved to daily salary. If the type of raise is equal to 2, so the daily salary must be multiplied by the general %.

Operand 1

Operator

Operand 2

Result

TIPOAUM

SI_DIFERENTE

1

CONTINUA_1

SALDIA

SI_IGUAL

0

CONTINUA_2

SALDIA

SI_MAYOR

SALMIN

CONTINUA_2

 

MUEVE

SALMIN

SALDIA

 

SALTA

 

CONTINUA_2

CONTINUA_1

ETIQUETA

 

 

INCRE_GRAL

DIVIDE        100

NAUX_01

 

NAUX_01

SUMA        1

NAUX_01

 

SALDIA

MULTIPLICA

NAUX_01

SALDIA

CONTINUA_2

ETIQUETA