INSTRUCTION FOR USING LOOKUP TABLE

A. Standard input excel file

1. Parameters commonly used in working Lookup Table

Standard unit formula:

Example 1: ND ## length ## millimeters

ND: The usual input parameter is the pipe diameter, used to look up in excel

Length: Parameter attribute

Millimeters: unit

Example 2: D1 ## length ## millimeters

D1: Parameter result returned

Length: Parameter attribute

Millimeters: unit

Standard recipe quantity:

Example 1: n ## number ## general

n: quantity

Number: unit attribute

General: because the number has no dimension, the default is general

2.Save standard file

Select the standard Save CSV (Comma delimited)

B. How to Import into Revit

Select Family Types

C. How the Lookup Table function works

a. Create a function that contains the name of the record

For example:

Text item: parameter name (optional)

Value: Required name of imported Excel table

Note that selecting Shared Parameter will help share variables when object statistics

b. Create the basic Lookup function

For example: Size_lookup (click, "C", 0 mm, D)

Size_lookup: function type

bich thep: variable name containing Excel records

"C": The parameter to look up for

0 mm: results returned when false

D: input parameter (this is ND on the Excel record table, Lookup function always defaults the input value as the second column, the first column is the ordinal number)

EN BIM VIETNAM

Free online learning channel