Sybil Posted September 15, 2008 Share Posted September 15, 2008 (edited) Window's schedule lists ALL windows. I only want to list each window once, when I use the sum tool it seems to work. However, when you look at the new schedule it seems to add up all the window widths. Please Help. See attached: Edited September 15, 2008 by Sybil Quote Link to comment
Ariel Posted September 15, 2008 Share Posted September 15, 2008 Had a similar problem several months back: http://techboard.vectorworks.net/ubbthreads/ubbthreads.php?ubb=showflat&Main=17796&Number=97842#Post97842 I don't believe even VW 2009 has a fix. Quote Link to comment
Ariel Posted September 15, 2008 Share Posted September 15, 2008 Correction: As mentioned in my link above, you can use the summarization icon on a maximum of 3 columns to do what you want. Quote Link to comment
Yancka Posted September 16, 2008 Share Posted September 16, 2008 Then you have to create simple worksheet without database. I think you can't list each type of window once with database. Example from my practice. Windows are symbols, no prefix, label looks like "W-02". B4 cell is W-01. C4 is =COUNT(INSYMBOL & (L='1st_floor_plan') & (Window.IDLabel=$B4)) D4 is =COUNT(INSYMBOL & (L='2nd_floor_plan') & (Window.IDLabel=$B4)) E4 is =COUNT(INSYMBOL & (L='3rd_floor_plan') & (Window.IDLabel=$B4)) F4 is =SUM(C4..E4) Hope this helps. Quote Link to comment
Vectorworks, Inc Employee Hugues Posted September 16, 2008 Vectorworks, Inc Employee Share Posted September 16, 2008 As Ariel mentioned, you can place a SUM icon on the column where you don't want the numbers to add up. But you can only use a maximun of 3 SUMs in a database. If you run out of SUMs, the workaround is to add a quantity column at the end of your worksheet, enter the formula =COUNT. Now you can use a reference to this column to divide the columns where you want to eliminate the summation. With H being the quantity column, the formula in your windows width column could then look like this: =(Window.OverallWidth)/H4 Quote Link to comment
Sybil Posted September 16, 2008 Author Share Posted September 16, 2008 Very clever, thanks a loPr Quote Link to comment
Sybil Posted September 16, 2008 Author Share Posted September 16, 2008 Very clever, thanks a loPr Quote Link to comment
Sybil Posted September 16, 2008 Author Share Posted September 16, 2008 Very clever, thanks a loPr Quote Link to comment
Sybil Posted September 16, 2008 Author Share Posted September 16, 2008 Very clever, thanks a loPr 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.