Results 1 to 8 of 8

Thread: lookup table units

  1. #1
    Active Member
    Join Date
    2006-02
    Posts
    59
    Login to Give a bone
    0

    Default lookup table units

    looking for some clarification on the acceptable units that can be used in the lookup tables.

    trying to create a lookup table that looks at HP to determine Amperes. To be sure that the table was setup properly and linked and working i started with Horsepower##length##inches and Amps##length##inches with the length parameter in the family. This works fine.

    However when I switch the parameters in the familiy to the correct units hp(power) and A(current), and then modify the csv file i cannot get any combination to work without receiving the inconsistent units error box. I have tried the following with no luck.

    Horsepower##number##horsepower
    Amps##number##amperes

    and

    Horsepower##other##horsepower
    Amps##other##amperes

    the help gives no indication or explanation of when to use number or other, or if there are limitations to the availbale units to select from.

    Thanks

    -
    aj

  2. #2
    AUGI Addict truevis's Avatar
    Join Date
    2004-07
    Location
    Massachusetts, USA
    Posts
    1,191
    Login to Give a bone
    0

    Default Re: lookup table units

    Quote Originally Posted by alan.jackson View Post
    ...To be sure that the table was setup properly and linked and working i started with Horsepower##length##inches and Amps##length##inches with the length parameter in the family...
    I don't know what the right answer is, but you can get a number from a length by dividing by its unit. E.g.: HP = Horsepower/1"

    Try Horsepower##other##

    I've also found that I have to put 1 or 0 in tables and convert that parameter with a formula to yes or no in the RFA to get what I want.

  3. #3
    Active Member
    Join Date
    2006-02
    Posts
    59
    Login to Give a bone
    0

    Default Re: lookup table units

    Quote Originally Posted by truevis View Post
    I don't know what the right answer is, but you can get a number from a length by dividing by its unit. E.g.: HP = Horsepower/1"

    Try Horsepower##other##

    I've also found that I have to put 1 or 0 in tables and convert that parameter with a formula to yes or no in the RFA to get what I want.
    ha. yeah, i've used that trick before

    I was hoping i wouldn't have to go down that route. Have you used that method effectively for lookup tables?

    -
    aj

  4. #4
    I could stop if I wanted to Kevin Janik's Avatar
    Join Date
    2003-05
    Location
    Portland, OR
    Posts
    383
    Login to Give a bone
    0

    Default Re: lookup table units

    Just to ask a dumb question, are lookup tables only for MEP Families? Also from Help they seem like Type Catalogs and are listed under them in help except Type Catalogs are .TXT files and Lookup Tables seem to be .CSV files.

    Last, some people on AUGI call Key Schedules lookup tables is a few posts. The above are external and these are internal correct?

    Could people clarify my lack of terminological understanding? (That might not be a word but it spell checks!)

    Thanks in advance!

    Kevin

  5. #5
    I could stop if I wanted to Kevin Janik's Avatar
    Join Date
    2003-05
    Location
    Portland, OR
    Posts
    383
    Login to Give a bone
    0

    Default Re: lookup table units

    Any information on lookup tables?

    Kevin

  6. #6
    Active Member
    Join Date
    2006-02
    Posts
    59
    Login to Give a bone
    0

    Default Re: lookup table units

    Type Catalogs are really CSV also, saved as TXT files.

    Essentially they perform similar functions in taking a defined value and looking up associated values corresponding to that definition.

    -
    aj

  7. #7
    I could stop if I wanted to Kevin Janik's Avatar
    Join Date
    2003-05
    Location
    Portland, OR
    Posts
    383
    Login to Give a bone
    0

    Default Re: lookup table units

    Thanks for the reply!

    I am assuming they are only used in Revit MEP, correct?

    Kevin

  8. #8
    AUGI Addict truevis's Avatar
    Join Date
    2004-07
    Location
    Massachusetts, USA
    Posts
    1,191
    Login to Give a bone
    0

    Default Re: lookup table units

    Quote Originally Posted by Kevin Janik View Post
    I am assuming they are only used in Revit MEP, correct?
    Last time I checked, I could view, but not change, an already-placed family that used a lookup function in RAC.

    Workaround -- The same functionality (I think) can be done with a conditional statement. E.g:
    Code:
    Tap Thickness = if(Tap Diameter < 0' 1 1/4", 0' 1 1/16", if(Tap Diameter < 0' 2", 0' 1 5/16", if(Tap Diameter < 0' 2 1/2", 0' 1 5/8", if(Tap Diameter < 0' 3", 0' 1 5/8", if(Tap Diameter < 0' 3 1/2", 0' 1 3/4", if(Tap Diameter < 0' 5", 0' 2 1/4", 0' 3 11/16"))))))

Similar Threads

  1. 2014: Revit Lookup Table Acceptable Units - Consolidated List? / Units for ##NUMBER?
    By DMagillIII in forum Revit MEP - Families
    Replies: 2
    Last Post: 2015-01-23, 08:55 PM
  2. 2014: Inconsistent Units with Lookup Table - What Am I Doing Wrong?
    By DMagillIII in forum Revit MEP - Families
    Replies: 1
    Last Post: 2013-08-07, 07:14 PM
  3. 2013: LOOKUP TABLE PARAMETER UNITS
    By blanchardpaul in forum Revit MEP - Families
    Replies: 0
    Last Post: 2013-07-22, 04:30 PM
  4. Help! Lookup Table Possible?
    By mark.mcmullan in forum Revit MEP - Families
    Replies: 1
    Last Post: 2009-12-02, 05:27 PM
  5. HELP! ! ! W/ Lookup Table
    By TerribleTim in forum Dynamic Blocks - Technical
    Replies: 1
    Last Post: 2008-09-10, 09:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •