Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
1/10

Organization (S): EDF-R & D/AMA, DeltaCAD
Handbook of Utilization
U4.3- booklet: Function
Document: U4.33.03

Procedure CALC_TABLE

1 Goal

To handle the data of the tables to the manner of a spreadsheet.

The command makes it possible to carry out operations on the data of the tables. Following operations
are currently available:

·
Concaténer/Combiner two tables,
·
To apply a formula,
·
To re-elect parameters,
·
To filter the lines according to certain criteria,
·
To extract certain columns from a table,
·
To order the lines,

Product a structure of data counts.
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
2/10

Count

matters

1 Goal ......................................................................................................................................................... 1
2 Syntax .................................................................................................................................................. 3
3 Operands ............................................................................................................................................. 4
3.1 Operand COUNTS ............................................................................................................................. 4
3.2 Operand COMB: concaténer/to combine two tables ....................................................................... 4
3.2.1 Operand COUNTS .................................................................................................................... 4
3.2.2 Operand NOM_PARA ............................................................................................................. 4
3.3 Operand OPER: To apply a formula ......................................................................................... 4
3.3.1 Operand FORMULATES ............................................................................................................... 4
3.3.2 Operand NOM_PARA ............................................................................................................. 4
3.4 Operand RE-ELECTS: To re-elect parameters of a table ....................................................... 5
3.4.1 Operand NOM_PARA ............................................................................................................. 5
3.5 Operand FILTERS: To filter the lines according to certain criteria ......................................................... 5
3.5.1 Operand NOM_PARA ............................................................................................................. 5
3.5.2 Operand CRIT_COMP ........................................................................................................... 5
3.5.3 Operands VALE/VALE_I/VALE_C/VALE_K ......................................................... 6
3.5.4 Operands CRITERION/PRECISION .................................................................................... 6
3.5.5 Example of use of key word FILTRE ............................................................................... 6
3.6 Operand EXTR: To extract certain columns from a table .............................................................. 6
3.6.1 Operand NOM_PARA ............................................................................................................. 6
3.7 TRI operand: To order the lines ............................................................................................... 6
3.7.1 Operand NOM_PARA ............................................................................................................. 7
3.7.2 Operand COMMAND .................................................................................................................... 7
3.8 Operand INFORMATION ............................................................................................................................... 7
4 Examples ............................................................................................................................................... 8

Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
3/10

2 Syntax

= CALC_TABLE (

reuse
=, [tabl_ *]



TABLE
= matable,
[tabl_ *]



TITER
= title
[l_Kn]


# 1. Concaténer/to combine two tables:



COMB =_F (
TABLE


=
count,


[tabl_ *]






NOM_PARA

=
will l_para,
[l_Kn]






),


# 2. To apply a formula:



OPER =_F (
FORMULE =
formulate,

[formula]






NOM_PARA

=
para, [kN]






),


# 3. To re-elect parameters of a table:



RENOMME =_F (
NOM_PARA

=
will l_para,
[l_Kn]






),


# 4. To filter lines:



FILTRE =_F (
NOM_PARA

=
para, [kN]








/
CRIT_COMP
=

/“EQ”,
[DEFAUT]
/“”,
/“LT”,
/“WP”,
/“IT”,
/“GE”,









/VALE_I

=
ival,
[I]










/
VALE_K

=
kval,
[KN]










//
VALE
=
rval,
[R]











/
VALE_C

=
cval,
[C]











|
PRECISION =/prec,
[R8]
/
1.0D-3,
[DEFAUT]












|
CRITERION =/“RELATIVE”, [DEFECT]
/
“ABSOLU”,
/
CRIT_COMP
=

/“MAXI”,
/“ABS_MAXI”,
/“MINI”,
/“ABS_MINI”,
/“VIDE”,
/“NON_VIDE”,




),


# 5. To extract certain columns:



EXTR =_F (
NOM_PARA

=
will l_para,
[l_Kn]






),


# 6. To order the lines according to values' of a parameter:



TRI =_F (
NOM_PARA
=
will lpara,
[l_Kn]







ORDRE
=/“CROISSANT”
,
[DEFAUT]











/“DECROISSANT”,





),




INFO
=
/
1,
[DEFAUT]





/
2,





)
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
4/10

3 Operands

3.1 Operand
TABLE

TABLE = matable

Name of the initial table on which one will carry out handling

3.2 Operand
COMB: concaténer/to combine two tables

/
COMB

Key word COMB allows concaténer, to combine two tables between them, with seam on one
common parameter list.

3.2.1 Operand
TABLE


TABLE = table

Name of the table whose values must come to overload and/or enrich the initial table.

3.2.2 Operand
NOM_PARA


NOM_PARA = will l_para

Name of the parameters whose values must be identical in the two tables.

Remarks for the combination:

