How to report surfaces in families within Revit and export to Excel

Hello there,

I am fairly new to Dynamo and am trying to figure out how to do this task.

I want to create an excel spreadsheet that can report the total number of surfaces on all families within a Revit project (ie. a cube will have 6 surfaces, a chair will have 500 surfaces). The point of this is to see which families have a lot of vector lines, which ultimately slows down the file if it is copied multiple times ( ie. downloading manufacturer’s families and copied).

Any help would be appreciated.

Thanks
-Kyle

Do you have a first effort?

I would consider:
Query elements.
Element.geometry.
Geometry.explode.
List.count.

I haven’t tested this but you could. It will likely take awhile time to run on bigger jobs and I’m not sure geometry is the resource hog it once was with modern hardware.

Maybe on a side note, but have you also considered using the Performance Adviser Rules for this kind of reporting?

1 Like