Tools: Label Style - Formula Definition + Define Cell - Formula
Arithmetic operators
+ |
Addition |
() |
Parentheses |
- |
Subtraction |
(()) |
Nested parentheses |
* |
Multiplication |
e |
A power of ten in floating-point representation |
/ |
Division |
^ |
Power |
Supported arithmetic functions
Note: The arithmetic functions that can be used with label styles are different from those provided by the
Function () tool (How). Click here to see an overview.
Allplan |
Math. |
Explanation |
ABS(X) |
|x| |
Absolute value |
SQRT(X) |
|
Square root |
SQR(X) |
x2 |
Square |
PI(X) |
PI |
Circle function of pi PHI(2) = PI * 2 |
LN(X) |
ln x |
Natural logarithm (Base e) |
LOG(X) |
log x |
Logarithm for base 10 |
RCP(X) |
1/x |
Reciprocal of x |
EXP(X) |
ex |
Exponential function (basis x) |
SGN(X) |
- |
Sign 0=0 <0=-1 >0=+1 |
SIN(X) |
sin x |
Sine |
COS(X) |
cos x |
Cosine |
TAN(X) |
tan x |
Tangent |
ASIN(X) |
arcsin x |
Arc sine |
ACOS(X) |
arccos x |
Arc cosine |
ATAN(X) |
arctan x |
Arc tangent |
SINH(X) |
sinh x |
Hyperbolic sine |
COSH(X) |
cosh x |
Hyperbolic cosine |
TANH(X) |
tanh x |
Hyperbolic tangent |
NINT(X) |
- |
Rounding to the next integer |
INT(X) |
- |
Rounds down to nearest integer |
CEIL(X) |
- |
Rounds up to nearest integer |
GRA(X) |
- |
Radians to degrees |
RAD(X) |
|
Degrees to radians |
GON(X) |
- |
Radians to grads |
RAG(X) |
|
Grads to radians |
AVG(x1; x2; ..) |
- |
Average of up to 10 semicolon-separated arguments (AVG(1;3)=2) |
MIN(x1; x2; ..) |
- |
Minimum of up to 10 semicolon-separated arguments (MIN(1;3)=1) |
MAX(x1; x2; ..) |
- |
Maximum of up to 10 semicolon-separated arguments (MAX(1;3)=3) |
FLAG(Value; bit[n];...) |
- |
Offers a Binary check. |
ROUND(X;x) |
- |
Rounds off any number (X) to a specific number of digits |
ROUND(X;y;z) |
- |
Rounds off any number (X) to a specific number of digits (y) by using a specific rounding precision for the last digit (z) |
ELE() |
- |
Filters several numeric values of an attribute and returns 0 or 1 |
VALUE(string;index) |
- |
Derives any values from texts |
MID(Text; |
- |
Returns a specific number of characters of a character string |
PARENTPRECAST() |
- |
Enables the selection of attributes of the upstream precast element (parent element) of reinforcement elements and fixtures in legends, label styles and reports. Tip: You can also find bars or fixtures that do not belong to any precast element using the PARENTPRECAST () command. The filter is used to search for bars or fixtures for which there is no upstream precast element (attribute Precast ID, @1877@ = 0) |
FORMAT(format string; value1; [value<n>]; ....) |
- |
Is used for formatted output of values |
IMPPRE(Parameter1; Parameter2) |
- |
This is used to convert a metric unit into the current American unit in use (feet, inches) for dimensions. Parameter1 defines the attribute to be converted. Parameter2 defines the unit of the attribute currently set.
Note: Make sure you enter a space after Parameter1;. |
FIXTURECOUNT(Attribute;Value) |
- |
Calculates the number of fixtures with a specific attribute in a precast element. |
GROUP(instruction;attribute) |
- |
It groups elements containing attributes such as reinforcement, precast elements and similar. The GROUP function considers 3 different scenarios:
Note: Only one individual attribute can ever be evaluated with the GROUP function. For example, one grouping using the attribute Dim. string index (@1013@, Integer) could appear as follows: |
OPENINGMACROCOUNT(Attribute;Value) |
- |
You can, for example, count all openings with an opening macro for slabs or wall elements (iWall), which geometrically influence the selected precast element. Openings that lie outside or that only touch the precast element are not counted. |
Syntax of Allplan's formula interpreter (Backus-Naur form)
|
(C) ALLPLAN GmbH |
Privacy policy |