Subprojects
subsyscount
counts all variables with a given name, found in the sub systems of the current workbook
Collection subsyscount(Object var, Object condition=nothing, Object compval=nothing)
-
var: is the name of the variable in the sub system
-
condition: optional, is the name of a property in the sub system that decides, if this sub system is used for the accumulate process
-
compval: optional: is the value the condition variable is compared to
subsysmax
calculates the maximum of all sub-system variables that share the given variable name
Collection subsysmax(Object var, Object condition=nothing, Object compval=nothing)
-
var: is the name of the variable in the sub system
-
condition: optional, is the name of a property in the sub system that decides, if this sub system is used for the accumulate process
-
compval: optional: is the value the condition variable is compared to
subsysmean
calculates the mean of all sub-system variables that share the given variable name
Collection subsysmean(Object var, Object condition=nothing, Object compval=nothing)
-
var: is the name of the variable in the sub system
-
condition: optional, is the name of a property in the sub system that decides, if this sub system is used for the accumulate process
-
compval: optional: is the value the condition variable is compared to
subsysmin
calculates the minimum of all sub-system variables that share the given variable name
Collection subsysmin(Object var, Object condition=nothing, Object compval=nothing)
-
var: is the name of the variable in the sub system
-
condition: optional, is the name of a property in the sub system that decides, if this sub system is used for the accumulate process
-
compval: optional: is the value the condition variable is compared to
subsysprod
builds the product of all variables of a given name, found in the sub systems of the current workbook
Collection subsysprod(Object var, Object condition=nothing, Object compval=nothing)
-
var: is the name of the variable in the sub system
-
condition: optional, is the name of a property in the sub system that decides, if this sub system is used for the accumulate process
-
compval: optional: is the value the condition variable is compared to
subsyssum
sums up the variables of a given name, found in the sub systems of the current workbook
Collection subsyssum(Object var, Object condition=nothing, Object compval=nothing)