minotto Posted May 23, 2017 Share Posted May 23, 2017 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 Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted May 23, 2017 Vectorworks, Inc Employee Share Posted May 23, 2017 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. Quote Link to comment
minotto Posted May 23, 2017 Author Share Posted May 23, 2017 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? Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted May 23, 2017 Vectorworks, Inc Employee Share Posted May 23, 2017 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. Quote Link to comment
Marionette Maven Marissa Farrell Posted May 23, 2017 Marionette Maven Share Posted May 23, 2017 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. Quote Link to comment
minotto Posted May 23, 2017 Author Share Posted May 23, 2017 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. Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted May 24, 2017 Vectorworks, Inc Employee Share Posted May 24, 2017 12 hours ago, minotto said: i think the worksheet/ schedule capabilities need a revision - simplified We agree! This is planned. 1 Quote Link to comment
Recommended Posts
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.