I need to automate a sheetmetal duct chart calulation

[poseidonsbeard]

Not sure what formula to use and my excel skills are basic. But...

Goal is to automate chart calculations using 3 inputs
Example:
If duct is (input 1)34"wide x (input 2)20"high x (input 3, may be a sum of numbers) 35' in length, 34" is greater than 30" maximum width
for 24 ga. So it must be 22 ga. 34" + 20" = 54" going across from 54" find
13.5 lb. per foot. 13.5 x 35' = 472.5 lbs.

HELP?

 

[NARAYANK991]

Hi ,

See if this is OK.

You will need to enter values in cells B3 and G3 in the data tab.

Narayan

 

[poseidonsbeard]

Thanks Narayank991,
Some of the results are #n/a and I can not subtotal the total pounds...see attached. I tried to correct it but failed miserably

 

[NARAYANK991]

Hi ,

See the file now.

Narayan