fhunt Posted June 13, 2019 Share Posted June 13, 2019 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 ? Quote Link to comment
Vectorworks, Inc Employee Tamsin Slatter Posted June 14, 2019 Vectorworks, Inc Employee Share Posted June 14, 2019 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. Quote Link to comment
Vectorworks, Inc Employee Tamsin Slatter Posted June 14, 2019 Vectorworks, Inc Employee Share Posted June 14, 2019 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 2 Quote Link to comment
fhunt Posted June 14, 2019 Author Share Posted June 14, 2019 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 1 Quote Link to comment
Vectorworks, Inc Employee Tamsin Slatter Posted June 14, 2019 Vectorworks, Inc Employee Share Posted June 14, 2019 You're welcome. You can achieve so much with worksheets - just need to get your head around the possibilities! Quote Link to comment
RussU Posted June 14, 2019 Share Posted June 14, 2019 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! 2 Quote Link to comment
milezee Posted June 14, 2019 Share Posted June 14, 2019 @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 👍 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.