MVVNWO returns variable number of the Xth value (where X is set by Offset) from a series of values.
MVVNWO(Offset, VarNum1, VarNum2, ...,VarNum99)
MVVNWO(Offset, "Where Clause")
Offset sets which date to return, (i.e., date of 1st Value, 2nd Value, etc...)
VarNum1, VarNum2,...,VarNum99 is a comma separated list of variables that sets which variable to search.
"Where clause" : Instead of providing a list of variables, you can use an SQL Where clause against the VarDesc table to get the list of variables. (i.e., "Units = 'mg/L'" would return all variables with Units set to mg/L. See examples.
All variables listed MUST have the same frequency (i.e., daily, hourly, ...).
Example functions and their results:
See Also: MVDWO