Flex Duct Schedule Grouping

[jdmwrxpower]

Hi everyone,

     I am still trying to get a handle on these schedules. I created a Flex Duct Schedule with the count, type, diameter, length, the overall size (ill remove the overall size and leave the diameter), then finally by system type. 

I have it sorted by System Type and Diameter. I also would like to sum up the count column and the lengths and separates by diameter.  

Example: 10 Flex Ducts Round 6" Diameter Total Length 100' System Type: Supply Air 

                    7 Flex Ducts Round 12" Diameter Total Length 28' System Type: Return Air 

What would be the correct way to do this? Thank you in advance

[HVAC-Novice]

Did you try the Sorting/Grouping tab features? that should enable most if not all what you want.

I'm not sure what you try to accomplish. is this for actually ordering flex duct, or what exactly? and you have 28' flex duct sections? Usually flex duct is limited t 3'or so. it is just to connect diffusers, not to do actual runs. i know it is a bit off-topic to your original question. but might be helpful to clarify what you are doing. 

[jdmwrxpower]

@HVAC-Novice 

Thank you. I'm building a large home and mechanical hvac system is done. The flex ducts used in resi off the main trunks comes up to 50' lengths. 

What I am trying to do is just get the sorting and grouping right. I had posted a photo. 

If you look at the first 4 rows the flex ducts are each 6" and each is itemized. I would like the schedule to combine those 4 rows of 6" flex and give a total length. 

[ToanDN · Accepted solution]

- Formatting tab: set Length = Calculate Totals

- Sorting/ Grouping tab: 1 - Family and Type; 2 - Diameter; untick [Itemize every instance] box

[jdmwrxpower]

@ToanDN Thank you - Only issue is the lengths columns show "varies" where I am trying to get a total length for the 6" diameter etc.

[ToanDN]

---

@jdmwrxpower wrote:

@ToanDN Thank you - Only issue is the lengths columns show "varies" where I am trying to get a total length for the 6" diameter etc.

---

Did you forget to do the 1st step?

[jdmwrxpower]

@ToanDN 

I did miss the first step. I was looking on the phone and jumped onto the PC and now I see it. Thank you for your help. The schedule is doing exactly what I wanted. I added a then-by-system type to break up supply/return/exhaust.