Add gages of sheets for duct sizes to a schedule in Revit MEP

In Revit, you can add gages of sheets for duct sizes to a schedule

  1. First you need to make a schedule

  2. Then go to your schedule and create a “Calculated Value” I name it Rect.Max.Size, as the following shown steps:

 

1

 

In the textbox next to Formula type this:

if(Width > Height, Width, Height)

 

Which means select the maximum value and drop into the column “Rect.Max.Size”

  1. Insert data at “SMACNAHVAC Duct Construction Standard Metal and Flexible 2ndEdition”

 

gauge

 

By creating a “Calculated Value” I name it GAGES OF SHEETS FOR DUCT SIZES, which will be as the following steps:

 

2

 

In the textbox next to Formula type this:

if(Rect.Max.Size < 1′ 1″, “Gauge 26″, if(and(Rect.Max.Size < 2′ 6″, Rect.Max.Size > 1′ 1”), “gauge 24″, if(and(Rect.Max.Size < 3′ 6″, Rect.Max.Size > 2′ 7”), “gauge 22″, if(and(Rect.Max.Size < 5′, Rect.Max.Size > 3′ 7”), “gauge 20″, if(and(Rect.Max.Size > 5′ 1”), “Gauge 18”, “NA”)))))

 

Which means select the maximum value and drop into the column “Rect.Max.Size”

 

The schedule will be as this:

 

34

 

 

A comment below by Engr. Sameh too important to consider, as he said, there’s a new tables should be taken, that’s why you can take above steps and practice using the new tables.

add gauge


12 thoughts on “Add gages of sheets for duct sizes to a schedule in Revit MEP

    1. Copy and past the following formula
      if(Rect.Max.Size < 13", "Gauge 26", if(and(Rect.Max.Size 13″), “gauge 24″, if(and(Rect.Max.Size 31”), “gauge 22″, if(and(Rect.Max.Size 43”), “gauge 20″, if(and(Rect.Max.Size > 61”), “Gauge 18”, “NA”)))))

      Like

    1. This as put in a Revit, Copy and past this
      if(Rect.Max.Size < 13", "Gauge 26", if(and(Rect.Max.Size 13″), “gauge 24″, if(and(Rect.Max.Size 31”), “gauge 22″, if(and(Rect.Max.Size 43”), “gauge 20″, if(and(Rect.Max.Size > 61”), “Gauge 18”, “NA”)))))

      Like

  1. Please note that as per SMACNA 3rd edition, the up tables has been declined, you should follow up the SMACNA table 1-3 thru 1-9. and you should investigate whether your duct is reinforced or not, giving this method described above, will make untrue estimation for duct construction, which eventually shall cause losses in money.

    Like

    1. Thanks for updating, I added your comment to the article to be considered, I am afraid I have no time now to update the video and article with the new tables, I will asap, you can send me the new tables to add them too. BR, Samaah

      Like

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.