Results 1 to 2 of 2

Thread: Help! Lookup Table Possible?

  1. #1
    Member
    Join Date
    2009-01
    Posts
    24
    Login to Give a bone
    0

    Cool Help! Lookup Table Possible?

    Hi,

    I have created a supply fan family, with an LPHW heater battery. From various parameters, i can calculate the LPHW Flow required to heat the air, in kg/s. Now here is the tricky part...

    Is it possible to use a lookup table to determine the LPHW connection radius if it knows the LPHW flow?

    I have attached a lookup table with the correct values (not in .CSV because that is not a valid file upload type)
    eg. (Flow between 0.159kg/s and 0.298kg/s requires a 32mm pipe, and therefore connection radius should be 16mm)

    Thanks in advance for your help, i need it!
    Attached Files Attached Files

  2. #2
    Active Member
    Join Date
    2008-09
    Posts
    94
    Login to Give a bone
    0

    Default Re: Help! Lookup Table Possible?

    From what I have found, Revit's lookup table does not use ranges. It's looking for an exact match otherwise it uses the default that you give it. In your csv file for example, unless the flow parameter is exactly the "max" value that you have in column C it will use the default.

    In which case, to achieve a ranged result, use nested if then statements. This becomes ugly pretty fast, but is functional. if( A < 1, B, if( A < 2, C, if( A < 3, D,...)))

Similar Threads

  1. 2013: Family using Lookup Table -
    By alaughlin756641 in forum Revit MEP - Families
    Replies: 9
    Last Post: 2013-06-27, 07:48 PM
  2. 2012: Lookup Table Question
    By Dr._House in forum Revit MEP - General
    Replies: 3
    Last Post: 2013-01-08, 06:01 PM
  3. 2012: MEP Lookup Table - What am i doing wrong...
    By hmunsell in forum Revit - Platform
    Replies: 0
    Last Post: 2011-09-30, 07:19 PM
  4. HELP! ! ! W/ Lookup Table
    By TerribleTim in forum Dynamic Blocks - Technical
    Replies: 1
    Last Post: 2008-09-10, 09:48 PM
  5. Can someone supply me with an example of a lookup table?
    By robert.1.hall72202 in forum Dynamic Blocks - Technical
    Replies: 4
    Last Post: 2006-02-20, 06:11 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
  •