{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Refrigerant line capacities","717 line capacities","744 transcritical line cap","Refrigerant line detail","744 transcritical line detail","refrigerant list","uom list","available line sizes","refrigerant line types","refrigerant line types CO2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Refrigerant line capacities","index":0,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,7,0,12],[0,14,0,19],[1,7,1,12],[1,14,1,19],[3,7,3,12],[3,14,3,19]]}
["UOM",null,"IP","Req'd for",null,null,null,{"$f":"\"Suction line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Suction line capacity, tons refrigeration"},null,null,null,null,null,null,{"$f":"\"Minimum suction riser line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Minimum suction riser line capacity, tons refrigeration"},null,null,null,null,null,null,"Discharge","Liquid","Drain"]
[null,null,null,"line types",null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"},{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"},{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"}]
["Refrigerant",null,{"$f":"VLOOKUP($E$5,'refrigerant list'!A1:B47,2)","v":"448A"},"All",null,null,null,-60,-40,-20,0,20,40,null,-60,-40,-20,0,20,40,null,"refrig","refrig","refrig"]
["Evap Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},-10,"L, D, CD; S, SR spec'ed in table",null,"Copper Tube",null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},null,null,null,null,null,null,{"$f":"\"Velocity, \"&IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"Velocity, ft/min"},null,null,null,null,null,null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},{"$f":"\"vel, \"&IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"vel, ft/min"}]
["Cond Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},110,"D",25,"OD, in","Type",0.371,0.58899999999999997,0.88500000000000001,1.27,1.75,2.35,null,1200,1200,1200,1200,1200,1200,null,5.74,3.48,100]
["Liquid Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},100,"All",null,"3/16","ACRA",1.39E-3,2.64E-3,4.64E-3,7.6699999999999997E-3,1.2E-2,1.8100000000000002E-2,null,4.1900000000000001E-3,7.62E-3,1.2999999999999999E-2,2.12E-2,3.3000000000000002E-2,4.9700000000000001E-2,null,5.1400000000000001E-2,0.14199999999999999,0.17899999999999999]
["Superheat",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},25,"S, SR, D",null,"1/4","ACRA",4.1999999999999997E-3,7.92E-3,1.38E-2,2.2800000000000001E-2,3.56E-2,5.33E-2,null,9.2999999999999992E-3,1.6899999999999998E-2,2.9000000000000001E-2,4.7100000000000003E-2,7.3400000000000007E-2,0.11,null,0.15,0.41799999999999998,0.39900000000000002]
["Equivalent Length",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},100,"All",null,"5/16","ACRA",8.8000000000000005E-3,1.6500000000000001E-2,2.87E-2,4.7100000000000003E-2,7.3400000000000007E-2,0.11,null,1.5900000000000001E-2,2.8899999999999999E-2,4.9500000000000002E-2,8.0500000000000002E-2,0.126,0.189,null,0.307,0.86199999999999999,0.68200000000000005]
["Max Velocity, Suction",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"S",null,"3/8","ACRA",1.6299999999999999E-2,3.04E-2,5.28E-2,8.6300000000000002E-2,0.13400000000000001,0.2,null,2.4899999999999999E-2,4.53E-2,7.7600000000000002E-2,0.126,0.19700000000000001,0.29599999999999999,null,0.55800000000000005,1.58,1.07]
["Max Velocity, Discharge",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"D",null,"1/2","ACRA",4.0899999999999999E-2,7.5899999999999995E-2,0.13100000000000001,0.214,0.33200000000000002,0.49399999999999999,null,4.9000000000000002E-2,8.9099999999999999E-2,0.152,0.248,0.38600000000000001,0.58099999999999996,null,1.37,3.89,2.1]
["Max Velocity, Liquid","ft/min",300,"L",null,"5/8","ACRD",7.4800000000000005E-2,0.13900000000000001,0.23899999999999999,0.38900000000000001,0.60199999999999998,0.89500000000000002,null,7.6499999999999999E-2,0.13900000000000001,0.23799999999999999,0.38700000000000001,0.60399999999999998,0.90800000000000003,null,2.4700000000000002,7.05,3.28]
["∆T, Suction",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},1.5,"S",null,"3/4","ACRD",0.129,0.23799999999999999,0.40899999999999997,0.66400000000000003,1.03,1.52,null,0.114,0.20799999999999999,0.35599999999999998,0.57899999999999996,0.90200000000000002,1.36,null,4.1900000000000004,12,4.9000000000000004]
["∆T, Discharge",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},1.5,"D",null,"7/8","ACRD",0.2,0.36899999999999999,0.63500000000000001,1.03,1.59,2.36,null,0.159,0.28899999999999998,0.49399999999999999,0.80400000000000005,1.25,1.88,null,6.47,18.600000000000001,6.8]
["∆T, Liquid","°F",1,"L",null,"1-1/8","ACRD",0.41,0.754,1.29,2.09,3.22,4.7699999999999996,null,0.27100000000000002,0.49199999999999999,0.84299999999999997,1.37,2.14,3.21,null,13,34.799999999999997,11.6]
[null,null,null,null,null,"1-3/8","ACRD",0.72,1.32,2.2599999999999998,3.65,5.62,8.31,null,0.41199999999999998,0.75,1.28,2.09,3.25,4.8899999999999997,null,22.7,53,17.7]
["Effective Roughness",null,null,null,null,"1-5/8","ACRD",1.1499999999999999,2.1,3.59,5.78,8.89,13.1,null,0.58299999999999996,1.06,1.82,2.95,4.5999999999999996,6.92,null,35.700000000000003,75,25]
["Copper Tube",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"5.0E-6\",\"1.524E-6\")","v":"5.0E-6"},null,null,"2-1/8","ACRD",2.4,4.38,7.46,12,18.399999999999999,27.2,null,1.01,1.85,3.16,5.14,8.01,12,null,73.8,130,43.5]
["Steel Pipe",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"1.5E-4\",\"4.572E-5\")","v":"1.5E-4"},null,null,"2-5/8","ACRD",3.91,7.12,12.2,19.8,30.9,46.4,null,1.57,2.85,4.87,7.93,12.3,18.600000000000001,null,130,201,67.099999999999994]
[null,null,null,null,null,"3-1/8","ACRD",5.58,10.199999999999999,17.399999999999999,28.3,44.1,66.3,null,2.23,4.0599999999999996,6.96,11.3,17.600000000000001,26.5,null,185,287,95.7]
["Blue cells = input values",null,null,null,null,"3-5/8","ACRD",7.55,13.7,23.5,38.299999999999997,59.6,89.6,null,3.02,5.5,9.41,15.3,23.8,35.799999999999997,null,250,388,129]
[null,null,null,null,null,"4-1/8","ACRD",9.82,17.899999999999999,30.6,49.7,77.5,116,null,3.93,7.15,12.2,19.899999999999999,31,46.6,null,325,505,168]
["General guidelines regarding refrigerant velocity:",null,null,null,null,"5-1/8","ACRD",15.3,27.8,47.7,77.5,121,182,null,6.12,11.1,19.100000000000001,31,48.3,72.599999999999994,null,507,787,262]
[null,null,null,null,null,"6-1/8","ACRD",22,40,68.5,111,174,261,null,8.8000000000000007,16,27.4,44.6,69.400000000000006,104,null,729,1130,377]
["For liquid lines, 400 ft/min maximum for lengths less than",null,null,null,null,"8-1/8","ACRD",38.4,69.900000000000006,120,195,303,456,null,15.4,28,47.9,77.8,121,182,null,1270,1980,659]
["50 ft.  300 ft/min maximum for lengths 50 ft to 150 ft."]
["200 ft/min maximum for lengths exceeding 150 ft.",null,null,null,null,"Steel Pipe"]
[null,null,null,null,null,"NPS, in","Schedule"]
["For suction and discharge lines, 700 ft/min minimum and",null,null,null,null,"1/8",80,5.3499999999999997E-3,9.7599999999999996E-3,1.6500000000000001E-2,2.64E-2,4.0099999999999997E-2,5.8500000000000003E-2,null,1.1900000000000001E-2,2.1700000000000001E-2,3.7100000000000001E-2,6.0299999999999999E-2,9.4E-2,0.14099999999999999,null,0.155,0.46600000000000003,0.51]
["3000 ft/min maximum.",null,null,null,null,"1/4",80,1.35E-2,2.4500000000000001E-2,4.1399999999999999E-2,6.5799999999999997E-2,0.1,0.14499999999999999,null,2.35E-2,4.2700000000000002E-2,7.3099999999999998E-2,0.11899999999999999,0.185,0.27900000000000003,null,0.38400000000000001,1.1599999999999999,1.01]
[null,null,null,null,null,"3/8",80,3.3799999999999997E-2,6.0900000000000003E-2,0.10199999999999999,0.16200000000000001,0.245,0.35699999999999998,null,4.6100000000000002E-2,8.3799999999999999E-2,0.14399999999999999,0.23300000000000001,0.36399999999999999,0.54700000000000004,null,0.94199999999999995,2.85,1.98]
["For suction and discharge risers, 1200 ft/min minimum",null,null,null,null,"1/2",80,6.7199999999999996E-2,0.121,0.20200000000000001,0.32,0.48399999999999999,0.70299999999999996,null,7.6799999999999993E-2,0.14000000000000001,0.23899999999999999,0.38900000000000001,0.60599999999999998,0.91100000000000003,null,1.85,5.62,3.29]
["and 3000 ft/min maximum.",null,null,null,null,"3/4",80,0.153,0.27400000000000002,0.45800000000000002,0.72299999999999998,1.0900000000000001,1.58,null,0.14199999999999999,0.25800000000000001,0.442,0.71799999999999997,1.1200000000000001,1.68,null,4.17,12.7,6.08]
[null,null,null,null,null,"1",80,0.30199999999999999,0.53900000000000003,0.89900000000000002,1.42,2.14,3.1,null,0.23599999999999999,0.42899999999999999,0.73499999999999999,1.19,1.86,2.8,null,8.16,24.8,10.1]
["For condenser drain lines, 100 ft/min maximum.  If a",null,null,null,null,"1-1/4",80,0.65300000000000002,1.1599999999999999,1.93,3.05,4.59,6.66,null,0.42099999999999999,0.76500000000000001,1.31,2.13,3.32,4.99,null,17.5,53.2,18]
["vent line is used, 180 ft/min maximum.",null,null,null,null,"1-1/2",80,1,1.77,2.95,4.6500000000000004,6.99,10.1,null,0.57999999999999996,1.05,1.8,2.93,4.57,6.88,null,26.6,74.5,24.8]
[null,null,null,null,null,"2",40,2.33,4.1399999999999997,6.87,10.8,16.2,23.6,null,1.1000000000000001,2,3.43,5.57,8.68,13.1,null,61.8,141,47.2]
[null,null,null,null,null,"2-1/2",40,3.73,6.61,11,17.2,25.9,37.5,null,1.57,2.86,4.8899999999999997,7.95,12.4,18.600000000000001,null,98.4,202,67.3]
["Notes: For discharge lines, refrigerant thermodynamic",null,null,null,null,"3",40,6.06,11,18.899999999999999,30.4,45.8,66.3,null,2.42,4.41,7.55,12.3,19.100000000000001,28.8,null,174,312,104]
["state is evaluated at isentropic compression + 50°F",null,null,null,null,"3-1/2",40,8.11,14.7,25.2,41,64,96.2,null,3.24,5.9,10.1,16.399999999999999,25.6,38.5,null,254,417,139]
[null,null,null,null,null,"4",40,10.4,19,32.5,52.9,82.4,124,null,4.17,7.6,13,21.1,32.9,49.5,null,346,537,179]
["NRE is calculated using enthalpy of saturated suction",null,null,null,null,"5",40,16.399999999999999,29.8,51.1,83.1,129,195,null,6.56,11.9,20.399999999999999,33.200000000000003,51.8,77.8,null,543,844,281]
["vapor at evap temp.",null,null,null,null,"6",40,23.7,43.1,73.8,120,187,281,null,9.4700000000000006,17.2,29.5,48,74.8,112,null,785,1220,406]
[null,null,null,null,null,"8",40,41,74.599999999999994,128,208,324,487,null,16.399999999999999,29.8,51.1,83.1,129,195,null,1360,2110,703]
[null,null,null,null,null,"10",40,64.599999999999994,118,201,327,510,767,null,25.9,47,80.5,131,204,307,null,2140,3330,1110]
[null,null,null,null,null,"12",40,91.8,167,286,465,724,1090,null,36.700000000000003,66.8,114,186,290,436,null,3040,4720,1570]

