Functions and Formulas

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

weight :

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

Feedback

Did you find what you needed?

If you have any further questions or suggestions to improve this page, please let us know: