Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Difficulty with Door Exiting Formulas Rounding

18 ANTWORTEN 18
GELÖST
Antworten
Nachricht 1 von 19
Anonymous
1633 Aufrufe, 18 Antworten

Difficulty with Door Exiting Formulas Rounding

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.

18 ANTWORTEN 18
Nachricht 2 von 19
barthbradley
als Antwort auf: Anonymous

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

Nachricht 3 von 19
TripleM-Dev.net
als Antwort auf: Anonymous

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 formatFamily custom unit format    Project tag used on wallProject 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.

Nachricht 4 von 19
ToanDN
als Antwort auf: Anonymous


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

Nachricht 5 von 19
TripleM-Dev.net
als Antwort auf: TripleM-Dev.net

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

Nachricht 6 von 19
Anonymous
als Antwort auf: TripleM-Dev.net

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.

Nachricht 7 von 19
RDAOU
als Antwort auf: Anonymous

 

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

f2.png

 

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

 

f2.png

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 8 von 19
TripleM-Dev.net
als Antwort auf: Anonymous

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")

Nachricht 9 von 19
TripleM-Dev.net
als Antwort auf: RDAOU

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

Nachricht 10 von 19
RDAOU
als Antwort auf: TripleM-Dev.net


@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

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 11 von 19
Anonymous
als Antwort auf: TripleM-Dev.net

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.

Nachricht 12 von 19
Anonymous
als Antwort auf: TripleM-Dev.net

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.

Nachricht 13 von 19
RDAOU
als Antwort auf: Anonymous

@Anonymous 

 

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

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 14 von 19
Anonymous
als Antwort auf: RDAOU

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.

Nachricht 15 von 19
TripleM-Dev.net
als Antwort auf: RDAOU

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.

Nachricht 16 von 19
Anonymous
als Antwort auf: TripleM-Dev.net

Definitely not the way to go.

Nachricht 17 von 19
RDAOU
als Antwort auf: TripleM-Dev.net

@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

 

 

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 18 von 19
TripleM-Dev.net
als Antwort auf: Anonymous

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!

 

Nachricht 19 von 19
Anonymous
als Antwort auf: TripleM-Dev.net

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

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report