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