![\"\"](\"https:\/\/www.xrev.com.au\/news\/wp-content\/uploads\/2013\/12\/Fantech-Adjustable-Pitch-Axial-Flow-Fan.png\" "\\"Adjustable")
<\/a>Adjustable Pitch Axial Flow Fan<\/p><\/div>\n
Sure I could have just generated a type catalog of the sizes, but then what’s to stop the end user going into the type and instance parameters and changing values, which may created unavailable combinations or worse, break the family because of invalid sizing combinations…<\/p>\n
Solution: Conditional Statements<\/strong><\/p>\n For those who have attended some of my RTC presentations you may have your own copy of my nested If Statement generator which I created in Excel as I have given it away to some attendees. \u00a0Below is an image of what it is. \u00a0Its not that complicated, just some concatenate formulas nested into each other…<\/p>\n Excel Revit IF Statement Generator<\/p><\/div>\n The big advantage is it doesn’t matter how many you nest into each other, just grab the bottom line and paste into Revit.<\/p>\n Revit Limitations<\/strong><\/p>\n To tell the truth the previous maximum IF Statements I’ve tried is around 200, this time there were nearly 700, and many different parameters each requiring a formula of this complexity. \u00a0 What I found was Revit would crash at around 580 conditional statements in a single formula… \u00a0Surely Autodesk should know someone would try and do this, lol!<\/p>\n So how to get around this limitation, my first thought was to try and use “And” and “OR” conditions to try and reduce the number of required conditions. \u00a0However, this was going to be extremely tedious and there would still be 168+… \u00a0So then I decided to simply split across a couple of parameters. \u00a0EG: I had 500 conditions in one parameter then linked to a different parameter with the remaining conditions. \u00a0SOLVED!<\/p>\n Revit Formulas<\/p><\/div>\n I did note a large performance hit when changing parameters in the family editor. \u00a0Changing any values would take 5-15 seconds. \u00a0However, testing in a project and the changes are instant! \u00a0So not sure why performance is fine in a project.<\/p>\n I still created a type catalog of all 672 types to make it quick and easily to select the appropriate model.<\/p>\n I hope someone finds this useful!<\/p>\n","protected":false},"excerpt":{"rendered":" So last week I was tasked with create a duct mounted adjustable pitch axial flow fan. \u00a0I was told there were 672 variations permissable and provided a spreadsheet of sizes and a diagram explaining how it matched up. Sure I … Continue reading <\/a><\/a>