Project Matrix Creation

FAQ
1

I’m stuck on this script and honestly not sure if I’m even off to the right start. The goal is to create a Project Matrix sheet that shows the total values of all units on each floor and show the sum of the total values to get the overall sq ft of all units in the building. Here I am trying to find a way to get the total sq ft of the bedroom units on the first floor. This would be continued on the sheet to represent Construction Gross Area.

I do not want the values that sum up to get the total on each level to appear on the sheet, only the totals that are a result of these values and the total that is a result of totals on each level.

I understand it may be a bit confusing in wording but I cannot find a way to describe it without sharing a photo as I am not as peppered in Dynamo as of yet. If you do know the fix through the problem, please provide a brief walkthrough as I am trying to understand the logic to the best.

Thanks

image
image1920×1364 210 KB

2

Easier is to create an excel file and make a pivot table in my opinion.
Just a few clicks and voila.

3

Would this be automated? I want to make it where all the information that is put into a project can be done across all the projects in the office.

4

Automated no, but you can have others edit the data in excel, and import that back in and update your rooms with a few exceptions, you can’t change the circumvent of the room for example.
All you have to do is export the UniqueId of the Elements to keep synchronization.
There are a few examples here on the forum, find them.
Good luck.