{"sheet":"717 line capacities","index":1,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,7,1,12],[3,7,3,12],[0,7,0,12],[0,14,0,19],[1,14,1,19],[3,14,3,19]]}
["UOM",null,"IP","Req'd for",null,null,null,{"$f":"\"Suction line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Suction line capacity, tons refrigeration"},null,null,null,null,null,null,{"$f":"\"Minimum suction riser line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Minimum suction riser line capacity, tons refrigeration"},null,null,null,null,null,null,"Discharge","Liquid","Drain"]
[null,null,null,"line types",null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"},{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"},{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"}]
["Refrigerant",null,"717","All",null,null,null,-60,-40,-20,0,20,40,null,-60,-40,-20,0,20,40,null,"refrig","refrig","refrig"]
["Evap Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},5,"L, D, CD; S, SR spec'ed in table",null,"Steel Pipe",null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},null,null,null,null,null,null,{"$f":"\"Velocity, \"&IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"Velocity, ft/min"},null,null,null,null,null,null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},{"$f":"\"vel, \"&IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"vel, ft/min"}]
["Cond Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},100,"D",null,"NPS, in","Schedule",0.182,0.30599999999999999,0.48399999999999999,0.72799999999999998,1.05,1.46,null,1200,1200,1200,1200,1200,1200,null,3.3,2.78,100]
["Liquid Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},86,"All",null,"1/8",80,1.0500000000000001E-2,2.0199999999999999E-2,3.56E-2,5.8799999999999998E-2,9.1499999999999998E-2,0.13600000000000001,null,1.43E-2,2.6200000000000001E-2,4.5100000000000001E-2,7.3599999999999999E-2,0.115,0.17299999999999999,null,0.30299999999999999,2.4,2.27]
["Superheat",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},25,"S, SR, D",null,"1/4",80,2.7099999999999999E-2,5.16E-2,9.0499999999999997E-2,0.14799999999999999,0.23,0.34,null,2.81E-2,5.16E-2,8.8900000000000007E-2,0.14499999999999999,0.22700000000000001,0.34100000000000003,null,0.754,5.98,4.47]
["Equivalent Length",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},100,"All",null,"3/8",80,6.88E-2,0.13,0.22600000000000001,0.36899999999999999,0.56899999999999995,0.84,null,5.5199999999999999E-2,0.10100000000000001,0.17399999999999999,0.28499999999999998,0.44500000000000001,0.66800000000000004,null,1.86,14.7,8.77]
["Max Velocity, Suction",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"S",null,"1/2",80,0.13900000000000001,0.26,0.45100000000000001,0.73299999999999998,1.1299999999999999,1.66,null,9.1999999999999998E-2,0.16900000000000001,0.29099999999999998,0.47499999999999998,0.74099999999999999,1.1100000000000001,null,3.67,29.1,14.6]
["Max Velocity, Discharge",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"D",null,"3/4",80,0.32,0.59699999999999998,1.03,1.67,2.56,3.76,null,0.17,0.312,0.53700000000000003,0.877,1.37,2.06,null,8.2799999999999994,65.7,27]
["Max Velocity, Liquid","ft/min",300,"L",null,"1",80,0.63900000000000001,1.18,2.04,3.29,5.03,7.39,null,0.28299999999999997,0.51800000000000002,0.89300000000000002,1.46,2.2799999999999998,3.42,null,16.2,129,44.9]
["∆T, Suction",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},1,"S",null,"1-1/4",80,1.26,2.31,3.98,6.5,10.199999999999999,15.3,null,0.504,0.92400000000000004,1.59,2.6,4.0599999999999996,6.1,null,31.9,240,80.099999999999994]
["∆T, Discharge",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},1,"D",null,"1-1/2",80,1.74,3.18,5.48,8.9600000000000009,14,21,null,0.69399999999999995,1.27,2.19,3.58,5.6,8.4,null,44,331,110]
["∆T, Liquid","°F",1,"L",null,"2",40,3.3,6.04,10.4,17,26.6,39.9,null,1.32,2.42,4.17,6.8,10.6,16,null,83.5,628,209]
[null,null,null,null,null,"2-1/2",40,4.7,8.6199999999999992,14.9,24.3,37.9,56.9,null,1.88,3.45,5.94,9.7100000000000009,15.2,22.8,null,119,896,299]
["Effective Roughness",null,null,null,null,"3",40,7.26,13.3,22.9,37.5,58.5,87.9,null,2.9,5.33,9.18,15,23.4,35.200000000000003,null,184,1380,461]
["Steel Pipe",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"1.5E-4\",\"4.572E-5\")","v":"1.5E-4"},null,null,"3-1/2",40,9.7100000000000009,17.8,30.7,50.1,78.3,118,null,3.88,7.12,12.3,20,31.3,47,null,246,1850,617]
[null,null,null,null,null,"4",40,12.5,22.9,39.5,64.5,101,151,null,5,9.17,15.8,25.8,40.299999999999997,60.5,null,317,2380,794]
["Blue cells = input values",null,null,null,null,"5",40,19.600000000000001,36,62.1,101,158,238,null,7.86,14.4,24.8,40.6,63.3,95.2,null,498,3750,1250]
[null,null,null,null,null,"6",40,28.4,52,89.7,146,229,344,null,11.3,20.8,35.9,58.6,91.5,137,null,719,5410,1800]
[null,null,null,null,null,"8",40,49.1,90.1,155,254,396,595,null,19.7,36,62.1,101,158,238,null,1250,9370,3120]
["General guidelines regarding refrigerant velocity:",null,null,null,null,"10",40,77.400000000000006,142,245,400,624,938,null,31,56.8,97.9,160,250,375,null,1960,14800,4920]
[null,null,null,null,null,"12",40,110,202,347,567,886,1330,null,44,80.599999999999994,139,227,354,532,null,2790,21000,6990]
["For liquid lines, 400 ft/min maximum for lengths less than"]
["50 ft.  300 ft/min maximum for lengths 50 ft to 150 ft."]
["200 ft/min maximum for lengths exceeding 150 ft."]
[]
["For suction and discharge lines, 700 ft/min minimum and"]
["3000 ft/min maximum."]
[]
["For suction and discharge risers, 1200 ft/min minimum"]
["and 3000 ft/min maximum."]
[]
["For condenser drain lines, 100 ft/min maximum.  If a"]
["vent line is used, 180 ft/min maximum."]
[]
[]
["Notes: For discharge lines, refrigerant thermodynamic"]
["state is evaluated at isentropic compression + 50°F"]
[]
["NRE is calculated using enthalpy of saturated suction"]
["vapor at evap temp."]

