Aggregate SqFt Plans from many projects
Just wanted to solicit feedback on a proposed change to our process. I am looking at a process for aggregating scope of work Sqft from many different projects across a large firm.
The proposed workflow is each project creates a Scope of Work Area Plan for each floor and we use the calculated area to determine the total SQFT for each project.
What I think we would need to do is leverage dynamo or C# addin to copy the total sqft from all the SOW area plan areas in the model to a project level (probably shared so I know it’s our parameter) parameter. Yes I know this could be scheduled but I don’t see how I can pull the calculated total sqft from a schedule grand total to a parameter.
Anyway the idea is as the work progresses changes to size of SoW are reflected in the updates to this SoW area plan areas. In theory this would be more reliable and accurate than the marketing data the team currently has. And we could use additional parameters to divvy up the SoW into types of work (lab, sleeping areas, k12, industrial, etc).
I foresee having issues aggregating this data somewhere accessible from models hosted in Forma, users updating this data (probably falls on the BIM team realistically), and parsing out “true project” Revit files from models copied forward to support future work. I’m confident parameter work for filtering sorting grouping etc on the reporting end (probably PBI or excel).
Anyway I’m just fishing for thoughts or recommendations.