HELP
Click here to see this page in full context

Using Quick Views

You can customize the display of information for Input, Output, Memory, and CDS tables and save Chart or Pivot Tables  using Quick Views.Each project is associated with a project Quick View file, or .atz type file, that offers saved views accessible from the Quick Views window under the appropriate table type.

These saved views let you filter data, order columns, and set other visual appearance factors for data tables or charts so that they are readily available for repeated use within projects.

Additionally, a Default View may be created to alter the view of all data tables when they are opened across any project.

 

Table Quick Views

Follow the steps below to create a Quick View for a table:

  1. Open the desired table by double-clicking the table name or by right-clicking and selecting Organize Columns from the  Data TableToolbar.

 

  1. Modify the appearance of the table:

  1. To move a column, use the Organize Columns feature to change the order of all the columns to desired locations. You can also hold the Shift key and click on the border of the column, then drag the column to the desired location in the database table and release to place the column in selected position. 
  1. To resize a column width, click and hold the line to the right of the column, then drag to desired width and release.
  1. To resize a sub-header row height, click and hold the line above row #1 outside the data field, then drag down to desired height.

  1. To lock column panes when scrolling horizontally, select a cell/column in the table, then right-click and select Set Frozen Columns. This locks the selected cell and any to the left of it. These columns will be highlighted, indicating that they are locked and will thus remain at the left of the table when scrolling horizontally.  In the example below, the Hydro Year and Name columns are locked and will remain visible as the user scrolls through columns. To change the fixed columns, repeat the process

  1. To remove the locked columns, right-click and select Clear Frozen Columns.

 

  1. When the desired view is achieved, click the  button on the toolbar for the active table. Enter a name for the Quick View in the window shown below and select OK. The customized table view will be saved to the Quick View window under the appropriate table type (i.e., Input, Output, Memory, or CDS).  Multiple views of the same table can be saved as long as each is given a unique name.

  1. To view the customized version of the table, double-click on the Quick View name from the list.

 

Import Quick Views

Use this feature to import custom Quick Views from a different project Quick View file (.atz). Individual custom table views and charts can be created and saved in any project without having to recreate the custom view each time. See Import Quick Views in the Quick View Manager  for more information.

 

Default Quick Views

Default views are provided for input, output and memory tables when those tables are opened from the data grid window. These default views have been created for each table type for improved data layout.

Automatically Filtered Views - Some tables, when opened, will automatically show a Filtered View based on the areas, zones, or pools which are running in the study system. Filtered views are demarcated with Filter Active in the table's lower status bar. (The table must be checked 'In Study'.)  Automatic filters are overridden by the User Default view (below).

User Defaults - The user has the option of changing the default view for each table to a personalized default view. To change the default view, save a new Quick View with the name "UserDefault" (see above for directions on saving Grid Quick Views) or use the Save as Quick View dropdown feature. The default view can be changed at any time by saving again with the "UserDefault" name. Default Quick Views are not listed in the Quick View window but are automatically used anytime a table is opened. The original, factory default view can be restored at any time using the Restore Original Quick Views button on the Quick View Manager ribbon, but this will delete ALL UserDefault views.

NOTE: Be aware that the default view is the default for table types in the input database (e.g., the default is applied to ALL RMT tables, not the specific Alberta RMT table). Thus a default view created for a specific table will be used for any table of that type. Also note that if a filtered view is saved as a default Quick View, the Filter will remain the next time the table is opened (without using another Quick View) and not all line items will be visible. In this case, the filter can be removed by pressing the Clear Filter/Sort button on the toolbar.

Quick View Manager

The Quick View Manager provides flexible settings for project and UserDefault Quick Views. It is used to set up the automatic load Quick Views at the end of a simulation, including saving and emailing tables and charts. The Manager window is especially helpful for generating consistent default output Quick Views across time periods from those already in the Quick View file, even for the UserDefault views.

 Productivity Tools

 Quick Views

 Using Quick Views

For further assistance, please contact Aurora Support.

Copyright© 1997-2024 Energy Exemplar LLC. All rights reserved.