I am attempting to export room parameters and their wall and window geometry to excel and seeking guidance.
Export Geometry From Revit To Excel.dyn (24.3 KB)
My End Goal: Use the geometry to calculate exterior wall and window areas for each room and then enter this information into a mechanical load calculation software (I’m required to use HAP which isn’t fully compatible with gbxml geometry, so I will be hand entering the sq-ft data for each room).
Problem 1: I’m using the LunchBox Room Element Collector node to pick out the boundary points and vectors, but I’m unsure how to push these values into a list that can’t be transposed correctly in excel.
Problem 2: The above would give me the 3-D boundaries (I think), is there a way to filter it so I’m only exporting exterior walls?
Problem 3: Windows – any thoughts on how to export the window geometry for each room?
Alternate Solutions: Maybe Dynamo is not the easiest solution, could there be another product that takes the gbxml file and allow me to breakout the wall and window areas for each space?
Thanks for reading! If I can get this to work, I’d like to try to then attempt to export the bounding roof and ceiling geometries for each room, but I don’t want to get ahead of myself.