Goal amount for this year: 2500 USD, Received: 2164 USD (87%)

# Thread: Problems using ROUND() function with Duct Size parameter

1. ## Problems using ROUND() function with Duct Size parameter

Hello everyone! I've currently hit a wall. Here's the scenario:

Mechanical HVAC equipment have duct opening sizes, and a lot of times the physical size of the opening is built to the 1/16" of accuracy. So for example you may have a supply duct discharge opening of 23-5/8"x16-3/16". Duct sizes are manufactured in 1/2" size increments, thus the need to try and use the ROUND() function to apply to the actual Duct Connector, rather than utilize the physical size opening. The smaller duct size is okay, it's an open flange that a sheet metal mechanic then "fits" in the opening with certain fasteners (clips, S & Drive, etc).

I am getting nothing but Inconsistent Units no matter what I try. I've referenced the "Inconsistent Units" thread and for the last half hour I've tried everything, and even test examples in my Family but I am stuck. Is there any way at all to neutralize the units so the ROUND() function can be utilized? Below is an example of what I'm trying to accomplish. Now, I've tried all types of variations with the example, but nothing is working. Everything is "inconsistent units" in the end, no matter how many ways you break it a part. It seems I may need to find a way to convert the units from fractional inches to decimal and then back to fractional inches - is this easily achieved? Thanks in advance!

-TZ

Code:
```Parameter		| Value		| Formula
----------------------------------------------------------------------
RTU_SA Drop Height	| 47 7/8"	|
RTU_SA Drop Width	| 102 1/2"	|
| 		|
DUCT_SA Drop Height	| 		| ROUNDDOWN(RTU_SA Drop Height)
DUCT_SA Drop Width	| 		| ROUNDDOWN(RTU_SA Drop Width)

----------------------------------------------------------------------
RTU_* parameter Discipline/Type is HVAC/Duct Size
DUCT_* parameter Discipline/Type is Common/Dimension or Common/Number (tried both, don't work)```

2. Post Family?

3. Here it is, without any ROUND() function parameters in place. You'll have to add to test.

4. Originally Posted by tzframpton
Here it is, without any ROUND() function parameters in place. You'll have to add to test.
Here you go. You can do it, but as you said, you need to remove the units (extra parameter), do the round, then put the units back (another parameter). I imagine you MIGHT be able to do it with a formula IN the rounddown, but i dont use Round that much, so im not sure. I would want it this way anyway, so the formulas are cleaner. Youll want to redo with Shared Parameters.

5. Well that was easy. I was one parameter away from getting this to work.

Thanks again man!! As always, much much appreciated.

-TZ

6. I always put in lots of ' /1 ' in formulas to eliminate the units and make everything numbers. Then multiply by the correct unit at the end of the formula. It does mean your formulas might be wrong if someone goes and changes the input units but it makes life easier.

#### Posting Permissions

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