Locate User Formula is designed to ease the creation of complex formulas within spread reports.

FIELDS:

Formula:  The formula to be located.  Use "?" for the offset field of the formulas to increment (from 1 to the Num To Place setting).  Use the function browser to insert a function into the formula.  Simply click on the function, choose a variable if required and the function will be inserted into the formula.  See examples.

Num to Place: Sets the number of formulas to place on the report.

EXAMPLES:

Locate 31 values calculating the load based on Monthly Average TSS and the daily flow (uses the V and GAVG functions):