Space Tool Proposed vs Net Area calculation

[Brian H]

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

[PVA - Admin]

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.

[Brian H]

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

[PVA - Admin]

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.

[Brian H]

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

Thanks

[Pat Stanford]

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

[Brian H]

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

[PVA - Admin]

There it is, thanks Pat!

[Brian H]

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

[Brian H]

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!