{"sheet":"744 transcritical line cap","index":2,"n_rows":45,"n_cols":23,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,7,0,12],[0,14,0,19],[1,7,1,12],[1,14,1,19],[3,7,3,12],[3,14,3,19]]}
["UOM",null,"IP","Req'd for",null,null,null,{"$f":"\"Suction line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Suction line capacity, tons refrigeration"},null,null,null,null,null,null,{"$f":"\"Minimum suction riser line capacity, \"& IF($C$1=\"IP\",\"tons refrigeration\",\"kW\")","v":"Minimum suction riser line capacity, tons refrigeration"},null,null,null,null,null,null,"Discharge","Gas"]
[null,null,null,"line types",null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Saturated Suction Temperature, \"& IF($C$1=\"IP\",\"°F\",\"°C\")","v":"Saturated Suction Temperature, °F"},null,null,null,null,null,null,{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"},{"$f":"\"Line, \"&IF($C$1=\"IP\",\"tons\",\"kW\")","v":"Line, tons"}]
["Refrigerant",null,"744","All",null,null,null,-60,-40,-20,0,20,40,null,-60,-40,-20,0,20,40,null,"refrig","refrig"]
["Evap Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},0,"G, D; S, SR spec'ed in table",null,"Copper Tube",null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},null,null,null,null,null,null,{"$f":"\"Velocity, \"&IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"Velocity, ft/min"},null,null,null,null,null,null,{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"},{"$f":"\"∆P, \"&IF($C$1=\"IP\",\"psi\",\"bar\")","v":"∆P, psi"}]
["Gas Cooler Press",{"$f":"IF($C$1=\"IP\",\"psig\",\"bar(g)\")","v":"psig"},1400,"All",null,"OD, in","Type",0.53900000000000003,0.74399999999999999,0.99099999999999999,1.28,1.62,2.02,null,1200,1200,1200,1200,1200,1200,null,3.44,3.44]
["Gas Cooler Outlet Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},120,"All",null,"3/16","ACRA",1.91E-3,3.0899999999999999E-3,4.64E-3,6.4900000000000001E-3,8.3999999999999995E-3,9.7999999999999997E-3,null,0.01,1.6199999999999999E-2,2.4299999999999999E-2,3.4299999999999997E-2,4.5100000000000001E-2,5.3699999999999998E-2,null,1.8599999999999998E-2,2.7400000000000001E-2]
["Superheat",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},40,"S, SR, D",null,"1/4","ACRA",5.7000000000000002E-3,9.1800000000000007E-3,1.37E-2,1.9099999999999999E-2,2.47E-2,2.87E-2,null,2.23E-2,3.5900000000000001E-2,5.3999999999999999E-2,7.6200000000000004E-2,0.1,0.11899999999999999,null,5.4199999999999998E-2,0.08]
["Equivalent Length",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},100,"All",null,"5/16","ACRA",1.18E-2,1.9E-2,2.8299999999999999E-2,3.9399999999999998E-2,5.0700000000000002E-2,5.8999999999999997E-2,null,3.8199999999999998E-2,6.1400000000000003E-2,9.2399999999999996E-2,0.13,0.17100000000000001,0.20399999999999999,null,0.111,0.16400000000000001]
["Max Velocity, Suction",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"S",null,"3/8","194(1885)",2.3300000000000001E-2,3.73E-2,5.5500000000000001E-2,7.6999999999999999E-2,9.9000000000000005E-2,0.115,null,6.2899999999999998E-2,0.10100000000000001,0.152,0.215,0.28199999999999997,0.33600000000000002,null,0.216,0.318]
["Max Velocity, Discharge",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"D",null,"1/2","194(1885)",5.0799999999999998E-2,8.1199999999999994E-2,0.121,0.16700000000000001,0.214,0.248,null,0.112,0.18,0.27200000000000002,0.38300000000000001,0.504,0.6,null,0.46600000000000003,0.625]
["Max Velocity, Gas","ft/min",300,"G",null,"5/8","194(1885)",9.3799999999999994E-2,0.14899999999999999,0.221,0.30599999999999999,0.39300000000000002,0.45400000000000001,null,0.17699999999999999,0.28499999999999998,0.42799999999999999,0.60399999999999998,0.79500000000000004,0.94599999999999995,null,0.85199999999999998,0.98599999999999999]
["∆T, Suction",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},0.25,"S",null,"3/4","194(1885)",0.153,0.24299999999999999,0.36,0.497,0.63700000000000001,0.73699999999999999,null,0.255,0.41,0.61699999999999999,0.87,1.1399999999999999,1.36,null,1.38,1.42]
["∆T, Discharge",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},0.25,"D",null,"7/8","194(1885)",0.23100000000000001,0.36699999999999999,0.54300000000000004,0.749,0.95899999999999996,1.1100000000000001,null,0.34699999999999998,0.55800000000000005,0.84,1.18,1.56,1.85,null,2.0699999999999998,1.93]
["∆T, Gas","°F",0.25,"G",null,"1-1/8","194(1885)",0.45600000000000002,0.72399999999999998,1.07,1.47,1.88,2.17,null,0.57799999999999996,0.93,1.4,1.97,2.6,3.09,null,4.0599999999999996,3.22]
[null,null,null,null,null,"1-3/8","194(1885)",0.77700000000000002,1.23,1.81,2.5,3.19,3.68,null,0.86199999999999999,1.39,2.09,2.95,3.87,4.6100000000000003,null,6.87,4.8]
["Effective Roughness",null,null,null,null,"1-5/8","194(1885)",1.21,1.91,2.82,3.88,4.95,5.7,null,1.2,1.94,2.91,4.1100000000000003,5.4,6.43,null,10.6,6.7]
["Copper Tube",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"5.0E-6\",\"1.524E-6\")","v":"5.0E-6"},null,null,"2-1/8","194(1885)",2.46,3.89,5.73,7.86,10,11.5,null,2.06,3.31,4.9800000000000004,7.03,9.25,11,null,21.5,11.5]
["Steel Pipe",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"1.5E-4\",\"4.572E-5\")","v":"1.5E-4"},null,null,"2-5/8","194(1885)",4.3,6.79,10,13.7,17.399999999999999,20,null,3.14,5.05,7.6,10.7,14.1,16.8,null,37.299999999999997,17.5]
[null,null,null,null,null,"3-1/8","ACRD",8.7200000000000006,13.7,20.2,27.6,35.200000000000003,40.4,null,5.36,8.6199999999999992,13,18.3,24.1,28.7,null,75,29.9]
["Blue cells = input values",null,null,null,null,"3-5/8","ACRD",13,20.399999999999999,30,41,52.2,59.9,null,7.25,11.7,17.600000000000001,24.8,32.6,38.799999999999997,null,111,40.4]
[null,null,null,null,null,"4-1/8","ACRD",18.3,28.8,42.2,57.8,73.5,84.4,null,9.42,15.2,22.8,32.200000000000003,42.3,50.4,null,157,52.5]
["Reference:",null,null,null,null,"5-1/8","ACRD",32.799999999999997,51.6,75.5,103,131,150,null,14.7,23.6,35.6,50.2,66,78.5,null,279,81.8]
["Critical Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},{"$f":"IF($C$1=\"IP\",\"87.76\",\"30.98\")","v":"87.76"},null,null,"6-1/8","ACRD",52.8,82.9,121,166,210,241,null,21.1,34,51.1,72.099999999999994,94.8,113,null,447,118]
["Critical Press",{"$f":"IF($C$1=\"IP\",\"psig\",\"bar(g)\")","v":"psig"},{"$f":"IF($C$1=\"IP\",\"1055.29\",\"72.76\")","v":"1055.29"},null,null,"8-1/8","ACRD",92.2,148,223,315,414,493,null,36.9,59.3,89.3,126,166,197,null,921,205]
[]
[null,null,null,null,null,"Steel Pipe"]
["Notes: For discharge lines, refrigerant thermodynamic",null,null,null,null,"NPS, in","Schedule"]
["state is evaluated at isentropic compression + 50°F. ",null,null,null,null,"1/8",80,6.8199999999999997E-3,1.0699999999999999E-2,1.5599999999999999E-2,2.12E-2,2.6800000000000001E-2,3.0599999999999999E-2,null,2.86E-2,4.5999999999999999E-2,6.9199999999999998E-2,9.7600000000000006E-2,0.128,0.153,null,5.6500000000000002E-2,8.2199999999999995E-2]
[null,null,null,null,null,"1/4",80,1.7100000000000001E-2,2.6700000000000002E-2,3.8800000000000001E-2,5.2699999999999997E-2,6.6500000000000004E-2,7.5999999999999998E-2,null,5.6399999999999999E-2,9.0700000000000003E-2,0.13600000000000001,0.193,0.253,0.30099999999999999,null,0.14000000000000001,0.20399999999999999]
["NRE is calculated using enthalpy of saturated suction",null,null,null,null,"3/8",80,4.2200000000000001E-2,6.5699999999999995E-2,9.5299999999999996E-2,0.129,0.16300000000000001,0.186,null,0.111,0.17799999999999999,0.26800000000000002,0.378,0.497,0.59099999999999997,null,0.34300000000000003,0.498]
["vapor at evap temp.",null,null,null,null,"1/2",160,5.4600000000000003E-2,8.5099999999999995E-2,0.123,0.16700000000000001,0.21099999999999999,0.24099999999999999,null,0.13400000000000001,0.216,0.32500000000000001,0.45900000000000002,0.60299999999999998,0.71799999999999997,null,0.443,0.64400000000000002]
[null,null,null,null,null,"3/4",160,0.113,0.17599999999999999,0.255,0.34499999999999997,0.435,0.496,null,0.23100000000000001,0.372,0.56100000000000005,0.79100000000000004,1.04,1.24,null,0.91200000000000003,1.29]
["For discharge and gas lines, ∆P equivalent to ∆T is",null,null,null,null,"1",160,0.24199999999999999,0.376,0.54400000000000004,0.73699999999999999,0.92800000000000005,1.06,null,0.41,0.66100000000000003,0.99399999999999999,1.4,1.84,2.19,null,1.94,2.29]
["calculated as an isenthalpic process since ∆T in",null,null,null,null,"1-1/4",160,0.61699999999999999,0.95599999999999996,1.38,1.87,2.36,2.68,null,0.83199999999999996,1.34,2.0099999999999998,2.84,3.74,4.45,null,4.93,4.63]
["saturation temperature does not exist above critical",null,null,null,null,"1-1/2",160,0.9,1.39,2.0099999999999998,2.73,3.43,3.91,null,1.1100000000000001,1.78,2.68,3.78,4.97,5.92,null,7.18,6.16]
["temperature.",null,null,null,null,"2",160,1.66,2.57,3.71,5.0199999999999996,6.31,7.19,null,1.76,2.83,4.26,6.01,7.9,9.4,null,13.2,9.8000000000000007]
[null,null,null,null,null,"2-1/2",160,3.05,4.71,6.8,9.1999999999999993,11.6,13.2,null,2.79,4.49,6.76,9.5399999999999991,12.5,14.9,null,24.2,15.5]
[null,null,null,null,null,"3",160,5.31,8.1999999999999993,11.8,16,20.100000000000001,22.9,null,4.26,6.85,10.3,14.5,19.100000000000001,22.8,null,42,23.7]
[null,null,null,null,null,"3-1/2",80,10.199999999999999,15.7,22.7,30.6,38.6,43.9,null,6.99,11.3,16.899999999999999,23.9,31.4,37.4,null,80.5,39]
[null,null,null,null,null,"4",160,10.8,16.600000000000001,24,32.4,40.799999999999997,46.5,null,7.3,11.8,17.7,25,32.799999999999997,39.1,null,85.2,40.700000000000003]
[null,null,null,null,null,"5",160,19.5,30.1,43.5,58.7,73.8,84,null,11.5,18.5,27.8,39.299999999999997,51.6,61.5,null,154,64.099999999999994]
[null,null,null,null,null,"6",160,31.6,48.8,70.400000000000006,95.1,120,136,null,16.600000000000001,26.8,40.299999999999997,56.8,74.7,88.9,null,250,92.6]
[null,null,null,null,null,"8",160,64.5,99.5,143,194,243,277,null,28.7,46.2,69.5,98,129,153,null,508,160]
[null,null,null,null,null,"10",160,112,177,255,345,433,493,null,44.6,71.8,108,153,201,239,null,904,249]
[null,null,null,null,null,"12",160,158,255,384,541,683,777,null,63.4,102,153,217,285,339,null,1430,353]

