Wall Schedule with Windows and Doors

[Anonymous]

Hi!

I'm looking for a way to build a Wall Schedule which would also show the doors/windows present on each wall.

I tried using the Mark parameter, inputting for each wall the tag number of each door and window, but it's too much work for a big project. Is there a way to automatically show which doors or windows are on each wall?

Example: I want a schedule like this:

Wall Schedule

Type         |  Area  |  Height  |  Window  |  Door  |

Concrete  |  4 m²  |   2 m     |   W01       |  D01   |

Brick        |  6 m²  |   2 m     |    W02      |  D02   |

If anyone could help me please! Thanks 🙂

[ToanDN]

There is no direct way and automated to do it in Revit. But you can create a Dynamo script to copy the host (wall) information to the doors and windows and use it in a door/window schedule.

[Anonymous]

Hmm then it won't work for what I need. I need the type and area of the wall and then the window/door on that wall. Bc the way I have to pay my wall contractor is by discounting only windows or door areas bigger than 2 sq.m. Less than that, I pay as if it was a whole wall, with no openings.

Thanks!

[Sahay_R]

If you create a Wall schedule with an Area parameter field, it will calculate the area of the wall minus the area of doors and windows. This might help.....

[ToanDN]

Edit:  I made a mistake.  The contract wall area should be the Wall Area + the Area of Doors/Windows less than 2 sqm like in the image below.  the screencast show subtraction and it is wrong.  Revit 2017 file attached.

@Anonymous

Dynamo can help speed it up by reading the Wall ID and writing it to the Doors/Windows ID for scheduling, and potentially reading the Doors/Windows Area (with < 2 m2 filter) and writing it back to the Walls.

See screencast for a manual approach.  It's kinda long because I did it from scratch and on the fly with my thought process.

[ToanDN · Accepted solution]

Here is another approach. Put all the windows less than 2m2 in a later phase. Schedule your walls in the current phase and it should exclude those windows area.

[Anonymous]

Thank you for the screencast and all your support!!

@ToanDN

If I was modeling from zero I believe that would be the best solution, even though it's still very "manual" (would have to input each window and door area into the wall schedule - even though I could export everything to Excel and do it quick).

But since I got a finished model from the architects the last option you suggested fits my needs in a better way.

[Sahay_R]

You can add a formula driven Area parameter to the window families, and have them involved in the schedule and the calculation formula. Less manual involvement for you.