Status & Access

ahpmean

returns mean importances for each customer group compatible to a QFD0 matrix

Collection ahpmean(Collection ahpimportance, Collection customergroup)

ahpimportance: is the table of importances for each respondent, calculated by ahp
customergroup: is a table column containing the customer group for each respondent

attributelookup

Retrieves the attribute of a given scalar, vector or matrix.

Object attributelookup(Object src, string name, boolean handle_enumerations=false, Object def=nothing)

src: the object that has got the attribute
name: the name of the attribute
handle_enumerations: set to true if the function should retrieve the attribute of a enumeration value rather than the attribute of a cell
def:

currentlayer

Collection currentlayer(Collection source, Object type=0)

source:
type:

diagramlookup

searches for a maximum or minimum value of items in a diagram defined by a interrelationship matrix

Collection diagramlookup(Collection diagram, Collection src, integer iterations=1, boolean findmaximum=true, integer level=nothing)

diagram: is the matrix defining the diagram
src: is the vector containing the values to be searched
iterations: defines the number of recursive lookups. Positive numbers indicate a lookup from cause to effect, negative numbers indicate a lookup from effect to cause.
findmaximum: if true, the result is the maximum of all connected values. if false, the result is the minimum of all connected values.
level: is the level of details the operation is performed on.

extend

expands the dimension of the given object by 1

Object extend(Collection src, Collection dim, integer lev=leafLevel, integer =leafLevel)

src: is the soruce object with dimension n
dim: is the dimension to add
lev:
:

formatcondition

Used for conditional formatting. Using this function creates one of the 4 available conditional format states. For each state, individual format settings can be set.

Collection formatcondition(integer mode, Collection src, Object val1=nothing, Object val2=nothing, Object val3=nothing, Object val4=nothing, Object val5=nothing, Object val6=nothing)

mode: comparison mode. decides how src, val1 and val2 have to be compared to create the result.
src: source parameter for the comparison operation
val1: second parameter for the comparison operation
val2: third parameter for the comparison operation
val3: third parameter for the comparison operation
val4: third parameter for the comparison operation
val5: third parameter for the comparison operation
val6: third parameter for the comparison operation

hiword

returns the upper 16 bit of a 32 bit integer value

integer hiword(Collection value)

value: is the 32 bit integer or a collection of 32 bit integers

identicalrows

detects identical rows or columns in a matrix or tensor.

Collection identicalrows(Collection tensor, Object rowdim, Object coldim)

tensor: is the matrix or tensor to be checked
rowdim: is the row dimension index or tree
coldim: is the column dimension index or tree

isemptyrow

detects empty rows or columns in a matrix or tensor.

Collection isemptyrow(Collection tensor, Object rowdim, Object coldim)

tensor: is the matrix or tensor to be checked
rowdim: is the row dimension index or tree
coldim: is the column dimension index or tree

isprimary

Checks if a cell is marked as the primary cell of a matrix

Collection isprimary(Object obj)

obj: the source object, usually a matrix with some cells marked as primary

isstate

Checks if a cell is marked with a specified user defined state.

Collection isstate(Object obj, Object state=nothing)

obj: the source object, usually a matrix or table column
state: the state to be checked. Valid constants are stNotConfirmed, stInProgress, stConfirmed, stUser1, stUser2, stUser3, stUser4, stPrimary, stCritical

leaflev

Returns the content of the given collection in a new collection using the bottom level of the attached tree.

Collection leaflev(Collection src)

src: is the source collection

lev

Returns the content of the given collection in a new collection using specified levels of the attached trees.

Collection lev(Collection src, integer dim1=nothing, integer dim2=nothing, integer dim3=nothing, integer dim4=nothing, integer dim5=nothing, integer dim6=nothing, integer dim7=nothing, integer dim8=nothing)

src: is the source collection
dim1: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim2: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim3: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim4: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim5: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim6: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim7: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)
dim8: is the level for the n'th dimension of the collection. Enter a number or one of the level constants (outlineLevel, bottomLevel, paramLevel)

loword

returns the lower 16 bit of a 32 bit integer value

integer loword(Collection value)

value: is the 32 bit integer or a collection of 32 bit integers

matrixlookup

Returns a vector the same size as the two input vectors. The result contains the cells of the given matrix found at the coordinates specified by x and y.

Collection matrixlookup(Collection x, Collection y, Collection matrix)

x: is a vector containing coordinates for the first dimension of the matrix
y: is a vector containing coordinates for the second dimension of the matrix
matrix: is a matrix

mget

Collection mget(string system, string table, string column="", string name1="", string name2="", string name3="")

system:
table:
column:
name1:
name2:
name3:

outlev

Returns the content of the given collection in a new collection using the outline level of the attached tree.

Collection outlev(Collection src)

src: is the source collection

reduce

reduces the dimension of the given object by 1

Object reduce(Collection src, Object dim, integer mode=reduce_to_median, integer =reduce_to_median)

src: is the soruce object with dimension n
dim: is the dimension to remove
mode:
:

sectionlookup

Returns a section of a n-dimensional tensor with a dimension of n-1, e.g. a column of a matrix.

Object sectionlookup(Collection src, Object key, Collection header=nothing)

src: is the tensor
key: is the name of the selected element, e.g. the name of a column
header: optional: the tree that contains the header elements.

selectedbranch

Collection selectedbranch(Collection source, Object selection)

source:
selection:

subset

Returns a part of a given source object, specified by a level descriptor for each dimension.

Object subset(Collection src, Object level=nothing)

src: is the source object
level: level descriptor (numeric, name of a item type or a vector)

synctree

Collection synctree(Collection net, Object relval=nothing)

net:
relval:

syslev

Returns the content of the given collection in a new collection using the parameter level of the attached tree.

Collection syslev(Collection src)

src: is the source collection

throwerror

Interrupts recalculation and returns an error message. The error message is shown in the session window. This function can be used for exception handling in user-defined functions.

integer throwerror(integer error)

error: An error message.

trizsolution

Returns the list of TRIZ conflict resolutions for an auto matrix (roof matrix) of characteristics.

Collection trizsolution(Collection conflicts, Object parameters, Collection solutions)

conflicts: The auto matrix
parameters: A vector containing the TRIZ engineering parameter for each input of the matrix.
solutions: The TRIZ matrix of inventive principles

Feedback

Did you find what you needed?

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

Functions and Formulas

Status & Access

Status & Access

ahpmean

attributelookup

currentlayer

diagramlookup

extend

formatcondition

hiword

identicalrows

isemptyrow

isprimary

isstate

leaflev

lev

loword

matrixlookup

mget

outlev

reduce

sectionlookup

selectedbranch

subset

synctree

syslev

throwerror

trizsolution

Feedback

Did you find what you needed?