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)

Collection accumulate(Object value, Object start, Object sort=nothing, boolean asc=true, Object , Object , Object =nothing, boolean =true)

  • 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.

Collection groupby(Object weight, Object lo=0.333333, Object hi=0.666666, Object hi2=nothing, Object hi3=nothing, Object hi4=nothing)

  • 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

Collection limit(Collection value, Collection min, Collection max=nothing)

  • 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.

Collection markselected(Collection matrix, Object sel0, Object sel1, Object val)

  • 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

Collection merge(Collection x, Collection y, Collection v=nothing)

  • 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..

Collection mirrorcustom(Collection x, Collection lt, Collection eq, Collection gt)

  • 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.

Collection mirrorneg(Collection x)

  • 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.

Collection mirrorreciprocal(Collection x, float total=0.0, boolean ahp=true)

  • 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.

Collection scale(Collection x, Numeric min1, Numeric max1, Numeric min2, Numeric max2)

  • 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.

Collection selection(Collection x, Collection val)

  • 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.

Collection shift(Collection vector, integer 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:

=