I am currently working on a task that requires simplifying a structural component dimension schedule, as shown in the attached image. I want to automate the process using Dynamo to group components with identical dimensions into a single row and generate a simplified table format. For example, components like G6, G8, G13, G15 (700x700) should be grouped and displayed in one row. Could you advise on how to write a script in Dynamo to achieve this automation?
Hello,since it’s traditional Chinese and your name Tsai.I assume you come from Taiwan.I‘m from mainland China.Here’s my suggestions.
1、get all beams（大梁） and filter them by type（尺寸）；
2、after group them into each group and you can get the name of Number（编号）；
3、arrange these name（values） to strings and export to Excel.
4、Additional,if you want to make a schedule inside Revit.You need set them strings（number value to a parameter,for example annotations.And then make a schedule based on type and this parameter value.