# 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 ?

• Vectorworks, Inc Employee

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.

• Vectorworks, Inc Employee

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

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

• Vectorworks, Inc Employee

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

31 minutes ago, Tamsin Slatter said:

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!

@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 👍

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×

• KBASE
• #### MARIONETTE

×
• Create New...