Results 1 to 4 of 4

Thread: Conditional Schedule Formulas

  1. #1
    New Member
    Join Date
    December 4, 2012
    Posts
    2
    Current Local Time
    06:32 AM

    Not allowed! Not allowed!

    Conditional Schedule Formulas

    I'm trying to create a conditional formula to reflect Occupancy Load Factors if I insert a value into my Occupancy field.
    For example I have:

    Name | Number | Area | Area per Occupant | Occupancy| Occupancy Factor |

    ROOM------1-------100-------------20-----------------B-----------------?---------------

    Is there a way I can create a formula or something where if i type in B in OCCUPANCY, it will automatically fill OCCUPANCY FACTOR with 100, and if i type in A, it'll give me a different number?

  2. #2
    Senior Member chris.macko's Avatar
    Join Date
    April 12, 2011
    Location
    Chicago, IL
    Posts
    542
    Current Local Time
    05:32 AM

    Not allowed! Not allowed!
    Where are you trying to enter this information? Is this a room schedule being used to calculate occupancy? As of right now you can't use conditional statements to test for text values in Revit formulas. I'd suggest a key schedule for this. That way you can create a preset list of occupancy types along with their associated factors and just pick them from the list in each room.

  3. #3
    New Member
    Join Date
    December 4, 2012
    Posts
    2
    Current Local Time
    06:32 AM

    Not allowed! Not allowed!
    Correct I am entering all of this into a schedule that will hopefully reflect in a Room Tag down the line.
    I'm not familiar with a key schedule?

  4. #4
    Senior Member chris.macko's Avatar
    Join Date
    April 12, 2011
    Location
    Chicago, IL
    Posts
    542
    Current Local Time
    05:32 AM

    Not allowed! Not allowed!
    Create a new room schedule, but in the first dialog that pops up, select schedule keys instead of schedule building components. You can then add data rows that will be available in the rooms. You cannot add shard parameters to key schedules though, so the tagging part is a little tricky. There are some workarounds, and I think global parameters might even make this process a little easier. Do some searching on the forum here and you'll find a few workflows. I've always just put a schedule on the sheet next to the plan and not worried about forcing more info into the tags.

Similar Threads

  1. Revit schedule formulas
    By Marcel Jansen in forum Architecture and General Revit Questions
    Replies: 5
    Last Post: May 4th, 2016, 01:41 PM
  2. can we use Family Type as conditional formatting in schedule
    By JiaQing in forum Architecture and General Revit Questions
    Replies: 6
    Last Post: April 10th, 2015, 03:24 PM
  3. Schedule field color derived from conditional formating, not showing on sheet.
    By Jumle in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: November 27th, 2012, 06:12 PM
  4. Conditional Statement Help
    By Kent in forum Architecture - Family Creation
    Replies: 4
    Last Post: February 12th, 2012, 10:07 PM
  5. Conditional Formula
    By Drew in forum Architecture - Family Creation
    Replies: 4
    Last Post: February 6th, 2012, 03:12 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
  •