Functions and Formulas  

Matrix Fill

accumulate

fills a vector by adding an input value to the value in the previous row of the vector. (f(i)=f(i-1)+x)

• value: is the scalar or vector with the input values
• start: is the initial value
• sort: defines a sort order
• asc: true: sort ascending, false: sort descending
• : is the scalar or vector with the input values
• : is the initial value
• : defines a sort order
• : true: sort ascending, false: sort descending

groupby

Creates group index numbers from 1 to 3 for all values in the weight input column.

• weight: is a column containing weights
• lo: is the specification limit between group 1 and 2
• hi: is the specification limit between group 2 and 3
• hi2: is the specification limit between group 2 and 3
• hi3: is the specification limit between group 2 and 3
• hi4: is the specification limit between group 2 and 3

limit

Limits the first argument to a given minimum and maximum

• value: is the input value
• min: is the lower bound of the range
• max: is the upper bound of the range

markselected

Inserts a given value into all cells of a matrix whose columns and rows are found in two collections of selected items.

• matrix: The input matrix
• sel0: A tree or custom list value containing the selected rows
• sel1: A tree or custom list value containing the selected columns
• val: The value to be inserted into a cell, if column and row are both found in the two collection of selected items.

merge

returns either the first or second function argument depending on the state and value of the first argument

• x: contains the primary values
• y: contains the secondary values
• v: a primary value equal to this will be ignored and the secondary value will be taken instead

mirrorcustom

Completes a partially filled Automatrix (quadratic matrix) by filling empty cells with the inverse values of the corresponding transposed cells..

• x: is the partially filled Automatrix
• lt: is the value for 'less important'
• eq: is the value for 'equally important'
• gt: is the value for 'more important'

mirrorneg

Completes a partially filled Automatrix (quadratic matrix) by filling empty cells with the negated values of the corresponding transposed cells.

• x: is the partially filled Automatrix

mirrorreciprocal

Completes a partially filled automatrix (quadratic matrix) by filling empty cells with the inverse values of the corresponding transposed cells.

• x: is the partially filled automatrix
• total: the intended total sum for each column of the result, 1.0 for percentage, 0.0 to skip normalization
• ahp: if true, only items belonging to the same group will be part of the result.

scale

Maps the numbers in a container from an old to a new range.

• x: is the container which contains the values you want to rescale.
• min1: is the lower boundary of the old range.
• max1: is the upper boundary of the old range.
• min2: is the lower boundary of the new range.
• max2: is the upper boundary of the new range.

selection

Enters the selection from an single or multivalued enumeration into a matrix or vector.

• x: The field or vector containing the enumerations.
• val: The value to be entered into the selected cells

shift

Creates a vector from the values of a given source vector. The rows of the new vector are shifted by a given offset.

• vector: the vector that contains the values
• offset: the offset between the source and the target vector