SUPPORTED VARIABLE CONFIGURATIONS FOR INTERFACE Q13207

The possible tag values for variables recieving data from this interface is as follows:

1 to 3 fields seperated by periods.

TableName.DataFieldName.DateFieldName

or

TableName.DataFieldName

or

DataFieldName

In WIMS, the Edit/View Variables screen allows the user to enter this data, see Figure 1 below.

Figure 1 - The variable entry screen from WIMS. The red arrow is pointing to the tag entry field referenced above.

For formatting the tag in an automated form see browser article here. 

•  This is a listing of all the statistics supported by this interface. This includes the following statistics for a specified time period:

AVERAGE	Take the average of the data poins
TOTAL	Take the sum total of all values
MINIMUM	Get the minimum value
MAXIMUM	Get the maximum value
FIRST	Get the first value (parameter or text parameter)
LAST	Get the last value (parameter or text parameter)
DIFF	Calculate the difference between the first and last values. If the first value is larger than the second then it will perform the following calculation: (10 ^ (Ceil(LOG(first_value) / LOG(10)))) - first_value + last_value Ceil will cause the value to round up
RANGE	Calculate the absolute value of the difference between the minimum and maximum values
INVENTORY	Running total of used volume. Only decreases in value are counted. Use the DEADBAND option in Hach WIMS variable setup to eliminate erroneous readings due to noise or vibrations.

  This is the value to multiply the result by when using parameter variable types. Commonly used to convert from one unit base to another. For example to convert gallons per minute (GPM) to gallons per day (GPD), set the scale factor to 1440 (1440 minutes per day).

•  All three fields must have numeric values or the word None (as shown). The Low Range and High Range will crop data from the source. For example to eliminate negative numbers from a particular tag, set the Low Range to 0 (zero) - this will get any values equal to or greater than 0 (zero). The Deadband is used for the statistic Inventory and will elliminate noise levels up to the value specified. For example, if you enter .5 next to Deadband, any value change of .5 or less, will be ignored.
  
  
  
• 
  • Start Time will set the beginning of the time slot for this variable.
  • Stop Time will set the ending time for the time slot.
  • Same Day as Start is only used by daily variables and it means the stop time is on the same day as the start time.
  • Day After Start is also only used by daily variables and it means the stop time is a day after the start time.
    
    
•  Allows you to filter data based on another tag. For example, flow rate while not in backwash, but during backwash we don't want flow rates uploaded to Hach WIMS.
  
  • Node:Tag.Field is the node, tag, and field associated with what you want to filter by, in our example it would be the backwash state.
  • Middle field is the filter operator. This can be <, >, =, <=, >=, <>, or CYCLESTO.