Using a lookup table with a system family

[ArynBergman]

I need to create a cable tray system family where a part number changes depending on the height and width for the cable tray runs.  I can do this easily for the fittings using lookup table, but I can't seem to find anything for the cable tray runs.  Is there some type of lookup table system for System families?  If not, is there a way to assign a part number parameter to a cable tray system family and have it changed based upon the height and/or width?

Thanks!

[CoreyDaun · Accepted solution]

There's not too much you can do here - System Families do not employ lookup tables. I believe that the best you could do is to report the catalog number with a Calculated Value in a Cable Tray Schedule. Include the fields "Height" and "Width" (you can hide them if you don't want them showing) and then create a Calculated Value (Text).

The formula will be a little complicated, as it will have to account for every possible model number with a separate condition and text string. Below is an example:

if(and(Height = 0'  6", Width = 0'  6"), "CT66",if(and(Height = 0'  6", Width = 0'  8"), "CT68", if(and(Height = 0'  6", Width = 0'  10"), "CT610", "CT612")))

This formula checks for each size available (in this example, only 6"x6", 6"x8", and 6"x10") and returns the specified string. If the Cable Tray doesn't meet any of the conditions, it will default to the last text string (highlighted in red).

Don't hesitate to ask if any of this is unclear or you otherwise would like more help.

**Note that these consecutive IF/THEN/ELSE conditional statements are only required because it is not currently possible in Revit to combine two or more text strings into one.

[ArynBergman · Accepted solution]

That's too bad.  I'm sure those formulas would work, but I would have to build them for a whole lot of families.  I think what I'll do is just export the cable tray runs to a spreadsheet and then apply similiar logic there and import the data back in throught the Parameter Transformer tool.

Thanks! 

[zeralot]

Thanks for posting this formula.

I managed to modify it to report an Item No. for every possible pipe T variation. 

It's about half a page long but it works. 🙂 

[Samir_emam]

Kindly check Electrical Power Cable Add-ins from following links:-

https://apps.autodesk.com/RVT/en/Detail/Index?id=2870984389903401467&appLang=en&os=Win64

and pro product

https://apps.autodesk.com/RVT/en/Detail/Index?id=8817589469754836824&appLang=en&os=Win64