simple windows schedule question

[Sybil]

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

[Ariel]

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.

[Ariel]

Correction:

As mentioned in my link above, you can use the summarization icon on a maximum of 3 columns to do what you want.

[Yancka]

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.

[Hugues]

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

[Sybil]

Very clever, thanks a loPr

[Sybil]

Very clever, thanks a loPr

[Sybil]

Very clever, thanks a loPr

[Sybil]

Very clever, thanks a loPr