Tables & Columns
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)
Parameters
| 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 |
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)
Parameters
| 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 |
norm
Normalizes the numbers in a container to a given total.
Collection norm(Collection x, Numeric total, integer level=nothing, Object sumdim=nothing)
Parameters
| x : | is the container which contains the values you want to normalize. |
| total : | is the sum you want to use for normalization, e.g. 100 if you want to express the values from container x in percent. |
| level : | is the level of details to operate on |
| sumdim : | specifies the dimension for the operation if the source is a multi-dimensional collection |
paretoSum
Collection paretoSum(Object weight)
Parameters
percentage
Normalizes the numbers in a container to a total of 1.0.
Collection percentage(Collection x, integer level=0.0, Object sumdim=nothing)
Parameters
| x : | is the container which contains the values you want to normalize. |
| level : | is the level of details to operate on |
| sumdim : | specifies the dimension for the operation if the source is a multi-dimensional collection |
ranking
Calculates rank numbers for a sequence according to the values in a vector. If the reverse parameter is false, the item with the highest value will get rank number 1. If the reverse parameter is true, the item with the lowest value will get rank number 1.
Collection ranking(Collection vector, boolean reverse=false)
Parameters
| vector : | a vector of values to be compared to each other |
| reverse : | indicates the sort direction |
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)
Parameters
| 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. |
scaleMax
Re-scales argument x from 0..maximum(x) to the new range given by min and max
Collection scaleMax(Collection x, Object min=1.0, Object max=10.0, Object mode=2.0)
Parameters
| x : | is the vector of values to be re-scaled |
| min : | is the new minimum |
| max : | is the new maximum |
| mode : | is the calculation mode: shallow: calculate in the dimension of x, levels: calculate for both the system and the parameter level of x |
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)
Parameters
| vector : | the vector that contains the values |
| offset : | the offset between the source and the target vector |
totalImportance
Calculates the total importance from one or more scoring methods, e.g. AHP, result of a questionnaire...
Collection totalImportance(Collection table, float total=1.0)
Parameters
| table : | is the table containing the results of the different methods |
| total : | the intended total sum for the result, 1.0 for percentage |
English
German