{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":49,"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":"Sheet1","index":0,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Air Properties Table 5"]
["Tfi",320,"C",null,"Tsi",314.52190006684287,"C",null,null,"Air Properties Table 1",null,null,null,null,"Air Properties Table 2",null,null,null,null,"Air Properties Table 3",null,null,null,null,null,"Steel Properties Table 4",null,null,null,"Match","T (K)","Cp (J/Kg*K)"]
["Tfo (guess)",314.97607575725834,"C",null,"Tso",313.41820421506389,"C",null,"Match","T (R)","h (btu/lbm)",null,null,"Match","T (°F)","mu (lbf*s/ft^2)","nu (ft^2/s)",null,"Match","T (K)","alpha (m^2/s)","K (W/mK)","Pr",null,"Match","T (K)","K (W/m*K)","Cp (J/Kg*K)",null,1,250,1002.9999999999999]
["Tinf",90,"°F",null,null,null,null,null,1,540,129.06,null,null,1,-40,3.29,1.1200000000000001,null,1,100,2.54,9.34,0.78600000000000003,null,1,100,9.1999999999999993,272,null,2,300,1004.9999999999999]
["Pavg",80,"psi",null,"Mu",28.97,"kg/kmol",null,2,560,133.86000000000001,null,null,2,-20,3.34,1.19,null,2,150,5.84,13.8,0.75800000000000001,null,2,200,12.6,402,null,3,350,1008]
["Di",{"$f":"0.402/12","v":3.3500000000000002E-2},"ft",null,"Ru",8314,"J/kmol*K",null,3,580,138.66,null,null,3,0,3.38,1.26,null,3,200,10.3,18.100000000000001,0.73699999999999999,null,3,300,14.9,477,null,4,400,1012.9999999999999]
["Do",{"$f":"0.5/12","v":4.1666666666666664E-2},"ft",null,null,null,null,null,4,600,143.47,null,null,4,10,3.44,1.31,null,4,250,15.9,22.3,0.72,null,4,400,16.600000000000001,515,null,5,450,1020]
["L",1.5,"ft",null,null,null,null,null,5,620,148.28,null,null,5,20,3.5,1.36,null,5,300,22.5,26.3,0.70699999999999996,null,5,600,19.8,557,null,6,500,1029]
["Mdot",0.13500000000000001,"lbm/s",null,null,null,null,null,6,640,153.09,null,null,6,30,3.58,1.42,null,6,350,29.9,30,0.7,null,6,800,22.6,582,null,7,550,1040]
["Wind Velocity",10,"mph",null,null,null,null,null,7,660,157.91999999999999,null,null,7,40,3.6,1.46,null,7,400,38.299999999999997,33.799999999999997,0.69,null,null,null,null,null,null,8,600,1051]
["Max Error",1,"W",null,null,null,null,null,8,680,162.72999999999999,null,null,8,50,3.68,1.52,null,8,450,47.2,37.299999999999997,0.68600000000000005,null,null,"Value","Low","High",null,9,650,1063]
[null,null,null,null,"Tf_ie",{"$f":"Tf_i*1.8","v":1067.67},"R",null,9,700,167.56,null,null,9,60,3.75,1.58,null,9,500,56.7,40.700000000000003,0.68400000000000005,null,"Ts_avg",{"$f":"Ts_avg","v":587.12005214095336},{"$f":"VLOOKUP(Ts_avg,Z4:Z10,1)","v":400},{"$f":"VLOOKUP(MATCH(Ts_avg,$Z$5:$Z$10)+1,$Y$5:$Z$10,2)","v":600},null,10,700,1075]
["Tf_i",{"$f":"Tfi+273.15","v":593.15},"K",null,"Tf_oe",{"$f":"Tf_o*1.8","v":1058.6269363630652},"R",null,10,720,172.39,null,null,10,70,3.82,1.64,null,10,550,66.7,43.9,0.68300000000000005,null,"K",{"$f":"(Z13-AA13)/(AB13-AA13)*(AB14-AA14)+AA14","v":22.213601564228604},{"$f":"VLOOKUP(Ts_avg,Z4:AA10,2)","v":16.600000000000001},{"$f":"VLOOKUP(MATCH(Ts_avg,$Z$4:$Z$10)+1,Y4:AA10,3)","v":22.6}]
["Tf_o (guess)",{"$f":"Tfo+273.15","v":588.12607575725838},"K",null,null,null,null,null,11,740,177.23,null,null,11,80,3.86,1.69,null,11,600,76.900000000000006,46.9,0.68500000000000005,null,"Cp",{"$f":"(Z13-AA13)/(AB13-AA13)*(AB15-AA15)+AA15","v":577.68521746721933},{"$f":"VLOOKUP(Ts_avg,Z4:AB10,3)","v":515},{"$f":"VLOOKUP(MATCH(Ts_avg,$Z$4:$Z$10)+1,Y4:AB10,4)","v":582},null,null,"Value","Low","High"]
["Tinf",{"$f":"CONVERT(B5,\"F\",\"K\")","v":305.37222222222221},"K",null,"Tf_avg",{"$f":"(B14+B15)/2","v":590.63803787862912},"K",null,12,760,182.08,null,null,12,90,3.9,1.74,null,12,650,87.3,49.7,0.69,null,null,null,null,null,null,"Tf_avg",{"$f":"Tf_avg","v":590.63803787862912},{"$f":"VLOOKUP(Tf_avg,AE4:AE13,1)","v":550},{"$f":"VLOOKUP(MATCH(Tf_avg,$AE$4:$AE$13)+1,$AD$4:$AE$13,2)","v":600}]
["Pavg",{"$f":"B6*6894.75729","v":551580.58319999999},"Pa",null,null,{"$f":"CONVERT(Tf_avg,\"K\",\"F\")","v":603.47846818153243},"°F",null,13,780,186.94,null,null,13,100,3.94,1.79,null,null,null,null,null,null,null,null,null,null,null,null,"Cp",{"$f":"(AE16-AF16)/(AG16-AF16)*(AG17-AF17)+AF17","v":1048.9403683332985},{"$f":"VLOOKUP(Tf_avg,AE4:AF13,2)","v":1040},{"$f":"VLOOKUP(MATCH(Tf_avg,$AE$4:$AE$13)+1,AD4:AF13,3)","v":1051}]
["Di",{"$f":"CONVERT(B7,\"ft\",\"m\")","v":1.0210800000000001E-2},"m",null,null,null,null,null,14,800,191.69,null,null,14,120,4.0199999999999996,1.89,null,null,"Value","Low","High"]
["Do",{"$f":"CONVERT(B8,\"ft\",\"m\")","v":1.2699999999999999E-2},"m",null,"Ts_i",{"$f":"CONVERT(Tsi,\"C\",\"K\")","v":587.67190006684291},"K",null,15,820,196.69,null,null,15,140,4.13,2.0099999999999998,null,"Tf_avg",{"$f":"Tf_avg","v":590.63803787862912},{"$f":"VLOOKUP(Tf_avg,T5:T16,1)","v":550},{"$f":"VLOOKUP(MATCH(Tf_avg,$T$5:$T$16)+1,$S$5:$T$16,2)","v":600}]
["L",{"$f":"CONVERT(B9,\"ft\",\"m\")","v":0.4572},"m",null,"Ts_o",{"$f":"CONVERT(Tso,\"C\",\"K\")","v":586.56820421506382},"K",null,16,840,201.56,null,null,16,160,4.22,2.12,null,"alpha",{"$f":"((T19-U19)/(V19-U19)*(V20-U20)+U20)*10^-6","v":7.499015972724033E-5},{"$f":"VLOOKUP(Tf_avg,T5:U16,2)","v":66.7},{"$f":"VLOOKUP(MATCH(Tf_avg,$T$5:$T$16)+1,S5:U16,3)","v":76.900000000000006}]
["Mdot",{"$f":"CONVERT(B10,\"lbm\",\"kg\")","v":6.1234969950000009E-2},"kg/s",null,"Ts_avge",{"$f":"(Ts_i+Ts_o)/2","v":587.12005214095336},"K",null,17,860,206.46,null,null,17,180,4.34,2.25,null,"K",{"$f":"((T19-U19)/(V19-U19)*(V21-U21)+U21)*10^-3","v":4.8614012393920984E-2},{"$f":"VLOOKUP(Tf_avg,T5:V28,3)","v":43.9},{"$f":"VLOOKUP(MATCH(Tf_avg,$O$5:$O$28)+1,S5:V28,4)","v":49.7}]
["Wind Velocity",{"$f":"B11*0.44704","v":4.4703999999999997},"m/s",null,null,null,null,null,18,880,211.35,null,null,18,200,4.49,2.4,null,"Pr",{"$f":"(T19-U19)/(V19-U19)*(V22-U22)+U22","v":0.68462552151514522},{"$f":"VLOOKUP(Tf_avg,T5:W16,4)","v":0.68300000000000005},{"$f":"VLOOKUP(MATCH(Tf_avg,$T$5:$T$16)+1,S5:W16,5)","v":0.68500000000000005}]
[null,null,null,null,"Tf_film",{"$f":"(F20+B16)/2","v":445.97021321864304},"K",null,19,900,216.26,null,null,19,300,4.97,3.06]
["h1",{"$f":"h1e*2326","v":599831.98521000007},"J/kg",null,"Tf_filme",{"$f":"CONVERT(F23,\"K\",\"F\")","v":343.07638379355751},"°F",null,20,920,221.18,null,null,20,400,5.24,3.65,null,"Tf_avg",{"$f":"Tf_film","v":445.97021321864304},{"$f":"VLOOKUP(Tf_film,T5:T16,1)","v":400},{"$f":"VLOOKUP(MATCH(Tf_film,$T$5:$T$16)+1,$S$5:$T$16,2)","v":450}]
["h2",{"$f":"h2e*2326","v":594562.92662211263},"J/kg",null,null,null,null,null,21,940,226.11,null,null,21,500,5.8,4.51,null,"alpha",{"$f":"((T24-U24)/(V24-U24)*(V25-U25)+U25)*10^-6","v":4.6482697952918462E-5},{"$f":"VLOOKUP(Tf_film,T5:U16,2)","v":38.299999999999997},{"$f":"VLOOKUP(MATCH(Tf_film,$T$5:$T$16)+1,S5:U16,3)","v":47.2}]
["Qtrans",{"$f":"B21*(B24-B25)","v":322.65064429407693},"W",null,null,null,null,null,22,960,231.06,null,null,22,750,6.81,6.68,null,"K",{"$f":"((T24-U24)/(V24-U24)*(V26-U26)+U26)*10^-3","v":3.7017914925305005E-2},{"$f":"VLOOKUP(Tf_film,T5:V16,3)","v":33.799999999999997},{"$f":"VLOOKUP(MATCH(Tf_film,$T$5:$T$16)+1,S5:V16,4)","v":37.299999999999997}]
[null,null,null,null,null,null,null,null,23,980,236.02,null,null,23,1000,7.85,9.3000000000000007,null,"Pr",{"$f":"(T24-U24)/(V24-U24)*(V27-U27)+U27","v":0.68632238294250858},{"$f":"VLOOKUP(Tf_film,T5:W16,4)","v":0.69},{"$f":"VLOOKUP(MATCH(Tf_film,$T$5:$T$16)+1,S5:W16,5)","v":0.68600000000000005}]
["rho_avg",{"$f":"Pavg*Mu/(Tf_avg*Ru)","v":3.2540635638137876},"kg/m^3",null,null,null,null,null,24,1000,240.98,null,null,24,1500,9.5,15.1]
["Kair_i",{"$f":"rho_avg*AE17*T20","v":0.25596530950414359},"W/mK",null,null,null,null,null,25,1040,250.95]
["mu_i",{"$f":"O32*47.88026","v":2.9772199488217129E-5},"Ns/m^2",null,null,null,null,null,26,1080,260.97000000000003,null,null,null,"Value","Low","High"]
["Pr_i",{"$f":"T22","v":0.68462552151514522},null,null,null,null,null,null,27,1120,271.02999999999997,null,null,"Tf_avge",{"$f":"Tf_avge","v":603.47846818153243},{"$f":"VLOOKUP(Tf_avge,O5:O28,1)","v":500},{"$f":"VLOOKUP(MATCH(Tf_avge,$O$5:$O$28)+1,$N$5:$O$28,2)","v":750}]
["Re_Di",{"$f":"4*Mdot/(PI()*Di*mu_i)","v":256471.3971547058},null,null,null,null,null,null,28,1160,281.14,null,null,"mu",{"$f":"((O31-P31)/(Q31-P31)*(Q32-P32)+P32)*10^-7","v":6.2180530114533898E-7},{"$f":"VLOOKUP(Tf_avge,O5:P28,2)","v":5.8},{"$f":"VLOOKUP(MATCH(Tf_avge,$O$5:$O$28)+1,N5:P28,3)","v":6.81}]
["Nu_Di",{"$f":"0.023*Re_Di^0.8*Pr_i^0.3","v":436.10886168857223},null,null,null,null,null,null,29,1200,291.3,null,null,"nu",{"$f":"((O31-P31)/(Q31-P31)*(Q33-P33)+P33)*10^-4","v":5.4081931038157016E-4},{"$f":"VLOOKUP(Tf_avge,O5:Q28,3)","v":4.51},{"$f":"VLOOKUP(MATCH(Tf_avge,$O$5:$O$28)+1,N5:Q28,4)","v":6.68}]
["h_i",{"$f":"Nu_Di*Kair_i/Di","v":10932.418592041284},"W/(m^2K)"]
["TLM",{"$f":"(Tf_i-Tf_o)/LN((Ts_i-Tf_i)/(Ts_i-Tf_o))","v":2.0176163661356266},"K",null,null,null,null,null,null,"Value","Low","High",null,"Tf_filme",{"$f":"Tf_filme","v":343.07638379355751},{"$f":"VLOOKUP(Tf_filme,O5:O28,1)","v":300},{"$f":"VLOOKUP(MATCH(Tf_filme,$O$5:$O$28)+1,$N$5:$O$28,2)","v":400}]
["Qconv_i",{"$f":"h_i*PI()*Di*L*TLM","v":323.49733574542921},"W",null,null,null,null,null,"Tf_ie",{"$f":"Tf_ie","v":1067.67},{"$f":"VLOOKUP(Tf_ie,J5:J33,1)","v":1040},{"$f":"VLOOKUP(MATCH(Tf_ie,$J$5:$J$33)+1,$I$5:$J$33,2)","v":1080},null,"mu",{"$f":"((O35-P35)/(Q35-P35)*(Q36-P36)+P36)*10^-7","v":5.0863062362426054E-7},{"$f":"VLOOKUP(Tf_filme,O5:P28,2)","v":4.97},{"$f":"VLOOKUP(MATCH(Tf_filme,$O$5:$O$28)+1,N5:P28,3)","v":5.24}]
["Error_1",{"$f":"Qtrans-Qconv_i","v":-0.84669145135228518},"W",null,null,null,null,null,"h1",{"$f":"(J36-K36)/(L36-K36)*(L37-K37)+K37","v":257.88133500000004},{"$f":"VLOOKUP(Tf_ie,J5:K33,2)","v":250.95},{"$f":"VLOOKUP(MATCH(Tf_ie,$J$5:$J$33)+1,I5:K33,3)","v":260.97000000000003},null,"nu",{"$f":"((O35-P35)/(Q35-P35)*(Q37-P37)+P37)*10^-4","v":3.3141506643819891E-4},{"$f":"VLOOKUP(Tf_filme,O5:Q28,3)","v":3.06},{"$f":"VLOOKUP(MATCH(Tf_filme,$O$5:$O$28)+1,N5:Q28,4)","v":3.65}]
[]
["Kss",{"$f":"Z14","v":22.213601564228604},"W/mK",null,null,null,null,null,"Tf_oe",{"$f":"Tf_oe","v":1058.6269363630652},{"$f":"VLOOKUP(Tf_oe,J5:J33,1)","v":1040},{"$f":"VLOOKUP(MATCH(Tf_oe,$J$5:$J$33)+1,$I$5:$J$33,2)","v":1080}]
["Qcond",{"$f":"2*PI()*L*Kss*(Ts_i-Ts_o)/LN(Do/Di)","v":322.83996881195054},"W",null,null,null,null,null,"h2",{"$f":"(J39-K39)/(L39-K39)*(L40-K40)+K40","v":255.61604755894783},{"$f":"VLOOKUP(Tf_oe,J5:K33,2)","v":250.95},{"$f":"VLOOKUP(MATCH(Tf_oe,$J$5:$J$33)+1,I5:K33,3)","v":260.97000000000003}]
["Error_2",{"$f":"Qcond-Qconv_i","v":-0.65736693347867003},"W"]
[]
["Kair_o",{"$f":"T26","v":3.7017914925305005E-2},"W/mK"]
["v_air",{"$f":"O37*0.092903","v":3.078945391730799E-5},"m^2/s"]
["Pr_o",{"$f":"T27","v":0.68632238294250858}]
["Re_Do",{"$f":"Vel*Do/nu_o","v":1843.9456624492127}]
["Nu_Do",{"$f":"0.3+(0.62*Re_Do^0.5*Pr_o^(1/3))*(1+(Re_Do/282000)^(5/8))^0.8*(1+(0.4/Pr_o)^(2/3))^-0.25","v":21.580195687162437}]
["h_o",{"$f":"Nu_Do*Kair_o/Do","v":62.901877796756942}]
["Qconv_o",{"$f":"h_o*PI()*Do*L*(Ts_o-Tinf)","v":322.65064429407596},"W"]
["Error3",{"$f":"B26-B49","v":9.6633812063373625E-13}]