Sky Posted August 18, 2008 Share Posted August 18, 2008 I am working on a multi-story office project and I would like to put a room schedule on the Finish Plan page that is specific just for that level. The room numbers are assigned through space objects and correspond to the different levels by hundreds, i.e. 100s for the first level, 200s for the second level, etc. Is it possible to do this by way of some formula in the Room Schedule? Quote Link to comment
brudgers Posted August 18, 2008 Share Posted August 18, 2008 Edit the criteria to limit the scheduled objects to the desired source only. For example, add a criterion that limits the source to only objects on layer mod-floor-2. Quote Link to comment
Sky Posted August 18, 2008 Author Share Posted August 18, 2008 I tried to edit the criteria from the datebase header, but a message came up that said: "This criteria cannot be edited with the Criteria Dialogue. You must edit the VectorWorks representation of the criteria using the Worksheet Formula Bar." I don't know how to add criterion by formual. Quote Link to comment
Sky Posted August 18, 2008 Author Share Posted August 18, 2008 Right now the formula is shown as: =DATABASE(Space.'On Schedule'=TRUE) Or if I'm going to use the Room Number as the criteria, that formula is: =(Space.Number) Quote Link to comment
brudgers Posted August 18, 2008 Share Posted August 18, 2008 A schedule has a header row which can be displayed or hidden by the user. There is a drop down just to the left of lable of column "A". Make sure "database headers" is checked. Notice that one row has a small rectangle at the left. Select that row and left click. Select "edit criteria." Select "more choices" Select "layer" is "mod-floor-1" Now only objects on mod-floor-1 will be listed. Quote Link to comment
Sky Posted August 18, 2008 Author Share Posted August 18, 2008 That is exactly what I am doing, but I still get that error message. Quote Link to comment
Sky Posted August 19, 2008 Author Share Posted August 19, 2008 (edited) While Edit Criteria didn't work, Set Criteria worked. At first I had trouble figuring out what criteria I needed to set beyond the Layer criteria, but I figured it out - Type Is Space. So that is all resolved - thank you very much! Now onto the second part... I can't seem to get a separate Finish Schedule on each sheet. I am using VA Create Schedule to try to place the Finish Schedule on each sheet, but it doesn't seem to want to do it. I can only get it on one sheet at a time. I tried copy and paste, but it will only take the exact schedule and repeat it so when I change the criteria on one, it changes on both... ugh... Sorry to be so needy! Edited August 19, 2008 by Sky Quote Link to comment
brudgers Posted August 19, 2008 Share Posted August 19, 2008 Duplicate the worksheet in the resource browser. Space Schedule 1 Space Schedule 2 etc. Set the appropriate criteria for each. Quote Link to comment
Sky Posted August 19, 2008 Author Share Posted August 19, 2008 That worked! Thank you, thank you!!! 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.