In Revit, you can add gages of sheets for duct sizes to a schedule
-
First you need to make a schedule
-
Then go to your schedule and create a “Calculated Value” I name it Rect.Max.Size, as the following shown steps:
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”
-
Insert data at “SMACNAHVAC Duct Construction Standard Metal and Flexible 2ndEdition”
By creating a “Calculated Value” I name it GAGES OF SHEETS FOR DUCT SIZES, which will be as the following steps:
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:
Thanks a lot
LikeLiked by 1 person
Hi,
It’s not working for me. I am using Revit 2017.
I am having the following error message
“The following is not a valid schedule field:”Gauge 26”
LikeLike
Copy the formula from here and past it directly in Revit
LikeLike
I am having the following error message
The Following is not valid schedule field: 1′ 1″
LikeLike
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”)))))
LikeLike
The New Error message
The Following is not valid schedule field: Rect.Max.Size 13″
LikeLike
I have New Error message
The Following is not valid schedule field: Rect.Max.Size 13″
LikeLike
Please help me get duct gauge in fitting schedule as the many family types are there the above formula wont work. thank you
LikeLike
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”)))))
LikeLike
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.
LikeLike
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
LikeLike
Gauge value For round duct formula
LikeLike