Jump to content

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!

Link to comment

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.

Link to comment

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.

Link to comment

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.

×
×
  • Create New...