Jump to content
Sign in to follow this  

Worksheet calculations off

Recommended Posts

I have attached a record to my tree and shrub symbols. The record is attached to a 6' diameter circle in a class, so it's 28 sq ft. This is used to calculate the water needs of that plant (MWELO). However my worksheet is not adding up the sq ft accurately. For example:

6 Trees x 28sq ft= 168 sq ft.

My worksheet says it's 144 sq ft. So it's off by 4.26 sq ft per plant.

The problem isn't consistent, so on some shrubs it's off by more, on others it's off by less. Example:

8 shrubs x 28 sq ft=224, worksheet says 218 is the total, so it's off by .75 per plant.

15 shrubs x 28 sq ft=420, worksheet says 389, so it's off by 2.06 per plant.

Does anyone have advice on solving this? Thank you!

Share this post

Link to post

Tell us more please.

1. What number are you using in the calculation? The area of the circle or a manually entered value in the record?

2. If you are using the area, are you sure that the circles are exactly 6' diameter? The 144 sounds like 5.5' diameter.

3. Have you tried removing the SUM tile so you can see if there is a problem with a single instance or if they are all the same? If not, either temporarily add a second database to the worksheet or create a second worksheet that will show the data for every instance instead of just the total.

Share this post

Link to post

It looks like the tree symbol was too small. It was 8' diameter spread in the definition and the outline was an 8' diameter circle, but the interior linework was slightly larger than 8'. So although I had a 6' diameter circle, it shrunk it slightly so as to make the whole symbol fit into 8'.

It seems I'd have to give up the interesting aesthetics that I want to achieve technical accuracy or spend too much time tinkering with every symbol to make them exactly match the definition.

Share this post

Link to post

Or add a record to the symbol that you can then enter the value that you want regardless of the geometry of the symbol.

This is especially appropriate if you want to be able to use the graphical symbol as a "scalable symbol" and change the size to get the graphic look you want.

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.

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.

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.

  • Create New...