{"sheet":"Refrigerant line detail","index":3,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["UOM",null,"IP","Req'd for",null,null,null,null,null,null,null,null,"Darcy"]
["Refrigerant Line Type",null,"Discharge","line types",null,"Copper Tube",null,null,"Capacity","Mass Flow","Velocity","Reynold's","Friction","Relative","∆P","∆T"]
["Refrigerant",null,{"$f":"VLOOKUP($E$3,'refrigerant list'!A1:B47,2)","v":"449A"},"All",26,"OD, in","Type","ID, in",{"$f":"IF($C$1=\"IP\",\"tons\",\"kW\")","v":"tons"},{"$f":"IF($C$1=\"IP\",\"lbm/min\",\"kg/s\")","v":"lbm/min"},{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},"Number","Factor","Roughness",{"$f":"IF($C$1=\"IP\",\"psi\",\"bar\")","v":"psi"},{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"}]
["Evap Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},-40,"All",null,"3/16","ACRA",0.1275,2.81E-2,0.1134,356,20250,2.681E-2,4.706E-4,3.44,1]
["Cond Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},105,"D",null,"1/4","ACRA",0.19,8.2299999999999998E-2,0.33229999999999998,470,39810,2.2960000000000001E-2,3.1579999999999998E-4,3.44,1]
["Liquid Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},105,"All",null,"5/16","ACRA",0.2485,0.16900000000000001,0.68240000000000001,564,62510,2.0830000000000001E-2,2.4140000000000001E-4,3.44,1]
["Suction Vapor Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},-15,"S, SR, D",null,"3/8","ACRA",0.311,0.308,1.2430000000000001,655,90970,1.9279999999999999E-2,1.929E-4,3.44,1]
["Equivalent Length",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},100,"All",null,"1/2","ACRA",0.436,0.75700000000000001,3.056,820,159600,1.7270000000000001E-2,1.3760000000000001E-4,3.44,1]
["Maximum Velocity",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"SR, CD; optional for L, S, D",null,"5/8","ACRD",0.54500000000000004,1.37,5.5259999999999998,949,230800,1.6119999999999999E-2,1.1010000000000001E-4,3.44,1]
["Rating, ∆T",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},1,"L, S, D",null,"3/4","ACRD",0.66600000000000004,2.33,9.3979999999999997,1080,321200,1.519E-2,9.009E-5,3.44,1]
[null,null,null,null,null,"7/8","ACRD",0.78500000000000003,3.59,14.51,1200,420900,1.4489999999999999E-2,7.6429999999999998E-5,3.44,1]
["Effective Roughness",null,null,null,null,"1-1/8","ACRD",1.0249999999999999,7.27,29.34,1420,651500,1.346E-2,5.8539999999999999E-5,3.44,1]
["Copper Tube",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"5.0E-6\",\"1.524E-6\")","v":"5.0E-6"},null,null,"1-3/8","ACRD",1.2649999999999999,12.6,51.04,1630,918500,1.273E-2,4.7429999999999998E-5,3.44,1]
["Steel Pipe",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"1.5E-4\",\"4.572E-5\")","v":"1.5E-4"},null,null,"1-5/8","ACRD",1.5049999999999999,20,80.58,1810,1219000,1.217E-2,3.9870000000000003E-5,3.44,1]
[null,null,null,null,null,"2-1/8","ACRD",1.9850000000000001,41.3,166.6,2160,1910000,1.137E-2,3.023E-5,3.44,1]
["Density",{"$f":"IF($C$1=\"IP\",\"lbm/ft3\",\"kg/m3\")","v":"lbm/ft3"},3.5939999999999999,null,null,"2-5/8","ACRD",2.4649999999999999,72.7,293.7,2470,2712000,1.0800000000000001E-2,2.4340000000000001E-5,3.44,1]
["NRE",{"$f":"IF($C$1=\"IP\",\"Btu/lbm\",\"kJ/kg\")","v":"Btu/lbm"},49.53,null,null,"3-1/8","ACRD",2.9449999999999998,116,467.6,2750,3614000,1.0370000000000001E-2,2.037E-5,3.44,1]
["Dynamic Viscosity",{"$f":"IF($C$1=\"IP\",\"lbm/ft-s\",\"cP\")","v":"lbm/ft-s"},1.119E-5,null,null,"3-5/8","ACRD",3.4249999999999998,171,689.9,3000,4585000,1.0030000000000001E-2,1.7520000000000002E-5,3.41,0.94299999999999995]
[null,null,null,null,null,"4-1/8","ACRD",3.9049999999999998,222,896.8,3000,5228000,9.8169999999999993E-3,1.5359999999999999E-5,2.93,0.80900000000000005]
["Blue cells = input values",null,null,null,null,"5-1/8","ACRD",4.875,346,1398,3000,6526000,9.4680000000000007E-3,1.2310000000000001E-5,2.2599999999999998,0.625]
[null,null,null,null,null,"6-1/8","ACRD",5.8449999999999998,498,2009,3000,7825000,9.1970000000000003E-3,1.027E-5,1.83,0.50600000000000001]
[null,null,null,null,null,"8-1/8","ACRD",7.7249999999999996,869,3510,3000,10340000,8.8009999999999998E-3,7.7670000000000003E-6,1.33,0.36599999999999999]
["General guidelines regarding refrigerant velocity:"]
[null,null,null,null,null,"Steel Pipe"]
["For liquid lines, 400 ft/min maximum for lengths less than",null,null,null,null,"NPS, in","Schedule"]
["50 ft.  300 ft/min maximum for lengths 50 ft to 150 ft.",null,null,null,null,"1/8",80,0.215,8.7800000000000003E-2,0.35449999999999998,391,37530,3.7420000000000002E-2,8.3719999999999992E-3,3.44,1]
["200 ft/min maximum for lengths exceeding 150 ft.",null,null,null,null,"1/4",80,0.30199999999999999,0.218,0.87919999999999998,492,66270,3.3270000000000001E-2,5.96E-3,3.44,1]
[null,null,null,null,null,"3/8",80,0.42299999999999999,0.53400000000000003,2.1560000000000001,615,116000,2.9819999999999999E-2,4.2550000000000001E-3,3.44,1]
["For suction and discharge lines, 700 ft/min minimum and",null,null,null,null,"1/2",80,0.54600000000000004,1.05,4.2450000000000001,726,177000,2.7570000000000001E-2,3.297E-3,3.44,1]
["3000 ft/min maximum.",null,null,null,null,"3/4",80,0.74199999999999999,2.37,9.56,886,293300,2.5190000000000001E-2,2.4260000000000002E-3,3.44,1]
[null,null,null,null,null,"1",80,0.95699999999999996,4.6399999999999997,18.72,1040,445200,2.3460000000000002E-2,1.8810000000000001E-3,3.44,1]
["For suction and discharge risers, 1200 ft/min minimum",null,null,null,null,"1-1/4",80,1.278,9.93,40.1,1250,714300,2.1700000000000001E-2,1.408E-3,3.44,1]
["and 3000 ft/min maximum.",null,null,null,null,"1-1/2",80,1.5,15.1,61.11,1390,927400,2.0809999999999999E-2,1.1999999999999999E-3,3.44,1]
[null,null,null,null,null,"2",40,2.0670000000000002,35.1,141.80000000000001,1690,1562000,1.9199999999999998E-2,8.7080000000000002E-4,3.44,1]
["For condenser drain lines, 100 ft/min maximum.  If a",null,null,null,null,"2-1/2",40,2.4689999999999999,56,226,1890,2084000,1.839E-2,7.2900000000000005E-4,3.44,1]
["vent line is used, 180 ft/min maximum.",null,null,null,null,"3",40,3.0680000000000001,98.9,399.2,2160,2962000,1.746E-2,5.867E-4,3.44,1]
[null,null,null,null,null,"3-1/2",40,3.548,145,583.9,2370,3746000,1.6879999999999999E-2,5.0730000000000003E-4,3.44,1]
[null,null,null,null,null,"4",40,4.0259999999999998,201,812.5,2560,4594000,1.6400000000000001E-2,4.4710000000000003E-4,3.44,1]
["Notes: For discharge lines, refrigerant thermodynamic",null,null,null,null,"5",40,5.0469999999999997,363,1466,2940,6612000,1.5599999999999999E-2,3.5659999999999999E-4,3.44,1]
["state is evaluated at isentropic compression + 50°F",null,null,null,null,"6",40,6.0650000000000004,536,2163,3000,8120000,1.499E-2,2.968E-4,2.88,0.79600000000000004]
[null,null,null,null,null,"8",40,7.9809999999999999,928,3746,3000,10680000,1.4160000000000001E-2,2.2550000000000001E-4,2.06,0.56999999999999995]
["NRE is calculated using enthalpy of saturated suction",null,null,null,null,"10",40,10.02,1460,5905,3000,13410000,1.3520000000000001E-2,1.796E-4,1.57,0.433]
["vapor at evap temp.",null,null,null,null,"12",40,11.94,2080,8382,3000,15980000,1.3050000000000001E-2,1.5080000000000001E-4,1.27,0.35099999999999998]

{"sheet":"744 transcritical line detail","index":4,"n_rows":43,"n_cols":16,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["UOM",null,"IP","Req'd for",null,null,null,null,null,null,null,null,"Darcy"]
["Refrigerant Line Type",null,"Discharge","line types",null,"Copper Tube",null,null,"Capacity","Mass Flow","Velocity","Reynold's","Friction","Relative","∆P","∆T"]
["Refrigerant",null,"744",null,null,"OD, in","Type","ID, in",{"$f":"IF($C$1=\"IP\",\"tons\",\"kW\")","v":"tons"},{"$f":"IF($C$1=\"IP\",\"lbm/min\",\"kg/s\")","v":"lbm/min"},{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},"Number","Factor","Roughness",{"$f":"IF($C$1=\"IP\",\"psi\",\"bar\")","v":"psi"},{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"}]
["Evap Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},0,"All",null,"3/16","ACRA",0.1275,4.58E-2,0.22739999999999999,266,30120,2.469E-2,4.706E-4,4.75,0.25]
["Gas Cooler Press",{"$f":"IF($C$1=\"IP\",\"psig\",\"bar(g)\")","v":"psig"},1400,"All",null,"1/4","ACRA",0.19,0.13400000000000001,0.6633,349,58960,2.1319999999999999E-2,3.1579999999999998E-4,4.75,0.25]
["Gas Cooler Outlet Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},110,"All",null,"5/16","ACRA",0.2485,0.27300000000000002,1.359,418,92330,1.9449999999999999E-2,2.4140000000000001E-4,4.75,0.25]
["Suction Vapor Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},40,"S, SR, D",null,"3/8","194(1885)",0.31900000000000001,0.53200000000000003,2.6419999999999999,494,139900,1.7940000000000001E-2,1.8809999999999999E-4,4.75,0.25]
["Equivalent Length",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},100,"All",null,"1/2","194(1885)",0.42599999999999999,1.1499999999999999,5.6920000000000002,596,225700,1.6400000000000001E-2,1.4080000000000001E-4,4.75,0.25]
["Maximum Velocity",{"$f":"IF($C$1=\"IP\",\"ft/min\",\"m/s\")","v":"ft/min"},3000,"SR; optional for G, S, D",null,"5/8","194(1885)",0.53500000000000003,2.09,10.4,691,328400,1.5339999999999999E-2,1.121E-4,4.75,0.25]
["Rating, ∆T",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},0.25,"G, S, D",null,"3/4","194(1885)",0.64200000000000002,3.39,16.84,777,443000,1.457E-2,9.3460000000000003E-5,4.75,0.25]
[null,null,null,null,null,"7/8","194(1885)",0.749,5.09,25.28,857,570100,1.397E-2,8.0110000000000004E-5,4.75,0.25]
["Effective Roughness",null,null,null,null,"1-1/8","194(1885)",0.96699999999999997,10,49.53,1010,865100,1.306E-2,6.2050000000000004E-5,4.75,0.25]
["Copper Tube",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"5.0E-6\",\"1.524E-6\")","v":"5.0E-6"},null,null,"1-3/8","194(1885)",1.181,16.899999999999999,83.74,1140,1198000,1.2409999999999999E-2,5.0800000000000002E-5,4.75,0.25]
["Steel Pipe",{"$f":"IF($C$1=\"IP\",\"ft\",\"m\")","v":"ft"},{"$f":"IF($C$1=\"IP\",\"1.5E-4\",\"4.572E-5\")","v":"1.5E-4"},null,null,"1-5/8","194(1885)",1.395,26.1,129.6,1270,1569000,1.191E-2,4.3010000000000003E-5,4.75,0.25]
[null,null,null,null,null,"2-1/8","194(1885)",1.825,52.7,261.89999999999998,1500,2424000,1.1180000000000001E-2,3.2879999999999997E-5,4.75,0.25]
["Density",{"$f":"IF($C$1=\"IP\",\"lbm/ft3\",\"kg/m3\")","v":"lbm/ft3"},9.641,null,null,"2-5/8","194(1885)",2.2530000000000001,91.4,454.3,1700,3406000,1.065E-2,2.6630000000000001E-5,4.75,0.25]
["NRE",{"$f":"IF($C$1=\"IP\",\"Btu/lbm\",\"kJ/kg\")","v":"Btu/lbm"},40.26,null,null,"3-1/8","ACRD",2.9449999999999998,184,914,2000,5242000,1.005E-2,2.037E-5,4.75,0.25]
["Dynamic Viscosity",{"$f":"IF($C$1=\"IP\",\"lbm/ft-s\",\"cP\")","v":"lbm/ft-s"},1.508E-5,null,null,"3-5/8","ACRD",3.4249999999999998,273,1355,2200,6680000,9.7300000000000008E-3,1.7520000000000002E-5,4.75,0.25]
[null,null,null,null,null,"4-1/8","ACRD",3.9049999999999998,384,1906,2380,8244000,9.4680000000000007E-3,1.5359999999999999E-5,4.75,0.25]
["Blue cells = input values",null,null,null,null,"5-1/8","ACRD",4.875,683,3394,2720,11760000,9.0530000000000003E-3,1.2310000000000001E-5,4.75,0.25]
[null,null,null,null,null,"6-1/8","ACRD",5.8449999999999998,1080,5390,3000,15570000,8.7419999999999998E-3,1.027E-5,4.67,0.246]
[null,null,null,null,null,"8-1/8","ACRD",7.7249999999999996,1890,9414,3000,20580000,8.3700000000000007E-3,7.7670000000000003E-6,3.38,0.17799999999999999]
["Reference:"]
["Critical Temp",{"$f":"IF($C$1=\"IP\",\"°F\",\"°C\")","v":"°F"},{"$f":"IF($C$1=\"IP\",\"87.76\",\"30.98\")","v":"87.76"},null,null,"Steel Pipe"]
["Critical Press",{"$f":"IF($C$1=\"IP\",\"psig\",\"bar(g)\")","v":"psig"},{"$f":"IF($C$1=\"IP\",\"1055.29\",\"72.76\")","v":"1055.29"},null,null,"NPS, in","Schedule"]
[null,null,null,null,null,"1/8",80,0.215,0.13800000000000001,0.68659999999999999,282,53940,3.6920000000000001E-2,8.3719999999999992E-3,4.75,0.25]
[null,null,null,null,null,"1/4",80,0.30199999999999999,0.34200000000000003,1.7010000000000001,355,95110,3.2899999999999999E-2,5.96E-3,4.75,0.25]
["Notes: For discharge lines, refrigerant thermodynamic",null,null,null,null,"3/8",80,0.42299999999999999,0.83899999999999997,4.1669999999999998,443,166400,2.955E-2,4.2550000000000001E-3,4.75,0.25]
["state is evaluated at isentropic compression + 50°F. ",null,null,null,null,"1/2",160,0.46600000000000003,1.08,5.3869999999999996,472,195200,2.869E-2,3.8630000000000001E-3,4.75,0.25]
[null,null,null,null,null,"3/4",160,0.61199999999999999,2.23,11.09,563,306000,2.6460000000000001E-2,2.941E-3,4.75,0.25]
["NRE is calculated using enthalpy of saturated suction",null,null,null,null,"1",160,0.81499999999999995,4.76,23.64,677,489800,2.4379999999999999E-2,2.209E-3,4.75,0.25]
["vapor at evap temp.",null,null,null,null,"1-1/4",160,1.1599999999999999,12.1,59.93,847,872500,2.2159999999999999E-2,1.552E-3,4.75,0.25]
[null,null,null,null,null,"1-1/2",160,1.3380000000000001,17.600000000000001,87.24,927,1101000,2.1350000000000001E-2,1.3450000000000001E-3,4.75,0.25]
["For discharge and gas lines, ∆P equivalent to ∆T is",null,null,null,null,"2",160,1.6870000000000001,32.299999999999997,160.4,1070,1606000,2.0119999999999999E-2,1.067E-3,4.75,0.25]
["calculated as an isenthalpic process since ∆T in",null,null,null,null,"2-1/2",160,2.125,59.2,293.89999999999998,1240,2336000,1.9009999999999999E-2,8.4710000000000004E-4,4.75,0.25]
["saturation temperature does not exist above critical",null,null,null,null,"3",160,2.6240000000000001,103,510.8,1410,3287000,1.8069999999999999E-2,6.8599999999999998E-4,4.75,0.25]
["temperature.",null,null,null,null,"3-1/2",80,3.3639999999999999,197,978.4,1640,4912000,1.7049999999999999E-2,5.3510000000000005E-4,4.75,0.25]
[null,null,null,null,null,"4",160,3.4380000000000002,208,1036,1670,5088000,1.6959999999999999E-2,5.2360000000000004E-4,4.75,0.25]
[null,null,null,null,null,"5",160,4.3129999999999997,377,1873,1910,7335000,1.6119999999999999E-2,4.1730000000000001E-4,4.75,0.25]
[null,null,null,null,null,"6",160,5.1870000000000003,610,3032,2140,9873000,1.5469999999999999E-2,3.4699999999999998E-4,4.75,0.25]
[null,null,null,null,null,"8",160,6.8129999999999997,1240,6173,2530,15300000,1.4590000000000001E-2,2.6420000000000003E-4,4.75,0.25]
[null,null,null,null,null,"10",160,8.5,2210,10980,2890,21830000,1.393E-2,2.118E-4,4.75,0.25]
[null,null,null,null,null,"12",160,10.130000000000001,3260,16180,3000,26980000,1.3440000000000001E-2,1.7780000000000001E-4,4.1399999999999997,0.218]

{"sheet":"refrigerant list","index":5,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[1,"12"]
[2,"134a"]
[3,"22"]
[4,"245fa"]
[5,"290"]
[6,"32"]
[7,"401A"]
[8,"402A"]
[9,"404A"]
[10,"407A"]
[11,"407C"]
[12,"407F"]
[13,"407H"]
[14,"408A"]
[15,"409A"]
[16,"410A"]
[17,"422A"]
[18,"422B"]
[19,"422D"]
[20,"427A"]
[21,"438A"]
[22,"441A"]
[23,"442A"]
[24,"447A"]
[25,"448A"]
[26,"449A"]
[27,"450A"]
[28,"452A"]
[29,"452B"]
[30,"454A"]
[31,"454B"]
[32,"454C"]
[33,"455A"]
[34,"457A"]
[35,"458A"]
[36,"459B"]
[37,"466A"]
[38,"470A"]
[39,"507"]
[40,"513A"]
[41,"516A"]
[42,"600a"]
[43,"717"]
[44,744]
[45,"744A"]
[46,"1234yf"]
[47,"1234zee"]

{"sheet":"uom list","index":6,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["IP"]
["SI"]

{"sheet":"available line sizes","index":7,"n_rows":150,"n_cols":3,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
["Copper tube"]
[]
["Tube OD","Type","Tube ID"]
["1/8","ACRA",6.5000000000000002E-2]
["3/16","ACRA",0.1275]
["1/4","ACRA",0.19]
["5/16","ACRA",0.2485]
["3/8","ACRA",0.311]
["1/2","ACRA",0.436]
["5/8","ACRA",0.55500000000000005]
["3/4","ACRA",0.68]
["7/8","ACRA",0.78500000000000003]
["1-1/8","ACRA",1.0249999999999999]
["1-3/8","ACRA",1.2649999999999999]
["1-5/8","ACRA",1.5049999999999999]
["1/4","ACRD",0.2]
["3/8","ACRD",0.315]
["1/2","ACRD",0.43]
["5/8","ACRD",0.54500000000000004]
["3/4","ACRD",0.66600000000000004]
["7/8","ACRD",0.78500000000000003]
["1-1/8","ACRD",1.0249999999999999]
["1-3/8","ACRD",1.2649999999999999]
["1-5/8","ACRD",1.5049999999999999]
["2-1/8","ACRD",1.9850000000000001]
["2-5/8","ACRD",2.4649999999999999]
["3-1/8","ACRD",2.9449999999999998]
["3-5/8","ACRD",3.4249999999999998]
["4-1/8","ACRD",3.9049999999999998]
["5-1/8","ACRD",4.875]
["6-1/8","ACRD",5.8449999999999998]
["8-1/8","ACRD",7.7249999999999996]
["3/8","194(1160)",0.32700000000000001]
["1/2","194(1160)",0.45200000000000001]
["5/8","194(1160)",0.56699999999999995]
["3/4","194(1160)",0.68]
["7/8","194(1160)",0.79300000000000004]
["1-1/8","194(1160)",1.0229999999999999]
["1-3/8","194(1160)",1.2509999999999999]
["1-5/8","194(1160)",1.4810000000000001]
["2-1/8","194(1160)",1.931]
["2-5/8","194(1160)",2.3889999999999998]
["3/8","194(1885)",0.31900000000000001]
["1/2","194(1885)",0.42599999999999999]
["5/8","194(1885)",0.53500000000000003]
["3/4","194(1885)",0.64200000000000002]
["7/8","194(1885)",0.749]
["1-1/8","194(1885)",0.96699999999999997]
["1-3/8","194(1885)",1.181]
["1-5/8","194(1885)",1.395]
["2-1/8","194(1885)",1.825]
["2-5/8","194(1885)",2.2530000000000001]
[]
["Steel pipe"]
[]
["Nominal"]
["Pipe Size","Schedule","Pipe ID"]
["1/8",40,0.26900000000000002]
["1/4",40,0.36399999999999999]
["3/8",40,0.49299999999999999]
["1/2",40,0.622]
["3/4",40,0.82399999999999995]
["1",40,1.0489999999999999]
["1-1/4",40,1.38]
["1-1/2",40,1.61]
["2",40,2.0670000000000002]
["2-1/2",40,2.4689999999999999]
["3",40,3.0680000000000001]
["3-1/2",40,3.548]
["4",40,4.0259999999999998]
["5",40,5.0469999999999997]
["6",40,6.0650000000000004]
["8",40,7.9809999999999999]
["10",40,10.02]
["12",40,11.938000000000001]
["14",40,13.124000000000001]
["16",40,15]
["18",40,16.876000000000001]
["20",40,18.812000000000001]
["24",40,22.623999999999999]
["32",40,30.623999999999999]
["34",40,32.624000000000002]
["36",40,34.5]
["1/8",80,0.215]
["1/4",80,0.30199999999999999]
["3/8",80,0.42299999999999999]
["1/2",80,0.54600000000000004]
["3/4",80,0.74199999999999999]
["1",80,0.95699999999999996]
["1-1/4",80,1.278]
["1-1/2",80,1.5]
["2",80,1.9390000000000001]
["2-1/2",80,2.323]
["3",80,2.9]
["3-1/2",80,3.3639999999999999]
["4",80,3.8260000000000001]
["5",80,4.8129999999999997]
["6",80,5.7610000000000001]
["8",80,7.625]
["10",80,9.5619999999999994]
["12",80,11.374000000000001]
["14",80,12.5]
["16",80,14.311999999999999]
["18",80,16.123999999999999]
["20",80,17.937999999999999]
["22",80,19.75]
["24",80,21.562000000000001]
["4",120,3.6240000000000001]
["5",120,4.5629999999999997]
["6",120,5.5010000000000003]
["8",120,7.1870000000000003]
["10",120,9.0619999999999994]
["12",120,10.75]
["14",120,11.811999999999999]
["16",120,13.561999999999999]
["18",120,15.25]
["20",120,17]
["22",120,18.75]
["24",120,20.376000000000001]
["1/2",160,0.46600000000000003]
["3/4",160,0.61199999999999999]
["1",160,0.81499999999999995]
["1-1/4",160,1.1599999999999999]
["1-1/2",160,1.3380000000000001]
["2",160,1.6870000000000001]
["2-1/2",160,2.125]
["3",160,2.6240000000000001]
["4",160,3.4380000000000002]
["5",160,4.3129999999999997]
["6",160,5.1870000000000003]
["8",160,6.8129999999999997]
["10",160,8.5]
["12",160,10.125999999999999]
["14",180,11.188000000000001]
["16",160,12.811999999999999]
["18",160,14.438000000000001]
["20",160,16.062000000000001]
["22",160,17.75]
["24",160,19.312000000000001]
["1/2","XXS",0.252]
["3/4","XXS",0.434]
["1","XXS",0.59899999999999998]
["1-1/4","XXS",0.89600000000000002]
["1-1/2","XXX",1.1000000000000001]
["2","XXS",1.5029999999999999]
["2-1/2","XXS",1.7709999999999999]
["3","XXS",2.2999999999999998]
["4","XXS",3.1520000000000001]
["5","XXS",4.0629999999999997]
["6","XXS",4.8970000000000002]

{"sheet":"refrigerant line types","index":8,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Liquid"]
["Suction"]
["Suction Riser"]
["Discharge"]
["Condenser Drain"]

{"sheet":"refrigerant line types CO2","index":9,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Gas"]
["Suction"]
["Suction Riser"]
["Discharge"]