Ex: tab_resu=CALC_TABLE (TABLE=tab1,
COMB=_F (TABLE=tab2,
NOM_PARA= (“ABSC_CURV”, “NODE”)))
When ABSC_CURV and NOEUD are identical between tab1 and tab2, one inserts the values of
tab2 on the line of tab1 (for the other parameters common to the 2 tables, it is thus
value of tab2 which crushes that of tab1). If not one adds the line of tab2 at the end of tab1.
NOM_PARA acts like a primary key: if one does not find more once couple
(ABSC_CURV, NOEUD), the line is added.
This operator is not répétable because the command of the occurrences of the key word factor could
to modify the final result.

3.3 Operand
OPER: To apply a formula

/
OPER

Allows to apply a formula whose variables are the parameters of the table and to insert it
result in a new column.

Note:

This operator is répétable.

3.3.1 Operand
FORMULE


FORMULE = formula

Name of the formula to be applied

3.3.2 Operand
NOM_PARA


NOM_PARA = para

Name of the new parameter.
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
5/10

3.4 Operand
RENOMME: To re-elect parameters of a table

/
RENOMME

Key word RENOMME makes it possible to re-elect one or more parameters of a table.

3.4.1 Operand
NOM_PARA


NOM_PARA = will l_para

Name of the parameters: couples values (old name of the parameter, new name of
parameter)

Note:

This operator is répétable.

3.5 Operand FILTERS: To filter the lines according to certain criteria

/
FILTRE

The key word factor FILTRE makes it possible to retain in the table only the lines checking some
criteria imposed by the user. The occurrences of the key word are added the ones to the others
like successive filters. For each occurrence of this key word, one specifies the name of
parameter for which one imposes a condition, the type of condition (equality, not-equality, more
small.) as well as the value associated with the condition.

Note:

This operator is répétable.

3.5.1 Operand
NOM_PARA

NOM_PARA = para

para is the name of the parameter to which the constraint of filtering relates.

3.5.2 Operand
CRIT_COMP

CRIT_COMP = crit

crit is the type of the constraint of filtering.

EQ
“equality” for the entireties, the texts, realities or the complexes.
For the floating numbers (real or complex), this equality is evaluated with
a certain tolerance given by key words PRECISION and CRITERE.

“not-equality” (Cf. EQ)
LT
“smaller than”
Relations of command:
- natural for the entireties and realities
- alphabetical for the texts
- invalid for the complexes
WP
“larger than” (Cf. LT)

“smaller or equal to” (Cf. LT)
GE
“larger or equal to” (Cf. LT)
VIDE
blank cell
NON_VIDE
nonempty cell
MAXI
the line selected will be that which will have the maximum value
ABS_MAXI
the line selected will be that which will have the maximum absolute value
MINI
the line selected will be that which will have the minimal value
ABS_MINI
the line selected will be that which will have the minimal absolute value
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
6/10

3.5.3 Operands
VALE/VALE_I/VALE_C/VALE_K

These various key words are used according to the type of the column associated with the parameter on
which carries the constraint: entirety, reality, complex or text.

One gives in argument the value associated with the constraint; for example 12 if one is interested only in
sequence number 12.

This operand is useless when the types of constraint are used: “VACUUM”, “NON_VIDE”, “MAXIMUM”,
“MINI”,…

3.5.4 Operands
CRITERION/PRECISION

When the constrained parameter is of floating type (real or complex) and that the type of constraint is
the equality (or not-equality), this equality is evaluated with a certain tolerance.

PRECISION = eps,


eps is the tolerance
“RELATIVE” CRITERE=/,
|x-xref| < eps *|xref|
/“ABSOLU”

,
|x-xref|
<
eps

3.5.5 Example of use of key word FILTRE

If one specifies:

FILTRE= (_F (NOM_PARA= “NODE”, VALE_K = “N7”,),
_F (NOM_PARA= “INST”, CRIT_COMP= “WP”, VALE= 3.0,),
_F (NOM_PARA= “INST”, CRIT_COMP= “LT”, VALE= 13.0,),
),

One thus selects the lines of the table such as parameter NOEUD is worth “N7” and such as
parameter INST lies between 3. and 13.

3.6 Operand
EXTR: To extract certain columns from a table

/
EXTR

Key word EXTR makes it possible to extract certain columns from a table.

3.6.1 Operand
NOM_PARA


NOM_PARA = will l_para

Name of the parameters which one wants to extract.

Note:

This operator is not répétable.

3.7 Operand
TRI: To order the lines

/
TRI

Key word TRI makes it possible to order the lines according to values' of the parameters.

Note:

This operator is not répétable because the command of the occurrences of the key word factor could
to modify the final result.
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
7/10

3.7.1 Operand
NOM_PARA


NOM_PARA = will l_para

Names of the parameters to which the sorting relates.

3.7.2 Operand
ORDRE


COMMAND =/“GROWING”
/
“DECROISSANT”


This key word is used to specify if one must use an order ascending or decreasing. By defect, one
sort by ascending order.

