The Formula feature in FACE allows you to define an equation using basic math, trigonometric formulas, a Circle equation, and IF / ELSE statements; and apply the equation to each individual row of data from the source channel. All data derived from Formulas can be used in FlowWorks in the same ways as raw data channels - such as, calculated (virtual) data can be graphed and exported in a data table. This is achieved by way of first creating a Calculated Channel, and then appending a FACE formula.
Calculated Channels can also be configured with a predefined Function. FACE offers a host of commonly used functions for data analysis - choosing one of the many available functions allows for quick calculation setup, without having to continually go through the hassle of equation setup. To learn more about FACE functions, click here.
Quick Reference Guide: Formula
The PDF file below provides a quick reference guide for FACE's basic capabilities using formula, as well as descriptions of the many available mathematical functions.
About Circle Calculation
The circle function can be used to calculate flow when you know the diameter of a pipe and the depth of the material in that pipe. The calculation will return the area cross-section of the pipe occupied by the material. The syntax of this formula is: Circle(Depth, Diameter).
See article Formula Example: Computing Flow with the Circle Calculation.
About Conditional Statements and Comparisons
Conditional statement (IF A>B THEN 0 ELSE 1) is written as: IF (A>B,0,1) where 0 and 1 may be a variable, constant, or equation. You may substitute any variable, constant or equation with the word NULL - for example: IF(A>B,0,null).
Valid comparisons include the following:
About Lookup Tables
A lookup table is normally a spreadsheet that acts as a 'master list' for something (whether it be a number, text, a logical value, etc.). In FACE, it is used to look up a value, and then that value is applied to your calculation formula (where specified), for an output value (which is compiled into the Calculated Channel).
You choose a lookup table just before configuring a calculation in FACE (only applies with Formula). To use Lookup, choose the desired lookup table from the dropdown list and reference in the formula with an input Channel, such as: LOOKUP (A).