Batch Area Calculations

[MylesMc]

I am using autocad to find areas of a stream cross section such that when we take a water height measurement of the stream in the field, we can easily get the area from a spreadsheet since the cross section of the stream at any height will be known (once I get done in AutoCAD).

 

To further illustrate my needs, I have attached a picture. I need all the seperate areas between the red lines (the red lines are equally spaced vertically and have lengths that go end to end to the edges of the stream).

 

I have been hatching between the red lines and taking the areas of each hatched object. However, this is a slow and tedious process.

 

Hatching is not the issue because I can hatch multiple objects at once using the create seperate hatch option.

 

What I need is a way to list all the hatched object's areas into a text file so that I can easily copy and paste them into an excel file. Even if it is not a nice and neat list, I can atleast use a find for "area" to get them into a nice list a little faster.

 

Any Ideas?

 

Thanks,

Myles

 

[Manila Wolf]

Would be relatively simple if you had full AutoCAD as their are lisps available.

 

However, I wonder if this would be simple enough.

 

Make a new layer and make it current

Use the "boundary" command

You will have to click between the red lines one by one.

Turn off all the layers except the new one with the boundary's

Then use the list command, but select using "fence"

Draw your fence line from top to bottom.

Press F2 to show the list results. You will need to press enter a few times I think to show all the results.

Copy all the resultant text and paste into Excel at cell A2

Set up an Excel filter on Column A only, then filter just to just show the individual areas.

You now have a list of individual areas in the top to bottom order.

 

Or you could filter all except the areas, then delete those rows leaving just the area rows.

Edited March 15, 2012 by Manila Wolf

[MylesMc]

I ended up using a similar method by Hatching, then selecting the Hatches in order, using he LIST command and pasting the full list into excel and using the FILTER button under the DATA tab for AREA.

 

Thanks for the help.