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

Results 1 to 6 of 6
Like Tree3Likes
  • 1 Post By Twiceroadsfool
  • 1 Post By tzframpton
  • 1 Post By josephpeel

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

  1. #1
    Forum Addict tzframpton's Avatar
    Join Date
    January 17, 2011
    Location
    Dallas, TX
    Posts
    2,027
    Current Local Time
    01:40 PM

    Question 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. #2
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    10,180
    Current Local Time
    01:40 PM
    Post Family?

  3. #3
    Forum Addict tzframpton's Avatar
    Join Date
    January 17, 2011
    Location
    Dallas, TX
    Posts
    2,027
    Current Local Time
    01:40 PM
    Here it is, without any ROUND() function parameters in place. You'll have to add to test.
    Attached Files Attached Files

  4. #4
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    10,180
    Current Local Time
    01:40 PM
    Quote Originally Posted by tzframpton View Post
    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.
    Attached Files Attached Files
    tzframpton likes this.

  5. #5
    Forum Addict tzframpton's Avatar
    Join Date
    January 17, 2011
    Location
    Dallas, TX
    Posts
    2,027
    Current Local Time
    01:40 PM
    Well that was easy. I was one parameter away from getting this to work.

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

    -TZ
    Twiceroadsfool likes this.

  6. #6
    Forum Addict josephpeel's Avatar
    Join Date
    May 3, 2012
    Posts
    1,401
    Current Local Time
    08:40 PM
    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.
    tzframpton likes this.

Similar Threads

  1. Circular Round Supply Differ & Round Duct
    By amoroso in forum MEP - General
    Replies: 8
    Last Post: September 18th, 2015, 12:26 PM
  2. How to create a Duct Accessory for Round Duct?
    By BalajiBBI2205 in forum MEP - Family Creation
    Replies: 1
    Last Post: January 21st, 2015, 12:13 PM
  3. Duct Size vs Length parameter
    By brane1012 in forum MEP - Family Creation
    Replies: 6
    Last Post: November 26th, 2014, 05:58 PM
  4. How to keep round duct flat on top - eccentric taper
    By nick_h in forum MEP - General
    Replies: 8
    Last Post: November 11th, 2013, 01:35 PM
  5. ROUND function - Inconsistant Units!
    By Barrie in forum Architecture - Family Creation
    Replies: 2
    Last Post: June 27th, 2013, 09:44 PM

Posting Permissions

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