A2K's final winner for our Hacktober competition is Nick Halliday from EJE Architecture. Thank you again to everyone who submitted entries - we had a lot of fun reading them and we hope you all have enjoyed the helpful tips and tricks. Read Nick's tips on formulas and shared parameters & ticks in schedules for Revit.
Formulas and Shared Parameters
Many don’t know and some have never tried it before, but formulas in Revit families can take your families from average to extraordinary. Below a few different examples that I have used in the past in order to get formulas to either help improve accuracy, speed up documentation or improve the graphics of schedules.
Below is a standard door family with steel jambs typically used in high rise residential buildings.
In order to improve compliance and speed up drawing changes the 1428.1 door circulation zones have been added to the door. Using formulas, they automatically change depending on the door size (clear distance). The door has instance parameters that can be turned on and off for each door and also choose which type of zone is required.
These formulas are very long and complicated and there are quite a number of them. There are about 13 nested if statements in each of the 14 different formulas.
If the circulation zones are selected and the door width is too small an error message comes up to alert the user.
Ticks in Schedules
Yes or no parameters in schedules by default return a result of yes, no or blank if it has not been ticked yet. This is graphically not pleasing for the schedule and No can be mistaken for yes given default no is blank. Using calculated formulas can solve this with no extra effort on the user’s part. Typically, there would be a master schedule that shows every door or window in the project but is never placed on a sheet. There would then be the sheeted schedules that show a section of the master. In the sheeted schedules a calculated formula can be used to show the schedule as the below.
When the normal check box is ticketed in the master schedule or on the door family it translates to the image above for the sheeted schedules.
For extra speed and accuracy during documentation if shared parameters are used for the above visibility parameters then model elements such as the ones below can be associated so when the visibility boxes are check the model updates to show the door closure at the same time the schedule is ticked. The model/ drawings will always say the same as the schedule reducing human error.
These are just a few examples of where formulas and parameters can significantly improve the efficiency and accuracy of drawings and models.
Subscribe to our newsletter on the home page and receive more of these tips and tricks.