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 2nd Edition”

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:

3 4

Advertisements

One thought on “Add gages of sheets for duct sizes to a schedule |Revit MEP 2016

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s