Duct Schedules - Grouping opposite but same sizes???

[Anonymous]

Stuck on something I would think is pretty basic.  I created a duct schedule that lists the type (rectangular, round, etc.), size (width x height), length, and area of all ductwork in my project.  The length and area fields are calculated totals, whereby the schedule gives the total length of all 20x10 ducts, the total length of all 24x10 ducts, etc.  Simple.

What I can not get is how to group together ducts that have the same dimension but who have opposite widths and heights.  For example, if my project has ductwork 18 wide by 10 high, this is listed as one line in my schedule.  But I could also have ductwork that is 10 wide by 18 high.  In effect, the same size but the two types are listed separately.  Anyone know how I can group these together so that I have a total length of 18x10 duct regardless of whether it is 18x10 or 10x18?

Thanks in advance.

[CoreyDaun · Accepted solution]

I think the best you can do is create two Calculated Parameters, but this will greatly limit formatting options.

Name:  "Greater Size"

Discipline:  HVAC

Type:  Duct Size

Formula:  " if(Height > Width, Height, Width) "

Then create another one for "Lesser Size" with the formula " if(Height > Width, Width, Height) "

[Anonymous]

Thanks for the reply.  Interesting.  I will give it a shot.

[Anonymous]

Tried it.  Works partly.  I can get the "greater" and "lesser" size parameters to work, but once I decide to sort/group per one of these two parameters, my other duct sizes are inaccurate.  In other words, the 18x10 and 10x18 ducts now group under one common type and the total length and areas do represent the total of the 18x10 and 10x18 ducts.  However, now the 24x14, 24x20, 24x24 ducts all group under one 24 duct size and show a total that is a toal of all 24 wide ducts, not the individuals.  Close.  But I seem to be missing something.

[Anonymous]

Ok.  So, needed to sort by Greater Size and then by Lesser Size and it worked.  Got me what I want.  Many thanks.