Hello Community!

This Saturday, April 11, from 9am – 1pm EDT we will be performing maintenance on the Vectorworks Community Board. During this time, the site will be unavailable.

# Space Tool Proposed vs Net Area calculation

## Recommended Posts

Is it possible to do a take-off of the difference between the proposed area vs net area of a space and have the worksheet report what spaces are over or under the proposed area?

When trying to subtract one from the other in a worksheet #VALUE! is the result.

Thanks-

Brian

I was able to get the difference between the two values in a quick test file, could you post your space and worksheet so that I can take a look? Putting those two objects in their own test file (as long as the issue still remains) and posting just that would be fine.

Hi Jim,

See attached. I tried to subtract cell C from E, and space proposed from net area. What is the method to do the calc?

Thanks so much,

Brian

I could have sword there was a way to do this. What you are doing would be right for a regular worksheet, but for a database row (where you're doing math on multiple cells in order, below) you would use something like:

=('Space'.'11_Gross Area')-('Space'.'11_Proposed Area')

But in the case of spaces, the value its giving is including the "sq ft" so the math fails. But there IS a way around this, I have simply forgotten it. I'll check here and see if I can grab someone before we close. If not, perhaps another board denizen knows the way.

That is the formula that I tried but get #VALUE!

Thanks

In VW2015,

'Space'.'Area' and 'Space'.'Proposed Area' should give you the numerical values you are looking for.

'Space'.'11_Area' is defined as static text, so it can not be used in a math calculation.

The script in the following thread will show you the field types for each of the fields of the selected object.

Thank you Pat! Works like a charm! Very much appreciated.

Also thank you for the link to the PIO fields script. It is a great piece of code that I had used before but had lost.

Thanks for all of your help!

Brian

There it is, thanks Pat!

One more question on the proposed vs net area calculation.

The formula works in the worksheet as Pat explained.

Can it be attached to the space? I see that you can specify a formula to be attached to the space label.

When I add the formula =('Space'.'Net Area')-('Space'.'Proposed Area') to the formula, that is what appears on the label, not the numeric value.

Thanks again,

Brian

I think that I have figured it out, through trial and error....

It will report the difference as a value when linked to the space tag.

Now I can push and pull the space to get close to the value close to 0!

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×