Jump to content
fhunt

Landscape areas: plant numbers

Recommended Posts

I am using landscape areas to specify the amount of plantsper square meter, is there way to limit vector works to just specify odd numbers of plants and to round up areas? For example if I have an area of 1.5sqm and I plant at 4 p/sqm the output would be 6. Is there a function to bump up to 7 within the landscape areas tool ?

 

Share this post


Link to post

No, there isn't a way to do this in the Landscape Area tool directly. My initial thought was that you would be able to do this using a worksheet function on the schedule produced by the Landscape Area... but I can't figure it out. I even got my top spreadsheet brain, UK Director of Sales @Adrian Slatter onto it, but after a while of muddling it over, he's declared he will have to think about it... If we find a way, we'll post back to you.

Share this post


Link to post

Well, you're in luck. A long wait at the airport has put Adrian Slatter's brain to the test and he has come up with the Round function in a worksheet to produce the results you want. Please see the attached file which contains a worksheet based on the standard Landscape Area with Plants example. This now includes a new function to the right of the quantity, which looks at the quantity, and then makes it odd. Thank you @Adrian Slatter

Landscape Area Rounded.vwx

  • Like 2

Share this post


Link to post

Hi Tamsin, 

 

Many, many thanks to you and Adrian for looking into this and finding a solution!! It will be a really handy function when producing planting plans

 

Thanks again

 

 

  • Like 1

Share this post


Link to post

You're welcome. You can achieve so much with worksheets - just need to get your head around the possibilities!

Share this post


Link to post
31 minutes ago, Tamsin Slatter said:

need to get your head around the possibilities!

After having a look and seeing what Mr S has done, you really should get him to do a few video tutorials!
The viewers will love the English accent!

  • Like 2

Share this post


Link to post

@Tamsin Slatter yep I agree with the above ☝️, still new to VW here and using worksheets simply at the moment. I'm sure there's much more which can be done, so as @RussU says, some tutorials would be great 👍

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.

×