MVMIN compares the values of a specified set of variables each day and returns the minimum value.

SYNTAX:

MVMIN(Cj, Cn:Cw, Cy, ...)
where :
Cx is a conditional variable x

NOTES:

Each variable must be specified as a Conditional Variable (use "C" instead of "V").

The variables may be referenced two different ways;  single variables separated by commas (ie C2,C107,C45) or a range specified by a beginning variable, a colon, and an ending variable (i.e. C14:C22 will include all variables whose numbers fall between Variable 14 and Variable 22).  These two methods can be combined.

When specifying a range of variables,  there can be gaps in the series of existing variables.  For instance, if the specified range is C11:C17 and variable 14 does not exist, the function will calculate the remaining variables.

This function only works properly when all variables are the same frequency, i.e. all daily, all hourly, etc...  

This function will handle up to 199 variables.

EXAMPLES:

V127 = MVMIN(C70,C71,C1001:C1011)

Note: The range C1001:C1011 will specify that all variables from 1001 to 1011 will be included in the analysis, in the example shown below only variables 1001, 1002,1004, and 1011 are shown because variables 1003, 1005, 1006 do not exist.

Variable 127 will contain the minimum daily value of each of the input variables:

Example 2: Using Daily Detail (4 Hour) variables

V11379 = MVMIN(C11377,C11378)

where V11379,V11377, and V11378 are all 4-hour daily detail variables.  Note, to calculate values must be in the same data slot, not necessarily the same time.