Jump to content
  • 2

Calculating quantities across a database header


ericjhberg

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)
Link to comment

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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
Answer this question...

×   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.

×
×
  • Create New...