YSI BODAnalyst User Manual
Page 43
Reports
Section 8
YSI Incorporated
BOD Analyst for Windows Software
39
Offset The offset from the start date of the report. For example, if the start date is 1/1/99
and the offset is 1, the value from 1/1/99 will be returned. If the offset is 2, the value
from 1/2/99 will be returned and so forth.
Future OPTIONAL, Not Used.
VARWO(VarNum, Offset, future, future, future, future, future)
Returns the daily value for a sample when data is found. See Print Data only when it
occurs example in Locating Data on the Report later in this section. This formula is
automatically built when Locate/Sample is used.
VarNum
The sample number.
Offset The offset from the start date of the report. For example, if the start date is 1/1/99
and the offset is 1, the value from 1/1/99 will be returned. If the offset is 2, the value
from 1/2/99 will be returned and so forth.
Future
OPTIONAL. Not Used.
DATE(Offset, Format, Interval)
Returns a date. The easy way to place this function is to use Locate/Date.
Offset
Sets the number of intervals from the start date of the report
Format
Format for the date. Common formats:
mm/dd/yy
01/01/99
mmm
Jan
mmm yyyy
Jan 1999
Interval
The interval of time used with the Offset to calculate the date to print.
Values are:
1
Days
-1
Print the end date of the report
3
Months
4
Current Date
DWO(VarNum, Offset, FormatStr)
Returns a date only when data occurs for the sample specified by VarNum.
VarNum The sample to search to decide what day to print for.
Offset Sets the number of days from the start date of the report
FormatStr Format for the date. Common formats:
mm/dd/yy
01/01/99
mmm Jan
mmm yyyy
Jan 1999