Jump to content
Sign in to follow this  
WR-Studio

Filter Window Schedule By Class

Recommended Posts

i have a phased project with an apartment and main home.

i need separate window schedules for each.

I used the window schedule resource available via the Tools>Reports>VA Create Schedule>Window Schedule Summarized command.

i created and formatted the schedule. some windows are the same type in the apartment and main home.

i classified the windows as "A-GLAZ-APT" in the apartment and "A-GLAZ-HOME" in the main home.

i tried adding the "class" criteria, but receive syntax errors

how do I filter one schedule to display the main home windows only and filter another schedule for the apartment windows only?

Share this post


Link to post

Where are you getting syntax errors?

The criteria should look like this:

ubbthreads.php?ubb=download&Number=9146&filename=Worksheet%20Criteria.png

The criteria can be in any order...

Example attached

hth

mk

Edited by michaelk

Share this post


Link to post

michaelk,

thank you for sharing the criteria and sample. i mistakenly pasted the criteria into one of the columns.

if i paste this criteria in the "ID" "No." or "Qty" column, I get the code instead of the result (see image)

I reviewed your worksheet and noticed you didn't have to paste the criteria in a cell to get the result i want.

how do i apply the criteria to the worksheet without pasting it into a cell?

Share this post


Link to post

Apply the criteria to the database rows.

1. click on the little triangle

2. In the pulldown choose Database Headers

3. Right click on the header database header row. (It will be the whole number row above the x.1, x.2.... rows.)

4. In the flyout choose Edit Criteria

That will get you to the GUI.

Click on the triangle again and click on Database Headers to get ride of the header row.

hth

mk

Share this post


Link to post

michaelk,

yes, that was the problem. I tried to enter the command directly into the cell when I needed to use the database header row.

I noticed another problem. I read about it previously in a thread, but couldn't find it this time.

The door schedule has a quantity column. If it shows more than 1 item, the width or height column multiples the door width by the quantity. I used the "/C4" operand at the end of the equation so the Width column now reads "=((Door.Width)/C4)" (see attached)

I thought that would divide the width by the quantity and correctly display the width for a single window.

What is the right syntax to get the correct width?

Share this post


Link to post

michaelk,

i figured it out. i dragged the "sum" button to the Width and Height columns. Now it correctly shows a single width instead of a collective width.

hopefully, this will help others who experience the same problem.

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