RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

70 Users Online (69 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Systems >> Technical Support >> Lookup Tables again

Search this ThreadSearch this Thread | Page 1 of 1 |

Wed, Jul 30, 2014 at 12:40:37 PM | Lookup Tables again

#1

Pikachu123


active

Joined: Thu, Dec 12, 2013
0 Posts
5 Stars: 1 Votes


Hey guys, probably mainly WWhub. =). I'm still struggling to fully comprehend the lookup table function. this is what i got so far.

1)I created a family with one type, and made all my parameters instance parameters.

2)I exported to a txt file, and openned it in excell.

3) i added the addition sizes and values for each of my parameters into the excel file.

4_ saved as a cvs file.

5)went back into my family file and imported it through manage in the types parameter window.

Created a paramter that is named "Lookup Tale Name" and filled out the value of the name of the cvs file.

Now i'm trying to make the formula to reference the excell file, but i just can't seem to get the formula down properly. i understand this far... in the formula section for the parameters i want to reference the table type--size_lookup(Lookup Table Name, "....here is where i loose it. lol.

Waht is the first section of the formula, i think its the collumn in the excell file i want to reference. so the paramter name for what value i am filling out.

and what is the structure of the formula? what is it referencing in the excell file?

or even

I have a document with an explanation of it, but there are a few terms i'm not quite sure on, can someone ellaborate for me? what is the value referencing, and how is it referencing it for "Default value if not found"? aand what is the value referencing and how for the Lookup Value", that i believe is at the end of the formula?

I think i'm close, i mean i can taste it, i just a need a little nidge in the right direction. to any and all please and thank you. it's literally bothering me at night i can't grasps this completely. lol. no but really =(.

 


This user is offline

 

Wed, Jul 30, 2014 at 2:42:29 PM | Lookup Tables again

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 388 Votes


I have never used look-up tables so I will be little help here.

But here is something that may help you:

http://www.augi.com/library/lookup-tables-a-formula-for-success


This user is offline

 

Wed, Jul 30, 2014 at 3:33:23 PM | Lookup Tables again

#3

Pikachu123


active

Joined: Thu, Dec 12, 2013
0 Posts
5 Stars: 1 Votes


Thanks though i already have that document. I'm trying to combine information from the different sources i have. i have these. But tonight i'll just give them all a good read, and i'll post backl to  this thread once i figure it out. attached is the documentation i'm going to work off of. If you get bored or w/e and want to look into with me, it will be here for ya.



This user is offline

 

Thu, Jul 31, 2014 at 1:39:28 PM | Lookup Tables again

#4

Pikachu123


active

Joined: Thu, Dec 12, 2013
0 Posts
5 Stars: 1 Votes


So i finally figure it out! This is it.

1) Create a family with reference lines,or planes. Dimension the planes, and add geometry to them, and constrain the geometry to the reference lines. Then add Paramters to the dimensions.

2)Set all the parameters to instance parameters (so they will change with only one type).

3) Go to the application button,(the big "R"), and export family types to a text file.

4)open the text file in microsoft excel. with the openning wizard window make sure you open it as a "delimited" for the first window, and select "comma" for the second, then finish.

This organizes the text file into easy to read rows and collumn of all your parameters.

5) type in additional values for your parameters.

6) save this as a "comma-delemited" file or a .CVS file in the same location as the saved family it came from.

7)Open a windows explorer and change the file extension of the .CVS file to a .TXT file.

Shadeythen go back into excell and reopen and repeate step 4-6 with the text file you just created.

***make sure everything is in the same folder.***

9)Back in the family, go to the family types window, and click "manage" where it says Lookup Tables, and import the .CVS file into the family.

10)create a new TEXT parameter called Lookup Table Name, and in the value collumn tpe(or copy/paste), the exact name of the .CVS file. This parameter we are going to use to reference in our formulas for the other parameters.

*Now this is the part that i was stuck on for a litte bit.

In the formula column of the parameter you wish to report a value from the lookup table you must type a very specific formula for Revit to know what you are trying to accomplish.

The formula looks like this:

size_lookup(Lookup Table Name, "Value 1", Value 2, (Value 3,4,etc.))

Lookup Table Name= whatever you called your text parameter, the one that reference the lookup table .CSV file

Value 1= The Coloumn you are trying to report from in the CSV file if the size changes in your family(more than likely diameter). This MUST also ALWAYS be column "B" of the excell file, that means you have to move the base value you want to control everthing else into collumn B of the excell file, (again usually diameter).

Value 2= this is the Default value that is used is if the row you designate does not have a value for it.(most likely the default Diameter parameter), but you must type the parameter name, no actual Values.

Value 3,4,5,...etc= This, or these, values provide what Row to use based on the input value, when used, so Revit knows which row to reference. This,These, values must be enclosed by parentheses. 

So when i finished with my "Total length or A" parameter's formula it looked like this:

 

size_lookup(Lookup Table Name, "Total Length or A", Diameter, (Diameter))

Its saying, " go to look up table parameter,(with the value of the actual CVS file), and look for colunm called "Total Length or A", then if it doesn't have a value reference row called Diameter, and if it Does What row do i want to reference, well Diameter preferably. Since i only needed to reference one size,my diameter, i only have one value for the fourth slot in my formula, or what i called it above, my Value 3.

11) fill out all the formulas for the parameters you want to be used by the lookup table function in this matter.

12)Load into a project and test it out!

P.S.- What i did just to double check my constraints and formula, was i made multiple types at first and change the values directly in the family type window to make sure everything was possible without the family telling, "NO!". then deleted my types when i knew everything was good, and put in the same values in the excell file.

P.P.S- Type catalogues are much easier than lookup tables. =). Type catalogues you jst make additional types and do steps 3, 4, 6, and 7. But the only thing they do is give you a choice f what types you want to load into your project.

I attatched the family i made for anyones reference, its not too pretty, but it works! lol.



This user is offline

 

Thu, Jul 31, 2014 at 1:45:45 PM | Lookup Tables again

#5

Pikachu123


active

Joined: Thu, Dec 12, 2013
0 Posts
5 Stars: 1 Votes


oopsa in all instances i said .CVS, its really .CSV. my bad kind sirs.


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Revit MEP lookup tables / csv files

Revit Systems >> Technical Support

Sun, Sep 2, 2007 at 12:27:00 PM

1

Plumbing fittings are HUGE!

Revit Systems >> Technical Support

Fri, Feb 13, 2009 at 6:18:05 PM

2

Lookup tables - looking up numbers, getting Invalid Input

Revit Systems >> Technical Support

Tue, Oct 14, 2014 at 6:49:40 AM

4

Lookup Tables

Revit Building >> Technical Support

Thu, Mar 26, 2015 at 10:19:12 AM

1

New Help with Lookup Tables on MEP

Revit Systems >> Technical Support

Tue, Aug 24, 2010 at 1:51:45 PM

1

Site Stats

Members:

1976917

Objects:

22860

Forum Posts:

152166

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.2170

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights