Create combined schedule from two different category schedule outputs

Revit
, ,
1

Hi All, newbie question coming in again.

I have had luck exporting data from two schedules to excel, however I want to achieve the following:

Final output; a schedule which takes nett floor area of each level (room schedule) and works out the percentage of glazing for that level based off of values taken from a window schedule with calculated parameter for window area.

Instead of exporting the two schedules’ data to excel, I would like to use Dynamo to sort and list each nett floor area per level with each total window area per level in one schedule, from which I can introduce a calculated parameter to work out the percentage relationship between the two values. Is there an easy way to do this with Dynamo?

For reference, a dynamo file is attached based off of instructions followed from this video: https://youtu.be/Lb3zs2HOo34?si=ohEG3CFRj1SH3db6
This works to export any selected schedules into excel. It would be great to adapt this such that I could still select the desired schedules, but create a new combined information schedule in revit.

Any assistance would be greatly valued! Thank you.

nett-floor area test file
nett-floor area test file1524×514 114 KB

fen-nett floor test.dyn (35.8 KB)

2

What have you tried so far as to “combining” this data? I’m not sure I fully follow what you’re trying to do but if you can’t combine the two schedules in Revit then Dynamo won’t be able to do it either. You’re still limited to the functionality of Revit.

3

The best way would be to combine the data into one schedule in Revit, if possible, and just export out that one schedule to excel.

You should be able to append the data from the second schedule by setting the overwrite to false, but you would have to change that setting each time you export and you would also need to make sure the column and data structure in both schedules match each other.