Results 1 to 5 of 5

Thread: Room schedule legend scheme and formulas

  1. #1
    100 Club
    Join Date
    2004-01
    Location
    London
    Posts
    115
    Login to Give a bone
    0

    Default Room schedule legend scheme and formulas

    Hi All,

    I am trying to make a color coded legend with a calculated value parameter for a room schedule. Quite nicely I have discovered calculated value cannot be used in color scheme - that s what they should be used for...especially for room!

    Project parameters dosnt seem to accept other system params in their formulas!

    Any ideas how can this be done?

    I am calculating whether some rooms exceed or not a required amount of area.

  2. #2
    AUGI Addict
    Join Date
    2015-12
    Location
    Orlando, FL
    Posts
    1,049
    Login to Give a bone
    0

    Default Re: Room schedule legend scheme and formulas

    A color scheme may not be the best choice for this task. A schedule with the room name, the room's area, and two additional columns and a conditional formatting would do the job. The two additional columns are:

    1) "Programmed area".(new parameter, area)
    2) "Complies" (calculated value, yes/no)

    The calculated value works with a formula, which compares the values of "Area" and "Programmed area" between a certain range. Then you apply conditional formatting to "Complies" to display in red background the values where the result of the formula is "No".

  3. #3
    100 Club
    Join Date
    2004-01
    Location
    London
    Posts
    115
    Login to Give a bone
    0

    Default Re: Room schedule legend scheme and formulas

    Yes I know and I already did a schedule with those parameters! The problem is I want to generate automatically a plan showing the rooms that do not comply! The problem is that I cannot use calculated values parameters to make color legend plans!!!!!

  4. #4
    AUGI Addict
    Join Date
    2015-12
    Location
    Orlando, FL
    Posts
    1,049
    Login to Give a bone
    0

    Default Re: Room schedule legend scheme and formulas

    Quote Originally Posted by kafka View Post
    Yes I know and I already did a schedule with those parameters! The problem is I want to generate automatically a plan showing the rooms that do not comply! The problem is that I cannot use calculated values parameters to make color legend plans!!!!!
    You can make a floor plan (not a Color Scheme), showing rooms that do not comply with certain conditions, using a Filter, with conditions such as " 'Area' less than..." , and turning on the Fill of rooms.

  5. #5
    100 Club
    Join Date
    2004-01
    Location
    London
    Posts
    115
    Login to Give a bone
    0

    Default Re: Room schedule legend scheme and formulas

    Yes true I didn't think about filters, but still you can't use calculated values to make view filters! The only option is to use a shared parameter for areas/rooms and use as number, but this still invoves a bit of manual input. You need to entry this parameter for all rooms that exceedes or below a certain range! This is something they need to improve definetely. Probably it can be worked out with some API I guess also.

    thanks anyway

Similar Threads

  1. Apply color scheme to room schedule
    By dlangille in forum Revit Architecture - General
    Replies: 4
    Last Post: 2018-04-09, 05:25 PM
  2. Editing Color Scheme Legend
    By MikeJarosz in forum Revit Architecture - General
    Replies: 2
    Last Post: 2012-03-22, 07:59 PM
  3. Color Scheme legends on Legend Views
    By colmag6 in forum Revit MEP - Wish List
    Replies: 0
    Last Post: 2011-09-08, 08:18 PM
  4. Color Scheme Legends - Not on Plan but still in Legend?
    By saeborne in forum Revit Architecture - General
    Replies: 1
    Last Post: 2008-10-28, 08:12 PM
  5. Reinstate Color Scheme Legend
    By kellie.adler in forum Revit Architecture - General
    Replies: 2
    Last Post: 2007-01-11, 07:44 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
  •