Nonstandard Angles

[Anonymous]

Hi, 

 I need to prepare a Revit schedule with the all Plumbing fittings in the project. 

Due to sloped pipes I have got some non-standard elbows angles: 89 degrees or 44.

Is there any way to change the display of these elbows in schedules without remodeling in the model? 

Maybe some way to round these values? I can use some DYNAMO script if it is not too complicated. 

Thanks, 

[dmiller_SCE]

Without trying to redo the model you can attempt to use a calculated value in the schedule that rounds the angle parameter that you have.

[Anonymous]

I tried, but I have some issue with my formula. 

I need round to 90, 60, 45, 30, 22 and 15 degrees. 

I tried it by this formula: 

If(and(Elbow Angle>10, Elbow Angle<20), 15, If(and(Elbow Angle>20, Elbow Angle<25), 22, If(and(Elbow Angle>25, Elbow Angle<35), 30, If(and(Elbow Angle>40, Elbow Angle<50), 45, If(and(Elbow Angle>55, Elbow Angle<65), 60, If(and(Elbow Angle>85, Elbow Angle<95), 90, 0)

But it is not work, I still have some errors. 

[ToanDN]

Format the field units in the schedule to round to 5 degree.

[dmiller_SCE · Accepted solution]

@ToanDN  method is easier but I suggested the calculated value so that you could still see the actual angle of the elbows if needed vs. what it should be. So instead of rounding the actual field, you would round the calculated value. Either method should work for you but again @ToanDN is a more straight forward approach. 

example of rounding a calculated value to nearest 5°

round(your_angle_parameter / 5°) * 5°

[ToanDN · Accepted solution]

That's fine to have both original and rounded parameters.  Again, you can format the units of rounded parameter one instead of using a formula.

[dmiller_SCE]

You are correct with the formatting of the units but I was thinking more along the lines that if needed a more complex formula can be constructed in the calculated value.  In our example of rounding to the nearest 5 degrees may not actually work because specific angle increment is needed. If we round to 5 degrees and for some reason, a user modeled and angle of 63 degrees the angle would be rounded to 65 and not 60. I just have not had time to develop a cohesive formula to meet the needs requested. 

round to nearest 5 degrees gives values that do not fall with in specified values.

Calculated value allows a more complex formula to meet specified angels.

[dmiller_SCE · Accepted solution]

I have not actually validated your formula but you are missing parentheses at the end. Add 5 more parentheses at the end to close everything. 

If(and(Elbow Angle>10, Elbow Angle<20), 15, If(and(Elbow Angle>20, Elbow Angle<25), 22, If(and(Elbow Angle>25, Elbow Angle<35), 30, If(and(Elbow Angle>40, Elbow Angle<50), 45, If(and(Elbow Angle>55, Elbow Angle<65), 60, If(and(Elbow Angle>85, Elbow Angle<95), 90, 0))))))

[ToanDN]

Yes I didn't realized he needed 22-degree in the mix.  So using the [if(and...] formula is the correct way to go.

[Anonymous]

Thank you all. 

In this case the best solution was to add parentheses at the end (my mistake). 

But I tested the other proposal  and it is very helpful in continuing my work with schedules.