Hi everyone 
I need assistance on how to quantify the total length of model lines (or detail lines) per level in Revit using Dynamo, specifically for a faceted glass balustrade layout. The objective is to:
- Select and filter lines only from a specific level (e.g., Level 1).
- Calculate and round off the length of each line segment.
- Quantify the number of occurrences per line length (e.g., how many times a 1200mm segment appears).
- Compute the total length.
- Export all gathered data (Level, individual lengths, quantity per length, total) into Excel.
I’m looking for:
- Best-practice Dynamo node workflows (no Python if possible).
- Suggestions for clean data structure before Excel export (e.g., using List.GroupByKey or List.CountOccurrences).
- Any alternative methods or scripts that might better suit this task.
Appreciate if someone can guide or share a sample Dynamo script that works well for this kind of quantification and Excel reporting. uploaded herewith snip, Dynamo file and Revit file
24R_RAILING LINES PER LEVEL - FOR QUANTIFICATION USE - WIP.rvt (6.9 MB)
24DYN_CUTTING LIST OF LINES LENGTH AND TOTAL PER LEVEL.dyn (27.7 KB)
