Functions and Formulas

Sub Project

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

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

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

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

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

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)

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

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