topic Re: EZ way to calc. sum of line lengths?? in Collaboration with other software

EZ way to calc. sum of line lengths??

Stress Co_ — Wed, 09 Aug 2006 23:13:51 GMT

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

Re: EZ way to calc. sum of line lengths??

David Larrew — Thu, 10 Aug 2006 03:05:27 GMT

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

Re: EZ way to calc. sum of line lengths??

Stress Co_ — Thu, 10 Aug 2006 03:48:43 GMT

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

Re: EZ way to calc. sum of line lengths??

Link — Thu, 10 Aug 2006 06:11:35 GMT

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.

Re: EZ way to calc. sum of line lengths??

David Maudlin — Thu, 10 Aug 2006 12:13:35 GMT

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

Re: EZ way to calc. sum of line lengths??

Stress Co_ — Thu, 10 Aug 2006 14:07:12 GMT

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)

Re: EZ way to calc. sum of line lengths??

Greg A_ Blunier — Thu, 10 Aug 2006 14:45:45 GMT

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

Re: EZ way to calc. sum of line lengths??

Stress Co_ — Thu, 10 Aug 2006 15:28:08 GMT

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

Re: EZ way to calc. sum of line lengths??

Laura Yanoviak — Thu, 10 Aug 2006 15:38:50 GMT

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