Jump to content

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.

Sign in to follow this  
Brian H

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

Share this post


Link to post

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.

Share this post


Link to post

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

Share this post


Link to post

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.

Share this post


Link to post

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.

https://techboard.vectorworks.net/ubbthreads.php?ubb=showflat&Number=115054#Post115054

Share this post


Link to post

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

Share this post


Link to post

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

Share this post


Link to post

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

Add the Formula to the object info menu and enter: =#26#-#11#

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!

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.

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.

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