Duct area Calculation using size and gaug filter

I want to calculate duct area by its size and gauge.
I am able to calculate total surfaces area bt not able to filter with Gauge and size 1st i want filtar by size so i can Specify Gauges after i want filter its by AHU or workset

@vikrambhaliya1 MEP Series – Bourdon Tube Safety Pressure Gauge - MGA Controls

what do you mean by that? so filter pipes by pressure ?

There is no pipe its regarding duct

@vikrambhaliya1

do you have a try in python or dynamo ? screenshots