AutoCAD - Data Extraction Table for Area of Hatches

[dpalmerVQ54W]

In the screen shot below, the areas shown are the total area of hatch for each "Component". Each "Component" is a separate layer. This is in layout space and the part of building shown is in Model space.

I've tried Data Extraction which looks at the Hatch area on each layer. This generates a table, which I've been able to format to be similar to as shown above, including adding a sq ft column (calculated using a formula). I also managed to add a row at the bottom to sum the areas. My problem comes when formatting the Row heights. Ideally what I want to do is insert additional blank rows between each of the Components to match the screenshot above. The Table edit options won't allow me to do this! 

Any suggestions, alternative methods would be useful. I have tried building the table manually but can't work out how to extract the hatch area into the table (like the Data Extraction Wizards does).

I have multiple drawings, with varying numbers of Components so what ver is created needs to be flexible., if it's even possible.

Thanks.

[ The subject line of this post has been edited to include the product name by @handjonathan ]

[TheCADnoob]

Have you tried using fields in the table?

[dpalmerVQ54W]

The bit I'm struggling with is that my hatches are in model space and my table is in Layout. I can't work out how to select the hatch in model and link the field in Layout.

[TheCADnoob]

This may not be the best method to achieve this but you can copy the field string from the model space field and paste it into the paper space field (use formula). I will caution, in my experience, sometimes fields get wonky when you start getting to deep into nesting them. So make sure you verify the accuracy and that everything is as its supposed to be. 

 

[pendean]

---

@dpalmerVQ54W wrote:

The bit I'm struggling with is that my hatches are in model space and my table is in Layout. I can't work out how to select the hatch in model and link the field in Layout.

---

May I ask why not create a viewport just for the table in your Layout, scaled as you wish, instead of the more challenging option you've chosen? That way all of your content stays in one place, MODEL.

[dpalmerVQ54W]

Thank you for the suggestion to-date.

I had a re-think and followed @pendean suggest & created a table in Model. see below

• The coloured square is a block.
• The name is a Named Object field pointing to the layer
• Currently the sq m is an Object Area using Fields
• The sq ft is a formula
• The totals are a formula.

The problem comes when copying the table from one drawing to another (different floors of the same building).  The sq m and sq ft turn to xxxxxxx. I understand this as the Object Field is pointing to an object, which is different in the new drawing.

When I tried the Data Extraction method of creating a table, I could extract the area of hatch on a specific layer. This means it's not tied to a specific object. I can't work out how to extract the area of hatch on a layer and insert this into the table.

I hope this makes sense.

Thanks in anticipation.