Roger Webster Posted November 24, 2010 Share Posted November 24, 2010 How do I sort plants on a schedule into trees, shrubs, groundcovers etc? Should I place them on separate layers and create separate worksheets for each category using the "edit criteria" command? Or set up seperate classes for each? Quote Link to comment
mike m oz Posted November 25, 2010 Share Posted November 25, 2010 Roger you can use the Plant Category Record as a criteria filter. You need to be diligent though and ensure that all of your plants are categorised correctly and that the spelling is 100% correct in every instance. Quote Link to comment
Roger Webster Posted November 25, 2010 Author Share Posted November 25, 2010 Thanks Mike, I get the picture. Looks like I'll be spending the Christmas break sifting through plant object definitions. Quote Link to comment
Roger Webster Posted December 10, 2010 Author Share Posted December 10, 2010 Roger you can use the Plant Category Record as a criteria filter. You need to be diligent though and ensure that all of your plants are categorised correctly and that the spelling is 100% correct in every instance. OK I have gone through all my plant records making sure the category of each is correct. If I create a worksheet and include all categories, it's fine. If I then start to filter by category, the data disappears from all but the first category, ie, in subsequent categories all rows appear blank even though the "edit criteria" window tells me the items (plants) are being correctly sorted and counted . The "select data item" command also identifies each one, but no text appears in any of the row columns. Any help gratefully received. Quote Link to comment
mike m oz Posted December 10, 2010 Share Posted December 10, 2010 Here is an example from the Vw 2008 Landmark Getting Started tutorial. Quote Link to comment
Roger Webster Posted December 13, 2010 Author Share Posted December 13, 2010 Sounds promising but I cannot open the downloaded files. Are they available as pdfs? Quote Link to comment
mike m oz Posted December 13, 2010 Share Posted December 13, 2010 Roger it is a Vw 2009 file which is what your signature says you have. Thus I don't understand why you can't open it. A PDF will not be much use to you because you won't have any way of examining the Worksheet. A typical criteria filter is shown in the attached image. Quote Link to comment
Roger Webster Posted December 13, 2010 Author Share Posted December 13, 2010 I don't understand why either, but anyway ... as above, it's fine if I just have one section, eg trees, OR shrubs etc, but if I then add further database rows for shrubs, perennials, climbers etc and enter new edit the criteria for these all of these appear as blank rows. They do have data in them, I know this because if I add new plants, new rows appear and I can identify them using the "select data item" command, but all text in the worksheet rows is invisible/absent except for the first section. I also notice that the formula "summarise items with the same name" does not work in the subsequent sections, only in the first one. The only way I can find round this is to produce separate worksheet lists, one for each plant category. The Getting Started with Landmark 2011 pdf download shows the sort of plant list worksheet I need (though I'd want to edit the columns), but does not explain how it was created. I have also been trawling through the 2008 Design Series and Fundamentals manuals to get this far, but now I'm stuck! Quote Link to comment
Bryan G. Posted December 13, 2010 Share Posted December 13, 2010 Post your worksheet and we could check it to see if there is an issue. Quote Link to comment
mike m oz Posted December 14, 2010 Share Posted December 14, 2010 A question Roger. After you have made your changes are you invoking the Recalculate command? Quote Link to comment
Roger Webster Posted December 14, 2010 Author Share Posted December 14, 2010 (edited) OK here is (hopefully) a small file to illustrate the problem with some random plants. The plant list has captured all the data, but only the trees show up. Many thanks for the help. And yes I have been hitting the recalculate button, and any changes are indeed incorporated. Edited December 14, 2010 by Roger Webster Quote Link to comment
Bryan G. Posted December 14, 2010 Share Posted December 14, 2010 You only have a formula for the acer. as for the other verieties add the formula in the database header. I made the modification on you sample drawing and all works fine. Remember after each sort (ie. shrubs, perennials, etc.) add the formula in the header. Give it a whirl and let us know if you have any other questions. Quote Link to comment
Bryan G. Posted December 14, 2010 Share Posted December 14, 2010 Also make sure your plant data (Category) matches your sort or plants will be eliminated from the total. Quote Link to comment
mike m oz Posted December 14, 2010 Share Posted December 14, 2010 Roger, for the other categories you are missing formulae in each of the Database header rows. Quote Link to comment
Roger Webster Posted December 14, 2010 Author Share Posted December 14, 2010 Yes, just figured it out at last, from the file you sent earlier which I have now managed to open - I needed to copy and paste formulae into each database header. Thank you very much - a great leap forward for me Quote Link to comment
Roger Webster Posted December 15, 2010 Author Share Posted December 15, 2010 OK I'm finally there - with much help from Mike m and Bryan G - gratefully acknowledged. But I can't help thinking this should have been a great deal easier! The ability to produce a plant list from a plan, and to keep it updated, is a fantastically helpful tool for anyone in the landscape business and a good reason for using Vectorworks - but why make it so clunky to use?. The fields to be included will vary in different countries and according to the use the information will be put to - client presentation, costing, ordering etc, but surely sorting the list alphabetically and by plant category are pretty basic requirements for all of us. Why then do none of the standard sample worksheets do this, and why is information on such a basic task so very hard to come by? Does the process of customising a worksheet need to be so arcane? Sorry to gripe, but judging by some other postings on the subject of worksheets I'm not alone in finding this confusing, and as an Apple user I am accustomed to programmes being much more attuned to the needs of the end user. 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.