Jump to content
Samuel Derenboim

Property Line PIO Area Summaries

Recommended Posts

Good afternoon Everyone,

I'm having a real problem with calculating area summaries for the Property line plug in object. I've been trying a number functions additional to =('property line'.'area') in order to convert this string into a numeric value. I've tried =value, =area, =round, =num, =str2num, etc... and I can't for the life of me get it to work. Anyone had any similar problems - VW 2018 SP2

 

PS - I checked the VW forum records, there was a similar wishlist item, but for some reason =area function worked in that instance. Any help please? 

 

Thank you in advance!  

Edited by Samuel Derenboim

Share this post


Link to post

In a worksheet database (Row 2, criteria = Record 'Property Line' is present) with the 'Propery Line'.'Area' field in cell A, the following formula in column B worked for me:

 

=VALUE(SUBSTRING(A2, ' ', 1))

 

The Substring splits the string in cell A2 in to substrings using the space character as the delimiter. The 1 tells it to use the first substring it finds.

 

So with an area field of "475.542  sq ft    ",  it returns 475.542 to the Value function giving you a number.

 

If you are not using sq ft as your unit, you may need to adjust the substring delimiter is there is not a spaces after the number. If you have something like 123.455m2, I would just us 'm2' as the delimiter.

Share this post


Link to post

Pat, Thank you! Just modified your code to make it work in one column. Just make a worksheet column show this below:

 

=value(substring('property line'.'area', ' ', 1))

 

Just curious, why is this such a hassle for property lines? Couldn't they just make it originally a numeric function?

Edited by Samuel Derenboim

Share this post


Link to post

Yes, it seems that "THEY" could do a better job of making the data accessible in the worksheet. The Space object used to be pretty bad. Most of the fields there now have both numberic and string versions.

 

Submit a wish to have numeric versions of all the necessary fields of the property line.

 

I think this actually comes from all record data actually being stored as strings. Only having a single version of the data to keep straight is very comforting to programmers. ;-)

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

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.

×