topic Re: Difficulty with Door Exiting Formulas Rounding in Revit Architecture Forum

Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 18:18:39 GMT

So I am having this major issue with the way Revit is deciding to do rounding for our Exiting Component Door Tags. For a sprinklered building, the means of egress capacity factor is 0.15. When I put 0.15 into a Revit formula it changes the number to 19/128 which is 0.1484375. This creates incorrect calculations at times and I can't seem to get the number to round up and/or I can't figure out a different fraction that won't increase the number drastically. Has anyone run into this issue and figured it out? We have a project that has 943 occupants exiting out of one door and the number is wrong. The required door width should be 141.45" and Revit is giving me 140". Even if we didn't need to round up or down, the number is still at least 1" off and that is concerning. Can anyone help? I have 2 families that I have attached. 1 is just a generic annotation and the other is a door tag. Both of them had the same formulas, but I tried to round up the generic annotation to see if anything worked.

Re: Difficulty with Door Exiting Formulas Rounding

barthbradley — Fri, 28 Feb 2020 18:51:11 GMT

You can't fix by editing parameter's units format?

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 19:53:29 GMT

Like @barthbradley mentions, isc hanging the units roundoff in the Tag enough or does the value actually needs to be a certain amount of a value (X * 0.15).... to drive the door width (or something)...

Roundoff by Units: Length of wall to display in units of 15mm (just because we can)

1600mm/15=106,666 => 107 * 15 = 1605mm

Family custom unit format Project tag used on wall

For the door tag family; I can't test it without the project file context, but try the formula below:

Width - 0' 4" => replace by => roundup(Width / 1') * 1'

looks a bit weird, but needed to get the value back to a length type

This should round the value always up to the next integer value, or replace the 1 by another factor

Hope this helps.

Michel.

Re: Difficulty with Door Exiting Formulas Rounding

ToanDN — Fri, 28 Feb 2020 19:58:05 GMT

@Anonymous wrote:

So I am having this major issue with the way Revit is deciding to do rounding for our Exiting Component Door Tags. For a sprinklered building, the means of egress capacity factor is 0.15. When I put 0.15 into a Revit formula it changes the number to 19/128 which is 0.1484375. This creates incorrect calculations at times and I can't seem to get the number to round up and/or I can't figure out a different fraction that won't increase the number drastically. Has anyone run into this issue and figured it out? We have a project that has 943 occupants exiting out of one door and the number is wrong. The required door width should be 141.45" and Revit is giving me 140". Even if we didn't need to round up or down, the number is still at least 1" off and that is concerning. Can anyone help? I have 2 families that I have attached. 1 is just a generic annotation and the other is a door tag. Both of them had the same formulas, but I tried to round up the generic annotation to see if anything worked.

Edit you labels and increase the unit's Rounding from 0 to 2 Decimal places.

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 19:59:23 GMT

Yikes, some of the post was lost.

Parameters can have a various range of expressions.

Round(x), RoundUp(x), RoundDown(x) are some of them.

Round(23.4) = 23

Round(23.5) = 24

With the RoundUp/RoundDown you can force the value to always go up or down to the nearest whole number.

In formulas take the value format into account, X = number (like 23.4) and a integer (whole number) is returned.

Michel

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 20:14:46 GMT

What seemed to work is adding ECF to the Door Tag family as a label that isn't visible. Then just have to give every door an ECF and the calculations work for the most part. Still need the value to round up from 141.45 to 142. What I really need is to round up the if/then statement, but I keep getting inconsistent units.

Re: Difficulty with Door Exiting Formulas Rounding

RDAOU — Fri, 28 Feb 2020 21:11:18 GMT

instead of Fractional Inches …. Use Decimal Inches for that label
Occupant Calc = roundup(Occupants*0.15)*1" this should round up the 141.45 to 142

For Rounding up use the following formula .... Occupant Calc = roundup(Occupants*0.15)*1"

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 20:50:09 GMT

I'm just guessing here, the 141.45 comes from a length parameter, say Lx

A. convert length to number => Lx / 1

B. apply roundup => Roundup(Lx / 1) => this gives a Integer (enough?)

C. convert back to length by multiplying by 1mm (or 1') => (Roundup(Lx / 1) / 1mm) => Length again with roundup

Formula in the tag:

if(((Occupants) * (0' 0 19/128")) > 2' 8", (((Occupants) * (0' 0 19/128"))), 2' 8")

Below works for the Units warning, but won't work for the formula I think.

The Roundup will return a whole number and not a fraction!

if(((Occupants) * Roundup((0' 0 19/128")/1') * 1') > 2' 8", (((Occupants) * Roundup((0' 0 19/128")/1') * 1')), 2' 8")

Not entirely sure how to read/convert the inches as a decimal guy, normally I would then set it to 0.15 but the 19/128 isn't accurate enough?

Does the formula below work for you, maybe easier?

if(((Occupants) * 0.15 * 1') > 2' 8", (((Occupants) * 0.15 * 1')), 2' 8")

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 21:07:03 GMT

@RDAOU,

The formula should work (could be done in one calculation).

But I think it won't work in the project, this formula should then be in the Door family itself, and the tag would read that.

The Tag can't read the Tag's family type parameter, and isn't selectable in the Labels Parameters list.

Re: Difficulty with Door Exiting Formulas Rounding

RDAOU — Fri, 28 Feb 2020 21:19:27 GMT

@TripleM-Dev.net wrote:
@RDAOU,

The formula should work (could be done in one calculation).
But I think it won't work in the project, this formula should then be in the Door family itself, and the tag would read that.

The Tag can't read the Tag's family type parameter, and isn't selectable in the Labels Parameters list.

@TripleM-Dev.net It works in the project just fine - first image right hand side is that same label in the project!

Unless he wants that label to read a shared parameter in the door family which is not a real must, he can just use it as is without complicating a simple tag and making out of it a quantum physics thesis

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 21:17:45 GMT

If I put the formula in the door family then I would have to put that in every single door family I ever make. Having it in the tag made it easier.

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 21:21:10 GMT

if(((Occupants) * 0.15 * 1") > 2' 8", (((Occupants) * 0.15 * 1")), 2' 8")

^This formula almost worked because it got the number to read 141" instead of 140". Now I just need it to get from 141" to 142" since we need the grand total of 141.45" to round up.

Re: Difficulty with Door Exiting Formulas Rounding

RDAOU — Fri, 28 Feb 2020 21:23:52 GMT

@Anonymous

Did you try out reply 7 and it didn't round up properly?!

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 21:25:33 GMT

Sorry about that. Reply 7 worked for the Generic Annotation. Now I am trying to fix the Door Tag since the Door Tag is the family we use and the Generic Annotation is old version that somehow got into my office before I started working here.

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 21:29:33 GMT

I looked into the Tag Family of @Anonymous

If would mean to fill in the occupants in the tag instance, don't think that's the way to go.

As @RDAOU says, depends on how the Project information should be stored. (BIM etc)

Would set the formula in the Label itself from the occupants number given into the door element.

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 21:33:36 GMT

Definitely not the way to go.

Re: Difficulty with Door Exiting Formulas Rounding

RDAOU — Fri, 28 Feb 2020 21:43:00 GMT

@TripleM-Dev.net

Parametric design and how you input the information (manually or automated) has nothing to do with BIM...That is a flawed perception of BIM.

@Anonymous

Reply 7 and the formula given there in applies to both Generic Tag and Door tag... it will give the same output regardless where you use it. Your issue was more in using fractional inches with rounding. Decimal Inches are more reliable in computation

Re: Difficulty with Door Exiting Formulas Rounding

TripleM-Dev.net — Fri, 28 Feb 2020 21:39:43 GMT

If there's a roundoff still needed in the (occupants * 0.15) incorperate the formula of @RDAOU into it, and see if that works.

if((roundup(Occupants * 0.15) * 1") > 2' 8", (roundup(Occupants * 0.15)* 1"), 2' 8")

Didn't test the Unit convertions!

Re: Difficulty with Door Exiting Formulas Rounding

Anonymous — Fri, 28 Feb 2020 21:48:30 GMT

That formula worked! I was just having a hard time placing the round up in the correct location.