VWW Door Schedule - Summarize Quantity but NOT Dimensions

[decayny96]

When I generate a Door Schedule in VW2014 using the Door ID record and I summarize quantities of doors it also summarizes the dimensions - i.e., 10  3'-0" doors show up as 30'-0".  I don't want that - I want it to show the size [height, width and thickness] for ONE door of that type.

 

How do I achieve this?

[Pat Stanford]

Drag a second SUM tile (icon) to the columns that you don't want summed. That will then give you the average for those rows. It is up to you to make sure you are only summarizing doors with the same dimensions.

[decayny96]

Oh, that was quite easy. Thanks.

 

The other question I had was, when I use the pre-formatted VA Door Schedule in the Tool menu, I am not given the option to include symbols and PIO's.  I only have that option when I create my own new schedule in "Create Report..." Is there an easy way to edit the VA Door Schedule to do this.

 

[Tom Klaber]

Easy is relative, but you are able to add columns and call whatever data you want.   Just go to the Database header on the new column and call the data using the  =('Door'.'xxx')  - Replace the xxx with the data field you are trying to call.

 

 

[Pat Stanford]

To edit the default schedule you need to do a couple of steps.

 

1. Open the worksheet for editing.

2. Select a line in the database section of the worksheet (say 4.1)

3. Choose Database Headers from the Worksheet View Menu

4. Select the Schedule header row (e.g. 4, not 4.1, 4.2, etc.)

5. Right click in the row header

6. Choose Edit Criteria

7. Click the PIO and Symbol check boxes.

8. Click OK.

9. Unselect Database Headers from the worksheet View menu.