Navigation:  Setup >   EQUATIONS AND TABLES

 

 

Defining new sensors by building equations and adding table lookups.

Clicking on the dotted button in the Defined Grid, column 3, labeled "Equation/Table", opens the tables and equation selection options.  The form must be in the edit mode first.  Also see Build Define Sensors for a list of functions available.

The equation editor and the table maker is available from the selection options displayed below.

 

 

 

The equation editor is available by selecting Equation and then click the Build Equation

Tables lookup value can be assigned from this form.

Select a table name in the list and click the Build Table Button.

 

 

Click the edit button from the property box to show the equation builder form.

Equations, functions, IIF( ), Capture, SUM, MAX and other equations for specially defined sensors.

 

 

 

The equation editor allows you to build a special function to display a calculated value.  You can use data from other sensors in the system by selecting a Sensor Name in the analog dropdown box and then clicking on the Use Sensor Button.   You can also type in the sensor name with brackets around the sensor name.

 

The equation does not have to have any sensor value in the equation.  You can type in the equation you require using existing sensors or other defined sensors.

 

Example of some equations:

 

1.  CAPTURE(NOW,[Rcv01.coil]=1)       captures the datetime when Rcv01.coil becomes 1.  It must go back to 0 before it will capture again.

 

2.  IIF(([Sensor1]=1 AND [Sensor2]=1),1,0)        if Sensor1=1 and Sensor2=1 then value=1 else value=0.

 

 

Press the test button to see the results of your equation.  When you are done testing your equation, press the Save & Close button.  The new equation will be written to the equation box on the selector form.   Click the OK Button on the selector form with the equation checked.   Your new equation will be entered into the defined form.

 

If you click the exit button to close the form, no changes from the equation builder will be saved.

 

 

Note:  Defined sensors are evaluated from top to bottom in the defined grid.  If you reference a defined sensor in another defined location, be sure the new sensor references a sensor above it.

 

 

Defining a table assigned to a sensor.

Table editor: Assign Table Name, and select a sensor for the X value.  The Y value is the calculated output.

 

Select the sensor for the X value lookup.  The new defined sensor will be updated when this sensor changes value.

 

 

Table controls: Show, Add, Insert, and Delete

 

 

The show button calculates the result table and shows the data in tenths.  You can add rows, insert rows or delete rows as needed.  The table ends at the last row.

 

 

Table show form: Values are calculated for according to the X and Y set points.

 

 

Check the values in the table to see if they are correct.  Adjust your X and Y values to change the results.  X values that are greater than the last value in the table will use the last 2 data points in the table to calculate the new value.  X values lower than the first value return 0 as a result.