Proposal: SCT Series Value Threshold Exceedance Cell Color Alerts
Funding: USACE-SWD (Task 3.e) -- SEE NEXT REVISION
Phil Weinstein, CADSWES, 12-14-2015

Task Description

"In the SCT, allow for predefined coloring of cells or fonts, when the value is over or under a certain threshold."

Background

From the users' point of view, this enhancement is an extension to the RiverWare 6.8 enhancement to support custom color overrides for individual cells in an SCT. (This was developed in September 2015, three months ago). That enhancement is described in this document:

SCT Custom Slot/Timestep Cell Colors / RiverWare 6.8
R:\doc\sct\2015\SctCustomColors-2015-Sep.docx
http://cadswes2.colorado.edu/~philw/2015/SCT/SctCustomFlags/SctCustomColors-2015-Sep-Phil-9-28.pdf

The differences between that support and this new exceedance alert capability are as follows:

1. The criteria for a cell having the exceedance colors are dynamic, based on the value associated with the cell (series slot timestep) and threshold values associated with the slot within the SCT.
2. Foreground (text) and background colors associated with the exceedance condition are optional. For example, it is possible to specify only a foreground (text) color, and not a background color. In that case, the cell's background color would be that corresponding to the timestep flag associated with the cell's slot and timestep.

Proposal

Two types of configuration data are used to support SCT series value threshold exceedance cell color alerts. Both of these are associated with an SCT's configuration, so could be different for each SCT.

1. Optionally specified upper and lower threshold values for each series slot in an SCT.
2. Optionally specified threshold exceedance alert colors:
   1. "Under" text (foreground) color
   2. "Under" background color
   3. "Over" text (foreground) color
   4. "Over" background color

(1) SCT Series Slot Threshold Values

The upper and lower threshold values for each series slot will be specified in new columns shown within the SCT's Edit Series Slot List tab. (The following screenshot shows this SCT tab before the addition of these columns).

Three columns will be added:

• Lower Alert Threshold
• Upper Alert Threshold
• Scale and Units

The cells in the first two columns have editable numeric values, and can be cleared.

(2) Threshold Exceedance Alert Colors

The following panel will be added to the "Flags" (Flag Color and Toolbar Button Settings) tab of the SCT configuration dialog (shown below). The square buttons bring up the color chooser dialog. These are enabled (and relevant) only when the accompanying checkbox is checked.

--- (end) ---