DWG Data Extraction Export drawing data to tables and Excel

DWG Data Extraction Export drawing data to tables and Excel


ARES Commander allows you to
extract data from a drawing. An action has many applications. In this example, we are going
to take advantage of the blocks with attributes
of ARES Commander to extract those attributes and
convert them into a table, which indicates the number of elements and the cost of these. Thus, in a program like Excel we could import that information to obtain a total budget of the equipment cost of this project. Although the truth is that we can also do
it directly in ARES Commander. This action to extract data, we can do it to a specific area of the drawing or to the whole drawing. Let’s see how to do it. These chairs are blocks with attributes. In the INSERT tab we will find DATA EXTRACTION. We have the possibility to
create a new data extraction, or use an existing one, to update a previous extraction, For example, in this case, it will be a new data extraction. The data will be saved in
a DET extension format. In this example, we do not want to
extract all the data from the drawing, but we are going to choose
specific elements. Therefore we choose this option. Now with a window, we select the area that
includes the elements that interest us. We have selected more than necessary, but it doesn’t matter, we can filter them. Since we are only interested in the
chair that is a block with attributes. We activate and deactivate options to
quickly filter the one that interests us. Now you only see the
block with attributes that interest us and after
selecting it press NEXT The block as such has
much more information related specifically to its attributes. So we will make a new data leak, deselecting the categories
that we are not interested in. Now we only have the
attributes of the block, and we can also deselect those
that do not interest us. For example, we deselect DESIGNER. Press NEXT. Note that the preview of the table
indicates the number of elements, there are 62. We even know the individual cost, because it was one more attribute. But we don’t have the total
cost of the chairs. Therefore, after pressing NEXT, we can export this data to EXCEL and complement the table by adding a formula that multiplies
the number of chairs by the individual cost. This action applied to all
project equipment, would allow us to quickly
have the exact cost of the equipment. Now, we can choose between
inserting the data in a table within the ARES Commander drawing, or extracting it to an external file that I can import into Excel
or another similar one. Although the truth is that we can
also choose both options, and thus generate the table while generating the external file. We have got the table. But before seeing how to
perform calculations, let’s make a change. In the drawing, we will remove 6 chairs and we will extract the data again. In this case, we want to
edit an existing one. So we chose the DET extension
file that we had created before. We select the entities … Note that ARES Commander remembers
our previous preferences, showing only the chair. The “DESIGNER” attribute is also deactivated, so press NEXT. In the preview of the table,
we can see that there are now 56, that is 6 less than before. We choose the 2 options again, to create a table within the
ARES Commander drawing and in this case, to update
the previously created file. That’s why he asks us if
we want to replace it. Here we have the 2 tables. We can remove the oldest one. In Excel, we can import
the CSV extension file, and after making usual
corrections when importing this type of files we get the table, where we can add a
multiplication formula at the end On the other hand, from the table that we have
inserted in the drawing, we must not forget that we can add formulas, just as we would in programs such as Excel. To do this, we select a cell. Pressing the right mouse button, we go to INSERT and choose COLUMN RIGHT Or we can do it from the Ribbon. We give this column a name. In the lower cell, we write a formula, just like in Excel we start with “=” followed by the coordinates of the cells that in this case, we are interested in multiplying. That is A3 multiplied by E3. Press ENTER, We adjust the size, and so we have a complete table, even capable of performing operations without leaving ARES Commander. To learn more about TABLES
in ARES Commander we have another video where
we delve into this topic. For these and other topics, you can visit the extensive
HELP offered by the program.

Leave a Response

Your email address will not be published. Required fields are marked *