In the analysis table you can capture and view the model’s requirements analysis data. The analysis table can be found under the Analysis heading in the main navigation menu.
Good to know: you can also edit analysis data on the detail view of an object. See here for more info on that.
On the analysis table page, you can either select a predefined table definition (earlier created by either yourself or another project participant) or create a new table definition.
In this article, we’ll focus on how you can create a new table definition and explain the different options for selecting the data that you want to see in your table.
If you want to know more about saving and modifying predefined table definitions, click here.
TIP: are you planning to do a lot of work in the analysis table? Check out the article on our bulk action feature that allows you to modify large amounts of analysis data with just a few clicks.
Creating a new table definition
As said above, you must click on the button New to create a new table definition. By doing so, you will be presented with various selection possibilities for the requirements you wish to include in your table.
Good to know: if you don’t make any selections, you get to see all requirements. Depending on the number of requirements, this may slow down the performance of the table. So, it’s best to be specific about what you want to see.
You can use the following selections for the analysis table:
Tree(part)
Use this selection to select a particular tree (e.g. Spaces & locations tree or Systems & elements tree). In addition, you can use the Select tree part button to select a particular part of the selected tree (e.g. particular part of the building or a particular type of systems).
Object type
Trees can contain different types of objects (e.g. buildings, groups of spaces, spaces, outdoor spaces, …). Use this selection to focus on one particular type of object.
Label
Objects may be ‘tagged’ with labels. Use this selection if you only want to see objects with a particular label.
Instance of
This selection is only available when you have selected the Spaces & locations – project objects tree and when working with typicals. It allows you to select spaces or segments that are the instances of a particular typical object (e.g. meeting room or toilet space).
Requirement subject
With this selection you can refine your search results by choosing a specific requirement subject. For example, for the spaces tree, you can find requirement types like visual or acoustic comfort.
TIP: combine different selections to find exactly what you are looking for. For example: to get all requirements concerning room acoustics, make the following selections:
(1) Tree: spaces
(2) Object type: space
(3) Requirement subject: acoustic comfort
Viewing and saving your table definition
Once you have made your selections, you can click on the Show button to get to the table.
Good to know: the number that is presented in the Show button indicates the number of requirements that are part of your selection (in the example above, the selection contains 36 requirements).
If you expect that you will need to use this table set-up more than once, then save it by clicking on the Save table definition button.
More explanation about saving table definitions can be found here.
Table columns
Once you have clicked on Show, and are in the table itself, you will see quite a number of columns. These columns are grouped in the following way:
- Requirement (the subject of the requirements analysis)
- RFC (possible change requests concerning a requirement)
- Analysis (the analysis ‘tags’ that has been assigned to the requirements)
All three are discussed below.
Good to know: Use the icon in the top left of the table to select which columns you want to view.
Requirements
The first group of columns displays information about the requirements that have to be (or have been) analysed.
Object
This is the object to which a requirement belongs. Filtering in this column is very useful when looking for the requirements of a particular system or element (e.g. the HVAC system)
Requirement type
This column shows what type of requirement it concerns. Filtering in this column is very useful when you want to link analysis information to a particular type of standard property (e.g. floor heights) or a particular type of relation (e.g. adjacency relations).
Related object
This column shows objects that are related to the objects in the first column. For example power sockets that need to be placed in rooms, or the interface relations between different systems.
Value/quantity
This concerns the value or quantity of a requirement (e.g. 20 m2 or 4 items in the case of power sockets).
ID
The unique identifier of a requirement.
Deviation (only relevant when working with typicals)
An indication whether a requirement is deviating from a typical’s requirement or not. This column is useful when you want to focus on deviations in your verification plan.
RFC
RFC stands for request-for-change. This column can be used to view and create RFC’s.
Analysis
In this part of the table, the analysis data is shown. What you’ll see here, depends on how the analysis module has been set up for your model, or more precisely, which analysis properties have been defined in the settings menu. Each analysis property is presented as a column.
Useful actions, tips & tricks
Doing bulk actions
When you have to do a lot of repetitive data edits, you can best use our bulk edit feature. Read more here about how this exactly works.
Filtering
A filter icon is located at the top of each column in the analysis table. With these filters you can filter on both requirements and analysis data.
Sorting
The sorting icons are also located on top of each column. Click on the arrow pointing down to sort in ascending order, click on the arrow pointing up to sort in descending order.
Increasing column width
For columns that have a lot of info in them (e.g. text values), it can be useful to increase the column width. This can be done in the column header by grabbing and moving the column’s border.
Increasing the display range
The display range concerns the number of rows that are being displayed on a page. This setting is located at the bottom of the page.You can choose between 10, 25, 50 or 100 rows per page.
Please note: Increasing the display range might make the table a bit slower, since more information will be shown on each page.
Dragging values
In the table, you are able to ‘drag’ values over multiple cells. To do this you have to:
- Select the cell with the value that you want to use;
- Click on the small blue corner of the cell;
- Hold on to your mouse button;
- And drag your mouse up/down over the cells of which you want them to have the same value.
Export the table to excel
For the purpose of communication, it is sometimes easy to have data in Excel. To get an Excel export of your table, just click on the icon, right next to the overview’s name.
Depending on the size of the overview, it may takes some time to download the file. You can find the file in the downloads folder of your computer.