Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

john.vellek
en respuesta a: Anonymous

Hi @Anonymous,

 

I made a quick video that shows some possibilities for accomplishing your request.

 

You will see that I created a block with three attributes in it. 

1) Spacename

2) Area

3) Perimeter

 

The last two attributes contain fields. Each field is linked to an object. In this case the object is a polyline which would represent the perimeter of your room.

The first of these fields is linked to the area inside the polyline and the second field is linked to the length of the polyline.

 

Because the fields are linked, if the polyline grows or shrinks or changes shape, the fields will automatically capture the new values. To see any changes you can Update the fields or Regen.

 

Next, I created an extraction template to use with ATTEXT. This command will create a text file based upon the template.  I extract the data from my block and it ends up in a TXT file. I rename the extension to CSV (comma separated value) and open it in Excel. I sort the columns and then use Replace to remove extra characters that I don't want to see.

 

I then copy and paste the cells into an existing spreadsheet that I have previously linked to my drawing using DATALINK.

 

I can then return to my drawing and update the table which is based upon the datalink. It now shows all the Rooms and the attribute information.

 

This sounds like a lot of steps but I hope you can get the idea and use the concept to your advantage.  I have attached my sample files for your use.

 

I apologize that I didn't narrate my video but my microphone has just quit on me.

 

Please select the Accept as Solution button if my post solves your issue or answers your question.

 


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback