Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

# Thread: New Revit User - Spatial Ideas

1. Have you looked at The Revit Kid's application SAuBIM Code Calcs?

2. 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.

3. 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;

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.

4. 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.

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

6. Originally Posted by ekkonap
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.

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. 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.

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. 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 First 123456 ... Last