Brian H Posted December 9, 2014 Share Posted December 9, 2014 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 Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted December 9, 2014 Vectorworks, Inc Employee Share Posted December 9, 2014 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. Quote Link to comment
Brian H Posted December 9, 2014 Author Share Posted December 9, 2014 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 Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted December 9, 2014 Vectorworks, Inc Employee Share Posted December 9, 2014 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. Quote Link to comment
Brian H Posted December 9, 2014 Author Share Posted December 9, 2014 That is the formula that I tried but get #VALUE! Thanks Quote Link to comment
Pat Stanford Posted December 10, 2014 Share Posted December 10, 2014 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 Quote Link to comment
Brian H Posted December 10, 2014 Author Share Posted December 10, 2014 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 Quote Link to comment
Vectorworks, Inc Employee PVA - Admin Posted December 10, 2014 Vectorworks, Inc Employee Share Posted December 10, 2014 There it is, thanks Pat! Quote Link to comment
Brian H Posted December 15, 2014 Author Share Posted December 15, 2014 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 Quote Link to comment
Brian H Posted December 15, 2014 Author Share Posted December 15, 2014 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! Quote Link to comment
Recommended Posts
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.