Jump to content
Samuel Derenboim

Worksheet Summary Problem w/ Tags and Geometry Ref

Recommended Posts

Posted (edited)

Hi everyone, 


Maybe someone by chance ran into a similar problem? I have a series of elevations where i used geometry and tags to summarize window heights and window widths (among various other elements) in a worksheet. Normally, when i do window schedules, or door schedules in a bim model, the information doesn't repeat when i enable 'summarize items'. Here, for the life of me, i can't figure out why when i summarize by its id (custom record), by the geometry height =height, and by geometry width =width i get repeated elements that wont summarize, even if they display the same information.

image.thumb.png.ab943aba2503386cfd9e1c509d223cb7.png

 

but when i just summarize by ID i get this

 

image.thumb.png.24dc97313b5e6aa309cd41df161feee8.png

 

 

Perhaps someone can help me out? Thanks in advance!

Edited by Samuel Derenboim

Share this post


Link to post
Posted (edited)

Update - 

Noticed that despite having the same dimensions, the ratio of the objects are different. Is there a way to globally update all objects ratio without having to re-enter the dimensions of every single object? The moment I update the dimensions, or retype the dimension, it updates the ratio. This also helps with the summary - it starts to summarize the contents of the the file better. Is there a way to auto update the ratios of all of the geometry that have the same dimensions dynamically? or is there a way to re enter the =height and =width columns (they remain grey). It might help with the ratio problem.

 

 

image.thumb.png.b9410064f4b5202c86ffee798184481c.png

 

image.thumb.png.15636b47d50a4793af9b19e751a9e854.png

 

Edited by Samuel Derenboim

Share this post


Link to post

It appears that the actual entered dimensions of the windows are not identical, but that they round to the same display value. That would also be why you are not able to get them to Summarize as they are not the same at a computer level even though the are on a human level.

 

Assuming you Height and Width columns are actually displaying the information from the Window Record (=window.height) and not the worksheet functions (=height), you should be able to enter the height or width in inches into a cell so you can copy it to the clipboard. You can then paste that into a multiple selection of other cells.

 

If you were in Inches instead of Feet-Inches it would be easier and just be a copy/paste.

 

Or temporarily change the cell formatting to Decimal to make the copy/paste easier and then format back.

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.

×