Something I always miss is a way to stablish relationships between schedules direct In Revit, I though a system like PowerBI model or Access relationships would be a good and intuitive way to do this.
Like in a wall schedule I could stabilish the relationship with their hosted elements like doors or windows in a way to use data from these schedules to make calculations, per example if the openings of windows are less than 2 m² here we consider this value as part of the total area of the wall, so I can make a new calculated field that get the area of the wall and sum with the area of windows with more than 2 m² of opening.
We could have nodes like Dynamo with pre-made relationships/operations between schedules wich can made the use more friendly and automated.
Bellow is a image showing what I though.
