Jump to content
  • 2
Sign in to follow this  
ericjhberg

Calculating quantities across a database header

Question

We are often tasked with quantifying elements in our drawings and dividing these quantities up along different sections of the design.

 

To provide an example, the following screenshot shows an excel spreadsheet being used to track quantities across 9 medians in this case.

Screenshot_1.jpg.888ca799601948de25ad8685f63bc0b1.jpg

 

Each row is a separate line item that we need to provide quantities for and each column to the right, a separate median. Also note that each row is potentially a different unit.

 

It would be great if Vectorworks' worksheets had the capability to do something similar using database headers. I know it is possible by writing individual formulas in cells of a spreadsheet, but that gets cumbersome and potentially creates errors as classes modify and things shift throughout a project. Its a lot to keep track of. I also know that this could be managed by a record with separate fields for each of the medians' quantities, but again, that would have to updated each time the drawing shape changes since there is no way to link a shapes properties (i.e. area, volume, length, etc.) to a record value.

 

We can easily separate quantities using design layers, polygon location references, records, etc, so what I am imagining is

  1. a general database header formula...L='Demo' in this example.
  2. Then in columns I could use the =C formula to summarize rows based on classes (essentially the line items from the example) above,
  3. Use the formula =AREA(LOC='MEDIAN 1'), =AREA(LOC='MEDIAN 2'), =AREA(LOC='MEDIAN 3'), etc. for all of the columns calculating quantities.
  4. I don't really have a great way of separating the units (=area, =length, =volume, etc.) though, so I would have to create a database header for each different quantity (which can screw up the order)

Share this post


Link to post

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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
Sign in to follow this  

 

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.

×