Counting occurrences of "same lengths" within a family in a project

Counting occurrences of "same lengths" within a family in a project

Russell_Palmer
Contributor Contributor
565 Views
1 Reply
Message 1 of 2

Counting occurrences of "same lengths" within a family in a project

Russell_Palmer
Contributor
Contributor

I have a strut family containing two rods with individually adjustable lengths, nothing nested, all extrusions in same family with parameters for length, Rod 1, Rod 2. My prefab dept. would like to see one schedule counting how many rods total for all the strut in a particular area of the project are, let's say, 7" long and 15" long, etc. I'd like to keep this in Revit to place it on the shop drawing sheet in case the field wants to do the prefab. So far I have only been able to come up with one schedule containing a column for each rod length and a count for the strut that contains rods of that length which prefab will have to multiply the count by 2 to get the rod count of that length, or I have made two schedules, one for each rod in the family. This still requires prefab to add two columns together from separate schedules to get their count. What's worse, if the strut sits half on a column cap and the rods are different lengths, then that strut becomes an outlier making it another field to see and add together by prefab. My only solution is to export the parameter values to excel, import the excel spreadsheet into AutoCAD, then link the DWG into Revit. If anyone has a better idea, please share. Thank you 🙂

0 Likes
Accepted solutions (1)
566 Views
1 Reply
Reply (1)
Message 2 of 2

fabiosato
Mentor
Mentor
Accepted solution

Hello,

 

One suggestion, but may make your family bigger, is to use nested families for the struts with Shared parameter checked, so you can schedule them individually.

Fábio Sato
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

0 Likes