Jump to content
minotto

Roof Components in a Worksheet - Total Thickness

Recommended Posts

I've attached a file that i'm using to learn worksheets.  I'd like to add up the cells that contain the thickness of the roof component and show the total thickness in a separate cell.  I've tried using the SUM function as suggested by JimW in another post but i'm doing something wrong.

 

Any help is greatly appreciated.

 

 

Worksheets.vwx

Share this post


Link to post

View > Show Database Headers is currently On. I suspect that for this worksheet you just need to turn them off to display each component's thickness just once.

Share this post


Link to post

Yes but the total Roof Thickness in cell C3 which adds up cells of the components, C6 to C10 is not showing up.

How would i fix this?

Share this post


Link to post

I've not seen one configured with this many database header rows before, but I am not an expert with worksheets. However in a separate new row set to Spreadsheet rather than Database, =C6+C7+C8+C9+C10 summed them up without issue. I do not know why it isn't letting that happen in the C3 as you set it up here.

Share this post


Link to post

I would use "width" instead of summing the cells, since you're querying the same roof style throughout.

 

It would get trickier once you start introducing other styles, though.

Share this post


Link to post

Thanks for all your suggestions.  

 

Like the Resource Browser which was redesigned recently and is a lot more intuitive and efficient than it's prior incarnation , i think the worksheet/ schedule capabilities need a revision - simplified with BIM in mind where the whole process of extracting information from a model requires less effort.

Share this post


Link to post
12 hours ago, minotto said:

i think the worksheet/ schedule capabilities need a revision - simplified


We agree! This is planned.

  • Like 1

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

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.

×
×
  • Create New...