Jump to content
acrane

Total Lengths of Lines on one class

Recommended Posts

I am having trouble using worksheets to add up the total length of my lines that are on one class.

I am trying to set the criteria in the worksheet. Along with using the SUM tool. I'm having no luck. 

Any suggestions?

 

Thanks

Share this post


Link to post

HI @acrane

 

I'm assuming you'd like to create this yourself so I'm giving general directions rather than than just supplying a sheet for you.

 

You don't say whether you want just your 'chosen' class or show all classes in this exercise. I've chosen to 'see' all - You can make changes by adding a specific class name to the criteria.

 

So, set the criteria as simple as possible - you can add as many criteria as you want. This will just choose lines in general. 

 

1811831336_ScreenShot2018-05-31at10_21_57.thumb.png.0f591012d5ef549982a518dd1bdc367a.png

 

To provide an example, I've set up a special class here called 'Your Special Class Name' - you'll be changing to suit your project.

Then draw a few test lines choosing the Class as you go.

The black line is in 'Dimensions' and the red ones are set to 'Your Special Class Name'

And so, the lines are added to the simple 2 column worksheet. (appropriate headers added)

2053111679_ScreenShot2018-05-31at10_24_30.thumb.png.d3ad0192ac3b373d6efb426f81773f83.png
 

To Get the above, the column filters are set as below.

 

Class Name....

581077629_ScreenShot2018-05-31at10_24_05.thumb.png.6a82a708201d6089d3be8146398ef3f5.png

(you obviously don't have to Sort, but its provided)

 

Total line Length...

770543660_ScreenShot2018-05-31at10_45_01.thumb.png.53a666876b23c1c00f43a5b9bab150bf.png

 

 

Come back if you have problems.

 

 

 

Edited by Gadzooks
  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×