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 ChannelsA stream of data points whose source is an instruemnt in the field or an imported data file. Essentially, any data that enters FlowWorks that has not been modified by the FlowWorks system (such as any data in Calculated 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.
Important: 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 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 functions available for use.
Note: You can save this file to your PC. Simply right-click the image and select Save Image As.
About Circle Formula
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).
Please see article, "Formula Example: Computing Flow with the Circle Calculation" for a use-case example.
About Conditional Statements and Comparisons
Conditonal statements (IF A>B THEN 0 ELSE 1) are 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).