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. Then a special formula is used to retrieve values from the lookup table. These two components provide the access to the information in the lookup table. This file is then referenced through a text parameter. The lookup table is stored within the family through an import/export dialog. Revit families must use a very specific process to access and retrieve information from lookup tables. So, if youРІР‚в„ўre creating a tee fitting that has three different nominal diameters, one for each connection, you should have three lookup value columns to coincide these parameters.Р”Р‡igure 2: Reference Column, Lookup Value, and Lookup Columns in a Lookup Table.

If more than one lookup value is necessary, then as many columns as needed are created, shifting the lookup columns over.

All remaining columns are lookup columns, where Revit will retrieve values based on the lookup value data in the family. This column is a comparative column that Revit tries to match data from the family to the data in this column. The second column defines the lookup value, typically the nominal diameter of the element. The column header for this column is always left blank. The first column is a reference column used to designate a РІР‚СљnameРІР‚Сњ or reference for what that row in the table defines. 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. Column header formatting is ParameterName#ParameterType#ParameterUnits.Р”Р‡igure 1: Note the # between each part of the column header. Row 1 contains the column headers for each column. Lookup Tables can be edited using Microsoft Excel or Notepad.

csv file and the parameters/formulas in the family lets Revit immediately size and resize fittings based on the segments to which they are connected. 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. Lookup tables let you specify multiple parameter values relative to another value without creating a separate type for each set of values. Revit uses special parameters and formulas in families to reference the lookup table information. csv (comma separated value) files that are used in conjunction with Revit MEP families of certain categories. LetРІР‚в„ўs explore lookup tables and their relationship with AutodeskР’В® RevitР’В® families to better understand this process and its benefits. WeРІР‚в„ўre talking dozens of hours that lookup tables are saving us by automating fitting sizing. Then, of course, there are the multiple redesigns and resizes throughout the life of the project. Sure, each one might only take a few seconds, but with hundreds of fittings, it adds up fast. Imagine laying out a pipe system and going through to manually set the size of every single fitting in the system. The use of lookup tables for pipe and conduit fittings provide an invaluable process that we take for granted. Then use the trunk template on all n pipes.Back February 6th, 2014 Lookup Tables: A Formula for Success If you want four equally spaced pipes, use the Cross Joint.Р”Р‡or five or more equally spaced pipes, set Wye Angle to 180-(360/n) where n is the number of pipes. Creative Uses: This may not look like a Wye but this type of structural joint is possible with a Wye Angle greater than 90 deg.Р”Р„ 'T' joint can be made with three pipes coming together at the joint. Another way to look at it is that this angle is the amount that the legs are shifted out of alignment with the trunk pipe. This angle is half the angle between the two legs of the Wye. Wye Angle: must be a number between 0 deg. Pipe Wall: (Wall Thickness) must be a positive number, less than half Pipe OD Pipe OD: (Outside Diameter) must be a positive number Joint Name: name of this joint which is unique to this project or currently opened joints Note that because one of the branch pipes is flipped over to form the joint, the triangle and diamond alignment marks will also need to be swapped when aligning that second branch. Two templates are generated, a trunk template for the main trunk pipe and a branch template that is to be used twice, once for each branch, as both branches are cut identically. A Wye Joint is the intersection of the ends of three pipes to create a 'Y' shape (also know as a bifurcation).

Digital pipe fitter formulas