Jump to content
Sign in to follow this  
J. Wallace

Seperating trees,shrubs, and perennials on plant list

Recommended Posts

Hello

Anyone tell me how to separate trees, shrubs and perennials on a plant list worksheet ? I have tried to figure this out all afternoon. I place plants on the drawing, they end up on the list, all is well except I want to separate them into there different categories.

Any Help would be much appreciated, I believe the answer lies in the worksheet formulas, but I'm stuck.

Thanks

Share this post


Link to post

Take a look at the worksheet included in the 'Plant Objects.vwx' file (that is installed with landmark. It is formatted to separate the plants based upon the 'category' setting from the plant definition.

Share this post


Link to post

Wow....don't know how I missed that, Thanks.

Can you tell me if it's possible to have the ID show in this worksheet, and if so how???

Thanks

Share this post


Link to post

You will have to edit the worksheet to add a column. In the database header rows (there is one of these for each 'type' you will have to set the cell to get the ID data. Look at the format of the adjacent records and the plant record attached to each plant object to see what field you will have to reference. You will have to do this for each database header row.

Share this post


Link to post

What you really want is to have three different databases on one worksheet. Each would show just Trees/Shrubs/Perrenials.

To get one, you should be able to click and hold on the database row header (i.e. 4, not 4.1, 4.2, etc.). One of the options is to Edit Criteria. In the Criteria dialog box, click the More Choices button. This will give you an additional row of criteria. Set it to Shrubs.

This will give you a database that shows only the shrubs in the drawing.

Now select the database header row and copy and paste it lower in the worksheet. You should now have two copies of the Shrubs database. Edit the criteria again and change the Category from Shrubs to Perennials.

You should now have a database of shrubs and a database of Perennials.

Repeat this again for your trees. In the very brief test I did, the category for the trees was Coniferous Trees.

Share this post


Link to post

I liked the info in this topic we have also had the same issues, and easy solutions are great. However how is it done? The knowledge would allow us to create custom reports.

Also is there any reference material in regards to the reports area of the program?

And is there a way to automatically apply an image of the plant by its listing in the report.

Share this post


Link to post
What you really want is to have three different databases on one worksheet. Each would show just Trees/Shrubs/Perrenials.

To get one, you should be able to click and hold on the database row header (i.e. 4, not 4.1, 4.2, etc.). One of the options is to Edit Criteria. In the Criteria dialog box, click the More Choices button. This will give you an additional row of criteria. Set it to Shrubs.

Pat, could you clarify what gets set to shrubs? After I select the More Choices button, the options are Record, Plant Record, Present, Type, Is, 2D Locus. None of these pop-up menus has "shrubs". Or do I type that in after selecting something else? Thanks.

Share this post


Link to post

The Primary criteria needs to be Plant Record and the second category should be set to Field Value : Category = Shrubs

You will have to type in the word Shrubs, it will not show up in a pop-up.

Share this post


Link to post

Hi

an easy way we do it here is to use the 'Plant list- simple' supplied in the reports & schedules folder of the defaults/ libraries/ VW2008 folder.

turn on data base headers in the worksheet (the little upside down triangle under the red 'X' in the upper left corner). Click and hold the open diamond at the front of the line. Scroll down to 'set criteria'. If your trees, shrubs and ground-covers are on separate layers or classes, the criteria can be set to 'class' or 'layer', then select the appropriate layer or class. This should cause the worksheet to list only the trees, for example.

add a couple of rows to the bottom of the worksheet. Copy the database header line and paste it in one of the empty rows. Repeat the process using the next class or layer you want tabulated.

You may have to use the summation button to the top of the column.

Share this post


Link to post

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

Sign in to follow this  

 

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.

×
×
  • Create New...