The relations of command used are:

·
the natural command for the entireties and realities,
·
the alphabetical order for the texts and the names of concepts.

Note:

One cannot be useful oneself of a parameter complexes to classify the lines of a table.

For the parameters of the type NOEUD (or MAILLE), the command is alphabetical because these
parameters contain the name of the nodes (or of the meshs).

If one specifies:

TRI=_F (NOM_PARA= (“NODE”, “INST”), ORDRE= “GROWING”),

One will sort the lines of the table in the alphabetical order of the nodes. If there are several
lines corresponding to a given node, the second sort key (INST) will be used for
to classify these lines.

3.8 Operand
INFO

INFO = inf

Print in the file “message” of additional information if inf=2. Nothing occurs
if inf=1.
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
8/10

4 Examples

Count “TB1”
NR Y Z
NOEUD
0.2.0.4.5 NO1
1 4.0
17.5 N03
2 17.5 9.0 N06

Count “TB2”
NR X Z
NOEUD
1.2.0.2.5 NO1
3.4.0.5.5 N031
4 17.5
20.5 N062
6.5.0.8.0 N013

#--- COMBINAISON

TB3=CALC_TABLE (TABLE=TB1,
COMB =_F (TABLE = TB2, NOM_PARA=' NOEUD'))

The contents of table TB3 are:

NR Y Z NODE X
1 2.00000E+00 2.50000E+00 N01 2.00000E+00
1 4.00000E+00 1.75000E+01 N03 -
2 1.75000E+01 9.00000E+00 N06 -
3 - 5.50000E+00 N031 4.00000E+00
4 - 2.05000E+01 N062 1.75000E+01
6 - 8.00000E+00 N013 5.00000E+00

#--- FORMULE

DNOR=FORMULE (NOM_PARA = (“X”, “Z”),
VALE = “SQRT (X * X+Z * Z)”)

TB3=CALC_TABLE (TABLE = TB3,
reuse = TB3,
OPER =_F (FORMULE=DNOR, NOM_PARA=' NOR_COOR'))

The contents of table TB3 are:

NR Y Z NODE X NOR_COOR
1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00
1 4.00000E+00 1.75000E+01 N03 - -
2 1.75000E+01 9.00000E+00 N06 - -
3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00
4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01
6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
9/10

#--- RENOMMER

TB3=CALC_TABLE (TABLE = TB3,
reuse = TB3,
RENOMME=_F (NOM_PARA= (“NOR_COOR”, “NORM_XZ”)))

The contents of table TB3 are:

NR Y Z NODE X NORM_XZ
1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00
1 4.00000E+00 1.75000E+01 N03 - -
2 1.75000E+01 9.00000E+00 N06 - -
3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00
4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01
6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00

#--- FILTRE

TB4=CALC_TABLE (TABLE = TB3,
FILTER =_F (NOM_PARA=' NORM_XZ', CRIT_COMP=' LE', VALE=30.))

The contents of table TB4 are:

NR Y Z NODE X NORM_XZ
1 2.00000E+00 2.50000E+00 N01 2.00000E+00 3.20156E+00
3 - 5.50000E+00 N031 4.00000E+00 6.80074E+00
4 - 2.05000E+01 N062 1.75000E+01 2.69537E+01
6 - 8.00000E+00 N013 5.00000E+00 9.43398E+00

#--- EXTRACTION

TB3=CALC_TABLE (TABLE = TB3, reuse=TB3,
EXTR =_F (NOM_PARA= (“NODE”, “X”, “Z”, “NORM_XZ”)))

The contents of table TB3 are:

NODE X Z NORM_XZ

N01 2.00000E+00 2.50000E+00 3.20156E+00

N03 - 1.75000E+01 -

N06 - 9.00000E+00 -

N031 4.00000E+00 5.50000E+00 6.80074E+00

N062 1.75000E+01 2.05000E+01 2.69537E+01

N013 5.00000E+00 8.00000E+00 9.43398E+00

#--- TRI

TB3=CALC_TABLE (TABLE = TB3, reuse=TB3,
SORTING = _F (NOM_PARA=' NORM_XZ', ORDRE=' DECROISSANT'))

The contents of table TB3 are:

NODE X Z NORM_XZ

N062 1.75000E+01 2.05000E+01 2.69537E+01

N013 5.00000E+00 8.00000E+00 9.43398E+00

N031 4.00000E+00 5.50000E+00 6.80074E+00

N01 2.00000E+00 2.50000E+00 3.20156E+00

N06 - 9.00000E+00 -

N03 - 1.75000E+01 -
Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Code_Aster ®
Version
8.2
Titrate:
Procedure CALC_TABLE


Date:
31/01/06
Author (S):
COURTEOUS Mr., F. LEBOUVIER Key
:
U4.33.03-A1 Page:
10/10

Intentionally white left page.

Handbook of Utilization
U4.3- booklet: Function HT-62/06/004/A

Outline document