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
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.
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
Feedback
Did you find what you needed?
If you have any further questions or suggestions to improve this page, please let us know: