Material data

Returns information concerning a material.

RSA_MATERIAL_DATA (Information type, Material name)

The RSA_MATERIAL_DATA formula syntax has the following arguments:

Information type

The following types of information are available:

CB71_CATEGORY
timber category (0 - default, 1 - I, 2 - II, 3 - III; parameter for timber according to CB71)

CB71_HUMIDITY
initial (assembly) humidity (for timber design according to CB71)

CB71_NATURE
timber nature (1 - nonresinous, 0 - resinous; parameter for timber according to CB71)

CB71_RETREAT
shrinkage - given as percentage (data specific to timber design according to CB71)

CS
reduction factor for the limit of elasticity (shear) / burning velocity in mm/min. (for timber according to CB71)

DEFAULT
default material

DUMPCOEF
damping coefficient

E
Young's modulus / modulus of axial elasticity for timber

E5
5% modulus of axial elasticity - E 0.05 (for timber design according to EC 5)

EC_DEFORMATION
shear modulus (G) (for timber design according to EC 5)

ETRANS
modulus of transversal elasticity E 90, mean (data specific to timber design according to Eurocode5)

GMEAN
average modulus G / EC5

KIRCHOFF
shear modulus G

LX
thermal expansion coefficient

NAME
Material name

NU
Poisson ratio

NUANCE
additional short material description (contents of the DESCRIPTION column in the material database)

PN_DEFORMATION
shear modulus (G) (for timber design according to PN)

PN_E_ADDITIONAL
additional parameter (for timber design according to PN)

PN_E_TRANS
modulus of transversal elasticity (for timber design according to PN)

RE
design resistance

RE_AX_COMPR
axial compression resistance (for timber) / EC5

RE_AX_TENS
axial tension resistance (for timber) / EC5

RE_BENDING
flexural resistance (for timber) / EC5

RE_SHEAR
shear resistance (for timber) / EC5

RE_TR_COMPRESSION
transversal compression resistance (for timber) / EC5

RE_TR_TENSION
transversal tension resistance (for timber) / EC5

RO
unit weight

RT
limit tension resistance

SECOND_NAME
Second material name (used for steel so that it is possible to specify the equivalent according to Eurocode); contents of the SECOND_NAME column in the material database

STEEL_THERMAL
thermal processing indicator (1- processing, 0 - no processing)

TIMBER_TYPE
material type for timber (for example, natural - 0, glued - 1)

TYPE
material type (specifies a numerical designation of the material, for example, the number 1 denotes STEEL)

Note: If you type an argument in the formula manually, enclose the text in quotation marks. You can also select or type a cell address (for example A1) which the data will be loaded from.

Material name

The following input methods are available:

Text - type a text (any character string) and enclose it in quotation marks
Cell address - select or type a cell address (for example A1) which the data will be loaded from

Note: The specified name must be the same as the text entered into the ‘Name’ field in the material database.

EXAMPLE

Open the RSA_FORMULAS.rtd and RSA_FORMULAS.xlsx files to get a better understanding of the example below.

Note: The files are located in C:/ProgramData/Autodesk/Examples/Results Connect/RSA.

Formula:

RSA_MATERIAL_DATA("DUMPCOEF",H23) - specifies a value of the damping coefficient for the material determined in the cell H23

Result (data):

0.06