EZ way to calc. sum of line lengths??

[Stress Co_]

I'm working on a project where the municipality requires the average lot slope to be computed. Part of the calculation is "the summation of the length of all contour lines".

The contour lines are splines. Is there an easy way to calc. the sum?

I used "Element Information" to list the lengths.... and started adding by hand

[David Larrew]

Unfortunately, with the exception of Fills and Zones, I don't think you are able to calculate and schedule 2D elements.

[Stress Co_]

I tried copying the text from the "Element Info" window into an Excel spreadsheet (where I could add the "cells") ....... but it pasted a pic of the selected lines ...instead of the text

[Link]

I was hoping the new whizz-bang Measure Tool would allow us to add our measurements, but apparently we only need to measure one thing at a time!

I asked for it in beta and more recently in a bug report to GS. It would be nice to actually give that tool something over the great method we have always used to measure!

Cheers,
Link.

[David Maudlin]

Stress wrote:
I tried copying the text from the "Element Info" window into an Excel spreadsheet (where I could add the "cells") ....... but it pasted a pic of the selected lines ...instead of the text

Marc:

I tried setting the Working Units to decimal feet and copying just one number at a time (without the feet indicator, try double clicking on the number), and this pasted into Excel (Microsoft Excel X for Mac Service Release 1 from the About Excel box) as a number that can added to others. This worked with both ArchiCAD 9 & 10.

Not the easiest way to get the info you need, but better than copying the info by hand.

HTH

David

[Stress Co_]

David wrote:
I tried setting the Working Units to decimal feet and copying just one number at a time (without the feet indicator, try double clicking on the number), and this pasted into Excel (Microsoft Excel X for Mac Service Release 1 from the About Excel box) as a number that can added to others.

Daivd:
I tried just as you describe.... but it's still pasting a "picture" from the clip board (I have the same XL release)

[Greg A_ Blunier]

You should be able to use the menu (hidden under the little triangle in the upper right corner) in the Element Information palette to "Save as tabbed text".

This then opens in Excel and all you have to do is delete the foot indicators before summing them.

Greg

[Stress Co_]

Greg:
Thank you! I never knew those options existed.
That (and David's suggestion to switch to decimal feet) did the trick.

[Laura Yanoviak]

Link wrote:
I was hoping the new whizz-bang Measure Tool would allow us to add our measurements, but apparently we only need to measure one thing at a time!

I asked for it in beta and more recently in a bug report to GS. It would be nice to actually give that tool something over the great method we have always used to measure!

Cheers,
Link.

Link -- Sounds like a great wish list item -- here you go:

archicad-talk.graphisoft.com/viewtopic.php?t=11725