Worksheet Failure

[Artscape Design Ltd]

I have accurate plant schedules relating to three separate layers for different garden beds.  When I create a worksheet on the masterplan that includes all three layers of plant numbers if it coming up zero.  In my criteria I add all three layers plus plant records.   I would like to know why it is not selecting each layer so I can get a total number of plants.  

Thanks for your help. 

Wendy

[Tom W.]

Is your criteria saying 'all criteria in this set' for the layers rather than 'any criteria in this set'?

[Artscape Design Ltd]

Every time I try that over 10000 items meet criteria and it crashes the program.  

[rDesign]

If you can post a screenshot of your selection criteria, that would probably be very helpful to figure out what is going wrong with your selection criteria.

[Artscape Design Ltd]

I have made a new clean file, created two layers and pasted in the planting only.  When I do a total schedule with the 'any' criteria selected it works!  

Maybe there is a reason why it is picking up 100000 items in my original file.  There certainly aren't that many plants! 

 

[Artscape Design Ltd]

I have just selected the plant class instead of layer and this seems to work accurately.  So maybe I will in the future put different planting beds on different classes and select them as the criteria.  I know I have done it before with layers so I wonder if this is a gliche with the software that it doesn't always work? 

 

[Jeff Prince]

You problem is in line 1.  You have to change it to "ANY criteria in this set" and add the appropriate design layers.

 

Or, have you tried this method, using a "is not" statement and listing your design layers:

 

Really, a list of layers to use with an "any criteria" is quicker and more reliable than an "is not" method, especially if you build a graphic plant schedule on another design layer  IMHO.  I wouldn't use classes for this task as it could create more errors and confusion without careful management, design layers are superior and simpler.

Edited November 21, 2022 by jeff prince

[Tom W.]

10 hours ago, Artscape Design Ltd said:

Every time I try that over 10000 items meet criteria and it crashes the program.  

 

10 hours ago, Artscape Design Ltd said:

I have made a new clean file, created two layers and pasted in the planting only.  When I do a total schedule with the 'any' criteria selected it works!  

Maybe there is a reason why it is picking up 100000 items in my original file.  There certainly aren't that many plants! 

 

 

If you set the above criteria to 'any' in line 1 it will return all the objects on those layers not just the Plants as you will be basically asking VW to search for objects which either have the Plant Record present, or are on the L302 layer, or are on the L303 layer, or are on the L304 layer.

 

Instead you need this criteria:

 

 

Now you are only searching for objects with the Plant Record present which are located on either of those 3 layers.