General concept

Majority of functions accepts only an argument (). However, some of them also require pre-argument {}, and post argument []. For example, a simple sinus function going to look like:sin(0.24) ==> 0.23770262642713458accepting only angle value in radians. Whereas more complicated logarithm requires definition of the base too:log{10}(2780) ==> 3.4440447959180758A numeric integration function expects integration boundaries in pre-argument, integration function in argument, and discretization value in post argument, which is an integer between 100 and 100000.int{2,7}(2*x^2-15)[1000] ==> 148.33337499999996Post argument for the int function is optional, the default value of discretization is 1000. Functions requiring a set of numbers: min, max, mean, and stdev, accept those numbers in pre-argument.max{5, 7, 81} ==> 81To make a reference to another cell use its address in the format A7, B5, and so on. No special signs required.

! -- Only argument allows usage of mathematical operations and other functions. Pre argument accepts numbers, constants, and cell references. Post argument — numbers or letters.

! -- The only variable recognized by the system is x and it can be used only inside the integration function or sum of series.

List of functions

• sin()sine
• cos()cosine
• tan()tangent
• cot()cotangent
• asin()arcsine
• acos()arccosine
• atan()arctangent
• acot()arccotangent
• sinh()hyperbolic sine
• cosh()hyperbolic cosine
• tanh()hyperbolic tangent
• coth()hyperbolic cotangent
• abs()absolute value
• ln()natural logarithm
• log{base}()logarithm
• min{x1, x2, ... xn}minimum
• max{x1, x2, ... xn}maximum
• mean{x1, x2, ... xn}mean value
• stdev{x1, x2, ... xn}standart deviation
• sums{min: step: max}(f(x))sum of series
• int{min, max}(f(x))[discretization]numeric integration

List of constants

Conditional cell value

To change any cell value conditionally you must start its definition (formula) with the if statement. The concept of the condition block structure is the same as it is with the functions — if, elif, else define type of the block. It has to be followed by curly braces (pre-argument) describing conditions, and brackets (argument) which will hold the function or value that is going to be used if the conditions are met. No post argument expected. Every new block has to start on a new line.

• if{D2 <= 7}(3.75 + D2^1.7)
• elif{D2 > 7 && D2 < 12}(24.75 + D2^1.85)
• else(125)

! -- If block can only be first and else block can only be last.

! -- In case where no conditions are met NaN will be returned, which can not be used in further calculations.

! -- Accepted logical operators are && for logical and, || for logical or.

! -- Accepted comparisons: > for greater, < for less, >= for greater or equal, <= for less or equal, == for equal, != for not equal

Conditional cell comment

To make a conditional cell comment open a cell description table and hit the conditional comment button. Conditional comment syntax is basically the same as for conditional cell value: pre-argument holds a set of conditions, argument stores a comment string, and optional post argument defines semaphore type and accepts only three letters which represents green, orange, and red colours.if

• if{D2 <= 355}(ok)[g]
• elif{D2 > 355 && D2 <= 500}(possible plastic deformation)[o]
• else(high risk of failure)[r]

! -- In case where no conditions are met no comment string will be returned and the semaphore will take its neutral form — ○