Formulas Worksheet

Set up the Formulas worksheet with the columns described in the following table.

Table 13. Formulas Worksheet
Column Name Column Type Allowed Values
Channel Name Required String that does not contain the following characters:
  • ,
  • ;
  • \
  • @
  • .
Channel names must be unique.
Formula Type Required
  • Arithmetic
  • Boolean
Unit Optional String
Description Optional String
Formula Required Formula that references a Channel Name listed in the Channel Mapping worksheet between single quotation marks.

Note that the single quotation mark is a special character in Excel. To start the formula with a reference to a channel name, choose one of the following options:

  • Duplicate the single quotation mark: ''Channel 01' + 1
  • Specify the entire formula as a string, starting with the equal sign: ="'Channel 01' + 1"
Alarm Value Change Optional
  • Rises above value
  • Falls below value
  • Enters range
  • Leaves range
Critical Alarm Enabled Optional
  • TRUE
  • FALSE
Critical Value Optional Number
Critical Range Optional (<Min Value>; <Max Value>)

Range is expressed in parenthesis, with the minimum and maximum double values separated by a semicolon.
Critical Hysteresis Optional Number
Warning Alarm Enabled Optional
  • TRUE
  • FALSE
Warning Value Optional Number
Warning Range Optional (<Min Value>; <Max Value>)

Range is expressed in parenthesis, with the minimum and maximum double values separated by a semicolon.
Warning Hysteresis Optional Number