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:

=