BIM and others

Hi everyone, in this post I'll try to explain a workflow to keep planning information updated within the model using Dynamo and an Excel Dashboard. The idea In Revit we have the possibility to create spaces/rooms (it depends if you're an Engineer or an Architect) and you can create schedule listing all the elements that are inside these enclosed areas. But what is you have an element like a duct that is running through multiple spaces?  First option you can split this exactly on the separation line but this is time consuming and even now, you won't be able to schedule the space information.  Second option is to split and manually apply a space share parameter: time consuming and not very useful.  So my idea is to maintain the duct as it is and use Dynamo to calculate the list of spaces and fill the shared parameter automatically. This is the script and, for now, I'm using the Mark parameter to fill this list of spaces but of course you will use a share p