beautypg.com

YSI BODAnalyst User Manual

Page 43

background image

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