Family Dimensions Formula Based Off of Number and Number Range

[Anonymous]

I'm having trouble with coming up with a formula to create dimensions based on certain numbers.

Dimensions (Length Parameter) that need the formula:

1. Depth
2. Width
3. Height

Numbers to put into the formula (Number Parameter):

1. 15
2. 30
3. 45
4. 75
5. 112.5
6. 150
7. 225
8. 300
9. 500
10. 750

The "Numbers" are options to be entered into a single parameter, which affects the 3 "Dimensions" parameters.

An example scenario:

• "Numbers" = 75
  • "Depth" = 1' 8"
  • "Height" = 2' 6"
  • "Width" = 1'-8"

[iainsavage]

You could use a lookup table?

[Anonymous]

Is there a lookup table for Revit Families? Also, I forgot to mention in the original post that this is for a Revit Generic Model Family.

[halukuzuner]

If "Numbers" are not many you can use nested if. But I would prefer lookup table. This link may help you about neted if.

https://forums.autodesk.com/t5/revit-architecture-forum/if-and-conditional-formula-help/td-p/3753452

[iainsavage]

This link might help.

Its for version 2018 but still relevant except that in newer versions, once created the lookup table is imported into the family and resides in the family rather than being kept as a separate file. There are other online resources as well.

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2018/EN...

As @halukuzuner says you could use nested if/then formulas but it becomes quite complicated if there are a lot of options.

Type catalogues are another option but for this I think a lookup table is the best way forward.

[Anonymous]

I might have to give the formula from the link a try.

[Anonymous]

I checked out the link for the lookup table. I did notice that it mentioned the lookup tables are for conduit and pipe families. Can they be used for other families as well?

[halukuzuner]

Yes you can use in every family. As far as know there is no exception.

[Anonymous]

That's good to know. I might actually try the lookup table before trying the formula from the other link.

[iainsavage]

Some more links.

Again bear in mind that in older versions the lookup table was a separate file but in newer versions the table file is imported into the family:

http://help.autodesk.com/view/RVT/2014/ENU/?guid=GUID-91270AEF-225A-49D7-BF84-1F44D1E3E216

https://revit.com.au/lookup-tables-part-1/

[iainsavage]

sample family attached