- Primary Menu
- Pipe2020: KYPipe Overview (Steady-State)
- Digital Pipe Fitter software: make pipe cutting templates
- Welding Formulas and Tables - T.S. Hobert
- How Revit Families Use Lookup Tables
- Formatting the Lookup Table
- Articles and Tools for The Piping Folks :-)
- Lookup Tables: A Formula for Success
- pipe elbow center calculation formula pdf/elbow center chart/pipe fitter training
The use of lookup tables for pipe and conduit fittings provide an invaluable process that we take for granted. Imagine laying out a pipe system and going through to manually set the size of every single fitting in the system. Sure, each one might only take a few seconds, but with hundreds of fittings, it adds up fast.
Then, of course, there are the multiple redesigns and resizes throughout the life of the project. Lookup tables are.
Revit uses special parameters and formulas in families to reference the lookup table information. Lookup tables let you specify multiple parameter values relative to another value without creating a separate type for each set of values.
The most common use of lookup tables is defining the various dimensions of pipe and conduit fittings based on the nominal diameter of the fitting. This relationship of the. Lookup Tables can be edited using Microsoft Excel or Notepad.
Row 1 contains the column headers for each column. Note: Lookup Table columns can be formatted for multiple parameter types, but the only types that can be used within the family are Size types. The column header for this column is always left blank.
The second column defines the lookup value, typically the nominal diameter of the element. This column is a comparative column that Revit tries to match data from the family to the data in this column. All remaining columns are lookup columns, where Revit will retrieve values based on the lookup value data in the family.
Pipe2020: KYPipe Overview (Steady-State)
If more than one lookup value is necessary, then as many columns as needed are created, shifting the lookup columns over. Revit families must use a very specific process to access and retrieve information from lookup tables. This file is then referenced through a text parameter. These two components provide the access to the information in the lookup table. Then a special formula is used to retrieve values from the lookup table.
We will take an in-depth look at each piece of the connection to understand the relationship between the file and how each piece of information is retrieved and utilized by the family. To import the Lookup Table into your family, in the Family Types dialog, click on the Manage… button along the right side of the dialog box Figure 3.
In the Manage Lookup Tables dialog, click on the Import… button. Browse to the appropriate lookup table file and click OK Figure 4.
Digital Pipe Fitter software: make pipe cutting templates
The text parameter can technically be named anything you want, but to keep consistency with out of the box families and to simplify formulas, I recommend keeping the standard name.
Then enter the name of the.
Note: The Lookup Table Name value must match the. Once the Lookup Table parameter has been filled in with the appropriate.
Welding Formulas and Tables - T.S. Hobert
Using Formulas with the Lookup Table. To translate this into English, we are telling Revit to go look in Lookup Table Name for a column called Lookup Column and return the value from that column that corresponds with Lookup Value row. If there is no match, return the value specified for Default If Not Found.
In this case, the formula for finding the value of Fitting Outside Diameter reads something like this: In Lookup Table Name refers to parameter under Text where you entered the.
If we look at our. To verify the values of multiple parameters, additional Lookup Values are added to the end of the formula and the corresponding Lookup Value Columns are added to the. Figure 8 is an example showing a family that uses multiple Lookup Values.
In this case, the formula for finding the value of Socket Bottom to Socket Bottom Run reads something like this: In Lookup Table Name refers to parameter under Text where you entered the. We can define as many parameters as necessary using the lookup table, but remember that the values are driven by the first column s.
How Revit Families Use Lookup Tables
The number of lookup values in the formula should always be equal to the number of lookup value columns in the. If your formula is only referencing a single Lookup Value, Revit will never look past the first Lookup Value column in the Lookup Table.
The parameter name in the Lookup Value columns is in no way used by Revit. We already know how beneficial they are to the pipe and conduit modeling process, saving us a few seconds with each of hundreds of instances throughout our project. Lookup tables may have originally been intended to be used only with Pipe Fittings and Conduit Fittings, but we can actually use them with any category we want!
Formatting the Lookup Table
By using the process that we have discussed for creating lookup tables and associating them with Revit families, any family that can be flexed in Revit can be controlled by lookup tables.
Some are a little more logical than others. For instance, you could add lookup tables to pipe valve families so they are sized to fit the segment in which they are placed. So how can lookup tables help your workflow?
Articles and Tools for The Piping Folks :-)
Get creative! Did I mention that lookup tables work with families that have type catalogs, too? Back February 6th, Lookup Tables: A Formula for Success The use of lookup tables for pipe and conduit fittings provide an invaluable process that we take for granted. Figure 1: Note the between each part of the column header. How Revit Families Use Lookup Tables Revit families must use a very specific process to access and retrieve information from lookup tables.
Lookup Tables: A Formula for Success
Importing and Referencing the Lookup Table To import the Lookup Table into your family, in the Family Types dialog, click on the Manage… button along the right side of the dialog box Figure 3. Figure 7 Using Multiple Lookup Values To verify the values of multiple parameters, additional Lookup Values are added to the end of the formula and the corresponding Lookup Value Columns are added to the.
Figure 9 We can define as many parameters as necessary using the lookup table, but remember that the values are driven by the first column s. Marilyn Law marilyn.