Articles, Blog

Export BIM data to tables and Excel

February 14, 2020

ARES Commander allows data
extraction from BIM Entities. In this example, we have a building
with 13 floors of identical houses and we are going to focus on one of them. To obtain a budget of all the carpentry that affects the 4 houses
that make up the plant. For that, after calculating
the cost for a level, we will multiply it by 13 since they are the number
of housing levels that this building contains. Here we are observing one of the
standard levels with 4 homes. The carpentry manufacturer
has to pass a budget to the builder of the interior and exterior
carpentry of the homes of this building. Just by knowing what the price
of the carpentry by level is, then it will be multiplied by the 13 floors
of the houses to know the total. When opening the BIM Elements drop-down we can select categories of elements or select elements independently. Even several of them at once. The truth is that if we have an item selected we can “turn it off” or “show it”. We can also turn off all the families
that are identical in the project. Even those categories that have more than one variant, can be turned off all at once. In turn, having the category selected, you can easily distinguish all of its elements in the drawing. ARES Commander allows you to extract data from BIM elements in much the same way that you can extract data from
entities in a DWG drawing, which we have explained in another video. In this example, we will extract
all the data related to carpentry. For that, we will create a filter in which we indicate the project, in this case, there is only one. In “CRITERIA” we will choose “CATEGORY” and among the categories, we will look for everything that is related to doors and windows. We select them and click add. We save this selection with
the name “Carpentry”. Now we are going to extract data. In the dialog, we choose
“CREATE A NEW DATA EXTRACTION”. We name this extension file DET. We can include the whole drawing or select only the elements
that we had previously filtered. Press NEXT, and then again NEXT. We deselect the categories
that do not interest us. leaving only the BIM COMMON category. In this case, we only need
the “CATEGORY” property. Press NEXT. Notice that all the elements combined by type appear. If we deselect this option, the list with
all the elements are shown individually. Thanks to this box, entities of the same
type are combined, adding the amount in the “COUNT” column. Press NEXT. Now we can convert
the data into a table that we can insert into
the drawing, or export the data into a CSV or TXT format file and then import it into Excel, for example. The truth is that we can do
both at the same time. After giving a name to the data table, press SAVE and NEXT. In this box we specify the Table Style, if we haven’t it created. But we can choose the Standard
style offered by ARES Commander. In any place of the drawing, we can click to insert our table. From the top view we can see our table. Even move it to a more suitable position. We click on a cell in the table, and after pressing the right button, we choose to ‘Insert a Column Right.’ We can also do it from the Ribbon. Now we can add a title
that says “Price for Unit”. We add 2 more columns to the right. We write the unit prices of
each type of carpentry. In this column, we make a formula
that allows multiplying the individual value of each carpentry by the amount existing in the level. In the right column, we create a new formula that multiplies the total cost per level of each type of carpentry multiplied by 13 which is the number
of levels of this building. We repeat these operations
for the rest of the cells. For that, we can select a cell with the formula and after pressing copy, we can go to the rest of the
cells and paste them. And as if it were Excel, the formula will be updated to the new position of related
cells intelligently. In the next column, we copy and paste
the formula of the first cell following the above criteria. Now we are going to add
a row below the table. For that, after selecting a cell, we press the right button and
choose ‘Insert row below’. Now we are going to create a sum of all subtotals. We write the title “TOTAL”, while in the last cell we will create the summation. To do this, we press the right button and choose FORMULA
and the SUM option. Now we make a selection of the cells
that will be involved in this sum. Thus, ARES Commander
writes the formula for us. After accepting,
we see the result. Remember that we have grips that will allow us to adjust
the width of the columns. And all directly in ARES Commander. By the way, the data in
this the table is fully editable. For example to modify the
description of BIM objects. That in this case, they
appear in Spanish because in Spanish there were the
parameters of the families used in the original project. We may be interested in translating
it into another language. Something we can do directly in ARES Commander, editing the corresponding cell. Or also within a table in Excel. Now, in EXCEL. We can import the CSV extension file that we had previously created. To finish creating a table with the data obtained
from the BIM elements in ARES Commander. In Excel, as we did in ARES Commander we can create new columns, write unit prices, and then perform
operations with them. Thus we will obtain the costs by
level of each type of carpentry, as well as the total cost of these
typologies throughout the building. Closing the table with the
total cost of all carpentry. Whether we work with EXCEL or prefer to use the tables within ARES Commander we will get the same result, and we will achieve it
with the same ease. In addition, remember also that we can
make a selection of cells in Excel, then press Control + C key to Copy, and then in the drawing of ARES Commander paste it. Highlighting that the table pasted from Excel can be edited directly in ARES Commander because it is linked between both programs. Although the disadvantage is that to share
this project it is also necessary to send the Excel table to maintain its link. Unless we use ARES Commander tables directly which would make it independent. To learn more about Tables and how to work with the BIM elements of ARES Commander, visit the extensive help
offered by the software. In addition to viewing other videos,
we have on these topics.

No Comments

Leave a Reply