Details about the Room Data Sheet Tree and Room Data Sheet Views
Information about the room data sheet tree and room data sheet views in the Room Data Sheet module.
You are here
Room Data Sheet Tree
The room data sheet tree is located in the left-hand area Building and its structure can be configured individually. This makes it possible to compile different structure configurations for different use cases. For example, the rooms of a building can be grouped in the tree according to zones or room types. The elements of these structure levels are the structural elements of the individual configurations, which can be compiled in any combination and depth with regard to the number of levels. Structure configurations are created in the Structure Configurations dialog.
Structure Configuration: Opens the Structure Configurations dialog, where you can create, edit, and delete structure configurations.
The created structure configurations are then displayed in the drop-down list of the area for selection. After selecting a configuration, the display of the room data sheet tree is changed accordingly. Predefined structure configurations are available, which you can use as well as edit and extend as required.
By selecting the individual structural elements in the room data sheet tree, the contents in the room data sheet views in the right-hand area are controlled. The higher-level structural elements (e.g., levels such as ventilation zone or room type) display the rooms associated with the element in a tabular overview with the parameter values of the currently selected room data sheet view. All parameter values for the rooms are displayed on the room levels, taking into account the selected room data sheet view and thus the underlying property set.
Update: Updates the room data sheet tree, e.g. after changes to parameter values in the room data sheet views. Use this button, for example, if the structure configuration is set to By Room Type and the room types have been adjusted.
Room Data Sheet Views
The individual room data sheet views are located in the right-hand area and are displayed by selecting their names above the table (e.g., Structure Data or Sanitary Data). The rows of the table view display the rooms with the associated structure levels, i.e. the current structure configuration of the room data sheet tree. Which rooms and structure levels are displayed depends on the selected structure element in the room data sheet tree. The columns of the table display the parameters of the room data sheet view and their values. Which parameters are displayed is defined in the property sets of the room data sheet views.
Property sets are thematically organized groups of parameters that can be customized and expanded individually. You can create as many additional property sets as you like, allowing you to create user-defined room data sheet views that are tailored precisely to the needs of your project. Property sets are edited and created in the Property Sets dialog, which you can open by clicking the button 
Property Sets button in the toolbar.
Columns in Room Data Sheet Views:
The parameters of the property sets are displayed in the columns of the table starting with column four. The first three columns are identical in all room data sheet views. The first column, Et, allows you to edit selected rooms together. Tick the rows of the rooms that you want to edit together and then change the desired parameters for one of the rooms. Clicking on the column header Et, for example, selects or de-selects all rows of rooms. The following two columns always display the room and structure level numbers and the room and structure level names. In addition, you will find the button 
at the top left of the tables for all room views.
By clicking 
you have the possibility to copy the contents of the table with or without column heading and paste it into Excel.
The columns of the parameters are labeled with the respective parameter names. Depending on the parameter, additional information about the respective parameter is displayed in the tooltip. Clicking on the fields of the column headers opens the following context menu:
Sort Ascending, Sort Descending: Sorts the column in ascending or descending order. The sorting is then indicated by a corresponding symbol behind the parameter name.
Do not sort: Resets sorting.
Define Restriction: Opens the Restrictions dialog, where you can define and customize various types of restrictions and checks for the parameter values.
Define Calculation Formula: Opens the Formula Editor dialog, where you can easily define and customize a calculation formula for the parameter.
Aggregation: Allows you to display totals and averages.
Change Column Name: Opens the dialog for customizing the parameter name. Alternatively, you can also change parameter names in the Properties Sets dialog.
The fields in the column headers are marked with symbols that provide further information about the parameters.
| Symbol | Meaning |
|---|---|
 | This is a locked parameter whose values cannot be edited. Non-editable values include calculation results and values derived from user-defined calculation formulas. |
 | This is a user-defined parameter. User-defined parameters generally have no direct influence on calculations unless they have been entered by the user in calculations (e.g., in cooling load calculations or calculations for pipe routing concepts) or are used for further calculations of parameters that have a direct influence on calculations. |
 | This is a parameter whose values originate from a user-defined calculation formula. |
 | Restrictions or checks are defined for the values of the parameter. |
 | Average is activated as the Aggregation for the parameter. The average values of the parameter values of the associated rooms are displayed in the rows of the structure levels. The setting for the aggregation is controlled via the corresponding menu item in the context menu of the columns. |
 | Sum is activated as the Aggregation for the parameter. The sums of the parameter values of the associated rooms are displayed in the rows of the structure levels. The setting for the aggregation is controlled via the corresponding menu item in the context menu of the columns. |
 ,  etc. | Displays the unit of the parameter. |
If necessary, you can show and hide columns using the 
button at the top right of the table.
Rows in the Room Data Sheet Views:
The first row in all room data sheet views is a filter row that allows you to filter the individual columns. Various filtering options are available. You can filter by manual entry. The operators <, <=, >, >=, and = are also supported. The use of regular expressions (RegEx) is also supported.
You can also use regular expressions to search for rooms that do not meet the specified search criteria. You can also search for several search terms at the same time.
Furthermore, you can click on 
to open a menu where you can filter by parameter values. You can also combine the filter options and, for example, first filter by Office and then use the menu to display only the individual offices.
The following rows show the individual rooms with the corresponding structural elements of the structure configuration set in the room data sheet tree.
The rows of the structural elements display either the common values of the parameters of all associated rooms or the entry <varies> if the values of the parameter differ between rooms. In addition, you can use the aggregation options in the context menu of the columns to display the sums or averages of all associated rooms. Entries in the fields of the structural elements are transferred to all associated rooms.
The individual parameter values are displayed in the rows of the rooms. Cells highlighted in red indicate that the values do not comply with the restrictions defined for the parameter. Restrictions are defined in the Restrictions dialog, which you can open via the corresponding entry in the context menu of the columns.