schedules help

[John Windswept Design]

A couple of questions.

How do I separate first floor windows from second floor windows in my schedules? My numbers are w-101.... first floor w-201 second floor.

I'm trying to change the borders and shading of some cells and I try and I get a beep.

jt

[John Windswept Design]

Also my door sched is not in numeric order. How Do you do that?

[willofmaine]

To get your schedules in numeric order, click on the Database Row Header at the far left, in the cell with the little diamond in it. Then drag the little icons near the top (they're just under the formula bar) into whichever columns you want to sort by, in either ascending or descending order. The "sum" icon will consolidate all rows with the same information in the selected column into a single row (for example, if you have say ten type A windows and only need the schedule to list one of each window type). Presumably this will address both your window and door schedule questions. (This is all based on VW 2008; I assume it's the same in 2011).

Not sure about the borders and shading of cells, unless you're trying to change only some cells under a given database row header. All the rows under a database row header (designated with numbers like 2.2 instead of just 2) are controlled by the database row header directly above them (since they're the results of the database row header...).

Hope that all makes sense...

[John Windswept Design]

Wow wouldn't have guessed that one. Thanks a lot! I fixed the border and fill issue by restarting VW ;-s

I'm still trying to sort out the main floor window and the second floor window schedual thing. Any ideas?

john t

[Pat Stanford]

You are not going to be able to give different borders/shading to the different floors as long as they are in the same database row.

What you are going to have to do is edit the criteria to specify one of the layers. Do this by right/ctrl clicking in the database header row header (ie 4 not 4.1, 4.2 etc). Add a criteria to specify one layer.

Go to the next row (ie 5, not 4.1) and make it a database row. Give it the same criteria as the upper section except specify the other layer. Copy and paste all of the formulas from the first section (ie. Row 4) and paste them into the new section (ie 5).

You should now have a worksheet that will easily separate your windows on your first and second floors. Since they are separate rows, each section can have different formats. Remember, the database sub rows (4.1, 4.2, 5.3, 5.4, etc) are really only phantoms of the header row. The formatting will be the same as the header row.