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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
Organization (S):
EDF-R & D/AMA, DeltaCAD
Instruction manual
U4.3- booklet: Function
Document: U4.33.03
Procedure
CALC_TABLE
1 Goal
To handle the data of
tables
with the manner of a spreadsheet.
The control makes it possible to carry out operations on the data of the tables. Following operations
are currently available:
·
Concaténer/To combine 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.
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
Count
matters
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
2 Syntax
= CALC_TABLE
(
reuse
=, [tabl_ *]
COUNT
= matable,
[tabl_ *]
TITRATE
= title
[l_Kn]
# 1. Concaténer/to combine two tables:
COMB =_F (
COUNT
=
count,
[tabl_ *]
NOM_PARA
=
will l_para,
[l_Kn]
),
# 2. To apply a formula:
OPER =_F (
FORMULATE =
formulate,
[formula]
NOM_PARA
=
para, [kN]
),
# 3. To re-elect parameters of a table:
RE-ELECT =_F (
NOM_PARA
=
will l_para,
[l_Kn]
),
# 4. To filter lines:
FILTER =_F (
NOM_PARA
=
para, [kN]
/
CRIT_COMP
=
/“EQ”,
[DEFECT]
/“”,
/“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,
[DEFECT]
|
CRITERION =/“RELATIVE”, [DEFECT]
/
“ABSOLUTE”,
/
CRIT_COMP
=
/“MAXIMUM”,
/“ABS_MAXI”,
/“MINI”,
/“ABS_MINI”,
/“VACUUM”,
/“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:
SORTING =_F (
NOM_PARA
=
will lpara,
[l_Kn]
COMMAND
=/“GROWING”
,
[DEFECT]
/“DECREASING”,
),
INFORMATION
=
/
1,
[DEFECT]
/
2,
)
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
3 Operands
3.1 Operand
COUNT
COUNT = 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
COUNT
COUNT = 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 NODE 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, NODE), 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
FORMULATE
FORMULATE = formula
Name of the formula to be applied
3.3.2 Operand
NOM_PARA
NOM_PARA = para
Name of the new parameter.
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
3.4 Operand
RE-ELECT: To re-elect parameters of a table
/
RE-ELECT
The key word RE-ELECTS 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
FILTER
: To filter the lines according to certain criteria
/
FILTER
The key word factor
FILTER
allows 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 stress of filtering relates.
3.5.2 Operand
CRIT_COMP
CRIT_COMP = crit
crit
is the type of the stress 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 the key words
PRECISION
and
CRITERION
.
“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
)
VACUUM
blank cell
NON_VIDE
nonempty airframe
MAXIMUM
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
MINICOMPUTER
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
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
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 stress: entirety, reality, complex or text.
One gives in argument the value associated with the stress; for example 12 if one is interested only in
sequence number 12.
This operand is useless when the types of stress 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 stress 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|
/“ABSOLUTE”
,
|x-xref|
<
eps
3.5.5 Example of use of the key word
FILTER
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 the parameter
NODE
is worth '
N7'
and such as
parameter
INST
that is to say included/understood enters
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
SORTING: To order the lines
/
SORTING
The TRI key word 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.
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
3.7.1 Operand
NOM_PARA
NOM_PARA = will l_para
Names of the parameters to which the sorting relates.
3.7.2 Operand
COMMAND
COMMAND =/“GROWING”
/
“DECREASING”
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
NODE
(or
NET
), 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
INFORMATION
INFORMATION = inf
Print in the file “message” of additional information if inf=2. Nothing occurs
if inf=1.
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
4 Examples
Count
'
TB1
'
NR Y Z
NODE
0.2.0.4.5 NO1
1 4.0
17.5 N03
2 17.5 9.0 N06
Count
'
TB2
'
NR X Z
NODE
1.2.0.2.5 NO1
3.4.0.5.5 N031
4 17.5
20.5 N062
6.5.0.8.0 N013
#--- COMBINATION
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
#--- FORMULATE
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
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
#--- TO RE-ELECT
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
#--- FILTER
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
#--- SORTING
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 -
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
Instruction manual
U4.3- booklet: Function HT-62/06/004/A
Intentionally white left page.