The Sheets tab is an editable spreadsheet view of all contents in a selected space including; channels, stations, connectors, Echo Expansion Bridges, spaces, walls, presets, palettes and sequences.
The Sheets tab is available in both the Design and Program/Simulate views, although the data displayed and editable in each view will vary. Only certain data can be edited from the Sheets tab, even with advanced user level settings.
To view the Sheets tab, first select the desired space from the Browser, or select a sub-space from within the Plan view, then switch to the Sheets tab. The data displayed in the Sheets tab directly represents the contents of the selected space (Primary, Sub-Space, Project, or Server Project).
Space Hierarchy in Sheets
The selected space is identified in a breadcrumb trail found on the header row of the Sheets tab.
This breadcrumb can be set to show the entire space hierarchy or not by enabling or disabling the feature in space preferences.
Selecting and Editing Data
Click anywhere in the row of data to select an object. Object selection tracks within the Browser and the Property Editor populates with the selected objects properties. An editable cell of data outlines in red (selection color is a preference setting) while a cell of data that is not editable will highlight with selection, but will not have an outline and will not be editable.
To edit object properties in the Sheets tab, such as the Name or Processor assignment, double-click in the cell. The data displayed, as well as the data that is editable, will differ depending on which view you are in, Design or Program / Simulate, and which parameter is selected.
For example, in Design view, the editable data for a Channel is the channel Num, Name, Fixed Load (if applicable), Light Source Load, and Net3 Circuit.
For that same channel in the Program / Simulate view, an additional editable property, Intensity, is editable.
Collapse or Expand Data Sections
From within the Sheets tab, either Design or Program / Simulate views, you can expand or collapse data sections by simply double-clicking inside the header row of the section.
For example, to collapse the Presets, Palettes, and Sequences data section, double-click anywhere in the header row.
Repeat to expand the section. Alternatively, you can right click on a section header and select either "Collapse" or "Expand" from the context menu.
From the Sheets tab, in either the Design or Program / Simulate view, you can show or hide sub-spaces from the "Spaces" section of the spreadsheet by toggling the [Show Sub-Spaces]button located on the top right corner of the Sheets page.
This feature is available only with a Primary Space selected.
With "Show Sub-Spaces" Enabled.
With "Show Sub-Spaces" Disabled.
Sorting Data in Sheets
From the Sheets tab, in either the Design or Program / Simulate view, you can sort the spreadsheet data by selecting up to two user defined sorting values, primary and secondary.
Right-click in any column header row such as, "Num" or "Name" for instance, then select "Set primary sort" from the context menu. The data in the spreadsheet will sort by that column data. You can add an additional level to the spreadsheet by setting a secondary sort to a different column.
To clear a sort, right-click on the header and select "Clear..." from the context menu.
Show or Hide User Data in Sheets
From the sheets tab, in either the Design or Program Simulate views, you can choose to show or hide User Data (object metadata in basic terms) in the spreadsheet. By default, User Data is hidden.
To display User Data, right click on any header row in the Sheets tab and select "Show User Data" from the context menu.
User Data fields will display for all object types in the Sheets tab, and will remain enabled even when toggling between the Design or Program / Simulate views. To hide the User Data columns from the Sheets view, right click on any header and select "Hide User Data" from the context menu.
Format, Show or Hide Column Data in Sheets
From the Sheets tab, either Design or Program / Simulate view, you can rearrange the displayed column data by moving them to a new order, changing the column width, and you may show or hide specific columns from the view.
Moving Columns
Each data type is separated into sections within the Sheets view. Within each section, column headers that are specific to that data type are displayed. You can rearrange the columns from their default order as desired.
Click a column header, drag and drop the column into the new location within that section.
The new column order will display in Sheets for both Design and Program / Simulate views.
Change Column Width
From the Sheets tab, either Design or Program / Simulate view, you can change the column width.
Show or Hide Column Data
Each data type is separated into sections within the Sheets view. Within each section, column headers that are specific to that data type are displayed. You can hide columns of data from the spreadsheet as needed by right clicking inside the header and deselecting the column header name to be hidden.
The hidden columns will be hidden in the Sheets tab for both the Design and Program / Simulate views. To show the hidden column data again, right click in the header and select the column name from the list in the context menu.
Show or Hide a Station in Simulation
The Sheets tab, similar to the Plan tab, also provides the ability to view a station in simulation while in the Program / Simulate view.
Simply click the [Show] button next to the station in the spreadsheet to display the station in simulation. Click a preset button on the station to activate that preset; all affected channels for that preset will update in the spreadsheet and in real time if you are also in "Live Control".
To hide the simulated station, click [Hide] or click the [x] button on the image to close the graphic.