What am i doing?
Making a generative tool to find the ratio window / facade per room individually.
When I’ve completed the regular windows, I’m going to implement the curtain walls as well.
What did i achieve already?
-
Selected all windows and found the hosts of them.
-
Filtered all exterior walls (with assembly code used in our company) : to filter eventual indoor windows in a project
-
Made bounding boxes and then solids of all remaining windows.
-
Made solids of rooms in the project
(From here on the picture tells the rest of the story)
-
Intersected all solid windows with the solid rooms to get only rooms with windows in it.
-
Exploded remaining rooms to find the surface area of the wall with the window in it (via intersection of the solid windows again)
As you can see in the picture, I now have windows (as solids) with the surface containing that window for every room. Finding the area of both is no problem, I have done this in another version already.
What I need help with?
I can’t seem to find out how to link the surfaces and windows to the room ID’s (#2 in the picture). In the end I need to put the results of window/facade ratio in an excel sheet per room. Some rooms have multiple windows. I’m struggling with the list management for sure and I can’t see what I’m doing anymore.
In an attempt to come to #4 in the picture with list mapping instead of Flatten, it just gave me one result… That didn’t go as I’d hoped. (see picture 2).
I hope you guys can assist me in this one.