Page 2 of 10 FirstFirst 123456 ... LastLast
Results 11 to 20 of 99
Like Tree35Likes

Thread: New Revit User - Spatial Ideas

  1. #11
    Mr. Revit OpEd
    Join Date
    December 14, 2010
    Posts
    2,830
    Current Local Time
    03:42 PM
    Have you looked at The Revit Kid's application SAuBIM Code Calcs?

  2. #12
    Moderator cellophane's Avatar
    Join Date
    August 9, 2011
    Location
    Louisville, KY
    Posts
    6,055
    Current Local Time
    06:42 PM
    I'm pretty sure the calculation can be achieved. In Excel it is: =IF($C$4<=200,1,IF($C$4<=400,2,3+INT($C$4/700))) C4 is the occupancy.

    Something along these lines should work in Revit:
    if(Occupancy(not(>200)),1,if(Occupancy(not(>400)2, 3+(Occupancy/700))))

    I got the excel help here: Plumbing fixture calculations Spreadsheet is attached.

    I'm also attaching the code schedules I have. I honestly don't remember where I got them but they work pretty well.
    Attached Files Attached Files
    Ning Zhou and cganiere like this.

  3. #13
    Forum Addict GMcDowellJr's Avatar
    Join Date
    December 21, 2010
    Location
    Phoenix, AZ
    Posts
    2,514
    Current Local Time
    03:42 PM
    You're absolutely right about the uses that deine fixture count on something other than area (number of rooms, cells, etc.).

    For those uses that define fixture count through "shelves" (as you put it) I think you can. Check out this formula and see what you think;

    if(Business Group, if(not(Occupant Load Total/2>50),(Occupant Load Total/2)/(WC Male Key / 2), 50/(WC Male Key / 2)+ (Occupant Load Total/2-50)/WC Male Key),(Occupant Load Total/2)/WC Male Key)

    The Business Group parameter is a Yes/No that is defined in a Plumbing Key Schedule. Ideally I'd pull a logical off the text of the group name but of course we can't do that.

    A few more nested if/thens for the other shelved uses (A4 and A5 in the 2012 IBC) and you're home free.

    Doesn't solve the other issues but one step closer maybe!

    I still use dummy schedules that pull information from a manually updated/entered Generic Annotation but this gets the calcs done to make that update easier.
    Last edited by GMcDowellJr; September 4th, 2015 at 06:48 PM. Reason: formula edit
    cganiere likes this.

  4. #14
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    9,907
    Current Local Time
    05:42 PM
    What you are both missing is that the embedded if statements for the calculated values have to run on a room by room, or area by area basis. That isn't how the code is calculated. It's not a constant based on each room or space, it's a constant based on the total square footage of all rooms and spaces that comprise the business occupancy class. As has been discussed here many times, you cannot run calculations on totals, without using the API, or dynamo. Or manually transcribing the data as I mentioned many posts ago.

    I know how to write all of the embedded statements, I have all of the plumbing calculations, occupancy calculations, egress calculations, and more embedded in an old version of the template. The fact remains, for at least that occupancy class, it's wrong.
    cganiere likes this.

  5. #15
    Senior Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    575
    Current Local Time
    11:42 PM
    Quote Originally Posted by Twiceroadsfool View Post
    You cannot run calculations on totals, without using the API, or dynamo.
    Sure you can. Just be careful with your 'calculate totals' switch! It has a few other glitches as well.

    http://www.revitforum.org/architectu...tched-rvt.html
    Alex Cunningham and BD Mackey like this.

  6. #16
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    9,907
    Current Local Time
    05:42 PM
    Quote Originally Posted by ekkonap View Post
    Sure you can. Just be careful with your 'calculate totals' switch! It has a few other glitches as well.

    http://www.revitforum.org/architectu...tched-rvt.html
    That just lists the totals of the fields that are doing the calculations. It will not take a formula thats entered in the calculated value, and apply it directly to the total in the schedule.

  7. #17
    Senior Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    575
    Current Local Time
    11:42 PM
    Quote Originally Posted by Twiceroadsfool View Post
    That just lists the totals of the fields that are doing the calculations. It will not take a formula thats entered in the calculated value, and apply it directly to the total in the schedule.
    It's not perfect. It takes a bit of data wrestling to get what you are after, and it doesn't look anything like a regular schedule anymore. Revit starts throwing tantrums. But the math is solid. I use it to double check Dynamo calculations and user input.

    Bottom line: it can be done, but why bother. Just use Dynamo and get on with it.

  8. #18
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    9,907
    Current Local Time
    05:42 PM
    Define *data wrestling?* if it moves manually moving one field to another, then yes it can be done. Which is what I said in my original post. But a native revit schedule can't do it with just areas and calculated values. If you have one that you think does that, post it. Then I'll fill it in and I'll show you why it's wrong with IBC in the USA.

  9. #19
    Senior Member ekkonap's Avatar
    Join Date
    May 23, 2011
    Location
    Netherlands
    Posts
    575
    Current Local Time
    11:42 PM
    Quote Originally Posted by Twiceroadsfool View Post
    If you have one that you think does that, post it.
    Don't worry, I'm all for sharing. It's the explaining part I don't always find the time for. I stumbled upon this trick a few months back and have been building on it since. As I said, it is a bit flaky presentationwise, so it does not make sense to use it in all cases where it can be used.

    It does not involve a manual copy, although that means the schedule will show every unique parameter value for parameters that get summed, and Revits schedule filters pretend to have a nosebleed once a totaled value is entered into the mix. Makes sense, it needs all the values entered into the calculation to arrive at a total, so there is nothing to filter without altering the total, but that does not help in the cleaning up. As I showed in the link, even conditional formatting is shaky, UR9 did not fix that it seems.

    I certainly don't have any IBC compliant schedules laying around, as far as I know. I posted in the link what I can share right now, still working on the rest. I've got a presentation due for this stuff on thursday. I suppose I could share that once I'm done. I'm finding out the hard way that it's one thing to know that anything can be calculated, quite another to set it all up so that the presented data actually tells a coherent story. Plus 30+ coworkers clamoring for what they think has the most pressing need for impovement. They might even be right.

    And yes, to present it neatly I am resorting to some copying of parameter values. With Dynamo. The result of which I can now double check. If that IBC schedule needs to comply with some standard it will probably go down that road as well. Humans don't take well to raw data, they need information.

    'Revit can't do that!' If I got a penny every time I heard that...or for that matter Aaron, every time you heard that yourself. Still, nice to know you're willing to help me evaluate.

  10. #20
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    9,907
    Current Local Time
    05:42 PM
    So we agree: It cannot do the calculations that are required for Business Class occupancy for IBC. Thats what i thought.

    Dont get me wrong, im not discrediting what youve done... But i have it all built here too. its just that it misleads people in to thinking Revit can do it, when it cannot.

    As i said, im happy to explain why it doesnt work, when you get it done. Or heck, i can post mine and show you why they dont work. Its not a syntax thing. Its not possible when the calculation is done at the item by item level. UNLESS you copy data through some other appliance, which i said many posts ago.

Page 2 of 10 FirstFirst 123456 ... LastLast

Similar Threads

  1. Replies: 0
    Last Post: July 31st, 2014, 02:15 PM
  2. Replies: 0
    Last Post: June 27th, 2014, 05:15 AM
  3. Replies: 0
    Last Post: September 26th, 2012, 11:16 PM
  4. spatial area calculation
    By joss in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: February 9th, 2012, 10:57 PM
  5. New User Titles... Ideas please.
    By Munkholm in forum Forum Suggestions and Feedback
    Replies: 86
    Last Post: October 13th, 2011, 03:21 PM

Tags for this Thread

Posting Permissions

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