Rectangular vs Round Duct Dimensions

[Anonymous]

I'm trying to create a single parameter that will read the largest duct dimension (regardless of rectangular or round) in a duct schedule.  Basically: Find the Greatest of Length, Width and Diameter, where some ducts have two of the three and some only have one.

So far, every time I've mixed round duct diameter based parameters with the rectangular duct dimension parameters, I get a blank box.

I'm trying to save time by not writing the same downstream formulas twice (once for round and once for rectangular ducts). I want it to work like the Hydraulic Diameter and Equivalent Diameter parameters.

Has anyone seen this before or gotten around it?

Thanks in advance!

[CADmonkey_UK_Building_Services]

You need a Tag Family that reads the 'Size' property. This is common to round and rectangular duct. At the moment yours are reading width and depth or diameter.

[Anonymous]

The Size parameter seems to have a whole new set of challenges for creating formulas.  The rectangular ducts Size parameter is formatted as LxW and the round ducts Size parameters are Dø.  Is there a way to strip those down to just numbers usable in a formula to find the largest value?  

This is for a schedule, not just a tag.

[CADmonkey_UK_Building_Services]

Try this with Schedule formalas::
1.Make a formula to derive the cross-sectional area from circular duct Diameter
2. Make another formula for Rectangular.Length & Width
3. Now you have the Surface Area the shape doesn't matter.

*edit* I may have just re-discovered the 'area' property.

[Anonymous]

I'm after the largest duct dimension.  Be it Length, Width or Diameter.  Surface Area presents the same problem for combining the areas of round ducts into the same column as the areas of rectangular ducts.

I'm trying if(Diameter > 0, Diameter, if(Length > Width, Length, Width)).  This returns a blank box for all rectangular ducts and the diameter of all the round ducts.

Is there another way to write this?

[Anonymous · Accepted solution]

I solved it.

Thanks for responses.

[mastjaso]

Care to share said solution?