Statistics Worksheet

Set up the Statistics worksheet with the columns described in the following table. Use Statistics channels to apply a filter or compute the mean or RMS of an existing channel.

Table 14. Statistics Worksheet
Column Name Column Type Allowed Values
Channel Name Required String that does not contain the following characters:
  • ,
  • ;
  • \
  • @
  • .
Channel names must be unique.
Statistics Type Required
  • Filter
  • Mean
  • RMS
Data Source Required Must be the name of a channel listed in the Channel Mapping spreadsheet.
Description Optional String
Filter Type Optional
  • Highpass
  • Lowpass
Cutoff Optional Double

Use when the value of column Statistics Type is Filter.
Block Size Optional Double, expressed in seconds

Use when the value of column Statistics Type is Mean or RMS.
Alarm Value Change Optional
  • Rises above value
  • Falls below value
  • Enters range
  • Leaves range
Critical Alarm Enabled Optional
  • TRUE
  • FALSE
Critical Value Optional Double
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