Here’s my take on what i would have done for that particular scenario.
- Get all elements in particular MEP system. Since they all all connected to a single MEP system
- Get the first element, which is for your case, either the tallest element (assuming it is gravity feed), or you can just mark it in some parameter if it is too complicated
- Use the connector manager of the first element to find its connector and check which connector it is connected to. From here you will find your second element.
- Repeat step 3 until all element in that particular MEP system is covered, and vola, you will have all the element in sequential order.
- In between step 3 & 4, you can add whatever automation or code compliant checker requirements to your code.
By doing so, we wouldnt need to export it to excel at all and thus reducing any potential error across the way