Hello - I am wondering if anyone can help me out with this. I am new to Dynamo, and can’t figure this routine out past a certain point. I am trying to automate Revit room areas to Excel by their department (which can be summarized by their room name). I am working on an apartment project, and want to be able to have Dynamo write to Excel a list showing each department (1 BR, 2 BR, service, etc.) - by floor - with a total area by department. And then (ideally) total them. Such as,
1 BR - 2,567 SF
2 BR - 8,070 SF
3 BR - 4,121 SF
Corridors - 3,500 SF
Total - 18,258 SF
I’ve attached a Dynamo routine where I have extracted all the rooms by level, and sorted some of their parameters, such as Name, Number, Area. But my list filtering skills are rudimentary at best . . . is there a way to extract the rooms by level, then by department, then get their areas and total them?
Rooms to Excel-01.dyn (18.2 KB)