1. Home
  2. Overviews and diagrams
  3. Cross tables – requirements

Cross tables – requirements

In the main menu, located under Overviews, you can find the cross tables for requirements. These are tabular, Excel-like overviews of the requirements in BriefBuilder.

Located under ‘overviews’, you will find access to the cross tables

These cross tables give you an overall overview of the requirements in the model and enable you to edit the requirements in an Excel-like way (e.g. using ‘cell dragging’).

Take a look at the video below, or read the article below. to learn how it works.

Select what you want to see in your table

When clicking on the cross table menu item, you first get to see a selection window. This selection window provides you with the possibility to what you want to see on the rows and the columns of your table.

For the table’s rows, you can select a tree or a combination of trees.

For the table’s columns, you can select standard properties and/or relations with other objects.

For the table’s rows

For the rows, you have to select the tree(part) for which you wish to see the requirements. This selection is the first one on the selection page.

Select which tree you want to see

Optionally, you can use the Select tree part button to limit your selection to a specific object or group of objects.

Use the Select tree part button to limit your selection

Please note that some tables may be heavy on data and therefore slow to lead. Selecting only a particular part of a tree will certainly help!

Also note that if you are using object labels and typicals in your model, you can use these as filters to further limit your selection.

Use Label filter (if your tree has labels) and ‘Instance of ‘(if you are working with Typicals as additional filters for your table

For the table’s columns

The next step is to decide what type of requirements you wish to see as columns: standard properties and/or relations to other objects.

Standard properties

Under the header columns, you have the possibility to select what standard properties you want to see in your cross table.

For example, if you have chosen the Spaces & locations tree, you perhaps want to select the standard property table Acoustic comfort here to see which acoustics requirements apply to the selected spaces.

Select what you want to see from the standard property tables available for the tree you picked

TIP: You can select multiple standard property tables at the same time.

This is the selection that you have to use if you want to see the relations between the objects in the chosen tree and the objects in another tree.

For example, if you have chosen Spaces & locations tree for the rows, you may want to select the Systems & elements for the columns to see which elements are placed in which spaces.

Select which tree you want to see the relations of with the tree you choose in Step 1

Advanced options: a combined tree

Under advanced options, you will find the possibility to combine two different trees for the rows in your table.

That may sounds complex, but it can be very practical. For example, if you have chosen Spaces & locations for the rows, you may want to add the combined tree(part) for User equipment. This allows you to see standard properties and/or relations of both trees in one overview.

See example below.

Here, we can see what user equipment (chosen as the combined tree(part) for this table) is placed in a room (chosen as the combined tree), as well as how many power outlets (chosen as the related objects) are placed in that same room

To combine two trees, do the following:

Step 1: Activate the advanced options

Activate the advanced options in the upper right corner of the selection window.

In the

Step 2: Select the tree that would want to combine

When you have clicked on advanced options, you will get an extra option under the header rows, called combined tree. That is where you can make your selection.

Step 3 : Select the standard properties for the combined tree (optional)

When you select a tree for the combined tree(part), you will also get to see an extra option under the header columns for the selection of the possible standard properties for the objects in that tree.

You can add those too, if that is what you want to have in your table.

Note: the requirements for the combined tree will only be visible, not editable. Their prime purpose is to provide useful context for the rest of your cross table.

Step 4: Click on Show

Happy with your selections? Click on Show to get the table!

TIP: If you prefer to flip the x- and y-axis of your cross table, then click on the button Swap rows and columns in the selection window.

Table legenda

The cross table that you get to see will show whether there is a relation or a property value present. You will notice that these cells can have different colors. The ‘colour coding’ is as such:

  • Grey: cells where a relation or property value is not possible/not allowed
  • White: cells that are empty, but where you can enter a relation or a property value
  • Blue: cells where there is a relation or a property value present
  • Green: cells where there is a relation or property value present inherited specifically from a typical object

A good example of grey cells as seen in the image above is the GFA/UFA factor (third column from the left). This factor can only be defined at the level of a building or group of spaces. So, for the spaces, all these cells that are grey.

You can also see green cells in the image, indicating that the open workstation has inherited two values (usable floor area and security zone) from the typical object it is connected to.

Editing in the table

Cells can be edited in the following ways:

  • Typing in a value (quantity/distance in case of relations)
  • Deleting a value (quantity/distance in case of relations)
  • Double clicking on a cell (relations only: it creates a relation, without a quantity/distance)
  • Clicking on your delete button when having a cell selected

TIP: for quick navigation in the table, click on ENTER in one cell and you will move to the cell below. When clicking on TAB, you move to the cell on the right.

If you are using Advanced options to add a Combined tree(part) to the cross table, please note that you cannot edit any data from the combined tree(part). It is only viewable. The names of the objects are greyed out to indicate that they cannot be edited.

Copying data to multiple cells

You might want to copy particular requirements (properties/relations) to multiple cells. You may, for example, want to apply the same indoor climate requirements to all the spaces in your selection.

You can do that in two ways:

(1) You can “drag” the value of a cell:

  • Select the cell (or multiple cells)
  • Move your cursor to the little blue corner (lower corner on the right side)
  • Click on that and hold on to your mouse button
  • Drag the value to the cells where you want to have the same value
Click on little blue rectangle in the lower right corner, and hold on to your mouse button, to ‘drag’ a value over other fields

(2) You can use the well-known CTRL-C / CTRL-V short cut.

  • Select the cell (or multiple cells)
  • Click on your CTRL button and the letter C (simultaneously)
  • Select the cell (or multiple cells) where you want to have the same value
  • Click on your CTRL button and the letter V (simultaneously)

TIP: you can also use the CTRL-C and CTRL-V shortcuts when you want to copy-paste data from a Microsoft Excel sheet into BriefBuilder.

Download as Excel

You can download the table in Excel format by clicking on the icon, right next to the table’s name.

Depending on the size of the overview, it may take some time to download the file. You can find the file in the Downloads folder of your computer.

Some examples

See below for some examples of commonly used cross tabels and how to make them.

Indoor climate table

In building projects, indoor climate experts usually prefer to see their requirements in a tabular way. To create such overviews, do the following:

  • Select Spaces & locations for Tree(part)
  • Select the relevant property table (e.g., acoustics) for Standard properties
  • Click on Show

Placement table

In both infrastructure and building projects, it will be useful to see where technical systems/elements are placed spatially. To create an overview of this, do the following:

  • Select Spaces & locations for Tree(part)
  • Select Systems & elements for Related objects
  • Click on Show

Security zoning table + cameras

In a building project, you may want to check your security zoning requirements against the requirements for the placement of cameras. To create an overview of this, do the following:

  • Select Spaces & locations for Tree(part)
  • Select the relevant property table (the one with Security zoning) for Standard properties
  • Select Systems & elements as for Related objects.
  • Use the Select tree part button to select the object Security camera
  • Click on Show

Adjacency matrix

How should a project’s different spaces, or buildings, or locations be positioned in relation to one another? You can make a diagram of this (see here), but also a matrix. For this, do the following:

  • Select Spaces & locations for Tree(part)
  • Also select Spaces & locations for Related objects.
  • Click on Show

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!
CONTACT SUPPORT