SCT custom summary row cells: Hiding individual cells
Bug Number: n/a
Release notes (y/n): Yes
For Release Nums: 6.7

The full brief document describing this new feature is available here. An adapted expert, without images, is provided below.

• SCT Custom Summary Row Enhancement: Hiding Individual Cells / RiverWare 6.7
  Word: R:\doc\sct\2014\CustAggSumRows\CustAggSumRows-CellHiding-Jan2015.docx
  PDF: R:\doc\sct\2014\CustAggSumRows\CustAggSumRows-CellHiding-Jan2015-12.pdf
  HTML: http://cadswes2.colorado.edu/~philw/2015/SCT/CustSumRows/HideCells/SctCustSumRowCellHiding.html
  Images: http://cadswes2.colorado.edu/~philw/2015/SCT/CustSumRows/HideCells/DocImages2/
  

---

The new SCT Custom Time-Aggregation Summary Rows feature was developed two months ago, in October and November 2014, and was delivered in RiverWare 6.6 (January 2015). That feature is described in the following document:

• SCT: Custom Time-Aggregation Summary Rows / RiverWare 6.6 [5 pp].
  Word: R:\doc\sct\2014\CustAggSumRows\CustAggSumRows-Nov2014.docx

This document describes a simple enhancement to SCT Custom Time-Aggregation Summary Rows, allowing the user to hide the content of individual summary row cells.

• Note: This is a requirement for the SCT re-implementation of TVA's "Preschedule" Excel application. In an hourly model, a daily total (a custom summary row) should not be shown for the "Marginal (energy-) Cost" column.

-------------------------------
Hiding Custom Summary Row Cells
-------------------------------

The content of any particular custom summary cell can be hidden by right-clicking in the cell and selecting "Hide Aggregation Value" from the context menu. A cell value hidden in this way can be reshown by selecting the "Show Aggregation Value" context menu operation. (All such hidden cell values can be reshown with an operation in the associated configuration dialog box. This is described later in this document).

This cell-content hiding is effected on the custom summary row specification / SCT column slot basis. That is, cell-content visibility applies to the cell in each time aggregation shown in the SCT, and to all SCT columns in the SCT which are showing that slot (within the particular custom summary row). In an SCT having multiple series slot sheets, if a particular slot appears on each sheet, hiding a custom summary row cell in an SCT column for that slot will be applied to the SCT column for that slot in all series slot sheets.

----------------------------
Configuration Dialog Support
----------------------------

The SCT Custom Aggregation Summary Row configuration dialog box has two new provisions to support this new cell-content hiding feature. As shown below, this dialog is accessible from the SCT's "Aggregation" menu by clicking the "Custom Summary Rows ..." menu item.

1. A new "Hidden" column shows the number of slots (corresponding to SCT columns) which are currently hidden in the particular custom summary row (which is repeated in the SCT for each time aggregation).
2. A "Clear Value Hiding" button causes all hidden cells to be re-shown. The user must also click the "OK" or "Apply" button to have this change applied to the SCT series data table.

A tooltip on non-zero values in the "Hidden" column shows the names of the slots (corresponding to SCT columns) which are currently hidden in the particular custom aggregation summary row (in every timestep aggregation).

------------------------
Technical: Serialization
------------------------

The complete names of the slots to be hidden in the various SCT custom aggregation summary rows are internally saved in a QStringList added to the SctAggCustomSumItemConfig class (for each custom summary row) and saved in the SCT configuration file in a format parsed with Flex/Bison.

The SCT file excerpt below illustrates a variation of the SCT custom aggregation summary row configuration shown in this document (but with five cells hidden).

 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_DIV" "#aaaa00" "" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_SUM" "#eaceef" "My Sum" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_MAX" "" "My Max" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_MIN" "" "My Min" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_DIFF" "" "My Diff" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_AVE" "#defffb" "My Ave" "" "" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_SLOT_REF" "#ffffe6" "MEL" "Con" "SpecialOpEnergyMax" False
 AGG_CUST_SUM_ITEM_6 "SCT_AGG_CUST_SUM_DIV" "#ffaa7f" "" "" "" False
 
 AGG_CUST_SUM_HIDE_SLOT 1 "My Sum" "System.Marginal Cost"
 AGG_CUST_SUM_HIDE_SLOT 1 "My Sum" "System.System Tot"
 AGG_CUST_SUM_HIDE_SLOT 2 "My Max" "System.Marginal Cost"
 AGG_CUST_SUM_HIDE_SLOT 3 "My Min" "System.Marginal Cost"
 AGG_CUST_SUM_HIDE_SLOT 4 "My Diff" "System.Marginal Cost"

... note that the item's label text (e.g. "My Sum") isn't actually needed in the serialization; it's redundant with the preceding index number and is not used when loading. It's just there for debug diagnostics, and such.

--- (end) ---