I’m new to Dynamo and I am trying to size the pipes based on European standards. I managed to create a list to extract the parameters I need and then export this to Excel, however I reached a dead end. The list that I am exporting contains instances of those sections of pipes, which obviously have different lengths. Is there a way to create a list that adds up those lengths of pipes which belong to a specific section and then export this? I would like my exported list to show Section numbers on a column and the total length for that section on a different column.
When designing a water service system, Revit assigns numbers to the sections of the pipe and a unique mark to each of those pipe instances (pipe tag in picture attached shows Section 1, marks 12895, 12889 and 12890 and the Lengths in mm).