{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["SRG Calculator","Round Elbows","Rectangular Elbows","Round Duct Data","Rectangular Duct Data","Round Transitions","Rectangular Transitions","Standard Sizes","Table Format","Diagrams","Air Density Factors","User Manual","Example","memory"],"not_rendered":{"images":75,"macros":1,"external_links":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"SRG Calculator","index":0,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[2,5,3,5],[2,6,3,11],[2,14,2,15],[3,14,3,15],[17,1,17,17],[18,1,18,7],[18,8,18,14],[18,15,18,17]]}
[]
[]
[{"$nulls":5},"Project Name:",{"$nulls":7},"Prepared By:"]
[{"$nulls":13},"Date:",{"$f":"TODAY()","v":"2020-01-30"}]
[]
[{"$nulls":3},"Units:",1,null,null,"Unit Design Supply Temp:",69,{"$f":"IF($E$6=2,\"°C\",\"°F\")","v":"°F"},{"$nulls":4},"For Your Records…"]
[{"$nulls":7},"Altitude:",0,{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},"Duct Material Roughness:",{"v":0.00049,"d":"0.000490"},{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},null,"Void Temp:",null,{"$f":"IF($E$6=2,\"°C\",\"°F\")","v":"°F"}]
[{"$nulls":7},"Supply Air Density =",{"v":0.07482936,"d":"0.07483"},{"$f":"IF($E$6=2,\"kg/m^3\",\"lbm/ft^3\")","v":"lbm/ft^3"}]
[{"$nulls":14},"Room Design Temp:",null,{"$f":"IF($E$6=2,\"°C\",\"°F\")","v":"°F"}]
[{"$nulls":7},"Design Static Pressure:",0.22,null,"Total Duct Pressure at Start:",0.3,{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"}]
[{"$nulls":7},"Tolerance %:",{"v":0.1,"d":"10%"},{"$nulls":5},"Insulation Thickness:",null,{"$f":"IF($E$6=2,\"mm\",\"in\")","v":"in"}]
[null,null,"Version 1.02"]
[]
[]
[]
[]
[null,"Branch 1"]
[null,"Static Pressure Calculation"]
[null,"Duct Parameter Inputs (Select From Dropdowns)",{"$nulls":6},"Calculations",{"$nulls":6},"Results"]
[null,"Section Number","Duct Length","Vol. Flow Rate","Duct Width/Diameter","Duct Height","Duct Fitting","Duct Fitting instruction","Equiv. Diameter","ASHRAE Loss Coefficient","Duct Area","Total Volumetric Flow","Duct Velocity","Fitting Loss","Friction Loss","Total Pressure","Velocity Pressure","Static Pressure"]
[null,null,{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},{"$f":"IF($E$6=2,\"l/s\",\"CFM\")","v":"CFM"},{"$f":"IF($E$6=2,\"mm\",\"in\")","v":"in"},{"$f":"IF($E$6=2,\"mm\",\"in\")","v":"in"},null,null,{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},null,{"$f":"IF($E$6=2,\"m^2\",\"ft^2\")","v":"ft^2"},{"$f":"IF($E$6=2,\"l/s\",\"CFM\")","v":"CFM"},{"$f":"IF($E$6=2,\"m/s\",\"ft/s\")","v":"ft/s"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"}]
[null,null,{"$f":"SUM(C23:C37)","v":0},{"$f":"SUM(D23:D37)","v":0},null,null,"-","-",null,null,{"$f":"SUM(K23:K37)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(INT(B23)=1,$L$10,IF(NOT(ISERROR(VLOOKUP(E17,B:P,15,FALSE))),VLOOKUP(E17,B:P,15,FALSE),\"\"))","v":{"v":0.3,"d":"0.30"}}]
[null,1.01,{"$nulls":5},{"$f":"IF(G23=\"\",\"\",IF(AND(E23<>\"\",F23<>\"\"),IFERROR(VLOOKUP(G23,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G23,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E23<>\"\",IF(F23=\"\",IF($E$6=2,E23/1000,E23),IF($E$6=2,(1.3*POWER((E23*F23),0.625)/POWER((E23+F23),0.25))/1000,(1.3*POWER((E23*F23),0.625)/POWER((E23+F23),0.25)))),\"\")","v":""},null,{"$f":"IF(I23<>\"\",IF(F23<>\"\",IF($E$6=1,(E23/12)*(F23/12),(E23/1000)*(F23/1000)),IF($E$6=1,PI()*0.25*(I23/12)^2,PI()*0.25*(I23)^2)),\"\")","v":""},{"$f":"IF(D22=0,\"\",D22)","v":""},{"$f":"IF(K23<>\"\",IF($E$6=2,L23/(ROUND(K23*(1000),1)),ROUND(L23/(K23),1)),\"\")","v":""},{"$f":"IF(M23=\"\",\"\",IF($E$6=2,0.5*J23*$I$8*M23^2,((0.5*J23*$I$8*(M23/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M23<>\"\",IF($E$6=2,(0.109136*POWER((L23/1000),1.9))/(POWER(I23,5.02))*C23*($L$7*1000),0.11*(((12*$L$7)/I23)+(68/(8.56*I23*M23)))^0.25*((12*C23)/I23)*Q23),\"\")","v":""},{"$f":"IF(N23<>\"\",P22-N23-O23,\"\")","v":""},{"$f":"IF(M23=\"\",\"\",IF($E$6=2,0.5*$I$8*M23^2,(0.5*$I$8*(M23/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(P23<>\"\",P23-Q23,\"\")","v":""}]
[null,1.02,{"$nulls":5},{"$f":"IF(G24=\"\",\"\",IF(AND(E24<>\"\",F24<>\"\"),IFERROR(VLOOKUP(G24,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G24,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E24<>\"\",IF(F24=\"\",IF($E$6=2,E24/1000,E24),IF($E$6=2,(1.3*POWER((E24*F24),0.625)/POWER((E24+F24),0.25))/1000,(1.3*POWER((E24*F24),0.625)/POWER((E24+F24),0.25)))),\"\")","v":""},null,{"$f":"IF(I24<>\"\",IF(F24<>\"\",IF($E$6=1,(E24/12)*(F24/12),(E24/1000)*(F24/1000)),IF($E$6=1,PI()*0.25*(I24/12)^2,PI()*0.25*(I24)^2)),\"\")","v":""},{"$f":"IF(AND(D24=0,E24=0),\"\",L23-D23)","v":""},{"$f":"IF(K24<>\"\",IF($E$6=2,L24/(ROUND(K24*(1000),1)),ROUND(L24/(K24),)),\"\")","v":""},{"$f":"IF(M24=\"\",\"\",IF($E$6=2,0.5*J24*$I$8*M24^2,((0.5*J24*$I$8*(M24/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M24<>\"\",IF($E$6=2,(0.109136*POWER((L24/1000),1.9))/(POWER(I24,5.02))*C24*($L$7*1000),0.11*(((12*$L$7)/I24)+(68/(8.56*I24*M24)))^0.25*((12*C24)/I24)*Q24),\"\")","v":""},{"$f":"IF(N24<>\"\",P23-N24-O24,\"\")","v":""},{"$f":"IF(M24=\"\",\"\",IF($E$6=2,0.5*$I$8*M24^2,(0.5*$I$8*(M24/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q24=\"\",\"\",P24-Q24)","v":""}]
[null,1.03,{"$nulls":5},{"$f":"IF(G25=\"\",\"\",IF(AND(E25<>\"\",F25<>\"\"),IFERROR(VLOOKUP(G25,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G25,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E25<>\"\",IF(F25=\"\",IF($E$6=2,E25/1000,E25),IF($E$6=2,(1.3*POWER((E25*F25),0.625)/POWER((E25+F25),0.25))/1000,(1.3*POWER((E25*F25),0.625)/POWER((E25+F25),0.25)))),\"\")","v":""},null,{"$f":"IF(I25<>\"\",IF(F25<>\"\",IF($E$6=1,(E25/12)*(F25/12),(E25/1000)*(F25/1000)),IF($E$6=1,PI()*0.25*(I25/12)^2,PI()*0.25*(I25)^2)),\"\")","v":""},{"$f":"IF(AND(D25=0,E25=0),\"\",L24-D24)","v":""},{"$f":"IF(K25<>\"\",IF($E$6=2,L25/(ROUND(K25*(1000),1)),ROUND(L25/(K25),)),\"\")","v":""},{"$f":"IF(M25=\"\",\"\",IF($E$6=2,0.5*J25*$I$8*M25^2,((0.5*J25*$I$8*(M25/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M25<>\"\",IF($E$6=2,(0.109136*POWER((L25/1000),1.9))/(POWER(I25,5.02))*C25*($L$7*1000),0.11*(((12*$L$7)/I25)+(68/(8.56*I25*M25)))^0.25*((12*C25)/I25)*Q25),\"\")","v":""},"",{"$f":"IF(M25=\"\",\"\",IF($E$6=2,0.5*$I$8*M25^2,(0.5*$I$8*(M25/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q25=\"\",\"\",P25-Q25)","v":""}]
[null,1.04,{"$nulls":5},{"$f":"IF(G26=\"\",\"\",IF(AND(E26<>\"\",F26<>\"\"),IFERROR(VLOOKUP(G26,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G26,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E26<>\"\",IF(F26=\"\",IF($E$6=2,E26/1000,E26),IF($E$6=2,(1.3*POWER((E26*F26),0.625)/POWER((E26+F26),0.25))/1000,(1.3*POWER((E26*F26),0.625)/POWER((E26+F26),0.25)))),\"\")","v":""},null,{"$f":"IF(I26<>\"\",IF(F26<>\"\",IF($E$6=1,(E26/12)*(F26/12),(E26/1000)*(F26/1000)),IF($E$6=1,PI()*0.25*(I26/12)^2,PI()*0.25*(I26)^2)),\"\")","v":""},"","",{"$f":"IF(M26=\"\",\"\",IF($E$6=2,0.5*J26*$I$8*M26^2,((0.5*J26*$I$8*(M26/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M26<>\"\",IF($E$6=2,(0.109136*POWER((L26/1000),1.9))/(POWER(I26,5.02))*C26*($L$7*1000),0.11*(((12*$L$7)/I26)+(68/(8.56*I26*M26)))^0.25*((12*C26)/I26)*Q26),\"\")","v":""},"",{"$f":"IF(M26=\"\",\"\",IF($E$6=2,0.5*$I$8*M26^2,(0.5*$I$8*(M26/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q26=\"\",\"\",P26-Q26)","v":""}]
[null,1.05,{"$nulls":5},{"$f":"IF(G27=\"\",\"\",IF(AND(E27<>\"\",F27<>\"\"),IFERROR(VLOOKUP(G27,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G27,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E27<>\"\",IF(F27=\"\",IF($E$6=2,E27/1000,E27),IF($E$6=2,(1.3*POWER((E27*F27),0.625)/POWER((E27+F27),0.25))/1000,(1.3*POWER((E27*F27),0.625)/POWER((E27+F27),0.25)))),\"\")","v":""},null,{"$f":"IF(I27<>\"\",IF(F27<>\"\",IF($E$6=1,(E27/12)*(F27/12),(E27/1000)*(F27/1000)),IF($E$6=1,PI()*0.25*(I27/12)^2,PI()*0.25*(I27)^2)),\"\")","v":""},"","",{"$f":"IF(M27=\"\",\"\",IF($E$6=2,0.5*J27*$I$8*M27^2,((0.5*J27*$I$8*(M27/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M27<>\"\",IF($E$6=2,(0.109136*POWER((L27/1000),1.9))/(POWER(I27,5.02))*C27*($L$7*1000),0.11*(((12*$L$7)/I27)+(68/(8.56*I27*M27)))^0.25*((12*C27)/I27)*Q27),\"\")","v":""},"",{"$f":"IF(M27=\"\",\"\",IF($E$6=2,0.5*$I$8*M27^2,(0.5*$I$8*(M27/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q27=\"\",\"\",P27-Q27)","v":""}]
[null,1.06,{"$nulls":5},{"$f":"IF(G28=\"\",\"\",IF(AND(E28<>\"\",F28<>\"\"),IFERROR(VLOOKUP(G28,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G28,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.07,{"$nulls":5},{"$f":"IF(G29=\"\",\"\",IF(AND(E29<>\"\",F29<>\"\"),IFERROR(VLOOKUP(G29,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G29,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.08,{"$nulls":5},{"$f":"IF(G30=\"\",\"\",IF(AND(E30<>\"\",F30<>\"\"),IFERROR(VLOOKUP(G30,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G30,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.09,{"$nulls":5},{"$f":"IF(G31=\"\",\"\",IF(AND(E31<>\"\",F31<>\"\"),IFERROR(VLOOKUP(G31,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G31,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,{"v":1.1,"d":"1.10"},{"$nulls":5},{"$f":"IF(G32=\"\",\"\",IF(AND(E32<>\"\",F32<>\"\"),IFERROR(VLOOKUP(G32,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G32,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.11,{"$nulls":5},{"$f":"IF(G33=\"\",\"\",IF(AND(E33<>\"\",F33<>\"\"),IFERROR(VLOOKUP(G33,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G33,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.12,{"$nulls":5},{"$f":"IF(G34=\"\",\"\",IF(AND(E34<>\"\",F34<>\"\"),IFERROR(VLOOKUP(G34,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G34,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.13,{"$nulls":5},{"$f":"IF(G35=\"\",\"\",IF(AND(E35<>\"\",F35<>\"\"),IFERROR(VLOOKUP(G35,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G35,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,{"v":1.1400000000000001,"d":"1.14"},{"$nulls":5},{"$f":"IF(G36=\"\",\"\",IF(AND(E36<>\"\",F36<>\"\"),IFERROR(VLOOKUP(G36,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G36,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[null,1.15,{"$nulls":5},{"$f":"IF(G37=\"\",\"\",IF(AND(E37<>\"\",F37<>\"\"),IFERROR(VLOOKUP(G37,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G37,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]

{"sheet":"Round Elbows","index":1,"n_rows":120,"n_cols":3,"rows_kept":120,"hidden":true}
[null,"Duct Dia (in.)","Loss Coefficient (Co)"]
["CD3-1",4,0.21]
["CD3-1",5,0.16]
["CD3-1",6,0.14]
["CD3-1",8,0.11]
["CD3-1",10,0.11]
["CD3-2",4,0.37]
["CD3-2",5,0.3]
["CD3-2",6,0.25]
["CD3-2",8,0.24]
["CD3-2",10,0.11]
["CD3-3",4,0.13]
["CD3-3",5,0.1]
["CD3-3",6,0.08]
["CD3-3",8,0.07]
["CD3-3",10,0.07]
["CD3-4",4,0.17]
["CD3-4",5,0.14]
["CD3-4",6,0.11]
["CD3-4",8,0.13]
["CD3-4",10,0.11]
["CD3-5",4,0.57]
["CD3-5",5,0.5]
["CD3-5",6,0.43]
["CD3-5",8,0.34]
["CD3-5",10,0.28]
["CD3-5",12,0.26]
["CD3-5",14,0.25]
["CD3-5",16,0.25]
["CD3-7",4,0.34]
["CD3-7",5,0.3]
["CD3-7",6,0.26]
["CD3-7",8,0.21]
["CD3-7",10,0.17]
["CD3-7",12,0.16]
["CD3-7",14,0.15]
["CD3-15",4,1.19]
["CD3-15",5,1.19]
["CD3-15",6,1.19]
["CD3-15",8,1.19]
["CD3-15",10,1.19]
["CD3-15",12,1.19]
["CD3-15",14,1.19]
["CD3-15",16,1.19]
["CD3-15",18,1.19]
["CD3-15",20,1.19]
["CD3-15",22,1.19]
["CD3-15",24,1.19]
["CD3-15",26,1.19]
["CD3-15",28,1.19]
["CD3-16",4,1.09]
["CD3-16",5,1.06]
["CD3-16",6,1.02]
["CD3-16",8,0.99]
["CD3-16",10,0.96]
["CD3-16",12,0.94]
["CD3-16",14,0.93]
["CD3-16",16,0.91]
["CD3-16",18,0.9]
["CD3-16",20,0.9]
["CD3-16",22,0.9]
["CD3-16",24,0.89]
["CD3-16",26,0.89]
["CD3-16",28,0.89]
["CD3-17",4,0.84]
["CD3-17",5,0.82]
["CD3-17",6,0.79]
["CD3-17",8,0.76]
["CD3-17",10,0.73]
["CD3-17",12,0.72]
["CD3-17",14,0.71]
["CD3-17",16,0.71]
["CD3-17",18,0.7]
["CD3-17",20,0.69]
["CD3-17",22,0.69]
["CD3-17",24,0.68]
["CD3-17",26,0.68]
["CD3-17",28,0.68]
["CD3-18",4,0.63]
["CD3-18",5,0.61]
["CD3-18",6,0.59]
["CD3-18",8,0.57]
["CD3-18",10,0.55]
["CD3-18",12,0.54]
["CD3-18",14,0.53]
["CD3-18",16,0.52]
["CD3-18",18,0.52]
["CD3-18",20,0.52]
["CD3-18",22,0.52]
["CD3-18",24,0.51]
["CD3-18",26,0.51]
["CD3-18",28,0.51]
["CD3-19",4,0.49]
["CD3-19",5,0.48]
["CD3-19",6,0.46]
["CD3-19",8,0.44]
["CD3-19",10,0.43]
["CD3-19",12,0.42]
["CD3-19",14,0.41]
["CD3-19",16,0.41]
["CD3-19",18,0.41]
["CD3-19",20,0.4]
["CD3-19",22,0.4]
["CD3-19",24,0.4]
["CD3-19",26,0.4]
["CD3-19",28,0.4]
["CD3-20",4,0.65]
["CD3-20",5,0.61]
["CD3-20",6,0.57]
["CD3-20",8,0.52]
["CD3-20",10,0.48]
["CD3-20",12,0.45]
["CD3-20",14,0.43]
["CD3-20",16,0.41]
["CD3-20",18,0.38]
["CD3-20",20,0.37]
["CD3-20",22,0.36]
["CD3-20",24,0.35]
["CD3-20",26,0.35]
["CD3-20",28,0.35]

{"sheet":"Rectangular Elbows","index":2,"n_rows":58,"n_cols":15,"rows_kept":58,"hidden":true,"merged":[[0,2,0,14]]}
[null,null,"Duct Width (in.)"]
[null,"Duct Height (in.)",4,6,8,10,12,14,16,18,20,22,24,26,28]
["CR3-1",4,0.17,0.19,0.2,0.21,0.21,0.22,0.22]
["CR3-1",6,0.15,0.17,0.19,0.2,0.2,0.21,0.21,0.21,0.22,0.22,0.22]
["CR3-1",8,0.14,0.16,0.17,0.19,0.19,0.2,0.2,0.2,0.21,0.21,0.21,0.22,0.22]
["CR3-1",10,0.14,0.15,0.16,0.17,0.18,0.19,0.2,0.2,0.2,0.2,0.21,0.21,0.21]
["CR3-1",12,0.14,0.14,0.15,0.16,0.17,0.18,0.19,0.19,0.2,0.2,0.2,0.2,0.21]
["CR3-1",14,0.15,0.14,0.15,0.15,0.16,0.17,0.18,0.19,0.19,0.19,0.2,0.2,0.2]
["CR3-1",16,0.15,0.14,0.14,0.15,0.16,0.16,0.17,0.18,0.19,0.19,0.19,0.2,0.2]
["CR3-1",18,0.16,0.14,0.14,0.14,0.15,0.16,0.17,0.17,0.18,0.18,0.19,0.19,0.19]
["CR3-6",4,1.18,1.24,1.27,1.28,1.29,1.3,1.3]
["CR3-6",6,1.13,1.18,1.23,1.25,1.27,1.28,1.29,1.29,1.29,1.3,1.3]
["CR3-6",8,1.07,1.15,1.18,1.22,1.24,1.26,1.27,1.28,1.28,1.29,1.29,1.29,1.3]
["CR3-6",10,1.03,1.11,1.16,1.18,1.21,1.24,1.25,1.26,1.27,1.28,1.28,1.28,1.29]
["CR3-6",12,0.98,1.07,1.13,1.16,1.18,1.21,1.23,1.24,1.25,1.26,1.27,1.27,1.28]
["CR3-6",14,0.95,1.04,1.1,1.14,1.16,1.18,1.21,1.22,1.24,1.25,1.26,1.26,1.27]
["CR3-6",16,0.92,1.01,1.07,1.12,1.15,1.17,1.18,1.2,1.22,1.23,1.24,1.25,1.26]
["CR3-6",18,0.91,0.98,1.05,1.09,1.13,1.15,1.17,1.18,1.2,1.22,1.23,1.24,1.25]
["CR3-9",4,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",6,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",8,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",10,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",12,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",14,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",16,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-9",18,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11,0.11]
["CR3-12",4,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",6,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",8,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",10,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",12,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",14,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",16,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-12",18,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33,0.33]
["CR3-14",4,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",6,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",8,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",10,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",12,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",14,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",16,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-14",18,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38,0.38]
["CR3-15",4,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",6,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",8,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",10,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",12,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",14,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",16,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-15",18,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
["CR3-16",4,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",6,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",8,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",10,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",12,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",14,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",16,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]
["CR3-16",18,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41,0.41]

{"sheet":"Round Duct Data","index":3,"n_rows":16,"n_cols":21,"rows_kept":16,"hidden":true,"merged":[[0,2,0,12],[0,13,0,20]]}
[null,null,"from SRG",{"$nulls":10},"from table"]
["type","instruction","label (1st variable)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","label (2nd variable on table for 2D and 3D)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","row  offset (how offset from x row)","abel (3rd variable on table for 3D)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","row offset (how offset from x row)","data sheet name","dimention","horizontal variable row (for 2D)","data starting row","fitting column","1st vertical variable column","2nd vertical veriable column (for 3D)","data starting column"]
["CD3-1","Elbow, Die Stamped, 90 Degree, r/D = 1.5","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-2","Elbow, Die Stamped, 90 Degree, r/D = 1.0","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-3","Elbow, Die Stamped, 45 Degree, r/D = 1.5","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-4","Elbow, Die Stamped, 45 Degree, r/D = 1.0","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-5","Elbow, Pleated, 90 Degree, r/D = 1.5","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-7","Elbow, Pleated, 45 Degree, r/D = 1.5","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-15","Elbow, Mitered, 90 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-16","Elbow, Mitered, 60 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-17","Elbow, Mitered, 45 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-18","Elbow, Mitered, 30 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-19","Elbow, Mitered, 22.5 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["CD3-20","Elbow, Mitered with Vanes, 90 Degree","Diameter",0,5,{"$nulls":8},"Round Elbows",1,null,2,1,2,null,3]
["SD4-1-30","Transition, Round to Round, Supply Air Systems - 30 Degree Angle","Diameter 1",1,5,"Diameter 0",0,5,1,{"$nulls":4},"Round Transitions",2,2,3,1,2,null,3]
["SD4-1-45","Transition, Round to Round, Supply Air Systems - 45 Degree Angle","Diameter 1",1,5,"Diameter 0",0,5,1,{"$nulls":4},"Round Transitions",2,2,3,1,2,null,3]

{"sheet":"Rectangular Duct Data","index":4,"n_rows":11,"n_cols":21,"rows_kept":11,"hidden":true,"merged":[[0,2,0,12],[0,13,0,20]]}
[null,null,"from SRG",{"$nulls":10},"from table"]
["fitname","instruction","label (1st variable)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","label (2nd variable on table for 2D and 3D)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","row  offset (how offset from x row)","abel (3rd variable on table for 3D)","Directionality (0 for 1st vertical, 1 for horizontal, 2 for 2nd vertical)","column ","row offset (how offset from x row)","data sheet name","dimention","horizontal variable row (for 2D)","data starting row","fitting column","1st vertical variable column","2nd vertical veriable column (for 3D)","data starting column"]
["CR3-1","Elbow, Smooth Radius without Vanes, 1.5 RR, 90 degrees","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-6","Elbow, Mitered, 90 Degrees, Without Vanes","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-9","Elbow, Mitered, 90 Degree, Single-Thickness Vanes, 1 1/2-in. Vane Spacing ","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-12","Elbow, Mitered, 90 Degree, Single-Thickness Vanes, 3 1/4-in. Vane Spacing","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-14","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 1 1/2-in. Vane Spacing","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-15","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 2 1/8-in. Vane Spacing","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["CR3-16","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 3 1/4-in. Vane Spacing","Width",0,5,"Height",1,6,0,{"$nulls":4},"Rectangular Elbows",2,2,3,1,2,null,3]
["SR4-1-30","Transition, Rectangular, Two Sides Parallel, Symmetrical, Supply Air Systems - 30 degree angle","Height 1",2,6,"Width",0,5,0,"Height 0",1,6,1,"Rectangular Transitions",3,2,3,1,2,3,4]
["SR4-1-45","Transition, Rectangular, Two Sides Parallel, Symmetrical, Supply Air Systems - 45 degree angle","Height 1",2,6,"Width",0,5,0,"Height 0",1,6,1,"Rectangular Transitions",3,2,3,1,2,3,4]

{"sheet":"Round Transitions","index":5,"n_rows":30,"n_cols":16,"rows_kept":30,"hidden":true,"merged":[[0,2,0,15]]}
[null,null,"D1 Larger dimension"]
[null,"Do",4,5,6,8,10,12,14,16,18,20,22,24,26,28]
["SD4-1-30",4,0,0.1,0.25,0.64,1.63,3.92]
["SD4-1-30",5,null,0,0.07,0.33,0.64,1.33,2.9]
["SD4-1-30",6,null,null,0,0.14,0.37,0.65,1.19,2.28]
["SD4-1-30",8,{"$nulls":3},0,0.1,0.28,0.43,0.64,1.06,1.63]
["SD4-1-30",10,{"$nulls":4},0,0.07,0.19,0.33,0.46,0.66,0.94,1.38]
["SD4-1-30",12,{"$nulls":5},0,0.05,0.14,0.25,0.37,0.5,0.65,0.89]
["SD4-1-30",14,{"$nulls":6},0,0.04,0.12,0.21,0.3,0.41,0.52,0.64]
["SD4-1-30",16,{"$nulls":7},0,0.04,0.1,0.17,0.25,0.35,0.43]
["SD4-1-30",18,{"$nulls":8},0,0.03,0.08,0.14,0.22,0.3]
["SD4-1-30",20,{"$nulls":9},0,0.03,0.07,0.12,0.19]
["SD4-1-30",22,{"$nulls":10},0,0.03,0.06,0.11]
["SD4-1-30",24,{"$nulls":11},0,0.02,0.05]
["SD4-1-30",26,{"$nulls":12},0,0.02]
["SD4-1-30",28,{"$nulls":13},0]
["SD4-1-45",4,{"v":0,"d":"0.00"},{"v":0.122,"d":"0.12"},{"v":0.305,"d":"0.31"},{"v":0.7808,"d":"0.78"},{"v":2.3634999999999997,"d":"2.36"},{"v":5.684,"d":"5.68"}]
["SD4-1-45",5,null,{"v":0,"d":"0.00"},{"v":0.0854,"d":"0.09"},{"v":0.4026,"d":"0.40"},{"v":0.7808,"d":"0.78"},{"v":1.9285,"d":"1.93"},{"v":4.205,"d":"4.21"}]
["SD4-1-45",6,null,null,{"v":0,"d":"0.00"},{"v":0.1708,"d":"0.17"},{"v":0.45139999999999997,"d":"0.45"},{"v":0.793,"d":"0.79"},{"v":1.7254999999999998,"d":"1.73"},{"v":3.3059999999999996,"d":"3.31"}]
["SD4-1-45",8,{"$nulls":3},{"v":0,"d":"0.00"},{"v":0.122,"d":"0.12"},{"v":0.3416,"d":"0.34"},{"v":0.5246,"d":"0.52"},{"v":0.9279999999999999,"d":"0.93"},{"v":1.537,"d":"1.54"},{"v":2.3634999999999997,"d":"2.36"}]
["SD4-1-45",10,{"$nulls":4},{"v":0,"d":"0.00"},{"v":0.0854,"d":"0.09"},{"v":0.2318,"d":"0.23"},{"v":0.4026,"d":"0.40"},{"v":0.667,"d":"0.67"},{"v":0.957,"d":"0.96"},{"v":1.363,"d":"1.36"},{"v":2.001,"d":"2.00"}]
["SD4-1-45",12,{"$nulls":5},{"v":0,"d":"0.00"},{"v":0.061,"d":"0.06"},{"v":0.1708,"d":"0.17"},{"v":0.305,"d":"0.31"},{"v":0.45139999999999997,"d":"0.45"},{"v":0.725,"d":"0.73"},{"v":0.9425,"d":"0.94"},{"v":1.2905,"d":"1.29"}]
["SD4-1-45",14,{"$nulls":6},{"v":0,"d":"0.00"},{"v":0.0488,"d":"0.05"},{"v":0.1464,"d":"0.15"},{"v":0.2562,"d":"0.26"},{"v":0.366,"d":"0.37"},{"v":0.5002,"d":"0.50"},{"v":0.754,"d":"0.75"},{"v":0.9279999999999999,"d":"0.93"}]
["SD4-1-45",16,{"$nulls":7},{"v":0,"d":"0.00"},{"v":0.0488,"d":"0.05"},{"v":0.122,"d":"0.12"},{"v":0.2074,"d":"0.21"},0.25,{"v":0.427,"d":"0.43"},{"v":0.6234999999999999,"d":"0.62"}]
["SD4-1-45",18,{"$nulls":8},{"v":0,"d":"0.00"},{"v":0.0366,"d":"0.04"},{"v":0.0976,"d":"0.10"},{"v":0.1708,"d":"0.17"},{"v":0.26839999999999997,"d":"0.27"},{"v":0.366,"d":"0.37"}]
["SD4-1-45",20,{"$nulls":9},{"v":0,"d":"0.00"},{"v":0.0366,"d":"0.04"},{"v":0.0854,"d":"0.09"},{"v":0.1464,"d":"0.15"},{"v":0.2318,"d":"0.23"}]
["SD4-1-45",22,{"$nulls":10},{"v":0,"d":"0.00"},{"v":0.0366,"d":"0.04"},{"v":0.0732,"d":"0.07"},{"v":0.13419999999999999,"d":"0.13"}]
["SD4-1-45",24,{"$nulls":11},{"v":0,"d":"0.00"},{"v":0.0244,"d":"0.02"},{"v":0.061,"d":"0.06"}]
["SD4-1-45",26,{"$nulls":12},{"v":0,"d":"0.00"},{"v":0.0244,"d":"0.02"}]
["SD4-1-45",28,{"$nulls":13},{"v":0,"d":"0.00"}]

{"sheet":"Rectangular Transitions","index":6,"n_rows":354,"n_cols":14,"rows_kept":354,"hidden":true,"merged":[[0,3,0,13],[2,22,2,32]]}
[{"$nulls":3},"Ho"]
[null,"W","H1",4,6,8,10,12,14,16,18,20,22,24]
["SR4-1-30",6,6,0.06]
["SR4-1-30",6,8,0.16,0.04]
["SR4-1-30",6,10,0.25,0.09,0.03]
["SR4-1-30",6,12,0.36,0.16,0.06,0.02]
["SR4-1-30",6,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",6,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",6,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",6,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",6,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",6,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",6,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",8,6,0.06]
["SR4-1-30",8,8,0.16,0.04]
["SR4-1-30",8,10,0.25,0.09,0.03]
["SR4-1-30",8,12,0.36,0.16,0.06,0.02]
["SR4-1-30",8,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",8,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",8,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",8,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",8,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",8,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",8,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",10,6,0.06]
["SR4-1-30",10,8,0.16,0.04]
["SR4-1-30",10,10,0.25,0.09,0.03]
["SR4-1-30",10,12,0.36,0.16,0.06,0.02]
["SR4-1-30",10,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",10,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",10,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",10,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",10,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",10,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",10,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",12,6,0.06]
["SR4-1-30",12,8,0.16,0.04]
["SR4-1-30",12,10,0.25,0.09,0.03]
["SR4-1-30",12,12,0.36,0.16,0.06,0.02]
["SR4-1-30",12,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",12,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",12,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",12,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",12,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",12,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",12,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",14,6,0.06]
["SR4-1-30",14,8,0.16,0.04]
["SR4-1-30",14,10,0.25,0.09,0.03]
["SR4-1-30",14,12,0.36,0.16,0.06,0.02]
["SR4-1-30",14,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",14,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",14,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",14,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",14,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",14,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",14,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",16,6,0.06]
["SR4-1-30",16,8,0.16,0.04]
["SR4-1-30",16,10,0.25,0.09,0.03]
["SR4-1-30",16,12,0.36,0.16,0.06,0.02]
["SR4-1-30",16,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",16,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",16,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",16,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",16,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",16,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",16,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",18,6,0.06]
["SR4-1-30",18,8,0.16,0.04]
["SR4-1-30",18,10,0.25,0.09,0.03]
["SR4-1-30",18,12,0.36,0.16,0.06,0.02]
["SR4-1-30",18,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",18,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",18,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",18,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",18,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",18,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",18,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",20,6,0.06]
["SR4-1-30",20,8,0.16,0.04]
["SR4-1-30",20,10,0.25,0.09,0.03]
["SR4-1-30",20,12,0.36,0.16,0.06,0.02]
["SR4-1-30",20,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",20,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",20,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",20,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",20,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",20,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",20,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",22,6,0.06]
["SR4-1-30",22,8,0.16,0.04]
["SR4-1-30",22,10,0.25,0.09,0.03]
["SR4-1-30",22,12,0.36,0.16,0.06,0.02]
["SR4-1-30",22,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",22,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",22,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",22,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",22,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",22,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",22,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",24,6,0.06]
["SR4-1-30",24,8,0.16,0.04]
["SR4-1-30",24,10,0.25,0.09,0.03]
["SR4-1-30",24,12,0.36,0.16,0.06,0.02]
["SR4-1-30",24,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",24,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",24,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",24,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",24,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",24,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",24,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",26,6,0.06]
["SR4-1-30",26,8,0.16,0.04]
["SR4-1-30",26,10,0.25,0.09,0.03]
["SR4-1-30",26,12,0.36,0.16,0.06,0.02]
["SR4-1-30",26,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",26,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",26,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",26,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",26,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",26,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",26,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",28,6,0.06]
["SR4-1-30",28,8,0.16,0.04]
["SR4-1-30",28,10,0.25,0.09,0.03]
["SR4-1-30",28,12,0.36,0.16,0.06,0.02]
["SR4-1-30",28,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",28,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",28,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",28,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",28,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",28,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",28,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",30,6,0.06]
["SR4-1-30",30,8,0.16,0.04]
["SR4-1-30",30,10,0.25,0.09,0.03]
["SR4-1-30",30,12,0.36,0.16,0.06,0.02]
["SR4-1-30",30,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",30,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",30,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",30,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",30,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",30,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",30,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",32,6,0.06]
["SR4-1-30",32,8,0.16,0.04]
["SR4-1-30",32,10,0.25,0.09,0.03]
["SR4-1-30",32,12,0.36,0.16,0.06,0.02]
["SR4-1-30",32,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",32,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",32,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",32,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",32,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",32,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",32,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",34,6,0.06]
["SR4-1-30",34,8,0.16,0.04]
["SR4-1-30",34,10,0.25,0.09,0.03]
["SR4-1-30",34,12,0.36,0.16,0.06,0.02]
["SR4-1-30",34,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",34,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",34,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",34,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",34,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",34,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",34,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-30",36,6,0.06]
["SR4-1-30",36,8,0.16,0.04]
["SR4-1-30",36,10,0.25,0.09,0.03]
["SR4-1-30",36,12,0.36,0.16,0.06,0.02]
["SR4-1-30",36,14,0.49,0.22,0.11,0.05,0.02]
["SR4-1-30",36,16,null,0.29,0.16,0.08,0.04,0.01]
["SR4-1-30",36,18,null,0.37,0.21,0.12,0.06,0.03,0.01]
["SR4-1-30",36,20,null,null,0.25,0.16,0.09,0.05,0.02,0.01]
["SR4-1-30",36,22,{"$nulls":3},0.2,0.13,0.07,0.04,0.02,0.01]
["SR4-1-30",36,24,{"$nulls":3},0.23,0.16,0.1,0.06,0.04,0.02,0.01]
["SR4-1-30",36,26,{"$nulls":4},0.19,0.13,0.08,0.05,0.03,0.02,0.01]
["SR4-1-45",6,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",6,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",6,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",6,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",6,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",6,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",6,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",6,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",6,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",6,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",6,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",8,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",8,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",8,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",8,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",8,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",8,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",8,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",8,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",8,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",8,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",8,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",10,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",10,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",10,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",10,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",10,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",10,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",10,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",10,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",10,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",10,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",10,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",12,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",12,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",12,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",12,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",12,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",12,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",12,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",12,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",12,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",12,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",12,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",14,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",14,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",14,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",14,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",14,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",14,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",14,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",14,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",14,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",14,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",14,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",16,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",16,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",16,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",16,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",16,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",16,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",16,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",16,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",16,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",16,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",16,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",18,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",18,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",18,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",18,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",18,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",18,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",18,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",18,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",18,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",18,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",18,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",20,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",20,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",20,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",20,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",20,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",20,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",20,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",20,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",20,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",20,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",20,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",22,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",22,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",22,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",22,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",22,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",22,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",22,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",22,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",22,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",22,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",22,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",24,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",24,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",24,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",24,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",24,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",24,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",24,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",24,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",24,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",24,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",24,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",26,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",26,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",26,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",26,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",26,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",26,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",26,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",26,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",26,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",26,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",26,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",28,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",28,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",28,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",28,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",28,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",28,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",28,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",28,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",28,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",28,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",28,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",30,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",30,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",30,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",30,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",30,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",30,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",30,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",30,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",30,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",30,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",30,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",32,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",32,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",32,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",32,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",32,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",32,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",32,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",32,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",32,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",32,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",32,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",34,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",34,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",34,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",34,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",34,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",34,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",34,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",34,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",34,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",34,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",34,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]
["SR4-1-45",36,6,0.09,0,0,0,0,0,0,0,0,0,0]
["SR4-1-45",36,8,0.24,0.06,0,0,0,0,0,0,0,0,0]
["SR4-1-45",36,10,0.375,0.135,0.045,0,0,0,0,0,0,0,0]
["SR4-1-45",36,12,0.54,0.24,0.09,0.03,0,0,0,0,0,0,0]
["SR4-1-45",36,14,0.735,0.33,0.165,0.07500000000000001,0.03,0,0,0,0,0,0]
["SR4-1-45",36,16,0,0.43499999999999994,0.24,0.12,0.06,0.015,0,0,0,0,0]
["SR4-1-45",36,18,0,0.5549999999999999,0.315,0.18,0.09,0.045,0.015,0,0,0,0]
["SR4-1-45",36,20,0,0,0.375,0.24,0.135,0.07500000000000001,0.03,0.015,0,0,0]
["SR4-1-45",36,22,0,0,0,0.30000000000000004,0.195,0.10500000000000001,0.06,0.03,0.015,0,0]
["SR4-1-45",36,24,0,0,0,0.34500000000000003,0.24,0.15000000000000002,0.09,0.06,0.03,0.015,0]
["SR4-1-45",36,26,0,0,0,0,0.28500000000000003,0.195,0.12,0.07500000000000001,0.045,0.03,0.015]

{"sheet":"Standard Sizes","index":7,"n_rows":17,"n_cols":7,"rows_kept":17,"hidden":true,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"IP Units",{"$nulls":3},"SI Units"]
[null,"W","H",null,null,"W","H"]
[null,6,6,null,null,200,100]
[null,8,8,null,null,250,150]
[null,10,10,null,null,300,200]
[null,12,12,null,null,400,250]
[null,14,14,null,null,500,300]
[null,16,16,null,null,600,400]
[null,18,18,null,null,800,500]
[null,20,{"$nulls":3},1000,600]
[null,22,{"$nulls":3},1200,800]
[null,24,{"$nulls":3},1400,1000]
[null,26,{"$nulls":3},1600,1200]
[null,28,{"$nulls":3},1800]
[null,30,{"$nulls":3},2000]

{"sheet":"Table Format","index":8,"n_rows":200,"n_cols":18,"rows_kept":200,"hidden":true,"merged":[[3,1,3,17],[4,1,4,7],[4,8,4,14],[4,15,4,17]]}
[]
[]
[{"$nulls":3},"Parent Branch"]
[null,"Static Pressure Calculation"]
[null,"Duct Parameter Inputs (Select From Dropdowns)",{"$nulls":6},"Calculations",{"$nulls":6},"Results"]
[null,"Section Number","Duct Length","Vol. Flow Rate","Duct Width/Diameter","Duct Height","Duct Fitting","Duct Fitting instruction","Equiv. Diameter","ASHRAE Loss Coefficient","Duct Area","Total Volumetric Flow","Duct Velocity","Fitting Loss","Friction Loss","Total Pressure","Velocity Pressure","Static Pressure"]
[null,null,{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},{"$f":"IF($E$6=2,\"l/s\",\"CFM\")","v":"CFM"},{"$f":"IF($E$6=2,\"mm\",\"in\")","v":"in"},{"$f":"IF($E$6=2,\"mm\",\"in\")","v":"in"},null,null,{"$f":"IF($E$6=2,\"m\",\"ft\")","v":"ft"},null,{"$f":"IF($E$6=2,\"m^2\",\"ft^2\")","v":"ft^2"},{"$f":"IF($E$6=2,\"l/s\",\"CFM\")","v":"CFM"},{"$f":"IF($E$6=2,\"m/s\",\"ft/s\")","v":"ft/s"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"},{"$f":"IF($E$6=2,\"Pa\",\"inWC\")","v":"inWC"}]
[null,null,{"$f":"SUM(C9:C23)","v":0},{"$f":"SUM(D9:D23)","v":0},null,null,"-","-",null,null,{"$f":"SUM(K9:K23)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(INT(B9)=1,$L$10,IF(NOT(ISERROR(VLOOKUP(E3,B:P,15,FALSE))),VLOOKUP(E3,B:P,15,FALSE),\"\"))","v":""}]
[{"$nulls":7},{"$f":"IF(G9=\"\",\"\",IF(AND(E9<>\"\",F9<>\"\"),IFERROR(VLOOKUP(G9,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G9,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E9<>\"\",IF(F9=\"\",IF($E$6=2,E9/1000,E9),IF($E$6=2,(1.3*POWER((E9*F9),0.625)/POWER((E9+F9),0.25))/1000,(1.3*POWER((E9*F9),0.625)/POWER((E9+F9),0.25)))),\"\")","v":""},null,{"$f":"IF(I9<>\"\",IF(F9<>\"\",IF($E$6=1,(E9/12)*(F9/12),(E9/1000)*(F9/1000)),IF($E$6=1,PI()*0.25*(I9/12)^2,PI()*0.25*(I9)^2)),\"\")","v":""},{"$f":"IF(D8=0,\"\",D8)","v":""},{"$f":"IF(K9<>\"\",IF($E$6=2,L9/(ROUND(K9*(1000),1)),ROUND(L9/(K9),1)),\"\")","v":""},{"$f":"IF(M9=\"\",\"\",IF($E$6=2,0.5*J9*$I$8*M9^2,((0.5*J9*$I$8*(M9/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M9<>\"\",IF($E$6=2,(0.109136*POWER((L9/1000),1.9))/(POWER(I9,5.02))*C9*($L$7*1000),0.11*(((12*$L$7)/I9)+(68/(8.56*I9*M9)))^0.25*((12*C9)/I9)*Q9),\"\")","v":""},{"$f":"IF(N9<>\"\",P8-N9-O9,\"\")","v":""},{"$f":"IF(M9=\"\",\"\",IF($E$6=2,0.5*$I$8*M9^2,(0.5*$I$8*(M9/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(P9<>\"\",P9-Q9,\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(G10=\"\",\"\",IF(AND(E10<>\"\",F10<>\"\"),IFERROR(VLOOKUP(G10,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G10,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E10<>\"\",IF(F10=\"\",IF($E$6=2,E10/1000,E10),IF($E$6=2,(1.3*POWER((E10*F10),0.625)/POWER((E10+F10),0.25))/1000,(1.3*POWER((E10*F10),0.625)/POWER((E10+F10),0.25)))),\"\")","v":""},null,{"$f":"IF(I10<>\"\",IF(F10<>\"\",IF($E$6=1,(E10/12)*(F10/12),(E10/1000)*(F10/1000)),IF($E$6=1,PI()*0.25*(I10/12)^2,PI()*0.25*(I10)^2)),\"\")","v":""},{"$f":"IF(AND(D10=0,E10=0),\"\",L9-D9)","v":""},{"$f":"IF(K10<>\"\",IF($E$6=2,L10/(ROUND(K10*(1000),1)),ROUND(L10/(K10),)),\"\")","v":""},{"$f":"IF(M10=\"\",\"\",IF($E$6=2,0.5*J10*$I$8*M10^2,((0.5*J10*$I$8*(M10/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M10<>\"\",IF($E$6=2,(0.109136*POWER((L10/1000),1.9))/(POWER(I10,5.02))*C10*($L$7*1000),0.11*(((12*$L$7)/I10)+(68/(8.56*I10*M10)))^0.25*((12*C10)/I10)*Q10),\"\")","v":""},{"$f":"IF(N10<>\"\",P9-N10-O10,\"\")","v":""},{"$f":"IF(M10=\"\",\"\",IF($E$6=2,0.5*$I$8*M10^2,(0.5*$I$8*(M10/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q10=\"\",\"\",P10-Q10)","v":""}]
[{"$nulls":7},{"$f":"IF(G11=\"\",\"\",IF(AND(E11<>\"\",F11<>\"\"),IFERROR(VLOOKUP(G11,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G11,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E11<>\"\",IF(F11=\"\",IF($E$6=2,E11/1000,E11),IF($E$6=2,(1.3*POWER((E11*F11),0.625)/POWER((E11+F11),0.25))/1000,(1.3*POWER((E11*F11),0.625)/POWER((E11+F11),0.25)))),\"\")","v":""},null,{"$f":"IF(I11<>\"\",IF(F11<>\"\",IF($E$6=1,(E11/12)*(F11/12),(E11/1000)*(F11/1000)),IF($E$6=1,PI()*0.25*(I11/12)^2,PI()*0.25*(I11)^2)),\"\")","v":""},{"$f":"IF(AND(D11=0,E11=0),\"\",L10-D10)","v":""},{"$f":"IF(K11<>\"\",IF($E$6=2,L11/(ROUND(K11*(1000),1)),ROUND(L11/(K11),)),\"\")","v":""},{"$f":"IF(M11=\"\",\"\",IF($E$6=2,0.5*J11*$I$8*M11^2,((0.5*J11*$I$8*(M11/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M11<>\"\",IF($E$6=2,(0.109136*POWER((L11/1000),1.9))/(POWER(I11,5.02))*C11*($L$7*1000),0.11*(((12*$L$7)/I11)+(68/(8.56*I11*M11)))^0.25*((12*C11)/I11)*Q11),\"\")","v":""},"",{"$f":"IF(M11=\"\",\"\",IF($E$6=2,0.5*$I$8*M11^2,(0.5*$I$8*(M11/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q11=\"\",\"\",P11-Q11)","v":""}]
[{"$nulls":7},{"$f":"IF(G12=\"\",\"\",IF(AND(E12<>\"\",F12<>\"\"),IFERROR(VLOOKUP(G12,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G12,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E12<>\"\",IF(F12=\"\",IF($E$6=2,E12/1000,E12),IF($E$6=2,(1.3*POWER((E12*F12),0.625)/POWER((E12+F12),0.25))/1000,(1.3*POWER((E12*F12),0.625)/POWER((E12+F12),0.25)))),\"\")","v":""},null,{"$f":"IF(I12<>\"\",IF(F12<>\"\",IF($E$6=1,(E12/12)*(F12/12),(E12/1000)*(F12/1000)),IF($E$6=1,PI()*0.25*(I12/12)^2,PI()*0.25*(I12)^2)),\"\")","v":""},"","",{"$f":"IF(M12=\"\",\"\",IF($E$6=2,0.5*J12*$I$8*M12^2,((0.5*J12*$I$8*(M12/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M12<>\"\",IF($E$6=2,(0.109136*POWER((L12/1000),1.9))/(POWER(I12,5.02))*C12*($L$7*1000),0.11*(((12*$L$7)/I12)+(68/(8.56*I12*M12)))^0.25*((12*C12)/I12)*Q12),\"\")","v":""},"",{"$f":"IF(M12=\"\",\"\",IF($E$6=2,0.5*$I$8*M12^2,(0.5*$I$8*(M12/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q12=\"\",\"\",P12-Q12)","v":""}]
[{"$nulls":7},{"$f":"IF(G13=\"\",\"\",IF(AND(E13<>\"\",F13<>\"\"),IFERROR(VLOOKUP(G13,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G13,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E13<>\"\",IF(F13=\"\",IF($E$6=2,E13/1000,E13),IF($E$6=2,(1.3*POWER((E13*F13),0.625)/POWER((E13+F13),0.25))/1000,(1.3*POWER((E13*F13),0.625)/POWER((E13+F13),0.25)))),\"\")","v":""},null,{"$f":"IF(I13<>\"\",IF(F13<>\"\",IF($E$6=1,(E13/12)*(F13/12),(E13/1000)*(F13/1000)),IF($E$6=1,PI()*0.25*(I13/12)^2,PI()*0.25*(I13)^2)),\"\")","v":""},"","",{"$f":"IF(M13=\"\",\"\",IF($E$6=2,0.5*J13*$I$8*M13^2,((0.5*J13*$I$8*(M13/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M13<>\"\",IF($E$6=2,(0.109136*POWER((L13/1000),1.9))/(POWER(I13,5.02))*C13*($L$7*1000),0.11*(((12*$L$7)/I13)+(68/(8.56*I13*M13)))^0.25*((12*C13)/I13)*Q13),\"\")","v":""},"",{"$f":"IF(M13=\"\",\"\",IF($E$6=2,0.5*$I$8*M13^2,(0.5*$I$8*(M13/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q13=\"\",\"\",P13-Q13)","v":""}]
[{"$nulls":7},{"$f":"IF(G14=\"\",\"\",IF(AND(E14<>\"\",F14<>\"\"),IFERROR(VLOOKUP(G14,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G14,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G15=\"\",\"\",IF(AND(E15<>\"\",F15<>\"\"),IFERROR(VLOOKUP(G15,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G15,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G16=\"\",\"\",IF(AND(E16<>\"\",F16<>\"\"),IFERROR(VLOOKUP(G16,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G16,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G17=\"\",\"\",IF(AND(E17<>\"\",F17<>\"\"),IFERROR(VLOOKUP(G17,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G17,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G18=\"\",\"\",IF(AND(E18<>\"\",F18<>\"\"),IFERROR(VLOOKUP(G18,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G18,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G19=\"\",\"\",IF(AND(E19<>\"\",F19<>\"\"),IFERROR(VLOOKUP(G19,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G19,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G20=\"\",\"\",IF(AND(E20<>\"\",F20<>\"\"),IFERROR(VLOOKUP(G20,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G20,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G21=\"\",\"\",IF(AND(E21<>\"\",F21<>\"\"),IFERROR(VLOOKUP(G21,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G21,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G22=\"\",\"\",IF(AND(E22<>\"\",F22<>\"\"),IFERROR(VLOOKUP(G22,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G22,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G23=\"\",\"\",IF(AND(E23<>\"\",F23<>\"\"),IFERROR(VLOOKUP(G23,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G23,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G24=\"\",\"\",IF(AND(E24<>\"\",F24<>\"\"),IFERROR(VLOOKUP(G24,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G24,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G25=\"\",\"\",IF(AND(E25<>\"\",F25<>\"\"),IFERROR(VLOOKUP(G25,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G25,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G26=\"\",\"\",IF(AND(E26<>\"\",F26<>\"\"),IFERROR(VLOOKUP(G26,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G26,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G27=\"\",\"\",IF(AND(E27<>\"\",F27<>\"\"),IFERROR(VLOOKUP(G27,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G27,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G28=\"\",\"\",IF(AND(E28<>\"\",F28<>\"\"),IFERROR(VLOOKUP(G28,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G28,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G29=\"\",\"\",IF(AND(E29<>\"\",F29<>\"\"),IFERROR(VLOOKUP(G29,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G29,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G30=\"\",\"\",IF(AND(E30<>\"\",F30<>\"\"),IFERROR(VLOOKUP(G30,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G30,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G31=\"\",\"\",IF(AND(E31<>\"\",F31<>\"\"),IFERROR(VLOOKUP(G31,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G31,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G32=\"\",\"\",IF(AND(E32<>\"\",F32<>\"\"),IFERROR(VLOOKUP(G32,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G32,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G33=\"\",\"\",IF(AND(E33<>\"\",F33<>\"\"),IFERROR(VLOOKUP(G33,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G33,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G34=\"\",\"\",IF(AND(E34<>\"\",F34<>\"\"),IFERROR(VLOOKUP(G34,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G34,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G35=\"\",\"\",IF(AND(E35<>\"\",F35<>\"\"),IFERROR(VLOOKUP(G35,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G35,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G36=\"\",\"\",IF(AND(E36<>\"\",F36<>\"\"),IFERROR(VLOOKUP(G36,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G36,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G37=\"\",\"\",IF(AND(E37<>\"\",F37<>\"\"),IFERROR(VLOOKUP(G37,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G37,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G38=\"\",\"\",IF(AND(E38<>\"\",F38<>\"\"),IFERROR(VLOOKUP(G38,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G38,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G39=\"\",\"\",IF(AND(E39<>\"\",F39<>\"\"),IFERROR(VLOOKUP(G39,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G39,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G40=\"\",\"\",IF(AND(E40<>\"\",F40<>\"\"),IFERROR(VLOOKUP(G40,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G40,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G41=\"\",\"\",IF(AND(E41<>\"\",F41<>\"\"),IFERROR(VLOOKUP(G41,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G41,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G42=\"\",\"\",IF(AND(E42<>\"\",F42<>\"\"),IFERROR(VLOOKUP(G42,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G42,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G43=\"\",\"\",IF(AND(E43<>\"\",F43<>\"\"),IFERROR(VLOOKUP(G43,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G43,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G44=\"\",\"\",IF(AND(E44<>\"\",F44<>\"\"),IFERROR(VLOOKUP(G44,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G44,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G45=\"\",\"\",IF(AND(E45<>\"\",F45<>\"\"),IFERROR(VLOOKUP(G45,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G45,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G46=\"\",\"\",IF(AND(E46<>\"\",F46<>\"\"),IFERROR(VLOOKUP(G46,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G46,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G47=\"\",\"\",IF(AND(E47<>\"\",F47<>\"\"),IFERROR(VLOOKUP(G47,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G47,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G48=\"\",\"\",IF(AND(E48<>\"\",F48<>\"\"),IFERROR(VLOOKUP(G48,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G48,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G49=\"\",\"\",IF(AND(E49<>\"\",F49<>\"\"),IFERROR(VLOOKUP(G49,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G49,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G50=\"\",\"\",IF(AND(E50<>\"\",F50<>\"\"),IFERROR(VLOOKUP(G50,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G50,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G51=\"\",\"\",IF(AND(E51<>\"\",F51<>\"\"),IFERROR(VLOOKUP(G51,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G51,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G52=\"\",\"\",IF(AND(E52<>\"\",F52<>\"\"),IFERROR(VLOOKUP(G52,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G52,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G53=\"\",\"\",IF(AND(E53<>\"\",F53<>\"\"),IFERROR(VLOOKUP(G53,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G53,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G54=\"\",\"\",IF(AND(E54<>\"\",F54<>\"\"),IFERROR(VLOOKUP(G54,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G54,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G55=\"\",\"\",IF(AND(E55<>\"\",F55<>\"\"),IFERROR(VLOOKUP(G55,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G55,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G56=\"\",\"\",IF(AND(E56<>\"\",F56<>\"\"),IFERROR(VLOOKUP(G56,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G56,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G57=\"\",\"\",IF(AND(E57<>\"\",F57<>\"\"),IFERROR(VLOOKUP(G57,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G57,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G58=\"\",\"\",IF(AND(E58<>\"\",F58<>\"\"),IFERROR(VLOOKUP(G58,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G58,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G59=\"\",\"\",IF(AND(E59<>\"\",F59<>\"\"),IFERROR(VLOOKUP(G59,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G59,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G60=\"\",\"\",IF(AND(E60<>\"\",F60<>\"\"),IFERROR(VLOOKUP(G60,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G60,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G61=\"\",\"\",IF(AND(E61<>\"\",F61<>\"\"),IFERROR(VLOOKUP(G61,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G61,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G62=\"\",\"\",IF(AND(E62<>\"\",F62<>\"\"),IFERROR(VLOOKUP(G62,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G62,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G63=\"\",\"\",IF(AND(E63<>\"\",F63<>\"\"),IFERROR(VLOOKUP(G63,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G63,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G64=\"\",\"\",IF(AND(E64<>\"\",F64<>\"\"),IFERROR(VLOOKUP(G64,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G64,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G65=\"\",\"\",IF(AND(E65<>\"\",F65<>\"\"),IFERROR(VLOOKUP(G65,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G65,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G66=\"\",\"\",IF(AND(E66<>\"\",F66<>\"\"),IFERROR(VLOOKUP(G66,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G66,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G67=\"\",\"\",IF(AND(E67<>\"\",F67<>\"\"),IFERROR(VLOOKUP(G67,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G67,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G68=\"\",\"\",IF(AND(E68<>\"\",F68<>\"\"),IFERROR(VLOOKUP(G68,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G68,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G69=\"\",\"\",IF(AND(E69<>\"\",F69<>\"\"),IFERROR(VLOOKUP(G69,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G69,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G70=\"\",\"\",IF(AND(E70<>\"\",F70<>\"\"),IFERROR(VLOOKUP(G70,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G70,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G71=\"\",\"\",IF(AND(E71<>\"\",F71<>\"\"),IFERROR(VLOOKUP(G71,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G71,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G72=\"\",\"\",IF(AND(E72<>\"\",F72<>\"\"),IFERROR(VLOOKUP(G72,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G72,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G73=\"\",\"\",IF(AND(E73<>\"\",F73<>\"\"),IFERROR(VLOOKUP(G73,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G73,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G74=\"\",\"\",IF(AND(E74<>\"\",F74<>\"\"),IFERROR(VLOOKUP(G74,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G74,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","",{"$f":"IF(N74<>\"\",P73-N74-O74,\"\")","v":""},"",""]
[{"$nulls":7},{"$f":"IF(G75=\"\",\"\",IF(AND(E75<>\"\",F75<>\"\"),IFERROR(VLOOKUP(G75,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G75,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"",{"$f":"IF(AND(D75=0,E75=0),\"\",L74-D74)","v":""},{"$f":"IF(K75<>\"\",IF($E$6=2,L75/(ROUND(K75*(1000),1)),ROUND(L75/(K75),)),\"\")","v":""},"","","","",""]
[{"$nulls":7},{"$f":"IF(G76=\"\",\"\",IF(AND(E76<>\"\",F76<>\"\"),IFERROR(VLOOKUP(G76,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G76,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G77=\"\",\"\",IF(AND(E77<>\"\",F77<>\"\"),IFERROR(VLOOKUP(G77,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G77,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E77<>\"\",IF(F77=\"\",IF($E$6=2,E77/1000,E77),IF($E$6=2,(1.3*POWER((E77*F77),0.625)/POWER((E77+F77),0.25))/1000,(1.3*POWER((E77*F77),0.625)/POWER((E77+F77),0.25)))),\"\")","v":""},null,{"$f":"IF(I77<>\"\",IF(F77<>\"\",IF($E$6=1,(E77/12)*(F77/12),(E77/1000)*(F77/1000)),IF($E$6=1,PI()*0.25*(I77/12)^2,PI()*0.25*(I77)^2)),\"\")","v":""},"","",{"$f":"IF(M77=\"\",\"\",IF($E$6=2,0.5*J77*$I$8*M77^2,((0.5*J77*$I$8*(M77/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M77<>\"\",IF($E$6=2,(0.109136*POWER((L77/1000),1.9))/(POWER(I77,5.02))*C77*($L$7*1000),0.11*(((12*$L$7)/I77)+(68/(8.56*I77*M77)))^0.25*((12*C77)/I77)*Q77),\"\")","v":""},"",{"$f":"IF(M77=\"\",\"\",IF($E$6=2,0.5*$I$8*M77^2,(0.5*$I$8*(M77/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q77=\"\",\"\",P77-Q77)","v":""}]
[{"$nulls":7},{"$f":"IF(G78=\"\",\"\",IF(AND(E78<>\"\",F78<>\"\"),IFERROR(VLOOKUP(G78,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G78,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G79=\"\",\"\",IF(AND(E79<>\"\",F79<>\"\"),IFERROR(VLOOKUP(G79,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G79,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G80=\"\",\"\",IF(AND(E80<>\"\",F80<>\"\"),IFERROR(VLOOKUP(G80,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G80,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G81=\"\",\"\",IF(AND(E81<>\"\",F81<>\"\"),IFERROR(VLOOKUP(G81,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G81,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G82=\"\",\"\",IF(AND(E82<>\"\",F82<>\"\"),IFERROR(VLOOKUP(G82,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G82,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G83=\"\",\"\",IF(AND(E83<>\"\",F83<>\"\"),IFERROR(VLOOKUP(G83,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G83,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G84=\"\",\"\",IF(AND(E84<>\"\",F84<>\"\"),IFERROR(VLOOKUP(G84,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G84,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G85=\"\",\"\",IF(AND(E85<>\"\",F85<>\"\"),IFERROR(VLOOKUP(G85,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G85,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G86=\"\",\"\",IF(AND(E86<>\"\",F86<>\"\"),IFERROR(VLOOKUP(G86,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G86,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G87=\"\",\"\",IF(AND(E87<>\"\",F87<>\"\"),IFERROR(VLOOKUP(G87,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G87,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G88=\"\",\"\",IF(AND(E88<>\"\",F88<>\"\"),IFERROR(VLOOKUP(G88,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G88,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G89=\"\",\"\",IF(AND(E89<>\"\",F89<>\"\"),IFERROR(VLOOKUP(G89,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G89,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G90=\"\",\"\",IF(AND(E90<>\"\",F90<>\"\"),IFERROR(VLOOKUP(G90,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G90,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G91=\"\",\"\",IF(AND(E91<>\"\",F91<>\"\"),IFERROR(VLOOKUP(G91,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G91,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G92=\"\",\"\",IF(AND(E92<>\"\",F92<>\"\"),IFERROR(VLOOKUP(G92,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G92,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G93=\"\",\"\",IF(AND(E93<>\"\",F93<>\"\"),IFERROR(VLOOKUP(G93,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G93,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G94=\"\",\"\",IF(AND(E94<>\"\",F94<>\"\"),IFERROR(VLOOKUP(G94,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G94,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G95=\"\",\"\",IF(AND(E95<>\"\",F95<>\"\"),IFERROR(VLOOKUP(G95,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G95,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G96=\"\",\"\",IF(AND(E96<>\"\",F96<>\"\"),IFERROR(VLOOKUP(G96,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G96,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G97=\"\",\"\",IF(AND(E97<>\"\",F97<>\"\"),IFERROR(VLOOKUP(G97,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G97,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G98=\"\",\"\",IF(AND(E98<>\"\",F98<>\"\"),IFERROR(VLOOKUP(G98,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G98,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G99=\"\",\"\",IF(AND(E99<>\"\",F99<>\"\"),IFERROR(VLOOKUP(G99,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G99,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G100=\"\",\"\",IF(AND(E100<>\"\",F100<>\"\"),IFERROR(VLOOKUP(G100,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G100,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G101=\"\",\"\",IF(AND(E101<>\"\",F101<>\"\"),IFERROR(VLOOKUP(G101,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G101,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G102=\"\",\"\",IF(AND(E102<>\"\",F102<>\"\"),IFERROR(VLOOKUP(G102,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G102,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G103=\"\",\"\",IF(AND(E103<>\"\",F103<>\"\"),IFERROR(VLOOKUP(G103,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G103,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G104=\"\",\"\",IF(AND(E104<>\"\",F104<>\"\"),IFERROR(VLOOKUP(G104,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G104,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G105=\"\",\"\",IF(AND(E105<>\"\",F105<>\"\"),IFERROR(VLOOKUP(G105,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G105,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G106=\"\",\"\",IF(AND(E106<>\"\",F106<>\"\"),IFERROR(VLOOKUP(G106,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G106,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G107=\"\",\"\",IF(AND(E107<>\"\",F107<>\"\"),IFERROR(VLOOKUP(G107,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G107,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G108=\"\",\"\",IF(AND(E108<>\"\",F108<>\"\"),IFERROR(VLOOKUP(G108,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G108,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G109=\"\",\"\",IF(AND(E109<>\"\",F109<>\"\"),IFERROR(VLOOKUP(G109,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G109,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G110=\"\",\"\",IF(AND(E110<>\"\",F110<>\"\"),IFERROR(VLOOKUP(G110,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G110,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G111=\"\",\"\",IF(AND(E111<>\"\",F111<>\"\"),IFERROR(VLOOKUP(G111,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G111,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G112=\"\",\"\",IF(AND(E112<>\"\",F112<>\"\"),IFERROR(VLOOKUP(G112,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G112,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G113=\"\",\"\",IF(AND(E113<>\"\",F113<>\"\"),IFERROR(VLOOKUP(G113,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G113,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G114=\"\",\"\",IF(AND(E114<>\"\",F114<>\"\"),IFERROR(VLOOKUP(G114,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G114,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G115=\"\",\"\",IF(AND(E115<>\"\",F115<>\"\"),IFERROR(VLOOKUP(G115,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G115,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G116=\"\",\"\",IF(AND(E116<>\"\",F116<>\"\"),IFERROR(VLOOKUP(G116,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G116,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G117=\"\",\"\",IF(AND(E117<>\"\",F117<>\"\"),IFERROR(VLOOKUP(G117,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G117,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G118=\"\",\"\",IF(AND(E118<>\"\",F118<>\"\"),IFERROR(VLOOKUP(G118,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G118,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G119=\"\",\"\",IF(AND(E119<>\"\",F119<>\"\"),IFERROR(VLOOKUP(G119,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G119,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G120=\"\",\"\",IF(AND(E120<>\"\",F120<>\"\"),IFERROR(VLOOKUP(G120,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G120,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G121=\"\",\"\",IF(AND(E121<>\"\",F121<>\"\"),IFERROR(VLOOKUP(G121,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G121,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G122=\"\",\"\",IF(AND(E122<>\"\",F122<>\"\"),IFERROR(VLOOKUP(G122,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G122,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G123=\"\",\"\",IF(AND(E123<>\"\",F123<>\"\"),IFERROR(VLOOKUP(G123,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G123,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G124=\"\",\"\",IF(AND(E124<>\"\",F124<>\"\"),IFERROR(VLOOKUP(G124,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G124,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G125=\"\",\"\",IF(AND(E125<>\"\",F125<>\"\"),IFERROR(VLOOKUP(G125,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G125,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G126=\"\",\"\",IF(AND(E126<>\"\",F126<>\"\"),IFERROR(VLOOKUP(G126,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G126,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G127=\"\",\"\",IF(AND(E127<>\"\",F127<>\"\"),IFERROR(VLOOKUP(G127,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G127,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G128=\"\",\"\",IF(AND(E128<>\"\",F128<>\"\"),IFERROR(VLOOKUP(G128,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G128,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G129=\"\",\"\",IF(AND(E129<>\"\",F129<>\"\"),IFERROR(VLOOKUP(G129,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G129,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G130=\"\",\"\",IF(AND(E130<>\"\",F130<>\"\"),IFERROR(VLOOKUP(G130,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G130,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G131=\"\",\"\",IF(AND(E131<>\"\",F131<>\"\"),IFERROR(VLOOKUP(G131,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G131,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G132=\"\",\"\",IF(AND(E132<>\"\",F132<>\"\"),IFERROR(VLOOKUP(G132,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G132,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G133=\"\",\"\",IF(AND(E133<>\"\",F133<>\"\"),IFERROR(VLOOKUP(G133,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G133,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G134=\"\",\"\",IF(AND(E134<>\"\",F134<>\"\"),IFERROR(VLOOKUP(G134,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G134,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G135=\"\",\"\",IF(AND(E135<>\"\",F135<>\"\"),IFERROR(VLOOKUP(G135,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G135,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G136=\"\",\"\",IF(AND(E136<>\"\",F136<>\"\"),IFERROR(VLOOKUP(G136,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G136,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G137=\"\",\"\",IF(AND(E137<>\"\",F137<>\"\"),IFERROR(VLOOKUP(G137,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G137,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G138=\"\",\"\",IF(AND(E138<>\"\",F138<>\"\"),IFERROR(VLOOKUP(G138,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G138,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","",{"$f":"IF(N138<>\"\",P137-N138-O138,\"\")","v":""},"",""]
[{"$nulls":7},{"$f":"IF(G139=\"\",\"\",IF(AND(E139<>\"\",F139<>\"\"),IFERROR(VLOOKUP(G139,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G139,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"",{"$f":"IF(AND(D139=0,E139=0),\"\",L138-D138)","v":""},{"$f":"IF(K139<>\"\",IF($E$6=2,L139/(ROUND(K139*(1000),1)),ROUND(L139/(K139),)),\"\")","v":""},"","","","",""]
[{"$nulls":7},{"$f":"IF(G140=\"\",\"\",IF(AND(E140<>\"\",F140<>\"\"),IFERROR(VLOOKUP(G140,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G140,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G141=\"\",\"\",IF(AND(E141<>\"\",F141<>\"\"),IFERROR(VLOOKUP(G141,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G141,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},{"$f":"IF(E141<>\"\",IF(F141=\"\",IF($E$6=2,E141/1000,E141),IF($E$6=2,(1.3*POWER((E141*F141),0.625)/POWER((E141+F141),0.25))/1000,(1.3*POWER((E141*F141),0.625)/POWER((E141+F141),0.25)))),\"\")","v":""},null,{"$f":"IF(I141<>\"\",IF(F141<>\"\",IF($E$6=1,(E141/12)*(F141/12),(E141/1000)*(F141/1000)),IF($E$6=1,PI()*0.25*(I141/12)^2,PI()*0.25*(I141)^2)),\"\")","v":""},"","",{"$f":"IF(M141=\"\",\"\",IF($E$6=2,0.5*J141*$I$8*M141^2,((0.5*J141*$I$8*(M141/60)^2)/32.174)/5.1971))","v":""},{"$f":"IF(M141<>\"\",IF($E$6=2,(0.109136*POWER((L141/1000),1.9))/(POWER(I141,5.02))*C141*($L$7*1000),0.11*(((12*$L$7)/I141)+(68/(8.56*I141*M141)))^0.25*((12*C141)/I141)*Q141),\"\")","v":""},"",{"$f":"IF(M141=\"\",\"\",IF($E$6=2,0.5*$I$8*M141^2,(0.5*$I$8*(M141/60)^2)/(32.174*5.1971)))","v":""},{"$f":"IF(Q141=\"\",\"\",P141-Q141)","v":""}]
[{"$nulls":7},{"$f":"IF(G142=\"\",\"\",IF(AND(E142<>\"\",F142<>\"\"),IFERROR(VLOOKUP(G142,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G142,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G143=\"\",\"\",IF(AND(E143<>\"\",F143<>\"\"),IFERROR(VLOOKUP(G143,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G143,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G144=\"\",\"\",IF(AND(E144<>\"\",F144<>\"\"),IFERROR(VLOOKUP(G144,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G144,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G145=\"\",\"\",IF(AND(E145<>\"\",F145<>\"\"),IFERROR(VLOOKUP(G145,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G145,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G146=\"\",\"\",IF(AND(E146<>\"\",F146<>\"\"),IFERROR(VLOOKUP(G146,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G146,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G147=\"\",\"\",IF(AND(E147<>\"\",F147<>\"\"),IFERROR(VLOOKUP(G147,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G147,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G148=\"\",\"\",IF(AND(E148<>\"\",F148<>\"\"),IFERROR(VLOOKUP(G148,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G148,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G149=\"\",\"\",IF(AND(E149<>\"\",F149<>\"\"),IFERROR(VLOOKUP(G149,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G149,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G150=\"\",\"\",IF(AND(E150<>\"\",F150<>\"\"),IFERROR(VLOOKUP(G150,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G150,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G151=\"\",\"\",IF(AND(E151<>\"\",F151<>\"\"),IFERROR(VLOOKUP(G151,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G151,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G152=\"\",\"\",IF(AND(E152<>\"\",F152<>\"\"),IFERROR(VLOOKUP(G152,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G152,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G153=\"\",\"\",IF(AND(E153<>\"\",F153<>\"\"),IFERROR(VLOOKUP(G153,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G153,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G154=\"\",\"\",IF(AND(E154<>\"\",F154<>\"\"),IFERROR(VLOOKUP(G154,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G154,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G155=\"\",\"\",IF(AND(E155<>\"\",F155<>\"\"),IFERROR(VLOOKUP(G155,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G155,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G156=\"\",\"\",IF(AND(E156<>\"\",F156<>\"\"),IFERROR(VLOOKUP(G156,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G156,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G157=\"\",\"\",IF(AND(E157<>\"\",F157<>\"\"),IFERROR(VLOOKUP(G157,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G157,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G158=\"\",\"\",IF(AND(E158<>\"\",F158<>\"\"),IFERROR(VLOOKUP(G158,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G158,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G159=\"\",\"\",IF(AND(E159<>\"\",F159<>\"\"),IFERROR(VLOOKUP(G159,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G159,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G160=\"\",\"\",IF(AND(E160<>\"\",F160<>\"\"),IFERROR(VLOOKUP(G160,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G160,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G161=\"\",\"\",IF(AND(E161<>\"\",F161<>\"\"),IFERROR(VLOOKUP(G161,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G161,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G162=\"\",\"\",IF(AND(E162<>\"\",F162<>\"\"),IFERROR(VLOOKUP(G162,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G162,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G163=\"\",\"\",IF(AND(E163<>\"\",F163<>\"\"),IFERROR(VLOOKUP(G163,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G163,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G164=\"\",\"\",IF(AND(E164<>\"\",F164<>\"\"),IFERROR(VLOOKUP(G164,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G164,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G165=\"\",\"\",IF(AND(E165<>\"\",F165<>\"\"),IFERROR(VLOOKUP(G165,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G165,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G166=\"\",\"\",IF(AND(E166<>\"\",F166<>\"\"),IFERROR(VLOOKUP(G166,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G166,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G167=\"\",\"\",IF(AND(E167<>\"\",F167<>\"\"),IFERROR(VLOOKUP(G167,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G167,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G168=\"\",\"\",IF(AND(E168<>\"\",F168<>\"\"),IFERROR(VLOOKUP(G168,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G168,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G169=\"\",\"\",IF(AND(E169<>\"\",F169<>\"\"),IFERROR(VLOOKUP(G169,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G169,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G170=\"\",\"\",IF(AND(E170<>\"\",F170<>\"\"),IFERROR(VLOOKUP(G170,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G170,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G171=\"\",\"\",IF(AND(E171<>\"\",F171<>\"\"),IFERROR(VLOOKUP(G171,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G171,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G172=\"\",\"\",IF(AND(E172<>\"\",F172<>\"\"),IFERROR(VLOOKUP(G172,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G172,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G173=\"\",\"\",IF(AND(E173<>\"\",F173<>\"\"),IFERROR(VLOOKUP(G173,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G173,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G174=\"\",\"\",IF(AND(E174<>\"\",F174<>\"\"),IFERROR(VLOOKUP(G174,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G174,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G175=\"\",\"\",IF(AND(E175<>\"\",F175<>\"\"),IFERROR(VLOOKUP(G175,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G175,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G176=\"\",\"\",IF(AND(E176<>\"\",F176<>\"\"),IFERROR(VLOOKUP(G176,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G176,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G177=\"\",\"\",IF(AND(E177<>\"\",F177<>\"\"),IFERROR(VLOOKUP(G177,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G177,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G178=\"\",\"\",IF(AND(E178<>\"\",F178<>\"\"),IFERROR(VLOOKUP(G178,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G178,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G179=\"\",\"\",IF(AND(E179<>\"\",F179<>\"\"),IFERROR(VLOOKUP(G179,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G179,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G180=\"\",\"\",IF(AND(E180<>\"\",F180<>\"\"),IFERROR(VLOOKUP(G180,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G180,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G181=\"\",\"\",IF(AND(E181<>\"\",F181<>\"\"),IFERROR(VLOOKUP(G181,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G181,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G182=\"\",\"\",IF(AND(E182<>\"\",F182<>\"\"),IFERROR(VLOOKUP(G182,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G182,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G183=\"\",\"\",IF(AND(E183<>\"\",F183<>\"\"),IFERROR(VLOOKUP(G183,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G183,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G184=\"\",\"\",IF(AND(E184<>\"\",F184<>\"\"),IFERROR(VLOOKUP(G184,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G184,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G185=\"\",\"\",IF(AND(E185<>\"\",F185<>\"\"),IFERROR(VLOOKUP(G185,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G185,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G186=\"\",\"\",IF(AND(E186<>\"\",F186<>\"\"),IFERROR(VLOOKUP(G186,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G186,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G187=\"\",\"\",IF(AND(E187<>\"\",F187<>\"\"),IFERROR(VLOOKUP(G187,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G187,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G188=\"\",\"\",IF(AND(E188<>\"\",F188<>\"\"),IFERROR(VLOOKUP(G188,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G188,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G189=\"\",\"\",IF(AND(E189<>\"\",F189<>\"\"),IFERROR(VLOOKUP(G189,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G189,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G190=\"\",\"\",IF(AND(E190<>\"\",F190<>\"\"),IFERROR(VLOOKUP(G190,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G190,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G191=\"\",\"\",IF(AND(E191<>\"\",F191<>\"\"),IFERROR(VLOOKUP(G191,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G191,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G192=\"\",\"\",IF(AND(E192<>\"\",F192<>\"\"),IFERROR(VLOOKUP(G192,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G192,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G193=\"\",\"\",IF(AND(E193<>\"\",F193<>\"\"),IFERROR(VLOOKUP(G193,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G193,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G194=\"\",\"\",IF(AND(E194<>\"\",F194<>\"\"),IFERROR(VLOOKUP(G194,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G194,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G195=\"\",\"\",IF(AND(E195<>\"\",F195<>\"\"),IFERROR(VLOOKUP(G195,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G195,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G196=\"\",\"\",IF(AND(E196<>\"\",F196<>\"\"),IFERROR(VLOOKUP(G196,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G196,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G197=\"\",\"\",IF(AND(E197<>\"\",F197<>\"\"),IFERROR(VLOOKUP(G197,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G197,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G198=\"\",\"\",IF(AND(E198<>\"\",F198<>\"\"),IFERROR(VLOOKUP(G198,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G198,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G199=\"\",\"\",IF(AND(E199<>\"\",F199<>\"\"),IFERROR(VLOOKUP(G199,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G199,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"","","","","","","",""]
[{"$nulls":7},{"$f":"IF(G200=\"\",\"\",IF(AND(E200<>\"\",F200<>\"\"),IFERROR(VLOOKUP(G200,OFFSET('Rectangular Duct Data'!$A$2,0,0,COUNTA('Round Duct Data'!C:C),2),2,FALSE),\"\"),IFERROR(VLOOKUP(G200,OFFSET('Round Duct Data'!$A$3,0,0,COUNTA('Round Duct Data'!A:A),2),2,FALSE),\"\")))","v":""},"",null,"",{"$f":"IF(AND(D200=0,E200=0),\"\",IF(D200>0,L199-D199,L199))","v":""},{"$f":"IF(K200<>\"\",IF($E$6=2,L200/(K200*(1000)),L200/(K200)),\"\")","v":""},"","","","",""]

{"sheet":"Diagrams","index":9,"n_rows":22,"n_cols":4,"rows_kept":22,"hidden":true}
[null,"Diagram","Code","Description"]
[null,null,"CD3-1","Elbow, Die Stamped, 90 Degree, r/D=1.5"]
[null,null,"CD3-2","Elbow, Die Stamped, 90 Degree, r/D=1.0"]
[null,null,"CD3-3","Elbow, Die Stamped, 45 Degree, r/D = 1.5"]
[null,null,"CD3-4","Elbow, Die Stamped, 45 Degree, r/D = 1.0"]
[null,null,"CD3-5","Elbow, Pleated, 90 Degree, r/D = 1.5"]
[null,null,"CD3-7","Elbow, Pleated, 45 Degree, r/D = 1.5"]
[null,null,"CD3-15","Elbow, Mitered, 90 Degree"]
[null,null,"CD3-18","Elbow, Mitered, 30 Degree"]
[null,null,"CD3-19","Elbow, Mitered, 22.5 Degree"]
[null,null,"CD3-20","Elbow, Mitered with Vanes, 90 Degree"]
[null,null,"CD3-16","Elbow, Mitered, 60 Degree"]
[null,null,"CD3-17","Elbow, Mitered, 45 Degree"]
[null,null,"CR3-1","Elbow, Smooth Radius without Vanes, 1.5RR, 90 degrees"]
[null,null,"CR3-6","Elbow, Mitered, 90 Degrees, Without Vanes"]
[null,null,"CR3-9","Elbow, Mitered, 90 Degree, Single-Thickness Vanes, 1 1/2-in. Vane Spacing"]
[null,null,"CR3-12","Elbow, Mitered, 90 Degree, Single-Thickness Vanes, 3 1/4-in. Vane Spacing"]
[null,null,"CR3-14","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 1 1/2-in. Vane Spacing"]
[null,null,"CR3-15","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 2 1/8-in. Vane Spacing"]
[null,null,"CR3-16","Elbow, Mitered, 90 Degree, Double-Thickness Vanes, 3 1/4-in. Vane Spacing"]
[null,null,"SD4-1","Transition, Round to Round"]
[null,null,"SR4-1","Transition, Rectangular, Two Sides Parallel, Symmetrical"]

{"sheet":"Air Density Factors","index":10,"n_rows":15,"n_cols":16,"rows_kept":15,"hidden":true,"merged":[[0,1,0,9],[1,2,1,9]]}
[null,"Air Density Correction Factor"]
[null,"Air Temp (°F)","Altitude (ft)"]
[null,null,0,1000,2000,3000,4000,5000,6000,7000,null,null,"standard air density",{"$f":"IF('SRG Calculator'!E6=1,0.07468,1.2)","v":{"v":0.07468,"d":"0.074680"}},{"$f":"'SRG Calculator'!J8","v":"lbm/ft^3"}]
["correction",50,1.04,{"v":1,"d":"1.00"},0.97,0.94,{"v":0.9,"d":"0.90"},0.87,0.84,0.81]
["correction",55,1.03,0.99,0.96,0.93,0.89,0.86,0.83,{"v":0.8,"d":"0.80"}]
["correction",60,1.02,0.98,0.95,0.91,0.88,0.85,0.82,0.79,{"$nulls":4},"Min","Max"]
["correction",70,{"v":1,"d":"1.00"},0.96,0.93,0.89,0.86,0.83,{"v":0.8,"d":"0.80"},0.77,null,null,"Duct Velocity Recommended Limits",null,{"$f":"IF('SRG Calculator'!E6=1,500,2.5)","v":500},{"$f":"IF('SRG Calculator'!E6=1,1500,8)","v":1500}]
["correction",80,0.99,0.95,0.92,0.88,0.85,0.81,0.79,0.76]
["correction",90,0.97,0.94,{"v":0.9,"d":"0.90"},0.86,0.83,{"v":0.8,"d":"0.80"},0.77,0.75]
["correction",100,0.95,0.93,0.88,0.85,0.81,0.78,0.75,0.73]
["correction",110,0.94,0.92,0.86,0.83,{"v":0.8,"d":"0.80"},0.77,0.74,0.72]
["correction",120,0.93,{"v":0.9,"d":"0.90"},0.85,0.82,0.79,0.76,0.73,0.71]
["correction",130,0.91,0.88,0.83,0.81,0.78,0.75,0.72,{"v":0.7,"d":"0.70"}]
["correction",140,0.89,0.86,0.81,{"v":0.8,"d":"0.80"},0.77,0.73,0.71,0.68]
["correction",150,0.87,0.84,{"v":0.8,"d":"0.80"},0.79,0.75,0.72,{"v":0.7,"d":"0.70"},0.67]

{"sheet":"User Manual","index":11,"n_rows":223,"n_cols":2,"rows_kept":223}
["Static Regain Calculator User Manual"]
["Don't forget to Save periodically throughout your work to ensure you don't lose any progress."]
[]
[]
["A General Overview"]
[]
["Step 1:","Fill in entry boxes titled \"Project Name\" and \"Produced By\" accordingly. The date will automatically insert the current day but can be overridden if necessary."]
{"$rows_empty":8}
["Step 2: ","Select the button corresponding to the unit system you will be using to design the duct system (IP = English Units, SI = Metric Units). All units and calculation formulas will automatically update"]
[null,"to match the unit system selected. For this example, English (IP) units are used."]
{"$rows_empty":8}
["Step 3: ","Fill in the entry boxes titled \"Unit Design Supply Temp\" (The temperature of the air being supplied by the AHU) and \"Altitude\" (The distance above sea level that the AHU is at) accordingly.  "]
[null,"Make sure that the numbers correspond to the units located to the right of entry boxes. Once these numbers are entered, the spreadsheet will automatically calculate the Air Density Correction "]
[null,"Factor and then output a value next to the label titled \"Supply Air Density\" directly beneath the two entry boxes just filled in. For this example, a temperature of 69°F is used at sea level (0 ft)."]
{"$rows_empty":8}
["Step 4:","Fill in the \"Design Static Pressure\" entry box with the desired static pressure to be achieved throughout the duct, making sure to match the units located next to the entry box."]
[null,"For this example, 0.25 inches water column is used."]
{"$rows_empty":8}
["Step 5: ","Fill in the \"Duct Material Roughness\" entry box with the approximate value of the duct roughness as determined by the material type.  "]
[null,"This example is designed with Galvanized Steel with an estimated roughness value of 0.000490 ft."]
{"$rows_empty":9}
["Step 6: ","Fill in the \"Total Duct Pressure at Start\" entry box with the total pressure value at the AHU, making sure to match the units located next to the entry box. For this example, a total duct"]
[null,"pressure of 0.3 inches water column is used."]
{"$rows_empty":9}
["Step 8:","Select the button in the title bar that is titled \"Add Branch\". A pop up box will then appear asking how many sections are within the branch being designed. A drop down provides options "]
[null,"for this value, but if the necessary number is not available, a number can be manually typed in. Click \"Ok\". A chart will automatically be generated in the workspace below the title bar."]
[null,"This example uses six sections."]
{"$rows_empty":10}
["Step 9:","Starting in the row with section number 1.01, enter values for \"Duct Length\", \"Vol. Flow Rate\" (if applicable), \"Duct Width/Diameter\", and \"Duct Height\" (leave \"Duct Height empty if designing "]
[null,"for a rectangular duct). The \"Duct Width/Diameter\" and \"Duct Height\" columns have drop down options offering common values but the values may be overridden and typed manually if "]
[null,"necessary. Columns will begin to autopopulate in the right side of the table (it will show #VALUE! until all necessary columns on the duct parameter inputs section are filled)."]
{"$rows_empty":9}
["Step 10:","Select the proper duct fitting for the section being designed. A drop down is offered for the duct fitting column and gives the ASHRAE fitting codes for each type and size of duct fitting. "]
[null,"Images of each fitting type can be found by clicking the \"Generate Diagram\" button in the title bar and selecting through the duct fittings. Each diagram tab shows an image to the right "]
[null,"and the full description of the fitting type below it. Once a duct fitting is selected in the table, the full description of the duct fitting will appear in the column to the right. The diagrams  "]
[null,"button can be activated and used simultaneously as the table is in use. Note the fitting database covers most types of bend and some basic transitions/reducers."]
[null,"More complex fittings such as Tee's must be entered manually.  Use the ASHRAE fitting database for accurate calculations."]
{"$rows_empty":23}
["Step 11: ","Repeat steps 9 & 10 for each row of the branch. Adjust necessary parameters (Duct Width/Diameter, Duct Height, Duct Fitting) to meet static pressure requirements (When the duct is"]
[null,"designed within specified tolerance of the design static pressure, the entire row will turn green). The entire table will be green if static pressure design contraints are met for every section of duct."]
{"$rows_empty":11}
["Step 12:","The first branch is complete after Step 11. If designing for a system with more than one branch, click the \"Add Branch\" button again and enter the number of sections in the next branch, "]
[null,"the same way as the first. When the new table appears below the first, it will have a new entry box next to the branch name that requires the input of the section number of the parent branch"]
[null,"(e.g. if Branch 2's starting point has a takeoff from section 1.03, the box will need to have 1.03 typed into it). Design the new branch using the same steps as the first branch."]
{"$rows_empty":13}
["To Remove a Branch or Section"]
[]
["Step 1: ","Click the \"Remove Branch\" button in the title bar. A pop up box will appear with a drop down asking which branch needs to be removed. The drop down offers the numbers "]
[null,"corresponding to the branches already in the spreadsheet. If an individual section within a branch would like to be removed instead, the section number can be manually typed into"]
[null,"this box (i.e. 1.04) and it will only remove that section. WARNING: Since the remove function uses a macro, the action cannot be undone after clicking \"Remove Branch\". Due to this, "]
[null,"a checkbox must be clicked prior to clicking \"Remove Branch\" to acknowledge that this is the correct action to take. Also note that removing a branch deletes the entire row that the"]
[null,"branch is contained in so do not store any information in cells to the right of the branch being deleted."]
{"$rows_empty":16}
["Step 2:","Once the pop up box is filled in and it is acknowledged that the action cannot be undone, click \"Remove Branch\". If deleting an entire branch, the entire branch table will be "]
[null,"automatically removed in its entirety. If removing only a section of a branch, the section will be removed and the table will adjust all section numbers up to where the change"]
[null,"was made and will resize the table."]
[]
[]
[]
["To Insert a Section in a Branch"]
[]
["Step 1:","Click the \"Insert Section\" button in the title bar. A pop up box will appear asking which section you would like the new section to be inserted after. Type the section number that"]
[null,"the new section should appear below in the table in the entry box (i.e. 1.03 to insert a section after section 1.03)."]
{"$rows_empty":14}
["Step 2:","Click \"OK\". A new section will appear below the section entered in the pop up box. It will have a revised section number that adds \".1\" after the section number typed into"]
[null,"the pop up box (for this example, \"1.03.1\"). The table and its calculations will automatically update to accommodate the new addition."]
{"$rows_empty":17}
["Important Note! - Updating Fitting Coefficients for Transitions/Reducers"]
[]
[null,"Whenever a change to a dimension to the duct parameters is made to a transition/reducer, the coeffecient only updates if the dimension change is on the same line of the reducer."]
[null,"If the dimension of the downstream side of the reducer i.e. the row below it, the reducer coeffiecent will not update with the new size. An easy workaround is to reselect the duct fitting"]
[null,"from the dropdown in column \"G\" this will force an update using the revised dimension in the line below."]
[]
[null,"In the example below, if the duct height for section 1.05 is changed, then the duct fitting should be updated in section 1.04.1 by simply reselecting a SR4-1-30 fitting."]

{"sheet":"Example","index":12,"n_rows":358,"n_cols":2,"rows_kept":358,"merged":[[3,1,3,19],[35,1,35,19],[68,1,68,19],[94,1,94,19],[125,1,125,19],[177,1,177,19],[208,1,208,19],[270,1,270,19],[337,1,337,19],[355,1,355,19]]}
[]
[]
[]
[null,"Step 1 - Sketch Layout"]
[]
[null,"Sketch a schematic of duct and diffuser layout, mark each diffuser with volume flow rate."]
{"$rows_empty":29}
[null,"Step 2 - Mark Up Sections with References"]
[]
[null,"Mark each section of the duct between diffusers and branches with a unique identifying number, starting with 1.01."]
[null,"Bends and takeoffs and any fitting must be marked up with a unique number. "]
[null,"Tip: Don’t worry if items are missed, they can be inserted later."]
{"$rows_empty":28}
[null,"Step 3 - Enter Duct Lengths and Diffuser Flow Rates"]
[]
[null,"Enter duct lengths, diffuser and branch tee volume flow rates."]
[null,"In this example, 1.03 is a tee serving the 200 and 300 cfm diffusers, so the total of the two diffusers (500 cfm) should be entered in this section."]
[null,"Note that the duct section identifying number is associated with the diffuser at the END of the section - so for example section 1.05 is associated with the 200 CFM diffuser."]
{"$rows_empty":21}
[null,"Step 4 - Enter Duct Fittings"]
[]
[null,"Now enter the duct fittings, such as bends and tees. Transitions cannot be put in at this stage as the duct sizes are not yet know."]
[null,"Use the drop down in column \"G\" to choose from the available fittings by ASHRAE code."]
[null,"Tip: Use the \"Generate Diagram\" button to view the available fitting database and associated codes."]
[null,"The program will automatically populate the ASHRAE loss coefficient for bends and basic transitions/reducers but these only appear when the duct sizes are entered."]
[null,"For more complicated fittings such as tees, the coefficient must be entered manually. At this stage the coefficient of the tee at 1.03 is unknown as the duct sizes are unknown."]
{"$rows_empty":24}
[null,"Step 5 - Add Branches"]
[]
[null,"Add a branch for the 200 & 300 cfm diffusers by using the \"Add Branch\" button."]
[null,"Enter the \"Parent Branch\" number in the highlighted cell - 1.03 in this example."]
[null,"Populate the duct lengths and fittings in the new branches."]
{"$rows_empty":47}
[null,"Step 6 - Size Ducts"]
[]
[null,"Now the approximate duct sizes starting with the first section 1.01 can be entered. Sizing should be done in accordance with ASHRAE recommended duct velocities."]
[null,"In this example, circular ductwork will be used throughout. 14\" diameter has been selected for section 1.01, for a velocity of just over 1000 fpm."]
{"$rows_empty":11}
[null,"Now complete the remaining duct sizes and adjust to achieve approximately the same static pressure at each diffuser spigot."]
[null,"Tip: The sizes will need probably to be adjusted again once all the fittings have been entered."]
{"$rows_empty":14}
[null,"Step 7 - Add Reducers/Transitions"]
[]
[null,"Now that the approx. duct sizes are known, the transitions/reducers can be added."]
[null,"Insert the transition/reducer by using the \"Insert Section\" button, for example 1.05 has been reduced from 12\" to 10\" with the reducer being fitted after the 120 CFM diffuser."]
[null,"The reducer section is inserted after 1.04 so will be referenced as 1.04.1"]
{"$rows_empty":32}
[null,"Note: It is important to insert the transitions/reducer sections in the correct locations as the fitting lookup uses the size of the current line for the larger dimension and the following line"]
[null," for the smaller dimension. Always insert the new transition/reducer section after the larger dimension duct, not after the smaller. In the example below, the coefficient is looked up from the"]
[null," current line 12\" diameter and the smaller dimension is looked up from the next row which is 10\" dia."]
{"$rows_empty":22}
[null,"Step 8 - Add Branch/Tee Coefficients"]
[]
[null,"The branch/tee coefficients can now be added, these must be entered in manually as the software does not calculate the coefficients in this version."]
[null,"The ASHRAE fitting database should be used to calculate an accurate coefficient. If this is not available, then a coefficient of 0.15 can be used for the main branch (section 1.03) and 0.5-1.5 for the 90° branch"]
[null,"only use these coefficients as an estimate as they will vary considerably with different sizes/ratios and angles."]
[]
[null,"The ASHRAE fitting database was used to calculate the branch fitting loss for this example:"]
{"$rows_empty":60}
[null,"Step 9 - Final Adjustments"]
[]
[null,"Now that all of the fittings have been entered, the duct sizes can be adjusted as necessary to achieve an even static pressure along the ductwork."]
[]
[]
[]
[null,"Tip: Adjust the total starting pressure to achieve a static pressure of around 0.2-0.25 in w.c. at the diffuser spigots."]
{"$rows_empty":11}
[null,"Final Result"]
[]
[null,"In our example, our sizing results in a minimum of 0.21 and maximum of 0.25 in. w.c."]

{"sheet":"memory","index":13,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[25,24]
[24,23]
[27,26]
[28,27]
[31,30]
[30,29]